<sql id="Base_Column_List_common">

channel,cert_no,mobile,name,DATE_FORMAT(biz_date, '%Y-%m-%d') as bizDateStr,

case when code = 'ROU00000' then '成功' when code ='ROU00001' then '结果数据与KEY未匹配成功'

when code = 'ROU00002' then '未查询到信息' when code ='ROU00003' then '校验失败'

when code = 'ROU00004' then '处理中' when code ='ROU00005' then '请求重复'

when code = 'ROU00006' then '未配置渠道信息或者渠道不可用' when code ='ROU00007' then '用户未授权'

when code = 'ROU00008' then '用户授权失败' when code ='ROU00009' then '用户授权处理中'

when code = 'ROU00010' then '登录失败' when code ='ROU00011' then '渠道方处理错误，请查看渠道处理码'

when code = 'ROU99999' then '其他错误'

end as code,

case when status = 'INIT' then '初始化' when status ='ING' then '处理中'

when status = 'SUCCESS' then '成功' when status ='FAIL8' then '失败'

when status = 'FAIL9' then '失败'

end as status,create_at,update_at

</sql>

<sql id="Base_Column_List">

<include refid="Base_Column_List_common"/>

,province,city,isp

</sql>