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(37210)
}
}
Anonymous
Years ago
classics final positions
Final results are
Boys
12 Bulleen beat McKinnon
14 Melbourne beat Sturt
16 Sth Peninsula beat Dandenong
18 Eltham beat Melbourne
If you know the results great but an outsider would have no idea whats what ,check last days play. Can you really easily know what position everyone played for ?
http://www.sportingpulse.com/comp_info.cgi?client=4-5008-0-370263-0&pool=1005&action=ROUND&round=0
Next day this is typical of the web page, only 1 game played ? Dont think so :
http://www.sportingpulse.com/comp_info.cgi?a=LADDER&client=4-5008-0-370263-0&pool=5
Hey understand your frustration .The finals menu could only be decified ( by what i found ) if you had the classics booklet and read the timetable ,knew the finals layout ,the court time and what finals position they played for by filling it in from matches played LOL .The Sporting pulse didnt cough-up any ready info for finals layout