mysql> select recstatus, count(*) from oldrecorded group by recstatus;
+-----------+----------+
| recstatus | count(*) |
+-----------+----------+
|        -9 |        9 |
|        -4 |        9 |
|        -3 |    43079 |
|         2 |      328 |
|         4 |        4 |
|         6 |       12 |
|         7 |       37 |
|         8 |      104 |
|        11 |        2 |
+-----------+----------+
9 rows in set (0.02 sec)