Guest User

Untitled

a guest
Jul 16th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. var_storage:
  2. id | var_name | var_value | user
  3.  
  4.  
  5. post:
  6. id | user
  7.  
  8. post_var_storage:
  9. post_id | var_storage_id
  10.  
  11. SELECT * FROM
  12. post p
  13. WHERE
  14.  
  15. # MEAL=DINNER
  16. EXISTS (
  17. SELECT * FROM (
  18. SELECT *
  19. FROM post p2
  20. INNER JOIN post_var_storage pvs ON pvs.post_id = p2.id
  21. INNER JOIN vars_storage vs ON pvs.var_storage_id = vs.id
  22. WHERE p2.id = p.id
  23. ) vs
  24. WHERE
  25. vs.var_name = "MEAL" AND vs.value = "DINNER"
  26. ) AND
  27.  
  28. # FOOD=FRIES
  29. EXISTS (
  30. SELECT * FROM (
  31. SELECT *
  32. FROM post p2
  33. INNER JOIN post_var_storage pvs ON pvs.post_id = p2.id
  34. INNER JOIN vars_storage vs ON pvs.var_storage_id = vs.id
  35. WHERE p2.id = p.id
  36. ) vs
  37. WHERE
  38. vs.var_name = "FOOD" AND vs.value = "FRIED"
  39. ) AND
  40.  
  41. ....
Add Comment
Please, Sign In to add comment