SELECT SQL_CALC_FOUND_ROWS _articles.id_article,_articles.es,
IFNULL( _articles.titre_es , IFNULL( _articles.titre_uk, _articles.titre_fr )) AS 'titre_es', IF( _articles.titre_es IS NULL , IF( _articles.titre_uk IS NULL , 'fr' , 'uk'), 'es' ) AS 'titre_langue',
_prix.ref_prix as '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.es = '1' AND _prix.actif = '1' AND ( (_prix.stock > 0 ) OR (_prix.stock = 0 AND sstitre1_es != '')) AND ( _prix.indispo = 0 OR (_prix.indispo = 1 AND _prix.indispo_date BETWEEN CURDATE() AND ADDDATE(CURDATE(), INTERVAL 7 DAY)) )
AND _articles.id_categorieA = '23'
AND _articles.id_categorieB = '68445' GROUP BY _articles.id_article ORDER BY _prix.date_miseenligne DESC, _articles.ordre ASC, _articles.id_article DESC LIMIT 0,9
370810 - Sachet de 1000 anses pour bracelets de montres - 8/10 mm
Red cowhide watch strap with embossed crocodile finish, split leather lining and steel buckle
(2 modelos para elegir)
Black cowhide watch strap with embossed crocodile finish, split leather lining and steel buckle
(4 modelos para elegir)
Navy cowhide watch strap with embossed crocodile finish, split leather lining and steel buckle
(2 modelos para elegir)
460371M - Brown cowhide watch strap with embossed crocodile finish, split leather lining and steel buckle
460343BM - Navy blue genuine leather watch strap with lizard skin finish and steel buckle
Brown genuine, corrected grain cowhide watch strap with steel buckle
(3 modelos para elegir)
460391N - Broad black genuine, corrected grain cowhide watch strap with steel buckle
460403 - Pink 10mm man-made watch strap with chrome buckle
Desplácese hasta el final de la página para ver más artículos...