SELECT catC.id_categorieC, catC.categorieC_uk FROM _articles art
INNER JOIN _categorieC catC USING(id_categorieC)
WHERE catCuk = '1' AND catC.SD = '1'
AND art.id_categorieB = 62
GROUP BY catC.id_categorieC
ORDER BY catC.ordre
A great way of adding the final touch to your gifts.
Why not have some gift labels custom printed with you brand name, logo and / or address in order to combine an original method of communication with a useful decorative item.
Come and visit our gift packaging store in Paris
We bring you a fantastic range of gift packaging items as well as many that can be made-to-measure. So get in touch today.
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.SD = 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.