Olympics Analysis

RSS
Williamson's quest for best series ever Williamson's quest for best series ever

In today's Midweek Fixture, Dylan Cleaver looks at the chances of Kane Williamson producing the greatest batting performance in a test series and the looming battle between the men's Black Sticks and High Performance Sport…

NZOC satisfied with Olympic programme as wrestling faces the chop

The New Zealand Olympic Committee is satisfied all major New Zealand Olympic sports have secured their…

Troy Rawhiti-Forbes: Grand effort as London delivers on its promises

Remove the bunting, pull down the signs, and shut off the lights. The Olympic Games are over. The biggest…

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 19
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 29 Jul 2016 04:48:54 Processing Time: 1043ms