SELECT mod_cms_id , mod_cms_file , mod_cms_create_date , mod_cms_group_parent_cid , mod_cms_view FROM mod_cms 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_cms_order DESC LIMIT 300,10