Service Client Gratuit : 028 08 68 81

Satisfait ou remboursé sous 15 jours

0 Mon panier Mon compte

Modèle en tissu de la poitrine W43044

Modèle en tissu de la poitrine W43044

( 0 Commentaire(s) )
Modèle en tissu de la poitrine - La couche cutanée pelée de ce modèle de poitrine révèle une interprétation en couleur de la structure interne

Voir la description complète.

Prix public : 106,48 € TTC

Prix GirodMedical :

101,16 € TTC

Soit une économie de 5 %

Frais de livraison estimés : 5,51 €

Disponibilité : sous 30 jours

Add Items to Cart

Quantité :

Description
Détails
Avis
Contact

Modèle en tissu de la poitrine

La couche cutanée pelée de ce modèle de poitrine révèle une interprétation en couleur de la structure interne de la poitrine, y compris l'inflammation d'un canal galactophore bouché. Lorsque l'on tire sur l'anneau placé à l'arrière, le mamelon se rétracte, représentant ainsi un mamelon rétracté. L'insertion en mousse placée en dessous de la couche cutanée permet l'enseignement de la prévention, du soulagement et des effets des seins gonflés.

Détails sur le produit Modèle en tissu de la poitrine W43044 :

Référence W43044
Poids 3.00 Kg
Pays de fabrication Allemagne
Fabricant 3B scientific

Besoin d'informations complémentaires sur le produit Modèle en tissu de la poitrine W43044 ?






* 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 = 7, 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 = 2300
 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 != 2300) 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}