GOV/Datenauswertung

Liste aller Ortsnamen in einem Kreis

SELECT c.textualId, n.content, n.language, type_names.value
 FROM GovItem i 
 JOIN p ON p.ende=i.id 
 JOIN GovItem c ON p.anfang=c.id AND c.deleted=0 
 LEFT JOIN Property n ON n.gov_object=c.id AND n.type=1 
 LEFT JOIN Property t ON t.gov_object=c.id AND t.type=2 
 JOIN type_names ON type_names.type_id=t.typeObject AND type_names.language='deu'  
 WHERE i.textualId ='adm_169761'