query-195e58120ef3decf1f47df76e56505fc

rq turtle/ttl

Propertiesinstance of (P31)performer (P175)language of work or name (P407)publication date (P577)

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 bd: <http://www.bigdata.com/rdf#>
SELECT
 ?album ?albumLabel
 ?performer ?performerLabel
 ?publication_date
 ?language_of_work_or_name ?language_of_work_or_nameLabel
WHERE {
  ?album wdt:P31 wd:Q482994; # Find all albums

  wdt:P175 ?performer; # and the performer's name
  wdt:P407 ?language_of_work_or_name; # and their language
  wdt:P577 ?publication_date; # and their publish date

  FILTER(?language_of_work_or_name = wd:Q1860) # where language is English
  FILTER(?publication_date >= "2012-01-01T00:00:00Z"^^xsd:dateTime) # published on or after 1-1-2012
  FILTER(?publication_date < "2013-01-01T00:00:00Z"^^xsd:dateTime) # published before 1-1-2013

  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; v3("?album"):::projected v2("?language_of_work_or_name"):::projected v4("?performer"):::projected v1("?publication_date"):::projected c10(["bd:serviceParam"]):::iri c12(["#91;AUTO_LANGUAGE#93;,en"]):::literal c5(["wd:Q482994"]):::iri f0[["?publication_date < '2013-01-01T00:00:00Z^^xsd:dateTime'"]] f0 --> v1 f1[["?publication_date >= '2012-01-01T00:00:00Z^^xsd:dateTime'"]] f1 --> v1 f2[["?language_of_work_or_name = 'wd:Q1860'"]] f2 --> v2 v3 --"wdt:P31"--> c5 v3 --"wdt:P175"--> v4 v3 --"wdt:P407"--> v2 v3 --"wdt:P577"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 end