query-4b4b1585043280d75c35e4cbba92595c

rq turtle/ttl

TODO

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT distinct ?item ?itemLabel ?countryLabel ?designation_countryLabel ?coords
 where {
 {
Select ?item  (count(?item) as ?count)          # this select gets us items with more than one country / heritage designation
               where {
  ?item wdt:P1435 ?designation.                 # item has a heritage designation
  ?item wdt:P17 ?country.                       # item has a country 
  ?designation wdt:P17 ?designation_country.    # the heritage designation has a country
  filter (?country!=?designation_country)       # the country of the heritage designation is not the listing country

} group by ?item  having (?count>1) }                            # this select finds properties of the items found in the last select
  ?item wdt:P1435 ?designation.                 # item has a heritage designation
  ?item wdt:P17 ?country.                       # item has a country 
  ?designation wdt:P17 ?designation_country.    # the heritage designation has a country 
  OPTIONAL {?item wdt:P625 ?coords.}            # item may have coordinates
  filter (?country!=?designation_country)       # the country of the heritage designation is not the listing country
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 } order by ?itemLabel ?countryLabel ?designationLabel

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2018/04