Support/Interesting queries: Difference between revisions

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;