query-60c1df0c6df241536f5d515084464c5b

rq turtle/ttl

Sister cities whose Wikidata IDs represent adjacent numbers SELECT ?city1 ?city1Label ?id1 ?id2 ?city2 ?city2Label ?diff WITH { SELECT ?city1 ?id1 ?id2 ?city2 ?diff WHERE { ?city1 wdt:P190 ?city2. # sister cities bind(xsd:integer(substr(str(?city1),33)) as ?id1) # get the numeric element of the QID, cast as an integer bind(xsd:integer(substr(str(?city2),33)) as ?id2) # get the numeric element of the QID, cast as an integer bind(abs(?id1 - ?id2) as ?diff ) filter(?diff =1) } } AS %cities WHERE { INCLUDE %cities 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 bd: <http://www.bigdata.com/rdf#>
#Sister cities whose Wikidata IDs represent adjacent numbers
SELECT ?city1 ?city1Label ?id1 ?id2 ?city2 ?city2Label ?diff
WHERE 
{
   {
  SELECT ?city1 ?id1 ?id2 ?city2 ?diff WHERE {
    ?city1 wdt:P190 ?city2.         # sister cities
    bind(xsd:integer(substr(str(?city1),33)) as ?id1) # get the numeric element of the QID, cast as an integer
    bind(xsd:integer(substr(str(?city2),33)) as ?id2) # get the numeric element of the QID, cast as an integer
    bind(abs(?id1 - ?id2) as ?diff )
    filter(?diff =1)
  }
}  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

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