You can't refer to aliases from the SELECT list in the WHERE clause. So WHERE M.Date >= ScoreDateFrom and M.Date <= ScoreDateTo and M.MatchID = 1; uses the value of ScoreDateTo from the actual table, not CURDATE() as adjusted. You need to repeat that adjustment in WHERE.

I downloaded MySQL installer. I chose the Developer Default Setup Type. Now it's downloading the various components of MySQL. There is an issue here: the downloading seems to be stalled. As you can see, some components have already completed downloaded, but others are still downloading. It had been downloading for over an hour now and the percentages have not changed. There has been no visible progress so far after this state. What could be the cause of this? How can I make sure that the installer is really working instead of stalling? It seems that the installer downloaded some components and ... stopped working? I have a wireless internet connection. I don't know whether this could be the issue.