query-7ca1096c0656d62128d28764e3543abe
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?item ?label ?labelgen WHERE {
#
VALUES ?type {wd:Q571 wd:Q7725634 wd:Q47461344 }
?item wdt:P31 ?type .
?item wdt:P136 ?genre.
?genre rdfs:label ?labelgen filter (lang(?labelgen) = "it"). # <<<<<<<<<<<<<<<<<<<<<<<<
?item wdt:P577 ?date .
?item wdt:P50 ?author .
OPTIONAL {?author wdt:P1559 ?authorlabel . filter(lang(?authorlabel) = "en")}
OPTIONAL {?author rdfs:label ?authorlabel2 . filter(lang(?authorlabel2) = "en")}
FILTER (?date > "1979-01-01T00:00:00Z"^^xsd:dateTime) .
?item rdfs:label ?label filter (lang(?label) = "it")
?item wdt:P407 wd:Q652.
?article schema:about ?item ;
#schema:inLanguage ?lang ;
# schema:isPartOf [ wikibase:wikiGroup "wikipedia" ] .
} group by ?item ?label ?labelgen
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v10("?article")
v9("?author")
v5("?authorlabel")
v3("?authorlabel2")
v2("?date")
v8("?genre")
v7("?item"):::projected
v1("?label"):::projected
v4("?labelgen"):::projected
v6("?type")
c11(["wd:Q652"]):::iri
f0[["?label = 'it'"]]
f0 --> v1
f1[["?date > '1979-01-01T00:00:00Z^^xsd:dateTime'"]]
f1 --> v2
f2[["?labelgen = 'it'"]]
f2 --> v4
bind3[/VALUES ?type/]
bind3-->v6
bind30(["wd:Q571"])
bind30 --> bind3
bind31(["wd:Q7725634"])
bind31 --> bind3
bind32(["wd:Q47461344"])
bind32 --> bind3
v7 --"wdt:P31"--> v6
v7 --"wdt:P136"--> v8
v8 --"rdfs:label"--> v4
v7 --"wdt:P577"--> v2
v7 --"wdt:P50"--> v9
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v9 -."wdt:P1559".-> v5
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v9 -."rdfs:label".-> v3
end
v7 --"rdfs:label"--> v1
v7 --"wdt:P407"--> c11
v10 --"schema:about"--> v7