My list of top ratings doesnt appear anymore

Hi,

As the title said, I am having a big problem with my list of top ratings. Everything was working fine for a long time, it was perfect and customisable so I made exactly something I wanted to do.

But this weekend, pof! I dont know exactly what happened, I don’t touch anything, no particular plugin update, ratings are still working BUT now my list of top ratings show nothing.

This is what I get when I use debug mode :

WordPress database error: [Subquery returns more than 1 row]
SELECT *, (votes / (votes + 1)) * rating + (1 / (votes + 1)) * 3.71567672833 AS bayesian_rating FROM ag2013_posts LEFT JOIN( SELECT DISTINCT post_id, (SELECT CAST(meta_value AS DECIMAL(10)) FROM ag2013_postmeta WHERE ag2013_postmeta.post_id = meta.post_id AND meta_key ='votes') AS votes, (SELECT CAST(meta_value AS DECIMAL(10,2)) FROM ag2013_postmeta WHERE ag2013_postmeta.post_id = meta.post_id AND meta_key ='rating') AS rating FROM ag2013_postmeta meta ) AS newmeta ON ag2013_posts.ID = newmeta.post_id WHERE post_status =

And here is the end of my small knowledge. Seems something is wrong in the database, and I dont know what is this “extra row”, I dont understand at all ?? .

Where to check to fix this ? I dont want to destroy everything in my database, for now…

Please help me ??

https://www.ads-software.com/plugins/post-ratings/