User subpages by nonautopatrolled in cswiki - used to filter articles in NS_USER

SQL

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 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="autopatrolled")) # Exclude autopatrolled, they should know what they are doing
and page_len>4000 # Require non-trivial length, we may decrease this number if it will be too big later...
and page_title not like "%.js" and page_title not like "%.css" # Exclude scripts
order by page_len, page_title
;

SQL

Checking query status...