User:MisterSynergy/misc/sitelink badges
Jump to navigation
Jump to search
Try it!
Try it!
Try it!
Try it!
Try it!
Try it!
MisterSynergy’s work lists
- rowing/queries
- rowing/P214 for rowers
- rowing/P3171 for rowers
- rowing/event participation
- rowing/unconnected pages
- badminton/queries
- tennis/queries
- sports/queries
- sports/P641 worklists
- sports/P1447 worklists
- sports/Olympics
- cultural heritage/Germany
- misc/linked deleted items
- misc/quantity data type
- misc/references
- misc/sitelink badges
- misc/unsorted worklists
Special:PrefixIndex/User:MisterSynergy/ • User:MisterSynergy/sysop/header • item statistics • patrol • pages with code • activity • jobs
Overview[edit]
- Wikimedia badge (Q17442550), Wikisource badge (Q75042035)
- Help:Badges, Help:Sitelinks#Badges, Wikidata:Glossary#Badges
- Template:Badge item
- Most bot frameworks and automation tools do not support badge editing. However, badge management can to some extent be automated with direct Mediawiki API calls; see wbsetsitelink for details.
List of badges[edit]
Statistical queries[edit]
General statistics of badge use[edit]
SELECT ?badge ?badgeLabel (COUNT(*) AS ?cnt) WHERE {
?sitelink wikibase:badge ?badge .
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
} GROUP BY ?badge ?badgeLabel
Badge use of a particular Wikimedia project[edit]
SELECT ?badge ?badgeLabel (COUNT(*) AS ?cnt) WHERE {
?sitelink schema:isPartOf <https://de.wikipedia.org/>; wikibase:badge ?badge .
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
} GROUP BY ?badge ?badgeLabel
Used badges by badge and Wikimedia project[edit]
SELECT ?project ?badgeLabel (COUNT(?sitelink) AS ?cnt) WHERE {
# available badges: wd:Q17437796 wd:Q17437798 wd:Q17559452 wd:Q17506997 wd:Q17580674 wd:Q51759403 wd:Q20748092 wd:Q20748091 wd:Q20748093 wd:Q20748094 wd:Q28064618
VALUES ?badge {
wd:Q17437796 wd:Q17437798 wd:Q17559452 wd:Q17506997 wd:Q17580674 wd:Q51759403 wd:Q20748092 wd:Q20748091 wd:Q20748093 wd:Q20748094 wd:Q28064618
}
?sitelink schema:isPartOf ?project; wikibase:badge ?badge .
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
} GROUP BY ?project ?badgeLabel ORDER BY ASC(?badgeLabel) DESC(?cnt)
Maintenance queries[edit]
Inappropriate use of wikisource badges[edit]
SELECT ?badge ?badgeLabel ?sitelink ?wikiGroup ?item WITH {
SELECT ?sitelink ?item ?badge WHERE {
VALUES ?badge { wd:Q28064618 wd:Q20748094 wd:Q20748093 wd:Q20748092 wd:Q20748091 }
?sitelink wikibase:badge ?badge; schema:about ?item .
}
} AS %subquery WHERE{
INCLUDE %subquery .
?sitelink schema:isPartOf/wikibase:wikiGroup ?wikiGroup .
FILTER(?wikiGroup != 'wikisource') .
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}
List badges on non-list items[edit]
Many of these cases could be okay or "okay". The issue here is that quite a lot of list articles are merged with a non-list item.
SELECT ?badge ?badgeLabel ?sitelink ?item WHERE {
VALUES ?badge { wd:Q51759403 wd:Q17506997 }
?sitelink wikibase:badge ?badge; schema:about ?item .
MINUS { ?item wdt:P31/wdt:P279* wd:Q13406463 }
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}
Portal badge on non-portal items[edit]
SELECT ?sitelink ?item WHERE {
?sitelink wikibase:badge wd:Q17580674; schema:about ?item .
MINUS { ?item wdt:P31/wdt:P279* wd:Q4663903 }
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}