query-b4dff446712a825441aecb39cdf2630b
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?elo ?date ?url WHERE {
?item p:P1087 ?stmt .
?stmt prov:wasDerivedFrom ?ref; ps:P1087 ?elo .
?ref pr:P854 ?url .
MINUS { ?ref pr:P248 [] }
FILTER(REGEX(STR(?url), '^https?:\\/\\/ratings\\.fide\\.com\\/')) .
OPTIONAL { ?stmt pq:P585 ?date }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?date"):::projected
v5("?elo"):::projected
v2("?item"):::projected
v4("?ref")
v3("?stmt")
v1("?url"):::projected
a1((" "))
f0[["regex(str(?url),'^https?:\/\/ratings\.fide\.com\/')"]]
f0 --> v1
v2 --"p:P1087"--> v3
v3 --"prov:wasDerivedFrom"--> v4
v3 --"p:statement/P1087"--> v5
v4 --"p:reference/P854"--> v1
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v4 --"p:reference/P248"--> a1
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."p:qualifier/P585".-> v6
end