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(2984)
}
}
Is there anywhere to check standings and who is in the finals tonight and tommorrow? Is any of this information on the web, or can someone post the standings?.?.
The Finals Draw - As of Friday night (its bound to change, if it hasn't already is...)
UNDER 18 BOYS STATE
SF1 15th 19:15 Wayv 1 1A V 2B
SF2 15th 19:15 Wayv 2 1B V 2A
3/4 16th 11:30 Pasa 2 2 SF1 V 2 SF2 GF 16th 12:00 Dome 2 1 SF1 V 1 SF2
UNDER 18 GIRLS STATE
SF1 15th 17:00 Dome 3 1A Vs 2B
SF2 15th 18:15 Dome 3 1B Vs 2A
3/4 16th 11:30 Pasa 1 2 SF1 V 2 SF2
GF 16th 12:00 Dome 1 1 SF1 V 1 SF2
UNDER 16 BOYS STATE
SF1 15th 18:00 Wayv 1 1A Vs 2B
SF2 15th 18:00 Wayv 2 1B Vs 2A
3/4 16th 10:15 Pasa 1 2 SF1 V 2 SF2
GF 16th 10:45 Dome 1 1 SF1 Vs 1 SF2
UNDER 16 GIRLS STATE
SF2 15th 16:00 Dome 2 1B Vs 2A
SF1 15th 16:30 Dome 1 1A Vs 2B
3/4 16th 10:15 Pasa 2 2 SF1 Vs 2 SF2
GF 16th 10:45 Dome 2 1 SF1 Vs 1 SF2
These will be the main games i suppose. Sorry about the cryptic formatting.