query-f656e9a36b98ed42bb514364138544d5
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?P569_2 ?P569_3 WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
{
SELECT DISTINCT ?item ?P569_2 ?P569_3 WHERE {
?item p:P166 ?statement0.
?statement0 (ps:P166/(wdt:P279*)) wd:Q37922.
?item p:P1412 ?statement1.
?statement1 (ps:P1412/(wdt:P279*)) wd:Q1860.
?item p:P569 ?statement_2.
?statement_2 psv:P569 ?statementValue_2.
?statementValue_2 wikibase:timeValue ?P569_2.
?item p:P569 ?statement_3.
?statement_3 psv:P569 ?statementValue_3.
?statementValue_3 wikibase:timePrecision ?precision_3.
FILTER(?precision_3 >= 9 )
?statementValue_3 wikibase:timeValue ?P569_3.
FILTER(?P569_3 >= "+1924-00-00T00:00:00Z"^^xsd:dateTime)
}
LIMIT 100
}
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v8("?P569_2"):::projected
v1("?P569_3"):::projected
v3("?item"):::projected
v2("?precision_3")
v4("?statement0")
v5("?statement1")
v7("?statementValue_2")
v10("?statementValue_3")
v6("?statement_2")
v9("?statement_3")
a1((" "))
a2((" "))
c2(["bd:serviceParam"]):::iri
c4(["#91;AUTO_LANGUAGE#93;"]):::literal
c13(["wd:Q1860"]):::iri
c10(["wd:Q37922"]):::iri
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c2 --"wikibase:language"--> c4
end
f0[["?P569_3 >= '+1924-00-00T00:00:00Z^^xsd:dateTime'"]]
f0 --> v1
f1[["?precision_3 >= '9^^xsd:integer'"]]
f1 --> v2
v3 --"p:P166"--> v4
v4 --"p:statement/P166"--> a1
a1 --"p:direct/P279"--> c10
v3 --"p:P1412"--> v5
v5 --"p:statement/P1412"--> a2
a2 --"p:direct/P279"--> c13
v3 --"p:P569"--> v6
v6 --"p:statement/value/P569"--> v7
v7 --"wikibase:timeValue"--> v8
v3 --"p:P569"--> v9
v9 --"p:statement/value/P569"--> v10
v10 --"wikibase:timePrecision"--> v2
v10 --"wikibase:timeValue"--> v1