User:ValterVB

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). vec-0 Sta utensa cuà no ła ga nisun conosimento de ła łéngua vèneta (o ła capise co granda fadiga). This user is a member of WikiProject Italy.
Users by language

Requests for deletions

high

_{~154 open requests for deletions.}

Agenda

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

SPARQL

• A beginner-friendly course for SPARQL
• Find category item with label different than sitelink
• To check TV series: User:ValterVB/SPARQL
• Elenco ministri e presidenti del consiglio
• Elenco ministri e presidenti del consiglio (vers. 2)

• ?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 (Optimization for labels Link)

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!

• SELECT ?item WHERE { ?item schema:description "pagina di disambiguazione"@it. }
  

  Try it!

BOT

• My BOT: ValterVBot
• 200 000 000th edit
• User:ValterVBot/Task

Dirty Job

Label and description

• Label Description conflict

Candidates to delete

• Daily or more
  • User:Pasleim/notability
  • User:Pasleim/Items for deletion/Template
  • User:Pasleim/Items for deletion/Category
  • User:Pasleim/Items for deletion/Page deleted

• On demand - WDQ or ListeriaBot
  • User:ValterVB/Candidate to delete
  • Wikidata:Database reports/to delete/empty category items
  • Wikidata:Database reports/to delete/empty list items
  • Wikidata:Database reports/to delete/empty template items
  • Wikidata:Database reports/to delete/empty disambiguation items
  • Candidate to delete with WDQ

• Live update
  • * Special:ShortPages: must be <= 159 byte

Others

• Italian label with bracket
• User:Byrial/numbermerge/it-en: Merge candidates in it and en
• User:Byrial/numbermerge/it-fr: Merge candidates in it and fr
• User:Byrial/numbermerge/it-es: Merge candidates in it and es
• User:Byrial/numbermerge/it-de: Merge candidates in it and de
• User:YMS/RC
• User:ValterVB/Label
• User:ValterVB/Category
• User:XXN/items for categories without sitelinks
• Surname and disambiguation (max 100 item)
• P131 to add

Useful link

• Recent change
• Category:User warning templates: {{subst:Uw-link-removal1|Q...|plural}}.
• Wrong IMDb from my Bot
• Client/Lua
• interlink su it.wiki

Visual control of coordinates

SPARQL + Map

• Query Lombardia
• Query Piemonte
• Query Valle d'Aosta
• Query Trentino-Alto Adige
• Query Veneto
• Query Friuli-Venezia Giulia
• Query Liguria
• Query Emilia-Romagna
• Query Toscana
• Query Marche
• Query Umbria
• Query Lazio
• Query Abruzzo
• Query Campania
• Query Molise
• Query Puglia
• Query Basilicata
• Query Calabria
• Query Sicilia
• Query Sardegna

List of occupation for Bio infobox

User:ValterVB/Sandbox

Other

• 12 Angry Men (Q2345) Test case for film
• Giambattista Bodoni (Q220768) e Alberto Sordi (Q50003) Esempio di fonte per Web
• Esempio disambigue
  • Dempsey (Q1113495)
  • Deschamps (Q764080)
  • Diarra (Q1209175)
• Data set ISTAT

Stats

Admin statistics
Action	Count
Edits	889,661
Edits+Deleted	896,969
Pages deleted	205,002
Pages restored	1,548
Pages protected	12
Protections modified	2
Users blocked	44
Users reblocked	2
User rights modified	31

• Label and descriptions

Wikidata statistics
	Number of pages	119,584,883
	User total	6,716,463
	Active users list	24,652
	Administrators	73
	Users/administrator	338