query-fcfa666c7527e95bebf25abc44b85a73

Items with an IMO number and a Commons category

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
SELECT ?item ?imo ?image ?comm where {
  ?item wdt:P458 ?imo.
  ?comm schema:about ?item ; schema:isPartOf <https://commons.wikimedia.org/> .
  OPTIONAL {
  ?item wdt:P18 ?image.
  }
}

Query found at

https://www.wikidata.org/wiki/User:Kq-hit

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?comm"):::projected v4("?image"):::projected v2("?imo"):::projected v1("?item"):::projected c4([https://commons.wikimedia.org/]):::iri v1 --"wdt:P458"--> v2 v3 --"schema:about"--> v1 v3 --"schema:isPartOf"--> c4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."wdt:P18".-> v4 end