SELECT
a.deptcode deptcode,'card' cla, a.tradetype item_kind,b.jsguid jsid,a.account_id cashierid,a.orderid,a.cardtypeid itemid,a.cardtypename itemname,'1' itemquantity, a.pay_pos,a.pay_xj,
a.pay_card,a.free_money pay_free,a.pay_other,a.pay_othertype,a.pay_cardname,a.tc_categroyid,a.tc_cate,
a.report_categroyid,a.report_cate,
b.real_tc,b.real_yj_card,b.real_yj_free,b.real_yj_other,b.real_yj_pos,b.real_yj_xj,
FROM_UNIXTIME(b.create_time,'%s') create_time,b.`status`,b.cost, b.empname,b.isassign,
b.ismodify,b.order_sn,a.trade_shopcode shopcode,a.buscode,b.empguid ,a.seria_num,
b.tc_status,b.virtual_yj_xj,b.virtual_yj_card,b.virtual_yj_pos,b.virtual_yj_free,
b.virtual_yj_other,b.virtual_yj_othertype,b.pay_other_jyj,b.emp_audit,
FROM_UNIXTIME(b.emp_audit_time,'%Y-%m-%d %H:%i:%S') emp_audit_time
FROM tb_account a
INNER JOIN tb_account_his_js b ON a.account_id = b.account_id and a.trade_shopcode=b.shopcode
LEFT JOIN tb_orders_verify_log l ON a.orderid = l.orderid and a.trade_shopcode=l.shopcode
WHERE b.status=0 and b.shopcode in ('016577002F3C789DE72F307629B63224','7A4D420E847A850B5629E9D0DB63F17F','E5237326C94034E16ECA3F64AB4C6618','A682D602154AF72CBE8C6302498375CF','A38BE2EDE457F1FA830CF176F11BE9FB','DFF0DAC29DC66CF4B0F720C104A0043C','684009A37CE800FFFB3FA84F270B251D','209767D8B38653CF8E1B9F9F65C78538','F9D7B891A26398E72B0E6934EDB9DCBA','AFAB5723574BD5DACB997469FBD65F96','F6F5E59427EC38D74D697792FEC30FE4','A686C43BF6956A9B88393566E562747B','D24156F89D915F8AD53DACF6171A9418','CA76780707DAA2FAD43AF2EB1F6C75F6','2A2004173B5D6ACB21D1E337D6F7F16D','1464B32DC515967379CB91AF1D76AE12','15968FA0473ADA23893836D750D536D3','90F68FA929F77EAB7D8D1C8BC71CB733','3DABD4E8741CED5AA7AE80012DFDC2D4','D7C428E91C0CD125A3CC5E64ECDA4F43','740EA4F19D222B2A1752F83FE6E43C74','925D40AC2E5EB5CE204CD37086E1B1A0','642F8D7BD1CA3A2794A5DA920CA0D8A9','E20511A1FB5BF2C1B623E515882DBF9E','D66A1EBADE62D75972990C463104579B','64FA257D59A1DA1AF63072EA0A1400AC','2B5455D660737015DF4DACBAE0699A02','E105AF449D34688AA503FDA7EF6688DA','0F01C9BB311C79661AA61C4748367A08','7328B3BC4BD749926A136BA012F3DD93','3006199A28D6A3E589F7032CEA6D833D','9E58560AE7B2079E98C2F8477F6E4D5B','38AE1CA5010C6EBC5B9016AF3628A1E2','7A0177332765B71E5056D7B504105ABE','391CFA994518CA4E50E31B2C645719C9','CD41B62B2A2B536C97464C36D6066214','A5DC4B983D515346A551821A15938F1C','512DFE5C313DB747233749D611D2E16F','7A7BB664B9832441AE18B56FCA4C6C2C','AABA5C104BB4DBF6962FAB3D44DE50B0','4F02EC16754689C2A7E7253560361DA7','6E1D5F5EE723C84553DB7BDB5AA07A23','2D2849E2459E4F7171C5A3B8E31D3A99','F18D80917A51A062C9DD24FC155692C9','C07C46CB9EC7AA20E9365D5836824E90','135A28743B15077E581BF36B7B21D71D','6F4A6E55A29BBFF2F9903B97C837BFCC','A8F6099EA47CFD6435DF53AF4290DD63','54AEEA21B764BCF1F8F1FB72F9C3322F','7083360640cb11e885033c970e7bc5ce','E423832617C37B840A585C0DDD3FB877','BC59C2F4DBC064B876A020C8F0AC5319','3FB75814EC07CB80AC13EA10F2DC782B','7C86B9C82193EBD9DAA93021AF7FC514','F9FCC8B373956F51179BE477D1D54CE9','ECDD0E0A720BF088119C3877FE162C90','D86B5B3F357FD49ED5770D3A75AAC948','4D8D018FA44BA4F50A5E86C2DD69E1E8','7AE67F543688C7648CB2CEAE860EA556','FE5254B56DB86F79743A7868C7E74518','C9E1CB149655059DDB9A8FEA5F749D7E','6CE8B358FF42E7B01A871C4E0B98901A','36871E3886317408874460210A2F3BEE','05108FE8CC8BACDFE3BA1A915ED98B92','653EC56B047FD4A85259250C6B5B4CCA','B0BEFF7A347190A94A274255193ABC82','EE1D434065ADF45C4E5738E3AE72F3F0','087565A5B5F5424B6D4872C763D01B41','89BF848AE86A5A466A046E37A0D9E2A4','721392BA6CC2CD560566AC17B90B8D44','727EF7381717EF4E7D105A6F150B6808','219E6A029206B33BB0DCA3A45F48419A','08AC728CC6AA121D34ADCEBEC49EF1B0','BC713C5176AF9DF31A59CE6664CDA5E6','B7D31CB2D3EAE658D85DD181A147D40F','4EEF750828D6F10F78AA6247DD0A3889','8EFDE3904F68D251F8B2F2A903135649','731631B6622C75534201F0CCF1C2469F','7DF5CE0984812670AB8664C3CCDA4DD9','94645A51FEB6475D509544DA1B22F1EE','D24F8250C6B1C2F3B5C7D0EA9E939F98','AB15A07F8731DC684E3339745E15F8F6','692064E55D2EA19FBDED3B279CB35ACD','C6F1BD686AA87AEC59BD98F70AA83132','98C73D6C383954943DBAADFD271C9D98','AAD92EA81C37AC96DA267BAB2E950B55','F40AF410A22BAB9071FD3EB47C2C8F78','DC4611EF73150C78EF866872110F99C7','2DC7E234D164AF4258EA5623BEF7072F','9D18B34A2FB0000B71C3E7716A2830A6','0380155509C8AF6E75387207299CA82E','ACDCF78491007665D3F41ED1CC47FB2D','2F0F704AFA80F2CA3AC97D5205A6CFBE','F5F0E070628885E9CDB361866054B591','0E29ABD4793F90CD402BE74A81C30AA0','F5F59973B29D6ECB22A2E08E22F705B5','28736186E1707335D1557484CCD692F1','B6038906CA5295C0E36BE5C07C8FC13C','8B9461E6667E77E088F771F8DE4E3A2C','9E0A319B031F6DF442BECEEBE3B95E62','E661AE7E1C48C4A1655E1EE6EB609511','2552A2A8B0F10E2CD1A76EC355C92346','B0A42FB1C7263BD4CB0E13091E5CF6E6','8D91C662EB6053E66FB03562E0C09BDD','2C139557B3E3A4C4355ED4DA41B80D72','4272E06E99945199F62A2D94C79F14C9','A29021E9E33C1C0F9D407223CAB14698','FC2FA0CFD6F2E1186B3F156FF2A069B5','E9C163F3768C39A28F82BB002C18D311','6C3265AF4073C417B51019FC2944746D','FEDF36FC3D0B1ADFF2874CCC25CA13C4','B20E91EE6C1E4A7E48C3FF9D6423ED39','286B583A6CDB84A4495BA039C05B703D','06CE414B23492FDA14364324B50B30F4','9DB8DFD9CC4A81CE4C788B1AE3CB897C','4D69448B870646CE42B5EC1D3839CB95','70845ea040cb11e885033c970e7bc5ce','708460a140cb11e885033c970e7bc5ce','FE56B47861128A740F4F5002C14F293B','B9DCE0A357C53252CB32AEF784BEC668','E588E15DE6C8A2EB9C86252FD20E9AF7','E4E74C5742988BDE38EE3573D5BA8461','A2AC085187A8D881A4D052B4929DF828','50A47C2586022D7C169882F80C72C64C','ECAA9FAFD20BDBB73395225CB7B823C9','F8DCCADA184966BDC18F42C1FECA4A6A','874BB8F3950DDC0414B3AD5EAB7EA699','4C04F8FC24A1E9C139D2238A3874F345','95B90766BC530AE15773C93A6DF0A6C8','A2D120F3E72254EE3437D46EF6ED76F3','E8A2E5D3B0D52B29A557DAEF234ED273','B74A34912895F76B29BDB51DE74FC691','B3EDE70B3449FE079654B14370266112','7AD18BE49437EFBDC0EE213B955D2028','130DDFAA2F17E8B3F1B291DC0DEA37E1','3A4B83FC4E8A3F66F9D26F1D3F87D155','E0385AF654617521532494CE96B0E729','4372F880118B6A6FACAAD06084E6DE6E','9682437EDBEC3FB9F501C34920A2EC82','7454EB63798CCB60EACA4E89E57E48F5') and b.buscode='0B88F214D7E1C1A865ABD59BB878085E' and b.invalid=0
and b.create_time BETWEEN 1533052801 AND 1534262399 ;