SELECT moderationStatus, COUNT(1) FROM data_mediagallery WHERE vhost = 1147 AND STATUS=3 GROUP BY moderationStatus;
+------------------+----------+
| moderationStatus | COUNT(1) |
+------------------+----------+
|                0 |      128 |
|                1 |  1468252 |
|                2 |    48547 |
|                3 |        2 |
|                4 |      493 |
|                5 |      134 |
|                6 |       95 |
|               10 |       69 |
|               14 |      242 |
+------------------+----------+