The Magdeburg Cathedral's 500-Year Mystery Unveiled: An Astronomical Discovery