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(23710)
}
}
Im surprised at the lack of joiners. we have almost hit 10, for the amount of people that know how the season is going to end not many are joining. come all get involved, even get your friends involved.
neither did i but it has. So get on board. Im keen to get all the hoops people on it. You cant go wrong with bragging rights! There are alot of people on here that know what they are talking about and alot that think they know what they are talking about so let your tips do the talking!
also i have included the streak option for the competition. so this will be for predicting teams winning streaks. hope you all join and put your skills to the test!
After being down by 14 at the half, the boomers pulled in a massive second half effort to win by 1 point to the Tall Blacks. Both teams were shooting the lights out and Australias win was on the back of a brilliant effort by Jason Smith. Aaron Bruce and Newley also found there range from the three... Nice to hear, Keep improving boomers!