query-df7d87365d5ae94918e53684c5ac61f5

rq turtle/ttl

Aschroet

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
SELECT *
WHERE
{

{
  SELECT DISTINCT ?item
  WHERE
  {
    ?item wdt:P18 ?image .
    ?item wdt:P31 wd:Q5 .
    FILTER STRENDS(STR(?item), "2")
  }
LIMIT 150000
}  ?commons schema:about ?item .
  ?commons schema:isPartOf <https://commons.wikimedia.org/> .
  ?commons schema:name ?commons_title .
  FILTER STRSTARTS (?commons_title, "Category:")
}
LIMIT 70000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?commons"):::projected v1("?commons_title"):::projected v3("?image") v2("?item"):::projected c8([https://commons.wikimedia.org/]):::iri c5(["wd:Q5"]):::iri f0[["starts-with(?commons_title,'Category:')"]] f0 --> v1 f1[["ends-with(str(?item),'2')"]] f1 --> v2 v2 --"wdt:P18"--> v3 v2 --"wdt:P31"--> c5 v4 --"schema:about"--> v2 v4 --"schema:isPartOf"--> c8 v4 --"schema:name"--> v1