Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT a.id, a.title
- FROM article a
- JOIN (SELECT ac.article_id FROM article_category ac WHERE ac.category_id = '32') t1 ON t1.article_id = a.id
- JOIN (SELECT ac.article_id FROM article_category ac WHERE ac.category_id = '34') t2 ON t2.article_id = a.id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement