Service Client Gratuit : 02 40 58 98 00

Satisfait ou remboursé sous 15 jours

Le matériel médical pour professionnels et particuliers
0 Mon panier Mon compte

Huile Essentielle de basilic exotique bio Green For Health

Huile Essentielle de basilic exotique bio Green For Health

( 0 Commentaire(s) )
Huile essentielle de basilic exotique bio - Digestif, Articulaire et musculaire : tonique digestif et hépatobiliaire et pour tous les spasmes digestifs (colites, coliques, ballonnements...) et spasmes des menstruations.

Voir la description complète.

Prix Girodmedical :

7,73 € TTC

Frais de livraison estimés : 6,50 €

Disponibilité : sous 15 jours

Add Items to Cart

Quantité :

Description
Détails
Avis
Contact

Huile essentielle de basilic bio - Digestif, Articulaire et musculaire



Flacon compte gouttes de10ml



L’huile essentielle de basilic ou ocimum basilicum contient principalement les molécules aromatiques de la famille des méthyl éthers, anti spasmodiques majeurs. Son usage est tout à fait approprié comme tonique digestif et hépatobiliaire et pour tous les spasmes digestifs (colites, coliques, ballonnements...) et spasmes des menstruations. Elle peut être irritante pour la peau à l’état pur, il est donc conseillé de la diluer à 20% dans une huile végétale

Toutes les huiles essentielles Green For Health sont 100% naturelles, certifiées biologiques et sont chémotypées.

100% du total des ingrédients sont issus de l’agriculture biologique.

Ingrédients issus de l’agriculture biologique certifié par ECOCERT FR-BIO-01.

Tenir hors de portée des enfants. Utilisation interdite chez les enfants de moins de 6 ans, les femmes enceintes et allaitante.

Détails sur le produit Huile Essentielle de basilic exotique bio Green For Health :

Référence 000000239
Poids 0.05 Kg
Fabricant Green For Health

Besoin d'informations complémentaires sur le produit Huile Essentielle de basilic exotique bio Green For Health ?






* 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 = 3035, 50 , 0) AS `ranking_calculated`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_flat_1` 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 = 71056
 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 = 1
 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='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id='11' WHERE (e.entity_id != 71056) 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 /var/www/magento-1.4/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/magento-1.4/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /var/www/magento-1.4/lib/Zend/Db/Adapter/Pdo/Abstract.php(241): Zend_Db_Adapter_Abstract->query('SELECT 1 AS `st...', Array)
#3 /var/www/magento-1.4/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('SELECT 1 AS `st...', Array)
#4 /var/www/magento-1.4/lib/Zend/Db/Adapter/Abstract.php(707): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /var/www/magento-1.4/lib/Varien/Data/Collection/Db.php(704): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#6 /var/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 /var/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 /var/www/magento-1.4/lib/Varien/Data/Collection.php(264): Mage_Eav_Model_Entity_Collection_Abstract->load()
#9 /var/www/magento-1.4/app/code/local/Girodmedical/Girodrefnat/Block/Crossselling.php(76): Varien_Data_Collection->getItems()
#10 /var/www/magento-1.4/app/design/frontend/default/girodmedical/template/girodrefnat/crossselling.phtml(1): Girodmedical_Girodrefnat_Block_Crossselling->getCrosssellProduct()
#11 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(212): include('/var/www/magent...')
#12 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(239): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#13 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(253): Mage_Core_Block_Template->renderView()
#14 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(753): Mage_Core_Block_Template->_toHtml()
#15 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(520): Mage_Core_Block_Abstract->toHtml()
#16 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(471): Mage_Core_Block_Abstract->_getChildHtml('girodrefnat_cro...', true)
#17 /var/www/magento-1.4/app/design/frontend/default/girodmedical/template/catalog/product/view.phtml(181): Mage_Core_Block_Abstract->getChildHtml('girodrefnat_cro...')
#18 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(212): include('/var/www/magent...')
#19 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(239): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#20 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(253): Mage_Core_Block_Template->renderView()
#21 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(753): Mage_Core_Block_Template->_toHtml()
#22 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#23 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(753): Mage_Core_Block_Text_List->_toHtml()
#24 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(520): Mage_Core_Block_Abstract->toHtml()
#25 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(471): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#26 /var/www/magento-1.4/app/design/frontend/default/girodmedical/template/page/1column.phtml(49): Mage_Core_Block_Abstract->getChildHtml('content')
#27 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(212): include('/var/www/magent...')
#28 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(239): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#29 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Template.php(253): Mage_Core_Block_Template->renderView()
#30 /var/www/magento-1.4/app/code/core/Mage/Core/Block/Abstract.php(753): Mage_Core_Block_Template->_toHtml()
#31 /var/www/magento-1.4/app/code/core/Mage/Core/Model/Layout.php(529): Mage_Core_Block_Abstract->toHtml()
#32 /var/www/magento-1.4/app/code/local/Mage/Core/Controller/Varien/Action.php(389): Mage_Core_Model_Layout->getOutput()
#33 /var/www/magento-1.4/app/code/local/Girodmedical/Productredirection/controllers/Catalog/ProductController.php(57): Mage_Core_Controller_Varien_Action->renderLayout()
#34 /var/www/magento-1.4/app/code/local/Mage/Core/Controller/Varien/Action.php(418): Girodmedical_Productredirection_Catalog_ProductController->viewAction()
#35 /var/www/magento-1.4/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view')
#36 /var/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 /var/www/magento-1.4/app/code/local/Mage/Core/Model/App.php(298): Mage_Core_Controller_Varien_Front->dispatch()
#38 /var/www/magento-1.4/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#39 /var/www/magento-1.4/index.php(110): Mage::run('fr_fr', 'store')
#40 {main}