Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Jdx
.
POTY pages likely vandalized by anonymous users
Toggle Highlighting
SQL
# The query returns page names in "Translations" namespace (page_namespace=1198) and how many times each page has been edited # by anonymous users since given date. The more times given page has been edited, more likely it has been vandalized. USE commonswiki_p; #SELECT COUNT(*), MIN(img_size), MAX(img_size), AVG(img_size), STDDEV_POP(img_size) FROM image WHERE img_minor_mime='webp'; SELECT CONCAT('Translations:', page_title) AS 'Page title', DATE_FORMAT(rev_timestamp, '%Y-%m-%d %T') AS 'Date', COUNT(*) AS 'Edit count' FROM page INNER JOIN revision ON page_id=rev_page INNER JOIN ip_changes ON rev_id=ipc_rev_id WHERE page_namespace=1198 AND rev_timestamp>=20200213075600 AND page_title REGEXP 'Commons:Wiki_Loves_Folklore/(?:[0-9]+|Page_display_title)/' GROUP BY page_id ORDER BY rev_timestamp DESC, 2 DESC, 1 ASC;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...