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(33785)
}
}
In terms of the original "issue". I think you'll find most sensible senior coaches during the summer season group their players into:
Definite Div 1
Div 1 bench/Div 2 starter
Definite Div 2
Div 2 bench/Div 3
etc etc
During the summer season they setup a rotation with the "Div 1 bench/Div 2 starter" group so that they can refine their squads for winter season. As a player if you are doing well in Div 2, why would you not expect to be rewarded with a run in Div 1? On a complete fool of a coach would promise to give players in that group a run in a higher div and not honour that promise.
I think you'll find that as part of the natural rotation process some players were rotated down to give some others a go in a higher div and your team were the "unlucky" ones to face them during that period.