query-b2bca69ec0ee8fa7e46d2e82623ba2fc
only works with URLs ending in a slash. This finds only 6 results rather than 12:schema:isPartOf: Sorry for barging in, but it wasn't obvious to me that Jura1@ } . Q5:wd P31:wdt ; [] P18:wdt ?item } https://en.wikipedia.org/ isPartOf:schema ; ?item about:schema [] { MINUS . dateTime:xsd^^"1919-10-01" P569:wdt ?item { WHERE )?total as 40 * 365 * ?count( )?count as )*( COUNT( SELECT 12:50, 13 November 2021 (UTC)) talk (Streetmathematician --- Good point .. explains my time-outs. Thanks.
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
SELECT (COUNT (*) as ?count)
WHERE
{
?item wdt:P569 ?time.
FILTER ((?time < "1940-01-01"^^xsd:dat) && (?time > "1900-01-02"^^xsd:dat)).
MINUS { [] schema:about ?item ; schema:isPartOf <https://en.wikipedia.org/> }
?item wdt:P18 [] ; wdt:P31 wd:Q5 .
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?count")
v2("?item")
v1("?time")
a1((" "))
a2((" "))
c6([https://en.wikipedia.org/]):::iri
c9(["wd:Q5"]):::iri
f0[["?time < s1940-01-01^^<http://www.w3.org/2001/XMLSchema#dat>'?time > s1900-01-02^^<http://www.w3.org/2001/XMLSchema#dat>'"]]
f0 --> v1
v2 --"wdt:P569"--> v1
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
a1 --"schema:about"--> v2
a1 --"schema:isPartOf"--> c6
end
v2 --"wdt:P18"--> a2
v2 --"wdt:P31"--> c9
bind3[/"count(*)"/]
bind3 --as--o v3