Warning: mysqli::query(): (HY000/1041): Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 143Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr2.recargo, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '195' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3001') ORDER BY tr1.priority ASC in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/tax.php on line 29Warning: Invalid argument supplied for foreach() in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/tax.php on line 29Warning: mysqli::query(): (HY000/1041): Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 143Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr2.recargo, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '195' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3001') ORDER BY tr1.priority ASC in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/tax.php on line 59Warning: Invalid argument supplied for foreach() in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/tax.php on line 59Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=1259782 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=1179987 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=1178297 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=1178296 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=1177115 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=1177114 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=1170225 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=1041547 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=987353 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=425054 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=424948 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=417431 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=417389 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344Notice: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space1041 SELECT YGPUP.products_ud_min, YGPUP.products_ud_min_pack, YGP.products_id AS product_id, YGP.products_idPADRE, YGP.relationShip, YUB_global.getSKU(YGP.products_id) AS product_sku, YGPD.products_name AS name, YGPD.products_description AS description, '' AS meta_title, '' AS meta_description, '' AS meta_keyword, '' AS tag, if (PC.code_type=3,PC.name,'') AS model, '' AS sku, '' AS upc, if (PC.code_type=1,PC.name,'') AS ean, '' AS jan, '' AS isbn, '' AS mpn, '' AS location, (SELECT GROUP_CONCAT(name) FROM YUB_global._products_code WHERE code_type=2 AND products_id=YGP.products_id ) AS reffab, 'Sin Stock' AS stock_status, # ANULADO no saca bien las imagenes ==> IFNULL(PI.image,'a') AS image, IFNULL((SELECT image FROM `YUB_global`.`_products_images` WHERE products_id=YGP.products_id ORDER BY primaria DESC LIMIT 1),'a') AS image, IFNULL(YGP.manufacturers_id,'') AS manufacturer_id, IFNULL((M.name),'') AS manufacturer, # **************************************** # Añade Mika el 21/oct porque falta este VALOR y salia precios a 0 # **************************************** (SELECT MIN(price) FROM `YUB_global`._products_price WHERE products_id IN (SELECT products_id FROM `YUB_global`._products WHERE products_idPADRE=YGP.products_id) AND price_type_id = 6 AND price>0) AS priceParent, # **************************************** # **************************************** PP.price AS price, IF(YGP.relationShip = 3,(SELECT MIN(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS minprice, IF(YGP.relationShip = 3,(SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0),'') AS maxprice, IF(YGP.relationShip = 3,IFNULL((SELECT MIN(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1),''),'') AS minprice_special, IF(YGP.relationShip = 3, IFNULL( # anulado por mika el 2 Marzo 2018 por bug el precio mas alto es el de todos los productos... # (SELECT MAX(offer) FROM YUB_global._products_price RIGHT JOIN YUB_global._products_offer ON YUB_global._products_offer.products_price_id = YUB_global._products_price.products_price_id WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id) AND price_type_id=6 LIMIT 1), # entonces cojo el mas alto de todos los hijos (SELECT MAX(price) FROM YUB_global._products_price WHERE products_id IN (SELECT products_id FROM YUB_global._products WHERE products_idPADRE=YGP.products_id AND products_id!=YGP.products_id) AND price_type_id = 6 AND price>0), ''),'') AS maxprice_special, 0 AS discount, #De aqui se selecta si hay oferta - Alex IFNULL((SELECT offer FROM YUB_global._products_price PP RIGHT JOIN YUB_global._products_offer PO ON PO.products_price_id = PP.products_price_id WHERE products_id=YGP.products_id AND price_type_id=6 AND ( ( PO.fecha_fin >= '2020-01-21 00:00:00' AND PO.fecha_fin != '0000-00-00 00:00:00' AND PO.fecha_inicio < PO.fecha_fin ) OR (PO.fecha_fin = '0000-00-00 00:00:00' AND PO.fecha_inicio = '0000-00-00 00:00:00') ) LIMIT 1),'') AS special, '' AS reward, '' AS points, PTR.tax_rates_id_1 AS tax_class_id, CURDATE()-INTERVAL 2 DAY AS date_available, '' AS weight, '' AS weight_class_id, '' AS length, '' AS width, '' AS height, '' AS length_class_id, '' AS subtract, '' AS rating, '' AS reviews, '' AS minimum, '' AS sort_order, YGP.descatalogado, 1 AS status, CURDATE()-INTERVAL 2 DAY AS date_added, CURDATE()-INTERVAL 2 DAY AS date_modified, '' AS viewed FROM YUB_global._products YGP INNER JOIN YUB_global._products_description YGPD ON YGPD.products_id=YGP.products_id AND languages_id=1 LEFT JOIN YUB_global._products_ud_pack YGPUP ON YGPUP.products_id = YGP.products_id LEFT JOIN YUB_global._products_status ST ON ST.products_id=YGP.products_id AND ST.status_type_id=2 AND ST.IDCLIENTE=24 LEFT JOIN YUB_global._products_tax_rates PTR ON PTR.products_id=YGP.products_id LEFT JOIN YUB_global._products_code PC ON PC.important=1 AND (code_type=3 or code_type=1) AND PC.products_id=YGP.products_id # ANULADO no saca bien las imagenes ==> LEFT JOIN YUB_global._products_images PI ON PI.products_id=YGP.products_id and PI.primaria=1 LEFT JOIN YUB_global._manufacturers M ON M.manufacturers_id=YGP.manufacturers_id LEFT JOIN YUB_global._products_price PP ON PP.products_id=YGP.products_id AND price_type_id=6 WHERE YGP.products_id=379360 AND (status_value>0 OR status_value IS NULL) #AND #CACHECACHECAAA_# in /furanet/sites/laboticadeamalia.com/web/htdocs/es/system/library/db/mysqli_memcached.php on line 191Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 273Notice: Trying to get property of non-object in /furanet/sites/laboticadeamalia.com/web/htdocs/es/catalog/model/catalog/product.php on line 344 La Botica de Amalia
  • Tu cesta esta vacía!

ENVIOS:

Envíos en 24-72h, y gratis en pedidos de más de 40€.

RECOGIDA EN TIENDA:

Posibilidad de recogida del pedido en la tienda.

TARJETA Y PAYPAL:

Pagos seguros con Tarjeta de credito o debito y PayPal.

Novedades

Nuevo
Agotado
0.00€ Sin Iva: 0.00€
Nuevo
Agotado
0.00€ Sin Iva: 0.00€
Nuevo
Agotado
0.00€ Sin Iva: 0.00€
Nuevo
Agotado
0.00€ Sin Iva: 0.00€
Nuevo
Agotado
0.00€ Sin Iva: 0.00€
Nuevo
Agotado
0.00€ Sin Iva: 0.00€
Nuevo
Agotado
0.00€ Sin Iva: 0.00€
Nuevo
Agotado
0.00€ Sin Iva: 0.00€
Nuevo
Agotado
0.00€ Sin Iva: 0.00€
COLÁGENO CON SILICIO+CALCIO INSTANT 383 GR EPAPLUS
En Stock
Nuevo
Agotado
0.00€ Sin Iva: 0.00€
VITAMINA K2  60 CAP
Agotado
24.50€ Sin Iva: 24.50€