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 < 138) 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 > 138 ) ORDER BY position ASC LIMIT 1

Item #: STC20

316L Stainless Steel Box Chains 3mm


Gold 18 inch
Gold 20 inch
Gold 22 inch
Gold 24 inch
Gold 30 inch
Rhodium 18 inch
Rhodium 20 inch
Rhodium 22 inch
Rhodium 24 inch
Rhodium 30 inch