SELECT SUM(op.quantity) AS total FROM octab_order_product op LEFT JOIN `octab_order` o ON (op.order_id = o.order_id) LEFT JOIN `octab_product` p ON (op.product_id = p.product_id) LEFT JOIN octab_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE o.order_status_id > '0' AND p.product_id = '7663' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'