query-0cc7b5a7b2631b8d526179c74358e575
Works by Aristophanes
SELECT ?item ?itemLabel ?genreLabel (CONCAT(str(1+YEAR(?date)*-1), "BC") as ?yearBC) ?title
WHERE {
?item wdt:P50 wd:Q43353 .
?item wdt:P136 ?genre .
?item wdt:P1191 ?date .
?item wdt:P1476 ?title .
SERVICE wikibase:label { bd:serviceParam wikibase:language "it,grc" }
} ORDER BY ?date
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Works by Aristophanes
SELECT ?item ?itemLabel ?genreLabel (CONCAT(str(1+YEAR(?date)*-1), "BC") as ?yearBC) ?title
WHERE {
?item wdt:P50 wd:Q43353 .
?item wdt:P136 ?genre .
?item wdt:P1191 ?date .
?item wdt:P1476 ?title .
SERVICE wikibase:label { bd:serviceParam wikibase:language "it,grc" }
} ORDER BY ?date
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?date"):::projected
v3("?genre")
v2("?item"):::projected
v4("?title"):::projected
v5("?yearBC")
c9(["it,grc"]):::literal
c7(["bd:serviceParam"]):::iri
c2(["wd:Q43353"]):::iri
v2 --"wdt:P50"--> c2
v2 --"wdt:P136"--> v3
v2 --"wdt:P1191"--> v1
v2 --"wdt:P1476"--> v4
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end
bind0[/"concat(str('1^^xsd:integer' + year-from-dateTime(?date) * '-1^^xsd:integer'),'BC')"/]
v1 --o bind0
bind0 --as--o v5