select `blcms_T`.`id` as `id`, `blcms_T`.`tenderName` as `tenderName`, `blcms_T`.`tenderRefNo` as `tenderRefNo`, `blcms_W`.`title` as `sbu`, `blcms_A`.`title` as `area`, `blcms_D`.`TenderDueDate` as `TenderDueDate`, `blcms_D`.`TenderOpeningDate` as `TenderOpeningDate`, `blcms_T`.`tenderSbu` as `sbuid`, MAX(blcms_C.TenderDueDate) as lastdate, MAX(blcms_C.TenderOpeningDate) as lastOpndate from `blcms_tenders` as `blcms_T` leftjoin `blcms_websites` as `blcms_W` on `blcms_T`.`tenderSbu` = `blcms_W`.`id` leftjoin `blcms_tenderareas` as `blcms_A` on `blcms_T`.`tenderArea` = `blcms_A`.`id` leftjoin `blcms_corrigendums` as `blcms_C` on `blcms_T`.`id` = `blcms_C`.`tenderId` leftjoin `blcms_tender_dates` as `blcms_D` on `blcms_T`.`id` = `blcms_D`.`tenderId` where `blcms_T`.`tenderStatus` ='1'and (`blcms_D`.`PublishDate` <='2025-07-29'and `blcms_C`.`tenderId` isnotnulland `blcms_D`.`TenderDueDate` >='2025-07-29'or `blcms_C`.`TenderDueDate` >='2025-07-29') groupby `blcms_T`.`id` orderby `id` desc55.66ms/app/Http/Controllers/TenderSearchController.php:337bl_with_sbu
select `blcms_T`.`id` as `id`, `blcms_T`.`tenderName` as `tenderName`, `blcms_T`.`tenderRefNo` as `tenderRefNo`, `blcms_W`.`title` as `sbu`, `blcms_A`.`title` as `area`, `blcms_D`.`TenderDueDate` as `TenderDueDate`, `blcms_D`.`TenderOpeningDate` as `TenderOpeningDate`, `blcms_T`.`tenderSbu` as `sbuid`, MAX(blcms_C.TenderDueDate) as lastdate, MAX(blcms_C.TenderOpeningDate) as lastOpndate from `blcms_tenders` as `blcms_T` leftjoin `blcms_websites` as `blcms_W` on `blcms_T`.`tenderSbu` = `blcms_W`.`id` leftjoin `blcms_tenderareas` as `blcms_A` on `blcms_T`.`tenderArea` = `blcms_A`.`id` leftjoin `blcms_corrigendums` as `blcms_C` on `blcms_T`.`id` = `blcms_C`.`tenderId` leftjoin `blcms_tender_dates` as `blcms_D` on `blcms_T`.`id` = `blcms_D`.`tenderId` where `blcms_T`.`tenderStatus` ='1'and (`blcms_D`.`PublishDate` <='2025-07-29'and `blcms_C`.`tenderId` isnotnulland `blcms_D`.`TenderDueDate` >='2025-07-29'or `blcms_C`.`TenderDueDate` >='2025-07-29') groupby `blcms_T`.`id`, `blcms_C`.`tenderId` orderby `id` desc, `id` desc limit 10offset053.23ms/app/Http/Controllers/TenderSearchController.php:339bl_with_sbu