[SOLVED] need SQL to put into the CB List so I can get accurate list of Active CBsubs users

For years I have tried using the cb_fields plugin to ensure that a user was set to Active= Yes when a user subscribed or renewed, but somehow this has become very innacurate.

I wish we had something in CB Lists where I could select "CB plans = Active" like in backend.

What can I put into the Advanced area of the CB Lists where I can get all Active CBsubs users into a CB List?

thanks

The below usage can be used to filter a userlist to only show active subscribers.

www.joomlapolis.com/forum/277-cbsubs-gpl-support/227615-user-lists-by-subscription#255712

tried this and getting a 1054 SQL error:

Unknown column 'sub.user_id' in 'where clause' SQL=SELECT COUNT( DISTINCT u.id ) FROM j17_users u JOIN j17_user_usergroup_map g ON g.`user_id` = u.`id` JOIN j17_comprofiler ue ON ue.`id` = u.`id` WHERE u.block = 0 AND ue.banned = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND g.group_id IN (6, 7, 2, 3, 4, 5) AND ( sub.`user_id` = u.`id` AND sub.`status` = 'A' )

any help?

same error with this

j17_cbsubs_subscriptions.`user_id` = u.`id` AND j17_cbsubs_subscriptions.`status` = 'A'

The exact usage is directly in the below post.

www.joomlapolis.com/forum/277-cbsubs-gpl-support/227615-user-lists-by-subscription#255712

You need to directly copy and paste that entire query string as your Advanced filter for your userlist. I'm not sure why you only took the WHERE statement from it.

yes, thanks, working