select top 100 substring(qr_code,8,8) ,* from [LiuJun_PKh_lcfc_hf] --where right(ri,8) or substring(qr_code,8,8)=.
select top 10 left(right(one_code,13),11),* from LiuJun_PKqitchqi order by id desc