SELECT DISTINCT (p.post_title), p.post_name FROM im3_posts AS p LEFT JOIN im3_term_relationships AS r on p.ID = r.object_id LEFT JOIN im3_icl_translations AS t on t.element_id = p.ID WHERE r.term_taxonomy_id = 1592 AND t.language_code like "en" AND p.post_status like "publish" AND p.ID <> 3900 ORDER BY p.post_title ASC

Other partners

Mission :

Lead Quebec to reduce, reuse, recycle and recover residual materials to promote a circular economy and fight against climate change.