Guarantee RV - Destination Trailer

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
            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` = 'DT'  ORDER BY list_price DESC ;