--- modr8.orig/modr8.module	2006-12-25 22:24:02.000000000 +0100
+++ modr8/modr8.module	2007-01-05 20:30:51.000000000 +0100
@@ -180,7 +180,7 @@
   elseif ($op == 'view') {
     if (user_access('moderate content')){
       $block['subject'] = t('moderation queue');
-      $count = db_result(db_query(db_rewrite_sql('SELECT COUNT(*) FROM {node} n WHERE n.status = 1 AND n.moderate = 1 ORDER BY n.changed DESC')));
+      $count = db_result(db_query(db_rewrite_sql('SELECT COUNT(*) FROM {node} n WHERE n.status = 1 AND n.moderate = 1')));
       $sql = db_rewrite_sql('SELECT n.nid, n.title FROM {node} n WHERE n.status = 1 AND n.moderate = 1 ORDER BY n.changed DESC');
       $result = db_query_range($sql,0,6);
       $content = '<p>'. l(t('@items in moderation',array('@items' => format_plural($count, '1 post', '@count posts'))),'admin/content/modr8'). '</p>';