Olympics Photos

RSS
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 294
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 apcf03 at 02 Jul 2016 23:09:29 Processing Time: 890ms