SELECT PK_ID, eventTitle, eventCity, date_format(eventDate, '%b %e %Y') as eventDate  FROM events WHERE '2010-7-30' >= eventDate and '2010-7-30' <= eventEnd and eventStatus = 1 order by PK_ID asc