This user is an administrator on Wikidata.

User:ValterVB

From Wikidata
Jump to navigation Jump to 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).
Flag of Italy.svgThis user is a member of
WikiProject Italy.
Wikidata mop.svgThis user is an administrator on Wikidata. (verify)
Users by language


Requests for deletions

medium

63 open requests for deletions.

Agenda[edit]

Pasqua 2018 Update of Wikidata:WikiProject Disambiguation pages/Wikisomething disambiguation page conflict

SPARQL[edit]


  • ?item schema:description ?descriptionEn FILTER (LANG (?descriptionEn) = "en") . useful to have a description in a specific language
  • Subquery to try to avoid time out fot service label
select distinct ?prop ?propLabel {
  { SELECT DISTINCT ?prop {
   ?item (p:P1766|p:P41|p:P4004) [?qual []] .
   ?prop wikibase:qualifier ?qual .
  } LIMIT 1 }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

  • 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 881978
Edits+Deleted 888269
Pages deleted 199903
Pages restored 1529
Pages protected 10
Protections modified 2
Users blocked 40
Users reblocked 2
User rights modified 31
Wikidata statistics
Wikidata-logo.svg
  Number of pages 54,621,336  
  User total 3,029,167  
  Active users list 20,039  
  Administrators 60  
  Users/administrator 334