Articles created by autopatrolled in the last year, deleted as BLPPROD

SQL

SELECT COUNT(*) /*Lc.log_title AS "Title created", Lc.log_timestamp AS "Time created", actor_name AS "Editor created",
       Ld.log_title AS "Title deleted", Ld.log_timestamp AS "Time deleted"*/
FROM user_groups
JOIN actor_logging ON actor_user=ug_user
JOIN logging_userindex Lc ON Lc.log_actor=actor_id AND Lc.log_type='create' AND Lc.log_action='create' AND Lc.log_namespace=0
/*JOIN logging_logindex Ld ON Lc.log_page=Lc.log_page AND Lc.log_type='delete' AND Lc.log_action='delete'
JOIN comment_logging ON comment_id=Ld.log_comment_id AND comment_text LIKE "%BLPPROD%"*/
WHERE ug_group='autoreviewer'

SQL

Checking query status...