Jeeputer - fawiki Times deleted leaderboard

Fork of Times deleted leaderboard on English Wiktionary by Erutuon

This query is marked as a draft This query has been published by Jeeputer.

SQL

select
	CONCAT('[[', IF(log_namespace = 14, ':', ''), IF(log_namespace = 6, ':', ''), IF(log_namespace > 0, CONCAT('{{جا:فن:', log_namespace, '}}'), ''), IF(log_namespace > 0, ':', ''), REPLACE(log_title,'_',' '), ']]') as 'عنوان',
    CONCAT('{{جا:فن:',log_namespace,'}}') as 'فضای نام',
    CONCAT('{{جا:آرایش‌عدد:',count(*),'}}') as 'دفعات حذف',
    if(exists(select 1 from page where page_namespace = log_namespace and page_title = log_title),
      '{{جا:آری|بله}}',
      '{{جا:نه|خیر}}') as 'موجود'
from logging
where log_type = 'delete' and log_action = 'delete'
group by log_namespace, log_title
order by count(*) desc
limit 100;

SQL

Checking query status...