Service Client Gratuit : 028 08 68 81

Satisfait ou remboursé sous 15 jours

0 Mon panier Mon compte

Echantillon TENA Slip Super Medium

Echantillon TENA Slip Super Medium

( 0 Commentaire(s) )

Technologie FeelDry garantit une sensation peau sèche exceptionnelle - Elastiques Body Fitting au niveau des jambes pour un ajustement, un confort et une sécurité anti-fuites incomparables - Absorption : 2353 mL.

Voir la description complète.

Prix GirodMedical :

0,00 € TTC

Frais de livraison estimés : 5,20 €

Disponibilité : En stock

Add Items to Cart

Quantité :

Description
Détails
Avis
Contact

Echantillon TENA Slip Super Medium


Une protection de type change complet, offrant une absorption et une sécurité maximum contre les fuites, adaptée aux cas d'incontinence fécale. La large zone d'attache adhésive Easy Fit garantit un ajustement parfait et confortable ; il est possible de la repositionner plusieurs fois sans déchirer la protection. TENA Slip bénéficie en outre  de la technologie FeelDry pour une absorption incomparable et d'un double noyau qui absorbe et piège rapidement l'urine.

Caractéristiques et Avantages de la protection TENA Slip Super Medium

- La technologie FeelDry garantit une sensation peau sèche exceptionnelle grâce à une absorption rapide et un excellent pouvoir de rétention.
- Des élastiques Body Fitting au niveau des jambes pour un ajustement, un confort et une sécurité anti-fuites incomparables.
- Un indicateur d'humidité pour savoir quand changer la protection.
- Une composition Odour Neutralizer qui limite les diffusions d'odeur
- Un code couleur  pour trouver facilement le bon produit.
- Une double barrière anti-fuites pour une sécurité incomparable.

- Capacité d'absorption moyenne Rothwell : 2353 mL

Détails sur le produit Echantillon TENA Slip Super Medium :

Référence echantillon-650798-7
Poids 0.20 Kg
Fabricant Tena

Besoin d'informations complémentaires sur le produit Echantillon TENA Slip Super Medium ?






* Champs obligatoires

SELECT 1 AS `status`, `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`manufacturer`, `e`.`manufacturer_value`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`availablestock`, `e`.`ordered_qty`, `e`.`default_supply_delay`, `e`.`supply_date`, `e`.`ugiftcert_amount_config`, `e`.`ranking`, `e`.`is_in_stock_configurable`, `e`.`is_in_stock_configurable_value`, `e`.`before_sold_price`, `e`.`expedition_directe_fournisseur`, `e`.`materiel_rembourse_lpp`, `e`.`materiel_rembourse_lpp_value`, `e`.`links_exist`, `e`.`discount_price`, `e`.`discount_price_from`, `e`.`discount_price_to`, `e`.`sale_price`, `e`.`mea_product_date`, `e`.`marge`, `e`.`length_sale_flash`, `e`.`sales_flash_active`, `e`.`flash_price`, `e`.`stock_max`, `e`.`start_sale_flash`, `e`.`data_sales_flash_order`, `e`.`retour_gratuit`, `e`.`delais_retour`, `e`.`customizable`, `e`.`customizable_value`, `e`.`product_gender`, `e`.`product_gender_value`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, 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`, `_table_is_in_stock_configurable`.`value` AS `is_in_stock_configurable`, `_table_qty`.`qty`, `_table_ordered_qty`.`stock_ordered_qty` AS `ordered_qty`, `e`.`price` AS `priceNoSolded`, `e`.`tax_class_id` AS `taxClassIdReal`, `e`.`tax_class_id`, IF( IF(sales_flash_active=1,IF(stock_max < `_table_qty`.qty,IF(DATE_ADD(start_sale_flash, INTERVAL length_sale_flash DAY) > NOW(),IF(start_sale_flash < NOW(),1,0),0),0),0) = 1,flash_price,IF(
                     IF(discount_price IS NULL,
                        1, IF(DATE(discount_price_from) <= DATE(NOW()), 1, IF(discount_price_from IS NULL , 1, 0 ))) > 0
                           AND IF(DATE(discount_price_to) IS NULL, 1, IF(DATE(discount_price_to) >= DATE(NOW()), 1, IF(DATE(discount_price_to) = '2001-01-01',1,0) )
                       ) > 0 AND discount_price < e.price AND discount_price != 0 , discount_price, e.price)) AS `final_price`, IF(sales_flash_active=1,IF(stock_max < `_table_qty`.qty,IF(DATE_ADD(start_sale_flash, INTERVAL length_sale_flash DAY) > NOW(),IF(start_sale_flash < NOW(),1,0),0),0),0) AS `girodprice_sales_flash`, e.price AS `price`, e.created_at AS `created_at`,  e.ranking + e.ranking * IF(landingpage_store.landingpage_id IS NOT NULL , 100, 0) + e.ranking * IF( e.manufacturer = 1470, 50 , 0) AS `ranking_calculated`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_flat_5` AS `e`
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
 LEFT JOIN `catalog_product_entity_int` AS `_table_is_in_stock_configurable` ON (_table_is_in_stock_configurable.entity_id=e.entity_id) AND (_table_is_in_stock_configurable.attribute_id=701)
 LEFT JOIN `cataloginventory_stock_item` AS `_table_qty` ON (_table_qty.product_id=e.entity_id) AND (_table_qty.stock_id=1)
 LEFT JOIN `cataloginventory_stock_item` AS `_table_ordered_qty` ON (_table_ordered_qty.product_id=e.entity_id) AND (_table_ordered_qty.stock_id=1)
 LEFT JOIN `girodlandingpage_item` AS `landingpage_item` ON landingpage_item.product_id = e.entity_id
 LEFT JOIN `girodlandingpage_item` AS `filter_landing` ON filter_landing.landingpage_id = landingpage_item.landingpage_id AND filter_landing.product_id = 22480
 LEFT JOIN `girodlandingpage` AS `landingpage` ON filter_landing.landingpage_id = landingpage.landingpage_id AND landingpage.is_active = 1
 LEFT JOIN `girodlandingpage_store` AS `landingpage_store` ON landingpage_store.landingpage_id = landingpage.landingpage_id AND landingpage_store.store_id = 5
 INNER JOIN `catalog_category_product_index` AS `category_index` ON category_index.`product_id` = e.entity_id AND category_index.category_id IN ( ) 
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='5' AND cat_index.visibility IN(3, 4) AND cat_index.category_id='11' WHERE (e.entity_id != 22480) GROUP BY `e`.`entity_id` ORDER BY `ranking_calculated` DESC LIMIT 10

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') 
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.prod' at line 14

#0 /home/www/magento-1.4/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/www/magento-1.4/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /home/www/magento-1.4/lib/Zend/Db/Adapter/Pdo/Abstract.php(241): Zend_Db_Adapter_Abstract->query('SELECT 1 AS `st...', Array)
#3 /home/www/magento-1.4/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('SELECT 1 AS `st...', Array)
#4 /home/www/magento-1.4/lib/Zend/Db/Adapter/Abstract.php(707): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/www/magento-1.4/lib/Varien/Data/Collection/Db.php(704): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#6 /home/www/magento-1.4/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(953): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select))
#7 /home/www/magento-1.4/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(793): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#8 /home/www/magento-1.4/lib/Varien/Data/Collection.php(264): Mage_Eav_Model_Entity_Collection_Abstract->load()
#9 /home/www/magento-1.4/app/code/local/Girodmedical/Girodrefnat/Block/Crossselling.php(76): Varien_Data_Collection->getItems()
#10 /home/www/magento-1.4/app/design/frontend/default/girodmedical/template/girodrefnat/crossselling.phtml(1): Girodmedical_Girodrefnat_Block_Crossselling->getCrosssellProduct()
#11 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(212): include('/home/www/magen...')
#12 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(239): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#13 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(253): Mage_Core_Block_Template->renderView()
#14 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(753): Mage_Core_Block_Template->_toHtml()
#15 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(520): Mage_Core_Block_Abstract->toHtml()
#16 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(471): Mage_Core_Block_Abstract->_getChildHtml('girodrefnat_cro...', true)
#17 /home/www/magento-1.4/app/design/frontend/default/girodmedical/template/catalog/product/view.phtml(181): Mage_Core_Block_Abstract->getChildHtml('girodrefnat_cro...')
#18 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(212): include('/home/www/magen...')
#19 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(239): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#20 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(253): Mage_Core_Block_Template->renderView()
#21 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(753): Mage_Core_Block_Template->_toHtml()
#22 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#23 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(753): Mage_Core_Block_Text_List->_toHtml()
#24 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(520): Mage_Core_Block_Abstract->toHtml()
#25 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(471): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#26 /home/www/magento-1.4/app/design/frontend/default/girodmedical/template/page/1column.phtml(49): Mage_Core_Block_Abstract->getChildHtml('content')
#27 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(212): include('/home/www/magen...')
#28 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(239): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#29 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(253): Mage_Core_Block_Template->renderView()
#30 /home/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(753): Mage_Core_Block_Template->_toHtml()
#31 /home/www/magento-1.4/app/code/core/Mage/Core/Model/Layout.php(529): Mage_Core_Block_Abstract->toHtml()
#32 /home/www/magento-1.4/app/code/local/Mage/Core/Controller/Varien/Action.php(389): Mage_Core_Model_Layout->getOutput()
#33 /home/www/magento-1.4/app/code/local/Girodmedical/Productredirection/controllers/Catalog/ProductController.php(57): Mage_Core_Controller_Varien_Action->renderLayout()
#34 /home/www/magento-1.4/app/code/local/Mage/Core/Controller/Varien/Action.php(418): Girodmedical_Productredirection_Catalog_ProductController->viewAction()
#35 /home/www/magento-1.4/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view')
#36 /home/www/magento-1.4/app/code/core/Mage/Core/Controller/Varien/Front.php(184): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#37 /home/www/magento-1.4/app/code/local/Mage/Core/Model/App.php(298): Mage_Core_Controller_Varien_Front->dispatch()
#38 /home/www/magento-1.4/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#39 /home/www/magento-1.4/index.php(110): Mage::run('be_fr', 'store')
#40 {main}