Get list of orders that have not been closed that are older than 60 days
SELECT
    o1.order_id
FROM tblOrders o1
WHERE 
    o1.dsc_id = 1
    AND o1.te_date &lt; DATE_ADD(NOW(), INTERVAL -60 DAY)
    AND NOT EXISTS (SELECT order_id FROM tblOrders o2 WHERE o2.order_id = o1.order_id and o2.dsc_id = 8)
    AND EXISTS (SELECT order_id FROM tblOrders o2 WHERE o2.order_id = o1.order_id and o2.dsc_id != 1)
GROUP BY o1.order_id