UBB.threads PHP Forum Software Community Forums Resources and Customizing How Do I? Good query for non-active subscribers?

What I'm doing at present is to use PhPMyADmin and browse ubbt_SUBSCRIPTION_DATA then sort on USER_ID, then I can scan down the list and see which user IDs have SUBSCRIPTION_IS_ACTIVE set to 0 only with no other lines that are set to 1. It works but is a PITA. Maybe have a second SUBSCRIPTION STATUS TABLE (in addition to the current SUBSCRIPTION_DATA table) that would only allow one entry per user and a current status / group. If that changes (e.g., subscription expires) then that field gets set 0 or 1. Just a thought.