Error 1064: 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 '' at line 1
select season, gplayed, start, mins, mins/gplayed as minper, fg, fga, (fg+0.000)/fga as fgpct, fg3, fg3a, (fg3+0.000)/fg3a as fg3pct, ft, fta, (ft+0.000)/fta as ftpct, orb, drb, totrb, totrb/gplayed as rbpgm, ast, ast/gplayed as astpgm, pf, dq, tov, stl, blk, IFNULL((fg * 2) + fg3 + ft, (fg * 2) + ft) as pts, IFNULL(((fg * 2) + fg3 + ft)/gplayed, ((fg * 2) + ft)/gplayed) as ptspgm from playerseason where pkey =
Error 1064: 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 playergame.gkey = games.gkey and games.league = 'Y' group by playergame.p' at line 1
select games.gkey as gkey, games.season as season, count(*) as gplayed, sum(start) as start, if(count(*) = count(mins), sum(mins), null) as mins, if(count(*) = count(mins),sum(mins)/count(start), null) as avgmins, if(count(*) = count(fg), sum(fg), null) as fg, if(count(*) = count(fga), sum(fga), null) as fga, if(count(*) = count(fga), sum(fg+0.000)/sum(fga), null) as fgpct, if(count(*) = count(fg3), sum(fg3), null) as fg3, if(count(*) = count(fg3a), sum(fg3a), null) as fg3a, if(count(*) = count(fg3a), sum(fg3+0.000)/sum(fg3a), null) as fg3pct, if(count(*) = count(ft), sum(ft), null) as ft, if(count(*) = count(fta), sum(fta), null) as fta, if(count(*) = count(fta), sum(ft+0.000)/sum(fta), null) as ftpct, if(count(*) = count(orb), sum(orb), null) as orb, if(count(*) = count(drb), sum(drb), null) as drb, if(count(*) = count(totrb), sum(totrb), null) as totrb, if(count(*) = count(totrb), sum(totrb)/count(*), null) as rbavg, if(count(*) = count(ast), sum(ast), null) as ast, if(count(*) = count(ast), sum(ast)/count(*), null) as astavg, if(count(*) = count(pf), sum(pf), null) as pf, if(count(*) = count(dq), sum(dq), null) as dq, if(count(*) = count(tov), sum(tov), null) as tov, if(count(*) = count(stl), sum(stl), null) as stl, if(count(*) = count(blk), sum(blk), null) as blk, IFNULL((sum(fg) * 2) + sum(fg3) + sum(ft), (sum(fg) * 2) + sum(ft)) as pts, IFNULL(((sum(fg) * 2) + sum(fg3) + sum(ft))/count(start), ((sum(fg) * 2) + sum(ft))/count(start) ) as ptsavg from playergame, games where playergame.pkey = and playergame.gkey = games.gkey and games.league = 'Y' group by playergame.pkey, games.season
Error 1064: 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 playergame.gkey = games.gkey and games.league = 'Y' group by playergame.p' at line 1
select games.gkey as gkey, games.oppname as rowname, count(*) as gplayed, sum(start) as start, if(count(*) = count(mins), sum(mins), null) as mins, if(count(*) = count(mins), sum(mins)/count(start), null) as avgmins, sum(fg) as fg, IF(count(*) = count(fga), sum(fga), null) as fga, IF(count(*) = count(fga), sum(fg+0.000)/sum(fga), null) as fgpct, sum(fg3) as fg3, sum(fg3a) as fg3a, sum(fg3+0.000)/sum(fg3a) as fg3pct, if(count(*) = count(ft), sum(ft), null) as ft, if(count(*) = count(fta), sum(fta), null) as fta, if(count(*) = count(fta), sum(ft+0.000)/sum(fta), null) as ftpct, if(count(*) = count(orb), sum(orb), null) as orb, if(count(*) = count(drb), sum(drb), null) as drb, if(count(*) = count(totrb), sum(totrb), null) as totrb, if(count(*) = count(totrb), sum(totrb)/count(*), null) as rbavg, if(count(*) = count(ast), sum(ast), null) as ast, if(count(*) = count(ast),sum(ast)/count(start), null) as astavg, if(count(*) = count(pf), sum(pf), null) as pf, if(count(*) = count(dq), sum(dq), null) as dq, if(count(*) = count(tov), sum(tov), null) as tov, if(count(*) = count(stl), sum(stl), null) as stl, if(count(*) = count(blk), sum(blk), null) as blk, IFNULL((sum(fg) * 2) + sum(fg3) + sum(ft), (sum(fg) * 2) + sum(ft)) as pts, IFNULL(((sum(fg) * 2) + sum(fg3) + sum(ft))/count(start), ((sum(fg) * 2) + sum(ft))/count(start) ) as ptsavg from playergame, games where playergame.pkey = and playergame.gkey = games.gkey and games.league = 'Y' group by playergame.pkey
Error 1064: 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 playergame.gkey = games.gkey and games.league = 'N' and games.postseason ' at line 1
select games.gkey as gkey, games.oppname as rowname, count(*) as gplayed, sum(start) as start, if(count(*) = count(mins), sum(mins), null) as mins, if(count(*) = count(mins), sum(mins)/count(start), null) as avgmins, sum(fg) as fg, IF(count(*) = count(fga), sum(fga), null) as fga, IF(count(*) = count(fga), sum(fg+0.000)/sum(fga), null) as fgpct, sum(fg3) as fg3, sum(fg3a) as fg3a, sum(fg3+0.000)/sum(fg3a) as fg3pct, if(count(*) = count(ft), sum(ft), null) as ft, if(count(*) = count(fta), sum(fta), null) as fta, if(count(*) = count(fta), sum(ft+0.000)/sum(fta), null) as ftpct, if(count(*) = count(orb), sum(orb), null) as orb, if(count(*) = count(drb), sum(drb), null) as drb, if(count(*) = count(totrb), sum(totrb), null) as totrb, if(count(*) = count(totrb), sum(totrb)/count(*), null) as rbavg, if(count(*) = count(ast), sum(ast), null) as ast, if(count(*) = count(ast),sum(ast)/count(start), null) as astavg, if(count(*) = count(pf), sum(pf), null) as pf, if(count(*) = count(dq), sum(dq), null) as dq, if(count(*) = count(tov), sum(tov), null) as tov, if(count(*) = count(stl), sum(stl), null) as stl, if(count(*) = count(blk), sum(blk), null) as blk, IFNULL((sum(fg) * 2) + sum(fg3) + sum(ft), (sum(fg) * 2) + sum(ft)) as pts, IFNULL(((sum(fg) * 2) + sum(fg3) + sum(ft))/count(start), ((sum(fg) * 2) + sum(ft))/count(start) ) as ptsavg from playergame, games where playergame.pkey = and playergame.gkey = games.gkey and games.league = 'N' and games.postseason <> 'Y' group by playergame.pkey
Error 1064: 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 playergame.gkey = games.gkey and games.postseason = 'Y' group by playergame.' at line 1
select games.gkey as gkey, games.oppname as rowname, count(*) as gplayed, sum(start) as start, if(count(*) = count(mins), sum(mins), null) as mins, if(count(*) = count(mins), sum(mins)/count(start), null) as avgmins, sum(fg) as fg, IF(count(*) = count(fga), sum(fga), null) as fga, IF(count(*) = count(fga), sum(fg+0.000)/sum(fga), null) as fgpct, sum(fg3) as fg3, sum(fg3a) as fg3a, sum(fg3+0.000)/sum(fg3a) as fg3pct, if(count(*) = count(ft), sum(ft), null) as ft, if(count(*) = count(fta), sum(fta), null) as fta, if(count(*) = count(fta), sum(ft+0.000)/sum(fta), null) as ftpct, if(count(*) = count(orb), sum(orb), null) as orb, if(count(*) = count(drb), sum(drb), null) as drb, if(count(*) = count(totrb), sum(totrb), null) as totrb, if(count(*) = count(totrb), sum(totrb)/count(*), null) as rbavg, if(count(*) = count(ast), sum(ast), null) as ast, if(count(*) = count(ast),sum(ast)/count(start), null) as astavg, if(count(*) = count(pf), sum(pf), null) as pf, if(count(*) = count(dq), sum(dq), null) as dq, if(count(*) = count(tov), sum(tov), null) as tov, if(count(*) = count(stl), sum(stl), null) as stl, if(count(*) = count(blk), sum(blk), null) as blk, IFNULL((sum(fg) * 2) + sum(fg3) + sum(ft), (sum(fg) * 2) + sum(ft)) as pts, IFNULL(((sum(fg) * 2) + sum(fg3) + sum(ft))/count(start), ((sum(fg) * 2) + sum(ft))/count(start) ) as ptsavg from playergame, games where playergame.pkey = and playergame.gkey = games.gkey and games.postseason = 'Y' group by playergame.pkey
Error 1064: 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 playergame.gkey = games.gkey and games.han = 'H' group by playergame.pkey' at line 1
select games.gkey as gkey, games.oppname as rowname, count(*) as gplayed, sum(start) as start, if(count(*) = count(mins), sum(mins), null) as mins, if(count(*) = count(mins), sum(mins)/count(start), null) as avgmins, sum(fg) as fg, IF(count(*) = count(fga), sum(fga), null) as fga, IF(count(*) = count(fga), sum(fg+0.000)/sum(fga), null) as fgpct, sum(fg3) as fg3, sum(fg3a) as fg3a, sum(fg3+0.000)/sum(fg3a) as fg3pct, if(count(*) = count(ft), sum(ft), null) as ft, if(count(*) = count(fta), sum(fta), null) as fta, if(count(*) = count(fta), sum(ft+0.000)/sum(fta), null) as ftpct, if(count(*) = count(orb), sum(orb), null) as orb, if(count(*) = count(drb), sum(drb), null) as drb, if(count(*) = count(totrb), sum(totrb), null) as totrb, if(count(*) = count(totrb), sum(totrb)/count(*), null) as rbavg, if(count(*) = count(ast), sum(ast), null) as ast, if(count(*) = count(ast),sum(ast)/count(start), null) as astavg, if(count(*) = count(pf), sum(pf), null) as pf, if(count(*) = count(dq), sum(dq), null) as dq, if(count(*) = count(tov), sum(tov), null) as tov, if(count(*) = count(stl), sum(stl), null) as stl, if(count(*) = count(blk), sum(blk), null) as blk, IFNULL((sum(fg) * 2) + sum(fg3) + sum(ft), (sum(fg) * 2) + sum(ft)) as pts, IFNULL(((sum(fg) * 2) + sum(fg3) + sum(ft))/count(start), ((sum(fg) * 2) + sum(ft))/count(start) ) as ptsavg from playergame, games where playergame.pkey = and playergame.gkey = games.gkey and games.han = 'H' group by playergame.pkey
Error 1064: 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 playergame.gkey = games.gkey and games.han = 'A' group by playergame.pkey' at line 1
select games.gkey as gkey, games.oppname as rowname, count(*) as gplayed, sum(start) as start, if(count(*) = count(mins), sum(mins), null) as mins, if(count(*) = count(mins), sum(mins)/count(start), null) as avgmins, sum(fg) as fg, IF(count(*) = count(fga), sum(fga), null) as fga, IF(count(*) = count(fga), sum(fg+0.000)/sum(fga), null) as fgpct, sum(fg3) as fg3, sum(fg3a) as fg3a, sum(fg3+0.000)/sum(fg3a) as fg3pct, if(count(*) = count(ft), sum(ft), null) as ft, if(count(*) = count(fta), sum(fta), null) as fta, if(count(*) = count(fta), sum(ft+0.000)/sum(fta), null) as ftpct, if(count(*) = count(orb), sum(orb), null) as orb, if(count(*) = count(drb), sum(drb), null) as drb, if(count(*) = count(totrb), sum(totrb), null) as totrb, if(count(*) = count(totrb), sum(totrb)/count(*), null) as rbavg, if(count(*) = count(ast), sum(ast), null) as ast, if(count(*) = count(ast),sum(ast)/count(start), null) as astavg, if(count(*) = count(pf), sum(pf), null) as pf, if(count(*) = count(dq), sum(dq), null) as dq, if(count(*) = count(tov), sum(tov), null) as tov, if(count(*) = count(stl), sum(stl), null) as stl, if(count(*) = count(blk), sum(blk), null) as blk, IFNULL((sum(fg) * 2) + sum(fg3) + sum(ft), (sum(fg) * 2) + sum(ft)) as pts, IFNULL(((sum(fg) * 2) + sum(fg3) + sum(ft))/count(start), ((sum(fg) * 2) + sum(ft))/count(start) ) as ptsavg from playergame, games where playergame.pkey = and playergame.gkey = games.gkey and games.han = 'A' group by playergame.pkey
Error 1064: 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 playergame.gkey = games.gkey and games.han = 'N' group by playergame.pkey' at line 1
select games.gkey as gkey, games.oppname as rowname, count(*) as gplayed, sum(start) as start, if(count(*) = count(mins), sum(mins), null) as mins, if(count(*) = count(mins), sum(mins)/count(start), null) as avgmins, sum(fg) as fg, IF(count(*) = count(fga), sum(fga), null) as fga, IF(count(*) = count(fga), sum(fg+0.000)/sum(fga), null) as fgpct, sum(fg3) as fg3, sum(fg3a) as fg3a, sum(fg3+0.000)/sum(fg3a) as fg3pct, if(count(*) = count(ft), sum(ft), null) as ft, if(count(*) = count(fta), sum(fta), null) as fta, if(count(*) = count(fta), sum(ft+0.000)/sum(fta), null) as ftpct, if(count(*) = count(orb), sum(orb), null) as orb, if(count(*) = count(drb), sum(drb), null) as drb, if(count(*) = count(totrb), sum(totrb), null) as totrb, if(count(*) = count(totrb), sum(totrb)/count(*), null) as rbavg, if(count(*) = count(ast), sum(ast), null) as ast, if(count(*) = count(ast),sum(ast)/count(start), null) as astavg, if(count(*) = count(pf), sum(pf), null) as pf, if(count(*) = count(dq), sum(dq), null) as dq, if(count(*) = count(tov), sum(tov), null) as tov, if(count(*) = count(stl), sum(stl), null) as stl, if(count(*) = count(blk), sum(blk), null) as blk, IFNULL((sum(fg) * 2) + sum(fg3) + sum(ft), (sum(fg) * 2) + sum(ft)) as pts, IFNULL(((sum(fg) * 2) + sum(fg3) + sum(ft))/count(start), ((sum(fg) * 2) + sum(ft))/count(start) ) as ptsavg from playergame, games where playergame.pkey = and playergame.gkey = games.gkey and games.han = 'N' group by playergame.pkey
Error 1064: 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 playergame.gkey = games.gkey group by playergame.pkey' at line 1
select games.gkey as gkey, games.oppname as rowname, count(*) as gplayed, sum(start) as start, if(count(*) = count(mins), sum(mins), null) as mins, if(count(*) = count(mins), sum(mins)/count(start), null) as avgmins, sum(fg) as fg, IF(count(*) = count(fga), sum(fga), null) as fga, IF(count(*) = count(fga), sum(fg+0.000)/sum(fga), null) as fgpct, sum(fg3) as fg3, sum(fg3a) as fg3a, sum(fg3+0.000)/sum(fg3a) as fg3pct, if(count(*) = count(ft), sum(ft), null) as ft, if(count(*) = count(fta), sum(fta), null) as fta, if(count(*) = count(fta), sum(ft+0.000)/sum(fta), null) as ftpct, if(count(*) = count(orb), sum(orb), null) as orb, if(count(*) = count(drb), sum(drb), null) as drb, if(count(*) = count(totrb), sum(totrb), null) as totrb, if(count(*) = count(totrb), sum(totrb)/count(*), null) as rbavg, if(count(*) = count(ast), sum(ast), null) as ast, if(count(*) = count(ast),sum(ast)/count(start), null) as astavg, if(count(*) = count(pf), sum(pf), null) as pf, if(count(*) = count(dq), sum(dq), null) as dq, if(count(*) = count(tov), sum(tov), null) as tov, if(count(*) = count(stl), sum(stl), null) as stl, if(count(*) = count(blk), sum(blk), null) as blk, IFNULL((sum(fg) * 2) + sum(fg3) + sum(ft), (sum(fg) * 2) + sum(ft)) as pts, IFNULL(((sum(fg) * 2) + sum(fg3) + sum(ft))/count(start), ((sum(fg) * 2) + sum(ft))/count(start) ) as ptsavg from playergame, games where playergame.pkey = and playergame.gkey = games.gkey group by playergame.pkey
Error 1064: 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 playergame.gkey = games.gkey group by playergame.pkey, games.season' at line 2
select games.gkey as gkey, season, max(mins) as mins, max(fg) as fg, max(fga) as fga, max(fg3) as fg3, max(fg3a) as fg3a, max(ft) as ft, max(fta) as fta, max(orb) as orb, max(drb) as drb, max(totrb) as totrb, max(ast) as ast, max(pf) as pf, max(tov) as tov, max(stl) as stl, max(blk) as blk, max(IFNULL((fg * 2) + fg3 + ft, (fg * 2) + ft)) as pts from playergame, games where playergame.pkey = and playergame.gkey = games.gkey group by playergame.pkey, games.season
Game by Game stats only available since 1976-77Error 1064: 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 '' at line 1
select count(gkey) from playergame where pkey =
   


BIG Ten BIG Ten Network NCAA University of Michigan IMG
© 2017 Board of Regents of the University of Michigan. All Rights Reserved.