I have four levels of paid subscriptions set up: Bronze, Silver, Gold and, Platinum. When someone subscribes to a level (for example, Bronze), I go in and manually set their "Member Custom Title" to read "Bronze Member". Etc. I also go to Database tools and run a query like:
UPDATE ubbt_USER_PROFILE
SET USER_GROUP_IMAGES = 'a:1:{i:1;s:1:"9";}'
WHERE USER_ID = '2919'Which sets a little star of appropriate color next to their names.
The problem is, when a subscription expires, those don't automatically get reset - I have to do it manually. But very often someone's subscription will expire, but then they turn around and re-subscribe. The problem is, when I do a query in the Subsciption section and ask to look at all members where "Active=NO" I get pages of members, but many of those same members will also come up if i filter Active = Yes.
What would be a good query to run to see ONLY those members who are not active (and not also see those who went inactive and then re-subscribed). In plain English, I want to see members where Active = No but exclude those where They also have Active = YES for another subscription. (Those who are truly inactive, so I can reset their member status).
