Index: branches/dev/data/class/SC_SelectSql.php
===================================================================
--- branches/dev/data/class/SC_SelectSql.php	(revision 226)
+++ branches/dev/data/class/SC_SelectSql.php	(revision 11917)
@@ -32,9 +32,10 @@
 						
 		// $mode == 1 ¤Ï limit & offsetÌµ¤·						
-		if ( $mode != 1 ){
+		if ($mode == 2) {
+			$this->sql .= $this->order;
+		}elseif ( $mode != 1 ){
 			$this->sql .= $this->order . " " .$this->limit ." ". $this->offset;	
-		} elseif ($mode == 2) {
-			$this->sql .= $this->order;
-		}
+		}
+
 		return $this->sql;	
 	}
