金石

select a.user_id, a.jinshi as old_jinshi,b.js_coin as new_jinshi, (b.js_coin - a.jinshi) as diff from evt_member_moneybag as a left join evt_member_wallet_jinshi as b on a.user_id = b.member_id where ( a.jinshi > 0 or b.js_coin > 0) and a.jinshi != b.js_coin order by diff;

存豆

select a.user_id, a.save_time_beans as old_bean, b.save_bean as new_bean, (b.save_bean - a.save_time_beans) as diff from evt_member_moneybag as a left join evt_member_wallet_save_bean as b on a.user_id = b.member_id where ( a.save_time_beans > 0 or b.save_bean > 0) and a.save_time_beans != b.save_bean order by diff;

select *, FROM_UNIXTIME(create_time) from evt_member_log_save_time_beans where user_id = 2042 order by id desc limit 1000;

select * from evt_member_wallet_save_bean_log where member_id = 2042 order by id desc limit 1000;

select * from evt_member where id = 2042

// 存时

select a.user_id, a.save_time as old_time, b.save_time as new_time, (b.save_time - cast(a.save_time as SIGNED)) as diff from evt_member_moneybag as a left join evt_member_wallet_save_bean as b on a.user_id = b.member_id where ( a.save_time > 0 or b.save_time > 0) and a.save_time != b.save_time order by diff;

select *, FROM_UNIXTIME(create_time) from evt_member_log_save_time where user_id = 2042 order by id desc limit 1000;

select * from evt_member_wallet_save_time_log where member_id = 2042 order by id desc limit 1000;

select * from evt_member where id = 2042;

select * from evt_member_log_save_time_beans_list where id in (6244)

// 钱包余额

select a.user_id, a.money as old_money, b.money as new_money, (b.money - a.money) as diff from evt_member_moneybag as a left join evt_member_wallet_money as b on a.user_id = b.member_id where ( a.money > 0 or b.money > 0) and a.money != b.money order by diff;

select *, FROM_UNIXTIME(create_time) from evt_member_log_money where user_id = 5603 order by id desc limit 1000;

select * from evt_member_wallet_money_log where member_id = 5603 order by id desc limit 1000;

select * from evt_member_wallet_money_log where relation_type = 10

select * from evt_order_reward_status where order_id = 34991

// 其它辅助语句

select * from evt_member_log_save_time_beans where type = 101 and create_time >= 1721404800 and create_time <= 1721577599 and user_id not in (select member_id from evt_member_wallet_save_bean_log where relation_type in (1,2) and created_at >= '2024-7-20 00:00:00' order by id desc);

select user_id from evt_member_wallet_save_bean_log where relation_type in (1,2) and created_at >= '2024-7-20 00:00:00' order by id desc;

select *, FROM_UNIXTIME(create_time) from evt_member_log_save_time_beans where user_id = 260648 order by id desc limit 1000;

select * from evt_member_wallet_save_bean_log where member_id = 260648 order by id desc limit 1000;

select * from evt_member where id = 260648

select * from evt_member_log_save_time where type = 101 and create_time >= 1721404800 and create_time <= 1721577599 and user_id not in (select member_id from evt_member_wallet_save_bean_log where relation_type in (1,2) and created_at >= '2024-7-20 00:00:00' order by id desc);

select user_id from evt_member_wallet_save_bean_log where relation_type in (1,2) and created_at >= '2024-7-20 00:00:00' order by id desc;

select *, FROM_UNIXTIME(create_time) from evt_member_log_save_time where user_id = 260648 order by id desc limit 1000;

select * from evt_member_wallet_save_time_log where member_id = 260648 order by id desc limit 1000;

select * from evt_member where id = 260648