List<!field#>Lineup Card<!field#><!field#>2:0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, p.Jersey AS Jersey, s.Position AS Position, "" AS Notes FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.Played='1' AND s.GameID = '#idx#' <!field#>false<!field#>0<!field#>1<!field#>0<!field#>0<!line#>ListField<!field#>5<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>4*<!field#>TOTALS<!line#>ListField<!field#>5<!field#>p.Jersey<!field#>Jersey<!field#>2<!field#>2<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>5<!field#>s.Position<!field#>Position<!field#>2<!field#>3<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>5<!field#>""<!field#>Notes<!field#>2<!field#>4<!field#>true<!field#>6*<!field#><!report#>List<!field#>Roster<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats-Batting" || s.PlayerID || ".html" AS Player, p.Jersey AS Jersey, p.Height AS Height, p.Weight AS Weight, p.Age AS Age, p.Phone AS Phone, p.Email AS Email, p.Address AS Address FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  GROUP BY p.ID<!field#>true<!field#>0<!field#>1<!field#>1<!field#>0<!line#>ListField<!field#>6<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats-Batting" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>2*<!field#>TOTALS<!line#>ListField<!field#>6<!field#>p.Jersey<!field#>Jersey<!field#>2<!field#>2<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>6<!field#>p.Height<!field#>Height<!field#>2<!field#>3<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>6<!field#>p.Weight<!field#>Weight<!field#>2<!field#>4<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>6<!field#>p.Age<!field#>Age<!field#>2<!field#>5<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>6<!field#>p.Phone<!field#>Phone<!field#>2<!field#>6<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>6<!field#>p.Email<!field#>Email<!field#>0<!field#>7<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>6<!field#>p.Address<!field#>Address<!field#>0<!field#>8<!field#>true<!field#>2*<!field#><!report#>List<!field#>Overall<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS GP, sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END) AS GS, sum(s.minutes) AS Min, sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS MPG, sum(s.FG2Made+s.FG3Made) AS FGM, sum(s.FG2Attempted+s.FG3Attempted) AS FGA, sum(s.FG2Made+s.FG3Made)*1.0/sum(s.FG2Attempted+s.FG3Attempted) AS 'FG%', sum(s.FTMade) AS FTM, sum(s.FTAttempted) AS FTA, sum(s.FTMade)*1.0/sum(s.FTAttempted) AS 'FT%', sum(s.FG3Made) AS '3PM', sum(s.FG3Attempted) AS '3PA', sum(s.FG3Made)*1.0/sum(s.FG3Attempted) AS '3P%', sum(s.FG2Made*2+s.FTMade+s.FG3Made*3) AS TP, sum(s.FG2Made*2.0+s.FTMade+s.FG3Made*3.0)/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS PPG, sum(s.Assists) AS Ast, sum(s.Assists)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS APG, sum(s.Turnovers) AS 'TO', sum(s.Assists)*1.0/sum(s.Turnovers) AS 'A/T', max(s.FG2Made*2+s.FTMade+s.FG3Made*3) AS Hi FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS GP, sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END) AS GS, sum(s.minutes) AS Min, sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS MPG, sum(s.FG2Made+s.FG3Made) AS FGM, sum(s.FG2Attempted+s.FG3Attempted) AS FGA, sum(s.FG2Made+s.FG3Made)*1.0/sum(s.FG2Attempted+s.FG3Attempted) AS 'FG%', sum(s.FTMade) AS FTM, sum(s.FTAttempted) AS FTA, sum(s.FTMade)*1.0/sum(s.FTAttempted) AS 'FT%', sum(s.FG3Made) AS '3PM', sum(s.FG3Attempted) AS '3PA', sum(s.FG3Made)*1.0/sum(s.FG3Attempted) AS '3P%', sum(s.FG2Made*2+s.FTMade+s.FG3Made*3) AS TP, sum(s.FG2Made*2.0+s.FTMade+s.FG3Made*3.0)/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS PPG, sum(s.Assists) AS Ast, sum(s.Assists)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS APG, sum(s.Turnovers) AS 'TO', sum(s.Assists)*1.0/sum(s.Turnovers) AS 'A/T', max(s.FG2Made*2+s.FTMade+s.FG3Made*3) AS Hi FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  <!field#>true<!field#>0<!field#>1<!field#>2<!field#>1<!line#>ListField<!field#>7<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>2*<!field#>TOTALS<!line#>ListField<!field#>7<!field#>sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>GP<!field#>2<!field#>2<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END)<!field#>GS<!field#>2<!field#>3<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.minutes)<!field#>Min<!field#>2<!field#>4<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>MPG<!field#>2<!field#>5<!field#>false<!field#>1*<!field#>#0.0<!line#>ListField<!field#>7<!field#>sum(s.FG2Made+s.FG3Made)<!field#>FGM<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.FG2Attempted+s.FG3Attempted)<!field#>FGA<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.FG2Made+s.FG3Made)*1.0/sum(s.FG2Attempted+s.FG3Attempted)<!field#>FG%<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>7<!field#>sum(s.FTMade)<!field#>FTM<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.FTAttempted)<!field#>FTA<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.FTMade)*1.0/sum(s.FTAttempted)<!field#>FT%<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>7<!field#>sum(s.FG3Made)<!field#>3PM<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.FG3Attempted)<!field#>3PA<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.FG3Made)*1.0/sum(s.FG3Attempted)<!field#>3P%<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>7<!field#>sum(s.FG2Made*2+s.FTMade+s.FG3Made*3)<!field#>TP<!field#>2<!field#>15<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.FG2Made*2.0+s.FTMade+s.FG3Made*3.0)/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>PPG<!field#>2<!field#>16<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>7<!field#>sum(s.Assists)<!field#>Ast<!field#>2<!field#>17<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.Assists)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>APG<!field#>2<!field#>18<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>7<!field#>sum(s.Turnovers)<!field#>TO<!field#>2<!field#>19<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>7<!field#>sum(s.Assists)*1.0/sum(s.Turnovers)<!field#>A/T<!field#>2<!field#>20<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>7<!field#>max(s.FG2Made*2+s.FTMade+s.FG3Made*3)<!field#>Hi<!field#>2<!field#>21<!field#>true<!field#>1*<!field#>#0<!report#>List<!field#>Overall (Misc)<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS GP, sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END) AS GS, sum(s.minutes) AS Min, sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS MPG, sum(s.DRebounds) AS DRb, sum(s.ORebounds) AS ORb, sum(s.DRebounds+s.ORebounds) AS Reb, sum(s.Drebounds+s.ORebounds)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS RPG, sum(s.Steals) AS Stl, sum(s.Steals)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS SPG, sum(s.Blocks) AS Blk, sum(s.Blocks)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS BPG, sum(s.Fouls) AS PF FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS GP, sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END) AS GS, sum(s.minutes) AS Min, sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS MPG, sum(s.DRebounds) AS DRb, sum(s.ORebounds) AS ORb, sum(s.DRebounds+s.ORebounds) AS Reb, sum(s.Drebounds+s.ORebounds)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS RPG, sum(s.Steals) AS Stl, sum(s.Steals)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS SPG, sum(s.Blocks) AS Blk, sum(s.Blocks)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS BPG, sum(s.Fouls) AS PF FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  <!field#>false<!field#>0<!field#>1<!field#>3<!field#>1<!line#>ListField<!field#>8<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>3*<!field#>TOTALS<!line#>ListField<!field#>8<!field#>sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>GP<!field#>2<!field#>2<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END)<!field#>GS<!field#>2<!field#>3<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.minutes)<!field#>Min<!field#>2<!field#>4<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>MPG<!field#>2<!field#>5<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>8<!field#>sum(s.DRebounds)<!field#>DRb<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.ORebounds)<!field#>ORb<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.DRebounds+s.ORebounds)<!field#>Reb<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Drebounds+s.ORebounds)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>RPG<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>8<!field#>sum(s.Steals)<!field#>Stl<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Steals)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>SPG<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>8<!field#>sum(s.Blocks)<!field#>Blk<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>8<!field#>sum(s.Blocks)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>BPG<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>8<!field#>sum(s.Fouls)<!field#>PF<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0<!report#>List<!field#>Notes<!field#><!field#>3<!field#><i>Click on column headers to sort statistics</i>
<p>Contact Coach XXXX (Email: yourname@domain.com) if there are any errors.</p><!field#>false<!field#>0<!field#>1<!field#>4<!field#>0<!line#><!report#>List<!field#>Game-by-Game Stats<!field#><!field#>0<!field#>SELECT g.GameNo AS 'No.', g.Opponent AS Opponent, substr(g.GameDate,6,2) || "/" || substr(g.GameDate,9,2) || "/" || substr(g.GameDate,3,2) AS Date, g.Result AS Result, g.Score AS Score, sum(s.FG2Made+s.FG3Made) AS FGM, sum(s.FG2Attempted+s.FG3Attempted) AS FGA, sum(s.FG2Made+s.FG3Made)*1.0/sum(s.FG2Attempted+s.FG3Attempted) AS 'FG%', sum(s.FG3Made) AS '3PM', sum(s.FG3Attempted) AS '3PA', sum(s.FG3Made)*1.0/sum(s.FG3Attempted) AS '3P%', sum(s.FTMade) AS FTM, sum(s.FTAttempted) AS FTA, sum(s.FTMade)*1.0/sum(s.FTAttempted) AS 'FT%', sum(s.ORebounds) AS ORb, sum(s.DRebounds) AS DRb, sum(s.DRebounds+s.ORebounds) AS Reb, sum(s.Assists) AS Ast, sum(s.Turnovers) AS 'TO', sum(s.Assists)*1.0/sum(s.Turnovers) AS 'A/T', sum(s.Steals) AS Stl, sum(s.Blocks) AS Blk, sum(s.Fouls) AS PF, sum(s.FG2Made*2+s.FTMade+s.FG3Made*3) AS TP, sum(s.FG2Made*2.0+s.FTMade+s.FG3Made*3.0)/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS PPG FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  GROUP BY g.ID UNION SELECT ' ' AS 'No.', 'TOTALS' AS Opponent, ' ' AS Date, '' AS Result, '  ' AS Score, sum(s.FG2Made+s.FG3Made) AS FGM, sum(s.FG2Attempted+s.FG3Attempted) AS FGA, sum(s.FG2Made+s.FG3Made)*1.0/sum(s.FG2Attempted+s.FG3Attempted) AS 'FG%', sum(s.FG3Made) AS '3PM', sum(s.FG3Attempted) AS '3PA', sum(s.FG3Made)*1.0/sum(s.FG3Attempted) AS '3P%', sum(s.FTMade) AS FTM, sum(s.FTAttempted) AS FTA, sum(s.FTMade)*1.0/sum(s.FTAttempted) AS 'FT%', sum(s.ORebounds) AS ORb, sum(s.DRebounds) AS DRb, sum(s.DRebounds+s.ORebounds) AS Reb, sum(s.Assists) AS Ast, sum(s.Turnovers) AS 'TO', sum(s.Assists)*1.0/sum(s.Turnovers) AS 'A/T', sum(s.Steals) AS Stl, sum(s.Blocks) AS Blk, sum(s.Fouls) AS PF, sum(s.FG2Made*2+s.FTMade+s.FG3Made*3) AS TP, sum(s.FG2Made*2.0+s.FTMade+s.FG3Made*3.0)/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS PPG FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  <!field#>true<!field#>0<!field#>1<!field#>5<!field#>0<!line#>ListField<!field#>10<!field#>g.GameNo<!field#>No.<!field#>2<!field#>1<!field#>true<!field#>1*<!field#> <!line#>ListField<!field#>10<!field#>g.Opponent<!field#>Opponent<!field#>0<!field#>2<!field#>true<!field#>2*<!field#>TOTALS<!line#>ListField<!field#>10<!field#>substr(g.GameDate,6,2) || "/" || substr(g.GameDate,9,2) || "/" || substr(g.GameDate,3,2)<!field#>Date<!field#>2<!field#>3<!field#>true<!field#>2*<!field#> <!line#>ListField<!field#>10<!field#>g.Result<!field#>Result<!field#>2<!field#>4<!field#>true<!field#>1*<!field#><!line#>ListField<!field#>10<!field#>g.Score<!field#>Score<!field#>2<!field#>5<!field#>true<!field#>2*<!field#>  <!line#>ListField<!field#>10<!field#>sum(s.FG2Made+s.FG3Made)<!field#>FGM<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.FG2Attempted+s.FG3Attempted)<!field#>FGA<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.FG2Made+s.FG3Made)*1.0/sum(s.FG2Attempted+s.FG3Attempted)<!field#>FG%<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>10<!field#>sum(s.FG3Made)<!field#>3PM<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.FG3Attempted)<!field#>3PA<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.FG3Made)*1.0/sum(s.FG3Attempted)<!field#>3P%<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>10<!field#>sum(s.FTMade)<!field#>FTM<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.FTAttempted)<!field#>FTA<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.FTMade)*1.0/sum(s.FTAttempted)<!field#>FT%<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>10<!field#>sum(s.ORebounds)<!field#>ORb<!field#>2<!field#>15<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.DRebounds)<!field#>DRb<!field#>2<!field#>16<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.DRebounds+s.ORebounds)<!field#>Reb<!field#>2<!field#>17<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Assists)<!field#>Ast<!field#>2<!field#>18<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Turnovers)<!field#>TO<!field#>2<!field#>19<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Assists)*1.0/sum(s.Turnovers)<!field#>A/T<!field#>2<!field#>20<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>10<!field#>sum(s.Steals)<!field#>Stl<!field#>2<!field#>21<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Blocks)<!field#>Blk<!field#>2<!field#>22<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.Fouls)<!field#>PF<!field#>2<!field#>23<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.FG2Made*2+s.FTMade+s.FG3Made*3)<!field#>TP<!field#>2<!field#>24<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>10<!field#>sum(s.FG2Made*2.0+s.FTMade+s.FG3Made*3.0)/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>PPG<!field#>2<!field#>25<!field#>true<!field#>1*<!field#>#0.0<!report#>List<!field#>Overall (Last 5 Games)<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS GP, sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END) AS GS, sum(s.minutes) AS Min, sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS MPG, sum(s.FG2Made+s.FG3Made) AS FGM, sum(s.FG2Attempted+s.FG3Attempted) AS FGA, sum(s.FG2Made+s.FG3Made)*1.0/sum(s.FG2Attempted+s.FG3Attempted) AS 'FG%', sum(s.FTMade) AS FTM, sum(s.FTAttempted) AS FTA, sum(s.FTMade)*1.0/sum(s.FTAttempted) AS 'FT%', sum(s.FG3Made) AS '3PM', sum(s.FG3Attempted) AS '3PA', sum(s.FG3Made)*1.0/sum(s.FG3Attempted) AS '3P%', sum(s.FG2Made*2+s.FTMade+s.FG3Made*3) AS TP, sum(s.FG2Made*2.0+s.FTMade+s.FG3Made*3.0)/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS PPG, sum(s.Assists) AS Ast, sum(s.Assists)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS APG, sum(s.Turnovers) AS 'TO', sum(s.Assists)*1.0/sum(s.Turnovers) AS 'A/T' FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo DESC LIMIT 0,5) 
GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS GP, sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END) AS GS, sum(s.minutes) AS Min, sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS MPG, sum(s.FG2Made+s.FG3Made) AS FGM, sum(s.FG2Attempted+s.FG3Attempted) AS FGA, sum(s.FG2Made+s.FG3Made)*1.0/sum(s.FG2Attempted+s.FG3Attempted) AS 'FG%', sum(s.FTMade) AS FTM, sum(s.FTAttempted) AS FTA, sum(s.FTMade)*1.0/sum(s.FTAttempted) AS 'FT%', sum(s.FG3Made) AS '3PM', sum(s.FG3Attempted) AS '3PA', sum(s.FG3Made)*1.0/sum(s.FG3Attempted) AS '3P%', sum(s.FG2Made*2+s.FTMade+s.FG3Made*3) AS TP, sum(s.FG2Made*2.0+s.FTMade+s.FG3Made*3.0)/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS PPG, sum(s.Assists) AS Ast, sum(s.Assists)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS APG, sum(s.Turnovers) AS 'TO', sum(s.Assists)*1.0/sum(s.Turnovers) AS 'A/T' FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo DESC LIMIT 0,5)<!field#>true<!field#>0<!field#>1<!field#>6<!field#>1<!line#>ListField<!field#>11<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>2*<!field#>TOTALS<!line#>ListField<!field#>11<!field#>sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>GP<!field#>2<!field#>2<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END)<!field#>GS<!field#>2<!field#>3<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.minutes)<!field#>Min<!field#>2<!field#>4<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>MPG<!field#>2<!field#>5<!field#>false<!field#>1*<!field#>#0.0<!line#>ListField<!field#>11<!field#>sum(s.FG2Made+s.FG3Made)<!field#>FGM<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.FG2Attempted+s.FG3Attempted)<!field#>FGA<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.FG2Made+s.FG3Made)*1.0/sum(s.FG2Attempted+s.FG3Attempted)<!field#>FG%<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>11<!field#>sum(s.FTMade)<!field#>FTM<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.FTAttempted)<!field#>FTA<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.FTMade)*1.0/sum(s.FTAttempted)<!field#>FT%<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>11<!field#>sum(s.FG3Made)<!field#>3PM<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.FG3Attempted)<!field#>3PA<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.FG3Made)*1.0/sum(s.FG3Attempted)<!field#>3P%<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>11<!field#>sum(s.FG2Made*2+s.FTMade+s.FG3Made*3)<!field#>TP<!field#>2<!field#>15<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.FG2Made*2.0+s.FTMade+s.FG3Made*3.0)/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>PPG<!field#>2<!field#>16<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>11<!field#>sum(s.Assists)<!field#>Ast<!field#>2<!field#>17<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.Assists)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>APG<!field#>2<!field#>18<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>11<!field#>sum(s.Turnovers)<!field#>TO<!field#>2<!field#>19<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>11<!field#>sum(s.Assists)*1.0/sum(s.Turnovers)<!field#>A/T<!field#>2<!field#>20<!field#>true<!field#>1*<!field#>#0.0<!report#>List<!field#>Overall (Misc, Last 5)<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS GP, sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END) AS GS, sum(s.minutes) AS Min, sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS MPG, sum(s.DRebounds) AS DRb, sum(s.ORebounds) AS Orb, sum(s.DRebounds+s.ORebounds) AS Reb, sum(s.Drebounds+s.ORebounds)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS RPG, sum(s.Steals) AS Stl, sum(s.Steals)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS SPG, sum(s.Blocks) AS Blk, sum(s.Blocks)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS BPG, sum(s.Fouls) AS PF FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo DESC LIMIT 0,5) 
GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS GP, sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END) AS GS, sum(s.minutes) AS Min, sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS MPG, sum(s.DRebounds) AS DRb, sum(s.ORebounds) AS Orb, sum(s.DRebounds+s.ORebounds) AS Reb, sum(s.Drebounds+s.ORebounds)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS RPG, sum(s.Steals) AS Stl, sum(s.Steals)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS SPG, sum(s.Blocks) AS Blk, sum(s.Blocks)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS BPG, sum(s.Fouls) AS PF FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo DESC LIMIT 0,5)<!field#>false<!field#>0<!field#>1<!field#>7<!field#>0<!line#>ListField<!field#>12<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>3*<!field#>TOTALS<!line#>ListField<!field#>12<!field#>sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>GP<!field#>2<!field#>2<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END)<!field#>GS<!field#>2<!field#>3<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>sum(s.minutes)<!field#>Min<!field#>2<!field#>4<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>MPG<!field#>2<!field#>5<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>12<!field#>sum(s.DRebounds)<!field#>DRb<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>sum(s.ORebounds)<!field#>Orb<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>sum(s.DRebounds+s.ORebounds)<!field#>Reb<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>sum(s.Drebounds+s.ORebounds)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>RPG<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>12<!field#>sum(s.Steals)<!field#>Stl<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>sum(s.Steals)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>SPG<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>12<!field#>sum(s.Blocks)<!field#>Blk<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>12<!field#>sum(s.Blocks)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>BPG<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>12<!field#>sum(s.Fouls)<!field#>PF<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0<!report#>List<!field#>Boxscores<!field#><!field#>2:0<!field#>SELECT s.OffenseOrder AS 'Order', p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, s.Position AS Pos, s.FG2Made+s.FG3Made AS FGM, s.FG2Attempted+s.FG3Attempted AS FGA, s.FG3Made AS '3PM', s.FG3Attempted AS '3PA', s.FTMade AS FTM, s.FTAttempted AS FTA, s.ORebounds AS Orb, s.DRebounds AS DRb, s.Drebounds+s.ORebounds AS Reb, s.Fouls AS PF, s.FG2Made*2+s.FTMade+s.FG3Made*3 AS TP, s.Assists AS Ast, s.Turnovers AS 'TO', s.Blocks AS Blk, s.Steals AS Stl, s.minutes AS Min FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.Played='1' AND s.GameID = '#idx#'  UNION SELECT '--' AS 'Order', 'TOTALS' AS Player, ' ' AS Pos, sum(s.FG2Made)+sum(s.FG3Made) AS FGM, sum(s.FG2Attempted)+sum(s.FG3Attempted) AS FGA, sum(s.FG3Made) AS '3PM', sum(s.FG3Attempted) AS '3PA', sum(s.FTMade) AS FTM, sum(s.FTAttempted) AS FTA, sum(s.ORebounds) AS Orb, sum(s.DRebounds) AS DRb, sum(s.Drebounds)+sum(s.ORebounds) AS Reb, sum(s.Fouls) AS PF, sum(s.FG2Made)*2+sum(s.FTMade)+sum(s.FG3Made)*3 AS TP, sum(s.Assists) AS Ast, sum(s.Turnovers) AS 'TO', sum(s.Blocks) AS Blk, sum(s.Steals) AS Stl, sum(s.minutes) AS Min FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.Played='1' AND s.GameID = '#idx#' <!field#>true<!field#>0<!field#>1<!field#>8<!field#>0<!line#>ListField<!field#>13<!field#>s.OffenseOrder<!field#>Order<!field#>2<!field#>1<!field#>true<!field#>1*<!field#>--<!line#>ListField<!field#>13<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>2<!field#>true<!field#>3*<!field#>TOTALS<!line#>ListField<!field#>13<!field#>s.Position<!field#>Pos<!field#>2<!field#>3<!field#>true<!field#>1*<!field#> <!line#>ListField<!field#>13<!field#>s.FG2Made+s.FG3Made<!field#>FGM<!field#>2<!field#>4<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.FG2Attempted+s.FG3Attempted<!field#>FGA<!field#>2<!field#>5<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.FG3Made<!field#>3PM<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.FG3Attempted<!field#>3PA<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.FTMade<!field#>FTM<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.FTAttempted<!field#>FTA<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.ORebounds<!field#>Orb<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.DRebounds<!field#>DRb<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.Drebounds+s.ORebounds<!field#>Reb<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.Fouls<!field#>PF<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.FG2Made*2+s.FTMade+s.FG3Made*3<!field#>TP<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.Assists<!field#>Ast<!field#>2<!field#>15<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.Turnovers<!field#>TO<!field#>2<!field#>16<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.Blocks<!field#>Blk<!field#>2<!field#>17<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.Steals<!field#>Stl<!field#>2<!field#>18<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>13<!field#>s.minutes<!field#>Min<!field#>2<!field#>19<!field#>true<!field#>1*<!field#>#0<!report#>List<!field#>Player Game Logs<!field#><!field#>1:0<!field#>SELECT s.OffenseOrder AS 'Order', substr(g.GameDate,6,2) || "/" || substr(g.GameDate,9,2) || "/" || substr(g.GameDate,3,2) AS Date, g.Opponent  || " ("  || g.Result || ", " || g.Score  || ")" || "#link#" || "Boxscore" || s.GameID || ".html" AS Game, s.Started AS GS, s.minutes AS Min, s.FG2Made+s.FG3Made AS FGM, s.FG2Attempted+s.FG3Attempted AS FGA, s.FG3Made AS '3PM', s.FG3Attempted AS '3PA', s.FTMade AS FTM, s.FTAttempted AS FTA, s.ORebounds AS ORb, s.DRebounds AS DRb, s.Drebounds+s.ORebounds AS Reb, s.Assists AS Ast, s.Turnovers AS 'TO', s.Steals AS Stl, s.Blocks AS Blk, s.Fouls AS PF, s.FG2Made*2+s.FTMade+s.FG3Made*3 AS TP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.Played='1' AND s.PlayerID = '#idx#'  UNION SELECT '--' AS 'Order', '' AS Date, 'TOTALS' AS Game, ' ' AS GS, sum(s.minutes) AS Min, sum(s.FG2Made)+sum(s.FG3Made) AS FGM, sum(s.FG2Attempted)+sum(s.FG3Attempted) AS FGA, sum(s.FG3Made) AS '3PM', sum(s.FG3Attempted) AS '3PA', sum(s.FTMade) AS FTM, sum(s.FTAttempted) AS FTA, sum(s.ORebounds) AS ORb, sum(s.DRebounds) AS DRb, sum(s.Drebounds)+sum(s.ORebounds) AS Reb, sum(s.Assists) AS Ast, sum(s.Turnovers) AS 'TO', sum(s.Steals) AS Stl, sum(s.Blocks) AS Blk, sum(s.Fouls) AS PF, sum(s.FG2Made)*2+sum(s.FTMade)+sum(s.FG3Made)*3 AS TP FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  WHERE s.Played='1' AND s.PlayerID = '#idx#' <!field#>true<!field#>0<!field#>1<!field#>9<!field#>0<!line#>ListField<!field#>14<!field#>s.OffenseOrder<!field#>Order<!field#>2<!field#>1<!field#>false<!field#>1*<!field#>--<!line#>ListField<!field#>14<!field#>substr(g.GameDate,6,2) || "/" || substr(g.GameDate,9,2) || "/" || substr(g.GameDate,3,2)<!field#>Date<!field#>2<!field#>2<!field#>true<!field#>2*<!field#><!line#>ListField<!field#>14<!field#>g.Opponent  || " ("  || g.Result || ", " || g.Score  || ")" || "#link#" || "Boxscore" || s.GameID || ".html"<!field#>Game<!field#>0<!field#>3<!field#>true<!field#>4*<!field#>TOTALS<!line#>ListField<!field#>14<!field#>s.Started<!field#>GS<!field#>2<!field#>4<!field#>true<!field#>1*<!field#> <!line#>ListField<!field#>14<!field#>s.minutes<!field#>Min<!field#>2<!field#>5<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.FG2Made+s.FG3Made<!field#>FGM<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.FG2Attempted+s.FG3Attempted<!field#>FGA<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.FG3Made<!field#>3PM<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.FG3Attempted<!field#>3PA<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.FTMade<!field#>FTM<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.FTAttempted<!field#>FTA<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.ORebounds<!field#>ORb<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.DRebounds<!field#>DRb<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Drebounds+s.ORebounds<!field#>Reb<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Assists<!field#>Ast<!field#>2<!field#>15<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Turnovers<!field#>TO<!field#>2<!field#>16<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Steals<!field#>Stl<!field#>2<!field#>17<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Blocks<!field#>Blk<!field#>2<!field#>18<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.Fouls<!field#>PF<!field#>2<!field#>19<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>14<!field#>s.FG2Made*2+s.FTMade+s.FG3Made*3<!field#>TP<!field#>2<!field#>20<!field#>true<!field#>1*<!field#>#0<!report#>List<!field#>Statistics Legend<!field#><!field#>3<!field#><p align="center"><b><font size="4">Basketball Statistics Legend</font></b></p>
<table width="100%" border="0" cellpadding="7" cellspacing="1" background="../IMAGES/bg.gif">
        <tr valign="middle" class="rowheading">
          <td width="15%" bgcolor="#000033"><font color="#FFFFFF"><b>Abbr</b></font></td>
          <td width="35%" nowrap="nowrap" bgcolor="#000033"><font color="#FFFFFF"><b>Statistic</b></font></td>
          <td width="15%" bgcolor="#000033"><font color="#FFFFFF"><b>Abbr</b></font></td>
          <td width="35%" nowrap="nowrap" bgcolor="#000033"><font color="#FFFFFF"><b>Statistic</b></font></td>
        </tr>
        <tr valign="top" class="oddrow">
          <td valign="top" class="theBody">GP</td>
          <td valign="top" nowrap="nowrap" class="theBody">Games Played</td>
          <td class="theBody">Min</td>
          <td nowrap="nowrap" class="theBody">Minutes</td>
        </tr>
        <tr valign="top" class="evenrow">
          <td valign="top" class="theBody">GS</td>
          <td valign="top" nowrap="nowrap" class="theBody">Games Started</td>
          <td class="theBody">MPG</td>
          <td nowrap="nowrap" class="theBody">Minutes per Game</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td class="theBody">FGM</td>
          <td nowrap="nowrap" class="theBody">Field Goals Made (2-pointers + 3-pointers) </td>
          <td class="theBody">ORb</td>
          <td nowrap="nowrap" class="theBody">Offensive Rebounds</td>
        </tr>
        <tr valign="top" class="evenrow">
          <td class="theBody">FGA</td>
          <td nowrap="nowrap" class="theBody">Field Goals Attempted (2-pointers + 3-pointers) </td>
          <td class="theBody">DRb</td>
          <td nowrap="nowrap" class="theBody">Defensive Rebounds</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td class="theBody">FTM</td>
          <td nowrap="nowrap" class="theBody">Free Throws Made</td>
          <td class="theBody">Reb</td>
          <td nowrap="nowrap" class="theBody">Total Rebounds</td>
        </tr>
        <tr valign="top" class="evenrow">
          <td class="theBody">FTA</td>
          <td nowrap="nowrap" class="theBody">Free Throws Attempted</td>
          <td class="theBody">S or Stl </td>
          <td nowrap="nowrap" class="theBody">Steals</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td class="theBody">3PM</td>
          <td nowrap="nowrap" class="theBody">3-Point Field Goals Made</td>
          <td class="theBody">B or Blk </td>
          <td nowrap="nowrap" class="theBody">Blocks</td>
        </tr>
        <tr valign="top" class="evenrow">
          <td class="theBody">3PA</td>
          <td nowrap="nowrap" class="theBody">3-Point Field Goals Attempted</td>
          <td class="theBody">PF</td>
          <td nowrap="nowrap" class="theBody">Personal Fouls</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td class="theBody">TP</td>
          <td nowrap="nowrap" class="theBody">Total Points</td>
          <td valign="top" nowrap="nowrap" class="theBody">TF</td>
          <td valign="top" nowrap="nowrap" class="theBody">Technical Foul </td>
        </tr>
        <tr valign="top" class="evenrow">
          <td class="theBody">A or Ast</td>
          <td nowrap="nowrap" class="theBody">Assists</td>
          <td valign="top" nowrap="nowrap" class="theBody">Pos</td>
          <td valign="top" nowrap="nowrap" class="theBody">Position</td>
        </tr>
        <tr valign="top" class="oddrow">
          <td class="theBody">TO</td>
          <td nowrap="nowrap" class="theBody">Turnovers</td>
          <td valign="top" nowrap="nowrap" class="theBody">&nbsp;</td>
          <td valign="top" nowrap="nowrap" class="theBody">&nbsp;</td>
        </tr>
        <tr valign="top" class="evenrow">
          <td class="theBody">A/T</td>
          <td nowrap="nowrap" class="theBody">Assist/Turnover Ratio</td>
          <td valign="top" nowrap="nowrap" class="theBody">&nbsp;</td>
          <td valign="top" nowrap="nowrap" class="theBody">&nbsp;</td>
        </tr>
      </table>
    <!field#>true<!field#>0<!field#>1<!field#>10<!field#>0<!line#><!report#>List<!field#>Overall - Post Season<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS GP, sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END) AS GS, sum(s.minutes) AS Min, sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS MPG, sum(s.FG2Made+s.FG3Made) AS FGM, sum(s.FG2Attempted+s.FG3Attempted) AS FGA, sum(s.FG2Made+s.FG3Made)*1.0/sum(s.FG2Attempted+s.FG3Attempted) AS 'FG%', sum(s.FTMade) AS FTM, sum(s.FTAttempted) AS FTA, sum(s.FTMade)*1.0/sum(s.FTAttempted) AS 'FT%', sum(s.FG3Made) AS '3PM', sum(s.FG3Attempted) AS '3PA', sum(s.FG3Made)*1.0/sum(s.FG3Attempted) AS '3P%', sum(s.FG2Made*2+s.FTMade+s.FG3Made*3) AS PTS, sum(s.FG2Made*2.0+s.FTMade+s.FG3Made*3.0)/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS PPG, sum(s.Assists) AS Ast, sum(s.Assists)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS APG, sum(s.Turnovers) AS 'TO', sum(s.Assists)*1.0/sum(s.Turnovers) AS 'A/T' FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  Where g.GameType="Post-Season"
GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS GP, sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END) AS GS, sum(s.minutes) AS Min, sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS MPG, sum(s.FG2Made+s.FG3Made) AS FGM, sum(s.FG2Attempted+s.FG3Attempted) AS FGA, sum(s.FG2Made+s.FG3Made)*1.0/sum(s.FG2Attempted+s.FG3Attempted) AS 'FG%', sum(s.FTMade) AS FTM, sum(s.FTAttempted) AS FTA, sum(s.FTMade)*1.0/sum(s.FTAttempted) AS 'FT%', sum(s.FG3Made) AS '3PM', sum(s.FG3Attempted) AS '3PA', sum(s.FG3Made)*1.0/sum(s.FG3Attempted) AS '3P%', sum(s.FG2Made*2+s.FTMade+s.FG3Made*3) AS PTS, sum(s.FG2Made*2.0+s.FTMade+s.FG3Made*3.0)/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS PPG, sum(s.Assists) AS Ast, sum(s.Assists)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS APG, sum(s.Turnovers) AS 'TO', sum(s.Assists)*1.0/sum(s.Turnovers) AS 'A/T' FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  Where g.GameType="Post-Season"<!field#>false<!field#>0<!field#>1<!field#>11<!field#>1<!line#>ListField<!field#>16<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>2*<!field#>TOTALS<!line#>ListField<!field#>16<!field#>sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>GP<!field#>2<!field#>2<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>16<!field#>sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END)<!field#>GS<!field#>2<!field#>3<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>16<!field#>sum(s.minutes)<!field#>Min<!field#>2<!field#>4<!field#>false<!field#>1*<!field#>#0<!line#>ListField<!field#>16<!field#>sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>MPG<!field#>2<!field#>5<!field#>false<!field#>1*<!field#>#0.0<!line#>ListField<!field#>16<!field#>sum(s.FG2Made+s.FG3Made)<!field#>FGM<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>16<!field#>sum(s.FG2Attempted+s.FG3Attempted)<!field#>FGA<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>16<!field#>sum(s.FG2Made+s.FG3Made)*1.0/sum(s.FG2Attempted+s.FG3Attempted)<!field#>FG%<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>16<!field#>sum(s.FTMade)<!field#>FTM<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>16<!field#>sum(s.FTAttempted)<!field#>FTA<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>16<!field#>sum(s.FTMade)*1.0/sum(s.FTAttempted)<!field#>FT%<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>16<!field#>sum(s.FG3Made)<!field#>3PM<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>16<!field#>sum(s.FG3Attempted)<!field#>3PA<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>16<!field#>sum(s.FG3Made)*1.0/sum(s.FG3Attempted)<!field#>3P%<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0.0%<!line#>ListField<!field#>16<!field#>sum(s.FG2Made*2+s.FTMade+s.FG3Made*3)<!field#>PTS<!field#>2<!field#>15<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>16<!field#>sum(s.FG2Made*2.0+s.FTMade+s.FG3Made*3.0)/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>PPG<!field#>2<!field#>16<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>16<!field#>sum(s.Assists)<!field#>Ast<!field#>2<!field#>17<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>16<!field#>sum(s.Assists)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>APG<!field#>2<!field#>18<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>16<!field#>sum(s.Turnovers)<!field#>TO<!field#>2<!field#>19<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>16<!field#>sum(s.Assists)*1.0/sum(s.Turnovers)<!field#>A/T<!field#>2<!field#>20<!field#>true<!field#>1*<!field#>#0.0<!report#>List<!field#>Overall (Misc, Post Season)<!field#><!field#>0<!field#>SELECT p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html" AS Player, sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS GP, sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END) AS GS, sum(s.minutes) AS Min, sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS MPG, sum(s.ORebounds) AS Orb, sum(s.DRebounds) AS DRb, sum(s.DRebounds+s.ORebounds) AS Reb, sum(s.Drebounds+s.ORebounds)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS RPG, sum(s.Steals) AS Stl, sum(s.Steals)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS SPG, sum(s.Blocks) AS Blk, sum(s.Blocks)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS BPG, sum(s.Fouls) AS PF FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  Where g.GameType="Post-Season"
GROUP BY p.ID UNION SELECT 'TOTALS' AS Player, sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS GP, sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END) AS GS, sum(s.minutes) AS Min, sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS MPG, sum(s.ORebounds) AS Orb, sum(s.DRebounds) AS DRb, sum(s.DRebounds+s.ORebounds) AS Reb, sum(s.Drebounds+s.ORebounds)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS RPG, sum(s.Steals) AS Stl, sum(s.Steals)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS SPG, sum(s.Blocks) AS Blk, sum(s.Blocks)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END) AS BPG, sum(s.Fouls) AS PF FROM Stats s LEFT JOIN Players p ON p.ID = s.PlayerID LEFT JOIN Games g ON g.ID = s.GameID  Where g.GameType="Post-Season"<!field#>false<!field#>0<!field#>1<!field#>12<!field#>0<!line#>ListField<!field#>17<!field#>p.Last || ", " || p.first || "#link#" || "PlayerStats" || s.PlayerID || ".html"<!field#>Player<!field#>0<!field#>1<!field#>true<!field#>3*<!field#>TOTALS<!line#>ListField<!field#>17<!field#>sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>GP<!field#>2<!field#>2<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>17<!field#>sum(CASE WHEN s.started='1' THEN 1 ELSE 0 END)<!field#>GS<!field#>2<!field#>3<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>17<!field#>sum(s.minutes)<!field#>Min<!field#>2<!field#>4<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>17<!field#>sum(s.minutes)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>MPG<!field#>2<!field#>5<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>17<!field#>sum(s.ORebounds)<!field#>Orb<!field#>2<!field#>6<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>17<!field#>sum(s.DRebounds)<!field#>DRb<!field#>2<!field#>7<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>17<!field#>sum(s.DRebounds+s.ORebounds)<!field#>Reb<!field#>2<!field#>8<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>17<!field#>sum(s.Drebounds+s.ORebounds)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>RPG<!field#>2<!field#>9<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>17<!field#>sum(s.Steals)<!field#>Stl<!field#>2<!field#>10<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>17<!field#>sum(s.Steals)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>SPG<!field#>2<!field#>11<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>17<!field#>sum(s.Blocks)<!field#>Blk<!field#>2<!field#>12<!field#>true<!field#>1*<!field#>#0<!line#>ListField<!field#>17<!field#>sum(s.Blocks)*1.0/sum(CASE WHEN s.played='1' THEN 1 ELSE 0 END)<!field#>BPG<!field#>2<!field#>13<!field#>true<!field#>1*<!field#>#0.0<!line#>ListField<!field#>17<!field#>sum(s.Fouls)<!field#>PF<!field#>2<!field#>14<!field#>true<!field#>1*<!field#>#0<!report#>