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 >= '2018-09-30 00:00:00' AND event_date <= '2018-11-03 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 >= '2018-09-30 00:00:00' AND event_date <= '2018-11-03 23:59:59'
|
|