TEAM
| NAME
| TOTALselect h.position, last_name as lastname, first_name as firstname, s.playerid,
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>6 ANd m.id<12
GROUP BY s.playerid
order by score desc LIMIT 30 Unknown column 'm.id' in 'where clause' | |