2024-08-31 01:00:01 -- 將會員中心id寫入data-lake
2024-08-31 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-08-30%';
        
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249105'
                WHERE ordernumber = 'P200830110140813' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385490'
                WHERE ordernumber = 'P190830110235117' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249105'
                WHERE ordernumber = 'P200830110318424' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397123'
                WHERE ordernumber = 'P630830110504425' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335273'
                WHERE ordernumber = 'P190830110523860' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416242'
                WHERE ordernumber = 'P200830110601573' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416237'
                WHERE ordernumber = 'P190830110658817' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345137'
                WHERE ordernumber = 'P420830111118123' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416246'
                WHERE ordernumber = 'P180830111202420' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415776'
                WHERE ordernumber = 'P420830111251752' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416240'
                WHERE ordernumber = 'P630830111317343' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416247'
                WHERE ordernumber = 'P180830111324352' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326214'
                WHERE ordernumber = 'P180830111633523' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416248'
                WHERE ordernumber = 'P420830111700435' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406754'
                WHERE ordernumber = 'P420830111742833' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416252'
                WHERE ordernumber = 'P420830111929699' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416253'
                WHERE ordernumber = 'P420830112107336' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320213'
                WHERE ordernumber = 'P420830112253384' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416256'
                WHERE ordernumber = 'P180830112521240' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416252'
                WHERE ordernumber = 'P420830112633993' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416257'
                WHERE ordernumber = 'P180830112854146' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283248'
                WHERE ordernumber = 'P180830113016430' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352165'
                WHERE ordernumber = 'P180830113149755' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416253'
                WHERE ordernumber = 'P420830113230653' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416261'
                WHERE ordernumber = 'P180830113531655' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200830113717657' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416263'
                WHERE ordernumber = 'P180830113722425' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385478'
                WHERE ordernumber = 'P420830114000841' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237408'
                WHERE ordernumber = 'P200830114008199' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416265'
                WHERE ordernumber = 'P180830114118768' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276070'
                WHERE ordernumber = 'P200830114151320' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '221941'
                WHERE ordernumber = 'P200830114353409' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374922'
                WHERE ordernumber = 'P180830114431256' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399661'
                WHERE ordernumber = 'P180830114506128' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255004'
                WHERE ordernumber = 'P180830114958383' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341973'
                WHERE ordernumber = 'P420830115131556' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '79058'
                WHERE ordernumber = 'P420830115221525' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '120327'
                WHERE ordernumber = 'P200830115550950' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416270'
                WHERE ordernumber = 'P420830115649828' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '330728'
                WHERE ordernumber = 'P180830115650913' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356566'
                WHERE ordernumber = 'P420830120107708' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320976'
                WHERE ordernumber = 'P190830120508183' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230102'
                WHERE ordernumber = 'P180830120636932' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416276'
                WHERE ordernumber = 'P200830120640566' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416277'
                WHERE ordernumber = 'P190830120735956' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416278'
                WHERE ordernumber = 'P200830120751978' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416280'
                WHERE ordernumber = 'P180830120833552' 
            
2024-08-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406098'
                WHERE ordernumber = 'P180830120902415' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416281'
                WHERE ordernumber = 'P200830121057872' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399365'
                WHERE ordernumber = 'P190830121536397' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416289'
                WHERE ordernumber = 'P200830121658773' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376568'
                WHERE ordernumber = 'P190830121832575' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416287'
                WHERE ordernumber = 'P200830121920305' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231753'
                WHERE ordernumber = 'P190830121957526' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113784'
                WHERE ordernumber = 'P180830122021279' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372241'
                WHERE ordernumber = 'P420830122103715' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403063'
                WHERE ordernumber = 'P190830122119929' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281945'
                WHERE ordernumber = 'P200830122137373' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284067'
                WHERE ordernumber = 'P190830122529496' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393238'
                WHERE ordernumber = 'P180830122646428' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306297'
                WHERE ordernumber = 'P190830122732836' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232257'
                WHERE ordernumber = 'P200830122734455' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355793'
                WHERE ordernumber = 'P420830122930797' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416294'
                WHERE ordernumber = 'P180830123034780' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416297'
                WHERE ordernumber = 'P420830123328938' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154457'
                WHERE ordernumber = 'P200830123359529' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289978'
                WHERE ordernumber = 'P200830123532807' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416300'
                WHERE ordernumber = 'P420830123639361' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416303'
                WHERE ordernumber = 'P420830123822992' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336777'
                WHERE ordernumber = 'P200830124537728' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262046'
                WHERE ordernumber = 'P200830124713617' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416309'
                WHERE ordernumber = 'P190830124934989' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382548'
                WHERE ordernumber = 'P590830125242269' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313319'
                WHERE ordernumber = 'P420830125255383' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416052'
                WHERE ordernumber = 'P190830125408871' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221302'
                WHERE ordernumber = 'P200830125440660' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410620'
                WHERE ordernumber = 'P180830125815737' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416312'
                WHERE ordernumber = 'P420830125933757' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415189'
                WHERE ordernumber = 'P420830130243916' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416316'
                WHERE ordernumber = 'P420830130512517' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416319'
                WHERE ordernumber = 'P200830130847530' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416320'
                WHERE ordernumber = 'P420830130927998' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416322'
                WHERE ordernumber = 'P420830131037359' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245182'
                WHERE ordernumber = 'P190830131112127' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416323'
                WHERE ordernumber = 'P200830131145171' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404707'
                WHERE ordernumber = 'P190830131317331' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415000'
                WHERE ordernumber = 'P420830131329136' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P200830132024351' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401249'
                WHERE ordernumber = 'P420830132035195' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401249'
                WHERE ordernumber = 'P420830132144172' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416332'
                WHERE ordernumber = 'P420830132252480' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416333'
                WHERE ordernumber = 'P420830132624664' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41517'
                WHERE ordernumber = 'P190830132704314' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229832'
                WHERE ordernumber = 'P200830132713457' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416334'
                WHERE ordernumber = 'P180830132718226' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416337'
                WHERE ordernumber = 'P420830132755715' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410429'
                WHERE ordernumber = 'P420830133121399' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391632'
                WHERE ordernumber = 'P190830133310902' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100490'
                WHERE ordernumber = 'P200830133313638' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416341'
                WHERE ordernumber = 'P420830133555390' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389334'
                WHERE ordernumber = 'P200830134158789' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416346'
                WHERE ordernumber = 'P180830134231863' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396965'
                WHERE ordernumber = 'P420830134419300' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416348'
                WHERE ordernumber = 'P190830134600386' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180830134821780' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416350'
                WHERE ordernumber = 'P190830135045510' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416351'
                WHERE ordernumber = 'P420830135129571' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416354'
                WHERE ordernumber = 'P180830135327995' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416355'
                WHERE ordernumber = 'P420830135356772' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416356'
                WHERE ordernumber = 'P190830135432832' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416354'
                WHERE ordernumber = 'P180830135707454' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416288'
                WHERE ordernumber = 'P420830135823490' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416357'
                WHERE ordernumber = 'P180830135825606' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '151947'
                WHERE ordernumber = 'P180830135947252' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342207'
                WHERE ordernumber = 'P420830140050359' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416359'
                WHERE ordernumber = 'P200830140130986' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117088'
                WHERE ordernumber = 'P180830140305234' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403168'
                WHERE ordernumber = 'P200830140534373' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206994'
                WHERE ordernumber = 'P180830140651536' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296985'
                WHERE ordernumber = 'P200830140716524' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99638'
                WHERE ordernumber = 'P180830140733600' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276738'
                WHERE ordernumber = 'P180830140811118' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225903'
                WHERE ordernumber = 'P180830141053369' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225903'
                WHERE ordernumber = 'P180830141134229' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362393'
                WHERE ordernumber = 'P420830141217404' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416364'
                WHERE ordernumber = 'P200830141240693' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225903'
                WHERE ordernumber = 'P180830141302699' 
            
2024-08-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114280'
                WHERE ordernumber = 'P180830141334894' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274222'
                WHERE ordernumber = 'P200830141648435' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413187'
                WHERE ordernumber = 'P420830141849152' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416368'
                WHERE ordernumber = 'P180830141922663' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414262'
                WHERE ordernumber = 'P420830142101349' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232255'
                WHERE ordernumber = 'P180830142201790' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403138'
                WHERE ordernumber = 'P200830142615323' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371706'
                WHERE ordernumber = 'P420830142702751' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101571'
                WHERE ordernumber = 'P180830142711618' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399080'
                WHERE ordernumber = 'P420830143042331' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294019'
                WHERE ordernumber = 'P420830143153859' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180830143157762' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258944'
                WHERE ordernumber = 'P180830143724219' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416375'
                WHERE ordernumber = 'P190830143738144' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416376'
                WHERE ordernumber = 'P420830143820275' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416375'
                WHERE ordernumber = 'P190830144433864' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405634'
                WHERE ordernumber = 'P200830144513305' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416382'
                WHERE ordernumber = 'P420830144522343' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405634'
                WHERE ordernumber = 'P200830144608804' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356316'
                WHERE ordernumber = 'P200830144907780' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99903'
                WHERE ordernumber = 'P180830145152824' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249315'
                WHERE ordernumber = 'P190830145437407' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120315'
                WHERE ordernumber = 'P180830145627501' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416386'
                WHERE ordernumber = 'P190830145845870' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111382'
                WHERE ordernumber = 'P200830150126532' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219462'
                WHERE ordernumber = 'P200830150822134' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279892'
                WHERE ordernumber = 'P200830151010784' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284924'
                WHERE ordernumber = 'P200830151119607' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369316'
                WHERE ordernumber = 'P180830151331961' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416394'
                WHERE ordernumber = 'P200830151436332' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416396'
                WHERE ordernumber = 'P420830151611649' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416105'
                WHERE ordernumber = 'P180830151655820' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415855'
                WHERE ordernumber = 'P180830152503757' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180830152723944' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416403'
                WHERE ordernumber = 'P200830152823227' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404969'
                WHERE ordernumber = 'P630830153327389' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416407'
                WHERE ordernumber = 'P420830153600256' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206421'
                WHERE ordernumber = 'P190830153732179' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99647'
                WHERE ordernumber = 'P180830153816860' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206421'
                WHERE ordernumber = 'P190830153844550' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416410'
                WHERE ordernumber = 'P200830154018541' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376590'
                WHERE ordernumber = 'P420830154116326' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314089'
                WHERE ordernumber = 'P420830154153949' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416401'
                WHERE ordernumber = 'P420830154446943' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416243'
                WHERE ordernumber = 'P180830154537358' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406429'
                WHERE ordernumber = 'P190830154830260' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416416'
                WHERE ordernumber = 'P180830154904644' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406429'
                WHERE ordernumber = 'P190830154941631' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406429'
                WHERE ordernumber = 'P190830154949969' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416417'
                WHERE ordernumber = 'P180830155126574' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416419'
                WHERE ordernumber = 'P180830155254122' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221426'
                WHERE ordernumber = 'P180830155704864' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409321'
                WHERE ordernumber = 'P420830155734436' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94642'
                WHERE ordernumber = 'P190830155815323' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114984'
                WHERE ordernumber = 'P190830155913532' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409041'
                WHERE ordernumber = 'P420830160055231' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248048'
                WHERE ordernumber = 'P180830160410525' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409968'
                WHERE ordernumber = 'P180830160505750' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416428'
                WHERE ordernumber = 'P420830161446461' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416429'
                WHERE ordernumber = 'P420830161605262' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416430'
                WHERE ordernumber = 'P420830161712314' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397132'
                WHERE ordernumber = 'P180830161712316' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252401'
                WHERE ordernumber = 'P200830161827346' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416431'
                WHERE ordernumber = 'P420830162319430' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416432'
                WHERE ordernumber = 'P200830162410641' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300648'
                WHERE ordernumber = 'P180830162706455' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416333'
                WHERE ordernumber = 'P420830162901423' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410594'
                WHERE ordernumber = 'P420830163056349' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149331'
                WHERE ordernumber = 'P200830163102589' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412413'
                WHERE ordernumber = 'P420830163221595' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412413'
                WHERE ordernumber = 'P420830163259816' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305549'
                WHERE ordernumber = 'P420830163425428' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160054'
                WHERE ordernumber = 'P200830163514702' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111677'
                WHERE ordernumber = 'P180830163906345' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416440'
                WHERE ordernumber = 'P180830164052498' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383239'
                WHERE ordernumber = 'P180830164559925' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416446'
                WHERE ordernumber = 'P200830165130511' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '148560'
                WHERE ordernumber = 'P200830165337587' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111872'
                WHERE ordernumber = 'P180830165433508' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301815'
                WHERE ordernumber = 'P200830165754792' 
            
2024-08-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274998'
                WHERE ordernumber = 'P180830170150383' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416454'
                WHERE ordernumber = 'P420830170427214' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '335575'
                WHERE ordernumber = 'P180830170535516' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264054'
                WHERE ordernumber = 'P180830170614451' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416456'
                WHERE ordernumber = 'P420830170909435' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169576'
                WHERE ordernumber = 'P200830170939729' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280528'
                WHERE ordernumber = 'P630830171051301' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416457'
                WHERE ordernumber = 'P420830171112438' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416458'
                WHERE ordernumber = 'P180830171158701' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214777'
                WHERE ordernumber = 'P200830171243635' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416461'
                WHERE ordernumber = 'P420830171515424' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '327491'
                WHERE ordernumber = 'P420830171554956' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416462'
                WHERE ordernumber = 'P420830171753148' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365967'
                WHERE ordernumber = 'P200830172127171' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396627'
                WHERE ordernumber = 'P180830172131186' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416464'
                WHERE ordernumber = 'P200830172346879' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416465'
                WHERE ordernumber = 'P420830172402164' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416271'
                WHERE ordernumber = 'P200830172508763' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416467'
                WHERE ordernumber = 'P180830172616116' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '158793'
                WHERE ordernumber = 'P180830172741977' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281350'
                WHERE ordernumber = 'P190830172821747' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '77463'
                WHERE ordernumber = 'P420830172858236' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416471'
                WHERE ordernumber = 'P180830172933845' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416472'
                WHERE ordernumber = 'P200830173028776' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100281'
                WHERE ordernumber = 'P180830173103571' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116629'
                WHERE ordernumber = 'P200830173213491' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399693'
                WHERE ordernumber = 'P180830173325626' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264327'
                WHERE ordernumber = 'P180830173403481' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408639'
                WHERE ordernumber = 'P420830174016852' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416475'
                WHERE ordernumber = 'P200830174049636' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416477'
                WHERE ordernumber = 'P420830174137343' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '153160'
                WHERE ordernumber = 'P200830174216668' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96047'
                WHERE ordernumber = 'P180830174358112' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307277'
                WHERE ordernumber = 'P200830174556746' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379470'
                WHERE ordernumber = 'P200830174703127' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104175'
                WHERE ordernumber = 'P200830175029607' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '49370'
                WHERE ordernumber = 'P200830175416228' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403896'
                WHERE ordernumber = 'P180830175642877' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415949'
                WHERE ordernumber = 'P180830175754547' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '107931'
                WHERE ordernumber = 'P420830175925400' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96677'
                WHERE ordernumber = 'P180830175950717' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416489'
                WHERE ordernumber = 'P200830180811523' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409688'
                WHERE ordernumber = 'P420830180942882' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287122'
                WHERE ordernumber = 'P180830180945714' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237428'
                WHERE ordernumber = 'P180830181059644' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408210'
                WHERE ordernumber = 'P200830181208781' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416491'
                WHERE ordernumber = 'P200830181419698' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378236'
                WHERE ordernumber = 'P420830181446222' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P180830182007308' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404307'
                WHERE ordernumber = 'P420830182147361' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337206'
                WHERE ordernumber = 'P420830182427349' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416494'
                WHERE ordernumber = 'P420830182533258' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97201'
                WHERE ordernumber = 'P420830182628398' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242134'
                WHERE ordernumber = 'P180830182834545' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416497'
                WHERE ordernumber = 'P420830182902885' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416499'
                WHERE ordernumber = 'P420830183005235' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416501'
                WHERE ordernumber = 'P420830183351501' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398036'
                WHERE ordernumber = 'P180830183352455' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416502'
                WHERE ordernumber = 'P200830183502757' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405605'
                WHERE ordernumber = 'P420830183530318' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406319'
                WHERE ordernumber = 'P180830183659384' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415427'
                WHERE ordernumber = 'P200830183745612' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '135476'
                WHERE ordernumber = 'P420830183815509' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '265942'
                WHERE ordernumber = 'P180830184344694' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416507'
                WHERE ordernumber = 'P420830184833813' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180830184834996' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414935'
                WHERE ordernumber = 'P180830184924199' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416509'
                WHERE ordernumber = 'P420830185037998' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415699'
                WHERE ordernumber = 'P420830185221448' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416510'
                WHERE ordernumber = 'P180830185310908' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412309'
                WHERE ordernumber = 'P420830185415784' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342655'
                WHERE ordernumber = 'P180830190012384' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412702'
                WHERE ordernumber = 'P190830190151872' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P180830190306810' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '321807'
                WHERE ordernumber = 'P180830190359572' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416513'
                WHERE ordernumber = 'P190830190438430' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '251662'
                WHERE ordernumber = 'P190830190820321' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407026'
                WHERE ordernumber = 'P190830191029467' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346364'
                WHERE ordernumber = 'P200830191043715' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415742'
                WHERE ordernumber = 'P180830191229707' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282202'
                WHERE ordernumber = 'P180830191345606' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416517'
                WHERE ordernumber = 'P200830191532177' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282202'
                WHERE ordernumber = 'P180830191552276' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416519'
                WHERE ordernumber = 'P200830191749441' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '133616'
                WHERE ordernumber = 'P180830191813402' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408258'
                WHERE ordernumber = 'P180830192016364' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '309353'
                WHERE ordernumber = 'P190830192611249' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397719'
                WHERE ordernumber = 'P190830192924410' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '132012'
                WHERE ordernumber = 'P200830193939123' 
            
2024-08-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128962'
                WHERE ordernumber = 'P190830194013761' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '273312'
                WHERE ordernumber = 'P200830194139617' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '231580'
                WHERE ordernumber = 'P200830194334187' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '416537'
                WHERE ordernumber = 'P190830194546910' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '416535'
                WHERE ordernumber = 'P200830194612265' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '281302'
                WHERE ordernumber = 'P190830194755248' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '19189'
                WHERE ordernumber = 'P200830195043693' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '349554'
                WHERE ordernumber = 'P190830195056820' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '416541'
                WHERE ordernumber = 'P190830195226467' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '255658'
                WHERE ordernumber = 'P190830195442555' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '416542'
                WHERE ordernumber = 'P200830195526765' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '98919'
                WHERE ordernumber = 'P190830195527217' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '378763'
                WHERE ordernumber = 'P200830195944763' 
            
2024-08-31 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '413279'
                WHERE ordernumber = 'P200830200148565'