SELECT orderid,
orderdate,
(paymentamount- IFNULL(salestax1,0) - IFNULL(salestax2,0) - IFNULL(salestax3,0)) AS Sale
FROM orders
WHERE order_entry_system LIKE '%MARKETPLACE%'
AND orderstatus != 'Cancelled'
AND orderdate >= '2014-06-14 00:00:00' AND DATE(orderdate) <= CURDATE()
AND paymentmethodid = 32  ORDER BY orderdate DESC