Count of mainspace pages transcluding each RQ template

SQL

use enwiktionary_p;

select tl_title as template, count(*) as count from templatelinks
left join page on page_namespace = tl_namespace and page_title = tl_title
left join redirect on rd_from = page_id and rd_namespace = 10
where tl_from_namespace = 0 and tl_namespace = 10 and (tl_title like "RQ:%" and tl_title not like "%/documentation")
-- Filter out redirects. For instance, Template:RQ:KJV is a redirect to RQ:King_James_Version,
-- and a page that transcludes it will also transclude its redirect target.
and rd_title is NULL
group by template
order by count desc;

SQL

Checking query status...