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 log_comment LIKE '%madde 6%' OR log_comment LIKE '%M6%' OR log_comment LIKE '%m6%' OR log_comment LIKE '%m 6%' OR log_comment LIKE '%M 6%' OR log_comment LIKE '%ayda değer%' OR log_comment LIKE '%nsiklopedik%' OR log_comment LIKE '%md 6%' OR log_comment LIKE '%Md 6%' OR log_comment LIKE '%addeler 6%'
AND comment_text NOT LIKE '%uygunsuz%' AND log_comment NOT LIKE '%8%' AND log_comment NOT LIKE '%üzen%' AND log_comment NOT LIKE 'hatali baslik ve ansiklopedik olmayan icerik nedeniyle hizli silme' AND log_comment NOT LIKE 'ansiklopedik olmayan başlık'
/*AND page_namespace=0*/
GROUP BY title
ORDER BY deletions DESC
LIMIT 500

SQL

Checking query status...