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

Item #: STZSER5042

925 S.Silver AAA Grade CZ Hoops Earrings

Micro Pave AAA Grade CZ Hoop Earrings Look Of A Real Diamonds.

Comes with retail price Tag and description. 


Style (2) E-5220
Style (3) E-6757
Style (4) E-3525
Style (7) E-5791
Style (11) E-5800
Style (12) E-5788
Style (13) E-3283