Query: SELECT `Tender`.`id`, `Tender`.`title_english`, `Tender`.`content_english`, `Tender`.`title_hindi`, `Tender`.`content_hindi`, `Tender`.`start_publish`, `Tender`.`file_name`, `Tender`.`file_name_hindi`, DATE_FORMAT(Tender.start_publish,"%d-%m-%Y") as start_publish, DATE_FORMAT(Tender.end_publish,"%d-%m-%Y") as end_publish FROM `mcms_tenders` AS `Tender`   WHERE `Tender`.`publish` = 1 AND `Tender`.`status` = 1 AND `Tender`.`department_id` = 1 AND `Tender`.`start_publish` <= '2024-11-21' AND `Tender`.`end_publish` < '2024-11-21'   ORDER BY `Tender`.`start_publish` desc, `Tender`.`modified` desc  LIMIT 30
Tenders Archive: Test Title, Government Of Uttarakhand, India

Tenders Archive

Print