103
edits
Support/Interesting queries: Difference between revisions
Jump to navigation
Jump to search
no edit summary
(New page: ==Threads per day== The number of threads posted each day. SELECT DATE(FROM_UNIXTIME(commentDate)) d, COUNT(*) c FROM tiki_comments WHERE parentId = 0 GROUP BY d ORDER BY d;) |
No edit summary |
||
| Line 1: | Line 1: | ||
==Threads per day== | ==Threads per day== | ||
The number of threads posted each day. | The number of threads (questions) posted each day. | ||
SELECT DATE(FROM_UNIXTIME(commentDate)) d, COUNT(*) c FROM tiki_comments WHERE parentId = 0 GROUP BY d ORDER BY d; | SELECT DATE(FROM_UNIXTIME(commentDate)) d, COUNT(*) c FROM tiki_comments WHERE parentId = 0 AND objectType = 'forum' GROUP BY d ORDER BY d; | ||
==Replies per day== | |||
The number of posts (questions and replies) posted each day. | |||
SELECT DATE(FROM_UNIXTIME(commentDate)) d, COUNT(*) c FROM tiki_comments WHERE objectType = 'forum' GROUP BY d ORDER BY d; | |||