JReviews PaidListing and AcyMailing

May 23, 2018

Hi there, want to tell you about how to sort users with Paid Plans in AcyMailing

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)

June 4, 2018