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

one more question on this - the advanced filter should include the entire query with the SELECT included or just the WHERE clause? I'm guessing the entire query from SELECT to the end, thanks

ThePiston wrote: one more question on this - the advanced filter should include the entire query with the SELECT included or just the WHERE clause? I'm guessing the entire query from SELECT to the end, thanks

Yes, as already replied by Kyle above.

krileon wrote: 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.

I did that because in the popup instructions for the Filter field, you specifically say to only include the WHERE clause:

The query I provided is an advanced usage called a subquery. The tooltip is not telling you to only include the WHERE of a subquery or anything like that. It's telling you that anything you put there will be added as WHERE to the query.

ok, got it now, thanks

Awesome! Marked as solved.