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

Item #: STC17

316L Stainless Steel Franco Chains 6mm


Black 24 inch
Black 30 inch
Black 36 inch
Rhodium 24 inch
Rhodium 26 inch
Rhodium 30 inch
Rhodium 36 inch
Gold 22 inch
Gold 24 inch
Gold 26 inch
Gold 30 inch
Gold 36 inch