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(18415)
}
}
You know it's Friday afternoon when a thread like this gets posted.
I got all the names off of boxscores so far this year, or well-known ABLers who may not playing at the moment. The teams may not have played each other yet, or the players may not play the same position, but that's not the point.
Here are my key ABL men's matchups for 2005, to be said out loud in the manner of a court announcer:
the Forman-Farman matchup (Sturt v Forestville)
Coffey-Cioffi (Central v West)
Kies-Rees (North v Woodville)
I'm desperately waiting for one of the following players to transfer from South, so we can have the following killer matchup:
Frost-Blight
Other players with names begging for a matchup include: