SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `at_position`.`position` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '2' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
LEFT JOIN `aw_shopbybrand_brand_product` AS `at_position` ON (at_position.`product_id`=e.entity_id) AND (brand_id=1203) WHERE (`e`.`entity_id` IN('7096', '20225', '20226', '20227', '20228', '20229', '20230', '20231', '20232', '20233', '20234', '20235', '20236', '24096', '24235', '24247', '24969', '25015', '25019', '25107', '25143', '25175', '39110', '39111', '39112', '39113', '39114', '39115', '39116', '39117', '39118', '39119', '39120', '39121', '39122', '39123')) ORDER BY `at_position`.`position` DESC LIMIT 24 OFFSET 24
-
Veinoguard 60 Cápsulas
Disponible en 24/48 horas laborables
26,20 €
-
Oligophytum Fluor 100Gra
Disponible en 24/48 horas laborables
11,90 €
-
Physioxid 40 Cápsulas
Disponible en 24/48 horas laborables
24,52 €
-
Ultra Vegan B 30 Comprimidos Mast.
Disponible en 24/48 horas laborables
23,20 €
-
Flower Complex Nº 1 Choques 100Gra
Disponible en 24/48 horas laborables
15,35 €
-
Oligophytum Cobalto 100Gra
Disponible en 24/48 horas laborables
11,90 €
-
Doluperine 60 Cápsulas
Envío
gratis
Disponible en 24/48 horas laborables
59,50 €
-
Propargile 32Cap
Disponible en 24/48 horas laborables
23,80 €
-
Ultra Vegan D3 Gotas 8 Ml.
Disponible en 24/48 horas laborables
22,06 €
-
Oligophytum H4 Cu 100Gra
Disponible en 24/48 horas laborables
11,90 €