Please Log in to join the conversation.
SELECT a.`id` AS ID
, a.`name` AS Name
, a.`username` AS Username
, a.`email` AS Email
, c.`plan_id` AS Subscription
, d.`name` AS Plan
, c.`subscription_date` AS Subscribed
, c.`last_renewed_date` AS Renewed
, c.`expiry_date` AS Expires
FROM `jos_users` AS a
INNER JOIN `jos_comprofiler` AS b
ON b.`user_id` = a.`id`
INNER JOIN `jos_cbsubs_subscriptions` AS c
ON c.`user_id` = b.`user_id`
INNER JOIN `jos_cbsubs_plans` AS d
ON d.`id` = c.`plan_id`
WHERE a.`block` = 0
AND b.`confirmed` = 1
AND b.`approved` = 1
AND b.`banned` = 0
AND c.`status` = 'A'
Please Log in to join the conversation.
krileon wrote: Unfortunately, no; CBSubs and CB it self have no export tool. This is absolutely something we'd like to add in the future.
Please Log in to join the conversation.
Please Log in to join the conversation.