Service Client Gratuit : +33 240 58 98 00

Satisfait ou remboursé sous 15 jours

0 My Cart My account

Breast tissue model, W43044

Breast tissue model, W43044

( 0 Review(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

See full description.

Regular Price: €105.60 inc. VAT

Price GirodMedical:

€100.32 inc. VAT

A savings of 5 %

Estimated Shipping : €16.68

Available: in 30 days

Add Items to Cart

Qty:

Product description
Product Specification
Customer review
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.

Product Breast tissue model, W43044 details:

Reference W43044
Weight 3.00 Kg
Country of Production Germany
Manufacturer 3B scientific

Write Your Own Review on Breast tissue model, W43044





* Required Fields

More info about Breast tissue model, W43044 ?






* Required Fields

SELECT 1 AS `status`, `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `e`.`availablestock`, `e`.`before_sold_price`, `e`.`customizable`, `e`.`customizable_value`, `e`.`data_sales_flash_order`, `e`.`default_supply_delay`, `e`.`delais_retour`, `e`.`discount_price`, `e`.`discount_price_from`, `e`.`discount_price_to`, `e`.`expedition_directe_fournisseur`, `e`.`flash_price`, `e`.`image_label`, `e`.`is_in_stock_configurable`, `e`.`is_in_stock_configurable_value`, `e`.`length_sale_flash`, `e`.`links_exist`, `e`.`manufacturer`, `e`.`manufacturer_value`, `e`.`marge`, `e`.`materiel_rembourse_lpp`, `e`.`materiel_rembourse_lpp_value`, `e`.`mea_product_date`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`ordered_qty`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`product_gender`, `e`.`product_gender_value`, `e`.`ranking`, `e`.`required_options`, `e`.`retour_gratuit`, `e`.`sales_flash_active`, `e`.`sale_price`, `e`.`shipment_type`, `e`.`short_description`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`start_sale_flash`, `e`.`stock_max`, `e`.`supply_date`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`ugiftcert_amount_config`, `e`.`url_key`, `e`.`weight_type`, `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_15` 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 = 15
 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='15' 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('eu_en', 'store')
#40 {main}