Transclusion count of recently edited modules

SQL

set @module_namespace := 828;

/*
select count(tl_from)
from templatelinks
where tl_namespace = @moduleNamespace
and tl_title in (select
	-- page_id ,
    -- distinct rc_title as module,
    -- date_format(rc_timestamp, '%Y-%m-%d %H:%i:%s') as time
from recentchanges
inner join page on page_title = rc_title and page_namespace = rc_namespace
where rc_namespace = @module_namespace)
group by tl_from
-- order by rc_timestamp asc
-- limit 100; */

select
	concat('Module:', rc_title) as module,
    count(tl_from) as transclusions
from (
	select distinct rc_title from recentchanges where rc_namespace = @module_namespace and rc_source = 'mw.edit'
) as recently_edited_modules
left join templatelinks on tl_title = rc_title and tl_namespace = @module_namespace
group by rc_title;
SQL

Checking query status...
