{$packItems|@count}

$sql = 'SELECT p.*, product_shop.*, pl.*, image_shop.`id_image`, il.`legend`, cl.`name` AS category_default, a.quantity AS pack_quantity, product_shop.`id_category_default`, a.id_product_pack, a.id_product_attribute_item
                FROM `'._DB_PREFIX_.'pack` a
                LEFT JOIN `'._DB_PREFIX_.'product` p ON p.id_product = a.id_product_item
                LEFT JOIN `'._DB_PREFIX_.'product_lang` pl
                    ON p.id_product = pl.id_product
                    AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').'
                LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product`)'.
                Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1').'
                LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang.')
                '.Shop::addSqlAssociation('product', 'p').'
                LEFT JOIN `'._DB_PREFIX_.'category_lang` cl
                    ON product_shop.`id_category_default` = cl.`id_category`
                    AND cl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('cl').'
                WHERE product_shop.`id_shop` = '.(int)Context::getContext()->shop->id.'
                AND a.`id_product_pack` = '.(int)$id_product.'
                GROUP BY a.`id_product_attribute_item`';