Heavy Duty Vehicle Repair & Service

ABC Auto Care is an all makes trailer, bus, truck full-service repair shop with a team of ASE - Certified Factory Trained Technicians ready to handle everything from minor repairs to complete rebuilt transmissions. ABC Auto Care works on Caterpillar, Allison, Cummins, and all International transmissions. ABC Auto Care offers competitive rates, quick turn around times, and high-quality service to help you keep your bottom line low and on the road!
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 = '6'));