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

Item #: NEK372

Iced Out Full CZ IP Gold Cuban Chain


16 inch Gold Chain
18 inch Gold Chain
20 inch Gold Chain
24 inch Gold Chain
30 inch Gold Chain
8.5 Inch Gold Bracelet