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(682)
}
}
Anonymous
Years ago
Favourite ref hand signals
Nah nah nah... your all right but there are too many to choose... the best are definatly in pressure situations and you can tell the refs that love their basket ball!
1. Offensive foul, waves away basket, post player hooking signal, back to offensive position
2. 1 second left to go, offensive team down by 2 with a player driving at the basket one on one, defender steps across, ball goes up, time expires, ref on baseline holds off slightly few short blows of the whistle, its a foul, block, 2 are good and one to come....:P i love it
3. The big wind up quater court down on one knee charge call that not even the fat guy in the back row would possibly argue just because it looks so good.
All referees should take acting classes, even tho we might not think they make the right call, at least entertain us, Hollywood style.