John:SELECT SQL_CALC_FOUND_ROWS cars.id, images.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 AND images.featured = 1 WHERE cars.sold = '0' AND cars.complete = '1' GROUP BY cars.id ORDER BY cars.created DESC, images.id ASC LIMIT 10
