select gusl.numb_id, cast(gusl.created_at as date) as sm_date,
gs.name as shop_name, gs.code as shop_code, ga.name as area_name,
ckl.time, ckl.type, ck.name, p.type as product_name, p.number as product_number
  from gbc_user_sm_logs as gusl left join fwcx_id as fi on convert(bigint, substring(gusl.numb_id, 4, 8))=fi.num_id
  left join gbc_shops as gs on gusl.shop_id=gs.id
  left join gbc_ad_areas as gaa on gs.ad_code=gaa.ad_code
  left join gbc_areas as ga on ga.id=gaa.area_id
  left join ck_list as ckl on substring(ckl.idnum,4,8)=convert(varchar(8), fi.bag_id)
  left join cangku as ck on ck.name=ckl.[to]
  left join product as p on p.id=ckl.cp_type_id
  where ckl.type=2