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 Wholesale Plastic Bottles - Bottle Cap-spray Bottle - PET Bottles - Midwest Bottles

New Arrivals

Secure Site

Product Updates

Cancel Your Subscriptions

To unsubscribe from your email subscriptions, please enter your email address below. Please be sure to use the same email address that was used during sign-up.