103
edits
Support/Interesting queries: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| Line 24: | Line 24: | ||
==Thread statuses per week== | ==Thread statuses per week== | ||
Open/locked/solved threads per week. | Open/locked/solved threads per week. Week year then number of week (hopefully matches Ubuntu's calendar) | ||
SELECT YEARWEEK(FROM_UNIXTIME(commentDate), | SELECT YEARWEEK(FROM_UNIXTIME(commentDate),3) d, type, COUNT(*) c FROM tiki_comments WHERE objectType = 'forum' AND parentId = 0 GROUP BY d, type ORDER BY d; | ||