CB List

have a list where I'd like to see all Active subscribers..

I have two plans if someone is a part of them then want to list them in the list as active members.

Trick is the only field that would work is under
Community Builder > user management
and the heading isn't an option via sql - not sure where it is.

If equals Plan 1 or 2 the show in list
if anything else then don't show.

so based on that I'm not finding which table has the plan ID...
it wasn't showing in comprofiler table...
which table would I use for that query/ statement?

I assume by plans you mean from CBSubs. You can use Advanced filters to filter the users down to active subscribers. Examples as follows.

www.joomlapolis.com/forum/153-professional-member-support/237148-solved-how-to-create-a-list-showing-active-members-only#296273

Adjust the example queries as needed if you need the filtering to be plan specific.

Pretty close
However i only want to show where plan is 1 or 2 vs any active plans.

reason is, there are sponsor / reciprocal plans that don't need to be listed
but now that I'm seeing the layout I might be able to make it work -

#__cbsubs_subscriptions - looking in here - but not sure if I need the count if ... most likely I will..

..plan_id should cover what I'm after but also status has to = A
which makes sense now looking at the table.

However i only want to show where plan is 1 or 2 vs any active plans.

You'll need to modify the query then and extend it with plan_id check in its WHERE statement. Should be all you'll need to change in the query.

trying but haven't messed with this in awhile..

doesn't work however this does - only

but doesn't include plan ID 2 members - which I'm missing the way to do it..

was looking at this:
type of sql line

like this:
Think this is working...

does it look accurate to you?

Your final query should work fine.