USE zhwiki_p;

SELECT log_title, log_timestamp, rd_from

FROM logging

LEFT JOIN page AS mainpage ON mainpage.page_title = logging.log_title AND mainpage.page_namespace = logging.log_namespace

LEFT JOIN redirect ON redirect.rd_title = logging.log_title

WHERE log_action = "delete"

    AND log_namespace = 0

    AND mainpage.page_title IS NULL

    AND rd_from IS NOT NULL

    AND log_timestamp > DATE_FORMAT(NOW() - INTERVAL 7 DAY, '%Y%m%d%h%i%s')

GROUP BY log_title