sqlshit

INSERT INTO
  SANE_incm
  (
    id,
    uid,
    org_id,
    acnt_name,
    ulogin,
    sum,
    ptype_id,
    stype_id,
    ctime,
    time,
    curr_id,
    curr_sum,
    psp_id,
    psp_tid,
    op,
    comment,
    type
  )
SELECT
  i.id,
  i.uid,
  i.org_id,
  i.acnt_name,
  COALESCE(r.ulogin, i.acnt_name),
  i.sum,
  i.ptype_id,
  i.stype_id,
  FROM_UNIXTIME(i.ctime),
  i.time,
  i.curr_id,
  i.curr_sum,
  i.psp_id,
  i.psp_tid,
  i.op,
  i.comment,
  (
    CASE WHEN
      (r.ulogin IS NULL)
    THEN
      CASE WHEN
        (i.acnt_name LIKE '%sm')
      THEN
        'cash'
      ELSE
        'strange'
      END
    ELSE
      CASE WHEN
        (r.ltype = 1 OR r.ulogin IN ('1pavelpr1k2-38k0', 'dobrolyub9-713', 'lyus72-54', 'narbat22-95', 'serpval3-36') OR r.privjur = 1)
      THEN
        'cash'
      ELSE
        CASE WHEN
          (r.ulogin LIKE 'test%')
        THEN
          'trash'
        ELSE
          'cashless'
        END
      END
    END
  )
FROM
  RAW_incm AS i
LEFT OUTER JOIN
  requestbase AS r
ON
  r.blogin = i.acnt_name;