Please see this:
WARNING  Error while executing query: select event_type, EventId, VenueId, Price, Schedule, ev.startDate, ev.endDate, events.name eventname, movies.name moviename from `eventvenue` ev, `events` left join (movies) on (movies.ID = ev.EventId) where events.ID = ev.EventId and VenueId = '493' and ((ev.startDate >= '2010-04-25' or ev.endDate >= '2010-04-25') or event_type = 'movies') order by moviename asc, ev.startDate asc 1054:Unknown column 'ev.EventId' in 'on clause'
This query was working fine in mysql 4.1, but not in mysql 5.1. Can anyone please give me any pointers? Thank you for your time!