SELECT SQL_CALC_FOUND_ROWS _articles.id_article,_articles.de,
IFNULL( _articles.titre_de , IFNULL( _articles.titre_uk, _articles.titre_fr )) AS 'titre_de', IF( _articles.titre_de IS NULL , IF( _articles.titre_uk IS NULL , 'fr' , 'uk'), 'de' ) 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.de = '1' AND _prix.actif = '1' AND ( (_prix.stock > 0 ) OR (_prix.stock = 0 AND sstitre1_de != '')) 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 Modelle nach Wahl)
Plastic jewellery presentation box sheathed in grey paper with white edging
(4 Modelle nach Wahl)
Plastic jewellery presentation box sheathed in white paper with black edging
(4 Modelle nach Wahl)
702193 - White card necklace presentation box with fuchsia magnetic seal and sides
White and lime green card jewellery presentation box with magnetic seal
(2 Modelle nach Wahl)
White and blue card jewellery presentation box with magnetic seal
(2 Modelle nach Wahl)
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
Nach unten scrollen, um weitere Artikel anzuzeigen...
