Olympics Analysis

RSS
It's not just the athletes who need medals It's not just the athletes who need medals

New Zealand could do with some Olympic cheer, starting overnight.

Revealed: NZs Rio Olympic medal winners

The Herald has employed a complex system of statistics, rumour and hunches to compile a list of medal…

Williamson's quest for best series ever

In today's Midweek Fixture, Dylan Cleaver looks at the chances of Kane Williamson producing the greatest…

query
RESULTSET
query
  ANSWER AV_VALUE DISPLAY_ORDER MAX_RANGE MIN_RANGE PERCENTAGE QNA_ANSWERS_ID REAL REMAINDER VOTES
1 Yes [empty string] 10 10 0 42 17696 41.91 0.911764705882 57
2 No [empty string] 11 10 0 58 17697 58.09 0.0882352941177 79
CACHED false
EXECUTIONTIME 22
SQL SELECT qa.qna_answers_id, qa.answer, count(qna_results_id) as votes, avg(qr.value) as av_value, qa.min_range, qa.max_range, qa.display_order FROM qna_answers qa LEFT OUTER JOIN qna_results qr on qa.qna_answers_id = qr.qna_answers_id WHERE qa.qna_questions_id = ? AND qa.active = 'y' GROUP BY qa.qna_answers_id, qa.answer ORDER BY qa.display_order ASC
SQLPARAMETERS
array
1 4887
NZ Herald Poll

© Copyright 2016, NZME. Publishing Limited

Assembled by: (static) on production bpcf05 at 30 Sep 2016 13:47:08 Processing Time: 1490ms