Sie suchten nach Kieferorthop?de in Rheinland-Pfalz in Orten mit Anfangsbuchstaben P:

 -

SELECT geodb_locations.name AS name, geodb_locations.id as id, geodb_locations.adm3 AS adm3 FROM geodb_locations, geodb_adm1 WHERE geodb_adm1.name = 'Rheinland-Pfalz' AND geodb_locations.name like 'P%' AND geodb_locations.adm1 = geodb_adm1.adm1 AND geodb_locations.adm0 = 'DE' ORDER by geodb_locations.name;

[DIE]