Advertisement
Guest User

Queries

a guest
Oct 2nd, 2013
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.83 KB | None | 0 0
  1. #FIRST QUERY
  2.  
  3. SELECT event.* ,
  4. count( user_registration.user_registration_id ) AS user_registration_count
  5.  
  6. FROM `event`
  7.  
  8. LEFT JOIN registration_item ON
  9. registration_item.event_id = event.event_id
  10.  
  11. LEFT JOIN user_registration ON
  12. user_registration.registration_item_id = registration_item.registration_item_id
  13.  
  14. WHERE 1 = 1 AND event.event_id = '5240e695-9acc-4e32-9b98-1aecb3d0838' GROUP BY event.event_id;
  15.  
  16. #SECOND QUERY
  17.  
  18. SELECT event.* ,
  19. count( user_registration.user_registration_id ) AS user_registration_count
  20.  
  21. FROM `event`
  22.  
  23. LEFT JOIN registration_item ON
  24. registration_item.event_id = event.event_id
  25.  
  26. LEFT JOIN user_registration ON
  27. user_registration.registration_item_id = registration_item.registration_item_id
  28.  
  29. WHERE 1 = 1 AND event.event_id = '5240e695-9acc-4e32-9b98-1aecb3d0838' GROUP BY event.event_id LIMIT 50;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement