SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (111) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 8) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (111) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 8 ) ORDER BY position ASC LIMIT 1

Item #: BRCH28

Brass CZ Cuban Chain W/CZ Clasp


Gold Plated 12MM (20 inch)
Gold Plated 12MM (24 inch)
Gold Plated 12MM (8.5inch)
Silver Plated 12MM (20'' inch)
Silver Plated 12MM (24'' inch)
Silver Plated 12MM (8.5'' inch)
Gold plated 15MM (24 inch)
Gold plated 15MM (8.5 inch)