The above is just filtering them. To sort them by subscription date you'd need to set Sorting to Advanced then use the following.
Active Any
Code:
( SELECT sub.`subscription_date` FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` = 'A' ) DESC
Active Specific Plan
Code:
( SELECT sub.`subscription_date` FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` = 'A' AND sub.`plan_id` = PLAN_ID_HERE ) DESC
Both the above are descending. Change DESC to ASEC to sort ascending. They're sorting by subscription date, but you could sort by expiration, renewal date, etc.. As with the filtering you can change what status to sort by. So from A to X would sort by expired.
It seems very hard to just get a usable list of subs with name, email and sub type for a non-technical client to read and understand.
Is CB > User Management not sufficient for this? It has a Subscriptions column to show what subscriptions they have. This column can also be sorted (sort dropdown or by clicking its column title) and filtered (under Search Tools) on in CB > User Management. There's also CBSubs > Subscriptions page. What I've would recommend for non-technical users is use Joomla's built in Tour Guides feature. This lets you make guides to using backend that will walk them through things so they can understand how to use them.
krileon
