GML Top 100: DawgPoints--Blocking |
RANK | PLAYER | DawgPoints--Blocking | TEAMSELECT last_name as lastname, first_name as firstname, nickname, s.playerid, sum(blockscore) AS leader, yearretired, h.position, a.team, min(year) AS firstyear
FROM statsbyseason s
JOIN fof7_player_information h ON h.player_id=s.playerid
LEFT JOIN fof7_player_record a ON a.player_id=s.playerid
LEFT JOIN ben_retired r on r.playerid=s.playerid
WHERE last_name<>"" AND m.id>6 AND m.id<12
GROUP BY s.playerid
ORDER BY leader DESC LIMIT 100 Unknown column 'm.id' in 'where clause' |
|