query-7ecc249ba7c90328a2e4818c08995c56

rq turtle/ttl

Chidgk1Pmt(Q85817274)Şırnak Silopi power station w:Category:Power stations in Turkey(Q8788931)Category:Power stations in Turkey

Use at

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

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?article_link ?instance_of ?instance_ofLabel
WHERE
{

{
  SELECT ?article_link ?site
  WHERE
  {

{
  SELECT ?title ?site ?language_code
  WHERE
  {
    ?category_link schema:about wd:Q8788931 . # Category:Power stations in Turkey (Q8788931)
    ?category_link schema:isPartOf ?site .
    ?category_link schema:inLanguage ?language_code .
    ?category_link schema:name ?category_title .
    BIND (STRBEFORE(STRAFTER(STR(?site), "https://"), "/") AS ?endpoint)
    BIND (CONCAT('deepcat:"', STRAFTER(?category_title, ':'), '"') AS ?search_string)
    SERVICE wikibase:mwapi
    {
      bd:serviceParam wikibase:api "Search" .
      bd:serviceParam wikibase:endpoint ?endpoint .
      bd:serviceParam mwapi:srnamespace "0" .
      bd:serviceParam mwapi:srsearch ?search_string  .
      ?title wikibase:apiOutput mwapi:title .
    }
  }
}    BIND (STRLANG(?title, ?language_code) AS ?title_with_language)
    ?article_link schema:name ?title_with_language .
  }
}  ?article_link schema:name ?title_with_language .
  ?article_link schema:isPartOf ?site .
  ?article_link schema:about ?item .
  OPTIONAL { ?item wdt:P31 ?instance_of . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,tr". }
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2020/07