- Accueil
- Accessoires
- Compression
- Opaque
- Collant
Collant
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` 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 = '1076' 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')) AND (FIND_IN_SET(59,e.exclude_groupement) IS NULL || FIND_IN_SET(59,e.exclude_groupement) = 0) ORDER BY `e`.`gamme_value` ASC LIMIT 96
Aucun produit ne correspond à la sélection
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
- BIEN
- BIOCODEX
- BIODERMA
- BIOFREEZE
- BIOGARAN
- BIOSTIME
- BLUE-LENS
- BOIRON
- BOUCHARA
- BROTHIER-NOGUES
- C'EST MOI QUI L'AI FAIT
- CARRARE
- CATTIER
- CERAVE
- CHAUVIN BAUSCH & LOMB
- CLEANEAR
- COLOPLAST
- CONVATEC
- COVID-19
- CRAZY RUMORS
- 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
- EPITACT
- EUCERIN
- EVERGREEN PARAKITO
- EXPANSCIENCE
- FAMADEM
- FLO&GLO
- GABA
- GALDERMA
- GALLIA
- GENEVRIER
- GIFRER
- GILBERT
- GRAVIER
- GRIMBERG
- GSK
- GUM SUNSTAR
- HARTMANN
- HORIZANE SANTE
- HORUS PHARMA
- HRA
- IGLOO
- INELDEA
- IPRAD
- IPSEN CONSUMER HEALTHCARE
- JALDES
- JOHNSON ET JOHNSON
- KLORANE
- KNEIPP
- LA CHENAIE
- LA ROCHE POSAY
- LA ROSÉE
- LABORATOIRES ROIG
- LABORATOIRES VISIOMED
- LADY GREEN
- LANSINOH
- LAUDAVIE
- LCA
- LEHNING
- LES CHOCHOTTES
- LES PETITS BAINS DE PROVENCE
- LES SECRETS DE LOLY
- LIEBHERR
- LIFESCAN
- LILLY
- LOHMANN & RAUSCHER
- LUTTI - VICHY
- MAM
- MANIX
- MATERIEL BUREAUTIQUE
- MAYOLY SPINDLER
- MEDIATEUR
- MEDIFLUX
- MICROLIFE
- MODILAC
- MÖLNLYCKE
- MON COMPLICE
- MUSTELA
- MYLAN MEDICAL
- NAT&FORM
- NATURANCIA
- NEOPULSE
- NESTLE HEALTH SCIENCE
- NHS MENARINI
- NUTRAVALIA
- NUTREOV
- NUTRIBEN
- OMEGA PHARMA - PERRIGO
- ORLIMAN (SM EUROPE)
- PEDIACT
- PELUCHO
- PFIZER SANTE
- PHARM'UP
- PHARMACIE DE FRANCE
- PHARMAGUIDEUR
- PHARMASTRA
- PHYTEA DEDICATE
- PHYTOMANIA FRANCE
- PIERRE FABRE MEDICAL CARE
- PIERRE FABRE NATURACTIVE
- PIERRE FABRE ORAL CARE
- PODERM
- PROCTER & GAMBLE HEALTH
- PRODHEX
- PULMOLL
- PURE ENCAPSULATIONS
- PURESSENTIEL
- RECKITT BENCKISER
- RESPIRE
- ROCHE DIABETES CARE
- ROGE CAVAILLES
- RUBY - OB - NETT
- S.A.D
- SANTE VERTE
- SCHMID'T
- SCHOLL
- SEA-BANDS
- SEBAMED
- SERVIER
- SMITH AND NEPHEW
- SOFIBEL - FUMOUZE
- SOINEO
- SOLENS
- SOVEDIS
- SUAVINEX
- SUN COAT
- SUNPASS
- SYNERGIA
- TECHNI PHARMA
- TETRA MEDICAL
- TEVA
- TEXTILE FRANCAIS
- THEA
- THERMACELL
- TILMAN
- TOPICREM
- TRADIPHAR
- U.LABS (Unilever)
- URIAGE
- VICHY
- VISIOCLEAN
- VITAFLOR
- WELBE
- 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.