Untitled query #63531

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 archive on ar_actor=actor_id and ar_parent_id=0
/*AND Lc.log_timestamp>='20220318'*/
JOIN logging_logindex Ld ON Ld.log_namespace=ar_namespace and ld.log_title=ar_title 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...
