SELECT ItemID, COUNT(*) AS TotalCount
FROM (SELECT `ItemID`,`Confirm` FROM z251031 WHERE `Confirm` != 'Rejected' UNION ALL SELECT `ItemID`,`Confirm` FROM z251029 WHERE `Confirm` != 'Rejected') AS all_items
GROUP BY ItemID
JayJayTea
SELECT * FROM menu WHERE `NextDeliveryDate`!='' ORDER BY `SpecialLevel` DESC,`NextDeliveryDate`,`SearchPoint` DESC