• 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

...

makes was empty

    SELECT `V`.`make`,
        COUNT(`V`.`vehicle_id`) as num
    FROM `vehicle` `V`
    LEFT JOIN category_has_vehicle chv ON chv.vehicle_id = V.vehicle_id
    WHERE `V`.`price` > 0
    
    
    
    
    
    
    
    
     AND layout_id = 5
    
    GROUP BY `V`.`make`
    ORDER BY `V`.`make` ASC