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

Item #: SILR066

.925 S.Silver AAA Grade CZ Rings

Comes With Retail Price Tag & Description


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