query-6c57ca64fadd06fb595a0dc53d512706
All Humans with less than 6 statements linked with Odia Wikipedia SELECT ?item ?linkcount ?statementCount ?itemLabel ?itemDescription ?article WHERE { VALUES (?project ?maxStatementCount ?labelLanguage) { (https://or.wikipedia.org/6 "or") # adjust language and count here # URL above must be https:// and include the trailing / ! } ?item wdt:P31 wd:Q5 . # item = humans only ?article a schema:Article; schema:about ?item; schema:isPartOf ?project. ?item wikibase:statements ?statementCount. FILTER(?statementCount < ?maxStatementCount). OPTIONAL { ?item rdfs:label ?itemLabel. FILTER(LANG(?itemLabel) = ?labelLanguage). } OPTIONAL { ?item wikibase:sitelinks ?linkcount. } # for counting sitelinks SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } # for generating label } ORDER BY ASC (?statementCount) LIMIT 123
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
# All Humans with less than 6 statements linked with Odia Wikipedia
SELECT ?item ?linkcount ?statementCount ?itemLabel ?itemDescription ?article WHERE {
VALUES (?project ?maxStatementCount ?labelLanguage) {
(<https://or.wikipedia.org/>6 "or") # adjust language and count here
# URL above must be https:// and include the trailing / !
}
?item wdt:P31 wd:Q5 . # item = humans only
?article a schema:Article;
schema:about ?item;
schema:isPartOf ?project.
?item wikibase:statements ?statementCount.
FILTER(?statementCount < ?maxStatementCount).
OPTIONAL { ?item rdfs:label ?itemLabel.
FILTER(LANG(?itemLabel) = ?labelLanguage). }
OPTIONAL { ?item wikibase:sitelinks ?linkcount. } # for counting sitelinks
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } # for generating label
}
ORDER BY ASC (?statementCount)
LIMIT 123