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(33893)
}
}
C. Bruton G
C. Frank F
C. Steindl F
D. McCamey G
D. U'u G
K. Tiggs G/F
K. White G
M. Djeric G
M. Farrakhan G
M. Norton G
O. Odigie G/F
R. Carter G
R. Hinder F/C
R. Te Rangi F
S. Bruce G
S. Harris-Tunks C
T. Demos G
T. Greer F
These should be it, except DPs... If there's anyone I missed they're probably not worth picking anyways ;)
Does anyone else agree that this years trade week has been ridiculously stupid! Only 2 deals so far and one was a father-son rule, i know teams want to hold their picks because of the new teams coming in but surely there will be more than 2 deals in the only opportunity for teams to deal all year!
Luckily the mighty Reds have given me something else to enjoy this last week.
3-0, 3-0, 3-0 3-0. 3-0. 3-0
We ogt 3 and the got none do da do da!