|
TEAM
| NAME
| TOTALselect h.position, last_name as lastname, first_name as firstname, s.playerid,
sum(passscore)+sum(rushscore)+sum(recscore)+sum(blockscore) AS score, yearretired, min(year) AS firstyear
from statsbyseason s
JOIN fof7_player_information h ON h.player_id=s.playerid
LEFT JOIN ben_retired r on r.playerid=s.playerid
WHERE last_name<>"" AND m.id<14
GROUP BY s.playerid
HAVING sum(passplays)>0 OR sum(passattempts)>0
order by score desc LIMIT 30 Unknown column 'm.id' in 'where clause' | |