query-2a3a42581fbf01f77f8f65cfdb82bc98

rq turtle/ttl

ISNI - human without ISNI, ordered by quantity of sitelinks and externalIDs

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 wikibase:identifiers 10 .
          #?item wikibase:sitelinks 10 .
          ?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; v2("?id"):::projected v4("?item"):::projected v5("?rank") v3("?sl"):::projected a1((" ")) c8(["bd:serviceParam"]):::iri c2(["wd:Q5"]):::iri c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal c4(["10^^xsd:integer"]):::literal v4 --"wdt:P31"--> c2 v4 --"wikibase:identifiers"--> c4 v4 --"wikibase:identifiers"--> v2 v4 --"wikibase:sitelinks"--> v3 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v4 --"wdt:P213"--> a1 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end bind1[/"?id * ?sl"/] v2 --o bind1 v3 --o bind1 bind1 --as--o v5