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.
Quench your thirst with our Personalized Water Bottle Party Favors! These are the Labels Only! Our personalized water bottle labels are printed on glossy paper. Our labels are laser printed and will not smudge from water drips. Our labels are easily applied with a glue stick and will come with easy to follow instructions.
If you are putting your bottle on ice, please contact us for information regarding waterproof labels.
Min. Order: 24 pcs.
Please note:
Our standard labels fit the new eco-friendly Poland Spring water
bottles. If you are not using
Poland Spring, please include the size label you will need for your
bottle. If you do not know the size, please let us know the brand you
are using.
To add a photo to
your wrapper, just email your photo to sales@anyatyler.com
You will receive a proof of your wrapper prior to printing