# - Quarry

SQL

/*use enwiki_p;
SELECT p.page_title as title
FROM revision r
join page p on p.page_id=r.rev_page
WHERE p.page_namespace=14 and p.page_is_redirect=0 and r.rev_timestamp 
between 20180101000000 and 20180201000000
	and r.rev_parent_id=0
#GROUP BY r.rev_user_text
#ORDER BY COUNT(*) DESC
LIMIT 50;*/
select /* SLOW_OK */ count(rc_title),0 
from recentchanges 
join page 
on rc_cur_id=page_id 
where rc_new=1 
and rc_namespace=0 
and page_is_redirect=0 
and page.page_len>70 
and rc_deleted=0 
and DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY)<rc_timestamp;
SQL

Checking query status...
