English Wikipedia @ Freddythechick:Database reports/PRODed articles with deletion logs/Configuration

<syntaxhighlight lang="sql">

SELECT

       page_title,
       count(log_id) AS entries,
       min(log_timestamp) AS firstdel,
       max(log_timestamp) AS lastdel,
       group_concat(
               log_timestamp," - ",log_comment,"
"
               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

</syntaxhighlight>

Crontab

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