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` <= '2020-05-29' AND `Tender`.`end_publish` < '2020-05-29' ORDER BY `Tender`.`start_publish` desc, `Tender`.`modified` desc LIMIT 30

Tenders Archive: Government Of Uttarakhand, India

Tenders Archive

Print