• Mon caddie
  • My account
  •  
Minimum order: €50 incl. VAT (without postage and packaging fees)
  • Mon caddie
  • My account
  •  
  • FR
 Refine my search

Rubber findings

SELECT SQL_CALC_FOUND_ROWS _prix.id_article,_articles.uk, IFNULL( _articles.titre_uk , IFNULL( _articles.titre_uk, _articles.titre_fr )) AS 'titre_uk', IF( _articles.titre_uk IS NULL , IF( _articles.titre_uk IS NULL , 'fr' , 'uk'), 'uk' ) AS 'titre_langue', _prix.ref_prix as 'reference', _articles.id_categorieA, _articles.id_categorieB, _articles.id_categorieC, _articles.selection , _prix.id_article, Tri_Caract.Nom_fr FROM _articles INNER JOIN _prix on _articles.id_article = _prix.id_article INNER JOIN Tri_Trieur on _prix.id_prix = Tri_Trieur.ID_Prix LEFT OUTER JOIN Tri_Caract on Tri_Caract.ID_Caract = Tri_Trieur.ID_Caract3 WHERE _articles.uk = '1' AND _prix.actif = '1' AND ( (_prix.stock > 0 ) ) AND ( (_prix.indispo = 0 ) OR ( _prix.indispo = 1 AND _prix.indispo_date < ADDDATE(_prix.indispo_date, INTERVAL 7 DAY) ) ) AND _prix.SE = 1 AND _articles.id_categorieA = '2' AND _articles.id_categorieB = '11' GROUP BY Tri_Trieur.id_article, Tri_Trieur.id_article, Tri_Trieur.ID_Caract3 ORDER BY _prix.date_miseenligne DESC, _articles.ordre, _articles.id_article DESC LIMIT 0, 12
Comfort backs for earclips
10.56€ TTC - Comfort backs for earclips
1

Selfor logo

OUR STORES :

SELFOR, 20 rue Réaumur, 75003 Paris
01 42 78 06 66 -  selfor@selforparis.com

SELFOR +, 11 rue Réaumur, 75003 Paris
01 42 74 11 76 - selforplus@selforparis.com

SELFOR Décor, 19 rue Réaumur, 75003 Paris
01 42 74 48 08 - selfordecor@selforparis.com

 

 

INFORMATION

100% secure payment
Terms and conditions
Legal notices

 

MY PROFILE

Open an account
Log in
My orders
My basket

 

FIND US

Facebook

Instagram

Pinterest

Youtube

 

NEWSLETTER

Sign up and stay up to date with our new products and great deals! 

OK

Delivery
France, Luxembourg, Belgium: Delivery in 48/72 hrs - Other countries: 2 to 5 days according to destination.
Some items may take longer to be delivered.