SELECT * FROM `orders` 
WHERE ((billingaddress1 IS NULL OR billingaddress1 = '')
   OR (billingcity IS NULL OR billingcity = '')
   OR (billingpostalcode IS NULL OR billingpostalcode = ''))
AND orderstatus <> 'Cancelled'
AND orderid > 6000000
AND orderstatus IS NOT NULL
AND (customerid <> '' or customerid IS NOT NULL)
ORDER BY orderid DESC