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

Anonymous
Years ago
Most popular sport leagues in each state? ( AUS )
Being from QLD, i would say
1. NRL
2. V8 Supercars
3. Rugby Union
4. AFL
5. BBL
6. A-League
7. NBL
V8's have 3 rounds in QLD, willowbank, Townsville and Gold coast, ave crowds per day at each event is about 30-50k, i think 5 teams are from here (888, SBR, DJR, PMM and Tekno) and QLD'ers are natural rev heads


Anonymous
Years ago
i was suprised to see nbl infront of NRL in SA, here in n.sw NRL is easily the biggest

Anonymous
Years ago
Heard a rumour down here that new Pioneers import Josh Steinthal is no longer coming to Mount Gambier? Huge loss if it is true so close to the start of the season.
Leaves only Craig Stratford as a point guard for this season. Only 6 contracted players.
