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 #EE01WOR - Organza Rose
Pure elegance! Our matte silver and matte gold 2" square favor boxes will add a gorgeous finish to your tables. Wrapped with glittery sheer ribbon topped with a matching hand rolled rose. Available in sheer white, sheer ivory or sheer gold.
Kit: Flat pack box, organza ribbon* and rose
* this ribbon is not suitable to be cut and shipped in individual pieces. You will receive enough ribbon for each box ordered. Cut to 30" lengths.