Transclusion count of latest edited pages (nicely formatted)

SQL

set @interval = 2;  -- in hours

use ruwiki_p;
select
	date_format(rc_timestamp, '%Y‑%m‑%e %H:%i:%s') as Edit_date,
	rc_namespace as Namespace,
    case
    	when rc_namespace = 10 then 'Шаблон:' + replace(rc_title, "_", " ")
        else replace(rc_title, "_", " ")
    end as Page_name,
    rc_user_text as User_name,
    (
      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 rc_id desc

SQL

Checking query status...