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

SQL

SELECT 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", comment_text AS "Edit summary"
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
 /*AND Lc.log_timestamp>='20220318'*/
JOIN logging_logindex Ld ON Ld.log_page=Lc.log_page AND Ld.log_type='delete' AND Ld.log_action='delete'
JOIN comment_logging ON comment_id=Ld.log_comment_id AND comment_text LIKE "%BLPPROD%"
WHERE ug_group='autoreviewer'
ORDER BY Lc.log_timestamp

SQL

Checking query status...