Vehicles For Sale Cody, WY

Featured Inventory

SELECT a.id AS adid, a.year AS year, a.creatdate AS creatdate, a.bodytype,a.mileage AS mileage, a.specificmodel AS specificmodel,a.ftop AS ftop, a.fauction AS fauction, a.fcommercial AS fcommercial, a.imgmain AS img_name,a.special AS special, a.expreserved AS expreserved, a.solid AS solid, a.exptitle AS exptitle,a.bprice,a.price, a.expprice ,c.title AS category_name, c.id AS categid,mk.id AS mkid, mk.name AS make_name,md.id AS mdid, md.name AS model_name,img.name AS db_image, img.ordering AS db_image_ordering,ag.title AS access_level FROM n3ptb7_expautos_admanager as a LEFT JOIN n3ptb7_expautos_categories AS c ON c.id = a.catid LEFT JOIN n3ptb7_expautos_make AS mk ON mk.id = a.make LEFT JOIN n3ptb7_expautos_model AS md ON md.id = a.model LEFT JOIN #__expautos_images AS img ON img.catid = a.id AND img.ordering = (SELECT MIN(img2.ordering) FROM #__expautos_images AS img2 WHERE img2.catid = a.id order by ordering limit 1 ) LEFT JOIN n3ptb7_viewlevels AS ag ON ag.id = c.access WHERE a.state=1 AND c.access IN (1,1,5) AND c.id IN (3) AND a.special = 1 AND a.solid = 0 AND a.expreserved = 0 GROUP BY `a`.`id` ORDER BY a.id ASC,img.name ASC LIMIT 3