Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
85267 - Edits to certain pages by category
by
Red Director
This query is marked as a draft
This query has been published
by
Red Director
.
Toggle Highlighting
SQL
set @id = 67591586; SELECT page_title,MAX(rev_timestamp),page_latest, COUNT(page_title) AS count, ( SELECT pa_class FROM page_assessments WHERE pa_page_id = page_id AND pa_class != 'Unknown' LIMIT 1 ) AS pa_class FROM page JOIN revision_userindex ON page_id = rev_page JOIN categorylinks ON page_id = cl_from WHERE rev_actor = 100613 AND page_namespace = 0 -- Comment out the BETWEEN line if you want all-time stats. Date format is YYYYMMDDHHMMSS -- You can also scan edits *after* a date (instead of between two dates) by using: -- AND rev_timestamp > 20200101000000 AND rev_timestamp BETWEEN 20040101000000 AND 20241231125959 AND page_is_redirect = 0 AND cl_to = 'National_Football_League_teams' AND pl_from= @id GROUP BY page_namespace, page_title ORDER BY count DESC LIMIT 10000
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...