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

Item #: DISJ12

PLUGS & TUNNELS STARTER KIT 288 PCS 08G - 00G w/ 4 SIDED ROTATING DISPLAY

� YOU WILL RECEIVE 288 PCS (144 PAIRS) OF PLUGS & TUNNELS w/ 4 SIDED ROTATING DISPLAY. SIZES FROM 08G - 00G. GAUGES WILL BE ASSORTED BETWEEN LOGO, CZ AND ACRYLIC. THE DISPLAY STANDS 14.5" TALL. ONLY UPS GROUND ( 5 TO 7 BUSINESS ). ONLY AVAILABLE FOR U.S. CUSTOMERS. �

Shipping costs varies based on shipping destination and weight of the display.


288 PCS w/ DISPLAY