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 = '6914' 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 = '0' AND p2c2.categories_id NOT IN (0) AND c.parent_id NOT IN (0) AND p.products_id != '6914' AND p.products_status = 1 GROUP BY p.products_id ORDER BY RAND() SELECT p.products_id FROM products p, products_to_categories p2c, categories c WHERE p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND p.products_id != '6914' AND p.products_status = 1 GROUP BY p.products_id ORDER BY RAND() LIMIT 6


BLAIR ADDY BUCKET SALE COLORS

BLAIR ADDY BUCKET SALE COLORS

BLAIR ADDY BUCKET SALE COLORS

$216.00 Sale Price: $108.00

Nutmeg/Cobalt (NUC)
 
 
 

Unlined bucket shaped bag with a detachable pouch included; carry this versatile bag for a chic look!

Features: Unlined bag with pouch included. Magnetic closure for bag, zip closure for pouch. Interior zip pocket, 2 slide pockets.

12.25 x 9.5 x 4.5

Handle Drop: 9.5

Style # 834

Collection code # BLAR