bug #3510784 [edit] Limit clause ignored when sort order is remembered

1 files changed, 1 insertions, 1 deletions

diff --git a/sql.php b/sql.php
index 42d72caae2..cccd308453 100644
--- a/sql.php
+++ b/sql.php
@@ -435,7 +435,7 @@ if ($GLOBALS['cfg']['RememberSorting']
             // retrieve the remembered sorting order for current table
             $sql_order_to_append = ' ORDER BY ' . $sorted_col . ' ';
             $full_sql_query = $analyzed_sql[0]['section_before_limit'] . $sql_order_to_append
-                . $analyzed_sql[0]['section_after_limit'];
+                . $analyzed_sql[0]['limit_clause'] . ' ' . $analyzed_sql[0]['section_after_limit'];
 
             // update the $analyzed_sql
             $analyzed_sql[0]['section_before_limit'] .= $sql_order_to_append;