Support/Interesting queries

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;