Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
SELECT c.`id` AS 'User ID'
, c.`firstname` AS 'First Name'
, c.`lastname` AS 'Last Name'
, u.`email` AS 'Email'
, p.`name` AS 'Subscription'
, s.`subscription_date` AS 'Start Date'
, s.`expiry_date` AS 'End Date'
FROM `jos_cbsubs_subscriptions` AS s
LEFT JOIN `jos_cbsubs_plans` AS p
ON s.`plan_id` = p.`id`
INNER JOIN `jos_comprofiler` AS c
ON s.`user_id` = c.`id`
INNER JOIN `jos_users` AS u
ON c.`id` = u.`id`
WHERE s.`status` = 'A'
Please Log in to join the conversation.