select

id, regist_no, is_vehicleInsurance, regist_date, regist_date_value, org_code, org_name,
item_id, loss_id, item_type, item_type_name, loss_type, loss_type_name, loss_name,
case_item_type, case_item_type_name, app_inflow_time, app_inflow_time_value, app_inflow_type,
app_inflow_type_name, reassign_source, reassign_source_name, app_outflow_time, app_outflow_time_value,
app_outflow_port, app_outflow_type, app_outflow_type_name, app_handle_type, app_handle_type_name,
app_handle_name, app_handle_username, app_handle_mobile, app_handle_usercode, app_handle_org_code,
app_handle_org_name, back_handle_type, back_handle_type_name, back_handle_name, back_handle_username,
back_handle_usercode, back_handle_org_code, back_handle_org_name, back_handle_time,
create_by, create_time, modify_by, modify_time

from report_item_process

WHERE ( is_vehicleInsurance = 1

and case_item_type in
(
1
,
3
) )

order by regist_date_value desc,loss_id asc,app_inflow_time_value desc