Database error: Invalid SQL: SELECT `competition-match`.`filename` AS matchfn
FROM `competition-match` INNER JOIN `competition-name` ON `competition-match`.`idcompetition` = `competition-name`.`idcompetition`
INNER JOIN `competition` ON `competition-name`.`idcompetition` = `competition`.`id`
WHERE `competition-match`.id='843' AND `competition-name`.current=1 AND `competition`.`status`=1 MySQL Error: 1054 (Unknown column 'competition-match.idcompetition' in 'on clause')