|
|
Error in query
SELECT t.team_homepage, t.infoteam_id, t.site_description, t.name,
COUNT(p.nflplayer_id) as numplayers, sum(f.score ) as scoresum, count(f.score) as scorecount
FROM f_infoteams as t
LEFT JOIN f_infoplayers as p USING (infoteam_id)
LEFT JOIN f_infoforecasts as f ON (f.nflplayer_id=p.nflplayer_id AND f.year_id=2004 AND f.week_id=18 and predictor_subset='AL')
WHERE t.user_id =
GROUP BY t.infoteam_id; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY t.infoteam_id' at line 7 |
