Untitled query #55130

SQL

#Items with missing Description in specific language
SELECT ?item ?itemdesc_en ?itemLabel_ar ?itemLabel_en ?title ?genre ?publication_date ?author 
WHERE {
  ?item wdt:P31 wd:Q13442814.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  OPTIONAL { ?item rdfs:label ?itemLabel_ar.    FILTER((LANG(?itemLabel_ar)) = "ar")  }
  OPTIONAL { ?item rdfs:label ?itemLabel_en.    FILTER((LANG(?itemLabel_en)) = "en")  }
  OPTIONAL { ?item schema:description ?itemdesc_en.    FILTER((LANG(?itemdesc_en)) = "en")  }
  OPTIONAL { ?item wdt:P1476 ?title. }
  OPTIONAL { ?item wdt:P136 ?genre. }
  OPTIONAL { ?item wdt:P577 ?publication_date. }
  OPTIONAL { ?item wdt:P50 ?author. }
  FILTER(NOT EXISTS {    ?item schema:description ?itemdesc.    FILTER((LANG(?itemdesc)) = "ar")  })
}
limit 1000
SQL

Checking query status...
