Transclusion count of recently edited modules

SQL

set @module_namespace := 828;

select
	concat('Module:', replace(rc_title, '_' , ' ')) as module,
    count(tl_from) as transclusions,
    date_format(rc_timestamp, '%Y-%m-%d %H:%i:%s') as most_recent_edit,
    recent_edit_count
from (
  	select rc_title, count(rc_id) as recent_edit_count, max(rc_timestamp) as rc_timestamp from recentchanges
    where rc_namespace = @module_namespace and rc_source = 'mw.edit'
  	and rc_timestamp >= date_add(now(), interval -7 days)
    group by rc_title
) as recently_edited_modules
left join templatelinks on tl_title = rc_title and tl_namespace = @module_namespace
group by rc_title
order by transclusions desc;

SQL

Checking query status...