MrOnline
04-20-2006, 07:08 PM
guess this is a noob question but here it goes...
I need to find users who are member of group 9, but doesnt have an active subscriptions...
i've played alittle with it and figured out that i need to check if they are in usergroup, but not sure how i can make it so they are NOT part of "subscriptionlog.status=1"..
and do i need to use subscriptionlog.subscriptionid, or can i just use subscriptionid ??, or can i use only "subscriptionlog.status=1" and that will go over all subscriptionsid's ??
to make this clear.. what i want is to find any users in usergroup 9 that doesn not have an active subscription...
I need to find users who are member of group 9, but doesnt have an active subscriptions...
i've played alittle with it and figured out that i need to check if they are in usergroup, but not sure how i can make it so they are NOT part of "subscriptionlog.status=1"..
and do i need to use subscriptionlog.subscriptionid, or can i just use subscriptionid ??, or can i use only "subscriptionlog.status=1" and that will go over all subscriptionsid's ??
to make this clear.. what i want is to find any users in usergroup 9 that doesn not have an active subscription...