Wikidata:WikiProject Kosovo/Maintenance Queries

SPARQL queries

# Kosovo citiziens that have an article in EN or DE wiki but not in SQ
SELECT ?item ?itemLabel (COUNT(distinct ?article) as ?count)
{
    {
        SELECT ?item
        {
            {
                hint:Query hint:optimizer "None" .   
                ?item wdt:P31 wd:Q5  .
                ?item wdt:P27 wd:Q1246 .
                MINUS {?sitelinksq schema:about ?item . ?sitelinksq schema:isPartOf <https://sq.wikipedia.org/>}
            }
          ?article schema:about ?item .
              {
            ?article schema:isPartOf <https://de.wikipedia.org/>
              }
             UNION 
              {
            ?article schema:isPartOf <https://en.wikipedia.org/>
              }
        }
    }
    ?article schema:about ?item .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de" }
}
GROUP BY ?item ?itemLabel
ORDER BY DESC(?count)

Try it!

---

# This query shows all the Kosovo people whose label is missing

SELECT ?person ?item ?itemLabel ?itemDescription WHERE {
 ?item wdt:P31 wd:Q5.  
 ?item wdt:P27 wd:Q1246.

SERVICE wikibase:label { bd:serviceParam wikibase:language "en, sq". }
 FILTER(NOT EXISTS {
   ?item rdfs:label ?lang_label.
   FILTER(LANG(?lang_label) = "sq") 
 })
}
ORDER BY ?itemLabel

Try it!

Petscan queries

• Disambiguation pages on sqwiki that are not marked as disambiguation on wikidata. If a sqwiki article is not marked as disambiguation (instance of (P31)=Wikimedia disambiguation page (Q4167410)) on wikidata, it is either because it is linked to non-disambiguations on another wikis, or the disambiguation page is not linked at all to other wikis through wikidata.
• Disambiguation pages on sqwiki not associated with an item on wikidata. Try to find similar articles on other wikis. If you can't find any, create a new wikidata item with instance of (P31) set to Wikimedia disambiguation page (Q4167410).
• Biographies that are available only on sqwiki and lack English label on wikidata. Add the name in English for these people, so that they can be found by the users that use English on wikidata.