Advertisement
Guest User

Untitled

a guest
Apr 28th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.36 KB | None | 0 0
  1. SELECT likes, topic, text, DATE, post_id, t.forum, p.name, p.username FROM
  2.  
  3. (SELECT COUNT(pe.post) AS likes, topic, text, DATE, post_id, creator
  4. FROM Post AS p
  5. WHERE p.topic = 2
  6.  
  7. JOIN Posts_liked AS pl
  8. ON post_id = pl.post
  9.  
  10. ORDER BY p.DATE DESC
  11. LIMIT 1)AS x
  12.  
  13. JOIN Topic AS t
  14. ON x.topic = t.topic_ID
  15.  
  16. JOIN Person AS p
  17. ON x.creator = p.person_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement