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(6669) AND p.`id_product` NOT IN (6669) GROUP BY apg.`id_accessory_group`, apg.`id_accessory` ORDER BY apg.`position` ASC" 6551 // array(6) { [0]=> string(4) "2732" [1]=> string(4) "2714" [2]=> string(4) "2715" [3]=> string(4) "2716" [4]=> string(4) "2717" [5]=> string(4) "2718" } 6550 // array(6) { [0]=> string(4) "2731" [1]=> string(4) "2709" [2]=> string(4) "2710" [3]=> string(4) "2711" [4]=> string(4) "2712" [5]=> string(4) "2713" } 6007 // array(6) { [0]=> string(4) "2720" [1]=> string(4) "2594" [2]=> string(4) "2595" [3]=> string(4) "2596" [4]=> string(4) "2597" [5]=> string(4) "2598" } 6047 // array(6) { [0]=> string(4) "2719" [1]=> string(4) "2659" [2]=> string(4) "2660" [3]=> string(4) "2661" [4]=> string(4) "2662" [5]=> string(4) "2663" } 6050 // array(6) { [0]=> string(4) "2722" [1]=> string(4) "2664" [2]=> string(4) "2665" [3]=> string(4) "2666" [4]=> string(4) "2667" [5]=> string(4) "2668" } 6249 // array(6) { [0]=> string(4) "2721" [1]=> string(4) "2669" [2]=> string(4) "2670" [3]=> string(4) "2671" [4]=> string(4) "2672" [5]=> string(4) "2673" } 6254 // array(6) { [0]=> string(4) "2723" [1]=> string(4) "2674" [2]=> string(4) "2675" [3]=> string(4) "2676" [4]=> string(4) "2677" [5]=> string(4) "2678" } 6259 // array(6) { [0]=> string(4) "2724" [1]=> string(4) "2679" [2]=> string(4) "2680" [3]=> string(4) "2681" [4]=> string(4) "2682" [5]=> string(4) "2683" } 6008 // array(6) { [0]=> string(4) "2725" [1]=> string(4) "2599" [2]=> string(4) "2600" [3]=> string(4) "2601" [4]=> string(4) "2602" [5]=> string(4) "2603" } 6024 // array(6) { [0]=> string(4) "2726" [1]=> string(4) "2684" [2]=> string(4) "2685" [3]=> string(4) "2686" [4]=> string(4) "2687" [5]=> string(4) "2688" } 6312 // array(6) { [0]=> string(4) "2727" [1]=> string(4) "2689" [2]=> string(4) "2690" [3]=> string(4) "2691" [4]=> string(4) "2692" [5]=> string(4) "2693" } 6322 // array(6) { [0]=> string(4) "2728" [1]=> string(4) "2695" [2]=> string(4) "2694" [3]=> string(4) "2696" [4]=> string(4) "2697" [5]=> string(4) "2698" } 6580 // array(6) { [0]=> string(4) "2729" [1]=> string(4) "2699" [2]=> string(4) "2700" [3]=> string(4) "2701" [4]=> string(4) "2702" [5]=> string(4) "2708" } 6549 // array(6) { [0]=> string(4) "2730" [1]=> string(4) "2703" [2]=> string(4) "2704" [3]=> string(4) "2705" [4]=> string(4) "2706" [5]=> string(4) "2707" } 6603 // array(5) { [0]=> string(4) "2733" [1]=> string(4) "2734" [2]=> string(4) "2735" [3]=> string(4) "2736" [4]=> string(4) "2737" } 6011 // array(3) { [0]=> string(4) "2538" [1]=> string(4) "2539" [2]=> string(4) "2540" } 4173 // array(3) { [0]=> string(4) "1711" [1]=> string(4) "1712" [2]=> string(4) "1713" } 4581 // array(3) { [0]=> string(4) "1708" [1]=> string(4) "1709" [2]=> string(4) "1710" }
Ningún producto
Estos precios se entienden sin IVA