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 = '6562' 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 = '1603' AND p2c2.categories_id NOT IN (1603) AND c.parent_id NOT IN (1603) AND p.products_id != '6562' 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 != '6562' AND p.products_status = 1 GROUP BY p.products_id ORDER BY RAND() LIMIT 3


Men's RFOB Small Billfold

Men's RFOB Small Billfold

Men's RFOB Small Billfold

$46.00

Robins Egg (428) REG Green (301) GRN Orange (801) ORG
 
 
 

The perfect slim front-pocket wallet.

4 x 3.125 x 0.75

Features: Bill compartment, ID window with thumb glide, 4 credit card slots, 2 exterior pockets

Style # 1334

Collection code # RFOB