query-50f9cf1840e5a64a2a31e0a429744876
Work or printed material published in Vitoria-Gasteiz, Bilbao, Tolosa, Donostia-San Sebastián from 1799 to 1800 with date of publication SELECT ?item ?itemLabel ?place ?coord ?publishing_date WHERE { VALUES ?type {wd:Q1261026 wd:Q732577} ?item wdt:P31 ?type. ?item wdt:P577 ?publishing_date. FILTER(?publishing_date > "1700-01-01"^^xsd:dateTime && ?publishing_date < "1799-12-31"^^xsd:dateTime)
VALUES ?place {wd:Q8692 wd:Q10313 wd:Q497801 wd:Q14318}
?item wdt:P291 ?place.
?place wdt:P625 ?coord.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
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 bd: <http://www.bigdata.com/rdf#>
# Work or printed material published in Vitoria-Gasteiz, Bilbao, Tolosa, Donostia-San Sebastián from 1799 to 1800 with date of publication
SELECT ?item ?itemLabel ?place ?coord ?publishing_date WHERE {
VALUES ?type {wd:Q1261026 wd:Q732577}
?item wdt:P31 ?type.
?item wdt:P577 ?publishing_date.
FILTER(?publishing_date > "1700-01-01"^^xsd:date && ?publishing_date < "1799-12-31"^^xsd:dat)
VALUES ?place {wd:Q8692 wd:Q10313 wd:Q497801 wd:Q14318}
?item wdt:P291 ?place.
?place wdt:P625 ?coord.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?coord"):::projected
v3("?item"):::projected
v4("?place"):::projected
v1("?publishing_date"):::projected
v2("?type")
c8(["bd:serviceParam"]):::iri
c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["?publishing_date > '1700-01-01^^xsd:date'?publishing_date < s1799-12-31^^<http://www.w3.org/2001/XMLSchema#dat>'"]]
f0 --> v1
bind1[/VALUES ?type/]
bind1-->v2
bind10(["wd:Q1261026"])
bind10 --> bind1
bind11(["wd:Q732577"])
bind11 --> bind1
v3 --"wdt:P31"--> v2
v3 --"wdt:P577"--> v1
bind2[/VALUES ?place/]
bind2-->v4
bind20(["wd:Q8692"])
bind20 --> bind2
bind21(["wd:Q10313"])
bind21 --> bind2
bind22(["wd:Q497801"])
bind22 --> bind2
bind23(["wd:Q14318"])
bind23 --> bind2
v3 --"wdt:P291"--> v4
v4 --"wdt:P625"--> v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end