spletcher wrote: I am trying to make a frontend user list showing the active subscriptions by subscription date.

I am making a list of active members for a certain plan using this query:

( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`plan_id` = 1 AND sub.`status` = 'A' ) )

However, it appears that there is no way to show a field in my userlist from the CB Subscriptions table such as `subscription_date` or `last_renewed_date` from this table.

The only thing I can see in the user list is the CB fields that are defined. Does Joomlapolis have any suggested plugin to do this or do I need to look elsewhere in the JED for something to do queries on database tables and write the queries?

Thanks,

Stan