trwiki:Most speedy or requested deleted articles per notability by title

SQL

USE trwiki_p;
SELECT CONCAT('*[[',log_title,']]') AS title, COUNT(log_id) AS deletions
FROM logging JOIN comment ON comment_id=log_comment_id
WHERE log_action='delete' AND log_namespace = 0
AND comment_text LIKE '%Madde 6%' OR comment_text LIKE '%madde 6%' OR comment_text LIKE '%M6%' OR comment_text LIKE '%m6%' OR comment_text LIKE '%m 6%' OR comment_text LIKE '%M 6%' OR comment_text LIKE '%ayda değer%' OR comment_text LIKE '%nsiklopedik%' OR comment_text LIKE '%md 6%' OR comment_text LIKE '%Md 6%' OR comment_text LIKE '%addeler 6%'
AND comment_text NOT LIKE '%uygunsuz%' AND comment_text NOT LIKE '%8%' AND comment_text NOT LIKE '%üzen%' AND comment_text NOT LIKE 'hatali baslik ve ansiklopedik olmayan icerik nedeniyle hizli silme' AND comment_text NOT LIKE 'ansiklopedik olmayan başlık'
/*AND page_namespace=0*/
GROUP BY title
ORDER BY deletions DESC
LIMIT 500

SQL

Checking query status...