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 revision r
#	(SELECT * FROM revision WHERE rev_user_text = 'XXN-bot' group by rev_page order by rev_timestamp DESC) AS r
JOIN page pg #on rev_page = page_id
#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 r.rev_page = pg.page_id/**/#r.rev_id=pg.page_latest
#JOIN pagelinks on page_id = pl_from AND pl_title = "Q4167410"
WHERE /*rev_page = 34706185*/
r.rev_timestamp > '20170801235959'#'20170701235959'
# rev_page = 25966450#134449 
and r.rev_user_text = 'XXN'
and r.rev_comment like "/* Removed link to%"
#AND r.rev_parent_id = 0
#BETWEEN 500 AND 1000#< 1000#
GROUP BY pg.page_title
#Limit 5
SQL

Checking query status...
