Statistics Archives     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' grou 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' grou 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.pkeyError 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 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.pkeyError 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' gro 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.pkeyError 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 p 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.pkeyError 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 p 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.pkeyError 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 p 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.pkeyError 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 l 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, 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 1959-60Error 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 =