Skip to content

Instantly share code, notes, and snippets.

@mattkomarnicki

mattkomarnicki/phpbb_posts_per_month.sql

Last active October 23, 2019 11:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mattkomarnicki/90d964ffd570022597549a402fefabb9 to your computer and use it in GitHub Desktop.
Save mattkomarnicki/90d964ffd570022597549a402fefabb9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
phpbb_posts_per_month.sql
SELECT YEAR(FROM_UNIXTIME(post_time)) as `year`, LPAD(MONTH(FROM_UNIXTIME(post_time)), 2, 0) as `month`, COUNT(post_id) as count FROM phpbb3_posts
GROUP BY `year`, `month`
ORDER BY `year`, `month` ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment