TEST 8 - Quarry

SQL

#pip install sparqlwrapper
#https://rdflib.github.io/sparqlwrapper/

from SPARQLWrapper import SPARQLWrapper, JSON
sparql = SPARQLWrapper("https://query.wikidata.org/sparql")
sparql.setQuery("""SELECT DISTINCT ?item ?label ?sitelink WHERE {
  ?article schema:about ?item.
  ?article schema:isPartOf <https://ar.wikipedia.org/>.
  ?article schema:name ?sitelink.
  ?item rdfs:label ?label.
  ?item wdt:P31 wd:Q27020041.
  FILTER((LANG(?label)) = "ar")
  FILTER(?sitelink != ?label)
  FILTER("false"^^xsd:boolean = (CONTAINS(?sitelink, ")")))
}""")
sparql.setReturnFormat(JSON)
results = sparql.query().convert()

for result in results["results"]["bindings"]:
    print(result)
SQL

Checking query status...
