MYSQL ERROR
select a.EX_002_TEAM, RN_005_FLAG, b.EX_002_TEAM, concat(EX_003_FIRSTNAME,' ',EX_003_SURNAME) as player, EX_003_ID, a.EX_002_NOTES, EX_022_SQUADNUMBER, EX_003_SURNAME from soccerdb.EX_022_WORLDCUPSQUADS, soccerdb.EX_003_PLAYERS, V3.RN_005_TRANSLATION, soccerdb.EX_002_TEAMS as a left join soccerdb.EX_002_TEAMS as b on EX_002_CLUB_ID=b.EX_002_ID where EX_003_PLAYER_ID=EX_003_ID and EX_022_WORLDCUPSQUADS.EX_002_TEAM_ID=a.EX_002_ID and RN_005_TRANSLATION.EX_002_TEAM_ID=EX_022_WORLDCUPSQUADS.EX_002_TEAM_ID order by a.EX_002_TEAM ,EX_003_SURNAME

Unknown column 'EX_002_CLUB_ID' in 'on clause'

Trace

/classLib.php : line 381 : db->outputError(select a.EX_002_TEAM, RN_005_FLAG, b.EX_002_TEAM, concat(EX_003_FIRSTNAME,' ',EX_003_SURNAME) as player, EX_003_ID, a.EX_002_NOTES, EX_022_SQUADNUMBER, EX_003_SURNAME from soccerdb.EX_022_WORLDCUPSQUADS, soccerdb.EX_003_PLAYERS, V3.RN_005_TRANSLATION, soccerdb.EX_002_TEAMS as a left join soccerdb.EX_002_TEAMS as b on EX_002_CLUB_ID=b.EX_002_ID where EX_003_PLAYER_ID=EX_003_ID and EX_022_WORLDCUPSQUADS.EX_002_TEAM_ID=a.EX_002_ID and RN_005_TRANSLATION.EX_002_TEAM_ID=EX_022_WORLDCUPSQUADS.EX_002_TEAM_ID order by a.EX_002_TEAM ,EX_003_SURNAME

Unknown column 'EX_002_CLUB_ID' in 'on clause')

/classLib.php : line 4306 : db->get2dArray(select a.EX_002_TEAM, RN_005_FLAG, b.EX_002_TEAM, concat(EX_003_FIRSTNAME,' ',EX_003_SURNAME) as player, EX_003_ID, a.EX_002_NOTES, EX_022_SQUADNUMBER, EX_003_SURNAME from soccerdb.EX_022_WORLDCUPSQUADS, soccerdb.EX_003_PLAYERS, V3.RN_005_TRANSLATION, soccerdb.EX_002_TEAMS as a left join soccerdb.EX_002_TEAMS as b on EX_002_CLUB_ID=b.EX_002_ID where EX_003_PLAYER_ID=EX_003_ID and EX_022_WORLDCUPSQUADS.EX_002_TEAM_ID=a.EX_002_ID and RN_005_TRANSLATION.EX_002_TEAM_ID=EX_022_WORLDCUPSQUADS.EX_002_TEAM_ID order by a.EX_002_TEAM ,EX_003_SURNAME )

/classLib.php : line 4249 : sqlBuilder->writeCache(cache/SQL1170948620e57059b600063d43dcf070)

/modules/sqlList.php : line 47 : sqlBuilder->outputData()

/index.php : line 189 : include(/var/www/vhosts/11v11.com/httpdocs/modules/sqlList.php)