How to display only listings without reviews in the Listings Module
From JReviews Documentation
Revision as of 19:47, 6 January 2010 by Jreviews (Talk | contribs) (Created page with 'This is useful if you want to show users which listings don't have any reviews yet. Edit the mod_jreviews_listings module in the Module Manager, and enter this as the '''Custom …')
This is useful if you want to show users which listings don't have any reviews yet.
Edit the mod_jreviews_listings module in the Module Manager, and enter this as the Custom WHERE parameter:
(Totals.user_rating_count = 0 OR Totals.user_rating_count IS NULL)