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(21690)
}
}
This is the issue that basketball, and even cricket is just going to have to face though.
Youngsters will switch from both of those sports to AFL because it is easier to make the elite levels.
Especially with the 2 new teams coming in, there will be extra roster spots to fill, hence raw and unready kids will be put into those spots.
Why hoop, or play cricket for small money when you can get on an AFL list as a fringe player and receive a 2 year gig out of that.
AFL will suffer as well in the short term as players that would not normally be drafted will be, just to fill squads. A few injuries and this 38th player on the list may all of a sudden be getting a game that he normally would not. This then means inferior talent on the field.
The AFL expansion will do more harm than good to a lot of sports at grass roots level IMO.