Андрей Сухомозгий

<?php
$key = 'tags'; // имя опции товара
$category = 0; // фильтрация по категории
$param1 = $_GET['tag'];

$q = $modx->newQuery('msProductOption');
$q->innerJoin('msProduct', 'msProduct', 'msProduct.id=msProductOption.product_id');
$q->where(array('msProductOption.key' => $key, 'msProductOption.value'=> $param1));
$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'])) ;

}
$modx->runsnippet('pdoResources', array('parents'=>3,'resources'=>$result));

[[msTags?]]

[[!msOptions?name=`tags`&tplOuter=`@INLINE <p><strong>Tags:</strong> [[+rows]]</p>`&tplRow=`@INLINE <a href="tags?tag=[[+value]]">[[+value]]</a> `]]

[[!pdoPage:default=`Предстоящих событий пока нет...`?
    &parents=`13`
    &tpl=`innerWidgetEvent`
    &limit=`4`
    &includeTVs=`eventsDate,endeventsDate`
    &where=`["eventsDate > \"[[!today]]\""]`
    &sortby=`eventsDate` &sortdir=`ASC`
    ]]

<article class="news-item page-row has-divider clearfix row">       
    <figure class="thumb col-md-2 col-sm-3 col-xs-4">
        <img class="img-responsive" src="[[+tv.newsPic]]" alt="" />
    </figure>
    <div class="details col-md-10 col-sm-9 col-xs-8">
        <span class="label label-theme"><i class="fa fa-clock-o"></i>[[+publishedon:dateAgo]]</span>
        <h3 class="title"><a href="[[~[[+id]]]]">[[+pagetitle]]</a></h3>
        [[+introtext]]
        <a class="btn btn-theme read-more" href="[[~[[+id]]]]">Подробнее<i class="fa fa-chevron-right"></i></a>
    </div>
</article>

&link=``

[[!msProducts? &master=`[[*id]]` &parents=`0` ]]