#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;