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 = 405 AND t.language_code like "en" AND p.post_status like "publish" AND p.ID <> 792 ORDER BY p.post_title ASC

Other partners

Founded in 2015 and located in Laval, Nordresa designs and manufactures electric powertrains for commercial vehicles. Our clients are OEMs who want to accelerate the introduction of electric vehicles into their portfolio and fleet managers who aim to reduce their operation fees while limiting their impact on the environment. Our products are zero emission, versatile and profitable, today.