SELECT SQL_CALC_FOUND_ROWS pq4_posts.ID FROM pq4_posts 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_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
Propulsion Québec, en partenariat avec le ministère de l’Économie et de l’Innovation du Québec, propose une séance d’informations virtuelle exclusivement destinée aux membres de la…
Débat sur l’avenir des transports électriques et intelligents, dans le cadre de la campagne électorale provinciale Propulsion Québec vous invite à un débat politique…