SELECT `OrganizationCategory`.`id`, (IF(`OrganizationCategory`.`sub_category`!="" && `OrganizationCategory`.`sub_category` IS NOT NULL, `OrganizationCategory`.`sub_category`, `OrganizationCategory`.`category`)) AS `OrganizationCategory__abbrv_category` FROM `cat4_organization_categories` AS `OrganizationCategory` WHERE `OrganizationCategory`.`flag_type`="1" ORDER BY (IF(`OrganizationCategory`.`sub_category`!="" && `OrganizationCategory`.`sub_category` IS NOT NULL, `OrganizationCategory`.`sub_category`, `OrganizationCategory`.`category`)) ASC