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(31828)
}
}
Your son may wish to ask around at his local school as well. He may have a number of friends who play at clubs already.
Another thing to consider is where he is going to high school as this could impact on travel logistics. If he is going to say Scotch, then it may be easier for him to go to Sturt.
My 2 cents worth:
I think all clubs have got good coaches and committees. Some are more vocal at letting you know it.
West and North are probably the closest.
Norwood could be a goer. My nephew is playing there and is happy.
Forestville. Always well organised.
Centrals - getting out of the city. Facilities are first class, but Adelaideans have a thing about going north of Gepps Cross.
Woodville - boys are deceptively strong. Don't be too quick to discount them. Also have a more "family feel" than a larger club where a child runs the risk of being a number.