Prodded articles that have been previously deleted

SQL

/*
        previously_deleted_prods.sql

        Identify articles currently proposed for deletion which have
        actually been deleted in the past.

        Author:  Andrew Crawford (thparkth) <acrawford@laetabilis.com>

        License: Public Domain
*/

use enwiki_p;

SELECT
        page_title,
        COUNT(log_timestamp) AS times_deleted,
        min(log_timestamp) AS first_deletion,
        max(log_timestamp) AS last_deletion
FROM
        page
JOIN
        logging_logindex
ON
        log_page=page_id
JOIN
        categorylinks
ON
                cl_from=page_id
        AND
                cl_to="All_articles_proposed_for_deletion"
WHERE
                log_type="delete"
        AND
                log_namespace=0
        AND
                log_action="delete"
GROUP BY
        page_title
LIMIT 500
;
SQL

Checking query status...
