Limit number of records returned when certain criteria are met using mySQL

Hi All,

Hope all this makes sense...

On a site I'm developing, members with a membership_level of 1 through 6 can create an unlimited number of 'listing' records.

However, I’m trying to limit the number of records (created by any author with a membership_level of 2) that are shown on a list page, to only the first record where a status field == Available. (all records are sorted by an  'orderBy' => 'createdDate DESC', to show the newest records first)

In addition I need the list page to show all the available records for other levels of membership.

Here’s the ‘where’ I'm using on the list page to limit the overall records that are returned.

'where' => " createdByUserNum IN (SELECT num FROM cms_accounts WHERE (account_status LIKE '%1%' AND membership_level LIKE '%2%') )   AND  updatedDate > '$listing_age' AND `status` = 'Available' OR (createdByUserNum IN (SELECT num FROM cms_accounts WHERE (account_status LIKE '%1%' AND (membership_level LIKE '%1%'  OR membership_level LIKE '%3%' OR membership_level LIKE '%4%' OR membership_level LIKE '%5%' OR membership_level LIKE '%6%')) ) AND `status` = 'Available') ", 


I’d like to limit the number of records shown for membership_level 2 members in the ‘where’ as well, and tried adding LIMIT 1 to the where (below), but I couldn't get the syntax correct .

'where' => " createdByUserNum IN (SELECT num FROM cms_accounts LIMIT 1 WHERE (account_status LIKE '%1%' AND membership_level LIKE '%2%') )   AND  updatedDate > '$listing_age' AND `status` = 'Available' OR (createdByUserNum IN (SELECT num FROM cms_accounts WHERE (account_status LIKE '%1%' AND (membership_level LIKE '%1%'  OR membership_level LIKE '%3%' OR membership_level LIKE '%4%' OR membership_level LIKE '%5%' OR membership_level LIKE '%6%')) ) AND `status` = 'Available') ", 


Any ideas appreciated.

Thanks,

Jerry Kornbluth