EuroParcs-Ferienparks auf der Karte

SELECT l, count(v.id) AS aantal FROM App:Land l INNER JOIN App:Vakantiepark AS v WITH l.id = v.land where v.tonen=1 and v.merk = :hetmerk and :personen_12 MEMBER OF v.kenmerken and :personen_16 MEMBER OF v.kenmerken group by v.land ORDER BY l.land asc