Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #FIRST QUERY
- SELECT event.* ,
- count( user_registration.user_registration_id ) AS user_registration_count
- FROM `event`
- LEFT JOIN registration_item ON
- registration_item.event_id = event.event_id
- LEFT JOIN user_registration ON
- user_registration.registration_item_id = registration_item.registration_item_id
- WHERE 1 = 1 AND event.event_id = '5240e695-9acc-4e32-9b98-1aecb3d0838' GROUP BY event.event_id;
- #SECOND QUERY
- SELECT event.* ,
- count( user_registration.user_registration_id ) AS user_registration_count
- FROM `event`
- LEFT JOIN registration_item ON
- registration_item.event_id = event.event_id
- LEFT JOIN user_registration ON
- user_registration.registration_item_id = registration_item.registration_item_id
- 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