SELECT DISTINCT ?cl ?PL ?YL ?RPL1 ?RPL2 WHERE { ?c wdt:P31/wdt:P279* wd:Q3624078 . ## sovereign state FILTER NOT EXISTS { ?c wdt:P576 ?X } ### not dissolved date ?c rdfs:label ?cl . filter (lang(?cl)="en") filter (str(?cl) = "Germany") ?c ?P ?stmt . ?stmt pq:P805 ?Y . ## p:P-stmt reified as Y ?Prop wikibase:claim ?P; rdfs:label ?PL . filter (lang(?PL)="en") ?Y rdfs:label ?YL . filter (lang(?YL)="en") ### link between ?c and ?Y or back: must be in wdt:rprop optional { ?c ?rp1 ?Y . ?Rprop wikibase:directClaim ?rp1 . ?Rprop rdfs:label ?RPL1 . filter (lang(?RPL1)="en") } optional { ?Y ?rp2 ?c . ?Rprop wikibase:directClaim ?rp2 . ?Rprop rdfs:label ?RPL2 . filter (lang(?RPL2)="en") } } order by ?cl