By gerhard killesreiter on
mysql> select count(login) from users where login > 0 and from_unixtime(login) > '2008-08-01 00:00:00' and status = 0 ;
+--------------+
| count(login) |
+--------------+
| 450 |
+--------------+
The query gives us the number of users who logged in during August and are now blocked.
