Hoops

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(37197) } }