|
Hottest Cyphers
Error SQL: select count(votedUserID) as totalVotes, vb_cypher.id AS battleID, vb_cypher.description, vb_cypher.length, vb_cypher.beatID, vb_cypher.pID,
sum(rating) as totalRating,
sum(rating)/count(votedUserID) as avgRating
FROM vb_cypher_votes
INNER JOIN vb_cypher ON vb_cypher_votes.battleID=vb_cypher.id
WHERE rating>0
AND vb_cypher.status=2
AND vb_cypher.max_allowed>1
AND vb_cypher.date_ended > '2024-10-06 00:00:00'
GROUP BY battleID
HAVING totalVotes>1
ORDER BY avgRating DESC
LIMIT 10
No hot cyphers this week. |
|
|