Skip to content

Instantly share code, notes, and snippets.

@charly24

charly24/gist:5942567

Created July 7, 2013 06:37
Show Gist options
  • Save charly24/5942567 to your computer and use it in GitHub Desktop.
Save charly24/5942567 to your computer and use it in GitHub Desktop.
Download ZIP
WordPressの新規登録者数の推移表示
Raw
gistfile1.sql
select registered_date, count(*) as registered_cnt from (
select (YEAR(user_registered) * 10000 + MONTH(user_registered) * 100 + DAY(user_registered)) as registered_date from wp_users) as tmp
group by registered_date
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment