Выборка ресурсов с TV-параметрами

<?php
$q = $modx->newQuery('modResource');
$q->leftJoin('modTemplateVarResource', 'Price', 'modResource.id = Price.contentid AND Price.tmplvarid = 14');
$q->leftJoin('modTemplateVarResource', 'Currency', 'modResource.id = Currency.contentid AND Currency.tmplvarid = 15');
$q->groupby('modResource.id');

$q->select([
    'modResource.*',
    '`Price`.`id` AS `Price_id`, `Price`.`tmplvarid` AS `Price_tmplvarid`, `Price`.`contentid` AS `Price_contentid`, `Price`.`value` AS `Price_value`',
    '`Currency`.`id` AS `Currency_id`, `Currency`.`tmplvarid` AS `Currency_tmplvarid`, `Currency`.`contentid` AS `Currency_contentid`, `Currency`.`value` AS `Currency_value`',
    'IFNULL(`Price`.`value`, 0) AS `Price_value`',
    'IFNULL(`Currency`.`value`, "RUB") AS `Currency_value`'
]);

$q->where([
    [
        'Price.value:!=' => 0,
        'Price.value:IS NOT' => NULL
    ], [
        'Currency.value' => 'RUB',
        'OR:Currency.value:IS' => NULL
    ]
]);

$count = $modx->getCount('modResource', $q);
$q->limit(100);
if ($q->prepare() && $q->stmt->execute()) {
	$resources = $q->stmt->fetchAll(PDO::FETCH_ASSOC);
}

echo  "<p>Всего ресурсов найдено: {$count}</p><hr>";
foreach($resources as $resource) {
    echo "<p><b>{$resource['pagetitle']} ({$resource['id']})</b> -
    {$resource['Price_value']} {$resource['Currency_value']}</p>";
}