Replicas browser and optimizer
This query is marked as a draft
This query has been published
Find articles that have only been edited by one human editor. Such articles have higher chances of requiring attention.
# Find articles that have only been edited by one human editor. Such articles have higher chances of requiring attention. USE enwiki_p; SELECT page_title, page_len, COUNT(rev_actor) FROM ( SELECT p.page_title, p.page_len, r.rev_actor, a.actor_name FROM ( SELECT page_title, page_len, page_id FROM page WHERE page_namespace = 0 # Mainspace AND NOT page_is_redirect ORDER BY page_len DESC LIMIT 100 # I want to remove this limit. But even as low as 200, execution gets killed by 30 minutes timeout ) AS p LEFT JOIN revision_userindex r ON r.rev_page = p.page_id LEFT JOIN actor a ON r.rev_actor = a.actor_id WHERE NOT IS_IPV4(a.actor_name) AND NOT IS_IPV6(a.actor_name) AND LOWER(a.actor_name) NOT LIKE '%script%' AND LOWER(a.actor_name) NOT LIKE '%bot%' # TODO LOWER does not seem to work, I see InternetArchiveBot and AnomieBOT passing. AND a.actor_name NOT LIKE '%Bot%' AND a.actor_name NOT LIKE '%BOT%' ) AS myalias GROUP BY (page_title) #HAVING COUNT(rev_actor) < 2 ORDER BY page_len DESC # Short article are usually disambiguation pages, with low chances of requiring attention.
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in