brigadiar 4 Posted May 23, 2018 Share Posted May 23, 2018 Hi there, want to tell you about how to sort users with Paid Plans in AcyMailing 1. Download AcyMailing filter plugin 2. Create Smart-NewsLetter , choose Advanced Query , paste this code if you sort by: email SELECT User.email AS `email` FROM #__content AS Listing LEFT JOIN #__users AS User ON User.id = Listing.created_by WHERE (Listing.id IN (SELECT DISTINCT listing_id FROM #__jreviews_paid_orders WHERE order_active = 1 and plan_id IN (4,5,6))) 4,5,6 - it's your paidListing ID's or UserName SELECT User.name AS `name` FROM #__content AS Listing LEFT JOIN #__users AS User ON User.id = Listing.created_by WHERE (Listing.id IN (SELECT DISTINCT listing_id FROM #__jreviews_paid_orders WHERE order_active = 1 and plan_id IN (4,5,6))) 3. If you want to exclude these users from the rest of the mailing list you need: - create Mass action filter - paste code above - unsubscribe this users from "Global list" or sign to another list. - click Save 4. If you want to exclude these users automatically you need to set up CRON read this share your experience here 8) n00bster and Ant 1 1 Link to post
JAN44 4 Posted June 4, 2018 Share Posted June 4, 2018 This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to post
IvorJ 6 Posted June 4, 2018 Share Posted June 4, 2018 This section is only visible with a valid subscription. If you have a valid subscription, please login. JAN44 and Ant 2 Link to post
Jreviews Addict 26 Posted February 5, 2019 Share Posted February 5, 2019 This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to post
Ant 14 Posted February 6, 2019 Share Posted February 6, 2019 This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to post
Jreviews Addict 26 Posted February 6, 2019 Share Posted February 6, 2019 This section is only visible with a valid subscription. If you have a valid subscription, please login. n00bster 1 Link to post
JAN44 4 Posted February 7, 2019 Share Posted February 7, 2019 This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to post
Alejandro 877 Posted February 7, 2019 Share Posted February 7, 2019 This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to post
Jreviews Addict 26 Posted February 8, 2019 Share Posted February 8, 2019 This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to post
Recommended Posts