Paid subscriptions & usergroups (mysql query question)
 

I need to create a query to find users who belong to a particular secondary usergroup, but who do not currently have (or possibly never had) a certain paid subscription.

PHP Code:
SELECT user.userid, user.username FROM user, subscriptionlog WHERE user.userid = subscriptionlog.userid AND subscriptionlog.status !=1 AND ( FIND_IN_SET( "18", user.membergroupids ) ) ;

Finds me those who have an expired paid subscription (regardless of whether or not there's a current subscription). Which is okay... but it won't find those people that don't have an entry in the subscription table at all.

Any ideas? TIA