Jump to content

Wikipedia:Database reports/PRODed articles with deletion logs/Configuration

From Wikipedia, the free encyclopedia
SELECT
        page_title,
        count(log_id) AS entries,
        min(log_timestamp) AS firstdel,
        max(log_timestamp) AS lastdel,
        group_concat(
                log_timestamp," - ",log_comment,"<br>"
                ORDER BY log_timestamp ASC
                SEPARATOR " "
                      ) as log
FROM
        categorylinks,page,logging_logindex
WHERE
        cl_from=page_id
AND
        cl_to="All_articles_proposed_for_deletion"
AND
        page_title=log_title
AND
        log_type="delete"
AND
        log_action="delete"
AND
        log_namespace=0
GROUP BY
        page_id
LIMIT 500

Crontab

[edit]
30 06,18 * * * /usr/bin/jsub -N cron-tools.database-reports-2 -quiet python /data/project/database-reports/reports/database-reports/main.py en deleted_prods