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 Office supplies

Cheap office supplies

 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 = '1081' GROUP BY _articles.id_article ORDER BY _articles.ordre ASC, _articles.id_article DESC LIMIT 0,9
French \\\'Bonne Fete maman\\\' poster
714402 - French 'Bonne Fete maman' poster
Poster with French \\\'Soldes\\\' labels (x2)
712985 - Poster with French 'Soldes' labels (x2)
Posters with PROMOTION message
713679 - Posters with PROMOTION message
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