[phpwiki-checkins] SF.net SVN: phpwiki:[9615] trunk/lib/WikiDB/backend/PearDB_ffpgsql.php

[<var...@us...>]

Revision: 9615
          http://sourceforge.net/p/phpwiki/code/9615
Author:   vargenau
Date:     2015-03-06 11:52:49 +0000 (Fri, 06 Mar 2015)
Log Message:
-----------
Add AS in SQL

Modified Paths:
--------------
    trunk/lib/WikiDB/backend/PearDB_ffpgsql.php

Modified: trunk/lib/WikiDB/backend/PearDB_ffpgsql.php
===================================================================
--- trunk/lib/WikiDB/backend/PearDB_ffpgsql.php	2015-03-06 11:27:36 UTC (rev 9614)
+++ trunk/lib/WikiDB/backend/PearDB_ffpgsql.php	2015-03-06 11:52:49 UTC (rev 9615)
@@ -555,9 +555,9 @@
         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'"

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.