John:SELECT SQL_CALC_FOUND_ROWS cars.id, (SELECT file FROM images WHERE ad_session=cars.ad_session ORDER BY featured DESC LIMIT 1) AS file, cars.ownerid, car_makes.make, car_models.model, cars.trim, cars.year, cars.price, cars.mileage, cars.engine, cars.color, cars.int_color, cars.transmission, cars.drive, cars.created, cars.ad_session, cars.dealer FROM cars JOIN car_makes ON cars.make = car_makes.id JOIN car_models ON cars.model = car_models.id LEFT JOIN images ON cars.ad_session = images.ad_session WHERE dealer='1' AND cars.sold = '0' AND cars.complete = '1' AND cars.price > 0 GROUP BY cars.id ORDER BY price ASC LIMIT 10
