Guest User

Untitled

a guest
Jun 21st, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. SELECT * FROM tbl_news WHERE news_id
  2. IN (select news_id from
  3. tbl_tag_relations WHERE tag_id = 20)
  4.  
  5. SELECT * FROM tbl_news WHERE news_id
  6. IN (select news_id from
  7. tbl_tag_relations WHERE tag_id = 20)
  8.  
  9. SELECT * FROM tbl_news WHERE news_id
  10. IN (select news_id from
  11. tbl_tag_relations WHERE tag_id = 20)
  12.  
  13. SELECT tn.*
  14. FROM tbl_news tn
  15. JOIN tbl_tag_relations ttr ON ttr.news_id = tn.news_id
  16. WHERE ttr.tag_id = 20
  17.  
  18. SELECT *
  19. FROM tbl_news, tbl_tag_relations
  20. WHERE tbl_tag_relations.tag_id = 20 AND
  21. tbl_news.news_id = tbl_tag_relations.news_id
  22.  
  23. SELECT news_title, news_body
  24. ...
  25. LIMIT 5;
  26.  
  27. select *
  28. from tbl_news, tbl_tag_relations
  29. where
  30. tbl_tag_relations.tag_id = 20 and
  31. tbl_news.news_id = tbl_tag_relations.news_id
  32. limit 20
  33.  
  34. SELECT news_id, name, blah
  35. FROM tbl_news n
  36. JOIN tbl_tag_relations r ON r.news_id = n.news_id
  37. WHERE r.tag_id IN (20,21,22)
Add Comment
Please, Sign In to add comment