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(38695)
}
}
The Sydney Salary bonus was also along the lines of building up a strong team in Sydney so as to have a team that could bring in a lot of new supporters quickly.
Ugly Igley is right on: The Wildcats actually do have a house they normally use to house imports/others. I think its somewhere in City Beach .. or was back in the mid 00's.
Generally though a lot of the imports /newer places will live together or with the family of one of the other players.
"They may also live in a spare room/house of a club supporter/minder?"
Many, many years ago I lived in Canberra for a short time. When I mentioned my interest in basketball to my landlord, he told me the house next door was owned by Phil Smyth, who at that time was playing for the Cannons. When I moved in my neighbour was Rookie of the Year Lachlan Armfield, when I moved out six months later he had been replaced by the Cannons' new import, Rodney Monroe.
I wouldn't be surprised if the larger clubs owns the property (particularly Jack Bendat) and the club gives the player the use of the property during the season.