1 2 3 4 | SELECT count(*), MONTH(post_date), DAY(post_date) FROM `wp_posts` WHERE post_type='post' GROUP BY `MONTH(post_date)`,`DAY(post_date)` ORDER BY `count(*)` DESC |
1 2 3 4 | SELECT count(*), MONTH(post_date), DAY(post_date) FROM `wp_posts` WHERE post_type='post' GROUP BY `MONTH(post_date)`,`DAY(post_date)` ORDER BY `count(*)` DESC |