User:ValterVB

From Wikidata
Jump to: navigation, search

it:Utente:ValterVB

Babel user information
it-N Questo utente può contribuire con un livello madrelingua in italiano.
en-2 This user has intermediate knowledge of English.
fr-0 Cet utilisateur n’a aucune connaissance en français (ou le comprend avec de grandes difficultés).
es-0 Este usuario no tiene ningún conocimiento del español (o lo entiende con mucha dificultad).
de-0 Dieser Benutzer beherrscht Deutsch nicht (oder versteht es nur mit beträchtlichen Schwierigkeiten).
Wikidata mop.svg This user is an administrator on Wikidata. (verify)
Users by language


Requests for deletions

low

~31 open requests for deletions.

SPARQL[edit]

  • A beginner-friendly course for SPARQL
  • Find category item with label different than sitelink
  • SELECT ?item ?itemLabel ?istLabel ?admin ?adminLabel ?adminDescription ?start ?end WHERE {
      VALUES ?admin { wd:Q16287 wd:Q18288162 wd:Q426025 wd:Q28769238 wd:Q2567535}
      ?item wdt:P31 ?ist .
      ?stat ps:P131 ?admin.
      ?item p:P131 ?stat; #The trick is the semicolon
      OPTIONAL { ?stat pq:P580 ?start. }
      OPTIONAL { ?stat pq:P582 ?end. }
      SERVICE wikibase:label { bd:serviceParam wikibase:language "it". }
    } ORDER BY ?item ?start
    
    Try it!
  • SELECT ?item ?itDescrizione WITH {
      SELECT ?item {
        BIND( 1000000 * 30 AS ?base ) . # change this 0-30
        ?item wdt:P31 wd:Q4167836 .
        BIND( xsd:integer( STRAFTER( STR( ?item ), STR( wd:Q ) ) ) AS ?num ) .
        FILTER( ?num > ?base + 0 && ?num < ?base + 1000001 ) .
      }
    } AS %sub WHERE {
      INCLUDE %sub .
      ?item schema:description ?itDescrizione FILTER( LANG( ?itDescrizione ) = 'it' ) .
      FILTER( STR( ?itDescrizione ) != 'categoria di un progetto Wikimedia' ) .
    }
    
    Try it!

BOT[edit]

Dirty Job[edit]

Label and description[edit]

Candidates to delete[edit]

Others[edit]

Useful link[edit]

Visual control of coordinates[edit]

SPARQL + Map

List of occupation for Bio infobox[edit]

User:ValterVB/Sandbox

Other[edit]

Stats[edit]

Admin statistics
Action Count
Edits 813626
Edits+Deleted 817697
Pages deleted 108801
Pages restored 550
Pages protected 5
Protections modified 1
Users blocked 18
Users reblocked 1
User rights modified 26
Wikidata statistics
Wikidata-logo.svg
  Number of pages 27,854,330  
  User total 2,820,106  
  Active users list 17,517  
  Administrators 54  
  Users/administrator 324