SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (1) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 4) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (1) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 4 ) ORDER BY position ASC LIMIT 1
Wholesale Body Jewelry | Hip Hop Jewelry | Piercing Jewelry Wholesale
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Accessories

Item #: LN 9

ID TAG CZ LAYNARD IN 26 DIFF. COLORS AS LOW AS 2.00

COLOR (1)
COLOR (3)
COLOR (6)
COLOR (7)
COLOR (10)
COLOR (14)
COLOR (17)
COLOR (19)
COLOR (22)
COLOR (23)
COLOR (25)
MIX ALL COLOR