query-2ed1556b998722913eca55f85ec617ed
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
select ?lang (count(*) as ?total) {
?item wdt:P31 wd:Q577 .
?item wdt:P585 ?pit .
?item rdfs:label ?label .
bind (lang(?label) as ?lang) .
filter (str(?label) != str(year(?pit))) .
filter (?item not in (wd:Q3342801, wd:Q16131968)) . # out of sync items
} group by ?lang order by ?lang
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item")
v3("?label")
v5("?lang"):::projected
v4("?pit")
v5("?total")
c4(["wd:Q577"]):::iri
f0[["?item != 'wd:Q3342801'?item != 'wd:Q16131968'"]]
f0 --> v2
f1[["str(?label) != str(year-from-dateTime(?pit))"]]
f1 --> v3
f1 --> v4
v2 --"wdt:P31"--> c4
v2 --"wdt:P585"--> v4
v2 --"rdfs:label"--> v3
bind2[/"?label"/]
v3 --o bind2
bind2 --as--o v5
bind4[/"count(*)"/]
bind4 --as--o v5