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 36, 12
11.70€ TTC - French self-adhesive 'Saint Valentin' gift labels featuring Cupid
11.94€ TTC - Hot foil printed Heart Gift labels
11.94€ TTC 6.00€ TTC - Square self-adhesive 'I WISH YOU LIKE IT' gold hot foil printed gift labels
11.94€ TTC - Oval French ™Joyeux Noël™ adhesive gift labels in silver
11.94€ TTC - French ™Joyeux Noël™ oval adhesive gift labels in gold
11.94€ TTC - French ™Ouvre vite !™ Christmas labels Gold hot-foil printed French ™Joyeuses fêtes™ labels
11.94€ TTC - Hot foil printed French 'Joyeuses Fêtes' self-adhesive gift labels - gold background
11.94€ TTC - Hot foil printed French 'Joyeuses Fêtes' self-adhesive gift labels - red background
11.94€ TTC - Hot foil printed French 'Joyeuses Fêtes' self-adhesive gift labels - grey background
11.70€ TTC 7.20€ TTC - Etiquettes cadeau Plaisir d'offrir papier rayé et dorure à chaud argent
11.70€ TTC 6.00€ TTC - Self-adhesive mosaic heart Gift Labels
11.94€ TTC 6.00€ TTC - Square self-adhesive 'I WISH YOU LIKE IT' silver and black hot foil printed gift labels
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.