Евгений

{'!msProducts' | snippet:[
    'parents' => '5',
    'tpl'=> '@FILE chunks/middle_images.tpl',
    'leftJoin' => '{
        "images" : {
	    "class" : "msProductFile",
	    "on" : "`images`.product_id = msProduct.id AND `images`.type = \'image\' AND `images`.path NOT LIKE \'%x%\'"
	}
    }',
    'select' => '{
         "images" : "GROUP_CONCAT(`images`.`url` SEPARATOR \';\') as `images`"
    }',
]}

{set $imgArr = $images | split: ';'}
{foreach $imgArr  as $fileSrc}
    <img src="{$fileSrc}" srcset="{$fileSrc} 2x">
{/foreach}

{'pdoMenu' | snippet : [
    'parents' => $_modx->resource.id,
    'select' => [
        'modResource' => '*',
        'Data' => 'price,old_price,article',
    ],
    'leftJoin' => [
        'Data' => [
            'class' => 'msProductData',
            'alias' => 'Data',
            'on' => 'Data.id = modResource.id',
        ],
    ],
]}

// Add grouping
$groupby = array(
    'msProduct.id',
); //строка 28
if(!empty($scriptProperties['groupby'])){
    $groupby = array(
        $scriptProperties['groupby'],
    );
}

{'!mFilter2' | snippet:[
    'class' => 'msProduct',
    'parents' => 0,
    'element' => 'msProducts',
    'innerJoin' => '{
                "Category": {
                    "class": "msCategory"
                 }
            }',
    'select' => '{
                "Category": "*"
            }',
    'groupby' => 'Category.id',
    'tpl' => '@INLINE <p><a href="{$uri}">{$pagetitle}</a></p>',
    ....
]}

Код: 200 OK
{"success":false,"message":"ms2_product_autocomplete_err_noquery","total":0,"data":[],"object":[]}