Please Log in to join the conversation.
( SELECT sub.`expiry_date` FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND `expiry_date` < NOW() AND sub.`status` = 'X' ) DESC
if last sub.`id` for any sub.`user_id` is not like sub.`status` = 'A'
Please Log in to join the conversation.
Please Log in to join the conversation.
krileon wrote: You need to add an Advanced Filter if you want just expired subscribers as it adds directly to the WHERE statement. See the below for examples.
www.joomlapolis.com/forum/153-professional-member-support/237148-solved-how-to-create-a-list-showing-active-members-only#296273
( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` = 'X' ) >= 1 )
Please Log in to join the conversation.
( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` = 'A' ) = 0 )
Please Log in to join the conversation.
( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id`
AND sub.`status` = 'A' AND sub.`plan_id` IN (6,39,40,41,51,45,31,42,43,44,52)) = 0 )
Please Log in to join the conversation.