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(25291)
}
}
I'm also a bit miffed that a few players have been selected despite either not cutting it at International level previously or are around the age of 30 and have never been able to "make it" previously. I'm not saying they do not deserve to be "ranked" in the top echelon of players for Australia, but surely we should be picking those that are locks (i.e. Jackson, Taylor etc) but also the talented younger players that are on the periphery and may not yet have had a chance to estblish themselves on the senior international stage.
In any case, my "locks" for the Opals team are pending availability and fitness permitting are:
Jackson
Taylor
Cambage
Batkovic
Harrower
O'Hea
Snell
for mine, the above selections are no-brainers, and that leaves 5 more spots up for grabs IMO.