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(7855)
}
}
I notified the club on Friday afternoon that I had commitments of a work-related nature, and the club fully understood that if I have to work, then the employment is more important than the announcing, even more so since I cannot referee until the end of August (shin splints and stress fractures - both legs), and appreciated that I gave them ample notice, instead of leaving the Warriors in the lurch. I have told the club that if there are any more nights where I will be working on a game night, I will notify them again with plenty of ample notice. That is fair, isn't it, "BodyByJake"?
actually, earning $23+ per hour for 6 hours is beter than earning $20 for 4 hours and some change... so didn't hurt one cent, (Mod: Deleted. (a) I wouldn't be crowing about $23/hour. (b) wash your mouth out.)!!