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(24136)
}
}
Nominations still have til the 12th November 2010 before closing. But we are looking at a strong A Mens grade again as per recent years. There maybe a possiblity of SA Country nominating teams for the experience but this is still to be confirmed.
To all teams our carnival is open to all divisions in juniors & seniors. Groups will be determined by what division your players currently play in. If we get division 1 teams wanting to nominate we will scout around our current clubs and associations and try and get enough teams to have a div 1 group. As long as we get correct divisions stated on nomination forms teams will not be subject to play against teams higher than they nominate.
If you would like to enter a team or for more details please email basketballsa@adam.com.au or call 0408 575 041
Hope to see you all at the carnival.