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

Item #: ROS69

BLACK ACRYLIC BEADS ROSARY 10MM

10MM ACRYLIC BEADS ROSARY 

LENGTH 36"


ORANGE BEADS
HOT PINK BEADS
LIGHT GREEN BEADS
TURQUOISE BEADS
DARK GREEN BEADS
RED BEADS
WHITE BEADS
PURPLE BEADS