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
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]