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(25647)
}
}
Yeh get on League Pass if you can afford to. Best purchse ever. First year I got it and I have not had a single bad experience....except for the girlfriend bitching at me for loving basketball more than quality time with her...
Kriss, jump on the NBA website, it has a clear link to pricing. I assume it will be around $30US for the final series only. From memory the Regular season was around $140US. Totally worth it.
Baller#3, if you have 20 gigs max a month then you will hit your limit using League Pass quite easily. Last I checked, a game usually sucks down around 2-3 gig. So, with other downloads, after say five or six games you might hit your limit and then you might struggle while your service is shaped. But some would say 5-6 games per month is fine. Depends on what you need for your fix!