plugins/SpecialRecentChanges.php
changeset 414 818b4cd12b8b
parent 411 d1a95497b68f
child 430 ec90736b9cb9
--- a/plugins/SpecialRecentChanges.php	Tue Feb 12 00:37:46 2008 -0500
+++ b/plugins/SpecialRecentChanges.php	Tue Feb 12 00:42:29 2008 -0500
@@ -73,8 +73,9 @@
     l1.time_id AS currev_time, l2.time_id AS oldrev_time
   FROM ' . table_prefix . 'logs AS l1
   LEFT JOIN ' . table_prefix . 'logs AS l2                                                    
-    ON ( l1.log_type = l2.log_type AND l1.action = \'edit\' AND l1.action = l2.action AND l2.time_id < l1.time_id AND l1.page_id = l2.page_id AND l1.namespace = l2.namespace )
+    ON ( l1.log_type = l2.log_type AND l1.action = \'edit\' AND l1.action = l2.action AND l2.time_id < l1.time_id AND l1.page_id = l2.page_id AND l1.namespace = l2.namespace AND l2.is_draft != 1 )
   WHERE l2.time_id IS NOT NULL' . $where_extra . '
+        AND l1.is_draft != 1
   GROUP BY oldrev_time
   ORDER BY l1.time_id DESC, l2.time_id DESC;';
   }