The world of Rugby League.

rleague.com

Penrith Panthers vs Melbourne Storm

0:00
0m Half time 80m
Unknown column 'fs.FootyCompetitionID' in 'field list'
SELECT fp.FullName as FullName, fp.FootyPlayerID, fmp.PlayerNumber as PlayerNumber, (select count(*) from footymatchplayer ifmp inner join footymatch ifm on ifm.FootyMatchID = ifmp.FootyMatchID inner join footyround ifr on ifr.FootyRoundID = ifm.FootyRoundID inner join footyseason ifs on ifs.FootySeasonID = ifr.FootySeasonID and ifs.FootyCompetitionID = (select fs.FootyCompetitionID) where FootyPlayerID = fmp.FootyPlayerID and ifm.StartTime < (select fm.StartTime)) as CareerGames, (select sum(Tries) from footymatchplayer ifmp inner join footymatch ifm on ifm.FootyMatchID = ifmp.FootyMatchID inner join footyround ifr on ifr.FootyRoundID = ifm.FootyRoundID inner join footyseason ifs on ifs.FootySeasonID = ifr.FootySeasonID and ifs.FootyCompetitionID = (select fs.FootyCompetitionID) where FootyPlayerID = fmp.FootyPlayerID and ifm.StartTime < (select fm.StartTime)) as CareerTries, (select sum(Points) from footymatchplayer ifmp inner join footymatch ifm on ifm.FootyMatchID = ifmp.FootyMatchID inner join footyround ifr on ifr.FootyRoundID = ifm.FootyRoundID inner join footyseason ifs on ifs.FootySeasonID = ifr.FootySeasonID and ifs.FootyCompetitionID = (select fs.FootyCompetitionID) where FootyPlayerID = fmp.FootyPlayerID and ifm.StartTime < (select fm.StartTime)) as CareerPoints, (select count(*) from footymatchplayer ifmp inner join footymatch ifm on ifm.FootyMatchID = ifmp.FootyMatchID inner join footyround ifr on ifr.FootyRoundID = ifm.FootyRoundID and ifr.FootySeasonID = (select fs.FootySeasonID) where FootyPlayerID = fmp.FootyPlayerID and ifm.StartTime < (select fm.StartTime)) as SeasonGames, (select sum(Tries) from footymatchplayer ifmp inner join footymatch ifm on ifm.FootyMatchID = ifmp.FootyMatchID inner join footyround ifr on ifr.FootyRoundID = ifm.FootyRoundID and ifr.FootySeasonID = (select fs.FootySeasonID) where FootyPlayerID = fmp.FootyPlayerID and ifm.StartTime < (select fm.StartTime)) as SeasonTries, (select sum(Points) from footymatchplayer ifmp inner join footymatch ifm on ifm.FootyMatchID = ifmp.FootyMatchID inner join footyround ifr on ifr.FootyRoundID = ifm.FootyRoundID and ifr.FootySeasonID = (select fs.FootySeasonID) where FootyPlayerID = fmp.FootyPlayerID and ifm.StartTime < (select fm.StartTime)) as SeasonPoints from footyplayer fp inner join footymatchplayer fmp on fmp.FootyPlayerID = fp.FootyPlayerID inner join footymatch fm on fm.FootyMatchID = fmp.FootyMatchID inner join footyround fr on fr.FootyRoundID = fm.FootyRoundID inner join footyseason fs on fs.FootySeasonID = fr.FootySeasonID where fmp.FootyMatchID = 19596 and fmp.FootyTeamID = 17 order by fmp.PlayerNumber
backtrace/var/www/html/core/master.php800mc/var/www/html/data/footyMatchPlayers.php62loadByFootyMatchIDTeamIDExtendedStats/var/www/html/rleague/Match_Preview.php85render/var/www/html/rleague/Match_Preview.php41render/var/www/html/rleague/Match.php178