Hoops

Start a new topic

Choose the category that best suits your topic.

Check this if your topic contains a game spoiler (e.g., an NBA game that might be televised later).

Check this if your topic is spam.

You must read the Terms of Use. Please do not post offensive material.
Learn how to embed YouTube videos or tweets

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

Isaac

Years ago

NBL ladder and stats

The stats only change a few times a week, and only impact a few dozen rows, I'd guess. Could you periodically (4am daily) abstract some of the calculations to other columns rows to handle common queries?

What route do you use to isolate player stats for a particular team's roster? At the moment I deselect all teams, then select the team I want. Is there a way to just get the team without unchecking all others or deselecting all first? Obviously if you uncheck unwanted teams one-by-one, it re-queries each time.

Reply #669507 Report this topic

Anonymous

Years ago

Thanks guys 2 great sites much appreciated

Reply #669363 Report this topic

Isaac

Years ago

Not sure about the ladder, but the best option for stats is Spatial Jam. The interface can be a bit sluggish, but it's got loads of great options including some advanced and career stuff the NBL have failed to provide for many years now.

Reply #669328 Report this topic

Anonymous

Years ago

Are they handing out tech fouls for flopping this year i saw at least 6/7 flops in tonight game between the waves and the lightning and another one or two in the perth and 36ers game all called with a charge by our brilliant SA referees (in the women's game) and i was just curious what was the direction this year.

Reply #855179 Report this topic

Start a new topic

NBL ladder and stats

Reply to this topic

Recent Posts