Holiday park where you can surf / with surf school on the map
(26)
Below you will find an overview of holiday parks with where you can surf / with surf school on the map.
26 Holiday parks where you can surf / with surf school 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 :Surfen_en_of_surfschool MEMBER OF v.kenmerken group by v.land
ORDER BY l.land asc