User:AvatarFR
Jump to navigation
Jump to search
SELECT ?item ?itemLabel ?cnt WHERE {
{
SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE {
?item wdt:P31 wd:Q5 .
?item wdt:P21 wd:Q6581072 .
?item wdt:P27 wd:Q142 .
?item wdt:P106 wd:Q36834 .
?sitelink schema:about ?item .
FILTER NOT EXISTS {
?article schema:about ?item .
?article schema:isPartOf <https://fr.wikipedia.org/> . #Targeting Wikipedia language where subjects has no article.
}
} GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 100 #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,es,de" } #Service to resolve labels in (fallback) languages: automatic user language, English, French, Spanish, German.
} ORDER BY DESC (?cnt)