FrontController.php#1145seniorsbb_db_dev17.83msselectcount(*) as aggregate from `events` innerjoin `eventdetails` on `eventdetails`.`eventId` = `events`.`id` where `events`.`active` ='Yes'and `eventdetails`.`startDate` >='2025-07-05'and `eventdetails`.`endDate` <='2025-08-31'and (`events`.`editions` in (18) or `events`.`areaSpecific` ='NationWide') and `events`.`deleted_at` isnull
FrontController.php#1145seniorsbb_db_dev50.68msselect `events`.*, `eventdetails`.`id` as `eventdetailid`, `eventdetails`.`startDate` as `startingDate`, `eventdetails`.`startTime` as `startingTime`, `eventdetails`.`endDate` as `endDate`, `eventdetails`.`endTime` as `endTime`, `eventdetails`.`timeInstance` as `timeInstance` from `events` innerjoin `eventdetails` on `eventdetails`.`eventId` = `events`.`id` where `events`.`active` ='Yes'and `eventdetails`.`startDate` >='2025-07-05'and `eventdetails`.`endDate` <='2025-08-31'and (`events`.`editions` in (18) or `events`.`areaSpecific` ='NationWide') and `events`.`deleted_at` isnullorderby `eventdetails`.`startDate` asc, `eventdetails`.`startTime` asc limit 24offset0