SELECT
orderid,
DATE(shipdate)
FROM 
trackingnumbers
WHERE
YEAR(shipdate) = 2024
AND shipment_cost <> 0
AND orderid IN 
	(
    SELECT orderid
    FROM orderdetails
    WHERE productnote NOT LIKE '%DS%'
    AND YEAR(shipdate) = 2024
    )
GROUP BY
orderid,
shipdate
HAVING COUNT(orderid) > 1
ORDER BY DATE(shipdate) DESC