SELECT p2c.categories_id, c.parent_id FROM products_to_categories p2c, categories c WHERE p2c.categories_id = c.categories_id AND p2c.products_id AND c.parent_id IN (637,1602) AND p2c.products_id = '7429' AND c.categories_id != 1620 SELECT p.products_id FROM products p, products_to_categories p2c1, products_to_categories p2c2, categories c WHERE p.products_id = p2c1.products_id AND p.products_id = p2c2.products_id AND p2c1.categories_id != p2c2.categories_id AND p2c2.categories_id = c.categories_id AND p2c1.categories_id = '1621' AND p2c2.categories_id NOT IN (1621,1621) AND c.parent_id NOT IN (1621) AND p.products_id != '7429' AND p.products_status = 1 GROUP BY p.products_id ORDER BY RAND()


Valencia- Flat Pouch

Valencia- Flat Pouch

Valencia- Flat Pouch

$52.00

Cream (CRM) Multi (MLT) Black (BLK)
 
 
 
Sleek and simple flat pouch with LODIS emboss tab.

Features: Zip closure, center tab emboss logo.

5.5" x 8.5"

Style # 271

Collection code # VLCI