summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--textbook_companion_fixer_edit_book_category.inc2
1 files changed, 1 insertions, 1 deletions
diff --git a/textbook_companion_fixer_edit_book_category.inc b/textbook_companion_fixer_edit_book_category.inc
index 531e07a..a4c421e 100644
--- a/textbook_companion_fixer_edit_book_category.inc
+++ b/textbook_companion_fixer_edit_book_category.inc
@@ -272,7 +272,7 @@ function _tbc_fixer_list_of_new_category($pref_id)
FROM list_of_category loc
LEFT JOIN textbook_companion_book_main_subcategories tcbms ON loc.category_id = tcbms.main_category
LEFT JOIN list_of_subcategory los ON los.subcategory_id = tcbms.sub_category
- WHERE tcbms.pref_id = :pref_id
+ WHERE tcbms.pref_id = :pref_id ORDER BY loc.category_id
";
$args = array(
':pref_id' => $pref_id