select EVENT.SPONSORED, EVENT.pkEVENT_ID, EVENT.fkMEMBER_ID, EVENT.NAME, EVENT.DETAIL, EVENT.SAVE_DATE_DETAIL, EVENT.LOCATION, EVENT.ADDRESS, 
    EVENT.ADDRESS2, EVENT.CITY, EVENT.STATE_CODE, EVENT.PROVINCE_CODE, EVENT.TERRITORY, EVENT.ZIP, EVENT.COUNTRY_CODE, EVENT.ORGANIZER, EVENT.VENDOR_ACCESS, 
    EVENT.VENDOR_DETAIL, EVENT.START_DATE, EVENT.END_DATE, EVENT.ON_DEMAND, EVENT.SAVE_THE_DATE, EVENT.CANCELLED, EVENT.CFP_DEADLINE, EVENT.PREMIUM
    FROM EVENT
     where SPONSORED = 1 AND DELETED = 0 and OFFLINE = 0 and MATCH(EVENT.ORGANIZER, EVENT.SECOND_ORGANIZER)
                     AGAINST ('Clear Government Solutions| Inc. (CGS)' IN BOOLEAN MODE) and END_DATE >= (NOW() - INTERVAL 1 DAY) and ON_DEMAND = 0  order by SPONSORED DESC,ON_DEMAND ASC,START_DATE ASC,END_DATE  ASC