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

~38 open requests for deletions.

SPARQL[edit]

  • A beginner-friendly course for SPARQL
  • Find category item with label different than sitelink
  • SELECT ?item ?itemDescription {
      ?item wdt:P31 wd:Q4167410; schema:description ?itemDescription .
      FILTER(LANG(?itemDescription) = 'en') .
      FILTER(REGEX(STR(?itemDescription), '^Wiki[pm]edia disambiguation page$') = false) .
    } LIMIT 100
    
    Try it!
  • 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!
  • SELECT ?item ?description {
      ?item wdt:P31 wd:Q4167410.
      ?item schema:description ?description .
      FILTER( LANG( ?description ) = 'en' && REGEX( STR( ?description ), 'Wikipedia disambiguation page' ) ) .
    } LIMIT 50000
    
    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 834376
Edits+Deleted 838986
Pages deleted 166371
Pages restored 649
Pages protected 7
Protections modified 1
Users blocked 29
Users reblocked 2
User rights modified 28
Wikidata statistics
Wikidata-logo.svg
  Number of pages 40,793,198  
  User total 2,885,962  
  Active users list 18,746  
  Administrators 53  
  Users/administrator 354