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.