How to filter Listings and Geomaps modules to entries with specific plans

It is possible to filter the output of the modules and even the JReviews Custom List menu by adding a CUSTOM WHERE statement that looks like this:

(Listing.id IN (SELECT DISTINCT listing_id FROM #__jreviews_paid_orders WHERE order_active = 1 AND plan_id = 5))

If you want to match multiple plans the statement can be written like this:

(Listing.id IN (SELECT DISTINCT listing_id FROM #__jreviews_paid_orders WHERE order_active = 1 AND plan_id IN (4,5,6)))

Make sure you change the plan_id(s) to match the ids of your paid plans.