- Skip to main content
- Screen Reader Access
- Skip to navigation
- Text Size
- Select Theme Default Theme Yellow Theme Pink Theme Blue Theme
- हिंदी में
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-04-19' AND `Tender`.`end_publish` < '2024-04-19' ORDER BY `Tender`.`start_publish` desc, `Tender`.`modified` desc LIMIT 30
