|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
| League Pulse Fatal Error:
The following query in getRatings(, AND (p.pos = 'QB' OR p.pos = 'HB' OR p.pos = 'WR' OR p.pos = 'TE')); failed:
SELECT y.id, y.team, p.name, p.pos, (4 * IFNULL(pss.td, 0)) + (6 * IFNULL(rsh.td, 0)) + (6 * IFNULL(rec.td, 0)) + (.03 * IFNULL(pss.yds, 0)) + (0.068 * IFNULL(rsh.yds, 0)) + (0.068 * IFNULL(rec.yds, 0)) - (2*IFNULL(pss.int, 0)) - (2*IFNULL(rsh.fum, 0)) + (3*IFNULL(k.fgm, 0)) + (IFNULL(k.xpm, 0)) + (.9*IFNULL(d.tkl, 0)) + (1.5*IFNULL(d.loss, 0)) + (4.5*IFNULL(d.sack, 0)) + (6*IFNULL(d.int, 0)) + (3*IFNULL(d.ff, 0)) + (4*IFNULL(d.frec, 0)) + (1.5*IFNULL(d.def, 0)) as fantasy_points FROM db172050442.madcat_yearly_player_info y JOIN db172050442.madcat_players p ON p.id = y.id JOIN madcat_games g ON g.year = y.year AND g.game_id = 414 LEFT JOIN madcat_game_passing pss ON pss.player_id = y.id AND pss.game_id = g.game_id LEFT JOIN madcat_game_rushing rsh ON rsh.player_id = y.id AND rsh.game_id = g.game_id LEFT JOIN madcat_game_receiving rec ON rec.player_id = y.id AND rec.game_id = g.game_id LEFT JOIN madcat_game_defense d ON d.player_id = y.id AND d.game_id = g.game_id LEFT JOIN madcat_game_pr pr ON pr.player_id = y.id AND pr.game_id = g.game_id LEFT JOIN madcat_game_kr kr ON kr.player_id = y.id AND kr.game_id = g.game_id LEFT JOIN madcat_game_kicking k ON k.player_id = y.id AND k.game_id = g.game_id WHERE y.year = AND (p.pos = 'QB' OR p.pos = 'HB' OR p.pos = 'WR' OR p.pos = 'TE') HAVING fantasy_points > 0 ORDER BY fantasy_points DESC LIMIT 1 MySQL said: 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 'AND (p.pos = 'QB' OR p.pos = 'HB' OR p.pos = 'WR' OR p.pos = 'T
League Pulse Fatal Error:
The following query in getRatings(, AND (p.pos LIKE '%LB' OR p.pos LIKE '%S' OR p.pos = 'CB' OR p.pos = 'DT' OR p.pos = 'LE' OR p.pos = 'RE')); failed:
SELECT y.id, y.team, p.name, p.pos, (4 * IFNULL(pss.td, 0)) + (6 * IFNULL(rsh.td, 0)) + (6 * IFNULL(rec.td, 0)) + (.03 * IFNULL(pss.yds, 0)) + (0.068 * IFNULL(rsh.yds, 0)) + (0.068 * IFNULL(rec.yds, 0)) - (2*IFNULL(pss.int, 0)) - (2*IFNULL(rsh.fum, 0)) + (3*IFNULL(k.fgm, 0)) + (IFNULL(k.xpm, 0)) + (.9*IFNULL(d.tkl, 0)) + (1.5*IFNULL(d.loss, 0)) + (4.5*IFNULL(d.sack, 0)) + (6*IFNULL(d.int, 0)) + (3*IFNULL(d.ff, 0)) + (4*IFNULL(d.frec, 0)) + (1.5*IFNULL(d.def, 0)) as fantasy_points FROM db172050442.madcat_yearly_player_info y JOIN db172050442.madcat_players p ON p.id = y.id JOIN madcat_games g ON g.year = y.year AND g.game_id = 414 LEFT JOIN madcat_game_passing pss ON pss.player_id = y.id AND pss.game_id = g.game_id LEFT JOIN madcat_game_rushing rsh ON rsh.player_id = y.id AND rsh.game_id = g.game_id LEFT JOIN madcat_game_receiving rec ON rec.player_id = y.id AND rec.game_id = g.game_id LEFT JOIN madcat_game_defense d ON d.player_id = y.id AND d.game_id = g.game_id LEFT JOIN madcat_game_pr pr ON pr.player_id = y.id AND pr.game_id = g.game_id LEFT JOIN madcat_game_kr kr ON kr.player_id = y.id AND kr.game_id = g.game_id LEFT JOIN madcat_game_kicking k ON k.player_id = y.id AND k.game_id = g.game_id WHERE y.year = AND (p.pos LIKE '%LB' OR p.pos LIKE '%S' OR p.pos = 'CB' OR p.pos = 'DT' OR p.pos = 'LE' OR p.pos = 'RE') HAVING fantasy_points > 0 ORDER BY fantasy_points DESC LIMIT 1 MySQL said: 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 'AND (p.pos LIKE '%LB' OR p.pos LIKE '%S' OR p.pos = 'CB' OR p.p
|
|||||||||||||||||||||||
|
|
||||||||||||||||||||||
|
|
||||||||||||||||||||||
|
|
||||||||||||||||||||||
|
|
||||||||||||||||||||||
|
|
||||||||||||||||||||||
|
|
||||||||||||||||||||||
|
|
||||||||||||||||||||||
|
|
||||||||||||||||||||||
|
|
||||||||||||||||||||||
|
|
||||||||||||||||||||||
