ValterVB

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.

Requests for deletions

high

_{~156 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

Dirty Job

Label and description

Label Description conflict

Candidates to delete

Daily or more

On demand - WDQ or ListeriaBot

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
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,727,632
	User total	6,731,030
	Active users list	24,761
	Administrators	73
	Users/administrator	339