(184)
Below you will find an overview of holiday parks with with a cafe or bar on the map.
184 Holiday parks with a cafe or bar on the map found
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 :Cafe_en_of_Bar MEMBER OF v.kenmerken group by v.land
ORDER BY l.land asc