string(960) "SELECT
            COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
            COALESCE(SUM(first_level_quantity), 0) as quantity
          FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
          FROM `ps_cart_product` cp
            WHERE cp.`id_product_attribute` = 0
            AND cp.`id_customization` = 0
            AND cp.`id_cart` = 0 AND cp.`id_product` = 1607 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
          FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
            WHERE cp.`id_product_attribute` = 0
            AND cp.`id_customization` = 0
            AND cp.`id_cart` = 0 AND p.`id_product_item` = 1607 AND (pr.`pack_stock_type` IN (1,2) OR (
            pr.`pack_stock_type` = 3
            AND 0 = 1
        ))) as q LIMIT 1"