array(2) {
[0]=>
string(815) "
select r.*,
rc.info,
t.title as threadtitle,
u.username as username,
u.anonymous as useranonymous,
`f`.`value` AS `flairvalue`,
`ft`.`name` AS `flairname`,
`ft`.`colour` AS `flaircolour`,
`ft`.`icon` AS `flairicon`
from reply as r
join thread as t on t.id = r.threadid
join replycontent as rc on rc.replyid = r.id
join user as u on u.id = r.userid
left join `flair` `f` on `f`.`userid` = `u`.`id` and `f`.`categoryid` = `t`.`categoryid`
left join `flairoption` `ft` on `ft`.`id` = `f`.`flairoptionid`
where r.businessid = :businessId
and r.threadid = :threadId
group by r.id
order by r.utcdated desc
limit 0,50
"
[1]=>
array(2) {
["businessId"]=>
int(1)
["threadId"]=>
int(19546)
}
}
Anonymous
Years ago
Free Excel Basketball Statistics Workbook
Don't want to be negative and the package you've developed looks terrific and does some stuff that LIVE STATS wont, but did you know that LIVE STATS is downloadable FREE from the FIBA site?
Its reasonably comprehensive and allows instantaneous input rather than transcription but I'm not sure it tallies over the season the way your package seems to.
Another key stat I'm trying to play with at the moment and would like to automate more is +/-. That is, the difference between the score when a player enters the court and when a player leaves the court (accumulated over the game).
I had a play during one of my daughter's games last week and it was telling to see the variation in scores. Probably can't tell a whole lot from the one game but I'd be interested to see trends over the year. Scores in this particular 6-point win ranged from -2 to +18.