Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MySQL Join Examining Every Row
- SELECT *
- FROM comments AS c
- INNER JOIN articles AS a ON c.article_id = a.article_id
- INNER JOIN user_profiles AS p ON c.user_id = p.user_id
- INNER JOIN blog_users AS b ON c.user_id = b.user_id
- INNER JOIN forum_users AS f ON b.username = f.username
- WHERE a.article_id = :article_id
- ORDER BY c.comment_id DESC
- LIMIT 0 , 30
- WHERE c.Article_ID = :article_ID
Add Comment
Please, Sign In to add comment