Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. SET @row_number = 0;
  2. SELECT * FROM (
  3. SELECT (@row_number:=@row_number + 1) AS place,ct.* FROM (
  4. SELECT posts.`*`, COUNT(likes.postID) AS likes FROM posts
  5. LEFT JOIN likes ON likes.postID = posts.id
  6. WHERE posts.countryID = 1
  7. GROUP BY posts.id ORDER BY likes DESC
  8. LIMIT 2
  9. ) ct
  10. ) ct2
  11. WHERE ct2.id = 'hF8w+zkDkO6xb1xzfeIS';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement