Index: branches/2.8.x/CHANGELOG
===================================================================
--- branches/2.8.x/CHANGELOG	(revision 1345)
+++ branches/2.8.x/CHANGELOG	(revision 1346)
@@ -11,7 +11,9 @@
 ! = Update/Change
 
 ------------------------------------- 2.8.1 -------------------------------------
-11-May-2010 Dietmar Woellbrink (Luisehahne)
+12-May-2010 Dietmar Woellbrink (Luisehahne)
+#	Ticket #999 wrong sql statement in admin/pages/index.php (Tks to Lucutus)
+12-May-2010 Dietmar Woellbrink (Luisehahne)
 -	remove unneeded flags in backend themes
 -	remove admin/images
 11-May-2010 Dietmar Woellbrink (Luisehahne)
Index: branches/2.8.x/wb/admin/pages/index.php
===================================================================
--- branches/2.8.x/wb/admin/pages/index.php	(revision 1345)
+++ branches/2.8.x/wb/admin/pages/index.php	(revision 1346)
@@ -36,9 +36,9 @@
 	// $database = new database();
 
 	// Get page list from database
-    $sql = 'SELECT * FROM `'.TABLE_PREFIX.'pages` WHERE `parent` = '.$parent;
-    $sql .= (PAGE_TRASH != 'inline') ?  ' AND `visibility` != "deleted"' : '';
-    $sql .= ' ORDER BY `position` ASC';
+    $sql = 'SELECT * FROM `'.TABLE_PREFIX.'pages` WHERE `parent` = '.$parent.' ';
+    $sql .= (PAGE_TRASH != 'inline') ?  'AND `visibility` != \'deleted\' ' : ' ';
+    $sql .= 'ORDER BY `position` ASC';
 	$get_pages = $database->query($sql);
 /*
 	if(PAGE_TRASH != 'inline')
@@ -88,8 +88,8 @@
 				}
 			}
 			// Work out if we should show a plus or not
-            $sql = 'SELECT `page_id`,`admin_groups`,`admin_users` FROM `'.TABLE_PREFIX.'pages` WHERE `parent` = '.$page['page_id'];
-            $sql .= (PAGE_TRASH != 'inline') ?  ' AND `visibility` != "deleted"' : '';
+            $sql = 'SELECT `page_id`,`admin_groups`,`admin_users` FROM `'.TABLE_PREFIX.'pages` WHERE `parent` = '.$page['page_id'].' ';
+            $sql .= (PAGE_TRASH != 'inline') ?  'AND `visibility` != \'deleted\' ' : ' ';
             // $sql .= ' ORDER BY `position` ASC';
         	$get_page_subs = $database->query($sql);
 /*
@@ -193,8 +193,8 @@
 				if(MANAGE_SECTIONS == 'enabled' && $admin->get_permission('pages_modify')==true && $can_modify==true)
                 {
 
-                    $sql = 'SELECT `publ_start`, `publ_end` FROM `'.TABLE_PREFIX.'sections`';
-                    $sql .= ' WHERE `page_id` = '.$page['page_id'].' AND `module` != "menu_link"';
+                    $sql = 'SELECT `publ_start`, `publ_end` FROM `'.TABLE_PREFIX.'sections` ';
+                    $sql .= 'WHERE `page_id` = '.$page['page_id'].' AND `module` != \'menu_link\' ';
                     $query_sections = $database->query($sql);
 
 					// $query_sections = $database->query("SELECT publ_start, publ_end FROM ".TABLE_PREFIX."sections WHERE page_id = '{$page['page_id']}' AND module != 'menu_link'");
Index: branches/2.8.x/wb/admin/interface/version.php
===================================================================
--- branches/2.8.x/wb/admin/interface/version.php	(revision 1345)
+++ branches/2.8.x/wb/admin/interface/version.php	(revision 1346)
@@ -52,6 +52,6 @@
 
 // check if defined to avoid errors during installation (redirect to admin panel fails if PHP error/warnings are enabled)
 if(!defined('VERSION')) define('VERSION', '2.8.x');
-if(!defined('REVISION')) define('REVISION', '1345');
+if(!defined('REVISION')) define('REVISION', '1346');
 
 ?>
\ No newline at end of file