query-59d891fae3aa3af76921d77d90289696

rq turtle/ttl

إصدارات الصرخة Versions of The Scream Versions of The Scream Verze obrazu The Scream Versions of The Scream Versions of The Scream Versions of The Scream Versions of The Scream Versions of The Scream Versions of The Scream Versions of The Scream Versions du tableau « Le Cri » Versions of The Scream Versions of The Scream Versions of The Scream Versioni de L'urlo Versions of The Scream 영화 《스크림》의 여러가지 변형 작품 보기 Versions of The Scream Versions of The Scream Versions of The Scream Versies van De Schreeuw Versions of The Scream Versions of The Scream Versions of The Scream Versions of The Scream Versions of The Scream Versioner av tavlan Skriet Versions of The Scream Versions of The Scream Versions of The Scream Versions of The Scream Versions of The Scream

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT
  ?item
  (SAMPLE (?itemL) AS ?title)
  (SAMPLE (?y) AS ?year)
  (SAMPLE (?typeL) AS ?type)
  (group_concat(DISTINCT ?materialL ; separator = ", ") as ?materials)
  (SAMPLE (?collectionL) AS ?collection)
  (SAMPLE (?img) AS ?image)
{
  SELECT ?item ?itemL (YEAR(?date) AS ?y) ?typeL ?collectionL ?img ?materialL
  WHERE {
    ?item wdt:P179 wd:Q471379 .
    ?item wdt:P18 ?img .
    ?item wdt:P571 ?date .
    ?item wdt:P31 ?instance .
    ?item rdfs:label ?itemL FILTER (lang(?itemL) = "en").
    ?instance rdfs:label ?typeL FILTER (lang(?typeL) = "en").
    OPTIONAL {
      ?item wdt:P195 ?collection .
      ?collection rdfs:label ?collectionL FILTER (lang(?collectionL) = "en").
    }
    OPTIONAL {
      ?item wdt:P186 ?material .
      ?material rdfs:label ?materialL FILTER (lang(?materialL) = "en").
    }
  }
}
GROUP BY ?item
ORDER BY ?year ?item ?itemLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v17("?collection") v7("?collectionL"):::projected v9("?date") v17("?image") v8("?img"):::projected v10("?instance") v2("?item"):::projected v6("?itemL"):::projected v3("?itemLabel") v12("?material") v4("?materialL"):::projected v16("?materials") v14("?title") v15("?type") v5("?typeL"):::projected v13("?y"):::projected v15("?year") c3(["wd:Q471379"]):::iri f0[["?typeL = 'en'"]] f0 --> v5 f1[["?itemL = 'en'"]] f1 --> v6 v2 --"wdt:P179"--> c3 v2 --"wdt:P18"--> v8 v2 --"wdt:P571"--> v9 v2 --"wdt:P31"--> v10 v2 --"rdfs:label"--> v6 v10 --"rdfs:label"--> v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P195".-> v17 v17 --"rdfs:label"--> v7 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P186".-> v12 v12 --"rdfs:label"--> v4 end bind2[/"year-from-dateTime(?date)"/] v9 --o bind2 bind2 --as--o v13 bind9[/"sample(?itemL)"/] v6 --o bind9 bind9 --as--o v14 bind10[/"sample(?y)"/] v13 --o bind10 bind10 --as--o v15 bind11[/"sample(?typeL)"/] v5 --o bind11 bind11 --as--o v15 bind12[/"?materialL"/] v4 --o bind12 bind12 --as--o v16 bind13[/"sample(?collectionL)"/] v7 --o bind13 bind13 --as--o v17 bind14[/"sample(?img)"/] v8 --o bind14 bind14 --as--o v17