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(27218)
}
}
If we take out metro courts, what are the best courts that you have played on?
Mine are:
1. Millicent. No bias, the stadium is right up there with the Metro courts. I think better then Wayville easily.
2. Mt Gambier. Good show court, but the back courts need improvment at the Icehouse. Not good to play at in the heat.
3. Naracoorte. Not good at all. Better then Murray Bridge though.
4. Murray Bridge. They suck. Bring ice skates if you ever play here. Bad lighting.