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
WHERE log_action='delete' AND log_namespace = 0
AND log_comment 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%'
AND log_comment NOT LIKE '%uygunsuz%' AND log_comment NOT LIKE '%8%' AND log_comment NOT LIKE '%üzen%'
GROUP BY title
ORDER BY deletions DESC
LIMIT 100

SQL

Checking query status...