SELECT nf.offense_code offense_code, nf.nibrs_code nibrs_code, en.ec_code_type code_type, en.ec_code code, ecd.description code_desc, nm.code_type m_code_type, nm.code m_code, ecd.sort_order FROM nibrs_offenses nf INNER JOIN nibrs_code_ejs_mappings nm ON nm.nibrs_code = nf.nibrs_code INNER JOIN ejs_code_nibrs_mappings en ON en.nibrs_code = nm.nibrs_code AND en.code_type = nm.code_type AND en.code = nm.code INNER JOIN ejs_codes ecd ON ecd.code_type = en.ec_code_type AND ecd.code = en.ec_code INNER JOIN nibrs_tab_cols nt ON nt.code = ecd.code_type WHERE ecd.active = 'Y' ORDER BY ecd.sort_order, code_desc