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

Item #: BINITILG

Brass Initials CZ Pendants

AAA Grade CZ Pendant
Comes With Retail Price Tag & Description  


IP Gold (A)
IP Gold (B)
IP Gold (C)
IP Gold (D)
IP Gold (E)
IP Gold (F)
IP Gold (G)
IP Gold (H)
IP Gold (I)
IP Gold (J)
IP Gold (K)
IP Gold (L)
IP Gold (M)
IP Gold (N)
IP Gold (O)
IP Gold (P)
IP Gold (Q)
IP Gold (R)
IP Gold (S)
IP Gold (T)
IP Gold (U)
IP Gold (V)
IP Gold (W)
IP Gold (X)
IP Gold (Y)
IP Gold (Z)