SELECT p.cID, event.eID as eID, event.sttime as eventstart, event.entime as eventend, event.grouped as grouped, event.date as eventdate FROM Pages p LEFT JOIN btProEventDates event ON p.cID = event.eventID LEFT JOIN PagePaths pp ON (p.cID = pp.cID and pp.ppIsCanonical = true) LEFT JOIN PageSearchIndex psi ON p.cID = psi.cID LEFT JOIN PageTypes pt ON p.ptID = pt.ptID INNER JOIN Collections c ON p.cID = c.cID INNER JOIN CollectionVersions cv ON p.cID = cv.cID LEFT JOIN CollectionSearchIndexAttributes csi ON c.cID = csi.cID WHERE (((event.date = '2018-11-19' AND event.sttime > '19:13:40') OR event.date > '2018-11-19')) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cvIsApproved = 1) AND (p.cIsActive = :cIsActive) AND (p.cIsSystemPage = :cIsSystemPage) GROUP BY event.grouped, event.eventID ORDER BY event.date,event.sttime ASC LIMIT 5 OFFSET 0 array(2) { ["cIsActive"]=> bool(true) ["cIsSystemPage"]=> bool(false) }