query-d1c314b96a72393979e8c91248af1a91

rq turtle/ttl

The above query includes a lot of statues and public art with a permanent fixed location. The next query tries to exclude these.

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#>
#title:The most notable sculptures without a co-ordinate location
#defaultView:ImageGrid
SELECT ?item ?itemLabel (SAMPLE(?img) AS ?image) WHERE {
 {SELECT DISTINCT ?item WHERE {
?item wdt:P31/wdt:P279? wd:Q860861.
  MINUS {?item wdt:P625 []}
?item wikibase:sitelinks ?sites. } ORDER BY DESC(?sites) LIMIT 100 }
?item wdt:P18 ?img.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?item ?itemLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?image") v3("?img"):::projected v2("?item"):::projected v1("?sites") a2((" ")) a1((" ")) c8(["bd:serviceParam"]):::iri c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal c2(["wd:Q860861"]):::iri v2 --"wdt:P31"--> a1 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; a1 --"wdt:P279"--> c2 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; end union0r <== or ==> union0l end subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P625"--> a2 end v2 --"wikibase:sitelinks"--> v1 v2 --"wdt:P18"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end bind2[/"sample(?img)"/] v3 --o bind2 bind2 --as--o v4