From 812ae4a40541097c77f773f3ae61fae1ac0b4df3 Mon Sep 17 00:00:00 2001 From: vargenau Date: Fri, 6 Mar 2015 11:52:49 +0000 Subject: [PATCH] Add AS in SQL git-svn-id: svn://svn.code.sf.net/p/phpwiki/code/trunk@9615 96ab9672-09ca-45d6-a79d-3d69d39ca109 --- lib/WikiDB/backend/PearDB_ffpgsql.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/lib/WikiDB/backend/PearDB_ffpgsql.php b/lib/WikiDB/backend/PearDB_ffpgsql.php index 37fbf5b8a..d6436c83f 100644 --- a/lib/WikiDB/backend/PearDB_ffpgsql.php +++ b/lib/WikiDB/backend/PearDB_ffpgsql.php @@ -555,9 +555,9 @@ class WikiDB_backend_PearDB_ffpgsql if ($exclude) // array of pagenames $exclude = " AND p.pagename NOT IN " . $this->_sql_set($exclude); $sql = "SELECT substring(p.pagename from $p) AS wantedfrom, substring(pp.pagename from $p) AS pagename" - . " FROM $page_tbl p, $link_tbl linked" - . " LEFT JOIN $page_tbl pp ON linked.linkto = pp.id" - . " LEFT JOIN $nonempty_tbl ne ON linked.linkto = ne.id" + . " FROM $page_tbl AS p, $link_tbl AS linked" + . " LEFT JOIN $page_tbl AS pp ON linked.linkto = pp.id" + . " LEFT JOIN $nonempty_tbl AS ne ON linked.linkto = ne.id" . " WHERE ne.id IS NULL" . " AND p.id = linked.linkfrom" . " AND substring(p.pagename from 0 for $p) = '$page_prefix'" -- 2.45.0