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 = '7301' 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 = '1552' AND p2c2.categories_id NOT IN (1552,1167) AND c.parent_id NOT IN (1552) AND p.products_id != '7301' AND p.products_status = 1 GROUP BY p.products_id ORDER BY RAND()


BLAIR Gail Medium Drawstring

BLAIR Gail Medium Drawstring

BLAIR Gail Medium Drawstring

$240.00

Black/Taupe (BKT)
 
 
 
Cinch up all your essentials in this adorable medium sized drawstring bucket bag.

Features: Features: Magnetic closure. Interior slide pocket. Adjustable shoulder strap.

10.5 x 9.5 x 7"

Style # 933

Collection code # BLAR