OVERALL LEADERBOARD

Last match:
Leaderboard:
  R PR Team Name Manager Score
↔ 1 1 The Untouchables Andrew Bell 1205
↔ 2 2 friends of drewso Philip Allister 1190
↔ 3 3 RiggersRamshankables Mark Rigby 1148
↔ 4 4 Niall's Army Niall McMahon 1148
↔ 5 5 madgoona Joel Kersen 1146
↔ 6 6 zoot horn rollo michael carpenter 1145
↔ 7 7 robs red devils Rob Reynolds 1144
↔ 8 8 Slevs G Units Liam Slevin 1134
↔ 9 9 Nial Quins DiscoPant Michael McCletchie 1132
↔ 10 10 matt copied me James Sullivan 1124
↔ 11 11 bagsy david baggaley 1119
↔ 12 12 fullastars james fuller 1117
↔ 13 13 Scarlets Rhys Jones 1115
↔ 14 14 mightys shanur ali 1113
↔ 15 15 T-UnIt toseef fiaz 1110
↔ 16 16 Highbury Legends X1 simon Paice 1109
↔ 17 17 Summers Stars Craig Summers 1108
↔ 18 18 wouldsey rules Tom Gadderz 1105
↔ 19 19 East Utd ben brown 1101
↔ 20 20 dazza all stars darren brewster 1100
Last updated: 4:54pm Fri 18 May
1
2345»
Page 1 of 124
Powered By iDreamProducts.com

MySQL DEBUGGING INFORMATION

QUERY 1:


SELECT CONCAT(
(SELECT IF(short_name IS NOT NULL, short_name, name) FROM idreamfootball_epl0607.teams WHERE teamID=m.teamID_home),
' v ',
(SELECT IF(short_name IS NOT NULL, short_name, name) FROM idreamfootball_epl0607.teams WHERE teamID=m.teamID_away),
'
',
CONCAT(
DATE_FORMAT(m.date, '%l:%i'),
LOWER(CAST(DATE_FORMAT(m.date, '%p ') AS CHAR)),
DATE_FORMAT(m.date, '%a %e %b')
)
)
FROM idreamfootball_epl0607.matches m, idreamfootball_epl0607.STATS_TABLE s
WHERE m.date < NOW()
AND m.matchID=s.matchID
ORDER BY m.date DESC, m.teamID_home DESC
LIMIT 1

MySQL Reports (error no. 1146):

Table 'idreamfootball_epl0607.STATS_TABLE' doesn't exist

PHP BACKTRACE

#0 DatabaseObj->query(
SELECT CONCAT(
(SELECT IF(short_name IS NOT NULL, short_name, name) FROM idreamfootball_epl0607.teams WHERE teamID=m.teamID_home),
' v ',
(SELECT IF(short_name IS NOT NULL, short_name, name) FROM idreamfootball_epl0607.teams WHERE teamID=m.teamID_away),
'
',
CONCAT(
DATE_FORMAT(m.date, '%l:%i'),
LOWER(CAST(DATE_FORMAT(m.date, '%p ') AS CHAR)),
DATE_FORMAT(m.date, '%a %e %b')
)
)
FROM idreamfootball_epl0607.matches m, idreamfootball_epl0607.STATS_TABLE s
WHERE m.date < NOW()
AND m.matchID=s.matchID
ORDER BY m.date DESC, m.teamID_home DESC
LIMIT 1
) called at [/u0/home/epl_codebase/php/Leaderboards.class.php:128]
#1 Leaderboards->getLastUpdate(rank_overall) called at [/u0/home/epl_codebase/php/Leaderboards.class.php:527]
#2 Leaderboards->leaderboardOverall() called at [/u0/home/epl_codebase/php/Leaderboards.class.php:36]
#3 Leaderboards->displayLeaderboard() called at [/u0/home/epl_codebase/php/Leaderboards.class.php:10]
#4 Leaderboards->__construct() called at [/u0/home/epl_codebase/fantasy/leaderboards:2]