This query is marked as a draft This query has been published by Certes.

SQL

AخA
 
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 AND Lc.log_timestamp>='20220318'
JOIN logging_logindex Ld ON Lc.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'
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...