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

Item #: BRCH30

Brass 14MM CZ Cuban Chain


Gold Plated(18 inch)
Silver Plated(18 inch)
Rose Color(18 inch)
Two Tone Color(18 inch)
Gold Plated(20 inch)
Silver Plated(20 inch)
Two Tone Color(20 inch)
Gold Plated(22 inch)
Silver Plated(22 inch)
Rose Color(22 inch)
Two Tone Color(22inch)
Gold Plated(24 inch)
Silver Plated(24 inch)
Rose Color(24 inch)
Two Tone Color(24 inch)
Gold Plated(8.5 inch)
Silver Plated(8.5 inch)
Rose Color(8.5 inch)
Two Tone Color(8.5 inch)