103
edits
Support/Interesting queries: Difference between revisions
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%'; | ||
==Thread statuses per week== | |||
Open/locked/solved threads per week. | |||
SELECT YEARWEEK(FROM_UNIXTIME(commentDate),7) d, type, COUNT(*) c FROM tiki_comments WHERE objectType = 'forum' AND parentId = 0 GROUP BY d, type ORDER BY d; | |||