103
edits
Support/Interesting queries: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| Line 22: | Line 22: | ||
==Poll results== | ==Poll results== | ||
SELECT * FROM tiki_poll_options tpo INNER JOIN tiki_poll_votes tpv on tpo.optionId = tpv.optionId INNER JOIN tiki_polls tp on tpo.pollId = tp.pollId WHERE tp.title LIKE '%smart%'; | SELECT * FROM tiki_poll_options tpo INNER JOIN tiki_poll_votes tpv on tpo.optionId = tpv.optionId INNER JOIN tiki_polls tp on tpo.pollId = tp.pollId WHERE tp.title LIKE '%smart%'; | ||
==Poll result summary== | |||
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; | |||
0 - Solved problem | |||
1 - Did not solve problem | |||
10 - Easy to understand | |||
11 - Not easy to understand | |||
==Thread statuses per week== | ==Thread statuses per week== | ||