SELECT id_section FROM cms_sections JOIN cms_editorial_publications_states ON section_publication_state=id_publication_state WHERE section_num_parent = cms_module_section_202 AND ((section_start_date != 0 AND to_days(section_start_date)<=to_days(now()) AND to_days(section_end_date)>=to_days(now())) OR (section_start_date != 0 AND section_end_date =0 AND to_days(section_start_date)<=to_days(now())) OR (section_start_date = 0 AND to_days(section_end_date)>=to_days(now())) OR (section_start_date = 0 AND section_end_date = 0)) AND (editorial_publication_state_opac_show=1 AND editorial_publication_state_auth_opac_show = 0) ORDER BY section_order
select section_publication_state as statut from cms_sections where id_section=