Call Us Today: 01493 740 274
Call: 01493 740 274
NR29 5DR
Call Us Today: 01493 740 274
Call: 01493 740 274
NR29 5DR
berths was empty
SELECT `V`.`berths`, COUNT(`V`.`vehicle_id`) as num FROM `vehicle` `V` LEFT JOIN category_has_vehicle chv ON chv.vehicle_id = V.vehicle_id LEFT JOIN vehicle_has_layout vhl on V.vehicle_id = vhl.vehicle_id WHERE `V`.`berths` != '' AND make = 'autosleeper' AND `V`.`price` > 0 GROUP BY `V`.`berths` ORDER BY `V`.`berths` ASC