top

DATES TO BE ANNOUNCED

SELECT distinct eid, cname, cdate, ccity, cstate, venue_search, SaleInternet, feature_url, festival, enddate, DATE_FORMAT(ctime,'%l:%i%p'), notime, FEATURE, salestatus, artist_search, ccountry FROM event e where ( ((e.cpromo=33053 ) OR (e.cpromo_sales = 33053 )) AND (salestatus<8) AND (1=1) AND (CHEid<1) AND hide_from_search!=1) order by cdate, cstate, ccity