SQL query to pull out non-paying subscribers

[kh99]

I don't have subscriptions set up so I can't test this, but I think you should be able to add this to the end of the query you posted above:

WHERE user.usergroupid = P AND subscriptionlog.expirydate < UNIX_TIMESTAMP()

Where you'd replace the P with the usergroupid of the Premium group. You might also want to add "AND subscriptionlog.subscriptionid = S" if it's possible for users to have more than one subscription (to make sure you're matching the subscriptionid S of the Premium subscription).

I have to admit that I don't understand a lot about paid subscriptions. Do the records get removed from the subscription log when the subscription is done? If so, you might want to change your query to "...FROM user LEFT JOIN subscriptionlog", that way you'll find users even if they have no record in the subscriptionlog (and I think it still would work since in that case expirydate should be NULL).