SELECT o.orderdate, o.orderstatus, od.* FROM orderdetails od
JOIN orders o ON od.orderid = o.orderid AND o.orderstatus IN ('Shipped')
WHERE (od.ProductNote IS NULL or od.ProductNote = '') 
AND od.ProductCode NOT LIKE '%DSC-%'
AND od.orderid > 8000000