string(2352) "SELECT DISTINCT apg.`id_accessory_group`, apg.`id_accessory`, apg.`default_quantity`, apg.`min_quantity`, apg.`required`, apg.`position`, pl.`link_rewrite`, pl.`description_short`, pl.`available_later`, p.`id_product` AS `id_product`, p.`is_virtual`, p.`reference`, stock.`quantity` AS `stock_available`, stock.`out_of_stock`, apg.`id_accessory_group_product`, apg.`id_product_attribute`, i.`id_image`, IF(`is`.`id_image`, `is`.`id_image`, i.`id_image`) `id_image` FROM `hinst_accessory_group_product` apg INNER JOIN `hinst_product` p ON (p.`id_product` = apg.`id_accessory` AND p.active =1)LEFT JOIN `hinst_product_lang` pl ON (pl.`id_product` = apg.`id_accessory` AND pl.`id_lang` = 4) LEFT JOIN `hinst_accessory_group_product_lang` agpl ON (agpl.`id_accessory_group_product` = apg.`id_accessory_group_product` AND agpl.`id_lang` = 4) LEFT JOIN `hinst_image` i ON (i.`id_product` = apg.`id_accessory` AND `i`.`cover` = 1) LEFT JOIN `hinst_image_shop` `is` ON ( `is`.`id_image` = i.`id_image` AND `is`.id_shop = 1 AND `is`.`cover` = 1) LEFT JOIN `hinst_image_lang` il ON (il.`id_image` = i.`id_image` AND il.`id_lang` = 4) LEFT JOIN hinst_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) INNER JOIN hinst_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE apg.`id_accessory_group` IN (1) AND apg.`id_product` IN(4419) AND p.`id_product` NOT IN (4419) GROUP BY apg.`id_accessory_group`, apg.`id_accessory` ORDER BY apg.`position` ASC" array(6) { ["id_product_attribute"]=> string(4) "1818" ["stock_available"]=> string(5) "40000" ["out_of_stock"]=> string(1) "2" ["name"]=> string(7) "HI11310" ["id_image"]=> string(4) "1521" ["image"]=> string(53) "https://hanna.merkatu.info/1521-hsma_default/4336.jpg" } array(6) { ["id_product_attribute"]=> string(4) "1820" ["stock_available"]=> string(5) "40000" ["out_of_stock"]=> string(1) "2" ["name"]=> string(7) "HI11313" ["id_image"]=> string(4) "1521" ["image"]=> string(53) "https://hanna.merkatu.info/1521-hsma_default/4336.jpg" } array(6) { ["id_product_attribute"]=> string(4) "1821" ["stock_available"]=> string(5) "40000" ["out_of_stock"]=> string(1) "2" ["name"]=> string(7) "HI1131B" ["id_image"]=> string(4) "1521" ["image"]=> string(53) "https://hanna.merkatu.info/1521-hsma_default/4336.jpg" } array(6) { ["id_product_attribute"]=> string(4) "2579" ["stock_available"]=> string(5) "40000" ["out_of_stock"]=> string(1) "2" ["name"]=> string(7) "HI1131Y" ["id_image"]=> string(4) "2790" ["image"]=> string(53) "https://hanna.merkatu.info/2790-hsma_default/4336.jpg" } array(6) { ["id_product_attribute"]=> string(4) "2770" ["stock_available"]=> string(5) "40000" ["out_of_stock"]=> string(1) "2" ["name"]=> string(9) "HS1131MP5" ["id_image"]=> string(4) "1521" ["image"]=> string(53) "https://hanna.merkatu.info/1521-hsma_default/4336.jpg" } 4336 // string(4) "1818" array(1) { [1818]=> array(6) { ["id_product_attribute"]=> string(4) "1818" ["stock_available"]=> string(5) "40000" ["out_of_stock"]=> string(1) "2" ["name"]=> string(7) "HI11310" ["id_image"]=> string(4) "1521" ["image"]=> string(53) "https://hanna.merkatu.info/1521-hsma_default/4336.jpg" } } 4849 // array(2) { [0]=> string(4) "2222" [1]=> string(4) "2223" } 4829 // array(2) { [0]=> string(4) "2260" [1]=> string(4) "2261" } 4865 // array(2) { [0]=> string(4) "2240" [1]=> string(4) "2241" } 4851 // array(2) { [0]=> string(4) "2192" [1]=> string(4) "2193" } 4853 // array(2) { [0]=> string(4) "2212" [1]=> string(4) "2213" } 4856 // array(2) { [0]=> string(4) "2194" [1]=> string(4) "2195" } 4847 // array(2) { [0]=> string(4) "2234" [1]=> string(4) "2235" } 4830 // array(2) { [0]=> string(4) "2230" [1]=> string(4) "2231" } 4860 // array(2) { [0]=> string(4) "2232" [1]=> string(4) "2233" } 4867 // array(2) { [0]=> string(4) "2286" [1]=> string(4) "2287" } 4836 // array(2) { [0]=> string(4) "2210" [1]=> string(4) "2211" } 4814 // array(2) { [0]=> string(4) "2216" [1]=> string(4) "2217" } 5288 // string(4) "1787" 5425 // array(3) { [0]=> string(4) "1691" [1]=> string(4) "1692" [2]=> string(4) "1693" } 4491 // string(4) "1696"
Ningún producto
Estos precios se entienden sin IVA