En poursuivant votre navigation, vous acceptez l'utilisation de cookies destinés à améliorer la performance de ce site et à vous proposer des services et contenus personnalisés. Pour en savoir plus ou modifier vos paramètres cliquez ici.
Recherche Laval Europe
Specialist supplier accompanying Clockmakers and Jewellers for four generations
 All our products
Home Good deals Ear and nose piercing

Ear and nose piercing

 See description
SELECT SQL_CALC_FOUND_ROWS _articles.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', _articles.reference,_articles.id_categorieA,_articles.id_categorieB,_articles.id_categorieC,_articles.selection FROM _articles INNER JOIN _prix on _articles.id_article = _prix.id_article WHERE _articles.uk = '1' AND _prix.actif = '1' AND ( (_prix.stock > 0 ) OR (_prix.stock = 0 AND sstitre1_uk != '')) AND ( _prix.indispo = 0 OR (_prix.indispo = 1 AND _prix.indispo_date BETWEEN CURDATE() AND ADDDATE(CURDATE(), INTERVAL 15 DAY)) ) AND _articles.id_categorieA = '23' AND _articles.id_categorieB = '29188' GROUP BY _articles.id_article ORDER BY _articles.ordre ASC, _articles.id_article DESC LIMIT 0,9
Steel ear-piercing stud earrings by Studex
341006 - Steel ear-piercing stud earrings by Studex
Caflon gilded steel ear piercing studs
342041 - Caflon gilded steel ear piercing studs
Gold-plated \\\'Studex\\\' ear-piercing stud earrings
341005 - Gold-plated 'Studex' ear-piercing stud earrings
1

Newsletter

Sign up and stay up to date with our news, special offers and new arrivals...

Specialist supplier accompanying clockmakers and jewellers for four generations

Terms and Conditions - Legal notices