SELECT * FROM `sys_dict_misc`
WHERE dict_type_code NOT IN(
'NATION_DICT','ORG_LEVEL_DICT','USER_ORGWORK_TYPE_DICT','USER_ORGDUTY_DICT','MESSAGE_SEND_TYPE_DICT','AUDIT_STATUS_DICT','MESSAGE_SEND_STATUS_DICT','APPLICATION_AUDIT_DICT','SERVICE_INTERFACE_TYPE'
,'ALARM_TYPE_DICT','ALARM_CLOSE_TYPE_DICT','CHECK_STATUS','ALARM_LEVEL','WORK_STATUS','MEDICARE_CARD_TYPE_DICT','EVENT_PRIORITY_DICT','ALARM_STATUS_DICT','ENTITY_CATALOG_DICT','TODO_TYPE_DICT'
,'TODO_STATUS_DICT','MONITOR_INFO_TYPE_DICT','USER_BLACKLIST_RANK_DICT','BLACK_LIST_STATUS_DICT','PROP_AUTH_USER_OBJ','PROP_AUTH_ORG_OBJ','SMS_BUSINESS_TYPE','USER_STATUS','SMS_TEMPLATE','SYNC_OPERATION','MGR_RULE_TYPE','','','',''
,'SYNC_STATUS','USER_ID_CARD_TYPE','ORG_LEVEL_TYPE','SYNCDATA_TIME_DICT','USER_STATUS_DICT','ORG_TYPE_DICT','GROUP_TYPE_DICT','OPERATE_TYPE_DICT','OPERATE_OBJECT_DICT','ALARM_EVENT_DICT','EVENT_TYPE_DICT','','','',''
,'WEDLOCK_DICT','RELIGION_DICT','EDUCATION_DICT','USERTYPE_DICT','OPERATE_LEVEL_DICT','PRIVILEGE_TYPE_DICT','ORG_STYLE_DICT','NATIONALITY_DICT','GENDER_DICT'
,'CITY_CODE_DICT','PUSH_MESSAGE_DICT','MSG_TYPE_DICT','WORK_TASK_PUBLIC_SCOPE_DICT','APPLY_STATUS_DICT','TASK_STATUS','REMIND_WAY','APPROVE_STATUS_DICT','HOLIDAY_TYPE_DICT','RESET_CYCLE_DICT','','','','',''
,'COMPONENT_CONFIG_TYPE_DICT','FORM_COMPONENT_CATALOG_DICT','','','','','','','','','','','','',''
,'','','','','','','','','','','','','','',''
,'','','','','','','','','','','','','','','')
ORDER BY dict_type_id ASC

SELECT dict_type_name,UPPER(dict_type_code),dict_id,dict_name,dict_value,dict_disp_order,DICT_DESCRIPTION FROM `sys_dict_misc` WHERE dict_type_id>441
ORDER BY dict_type_code ASC