SELECT SQL_CALC_FOUND_ROWS pq4_posts.ID FROM pq4_posts INNER JOIN pq4_postmeta ON ( pq4_posts.ID = pq4_postmeta.post_id ) INNER JOIN pq4_postmeta AS mt1 ON ( pq4_posts.ID = mt1.post_id ) 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.meta_key = 'activity-monthfilter' AND mt1.meta_value = '202103' )
)
) 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 ( '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','propqc_activity','propqc_slide','propqc_chantier','propqc_project','propqc_ad','propqc_document','propqc_partner' ) ) OR pq4_posts.post_type NOT IN ('post','page','attachment','wp_block','propqc_activity','propqc_slide','propqc_chantier','propqc_project','propqc_ad','propqc_document','propqc_partner' ) ) GROUP BY pq4_posts.ID ORDER BY pq4_postmeta.meta_value+0 ASC LIMIT 0, 4
Propulsion Québec, en collaboration avec la délégation du Québec à Chicago, est fière d’organiser une toute première mission virtuelle sur le développement durable et…
Propulsion Québec est fière d’organiser le tout premier salon des carrières et de la formation en transports électriques et intelligents. Vous êtes étudiant, employé…