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

Item #: SILR871

.925 S.Silver AAA Grade CZ Ring

.925 Sterling Silver Ring AAA Grade CZ Ring  


IP Silver (Size 6)
IP Silver (Size 7)
IP Silver (Size 8)
IP Silver (Size 9)
IP Silver (Size 10)