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;
103

edits

Navigation menu