SELECT post.*, lat.meta_value AS latitude, lng.meta_value AS longitude FROM wp_posts AS post LEFT JOIN wp_postmeta AS lat ON post.ID = lat.post_id AND lat.meta_key = 'oyemetatpl_school_map_lat' AND lat.meta_value IS NOT NULL LEFT JOIN wp_postmeta AS lng ON post.ID = lng.post_id AND lng.meta_key = 'oyemetatpl_school_map_lng' AND lng.meta_value IS NOT NULL WHERE post.post_type = 'scholen' AND post.post_status='publish' GROUP BY post.ID ORDER BY post.post_title ASC
Voortgezet onderwijs in omgeving Nijmegen
51 resultaten gevonden – weergave op alfabetische volgorde