Sergey (Sentinel)

'sort' => 'Remains|remains:desc',
'loadModels' => 'msproductremains',
'leftJoin' => ["Remains" => [
                    "class" => "msprRemains",
                    "on" => ["msProduct.id = Remains.product_id AND Remains.remains > 0"]
                    ]
                ],
'groupby' => 'msProduct.id',
'select' => ['msProduct' => '*', 'Remains' => 'IF (Remains.remains > 0, 1, 0) as remains'],

{'!ecMessages' | snippet : [
     'threads' => '*',
    'tpl' => '@INLINE <li> 
                        <span>{$user_name}</span> 
                    </li>',
    'limit' => 6,
    'where' => ['thread_resource:!=' => $_modx->resource.id]

{'!ecMessages' | snippet : [
    'threads' => '*,-resource-'~$_modx->resource.id,
    'tpl' => '@INLINE <li> 
                        <span>{$user_name}</span> 
                        <a href="{$thread_resource | url}" title="{$thread_resource | resource : "pagetitle"}">
                        {$text}...
                        </a> 
                    </li>',
    'limit' => 6
]}

{'mspcs.filters' | placeholder}

{set $modification = []}
{if $product.options? and $product.options.modification?}
{set $modification = $_modx->runSnippet('!msOptionsPrice.modification',[
            'product' => $product.id,
            'includeThumbs' => 'small',
            'where' => json_encode([
                        'msopModification.id' => $product.options.modification
                        ]),
            'return' => 'data',
            'processOptions' => 1
            ])}
{set $modification = $modification[0]}

{/if}

{if $modification['old_price']?}
    {set $product.old_price = $modification['old_price']}
{/if}
                    
{$product.old_price}