SELECT info.rsid, info.now_date, man.name, cash.totalmoney,cash.bankname, cash.orignmoney, man.hp, cash.cashtype, info.regdate, cash.sms_check FROM reserv_info as info, reserv_man as man, reserv_cash as cash where info.status like 'AM%' and info.rsid=man.mid and man.mid=cash.cid and cash.cashtype != 'mbank'  and info.regdate >= '2025-03-12 22:17:33' and cash.sms_check='N' and info.regdate between '2026-03-11 08:47:33' and '2026-03-11 09:17:33'