SELECt `vehicle`.`id`, `vehicle`.`stock`, `vehicle`.`year`, `vehicle`.`make`, `vehicle`.`model`, `images`.`name`, ( SELECT COUNT(*) FROM `images` WHERe `vehicle_id` = `vehicle`.`id` ) AS `image_count`FROM `vehicle`LEFT JOIN `images`ON `images`.`vehicle_id` = `vehicle`.`id`WHERe `images`.`default`



