Василий Наумкин

<?php
$currentID = $modx->resource->id;
$parentID = $modx->resource->parent;
$delimeter = ' , ';
$scheme = $modx->getOption('link_tag_scheme');

$q = $modx->newQuery('msCategory');
$q->leftJoin('msCategoryMember', 'msCategoryMember', array(
	'`msCategory`.`id` = `msCategoryMember`.`category_id`'
));
$q->sortby('pagetitle','ASC');
$q->select(array('id','pagetitle'));
$q->where('`msCategoryMember`.`product_id` = '.$currentID.' OR `id` = '.$parentID);

$result = array();
if ($q->prepare() && $q->stmt->execute()) {
	while ($row = $q->stmt->fetch(PDO::FETCH_ASSOC)) {
		$url = $modx->makeUrl($row['id'], '', '', $scheme);
		$result[] = '<a href="'.$url.'">'.$row['pagetitle'].'</a>';
	}
}

return implode($delimeter, $result);

[[!getTicketsSections?
	&parents=`0`
	&tpl=`tpl.Blogs.sections.row`
	&includeTVs=`my_image`
]]

<img src="[[+my_image:phpthumbof=`h=180&w=196`]]" width="196" height="180"  alt="[[+pagetitle]]" title="[[+pagetitle]]" />