All Videos

Great Car Commercials

Herb's Transmission would like to welcome you to our Canton auto repair shop's video gallery of great car commercials. We have chosen some videos that we hope our customers in the greater Canton area can enjoy while visiting our website.

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'));