mysql> select entry_blog_id, count(1) from mt_entry where entry_id in  (SELECT entry_meta_entry_id FROM mt_entry_meta WHERE entry_meta_type = 'impersonated_modified_on') and entry_created_on > CURDATE() group by entry_blog_id;

+---------------+----------+
| entry_blog_id | count(1) |
+---------------+----------+
|           857 |        1 |
|          1366 |       80 |
|          1505 |        3 |
|          1707 |       39 |
|          1720 |       38 |
|          2317 |        1 |
|          2529 |        1 |
|          2553 |        2 |
|          2926 |        1 |
|          3405 |        1 |
|          3555 |        1 |
|          3606 |        3 |
|          3836 |       21 |
|          3866 |        1 |
|          3965 |        1 |
|          3972 |        3 |
|          3985 |       50 |
|          4001 |       26 |
|          4002 |        1 |
|          4005 |        1 |
|          4007 |        2 |
|          4335 |        8 |
|          4363 |        4 |
|          4376 |        5 |
|          4422 |      155 |
|          4450 |        2 |
|          4474 |        1 |
|          4501 |       10 |
|          4540 |        3 |
|          4550 |        1 |
|          4726 |       18 |
|          4743 |        2 |
|          4744 |        2 |
|          4745 |        2 |
|          4746 |        2 |
|          4747 |        2 |
|          4748 |        3 |
|          4749 |        3 |
|          4750 |        2 |
|          4751 |        3 |
|          4752 |        3 |
|          4755 |        3 |
|          4788 |        2 |
|          4799 |      209 |
|          4806 |       18 |
|          4807 |      343 |
|          4808 |      559 |
|          4909 |      419 |
|          4916 |        1 |
|          5005 |        6 |
|          5049 |        1 |
|          5141 |        3 |
|          5142 |        2 |
|          5150 |        3 |
|          5173 |        2 |
|          5178 |        3 |
|          5209 |        3 |
|          5210 |        2 |
|          5211 |        3 |
|          5212 |        3 |
|          5217 |       17 |
|          5223 |        3 |
|          5287 |        5 |
|          5414 |       14 |
|          5492 |        1 |
|          5493 |        6 |
|          5542 |        5 |
|          5546 |        7 |
|          5582 |       45 |
|          5615 |       14 |
|          5654 |        3 |
|          5671 |       48 |
|          5700 |       24 |
|          5701 |      419 |
|       8000030 |       17 |
|       8000248 |        5 |
|       8000289 |     1459 |
|       8000317 |      202 |
+---------------+----------+
78 rows in set (1.69 sec)