query-9e17adb98f295418882b702edc6f0f64

rq turtle/ttl

TODO

Use at

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