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

Item #: STPS171

316L S.Steel Chain & CZ Charm Sets


IP Gold (B)
IP Gold (C)
IP Gold (G)
IP Gold (E)
IP Gold (F)
IP Gold (G)
IP Gold (H)
IP Gold (I)
IP Gold (L)
IP Gold (M)
IP Gold (N)
IP Gold (P)
IP Gold (S)
IP Silver (A)
IP Silver (B)
IP Silver (C)
IP Silver (D)
IP Silver (E)
IP Silver (F)
IP Silver (G)
IP Silver (H)
IP Silver (I)
IP Silver (J)
IP Silver (K)
IP Silver (L)
IP Silver (M)
IP Silver (N)
IP Silver (P)
IP Silver (R)
IP Silver (S)