Complex MySQL Query

jwalsh

Hi, This is a rather complex SQL, but I would think it's used commonly. Can someone help?

The script checks for submitted articles, and let's you approve, or trash articles depending on quailty.

The idea is that articles by someone who already has 10+ articles approved by us will be more likely to have better content, and should be checked for approval first. So I'm making a seperate section that shows all pending articles from members with 10+ approved articles.

I want to return a list of articles with a 'pending' status, where the member who wrote it has 10+ articles with an 'active' status.

Here's the structure of the article table...

ID = Primary Key
MemberID = ID of author in members table
Title = Article Title
Status = 'pending' or 'active'

and the members

ID = Primary Key

There are obviosly more fields, but they aren't important.

Thanks for your help,

Josh

leatherback

So, what is the question?

If you expect us to write the full program for you.. Naah, not gonna happen. Sorry, but we also do not get payed for helping..

So give it a try, and let us know where you get stuck.

Roger_Ramjet

Solutions to this are version specific, so while you are reading the manual pay attention to the version information, and know your own version before you start. A quick read of the select syntax, group syntax, and subqueries will show you how to do this: plenty of examples.

mysql manual