SELECT
	regist_no,
	regist_date,
	org_name,
	item_type_name,
	loss_type_name,
	loss_name,
	case_item_type_name,
	app_inflow_time,
	app_inflow_type,
	reassign_source_name,
	app_outflow_time,
	app_outflow_type_name,
	app_handle_type_name,
	app_handle_name,
	app_handle_type_name,
	app_handle_mobile,
	app_handle_usercode,
	app_handle_org_name,
	back_handle_type_name,
	back_handle_name,
	back_handle_username,
	back_handle_org_name,
	back_handle_time
FROM
	report_item_process
ORDER BY regist_date_value desc,loss_id asc,app_inflow_time_value desc