Video Gallery

Santa Rosa Hydramatic would like to welcome you to our website's collection of informative and entertaining automotive videos. Santa Rosa Hydramatic hopes that all of our customers in Santa Rosa and the surrounding Sonoma 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 = '50'));