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 …')

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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)