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(26503)
}
}

Years ago
New NBL Site Design
Haven't really had time to look at the site properly, but one thing that really irks me is not being able to tell at a glance which team is the home team in each matchup.
The Yanks always have BOS @ NYK for eg, so everyone instantly knows Boston is playing on the Knicks homecourt. Aussie basketball people must have seen this and yet we persist with an inferior method of presenting matchups. Why?

Years ago
NBL needs a League Pass service.
Probably wouldn't be profitable, but hey, it'd be awesome.
