SELECT cry1.weight_brutto_remains 
FROM cargo_remains cry1 
INNER JOIN cargo_card cc1 ON cc1.id = cry1.cargo_card_id 
INNER JOIN placement_cargo_card pcc1 ON pcc1.id = cc1.id 
INNER JOIN contract_cargo_sub ccs1 ON ccs1.id = cc1.contract_cargo_sub_id 
INNER JOIN contract_cargo_consignment ccc1 ON ccc1.id = ccs1.contract_cargo_consignment_id 
INNER JOIN contract_cargo_head cch1 ON cch1.id = ccc1.contract_cargo_head_id 
INNER JOIN contract c1 ON c1.id = cch1.contract_id 
WHERE cch1.cargo_id = 2616
AND pcc1.placement_id = 46 
AND c1.contragent_id = 50
AND cry1.remains_time = (SELECT MAX(cry3.remains_time) 
 						              FROM cargo_remains cry3 
                           WHERE cry3.cargo_card_id = cc1.id 
                           AND cry3.cargo_card_id = cry1.cargo_card_id 
                           AND (cry3.remains_time <= :remains_time_yesterday))

SELECT cn.id, pcc.placement_id, ca.id, cargo_id, cargo_nomenclature_name, ca.contragent_full_name AS cargo_owner_name, placement_number, 
(CASE `c`.`cargo_status` 
WHEN 'export' THEN CONCAT(`cn`.`cargo_nomenclature_name`,' (Э)') 
WHEN 'import' THEN CONCAT(`cn`.`cargo_nomenclature_name`,' (И)') 
WHEN 'domestic' THEN CONCAT(`cn`.`cargo_nomenclature_name`,' (К)') 
ELSE `cn`.`cargo_nomenclature_name` end) AS cargo_nom_rus,

(SELECT SUM(cry1.weight_brutto_remains)
/*(SELECT cry1.weight_brutto_remains */
FROM cargo_remains cry1 
INNER JOIN cargo_card cc1 ON cc1.id = cry1.cargo_card_id 
INNER JOIN placement_cargo_card pcc1 ON pcc1.id = cc1.id 
INNER JOIN contract_cargo_sub ccs1 ON ccs1.id = cc1.contract_cargo_sub_id 
INNER JOIN contract_cargo_consignment ccc1 ON ccc1.id = ccs1.contract_cargo_consignment_id 
INNER JOIN contract_cargo_head cch1 ON cch1.id = ccc1.contract_cargo_head_id 
INNER JOIN contract c1 ON c1.id = cch1.contract_id 
WHERE cch1.cargo_id = cch.cargo_id 
AND pcc1.placement_id = pcc.placement_id 
AND c1.contragent_id = c.contragent_id 
AND cry1.remains_time = (SELECT MAX(cry3.remains_time) 
 						              FROM cargo_remains cry3 
                           WHERE cry3.cargo_card_id = cc1.id 
                           AND cry3.cargo_card_id = cry1.cargo_card_id 
                           AND (cry3.remains_time <= :remains_time_yesterday))) AS brutto_remains_sum_y 


FROM cargo_card cc 
INNER JOIN placement_cargo_card pcc ON pcc.id = cc.id 
INNER JOIN placement p ON p.id = pcc.placement_id 
INNER JOIN cargo_zone z ON z.id = p.cargo_zone_id 
INNER JOIN contract_cargo_sub ccs ON ccs.id = cc.contract_cargo_sub_id 
INNER JOIN contract_cargo_consignment ccc ON ccc.id = ccs.contract_cargo_consignment_id 
INNER JOIN contract_cargo_head cch ON cch.id = ccc.contract_cargo_head_id 
INNER JOIN contract c ON c.id = cch.contract_id 
INNER JOIN contragent ca ON ca.id = c.contragent_id 
INNER JOIN cargo_nomenclature cn ON cn.id = cch.cargo_id 
AND p.cargo_zone_id = :cargo_zone_id
GROUP BY cn.id, pcc.placement_id, ca.id
ORDER BY cargo_nomenclature_name, ca.contragent_full_name, placement_number

SELECT MAX(cry3.remains_time) 
    FROM cargo_remains cry3 
    WHERE cry3.cargo_card_id = 79530
    AND (cry3.remains_time <= :remains_time_yesterday)

SELECT cry3.remains_time
    FROM cargo_remains cry3 
    WHERE cry3.cargo_card_id = 79530
    AND (cry3.remains_time <= :remains_time_yesterday)
    ORDER BY cry3.`remains_time` DESC
    LIMIT 1