Query: | SELECT `T1`.`ID`, `T1`.`Path`, `T1`.`Level`, `T1`.`Type`, `T1`.`Key`, `T1`.`Lock`, `T1`.`Add`, IF(`T2`.`ID` AND `T2`.`Status` = 'active', `T2`.`ID`, IF( `T3`.`ID`, 1, 0 )) `Sub_cat` FROM `au_categories` AS `T1` LEFT JOIN `au_categories` AS `T2` ON `T1`.`ID` = `T2`.`Parent_ID` AND `T2`.`Status` = 'active' LEFT JOIN `au_tmp_categories` AS `T3` ON `T1`.`ID` = `T3`.`Parent_ID` AND `T3`.`Account_ID` = '' WHERE `T1`.`Status` = 'active' AND `T1`.`Parent_ID` = '0' GROUP BY `T1`.`Key` ORDER BY `T1`.`Position` |