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(19419)
}
}
Looks like he had another good game against the panthers, reckon the Davo effect is working. 7/10 3 pts is not a bad effort IMO. Still needs to work on turnovers.
Index of success has risen from 8.4 to 24.7 per game
I need boxscores (or at least just the final scores) from the North vs Norwood games (men and women) last week. I cannot process the tipping results without these scores.
Then to complete the ABL Statistics pages, I need boxscores for four games (67 and 70, men and women). 67 was Warriors vs Flames at the Dome. 70 was Warriors vs Mavs, also at the Dome.
If anyone can help, please do -- it would be great to have a full set of regular season statistics for 2005 to preserve for historical reference. Once I have this, I will make available a zip of all the 2005 boxscores for coaches and clubs who need them.