TEST 8 - Quarry

SQL

USE wikidatawiki_p; 
SELECT CONCAT("Q",ips_item_id), CONCAT("Lar"), CONCAT('"',ips_site_page,'"')
FROM wb_items_per_site
WHERE ips_site_id='arwiki'  {
  ?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, ")")))
}`,
      fullUrl = endpointUrl + '?query=' + encodeURIComponent( sparqlQuery ),
      headers = { 'Accept': 'application/sparql-results+json' };

fetch( fullUrl, { headers } ).then( body => body.json() ).then( json => {
    const { head: { vars }, results } = json;
    for ( const result of results.bindings ) {
        for ( const variable of vars ) {
            console.log( '%s: %o', variable, result[variable] );
        }
        console.log( '---' );
    }
} );
SQL

Checking query status...
