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(7660)
}
}
John!!! ref bashing even in a soccer thread... i'll leave that one alone.
Sorry DJ but i can't see you getting too much support on that one being a basketball site. And i have never seen a basketball game where a player takes a charge and is pretending to be injured, yes players flop, but when you scout basketball players there is no stat column of "years in acting school" (I am pretty sure i saw that on a soccer scouting site, but don't quote me).
The biggest problem with soccer is that there is still the problem that a lot of nations still think that the sport should be only played in their domain... countries like Australia should go back home and do something else... which was proven beyond a shadow of any doubt by the refereeing in the Australia - Brazil match... if the German ref who controlled that match gets the final, then the final will be a joke.