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(4657) AND p.`id_product` NOT IN (4657) GROUP BY apg.`id_accessory_group`, apg.`id_accessory` ORDER BY apg.`position` ASC" string(2112) "SELECT pa.`id_product_attribute`, stock.`quantity` AS `stock_available`, stock.`out_of_stock`, pa.reference AS `name` FROM `hinst_product_attribute` pa INNER JOIN hinst_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `hinst_product_attribute_shop` pas ON pas.`id_product_attribute` = pa.`id_product_attribute` AND pas.`id_shop` = 1 LEFT JOIN `hinst_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `hinst_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `hinst_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `hinst_attribute_lang` al ON a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4 LEFT JOIN `hinst_attribute_group_lang` agl ON ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4 INNER JOIN hinst_stock_available stock ON (stock.id_product = pa.id_product AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE pa.`id_product` = 4336 GROUP BY pa.`id_product`, pa.`id_product_attribute` ASC ORDER BY `name`" 5189 // array(2) { [0]=> string(4) "2785" [1]=> string(4) "2786" } 4315 // array(5) { [0]=> string(4) "1824" [1]=> string(4) "1826" [2]=> string(4) "1827" [3]=> string(4) "2580" [4]=> string(4) "2742" } 4332 // array(6) { [0]=> string(4) "2483" [1]=> string(4) "1803" [2]=> string(4) "1804" [3]=> string(4) "2484" [4]=> string(4) "2581" [5]=> string(4) "2771" } comb: //-// 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" } comb: //-// 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" } comb: //-// 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" } comb: //-// 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" } comb: //-// 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 // array(5) { [0]=> string(4) "1818" [1]=> string(4) "1820" [2]=> string(4) "1821" [3]=> string(4) "2579" [4]=> string(4) "2770" } array(5) { [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" } [1820]=> 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" } [1821]=> 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" } [2579]=> 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" } [2770]=> 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" } } 4978 // array(5) { [0]=> string(4) "1981" [1]=> string(4) "1980" [2]=> string(4) "1983" [3]=> string(4) "1982" [4]=> string(4) "1984" } 4979 // array(8) { [0]=> string(4) "1988" [1]=> string(4) "1987" [2]=> string(4) "1985" [3]=> string(4) "1986" [4]=> string(4) "1991" [5]=> string(4) "1989" [6]=> string(4) "1990" [7]=> string(4) "1992" } 5021 // string(4) "2164" 5077 // array(4) { [0]=> string(4) "1956" [1]=> string(4) "1953" [2]=> string(4) "1954" [3]=> string(4) "1955" } 5095 // array(15) { [0]=> string(4) "2057" [1]=> string(4) "2058" [2]=> string(4) "2059" [3]=> string(4) "2054" [4]=> string(4) "2056" [5]=> string(4) "2055" [6]=> string(4) "2051" [7]=> string(4) "2045" [8]=> string(4) "2046" [9]=> string(4) "2047" [10]=> string(4) "2049" [11]=> string(4) "2052" [12]=> string(4) "2048" [13]=> string(4) "2050" [14]=> string(4) "2053" } 5096 // array(17) { [0]=> string(4) "2092" [1]=> string(4) "2093" [2]=> string(4) "2095" [3]=> string(4) "2094" [4]=> string(4) "2090" [5]=> string(4) "2091" [6]=> string(4) "2084" [7]=> string(4) "2078" [8]=> string(4) "2085" [9]=> string(4) "2080" [10]=> string(4) "2081" [11]=> string(4) "2083" [12]=> string(4) "2086" [13]=> string(4) "2082" [14]=> string(4) "2089" [15]=> string(4) "2088" [16]=> string(4) "2087" } 5099 // array(18) { [0]=> string(4) "2127" [1]=> string(4) "2128" [2]=> string(4) "2131" [3]=> string(4) "2130" [4]=> string(4) "2132" [5]=> string(4) "2124" [6]=> string(4) "2125" [7]=> string(4) "2116" [8]=> string(4) "2110" [9]=> string(4) "2111" [10]=> string(4) "2112" [11]=> string(4) "2114" [12]=> string(4) "2117" [13]=> string(4) "2113" [14]=> string(4) "2123" [15]=> string(4) "2122" [16]=> string(4) "2109" [17]=> string(4) "2118" }
Ningún producto
Estos precios se entienden sin IVA