fossala wrote:Looks good. I wonder how many of them 469 came, got their answer then left.
Code: Select all
mysql> SELECT count(*) FROM `phpbb_users` WHERE user_lastpost_time > unix_timestamp(subdate(now(), interval 31 day)) and user_posts = 1;
+----------+
| count(*) |
+----------+
| 39 |
+----------+
1 row in set (0.02 sec)