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(6811)
}
}
Advertising the game would be better at the Entertainment Centre. By having permanent posters up, it would be viewed by everyone going there regardless of what they are going to see. Basketball would be exposed to people who normally would know nothing about it. It may even tempt them to try and see a game.
Um I think you will find that the court is much larger than a wrestling ring and that that flat seating is the floor in which the court would be placed :-)
Entertainment Centre has been considered for many years and at least twice that I know of was oh so close to happening only last minute decissions (saviour's) saw the sixers remain at the dome.
Maybe the Dome will be converted to a new indoor swimming centre- it certainly has potential for that - and carparking too, water side pools outdoors etc.