autosphere.ca

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 <> 1550 ORDER BY p.post_title ASC

Other partners

Autosphere.ca is the only B2B multisegment portal dedicated to the Canadian automotive industry. It is the most comprehensive and relevant information hub that can be found on the Web today, available to both English and French viewers. For all of the industry’s five segments (retail, fleet, tire, service repair or collision repair), we offer premium ad placement to connect directly to your client.