check items by summary

SQL

USE wikidatawiki_p;
SELECT pg.page_title, r.rev_comment, r.rev_timestamp, r.rev_len, pg.page_len
FROM 
	(SELECT * FROM revision WHERE rev_user_text = 'XXN-bot' group by rev_page order by rev_timestamp DESC) AS r
JOIN #page on rev_page = page_id and page_len < 500 AND page_is_redirect = 0 AND page_namespace = 0
	(SELECT * FROM page WHERE page_len < 1000 AND page_is_redirect = 0 AND page_namespace = 0) AS pg 
    on rev_page = pg.page_id
#JOIN pagelinks on page_id = pl_from AND pl_title = "Q4167410"
WHERE /*rev_page = 34706185
r.rev_timestamp > '20170726235959'#'20170701235959'*/ 
r.rev_comment like "%clearing item to prepare for redirect"
#AND r.rev_parent_id = 0
#BETWEEN 500 AND 1000#< 1000#
#GROUP BY page_title
SQL

Checking query status...
