|
|
Error in query SELECT i.nflplayer_id, i.name, i.position_code, i.nflteam_id, i.score, i.rank_by_pos as rank, j.rank_by_pos as prev_rank FROM f_infoforecasts as i LEFT JOIN f_infoforecasts as j ON i.nflplayer_id=j.nflplayer_id AND j.year_id = 2004 AND j.week_id = 17 AND j.predictor_subset = 'AL' WHERE i.position_code = 'TE' AND i.year_id = 2004 AND i.week_id = 18 AND i.predictor_subset = 'AL' ORDER BY i.rank ASC LIMIT 0,10 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 'rank, j.rank_by_pos as prev_rank FROM f_infoforecasts as i LEFT JOIN f_infofor' at line 1 |
