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

Item #: STZR09G

S.ST Micro Pave CZ Ring

IP GOLD PLATED STAINLESS STEEL MICRO PAVE CZ RING 


Size (6)
Size (7)
Size (8)
Size (9)
Size (10)
Size (11)
Size (12)
Size (13)