Movies at Gorey
Raheenagurren East, Courtown Road  0539489570


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REEL'') having scheduleDate between '2015-07-29' and '2015-11-06' order by FilmT' at line 13 SQL=select p.*, IF (performanceTime >= '2015-07-29 16:57:55', 0, 1) AS expired, e.*, coalesce(ov.omitrating, 0) as omitrating, ov.featuretype, ov.fls, ec.eventclassname, coalesce(ov.MaxTickets, 0) as MaxTickets, coalesce(ov.neverApplyBookingFee, 0) as neverApplyBookingFee, if (unix_timestamp(performanceTime) - unix_timestamp(date(performanceTime)) < 3600, date_sub(date(performancetime), interval 1 day), scheduledate) as perfDate from sup_performance P join sup_event E on E.EventCode = P.EventCode left outer join sup_eventoverride ov on ov.sitecode = 'M-GOREY' and ov.eventcode = e.eventcode left outer join sup_eventclass ec on = e.eventclass where P.siteCode = 'M-GOREY' and ScheduleDate >= '2015-07-29' and ScheduleDate <= date_add('2015-11-06', interval 1 day) and OffSale = 0 and performanceTime > '2015-07-29 16:57:55' and p.pricecard in (''REEL'') having scheduleDate between '2015-07-29' and '2015-11-06' order by FilmTitle, ScheduleDate, PerformanceTime