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, car_makes.make, car_models.model, cars.year, cars.price 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 cars.sold = '0' AND cars.complete = '1' AND cars.price > 0 GROUP BY cars.id ORDER BY price ASC LIMIT 24
