Database error: Invalid SQL: SELECT `competition-name`.`name`, `competition-name`.`filename`, `competition`.`idplace`, `competition-match`.`id`, `competition-match`.`goals1`, `competition-match`.`goals2`, `competition-match`.`team1type`, `competition-match`.`team2type`, `competition-match`.`date`, `t1`.`name` AS team1, `t2`.`name` AS team2, `place3`.`name` AS `nationalteam1`, `place4`.`name` AS `nationalteam2`, `competition-match`.`videocode`, `stadium-name`.`name` AS `stad`, `stadium-name`.`filename` AS `stadfn` FROM `competition-name` INNER JOIN `competition-match` ON `competition-name`.`idcompetition` = `competition-match`.`idcompetition` INNER JOIN `competition` ON `competition-name`.`idcompetition` = `competition`.`id` INNER JOIN `stadium-name` ON `competition-match`.`idstadium` = `stadium-name`.`idstadium` LEFT JOIN `team` AS `t1` ON `competition-match`.`idteam1` = `t1`.`id` LEFT JOIN `team` AS `t2` ON `competition-match`.`idteam2` = `t2`.`id` LEFT JOIN `national-team` AS `t3` ON `competition-match`.`idteam1` = `t3`.`id` LEFT JOIN `national-team` AS `t4` ON `competition-match`.`idteam2` = `t4`.`id` LEFT JOIN `place` AS `place3` ON `t3`.`place` = `place3`.`id` LEFT JOIN `place` AS `place4` ON `t4`.`place` = `place4`.`id` WHERE `competition-name`.`current` = 1 AND `competition-match`.`id`=433
MySQL Error: 1054 (Unknown column 'competition-match.idcompetition' in 'on clause')