• Hymer Motorhomes Logo
  • Burstner Motorhomes Logo
  • Bailey Motorhomes Logo
  • Adria Motorhomes Logo
  • Wildax Motorhomes Logo
  • Hymercar Motorhomes Logo

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 = 'sea'
        
        
        
        
        
        
        AND `V`.`price` > 0
        GROUP BY `V`.`berths`
        ORDER BY `V`.`berths` ASC