Custom Order

Custom Order lets you modify the sorting of results in custom lists used for landing pages, modules, widgets and shortcodes.

The custom order setting diretly changes the database query's ORDER BY statement.

JReviews already comes with plenty of sorting options, but if you insist on being creative, you can do that too.

Order by highest price ascending

Field.jr_price ASC

Order by highest price descending

Field.jr_price DESC

Order by featured status, then alphabetically

Joomla

Field.featured DESC, Listing.title

WordPress

Field.featured DESC, Listing.post_title

Order by number of photos

Totals.photo_count DESC