SELECT products.*, IF(products.url_custom='',products.url_default,products.url_custom) AS product_url, catalog.name AS cat_name, IF(catalog.url_custom='',catalog.url_default,catalog.url_custom) AS cat_url, SUM(orders_content.admin_quantity) AS product_quantity,SUM(orders_content.admin_price * orders_content.admin_quantity) AS product_amount FROM orders_content INNER JOIN orders ON orders.oid=orders_content.oid INNER JOIN products ON products.pid = orders_content.pid INNER JOIN catalog ON catalog.cid = products.cid AND catalog.is_visible='Yes' WHERE catalog.key_name <> 'gift_cert' AND products.is_visible='Yes' AND DATE_ADD(orders.placed_date, INTERVAL 2 MONTH)>NOW() AND orders.status='Completed' AND orders.payment_status='Received' GROUP BY orders_content.pid ORDER BY product_amount DESC LIMIT 12 58 mm White LDPE Sealing Disk Fits Most Jars w/ 58mm Neck

New Arrivals

Secure Site

Product Updates

58 mm Clear Sealing Disk Fits Most Jars w/ 58mm Neck

58 mm Clear Sealing Disk Fits Most Jars w/ 58mm Neck
Hover over image to zoom
Our Price: $0.08
Compared at: $0.10
You Save: $0.02
Product ID : pjd58mm2
Stock: 6,274
E-mail to a friend | Add To Wish List

Order

Description

58 mm  Clear sealing disk for cosmetic jars.  Plastic disc lays on top of jar but does not seal to jar.

Product Reviews

Login or Register to write the first review.