| N6::DB EXECUTE ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND rndsc.RoundID = rnd.RoundID
GROUP BY rndsc.RoundID
ORDER BY ' at line 4
QUERY:
SELECT rndsc.RoundID AS RNDSCR_ROUNDID, MAX(rnd.RoundNo) RNDSCR_MAXROUNDNO
FROM RoundScores rndsc, Rounds rnd
WHERE rndsc.SeasonID =
AND rndsc.RoundID = rnd.RoundID
GROUP BY rndsc.RoundID
ORDER BY RNDSCR_MAXROUNDNO DESC
CALL STACK:
SP::DB::_ExecuteStatement on line 179
SP::DB::ExecuteQuery on line 219
SP::DB::Score::GetMaxRoundInfo on line 126
SP::DataItem::Round::CurrentNextRound on line 51
ModPerl::ROOT::ModPerl::RegistryPrefork::srv_www_footytip_public_html_cgi_2dbin_Home_2ecgi::Main on line 41
Stack Trace: SP::Error::Exit on line 552 SP::App::__ANON__ on line 408 SP::DB::_ExecuteStatement on line 179 SP::DB::ExecuteQuery on line 219 SP::DB::Score::GetMaxRoundInfo on line 126 SP::DataItem::Round::CurrentNextRound on line 51 |


