query-ee3709770232989b11367d1179cf9242

rq turtle/ttl

TODO

Use at

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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
# tool: scholia
#defaultView:Timeline{"hide":["?argitaratze_data"]}
SELECT ?argitaratze_data ?itemLabelStart ?placeLabel ?year WHERE {
  VALUES ?type {
    wd:Q732577 wd:Q1261026
  }
  ?item wdt:P31 ?type;
    wdt:P577 ?argitaratze_data.
  FILTER((?argitaratze_data >= "1700-01-01"^^xsd:dat) && (?argitaratze_data <= "1799-12-31"^^xsd:dat))
  BIND(YEAR(?argitaratze_data) as ?year)
  VALUES ?place {wd:Q8692 wd:Q10313 wd:Q497801 wd:Q14318 wd:Q10282 wd:Q134674}  
  ?item wdt:P291 ?place.
  BIND(IF(STRLEN(?itemLabel) > 50, CONCAT(SUBSTR(?itemLabel, 1, 50),"…"), ?itemLabel) AS ?itemLabelStart)
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,eu".
    ?item rdfs:label ?itemLabel .
    ?place rdfs:label ?placeLabel .
  }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?argitaratze_data"):::projected v3("?item") v7("?itemLabel") v6("?itemLabelStart"):::projected v5("?place") v8("?placeLabel"):::projected v2("?type") v4("?year"):::projected c7(["bd:serviceParam"]):::iri c9(["#91;AUTO_LANGUAGE#93;,en,eu"]):::literal f0[["?argitaratze_data >= s1700-01-01^^<http://www.w3.org/2001/XMLSchema#dat>'?argitaratze_data <= s1799-12-31^^<http://www.w3.org/2001/XMLSchema#dat>'"]] f0 --> v1 bind1[/VALUES ?type/] bind1-->v2 bind10(["wd:Q732577"]) bind10 --> bind1 bind11(["wd:Q1261026"]) bind11 --> bind1 v3 --"wdt:P31"--> v2 v3 --"wdt:P577"--> v1 bind2[/"year-from-dateTime(?argitaratze_data)"/] v1 --o bind2 bind2 --as--o v4 bind3[/VALUES ?place/] bind3-->v5 bind30(["wd:Q8692"]) bind30 --> bind3 bind31(["wd:Q10313"]) bind31 --> bind3 bind32(["wd:Q497801"]) bind32 --> bind3 bind33(["wd:Q14318"]) bind33 --> bind3 bind34(["wd:Q10282"]) bind34 --> bind3 bind35(["wd:Q134674"]) bind35 --> bind3 v3 --"wdt:P291"--> v5 bind4[/"if(string-length(?itemLabel) > '50^^xsd:integer',concat(substring(?itemLabel,'1^^xsd:integer','50^^xsd:integer'),'…'),?itemLabel)"/] v7 --o bind4 bind4 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 v3 --"rdfs:label"--> v7 v5 --"rdfs:label"--> v8 end