query-7972c7958ff4fb627b1b0233bc6870d4

rq turtle/ttl

Artisti con opere alla Certosa di Bologna senza voce su it.wiki, e n. voci in altre lingue o progetti Wikimedia SELECT ?item ?itemLabel ?cnt WHERE { { SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE { ?item wdt:P31 wd:Q5 . ?item wdt:P6379 wd:Q3671680 . ?sitelink schema:about ?item . FILTER NOT EXISTS { ?article schema:about ?item . ?article schema:isPartOf https://it.wikipedia.org/ . #Targeting Wikipedia language where subjects has no article. } } GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 1000 #Sorted by amount of articles in other languages. Result limited to 1000 lines to not have a timeout error. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,it,es,de" } #Service to resolve labels in (fallback) languages: automatic user language, English, French, Spanish, German. } ORDER BY DESC (?cnt)

Use at

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

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#>
#Artisti con opere alla Certosa di Bologna senza voce su it.wiki, e n. voci in altre lingue o progetti Wikimedia
SELECT ?item ?itemLabel ?cnt WHERE {
{
  SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE { 
  ?item wdt:P31 wd:Q5 .
  ?item wdt:P6379 wd:Q3671680 .
  ?sitelink schema:about ?item .
  FILTER NOT EXISTS {
    ?article schema:about ?item .
    ?article schema:isPartOf <https://it.wikipedia.org/> . #Targeting Wikipedia language where subjects has no article.
  }
  } GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 1000 #Sorted by amount of articles in other languages. Result limited to 1000 lines to not have a timeout error.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,it,es,de" }  #Service to resolve labels in (fallback) languages: automatic user language, English, French, Spanish, German.
} ORDER BY DESC (?cnt)

Query found at

• https://www.wikidata.org/wiki/User:Una_tantum