SELECT *, `Competition`.`alternativeName` as `alternativeNameCompetition`, `CupEvent`.`id` as `cupeventid`, `RaceEvent`.`id` as `raceeventid`, `RaceEvent`.`eventStartDate` as `eventStartDate`, `RaceEvent`.`raceClass` as `raceeventraceclass`, `RaceClass`.`name` as `raceclassname2`, `Club`.`name` as `clubname`, `Club`.`id` as `club`, `Club`.`name` as `clubname`, `BundledRaceClass`.`alternativeName` as `raceclassname`
FROM `RaceEvent`
JOIN `Club` ON `Club`.`id` = `RaceEvent`.`eventHost`
JOIN `CupEvent` ON `CupEvent`.`id` = `RaceEvent`.`cupEvent`
JOIN `Cup` ON `Cup`.`id` = `CupEvent`.`cup`
LEFT JOIN `BundledRaceClass` ON `BundledRaceClass`.`raceClass` = `RaceEvent`.`raceClass` AND `BundledRaceClass`.`raceClassBundle` = `CupEvent`.`raceClassBundle`
LEFT JOIN `RaceClass` ON `RaceClass`.`id` = `RaceEvent`.`raceClass`
LEFT JOIN `Competition` ON `Competition`.`id` = `RaceEvent`.`event`
WHERE `RaceEvent`.`cupEvent` IN('d9a3d2b0-4d1d-11ec-8124-0050563dccfb')
AND `RaceEvent`.`isAccepted` = 1
AND `RaceEvent`.`eventHost` = '57837730-3de8-11ea-9db7-0050563dccfb'
AND   (
`RaceEvent`.`isHidden` IS NULL
OR `RaceEvent`.`isHidden` = 0
 )
ORDER BY `RaceEvent`.`eventStartDate` ASC