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.lftBridal Shower FavorsFavor BoxesBox Only - No Candy #PM-01
Our Gable favor boxes feature a unique shape with a handy handle. All boxes are one piece with a semi-automatic bottom and a gable handle top and are brown in the inside. Easy to assemble, the two sides fold together for the handle and then the ends fold up and lock on to a tab extending from the handle.
Perfect to stuff with fun favors or use as a hospitality box for your out of town guests. However you use it, this trendy favor box is a fabulous way to thank your guests for sharing in your special day.
Box Size: 8" x 4-7/8" x 5-1/4" (size is inside and does not include the handle or gable)