noob question

[MrOnline]

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...