enwiki: Transclusion count of the latest edited pages

SQL

set @interval = 24;  -- in hours

use enwiki_p;
select
	date_format(rc_timestamp, '%Y‑%m‑%d %H:%i:%s') as Edit_date,
	rc_namespace as Namespace,
    replace(rc_title, "_", " ") as Page_name,
    rc_user_text as User_name,
    rc_bot 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...