- Accueil
- Hygiène
- Bucco-dentaire
- Interdentaire
Interdentaire
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `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`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`cip7`, `e`.`cip13`, `e`.`ean`, `e`.`remise_client`, `e`.`remise_achat`, `e`.`price_catalogue`, `e`.`directlog_fournisseur`, `e`.`directlog_produit`, `e`.`gamme`, `e`.`gamme_value`, `e`.`is_adhesion`, `e`.`is_print`, `e`.`format`, `e`.`format_value`, `e`.`support`, `e`.`support_value`, `e`.`remise_exceptionnelle`, `e`.`stock_exceptionnel`, `e`.`date_remise`, `e`.`stock_initial`, `e`.`is_charge`, `e`.`s30`, `e`.`exclude_groupement`, (SELECT MIN(price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `price`, (SELECT MIN(final_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `final_price`, (SELECT MIN(tax_class_id) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `tax_class_id`, (SELECT MIN(min_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `min_price`, (SELECT MIN(max_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `max_price`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, 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`, (SELECT MIN(price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `price`, (SELECT MIN(final_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `final_price`, (SELECT MIN(tax_class_id) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `tax_class_id`, (SELECT MIN(min_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `min_price`, (SELECT MIN(max_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `max_price`, (SELECT MIN(price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `price`, (SELECT MIN(final_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `final_price`, (SELECT MIN(tax_class_id) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `tax_class_id`, (SELECT MIN(min_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `min_price`, (SELECT MIN(max_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `max_price`, (SELECT MIN(price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `price`, (SELECT MIN(final_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `final_price`, (SELECT MIN(tax_class_id) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `tax_class_id`, (SELECT MIN(min_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `min_price`, (SELECT MIN(max_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `max_price` FROM `catalog_product_flat_1` AS `e`
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(2, 4) AND cat_index.category_id = '1513' AND cat_index.is_parent=1
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 WHERE (e.manufacturer NOT IN('5610')) ORDER BY `e`.`gamme_value` ASC LIMIT 96
Laboratoires
- 3M SANTE
- A-DERMA
- AGETI
- ALVITA
- AMDIPHARM
- ARKOPHARMA
- ARROW
- ASCENSIA DIABETES CARE
- ASEPTA
- AVENE
- AVRIL COSMETIQUE BIO
- BABYDERME
- BAILLEUL
- BAYER CONSUMER HEALTH
- BAYER SCHERING PHARMA
- BD MEDICAL
- BEAPHAR
- BEAUTERRA
- BIOCODEX
- BIODERMA
- BIOFREEZE
- BIOSTIME
- BLUE-LENS
- BOIRON
- BOUCHARA
- BRAUN
- BROTHIER-NOGUES
- C'EST MOI QUI L'AI FAIT
- CARRARE
- CATTIER
- CERAVE
- CHAUVIN BAUSCH & LOMB
- CLEANEAR
- COLOPLAST
- CONVATEC
- COVID-19
- CRYOBEAUTY
- DAYANG
- DAZONT
- DERMOPHIL (MELISANA)
- DIFRAX
- DISSOLVUROL
- DODIE
- DUCRAY
- DURANCE
- DUREX
- EA PHARMA
- EAU DE MELISSE
- EG LABO
- ELANCO (MMX, CAPSTAR)
- ELANCO EX-BAYER SA
- ELASTOPLAST
- ELERTE
- ELIXIR & CO
- EUCERIN
- EVERGREEN PARAKITO
- EXPANSCIENCE
- FAMADEM
- GABA
- GALDERMA
- GALLIA
- GENEVRIER
- GIFRER
- GILBERT
- GRAVIER
- GRIMBERG
- GSK
- GUM SUNSTAR
- HARTMANN
- HORIZANE SANTE
- HORUS PHARMA
- HRA
- IGLOO
- INELDEA
- IPRAD
- IPSEN CONSUMER HEALTHCARE
- JOHNSON ET JOHNSON
- KLORANE
- KNEIPP
- LA CHENAIE
- LA ROCHE POSAY
- LABORATOIRES VISIOMED
- LANSINOH
- LAUDAVIE
- LCA
- LEHNING
- LES CHOCHOTTES
- LES PETITS BAINS DE PROVENCE
- LES SECRETS DE LOLY
- LIEBHERR
- LIFESCAN
- LILLY
- LOHMANN & RAUSCHER
- MAM
- MANIX
- MATERIEL BUREAUTIQUE
- MAYOLY SPINDLER
- MEDIATEUR
- MEDIFLUX
- MICROLIFE
- MODILAC
- MÖLNLYCKE
- MUSTELA
- MYLAN MEDICAL
- NAT&FORM
- NATURANCIA
- NEOPULSE
- NESTLE HEALTH SCIENCE
- NHS MENARINI
- NUTRAVALIA
- NUTREOV
- NUTRIBEN
- ORLIMAN (SM EUROPE)
- PEDIACT
- PELUCHO
- PFIZER SANTE
- PHARM'UP
- PHARMACIE DE FRANCE
- PHARMAGUIDEUR
- PHARMASTRA
- PHYTEA DEDICATE
- PHYTO-TERRA
- PHYTOMANIA FRANCE
- PIERRE FABRE MEDICAL CARE
- PIERRE FABRE NATURACTIVE
- PIERRE FABRE ORAL CARE
- PROCTER & GAMBLE HEALTH
- PRODHEX
- PULMOLL
- PURESSENTIEL
- RECKITT BENCKISER
- RESPIRE
- RICHESSES DU MONDE
- ROCHE DIABETES CARE
- ROGE CAVAILLES
- RUBY - OB - NETT
- S.A.D
- SANTE VERTE
- SCHOLL
- SEA-BANDS
- SERVIER
- SMITH AND NEPHEW
- SOFIBEL - FUMOUZE
- SOINEO
- SOLENS
- SOVEDIS
- SUAVINEX
- SUNPASS
- SYNERGIA
- TECHNI PHARMA
- TETRA MEDICAL
- TEVA
- TEXTILE FRANCAIS
- THEA
- THERMACELL
- THUASNE
- TILMAN
- TOPICREM
- TRADIPHAR
- U.LABS (Unilever)
- URIAGE
- VICHY
- VISIOCLEAN
- VITAFLOR
- WELEDA
- YOGI TEA
- YOUR GOOD SKIN
- ZAMBON
- ZENTIVA

+ 10000 références
de médicaments OTC, LNR, et de parapharmacie.

Livraison 72h
sans franco, livraison en 72h par notre transporteur Chronopost.

Tarifs membres
négociés par nos acheteurs et réservés aux pharmaciens membres de la SRA.

Besoin de conseil ?
une équipe disponible pour vous répondre du lundi au vendredi.