| 0.0022 |
SELECT `t`.`id`, `t`.`title`, `t`.`nit_document`, `t`.`boq_document`, `t`.`tender_form`, `t`.`nit_number`, `d`.`name` as `directorate`, `t`.`tender_date`
FROM `tenders` as `t`
INNER JOIN `directorates` as `d` ON `d`.`id` = `t`.`directorate_id`
WHERE DATE(t.tender_date) > CURDATE() - INTERVAL 1 DAY
ORDER BY `t`.`tender_date` ASC
|
