Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT likes, topic, text, DATE, post_id, t.forum, p.name, p.username FROM
- (SELECT COUNT(pe.post) AS likes, topic, text, DATE, post_id, creator
- FROM Post AS p
- WHERE p.topic = 2
- JOIN Posts_liked AS pl
- ON post_id = pl.post
- ORDER BY p.DATE DESC
- LIMIT 1)AS x
- JOIN Topic AS t
- ON x.topic = t.topic_ID
- JOIN Person AS p
- ON x.creator = p.person_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement