Алексей

{set $rows = json_decode(17 | resource : 'projects', true)}
{foreach $rows as $row}
    {$row.imgpro}{$row.loc}
{/foreach}

<?php
$tag = $_GET['tag'];

$key = 'tags'; // имя опции товара
$category = 0; // фильтрация по категории

$q = $modx->newQuery('msProductOption');
$q->innerJoin('msProduct', 'msProduct', 'msProduct.id=msProductOption.product_id');
$q->where(array('msProductOption.key' => $key, 'msProductOption.value'=> $tag));
$q->sortby('msProductOption.value','ASC');
$q->select('DISTINCT(msProductOption.value), msProduct.id');
$q->where(array('msProductOption.key' => $key));
if (!empty($category)) {
    $ids = $modx->getChildIds($category);
    $ids[] = $category;
    $q->innerJoin('msCategory', 'msCategory', 'msCategory.id=msProduct.parent');
    $q->where(array('msCategory.id:IN' => $ids));
}

$result = array();
if ($q->prepare() && $q->stmt->execute()) {
    while ($row = $q->stmt->fetch(PDO::FETCH_ASSOC)) {
    	$res['id'][] = $row['id'];
	}
	$result = implode(",", array_unique($res['id'])) ;
}

$params = array(
    'element' => 'msProducts',
    'includeThumbs' => '260x195',
    'parents' => 9,
    'limit' => 21,
    'tpl'=> 'tpl.msProducts.new',
    'ajaxMode' => 'default',
    'tplPageWrapper' => '@INLINE <ul class="pagination uk-pagination">{{+prev}}{{+pages}}{{+next}}</ul>',
    'tplPageActive' => '@INLINE <li class="uk-active"><span>{{+pageNo}}</span></li>',
    'resources' => $result
    );

$output = $modx->runSnippet('pdoPage', $params);
return $output;

<div id="pdopage">
    <div class="rows uk-child-width-1-3@s uk-grid-match" uk-grid>
        {'!Tags' | snippet}
    </div>
    
    <div class="uk-panel uk-panel-box uk-flex uk-flex-center">{'page.nav' | placeholder}</div>
</div>

<a class="tag tag[[+fontlevel]]" href="[[~26]]?tags=[[+tag]]" style="font-size:[[+fontsize]]px;">[[+tag]]</a>