Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(votes.id) as votes,servers.id,
- @curRow := @curRow + 1 AS row_number
- FROM servers LEFT JOIN votes ON votes.server_id=servers.id
- JOIN (SELECT @curRow := 0) r
- GROUP BY servers.id
- ORDER BY votes DESC
Advertisement
Add Comment
Please, Sign In to add comment
