SELECT o.orderid, o.orderstatus, od.productnote, t.trackingnumber, od.qtyshipped, od.qtyonhold, od.qtyonpackingslip
FROM orders o
JOIN orderdetails od ON o.orderid = od.orderid AND od.productcode NOT LIKE '%DSC-%'
LEFT JOIN trackingnumbers t ON o.orderid = t.orderid
WHERE od.qtyshipped > 0
AND od.productnote <> ''
AND t.trackingnumber IS NULL
AND o.orderid > 8000000