query-9e17adb98f295418882b702edc6f0f64
TODO
Use at
- https://query.wikidata.org/sparql
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 ?item ?itemLabel ?id ?sl ((?id * ?sl) as ?rank)
{
{
SELECT *
{ ?item wdt:P31 wd:Q5.
?item wdt:P106 wd:Q486748. # constrained to pianists so we see some results.
values ?id {10 11 12 13 14 15} # you can constrain ?id using values
values ?sl {10 11 12 13 14 15 }
#filter (?id >12) # or filter ?ids based on value
#filter (?sl >12)
?item wikibase:identifiers ?id.
?item wikibase:sitelinks ?sl.
MINUS{?item wdt:P213 [] .}
}
LIMIT 1000
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?rank) DESC(?id) DESC(?sl) ?item
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?id"):::projected
v4("?item"):::projected
v5("?rank")
v5("?sl"):::projected
a1((" "))
c9(["bd:serviceParam"]):::iri
c2(["wd:Q5"]):::iri
c4(["wd:Q486748"]):::iri
c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal
v4 --"wdt:P31"--> c2
v4 --"wdt:P106"--> c4
bind0[/VALUES ?id/]
bind0-->v5
bind00(["10^^xsd:integer"])
bind00 --> bind0
bind01(["11^^xsd:integer"])
bind01 --> bind0
bind02(["12^^xsd:integer"])
bind02 --> bind0
bind03(["13^^xsd:integer"])
bind03 --> bind0
bind04(["14^^xsd:integer"])
bind04 --> bind0
bind05(["15^^xsd:integer"])
bind05 --> bind0
bind1[/VALUES ?sl/]
bind1-->v5
bind10(["10^^xsd:integer"])
bind10 --> bind1
bind11(["11^^xsd:integer"])
bind11 --> bind1
bind12(["12^^xsd:integer"])
bind12 --> bind1
bind13(["13^^xsd:integer"])
bind13 --> bind1
bind14(["14^^xsd:integer"])
bind14 --> bind1
bind15(["15^^xsd:integer"])
bind15 --> bind1
v4 --"wikibase:identifiers"--> v5
v4 --"wikibase:sitelinks"--> v5
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v4 --"wdt:P213"--> a1
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
end
bind3[/"?id * ?sl"/]
v5 --o bind3
v5 --o bind3
bind3 --as--o v5