00:00:00| 23:59:59|||| SELECT ID, FULL_NAME_TC, EVENT_START_DATE, EVENT_END_DATE ,LINK_TC, IMAGES_TC FROM EVENT_CALENDAR WHERE STATUS='A' AND (YEAR(EVENT_START_DATE) = YEAR(CURDATE()) AND MONTH(EVENT_START_DATE) = MONTH(CURDATE())) AND ID IN (SELECT EVENT_ID FROM EVENT_TYPE WHERE EVENT_TYPE_ID=(SELECT ID FROM EVENT_TYPE_MAP_TABLE WHERE TYPE_NAME_TC=?)) ORDER BY EVENT_START_DATE DESC, EVENT_END_DATE DESC