Query: SELECT `Tender`.`id`, `Tender`.`title_english`, `Tender`.`content_english`, `Tender`.`title_hindi`, `Tender`.`content_hindi`, `Tender`.`file_name`, `Tender`.`file_name_hindi`, DATE_FORMAT(Tender.start_publish,"%d-%m-%Y") as display_date FROM `mcms_tenders` AS `Tender` WHERE `Tender`.`publish` = 1 AND `Tender`.`status` = 1 AND `Tender`.`department_id` = 1 AND `Tender`.`end_publish` >= '2024-11-21' ORDER BY `Tender`.`start_publish` desc, `Tender`.`modified` desc