query-e7d49401aa70d6895d5d69bdeab552f7
Propertiesoriginal language of film or TV show (P364)publication date (P577)has edition or translation (P747)language of work or name (P407)translator (P655)publisher (P123)
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX schema: <http://schema.org/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT DISTINCT ?work ?workLabel ?workLanguageLabel ?edition ?editionLabel ?publisherLabel ?editionLanguageLabel ?editionDate ?translatorLabel ?translator
WHERE {
FILTER (?work = wd:Q6911)
{
?work wdt:P364 ?workLanguage;
wdt:P577 ?originalPublicationDate;
wdt:P747 ?edition.
OPTIONAL {?work wdt:P407 ?workLanguage}
OPTIONAL {?edition wdt:P655 ?translator}
OPTIONAL {?edition wdt:P407 ?editionLanguage}
OPTIONAL {?edition wdt:P577 ?editionDate}
OPTIONAL {?edition wdt:P123 ?publisher}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?editionDate ?translatorLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?edition"):::projected
v1("?editionDate"):::projected
v8("?editionLanguage")
v5("?originalPublicationDate")
v9("?publisher")
v7("?translator"):::projected
v2("?translatorLabel"):::projected
v3("?work"):::projected
v4("?workLanguage")
c9(["bd:serviceParam"]):::iri
c11(["en"]):::literal
f0[["?work = 'wd:Q6911'"]]
f0 --> v3
v3 --"wdt:P364"--> v4
v3 --"wdt:P577"--> v5
v3 --"wdt:P747"--> v6
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P407".-> v4
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wdt:P655".-> v7
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wdt:P407".-> v8
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wdt:P577".-> v1
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v6 -."wdt:P123".-> v9
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
end