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(44269)
}
}
I'm not all that fussed about timing.
From a scheduling point of view it makes sense to have a lot of Sunday games of course since it means those teams can play twice per round.
Hate Sat arvo. Love sat night. Can put up with sun arvo. There is approx 4-5 sat arvo games for 36ers this season. We do know NBL basketball is played during the summer don't we, so lets's put the game on during the hottest part of the day. I bet the spectators won't be loving it in December, January and February when it's 30 odd degrees. I bet that was never discussed by the tv execs.
Fox and 9 dictate when games are on. Clearly they dont want to show NBL on Saturday night so the NBL dont fixture as many games that time anymore. Big shame because NBL is best when its played on saturday night IMO.