Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @row_number = 0;
- SELECT * FROM (
- SELECT (@row_number:=@row_number + 1) AS place,ct.* FROM (
- SELECT posts.`*`, COUNT(likes.postID) AS likes FROM posts
- LEFT JOIN likes ON likes.postID = posts.id
- WHERE posts.countryID = 1
- GROUP BY posts.id ORDER BY likes DESC
- LIMIT 2
- ) ct
- ) ct2
- WHERE ct2.id = 'hF8w+zkDkO6xb1xzfeIS';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement