From fdce8b8b09ae2b7deb798c2108c60e352ee81404 Mon Sep 17 00:00:00 2001
From: prashantsinalkar
Date: Thu, 11 May 2017 10:35:16 +0530
Subject: data fetched in order

---
 textbook_companion_fixer_edit_book_category.inc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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
-- 
cgit