SELECT id, nick_name, /*t_log_cash.point, r_money, be_r_money, af_r_money,*/ 
(case ac_code
when 10 then t_log_cash.r_money
else t_log_cash.point
end) as point
,t_log_cash.coment, t_log_cash.reg_time FROM t_log_cash 
join member on t_log_cash.member_idx = member.idx
where ac_code in (10,123,3001,3002,4001,4002,4003,4004,4005)
-- and coment like '%event%'
and t_log_cash.reg_time >= '2024-03-01 00:00:00' and t_log_cash.reg_time < '2024-03-19 00:00:00'
order by t_log_cash.idx desc;

