[Phpgroupware-cvs] [18579] fix: sql for list_all_versions in a project

[Pascal Vilarem]

Revision: 18579
          
http://svn.sv.gnu.org/viewvc/?view=rev&root=phpgroupware&revision=18579
Author:   maat
Date:     2008-06-02 10:09:52 +0000 (Mon, 02 Jun 2008)

Log Message:
-----------
fix: sql for list_all_versions in a project

Modified Paths:
--------------
    trunk/ged/inc/class.ged_dm.inc.php

Modified: trunk/ged/inc/class.ged_dm.inc.php
===================================================================
--- trunk/ged/inc/class.ged_dm.inc.php  2008-06-02 09:57:50 UTC (rev 18578)
+++ trunk/ged/inc/class.ged_dm.inc.php  2008-06-02 10:09:52 UTC (rev 18579)
@@ -3463,9 +3463,9 @@
                $sql="SELECT *, ged_elements.description edescription, 
ged_versions.description vdescription, ";
                $sql.="ged_versions.creation_date vcreation_date, 
ged_elements.creator_id ecreator_id ";
                $sql.="FROM ( ged_elements ";
-               $sql.="JOIN ged_versions On ( ged_elements.element_id = 
ged_versions.element_id) ";
-               $sql.="LEFT JOIN ged_doc_types ON 
ged_elements.project_root=".(int)$project_root_id." ";
-               $sql.="AND ged_elements.doc_type = ged_doc_types.type_id ) ";
+               $sql.="JOIN ged_versions On ( ged_elements.element_id = 
ged_versions.element_id " .
+               $sql.="AND ged_elements.project_root=".(int)$project_root_id." 
) ";
+               $sql.="LEFT JOIN ged_doc_types ON ged_elements.doc_type = 
ged_doc_types.type_id ) ";
                $sql.="ORDER BY ged_elements.doc_type, 
ged_elements.creation_date";
                
                $this->db->query($sql, __LINE__, __FILE__);