Replicas browser and optimizer
This query is marked as a draft
This query has been published
use cswiki_p; select concat("Wikipedista:", page_title), page_len from page where page_title like "%/%" # Is a subpage and page_namespace=2 # Is in NS_USER and # Exclude autopatrolled, bots and sysops, they should know what they are doing replace(REGEXP_REPLACE(page_title, "/.*$", ""), "_", " ") not in (select user_name from user where user_id in (select ug_user from user_groups where ug_group in ("autopatrolled", "bot", "sysop"))) and # Exclude users with more than 1000 edits replace(REGEXP_REPLACE(page_title, "/.*$", ""), "_", " ") not in (select user_name from user where user_editcount>1000) and page_len>600 # Require non-trivial length and page_title not like "%.js" and page_title not like "%.css" # Exclude scripts order by page_len desc, page_title asc;
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