103
edits
Support/Interesting queries: Difference between revisions
Jump to navigation
Jump to search
→Poll result summary
No edit summary |
|||
| Line 25: | Line 25: | ||
==Poll result summary== | ==Poll result summary== | ||
Weekly: | Weekly: | ||
SELECT YEARWEEK(voteDate, 3), position, SUM(voteCount) votes FROM tiki_poll_votes tpv INNER JOIN tiki_poll_options tpo ON tpo.optionId = tpv.optionId GROUP BY voteDate, position ORDER BY voteDate, position; | SELECT YEARWEEK(voteDate, 3), position, SUM(voteCount) votes FROM tiki_poll_votes tpv INNER JOIN tiki_poll_options tpo ON tpo.optionId = tpv.optionId GROUP BY YEARWEEK(voteDate, 3), position ORDER BY voteDate, position; | ||
*0 - Solved problem | *0 - Solved problem | ||