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(32347)
}
}
As long as there are:
> no more long term non reviewed positions
>all appointments are employed on quality outcomes which are based on performance indexes
>this state doesn't get a quasi one club mentality excluding players/coaches that are not top of the table clubs
>there is a panel to review and make these changes happen if success is not achieved
> flushing of current admin ,this State needs an injection of improvement from stadiums to State Team results
>increase and maintain standard of Umpiring
>lift the media profile of the game
Would love to know more about this as this was certainly done quietly.
Who instigated it?
How high up the food chain it come from?
Where is the payment coming from?
This job needs to be contract based. Not once in always in.
Inclusive of performance bonuses. Teams perform well in either SAM or SAC a bonus is added.
Time to get this job right and make sure it suits all parties involved.