DEFINER = `root`@`localhost`
`x`.`league` AS `league`,
CONCAT(`x`.`date`, ' ', `y`.`starttime`) AS `datetime`,
`y`.`hometeam` AS `hometeam`,
`y`.`awayteam` AS `awayteam`,
`y`.`starttime` AS `starttime`,
`y`.`homescore` AS `homescore`,
`y`.`awayscore` AS `awayscore`,
`z`.`sport` AS `sportid`,
`z`.`icon` AS `leagueicon`,
`a`.`name` AS `sportname`,
`a`.`duration` AS `duration`,
`p`.`status` AS `status`,
JOIN `games` `y` ON ((`y`.`event` = `x`.`id`)))
JOIN `leagues` `z` ON ((`x`.`league` = `z`.`name`)))
JOIN `sports` `a` ON ((`z`.`sport` = `a`.`id`)))
JOIN `progress` `p` ON ((`y`.`id` = `p`.`game`)))
JOIN `status` `s` ON ((`p`.`status` = `s`.`id`)))
ORDER BY `x`.`date` , `y`.`starttime`