Павел

&filters=`parent:categories`

<?php
$q = $modx->newQuery('modResource', $id);
$q->leftJoin('TicketThread','TicketThread', "`TicketThread`.`name` = 'resource-{$id}'");
$q->leftJoin('TicketComment','TicketComment', "`TicketThread`.`id` = `TicketComment`.`thread`");
$q->where(array(
    'TicketComment.published' => 1
));

$q->select('COUNT(`TicketComment`.`id`) as `comments`');

$count = 0;
if ($q->prepare() && $q->stmt->execute()) {
	$count = (integer) $q->stmt->fetch(PDO::FETCH_COLUMN);
}
return $count;

[{"caption":"Image", "fields": 
  [
   {"field":"title","caption":"Заголовок"},
{"field":"description","caption":"Описание","inputTVtype":"textarea"},
      {"field":"img","caption":"Изображение","inputTVtype":"image", "sources":"[{\"MIGX_id\":\"1\",\"context\":\"web\",\"sourceid\":\"4\"}]"}
  ]
}]

[{"caption":"Image", "fields": 
  [
   {"field":"title","caption":"Заголовок"},
{"field":"description","caption":"Описание","inputTVtype":"textarea"},
      {"field":"img","caption":"Изображение","inputTVtype":"image"}
  ]
}]