select `rice-2.1.1`.`krim_typ_t`.`NM` AS `responsibility_type_name`,`rice_2_1_1clean`.`krim_rsp_tmpl_t`.`NM` AS `rsp_TEMPLATE_NAME`,`rice_2_1_1clean`.`krim_rsp_t`.`NMSPC_CD` AS `rsp_namespace_code`,`rice_2_1_1clean`.`krim_rsp_t`.`NM` AS `rsp_NAME`,`rice_2_1_1clean`.`krim_rsp_t`.`RSP_ID` AS `rsp_id`,`rice_2_1_1clean`.`krim_attr_defn_t`.`NM` AS `attribute_name`,`rice_2_1_1clean`.`krim_rsp_attr_data_t`.`ATTR_VAL` AS `attribute_value` from ((((`rice_2_1_1clean`.`krim_rsp_t` join `rice_2_1_1clean`.`krim_rsp_attr_data_t` on((`rice_2_1_1clean`.`krim_rsp_t`.`RSP_ID` = `rice_2_1_1clean`.`krim_rsp_attr_data_t`.`RSP_ID`))) join `rice_2_1_1clean`.`krim_attr_defn_t` on((`rice_2_1_1clean`.`krim_rsp_attr_data_t`.`KIM_ATTR_DEFN_ID` = `rice_2_1_1clean`.`krim_attr_defn_t`.`KIM_ATTR_DEFN_ID`))) join `rice_2_1_1clean`.`krim_rsp_tmpl_t` on((`rice_2_1_1clean`.`krim_rsp_t`.`RSP_TMPL_ID` = `rice_2_1_1clean`.`krim_rsp_tmpl_t`.`RSP_TMPL_ID`))) join `rice_2_1_1clean`.`krim_typ_t` on((`rice_2_1_1clean`.`krim_rsp_tmpl_t`.`KIM_TYP_ID` = `rice_2_1_1clean`.`krim_typ_t`.`KIM_TYP_ID`))) order by `rice_2_1_1clean`.`krim_rsp_tmpl_t`.`NM`,`rice_2_1_1clean`.`krim_rsp_t`.`NM`,`rice_2_1_1clean`.`krim_attr_defn_t`.`NM`