> select count(*), oi_deleted FROM oldimage GROUP by oi_deleted; +----------+------------+ | count(*) | oi_deleted | +----------+------------+ | 39295 | 0 | | 399400 | 1 | | 3 | 2 | | 1 | 3 | | 1 | 4 | | 3 | 7 | | 8 | 9 | | 3 | 10 | | 1 | 11 | +----------+------------+ 9 rows in set (1.231 sec)