Sergey (Sentinel)

<div class="cart-item ptb-20 border-bottom">
	<div class="cart-img pull-left">
	    {if $img_d != '' && $img_d != '/small/'}<a href="[[~[[+id_d]]]]" class="product-image" title="{$name_d}"><img alt="{$name_d}" src="{$img_d}"></a>{/if}
	</div>
	<a href="[[~[[+id_d]]]]">[[+name_d]]</a>
	<div class="cart-item-details clear">
		
		<span class="price">[[+price_d]] </span>
		<div class="details-qty pull-left details-qty-60">
			<span>Кол-во:</span>
			<form method="post" id="dynamic-[[+id_d]]" class="ms2_form">
    			[[!msDynamicCount?
            		&id=`[[+id_d]]`
            	]]
        	    <input type="hidden" name="id" value="[[+id_d]]">
	            <input type="hidden" name="options" value="[]">
        	</form>
		</div>
		<div class="remove-edit">
			<ul>
				<li>
				    <form method="post" class="ms2_form">
                        <input type="hidden" name="key" value="[[+key_d]]">
                        <input type="hidden" name="id" value="[[+id_d]]">
                        <button type="submit" name="ms2_action" value="cart/remove" title="Удалить"><i class="fa fa-trash-o"></i></button>
                    </form>
			    </li>
			</ul>
		</div>
		
	</div>
</div>

$( '#oneClick_body input[name="count"]' ).change( function(){
        var id = '#' + $( this ).closest( 'form' ).attr( 'id' );
        var count = parseFloat($( this ).val()); 
        var price = parseFloat( $( id + ' .price' ).text().replace( /\s+/g, '' ) );
        var go = count * price;
        $( id + ' .price-sum' ).html( go.toFixed(2) );
    })

'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'],

[pdoTools] Error 42S22: Unknown column 'Remains.remains' in 'field list'