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',
_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.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 15 DAY)) )
AND _articles.id_categorieA = '23'
AND _articles.id_categorieB = '1079' GROUP BY _articles.id_article ORDER BY _articles.ordre ASC, _articles.id_article DESC LIMIT 0,9
Plastic jewellery presentation box sheathed in beige paper with white borders
(5 modelos para elegir)
Plastic jewellery presentation box sheathed in grey paper with white edging
(3 modelos para elegir)
Plastic jewellery presentation box sheathed in white paper with black edging
(3 modelos para elegir)
702193 - White card necklace presentation box with fuchsia magnetic seal and sides
White and lime green card jewellery presentation box with magnetic seal
(2 modelos para elegir)
White and blue card jewellery presentation box with magnetic seal
(2 modelos para elegir)
702504 - Satin finish silver coloured card bracelet box with black man-made foam insert
702399 - Glossy finish red card bracelet box with white man-made foam insert
702451 - Matchbox style card necklace box in matt purple and glossy white finish
Desplácese hasta el final de la página para ver más artículos...
