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

Item #: NEK373

Iced Out Full CZ IP Silver Cuban Chain


16 Inch Rhodium Chain
18 Inch Rhodium Chain
20 Inch Rhodium Chain
24Inch Rhodium Chain
30 Inch Rhodium Chain
8.5 Inch Rhodium Bracelet