SELECT p.*,oc.*, IF(p.url_custom='',p.url_default,p.url_custom) AS product_url, AS cat_name, IF(c.url_custom='',c.url_default,c.url_custom) AS cat_url, SUM(oc.admin_price * oc.admin_quantity) AS product_amount, SUM(oc.admin_quantity) AS product_quantity, SUM(oc.admin_price * oc.admin_quantity * o.gift_cert_amount / o.total_amount) AS gift_cert_amount, SUM(oc.admin_price * oc.admin_quantity * (1 - o.gift_cert_amount / o.total_amount)) AS total_amount FROM orders_content oc INNER JOIN orders o ON o.oid = oc.oid INNER JOIN products p ON = INNER JOIN catalog c ON c.cid = p.cid AND c.is_visible='Yes' WHERE c.key_name <> 'gift_cert' AND p.is_visible='Yes' AND DATE_ADD(o.placed_date, INTERVAL 2 MONTH)>NOW() and o.removed='No' AND o.status='Completed' AND o.payment_status='Received' GROUP BY ORDER BY product_amount DESC LIMIT 12 24-410 Black Dispensing Bottle Cap

New Arrivals

Secure Site

Product Updates

24-410 Black Ribbed Disc Top Dispensing Bottle Cap w/ .312 Orifice (Stull) (Stock Item)

24-410 Black Ribbed Disc Top Dispensing Bottle Cap w/ .312 Orifice (Stull) (Stock Item)
Hover over image to zoom
Our Price: $0.15
Compared at: $0.20
You Save: $0.05
Product ID : bdc24-410-blk-r
Manufacturer: Stull
Stock: 8,670

Continuous Stock
E-mail to a friend | Add To Wish List



24-410 black plastic dispensing bottle cap with non smooth finish, .312 orifice & disc-top.  Bottle closure is 1 in. wide x 1 3/8 in. high.

Product Reviews

Login or Register to write the first review.