All enwiki portal deletions mentioning "P2"

SQL

SELECT CONCAT('[[',CASE log_namespace WHEN -2 THEN 'Media:' WHEN -1 THEN 'Special:' WHEN 0 THEN ':' WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 4 THEN 'Wikipedia:' WHEN 5 THEN 'Wikipedia talk:' WHEN 6 THEN ':File:' WHEN 7 THEN 'File talk:' WHEN 8 THEN 'MediaWiki:' WHEN 9 THEN 'MediaWiki talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template talk:' WHEN 12 THEN 'Help:' WHEN 13 THEN 'Help talk:' WHEN 14 THEN ':Category:' WHEN 15 THEN 'Category talk:' WHEN 100 THEN 'Portal:' WHEN 101 THEN 'Portal talk:' WHEN 108 THEN 'Book:' WHEN 109 THEN 'Book talk:' WHEN 118 THEN 'Draft:' WHEN 119 THEN 'Draft talk:' WHEN 710 THEN 'TimedText:' WHEN 711 THEN 'TimedText talk:' WHEN 828 THEN 'Module:' WHEN 829 THEN 'Module talk:' WHEN 2300 THEN 'Gadget:' WHEN 2301 THEN 'Gadget talk:' WHEN 2302 THEN 'Gadget definition:' WHEN 2303 THEN 'Gadget definition talk:' ELSE CONCAT('{{ns:', log_namespace, '}}:') END,log_title,']]'),
	CASE log_user WHEN 0 THEN log_user_text ELSE user_name END AS username,
	log_timestamp,
	comment_text
FROM logging
	LEFT JOIN comment ON comment_id = log_comment_id
	LEFT JOIN user ON user_id = log_user
WHERE comment_text LIKE '%P2%'
	AND log_type = 'delete' AND log_action = 'delete'
ORDER BY log_timestamp ASC;
SQL

Checking query status...
