Transclusion count of latest edited pages (nicely formatted)

SQL

set @interval = 24;  -- in hours

use ruwiki_p;
select
	date_format(rc_timestamp, '%Y‑%m‑%e %H:%i:%s') as Edit_date,
    case
    	when rc_namespace = 10 then concat('Шаблон:', replace(rc_title, "_", " "))
        when rc_namespace = 828 then concat('Модуль:', replace(rc_title, "_", " "))
        when rc_namespace = 4 then concat('Википедия:', replace(rc_title, "_", " "))
        when rc_namespace = 104 then concat('Проект:', replace(rc_title, "_", " "))
        when rc_namespace = 100 then concat('Портал:', replace(rc_title, "_", " "))
        when rc_namespace = 2 then concat('Участник:', replace(rc_title, "_", " "))
        when rc_namespace = 0 then replace(rc_title, "_", " ")
        else concat('{{ns:', rc_namespace, '}}:', replace(rc_title, "_", " "))
    end as Page_name,
    rc_user_text as User_name,
    if(rc_bot, "Yes", "No") as Is_bot,
    rc_comment as Edit_summary,
    (
      select count(*) from templatelinks
      where templatelinks.tl_title = recentchanges.rc_title and templatelinks.tl_namespace = recentchanges.rc_namespace
    ) as Transclusion_count
from recentchanges
where (rc_type = 0 or rc_type = 1)  -- edit or new
	and rc_timestamp > now() - interval @interval hour + 0
having Transclusion_count > 0
order by Transclusion_count desc
SQL

Checking query status...
