User:ValterVB
Jump to navigation
Jump to search
Babel user information | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
Users by language |
Requests for deletions high ~100 open requests for deletions. |
Agenda
[edit]- Pasqua 2018 Update of Wikidata:WikiProject Disambiguation pages/Wikisomething disambiguation page conflict
SPARQL
[edit]- 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. }
BOT
[edit]Dirty Job
[edit]Label and description
[edit]Candidates to delete
[edit]- Daily or more
- On demand - WDQ or ListeriaBot
- Live update
- * Special:ShortPages: must be <= 159 byte
Others
[edit]- 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
[edit]- 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
[edit]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
[edit]Other
[edit]- 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
[edit]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 |
Wikidata statistics | ||
---|---|---|
![]() | ||
Number of pages | 118,631,764 | |
User total | 6,613,993 | |
Active users list | 23,691 | |
Administrators | 74 | |
Users/administrator | 320 |