How to change ordering after featured listings

When you set the default ordering for list pages to Featured in global configuration, the rest of the listings below featured will be ordered by submission date.

If you want to change that, edit this file:

• /com_jreviews/jreviews/models/everywhere/everywhere_com_content.php

Be advised that a lot of effort has been put into optimizing the queries in database table indexes for faster performance. If you mix two columns from different database tables, the query can no longer be optimized because a index cannot be used.

Find the code for featured ordering:

case 'featured':
 
   // ... some other lines in between ...
 
   $order = 'Field.featured DESC, Field.contentid DESC';

And change it to one of the below, depending which ordering after featured listings you want:

Ordering by title

    $order = 'Field.featured DESC, Listing.title ASC';

Ordering by most viewed listings

    $order = 'Field.featured DESC, Listing.hits DESC';

Ordering by highest user rating

    $order = 'Field.featured DESC, Totals.user_rating DESC, Totals.user_rating_count DESC';

Ordering by highest editor rating

    $order = 'Field.featured DESC, Totals.editor_rating DESC, Totals.editor_rating_count DESC';

Ordering by number of reviews

    $order = 'Field.featured DESC, Totals.user_comment_count DESC';