Blank pages last edited by MalnadachBot

SQL

/*
Due to unknown reasons, MalnadachBot sometimes blanks a page but does not add {{Blanked IP talk}} on its Task 13 run.
This glitch corrects by itself after a short time.
This query can be used to detect such pages
*/
select CONCAT('[[User talk:', page_title, ']]') as user_talk -- format as wikilink so that it can be read by AWB 
from page
join revision r1 on rev_id = page_latest and rev_actor = 215006043 -- latest page edit is by MalnadachBot
join actor on actor_user is null and actor_name = page_title -- IP user and IP talk page
where page_namespace = 3 -- User talk namespace
and page_len = 0 -- page is blank
order by user_talk asc; -- Arrange in ascending order
SQL

Checking query status...
