User:Crazy1880

Babel user information
de-N Dieser Benutzer spricht Deutsch als Muttersprache. en-3 This user has advanced knowledge of English. nl-0 Deze gebruiker heeft geen kennis van het Nederlands (of begrijpt het met grote moeite).
Users by language

Moin Moin. Besucht mich in der deutschen Wikipedia. --Crazy1880 (talk) 17:14, 8 July 2013 (UTC)

Wikidata statistics
	Number of pages	114,384,932
	User total	6,440,850
	Active users list	25,016
	Administrators	71
	Users/administrator	352

JavaSkripte

• User:Crazy1880/autoEditLists.js

Tools

• Persondata
• Database Reports

Query

SELECT ?item ?en_description {
  ?item wdt:P31 wd:Q13442814; schema:description ?en_description .
  FILTER( LANG( ?en_description ) = 'en' ) .
  OPTIONAL {
    ?item schema:description ?de_description .
    FILTER( LANG( ?de_description ) = 'de' ) .
  } .
  FILTER( !BOUND( ?de_description ) ) .
}
LIMIT 100

Try it!

SELECT ?item ?itemLabel WHERE 
{
  SERVICE bd:slice {
    ?article schema:isPartOf <https://de.wikipedia.org/> .       
    bd:serviceParam bd:slice.offset 0 . # Start at item number (not to be confused with QID)
    bd:serviceParam bd:slice.limit 70000 . # List this many items
  }
   ?article schema:about ?item .
   optional {?item rdfs:label ?itemLabel . filter(lang(?itemLabel)="de") }
   FILTER NOT EXISTS {?item schema:description ?itemDescription . filter(lang(?itemDescription)="de") }
   FILTER NOT EXISTS { ?item wdt:P31/wdt:P279* wd:Q4167836 . hint:Prior hint:gearing "forward". }
   FILTER NOT EXISTS { ?item wdt:P31 wd:Q11266439 .}
   FILTER NOT EXISTS { ?item wdt:P31 wd:Q15184295 .}
   FILTER NOT EXISTS { ?item wdt:P31 wd:Q11753321 .}
   FILTER NOT EXISTS { ?item wdt:P31 wd:Q17633526 .}
   FILTER NOT EXISTS { ?item wdt:P31 wd:Q19887878 .}
}
ORDER BY ASC(?itemLabel)

Try it!