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(4400) AND p.`id_product` NOT IN (4400) GROUP BY apg.`id_accessory_group`, apg.`id_accessory` ORDER BY apg.`position` ASC" 4722 // array(3) { [0]=> string(4) "1680" [1]=> string(4) "1681" [2]=> string(4) "1682" } 5324 // array(2) { [0]=> string(4) "2796" [1]=> string(4) "2797" } 4848 // array(2) { [0]=> string(4) "2214" [1]=> string(4) "2215" } 4823 // array(2) { [0]=> string(4) "2190" [1]=> string(4) "2191" } 4229 // array(2) { [0]=> string(4) "2298" [1]=> string(4) "2299" } 4824 // array(2) { [0]=> string(4) "2220" [1]=> string(4) "2221" } 4822 // array(2) { [0]=> string(4) "2250" [1]=> string(4) "2251" } 4849 // array(2) { [0]=> string(4) "2222" [1]=> string(4) "2223" } 4787 // array(2) { [0]=> string(4) "2280" [1]=> string(4) "2281" } 4796 // array(2) { [0]=> string(4) "2282" [1]=> string(4) "2283" } 4829 // array(2) { [0]=> string(4) "2260" [1]=> string(4) "2261" } 4852 // array(2) { [0]=> string(4) "2306" [1]=> string(4) "2307" } 4851 // array(2) { [0]=> string(4) "2192" [1]=> string(4) "2193" } 4792 // array(2) { [0]=> string(4) "2252" [1]=> string(4) "2253" } 4854 // array(2) { [0]=> string(4) "2304" [1]=> string(4) "2305" } 4853 // array(2) { [0]=> string(4) "2212" [1]=> string(4) "2213" } 4855 // array(2) { [0]=> string(4) "2308" [1]=> string(4) "2309" } 4859 // array(2) { [0]=> string(4) "2270" [1]=> string(4) "2271" } 4858 // array(2) { [0]=> string(4) "2236" [1]=> string(4) "2237" } 4232 // array(11) { [0]=> string(4) "2291" [1]=> string(4) "2292" [2]=> string(4) "2658" [3]=> string(4) "2627" [4]=> string(4) "2823" [5]=> string(4) "2288" [6]=> string(4) "2289" [7]=> string(4) "2290" [8]=> string(4) "2592" [9]=> string(4) "2593" [10]=> string(4) "2293" } 4857 // array(2) { [0]=> string(4) "2302" [1]=> string(4) "2303" } 4856 // array(2) { [0]=> string(4) "2194" [1]=> string(4) "2195" } 4850 // array(2) { [0]=> string(4) "2218" [1]=> string(4) "2219" } 4847 // array(2) { [0]=> string(4) "2234" [1]=> string(4) "2235" } 4833 // array(2) { [0]=> string(4) "2242" [1]=> string(4) "2243" } 4832 // array(2) { [0]=> string(4) "2262" [1]=> string(4) "2263" } 4830 // array(2) { [0]=> string(4) "2230" [1]=> string(4) "2231" } 4831 // array(2) { [0]=> string(4) "2228" [1]=> string(4) "2229" } 4806 // array(4) { [0]=> string(4) "2254" [1]=> string(4) "2255" [2]=> string(4) "2256" [3]=> string(4) "2257" } 4834 // array(2) { [0]=> string(4) "2198" [1]=> string(4) "2199" } 4870 // array(2) { [0]=> string(4) "2226" [1]=> string(4) "2227" } 4861 // array(2) { [0]=> string(4) "2266" [1]=> string(4) "2267" } 4860 // array(2) { [0]=> string(4) "2232" [1]=> string(4) "2233" } 4838 // array(2) { [0]=> string(4) "2276" [1]=> string(4) "2277" } 4840 // array(2) { [0]=> string(4) "2268" [1]=> string(4) "2269" } 4839 // array(2) { [0]=> string(4) "2208" [1]=> string(4) "2209" } 4864 // array(2) { [0]=> string(4) "2264" [1]=> string(4) "2265" } 4863 // array(2) { [0]=> string(4) "2238" [1]=> string(4) "2239" } 4865 // array(2) { [0]=> string(4) "2240" [1]=> string(4) "2241" } 4866 // array(4) { [0]=> string(4) "2204" [1]=> string(4) "2205" [2]=> string(4) "2206" [3]=> string(4) "2207" } 4237 // array(2) { [0]=> string(4) "2300" [1]=> string(4) "2301" } 4835 // array(2) { [0]=> string(4) "2248" [1]=> string(4) "2249" } 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" } 4812 // array(2) { [0]=> string(4) "2224" [1]=> string(4) "2225" } 4234 // array(2) { [0]=> string(4) "2296" [1]=> string(4) "2297" } 4871 // array(2) { [0]=> string(4) "2272" [1]=> string(4) "2273" } 4872 // array(2) { [0]=> string(4) "2200" [1]=> string(4) "2201" } 4837 // array(2) { [0]=> string(4) "2258" [1]=> string(4) "2259" } 4869 // array(2) { [0]=> string(4) "2274" [1]=> string(4) "2275" } 4876 // array(2) { [0]=> string(4) "2246" [1]=> string(4) "2247" }
Ningún producto
Estos precios se entienden sin IVA