query-5e9f4e55e152617eaca3e3bfbc2f9657

rq turtle/ttl

Propertiesaward received (P166)image (P18)country (P17)point in time (P585)instance of (P31)applies to part, aspect, or form (P518)

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Timeline
#
# Baum des Jahres
#
SELECT ?item ?itemLabel ?countryLabel ?year ?pic
WHERE 
{
  BIND(wd:Q3796486 AS ?pictype) #P31  botanische Illustration
  #BIND(wd:Q125191 as ?pictype) #P31  Fotografie
  BIND(wd:Q10884 as ?picpart)  #P518 betroffener Teil = Baum
  ?item wdt:P166 wd:Q167898.
  ?item p:P166 ?awardstatement.
  ?awardstatement pq:P17 ?country.
  ?awardstatement pq:P585 ?year.

  ?item p:P18 ?picstatement.
  ?picstatement ps:P18 ?pic.
  # ?picstatement pq:P31 ?pictype.
  ?picstatement pq:P518 ?picpart.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en". }
}
order by ?country ?year

Query found at

• https://www.wikidata.org/wiki/User:Looniverse/SPARQL