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.

    $sql = "SELECT DISTINCT u.uid,, 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,
      ORDER BY numitems DESC,";
# Line 169 site_map.module
-    $result = db_query_range($sql, 0, 10);
+    $result = db_query_range(db_rewrite_sql($sql), 0, 10);