tracersani

<?php
if (empty($id)) {$id = $modx->resource->id;}
if (empty($tpl)) {$tpl = '@INLINE <a href="{$_modx->makeUrl($id)}" class="tag">{$TV_NAME ?: $pagetitle}</a>';}
$pdo = $modx->getService('pdoFetch');

$conditions = array('product_id' => $id);
$options = array(
	'innerJoin' => array(
		'msCategory' => array('on' => 'msCategoryMember.category_id = msCategory.id'),
	),
	'leftJoin' => array(
		'tvtitle' => array(
			'class' => 'modTemplateVarResource', 
			'on' => 'tvtitle.contentid = msCategoryMember.category_id AND tvtitle.tmplvarid = 6'
		),
	),
	'select' => array(
		'msCategory' => 'all',
		'tvtitle' => 'IFNULL(tvtitle.value, "") AS TV_NAME',
	),
	'groupby' => 'msCategory.id',
	'sortby' => 'msCategory.id',
);
$rows = $pdo->getCollection('msCategoryMember', $conditions, $options);

$output = '';
foreach ($rows as $row) {
	$output .= $pdo->getChunk($tpl, $row);
}

return $output;