Database error: Invalid SQL: SELECT `user-favorite`.iditem, `competition-match`.`id`, `competition-match`.`filename` AS matchfn, `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`, `competition-name`.`filename` AS comp_fn, `competition-name`.`name` AS comp_name FROM `competition-name` INNER JOIN `competition-match` ON `competition-name`.`idcompetition` = `competition-match`.`idcompetition` 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` INNER JOIN `user-favorite` ON `user-favorite`.iditem=`competition-match`.`id` WHERE `competition-match`.`status`=1 AND `user-favorite`.iduser= 34 AND `user-favorite`.itemtype=11 AND `competition-name`.`current`=1 ORDER BY `date` DESC, `competition-match`.`id` DESC LIMIT 0, 12
MySQL Error: 1054 (Unknown column 'competition-match.idcompetition' in 'on clause')