query-3fbf60e17eb0781c5493a3d7e6ef9e9b

rq turtle/ttl

قائمة البلدان والعواصم في يومنا هذا List of present-day countries and capital(s) List of present-day countries and capital(s) Seznam současných zemí a jejich hlavních měst List of present-day countries and capital(s) Liste der aktuell exisiterenden Staaten und Hauptstädten List of present-day countries and capital(s) List of present-day countries and capital(s) List of present-day countries and capital(s) List of present-day countries and capital(s) List of present-day countries and capital(s) Liste des pays actuels avec leur(s) capitale(s) רשימת מדינות ובירות בנות ימינו List of present-day countries and capital(s) List of present-day countries and capital(s) Elenco dei paesi e delle capitali attuali 現在の国と首都 List of present-day countries and capital(s) List of present-day countries and capital(s) List of present-day countries and capital(s) List of present-day countries and capital(s) Lijst van huidige landen met per land de hoofdstad List of present-day countries and capital(s) List of present-day countries and capital(s) List of present-day countries and capital(s) List of present-day countries and capital(s) List of present-day countries and capital(s) Lista över nutida länder och huvudstäder List of present-day countries and capital(s) List of present-day countries and capital(s) Список сучасних країн та столиць List of present-day countries and capital(s) 当今的国家/地区与首都名单

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?country ?countryLabel ?capital ?capitalLabel
WHERE
{
  ?country wdt:P31 wd:Q3624078 .
  #not a former country
  FILTER NOT EXISTS {?country wdt:P31 wd:Q3024240}
  #and no an ancient civilisation (needed to exclude ancient Egypt)
  FILTER NOT EXISTS {?country wdt:P31 wd:Q28171280}
  OPTIONAL { ?country wdt:P36 ?capital } .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" }
}
ORDER BY ?countryLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?capital"):::projected v2("?country"):::projected v1("?countryLabel"):::projected c2(["wd:Q28171280"]):::iri c3(["wd:Q3024240"]):::iri c4(["wd:Q3624078"]):::iri c7(["bd:serviceParam"]):::iri c9(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P31"--> e0c2 e0v1("?country"):::projected e0c2(["wd:Q28171280"]):::iri end f0--EXISTS--> f0e0 f0 --> v2 f0 --> c1 f0 --> c2 v2 --"wdt:P31"--> c2 f1[["not "]] subgraph f1e1["Exists Clause"] e1v1 --"wdt:P31"--> e1c2 e1v1("?country"):::projected e1c2(["wd:Q3024240"]):::iri end f1--EXISTS--> f1e1 f1 --> v2 f1 --> c1 f1 --> c3 v2 --"wdt:P31"--> c3 v2 --"wdt:P31"--> c4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P36".-> v3 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end