<?php
ini_set('display_errors', 1);
$q = $modx->newQuery('modTemplate', array(
"resource.published" => 1,
"resource.deleted" => 0,
));
$q->innerJoin('modResource', 'resource', "resource.template = modTemplate.id");
$alias = $q->getAlias();
$q->select(array(
"{$alias}.id",
"uri",
"templatename as name",
"pagetitle",
"resource.id as resource_id",
"count(*) as `total`",
));
$q->groupby("{$alias}.id");
$base_url = $modx->getOption('base_url');
foreach($modx->getIterator('modTemplate', $q) as $object){
print "<br /><a href='{$base_url}{$object->uri}' target='_blank'>{$object->name} ({$object->id}) / {$object->pagetitle} ({$object->resource_id}) / {$object->total} документов</a>";
}