Mot clé : carrières

SELECT SQL_CALC_FOUND_ROWS pq4_posts.ID FROM pq4_posts LEFT JOIN pq4_term_relationships ON (pq4_posts.ID = pq4_term_relationships.object_id) LEFT JOIN pq4_postmeta ON ( pq4_posts.ID = pq4_postmeta.post_id ) LEFT JOIN pq4_postmeta AS mt1 ON ( pq4_posts.ID = mt1.post_id AND mt1.meta_key = 'activity-expired' ) JOIN pq4_icl_translations wpml_translations ON pq4_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', pq4_posts.post_type) WHERE 1=1 AND ( pq4_term_relationships.term_taxonomy_id IN (447) ) AND ( pq4_postmeta.meta_key = 'activity-datesort' AND ( mt1.post_id IS NULL ) ) AND ((pq4_posts.post_type = 'propqc_activity' AND (pq4_posts.post_status = 'publish' OR pq4_posts.post_status = 'acf-disabled'))) AND ( ( ( wpml_translations.language_code = 'fr' OR ( wpml_translations.language_code = 'fr' AND pq4_posts.post_type IN ( 'e-landing-page','elementor_library','propqc_ad' ) AND ( ( ( SELECT COUNT(element_id) FROM pq4_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'fr' ) = 0 ) OR ( ( SELECT COUNT(element_id) FROM pq4_icl_translations t2 JOIN pq4_posts p ON p.id = t2.element_id WHERE t2.trid = wpml_translations.trid AND t2.language_code = 'fr' AND ( p.post_status = 'publish' OR p.post_type='attachment' AND p.post_status = 'inherit' ) ) = 0 ) ) ) ) AND pq4_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-landing-page','elementor_library','propqc_activity','propqc_slide','propqc_chantier','propqc_project','propqc_ad','propqc_document','propqc_partner','propqc_program' ) ) OR pq4_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-landing-page','elementor_library','propqc_activity','propqc_slide','propqc_chantier','propqc_project','propqc_ad','propqc_document','propqc_partner','propqc_program' ) ) GROUP BY pq4_posts.ID ORDER BY pq4_postmeta.meta_value+0 ASC LIMIT 0, 4
  • RDV En route 2022

    La deuxième édition du RDV En route se tiendra en format PRÉSENTIEL le 26 octobre 2022 prochain au Centre des sciences de Montréal. Tout comme la première édition, cet…
    Tous les détails

    Ajouter à mon calendrier :   iCal   aCalendar

  • Programme Recharge+