SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 3 AND 12
GROUP BY g1.name
ORDER BY g1.lftSELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 13 AND 20
GROUP BY g1.name
ORDER BY g1.lft
Info: Your browser does not accept cookies. If you want to put products into your cart and purchase them you need to enable cookies.
Christmas Personalized Wine and Champagne Bottle Labels - Add a bit of elegance to your party with our personalized wine and champagne bottle labels. Use as a table accessory or give out a bottle as a party favor. You can choose from standard wine and champagne bottle labels or our personalized mini bottle labels. Our personalized bottle labels coordinate with our other custom party favors. Personalize your bottle labels any way you'd like. Use our additional information box below for any changes in personalization.
Our custom bottle labels are laser printed on glossy paper and will not run or smudge from bottle drips. Please note: These labels are not waterproof - they can be refrigerated, but will not hold up well in ice.
Standard size: 5-1/2” wide x 4” tall (size can be adjusted to fit your bottle)
Mini size: 4” wide x 2-1/2” tall (size can be adjusted to fit your bottle)
There is no extra charge for custom size within 1”
Min. order quantity: 12 standard or 24 mini