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.
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 = '1077' GROUP BY _articles.id_article ORDER BY _articles.ordre ASC, _articles.id_article DESC LIMIT 0,9
Mirror-effect shiny paper carrier bags (2 models to choose from)
Heart to heart collection matt paper carrier bag (2 models to choose from)
Romantic red paper carrier with heart motif (2 models to choose from)
Leopard skin print paper carrier bags (2 models to choose from)
Matt paper carrier - hearts and butterflies (2 models to choose from)
Antique pink coloured man-made suedette pouches with coordinated cord drawstring (2 models to choose from)
Fuchsia organdy veil pouches with matching drawstring (in packs of 10) (2 models to choose from)
572630 - Lime green organdy veil pouches (in packs of 10)
