join_page_id_id.page_type_id as page_id_page_type_id
");
- $cms_page_category->groupBy("cms_page_category.category_id,
- join_category_id_id.title ,
- join_page_id_id.page_type_id
- ");
+ $cms_page_category->groupBy("
+ cms_page_category.category_id,
+ join_category_id_id.is_draft
+ join_category_id_id.title ,
+ join_page_id_id.page_type_id
+ ");
+
$cms_page_category->orderBy("cms_page_fullpath(cms_page_category.category_id, ' - ') ASC");
foreach ($cms_page_category->fetchAll() as $s){