This is needed to ensure that the module does not show access controlled content. I was actually surprised that the Domain Access rewrite worked with the aggregate SQL, but it did.

<?php
    $sql
= "SELECT DISTINCT u.uid, u.name, count(u.uid) AS numitems
      FROM {node} n
      INNER JOIN {users} u ON u.uid = n.uid
      WHERE n.type = 'blog' AND n.status = 1
      GROUP BY u.uid, u.name
      ORDER BY numitems DESC, u.name"
;
# Line 169 site_map.module
-    $result = db_query_range($sql, 0, 10);
+   
$result = db_query_range(db_rewrite_sql($sql), 0, 10);
?>