diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2013-08-19 10:30:23 +0200 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2013-09-26 01:14:33 +0200 |
| commit | eace91af203e21fa82d054d42fc2117fa1230763 (patch) | |
| tree | 9a4974b58e090d9b90c725c822cc80b654484e49 | |
| parent | e7c43dbb6796d75445b50b0062d6e32cf650b3cd (diff) | |
| download | forums-eace91af203e21fa82d054d42fc2117fa1230763.tar forums-eace91af203e21fa82d054d42fc2117fa1230763.tar.gz forums-eace91af203e21fa82d054d42fc2117fa1230763.tar.bz2 forums-eace91af203e21fa82d054d42fc2117fa1230763.tar.xz forums-eace91af203e21fa82d054d42fc2117fa1230763.zip | |
[ticket/11691] Add order by to the query
PHPBB3-11691
| -rw-r--r-- | phpBB/phpbb/db/migration/data/v310/softdelete_p1.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/phpBB/phpbb/db/migration/data/v310/softdelete_p1.php b/phpBB/phpbb/db/migration/data/v310/softdelete_p1.php index a93171d931..14bd5f52fb 100644 --- a/phpBB/phpbb/db/migration/data/v310/softdelete_p1.php +++ b/phpBB/phpbb/db/migration/data/v310/softdelete_p1.php @@ -151,7 +151,8 @@ class softdelete_p1 extends \phpbb\db\migration\migration $sql = 'SELECT forum_id, topic_visibility, COUNT(topic_id) AS sum_topics, SUM(topic_posts_approved) AS sum_posts_approved, SUM(topic_posts_unapproved) AS sum_posts_unapproved FROM ' . $this->table_prefix . 'topics - GROUP BY forum_id, topic_visibility'; + GROUP BY forum_id, topic_visibility + ORDER BY forum_id, topic_visibility'; $result = $this->db->sql_query_limit($sql, $limit, $start); $update_forums = array(); |