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 Window display decor

Inexpensive window dressing decor

 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 = '1083' GROUP BY _articles.id_article ORDER BY _articles.ordre ASC, _articles.id_article DESC LIMIT 0,9
Set of 3 cupcake snowmen
901213 - Set of 3 cupcake snowmen
Red painted metal heart to hang with lace-cut design and opening
717426 - Red painted metal heart to hang with lace-cut design and opening
Lace-cut red metal heart on pedestal with opening
717431 - Lace-cut red metal heart on pedestal with opening
Set of 3 ice-cream cone snowmen
901212 - Set of 3 ice-cream cone snowmen
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