query-96a2b9b6f37d67c8aa936a01afeec2ab

rq turtle/ttl

schema:name

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
SELECT ?item ?commonscat ?sitelink ?name WHERE {
  ?item wdt:P373 ?commonscat.
  ?sitelink schema:about ?item; schema:isPartOf <https://commons.wikimedia.org/>; schema:name ?name .
  FILTER( CONTAINS(STR(?sitelink), 'Category:') = true ) .
  FILTER( ?commonscat != SUBSTR(STR(?name), 10) ) .
} LIMIT 1000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?commonscat"):::projected v4("?item"):::projected v2("?name"):::projected v3("?sitelink"):::projected c7([https://commons.wikimedia.org/]):::iri f0[["?commonscat != substring(str(?name),'10^^xsd:integer')"]] f0 --> v1 f0 --> v2 f1[["contains(str(?sitelink),'Category:') = 'true^^xsd:boolean'"]] f1 --> v3 v4 --"wdt:P373"--> v1 v3 --"schema:about"--> v4 v3 --"schema:isPartOf"--> c7 v3 --"schema:name"--> v2