Téo taxi

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 = 406 AND t.language_code like "fr" AND p.post_status like "publish" AND p.ID <> 3669 ORDER BY p.post_title ASC

Autres partenaires