Guarantee RV - Class A Motorhomes

SELECT * FROM brochure WHERE  `stock_item` = '1219X' OR `manufacturer` = 'COACHMEN' OR `brand_name` = 'MIRADA'  ORDER BY cms_headline

SELECT stock_item.id, stock_item.cms_headline, stock_item.year, stock_item.d, stock_item.sc, stock_item.type, stock_item.manufacturer, stock_item.brand_name, stock_item.model, stock_item.mileage, stock_item.list_price, stock_item.slides, stock_item.monthly, stock_item.int_clr, stock_item.option_description, stock_item_image.large_image, stock_item_image.small_image, stock_item_image.thumbnail_image, stock_item_details.description, stock_item_details.floor_plan, stock_item_details.youtube_share_url FROM stock_item LEFT JOIN stock_item_image ON stock_item.cms_headline = stock_item_image.stock_item LEFT JOIN stock_item_details ON stock_item.cms_headline = stock_item_details.cms_headline WHERE `type` = 'A' ORDER BY list_price DESC ;