SELECT category_image, event_date, event_time, event_time_end, event_title
FROM e_events LEFT JOIN e_categories ON
e_events.category_id = e_categories.category_id WHERE (e_events.id_colegio = '1003' AND e_events.event_is_public = 1 OR (e_events.id_colegio = '1003' AND e_events.event_is_public=0 AND e_events.user_id=0)) AND event_date >= '2019-09-29 00:00:00' AND event_date <= '2019-11-02 23:59:59' : SELECT category_image, event_date, event_time, event_time_end, event_title
FROM e_events LEFT JOIN e_categories ON
e_events.category_id = e_categories.category_id WHERE (e_events.id_colegio = '1003' AND e_events.event_is_public = 1 OR (e_events.id_colegio = '1003' AND e_events.event_is_public=0 AND e_events.user_id=0)) AND event_date >= '2019-09-29 00:00:00' AND event_date <= '2019-11-02 23:59:59' SELECT event_title, event_time, event_id, e_categories_langs.category_name AS category_name, category_image, event_time_end
FROM (e_categories RIGHT JOIN e_events ON
e_events.category_id = e_categories.category_id) LEFT JOIN e_categories_langs ON
e_categories.category_id = e_categories_langs.category_id WHERE e_events.event_date = '2019-10-02 00:00:00' AND (e_categories_langs.language_id = 'en' OR e_events.category_id IS NULL) AND (e_events.id_colegio = '1003' AND e_events.event_is_public = 1 OR (e_events.id_colegio = '1003' AND e_events.event_is_public=0 AND e_events.user_id=0)) ORDER BY e_events.event_time, event_date LIMIT 0,100
|
|