Sie suchten nach Kieferorthop?de im Postleitzahlenberiech ab 10xxx:

 -

SELECT geodb_locations.name AS name, geodb_locations.id as id, geodb_locations.adm3 AS adm3, geodb_adm1.name AS bundesland FROM geodb_locations, geodb_adm1 WHERE ( geodb_locations.plz like '10%' or geodb_locations.plz like '11%' or geodb_locations.plz like '12%' or geodb_locations.plz like '13%' or geodb_locations.plz like '14%' or geodb_locations.plz like '%,10%' or geodb_locations.plz like '%,11%' or geodb_locations.plz like '%,12%' or geodb_locations.plz like '%,13%' or geodb_locations.plz like '%,14%' ) AND geodb_locations.adm1 = geodb_adm1.adm1 AND geodb_locations.adm0 = 'DE' AND geodb_adm1.adm0 = 'DE' ORDER by geodb_locations.name;

[DIE]