SELECT catC.id_categorieC, catC.categorieC_uk FROM _articles art
INNER JOIN _categorieC catC USING(id_categorieC)
WHERE catCuk = '1' AND catC.SE = '1'
AND art.id_categorieB = 62
GROUP BY catC.id_categorieC
ORDER BY catC.ordre
Self-adhesive gift labels can be incorporated as part of your communication campaign, they can be used to seal your bags, hold a curling ribbon in place or just to add a finishing touch to a gift. Personalised with your brand identity, contact details or simply your logo, the label will add a touch of contrast and information to your gifts.
Contact us and learn more about creating your very own self-adhesive labels.
See description
FIRSTSELECT SQL_CALC_FOUND_ROWS _prix.id_article,_articles.uk,
IFNULL( _prix.conditionnement_uk , IFNULL( _prix.conditionnement_uk, _prix.conditionnement_fr )) AS 'titre_uk', IF( _prix.conditionnement_uk IS NULL , IF( _prix.conditionnement_uk IS NULL , 'fr' , 'uk'), 'uk' ) AS 'titre_langue', _prix.ref_prix as 'reference', _articles.id_categorieA, _articles.id_categorieB, _articles.id_categorieC, _articles.selection , _prix.id_article, Tri_Caract.Nom_fr
FROM _articles
INNER JOIN _prix on _articles.id_article = _prix.id_article
LEFT OUTER JOIN Tri_Trieur on _prix.id_prix = Tri_Trieur.ID_Prix
LEFT OUTER JOIN Tri_Caract on Tri_Caract.ID_Caract = Tri_Trieur.ID_Caract3
WHERE _articles.uk = '1'
AND _prix.actif = '1'
AND ( (_prix.stock > 0 ) )
AND ( (_prix.indispo = 0 ) OR ( _prix.indispo = 1 AND _prix.indispo_date < ADDDATE(_prix.indispo_date, INTERVAL 7 DAY) ) )
AND _prix.SE = 1
AND _articles.id_categorieA = '7' AND _articles.id_categorieB = '62' ORDER BY _prix.date_miseenligne DESC, _articles.ordre, _articles.id_article DESC LIMIT 0, 12
10.80€ TTC - Round Kraft-coloured adhesive gift labels with Joyeux anniversaire and balloons (x500)
11.94€ TTC - Oval adhesive gift labels with Félicitations in white, black and gold (x500)
11.94€ TTC - Christmas tree-shaped adhesive gift labels with Joyeux Noël in green and gold (x500)
11.94€ TTC - Gift-shaped adhesive gift labels with Joyeux Noël in red and gold (x500)
11.94€ TTC - Oval adhesive gift labels with Joyeux Noël in red, white and gold (x500)
11.94€ TTC - Oval adhesive gift labels with Joyeuses fêtes in black and gold (x500)
11.94€ TTC - Oval adhesive gift labels with Joyeuses fêtes in white and silver (x500)
10.80€ TTC - Round white adhesive gift labels with Ouvre vite and floral wreath motif (x500)
11.94€ TTC - Round adhesive gift labels with Plaisir d'offrir in black and gold (x500)
11.94€ TTC - Oval adhesive gift labels with Joyeux Anniversaire and champagne glasses in gold and black (x500)
11.94€ TTC - Bauble-shaped adhesive gift labels with Joyeux Noël in gold, red and black (x500)
11.94€ TTC - Star-shaped adhesive gift labels with Joyeuses fêtes in gold and white (x500)
Sign up and stay up to date with our new products and great deals!
OK
Delivery France, Luxembourg, Belgium: Delivery in 48/72 hrs - Other countries: 2 to 5 days according to destination. Some items may take longer to be delivered.
FR
