query-cb723d145d7d599b9ef855469be12dfe

rq turtle/ttl

List of Gurdwaras with English Wikipedia articles, but Punjabi Wikipedia articles are missing

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX schema: <http://schema.org/>

SELECT ?item (COUNT(DISTINCT ?sitelink) AS ?count) WHERE {
  ?item ?itemLabel wdt:P31 wd:Q337986.
  ?sitelink schema:about ?item.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,pa". }
  FILTER(EXISTS {
    ?wen schema:about ?item.
    ?wen schema:inLanguage "en".
  })
  FILTER(NOT EXISTS {
    ?wfr schema:about ?item.
    ?wfr schema:inLanguage "pa".
  })
}
GROUP BY ?item ?itemLabel
ORDER BY DESC(?count)

Query found at