ประกาศผลการจัดซื้อจัดจ้าง

SELECT mod_cms_id , mod_cms_file , mod_cms_create_date , mod_cms_group_parent_cid , mod_cms_view , mod_procurement_staus , mod_procurement_date FROM mod_cms LEFT JOIN mod_procurement ON mod_procurement_id = mod_cms_id LEFT JOIN mod_cms_group_parent ON mod_cms_group_parent_pid = mod_cms_id WHERE mod_cms_group_parent_cid = '25' AND mod_cms_modulekey = 'dad_procurement' AND mod_cms_staus = '1' AND ((mod_cms_start_date='0000-00-00 00:00:00' AND mod_cms_finish_date='0000-00-00 00:00:00') OR (mod_cms_start_date='0000-00-00 00:00:00' AND TO_DAYS(mod_cms_finish_date)>=TO_DAYS(NOW()) ) OR (TO_DAYS(mod_cms_start_date)<=TO_DAYS(NOW()) AND mod_cms_finish_date='0000-00-00 00:00:00' ) OR (TO_DAYS(mod_cms_start_date)<=TO_DAYS(NOW()) AND TO_DAYS(mod_cms_finish_date)>=TO_DAYS(NOW()) )) ORDER BY mod_procurement_date DESC LIMIT 760,10