SELECT
							event_main.ID,
							event_main.title,
							(SELECT event_category.name FROM salihin_cms.event_category WHERE event_main.category = event_category.ID) category,
							event_main.createdBy creator,
							event_main.status,
							event_main.venue,
							DATE_FORMAT(event_main.startDT, '%Y-%m-%d') startDate,
							DATE_FORMAT(event_main.endDT, '%Y-%m-%d') endDate,
							TIME_FORMAT(event_main.startDT, '%H:%i:%s') startTime,
							TIME_FORMAT(event_main.endDT, '%H:%i:%s') endTime
						FROM salihin_cms.event_main
						WHERE 1 = 1  AND event_main.status IN ('DRAFT', 'PUBLISHED')  ORDER BY title ASC