zhiwki: recently delete left talk page

SQL

USE zhwiki_p;
SELECT log_title, log_timestamp
FROM logging
LEFT JOIN page AS mainpage ON mainpage.page_title = logging.log_title AND mainpage.page_namespace = logging.log_namespace
LEFT JOIN page AS talkpage ON talkpage.page_title = logging.log_title AND talkpage.page_namespace = logging.log_namespace+1
WHERE log_action = "delete"
	AND log_namespace = 0
    AND mainpage.page_title IS NULL
    AND talkpage.page_title IS NOT NULL
	AND log_timestamp > DATE_FORMAT(NOW() - INTERVAL 30 DAY, '%Y%m%d%h%i%s')
GROUP BY log_title

SQL

Checking query status...