SELECT `games`.`ID`, (TO_DAYS(NOW())-TO_DAYS(`games`.`Date`)) AS `Diff` FROM `games` LEFT JOIN `competitions` ON `competitions`.`ID`= `games`.`CompID` WHERE `Status` NOT IN ('/', '!', '-', '0', '1', '2', '3', '4', '5', '6', '7','8', '9', '#', '~') AND TO_DAYS(`Date`) BETWEEN to_days('2024-05-03') AND to_days('2020-11-21') AND `competitions`.`AssignRefs`='Y' ORDER BY TO_DAYS(`Date`), `Nr`, `Location`, `TeamA`