MODX count number of times a template is used

modx_site_templates.sql

SELECT a.id, a.templatename, COUNT(b.id) as resources FROM modx_site_templates AS a
LEFT JOIN modx_site_content AS b ON a.id = b.template AND b.published = 1 AND b.deleted = 0
WHERE b.id IS NOT NULL
GROUP BY a.id;

modx_site_tmplvars.sql

SELECT a.id, a.type, a.name, COUNT(c.id) FROM modx_site_tmplvars a
LEFT JOIN modx_site_tmplvar_contentvalues b ON a.id = b.tmplvarid
LEFT JOIN modx_site_content c ON b.contentid = c.id AND c.published = 1 AND c.deleted = 0
WHERE c.id IS NOT NULL
GROUP BY a.id