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(28482)
}
}
Yes Corz I do pay for League Pass. There are free streams on the web, but they are poor quality and it is just too much stuffing around to find a passably good one. League Pass isn't super cheap, but if you like NBA basketball and have the time to watch 3-4 games per week, I reckon its totally worth it.
BTW, if you have a decent connection at home, you can still sign up for tomorrow's game plus the NBA finals for about $20-30.
There's the Rosemont in Hindley St. They'll definitely be open and will have decent screens and sound.
Weekdays I have been watching NBA playoff games at the Hope Inn (cnr Port and Sth rds). Ridiculously cheap front bar specials too! Not sure how early they open on Sundays though. Might be okay but I'd call to make sure if you try there or another suburban pub.
Need to get yourself a decent internet connection though Quag. Nothing beats watching from the comfort of your own home!