Best rated ordering does not favour number of votes for same-rated items (most voted should appear first)

Hello!

Error after update

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JOIN#__content_rating AS cr ON cr.content_id = i.id LEFT JOIN ( ' at line 1

I restored backup for com_flexicontent and now other error

Call to undefined method flexicontent_db::buildRatingOrderingColumn()

Then I restored DB - but error still displayed.

Ok, I restored FC modules from backup - and now site online.

So, issue in modules.

Hello

it looks like not all files were updated

You can send me access to the backend via a PM
and i will look at it now

Hello
I updated my post above.
Sent access details in PM, but you already have it.

Hello

I had tested category view and items manager with best rated ordering (in items manager sort by "rating" column),
but had not tested universal module,

Fixed the issue with SQL query in module
and updated the website with new version
you can test now

Tested in modules, preordered category and search view.
Ok, looks much better, but not ideal.
Explain.
We have very much items with 5 star rating and only 1 vote.
And they displays in alphabet order.
May be we need to add parameter to exclude elements in which less than 3 votes?

In search view (with and without text search field active) - no any results.
In category filters (with and without text search field active) - works fine.