Video Gallery

Jim Jennings Transmissions would like to welcome you to our website's collection of informative and entertaining automotive videos. Jim Jennings Transmissions hopes that all of our customers in Baltimore and the surrounding Baltimore 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 = '13'));