Support/Interesting queries
< Support
Jump to navigation
Jump to search
Threads per day
The number of threads (questions) posted each day.
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;