Video Gallery

Herb's Transmission would like to welcome you to our website's collection of informative and entertaining automotive videos. Herb's Transmission hopes that all of our customers in Canton and the surrounding Stark County area find these videos useful.

SELECT offers_owner.website_id, offers_owner.offer_id, offers_owner.id, websites.website_url, COALESCE(offers_owner.title, offers.title) AS title, COALESCE(offers_owner.description, offers.description) AS description, COALESCE(offers_owner.fine_print, offers.fine_print) AS fine_print, COALESCE(offers_owner.expiration, offers.expiration) AS expiration, COALESCE(offers_owner.teaser, offers.teaser) AS teaser, COALESCE(offers_owner.meta_title, offers.meta_title) AS meta_title, COALESCE(offers_owner.meta_description, offers.meta_description) AS meta_description, offers.image AS default_image, offers_owner.image AS owner_image, COALESCE(offers_owner.price, offers.price) AS price, offers_owner.sort_order FROM offers_owner LEFT JOIN websites on offers_owner.website_id = websites.id LEFT JOIN offers on offers_owner.offer_id = offers.id WHERE offers_owner.website_id in ((SELECT id FROM websites WHERE website_id = '45'));