SQL
AخA
SELECT CONCAT('[[Portal:',log_title,']]'),
CASE log_user WHEN 0 THEN log_user_text ELSE user_name END AS username,
log_timestamp,
comment_text
FROM logging_logindex
LEFT JOIN comment ON comment_id = log_comment_id
LEFT JOIN user ON user_id = log_user
WHERE (comment_text LIKE '%P2%' OR comment_text LIKE '%p2%')
AND log_type = 'delete' AND log_action = 'delete'
AND log_namespace = 100
ORDER BY log_timestamp ASC;
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.