query-b1e0a34590cc6ddb6304697aab55047f

rq turtle/ttl

List items that are letters ("133492), order by number of statements

we should remove scholarly articles

Adapted from:

List items that have a Biografisch Portaal number (P651), but have fewer than 6 statements

The SPARQL database isn't completely up to date for the number of statements, so this query will return fewer or incorrect items.

SELECT ?item ?itemLabel ?itemDescription ?statementcount WHERE { ?item wdt:P31 wd:Q133492 . ?item wikibase:statements ?statementcount . MINUS { ?item wdt:P31 wd:Q13442814 . } FILTER (?statementcount > 6 ) SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,it,fr,es" . }
} ORDER BY DESC(?statementcount)

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 bd: <http://www.bigdata.com/rdf#>
# List items that are letters ("133492), order by number of statements
# we should remove scholarly articles
# Adapted from:
# List items that have a Biografisch Portaal number (P651), but have fewer than 6 statements
# The SPARQL database isn't completely up to date for the number of statements, so this query will return fewer or incorrect items.

SELECT ?item ?itemLabel ?itemDescription ?statementcount WHERE {
  ?item wdt:P31 wd:Q133492 .
  ?item wikibase:statements ?statementcount .
  MINUS {
    ?item wdt:P31 wd:Q13442814 . }
  FILTER (?statementcount > 6 )
    SERVICE wikibase:label {
        bd:serviceParam wikibase:language "en,de,it,fr,es" .
    }          
} ORDER BY DESC(?statementcount)

Query found at

• https://www.wikidata.org/wiki/User:Tranquillus/Queries