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}