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('41aa7af6-3c3d-11ea-893e-0050563dccfb')
AND `RaceEvent`.`isAccepted` = 1
AND `RaceEvent`.`eventHost` = '65724f5c-969e-492a-b8fa-b31b013f1034'
AND   (
`RaceEvent`.`isHidden` IS NULL
OR `RaceEvent`.`isHidden` = 0
 )
ORDER BY `RaceEvent`.`eventStartDate` ASC