2024-05-31 01:00:02 -- 將會員中心id寫入data-lake
2024-05-31 01:00:02 -- 
            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-05-30%';
        
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387848'
                WHERE ordernumber = 'P630530100510292' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392965'
                WHERE ordernumber = 'P630530110152276' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276547'
                WHERE ordernumber = 'P180530110248799' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242849'
                WHERE ordernumber = 'P200530110536189' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351988'
                WHERE ordernumber = 'P420530110603404' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392964'
                WHERE ordernumber = 'P190530110741400' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392964'
                WHERE ordernumber = 'P190530110817120' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243774'
                WHERE ordernumber = 'P180530110928519' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352001'
                WHERE ordernumber = 'P190530111006929' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224521'
                WHERE ordernumber = 'P180530111213305' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '373255'
                WHERE ordernumber = 'P420530111244339' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392968'
                WHERE ordernumber = 'P420530111425954' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290463'
                WHERE ordernumber = 'P200530111503691' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392969'
                WHERE ordernumber = 'P630530111611961' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392970'
                WHERE ordernumber = 'P420530111828498' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318750'
                WHERE ordernumber = 'P420530111959279' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392971'
                WHERE ordernumber = 'P200530112035367' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389053'
                WHERE ordernumber = 'P180530112138167' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392972'
                WHERE ordernumber = 'P200530112216752' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389053'
                WHERE ordernumber = 'P180530112247644' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302821'
                WHERE ordernumber = 'P420530112301480' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '158171'
                WHERE ordernumber = 'P200530112354981' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302821'
                WHERE ordernumber = 'P420530112406120' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392975'
                WHERE ordernumber = 'P420530113029803' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392976'
                WHERE ordernumber = 'P200530113114542' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392977'
                WHERE ordernumber = 'P630530113140884' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392979'
                WHERE ordernumber = 'P420530113239801' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392980'
                WHERE ordernumber = 'P180530113308342' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392981'
                WHERE ordernumber = 'P200530113408237' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '330675'
                WHERE ordernumber = 'P190530113506172' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392982'
                WHERE ordernumber = 'P200530113809726' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392983'
                WHERE ordernumber = 'P420530113830812' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239316'
                WHERE ordernumber = 'P790530114814929' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392984'
                WHERE ordernumber = 'P200530115021266' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286166'
                WHERE ordernumber = 'P180530115319190' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392985'
                WHERE ordernumber = 'P200530115359826' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139001'
                WHERE ordernumber = 'P200530115804619' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293400'
                WHERE ordernumber = 'P200530115934528' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371964'
                WHERE ordernumber = 'P420530120023843' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371964'
                WHERE ordernumber = 'P420530120118822' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392990'
                WHERE ordernumber = 'P190530121215673' 
            
2024-05-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392992'
                WHERE ordernumber = 'P420530121333518' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392991'
                WHERE ordernumber = 'P180530121847562' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375958'
                WHERE ordernumber = 'P180530122134732' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392993'
                WHERE ordernumber = 'P790530122411259' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385951'
                WHERE ordernumber = 'P420530122446889' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294471'
                WHERE ordernumber = 'P190530122535765' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392994'
                WHERE ordernumber = 'P200530122915245' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339623'
                WHERE ordernumber = 'P190530122933295' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392996'
                WHERE ordernumber = 'P200530123400517' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '15078'
                WHERE ordernumber = 'P630530123509153' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392078'
                WHERE ordernumber = 'P710530123641162' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279239'
                WHERE ordernumber = 'P200530123825508' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392997'
                WHERE ordernumber = 'P790530123841147' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392998'
                WHERE ordernumber = 'P190530124105918' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369193'
                WHERE ordernumber = 'P200530124203278' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392999'
                WHERE ordernumber = 'P200530124312326' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393000'
                WHERE ordernumber = 'P790530124435495' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352236'
                WHERE ordernumber = 'P180530124622783' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393002'
                WHERE ordernumber = 'P420530124653756' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393003'
                WHERE ordernumber = 'P420530124846485' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393005'
                WHERE ordernumber = 'P200530125147688' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393006'
                WHERE ordernumber = 'P420530125337325' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393007'
                WHERE ordernumber = 'P180530125448218' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393008'
                WHERE ordernumber = 'P420530125523817' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305690'
                WHERE ordernumber = 'P200530125540431' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393009'
                WHERE ordernumber = 'P420530125619770' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393010'
                WHERE ordernumber = 'P630530125704318' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393011'
                WHERE ordernumber = 'P180530125719857' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393012'
                WHERE ordernumber = 'P420530125752400' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393013'
                WHERE ordernumber = 'P200530125845947' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393014'
                WHERE ordernumber = 'P710530130039313' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393017'
                WHERE ordernumber = 'P200530130317592' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393018'
                WHERE ordernumber = 'P420530130611982' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384055'
                WHERE ordernumber = 'P200530130737144' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393019'
                WHERE ordernumber = 'P200530131147366' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109910'
                WHERE ordernumber = 'P200530131324845' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331577'
                WHERE ordernumber = 'P190530131354427' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393020'
                WHERE ordernumber = 'P180530131404581' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84735'
                WHERE ordernumber = 'P190530131446895' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393021'
                WHERE ordernumber = 'P630530131836601' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358947'
                WHERE ordernumber = 'P420530131857677' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387244'
                WHERE ordernumber = 'P190530131904816' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160114'
                WHERE ordernumber = 'P190530132852288' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393024'
                WHERE ordernumber = 'P790530133415742' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393025'
                WHERE ordernumber = 'P710530133901503' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241330'
                WHERE ordernumber = 'P200530134000280' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '83774'
                WHERE ordernumber = 'P190530134225490' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393027'
                WHERE ordernumber = 'P630530134242677' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392742'
                WHERE ordernumber = 'P420530134245923' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392043'
                WHERE ordernumber = 'P590530134548468' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393028'
                WHERE ordernumber = 'P200530134703201' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393023'
                WHERE ordernumber = 'P790530134819726' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393023'
                WHERE ordernumber = 'P790530135027581' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393030'
                WHERE ordernumber = 'P790530135229383' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393032'
                WHERE ordernumber = 'P200530135244313' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393033'
                WHERE ordernumber = 'P200530135453171' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393030'
                WHERE ordernumber = 'P790530135550120' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393035'
                WHERE ordernumber = 'P200530135809532' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393036'
                WHERE ordernumber = 'P710530140042922' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393037'
                WHERE ordernumber = 'P180530140305997' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393039'
                WHERE ordernumber = 'P180530140738576' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350016'
                WHERE ordernumber = 'P190530140805359' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393039'
                WHERE ordernumber = 'P180530140821143' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219671'
                WHERE ordernumber = 'P190530141028458' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393041'
                WHERE ordernumber = 'P180530141037119' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '192344'
                WHERE ordernumber = 'P190530141207316' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393042'
                WHERE ordernumber = 'P180530141421538' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393043'
                WHERE ordernumber = 'P200530141605405' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101010'
                WHERE ordernumber = 'P180530141619958' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392719'
                WHERE ordernumber = 'P420530141648841' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99926'
                WHERE ordernumber = 'P190530141805602' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393044'
                WHERE ordernumber = 'P420530141815453' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392719'
                WHERE ordernumber = 'P420530141937576' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393049'
                WHERE ordernumber = 'P200530142326915' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393050'
                WHERE ordernumber = 'P420530142454792' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316445'
                WHERE ordernumber = 'P190530142729318' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271172'
                WHERE ordernumber = 'P190530142847617' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393053'
                WHERE ordernumber = 'P790530143219664' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393054'
                WHERE ordernumber = 'P180530143320998' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393055'
                WHERE ordernumber = 'P180530144129765' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393057'
                WHERE ordernumber = 'P200530144423427' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393058'
                WHERE ordernumber = 'P180530144451727' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393056'
                WHERE ordernumber = 'P420530144623794' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303941'
                WHERE ordernumber = 'P200530144722640' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393059'
                WHERE ordernumber = 'P180530145000277' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393061'
                WHERE ordernumber = 'P790530145547117' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393060'
                WHERE ordernumber = 'P790530145811472' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279901'
                WHERE ordernumber = 'P180530145928718' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393062'
                WHERE ordernumber = 'P710530150005730' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391716'
                WHERE ordernumber = 'P200530150209754' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381050'
                WHERE ordernumber = 'P180530150210161' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237374'
                WHERE ordernumber = 'P180530150521774' 
            
2024-05-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378465'
                WHERE ordernumber = 'P200530150611758' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336063'
                WHERE ordernumber = 'P190530150645676' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211642'
                WHERE ordernumber = 'P180530150926200' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269438'
                WHERE ordernumber = 'P180530151222393' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393064'
                WHERE ordernumber = 'P790530151355262' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393065'
                WHERE ordernumber = 'P790530151502535' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393066'
                WHERE ordernumber = 'P200530151532934' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288934'
                WHERE ordernumber = 'P180530151921539' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384245'
                WHERE ordernumber = 'P200530152537169' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384245'
                WHERE ordernumber = 'P200530152658723' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365294'
                WHERE ordernumber = 'P200530152831477' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304598'
                WHERE ordernumber = 'P180530153420570' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393070'
                WHERE ordernumber = 'P180530153611456' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '38807'
                WHERE ordernumber = 'P780530153651620' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393069'
                WHERE ordernumber = 'P710530153743876' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393063'
                WHERE ordernumber = 'P200530154228210' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393075'
                WHERE ordernumber = 'P710530154425835' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306535'
                WHERE ordernumber = 'P180530154541440' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393067'
                WHERE ordernumber = 'P200530154710715' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393078'
                WHERE ordernumber = 'P710530154804250' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390229'
                WHERE ordernumber = 'P200530155457401' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266092'
                WHERE ordernumber = 'P180530155815586' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393081'
                WHERE ordernumber = 'P180530155926542' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393083'
                WHERE ordernumber = 'P200530160113708' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393068'
                WHERE ordernumber = 'P200530160613443' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292979'
                WHERE ordernumber = 'P190530160713774' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393084'
                WHERE ordernumber = 'P180530160751321' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161953'
                WHERE ordernumber = 'P180530161110315' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393085'
                WHERE ordernumber = 'P420530161406407' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281268'
                WHERE ordernumber = 'P200530161442911' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390247'
                WHERE ordernumber = 'P200530161927649' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390480'
                WHERE ordernumber = 'P180530162207113' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102422'
                WHERE ordernumber = 'P200530162215384' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390480'
                WHERE ordernumber = 'P180530162255423' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341914'
                WHERE ordernumber = 'P420530162734818' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393086'
                WHERE ordernumber = 'P630530163122280' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393087'
                WHERE ordernumber = 'P420530163229814' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393088'
                WHERE ordernumber = 'P180530163312172' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387808'
                WHERE ordernumber = 'P420530163500868' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217480'
                WHERE ordernumber = 'P190530163753882' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389559'
                WHERE ordernumber = 'P420530163949220' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103395'
                WHERE ordernumber = 'P200530163955956' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393090'
                WHERE ordernumber = 'P200530164708683' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393091'
                WHERE ordernumber = 'P420530164840695' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393092'
                WHERE ordernumber = 'P420530165015120' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393093'
                WHERE ordernumber = 'P180530165209639' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393094'
                WHERE ordernumber = 'P420530165212949' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393095'
                WHERE ordernumber = 'P180530165428620' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367228'
                WHERE ordernumber = 'P180530165610126' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106204'
                WHERE ordernumber = 'P190530165834904' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102422'
                WHERE ordernumber = 'P200530170301305' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393097'
                WHERE ordernumber = 'P200530170529914' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393099'
                WHERE ordernumber = 'P630530170706929' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258697'
                WHERE ordernumber = 'P420530170814610' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393100'
                WHERE ordernumber = 'P180530170927720' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393100'
                WHERE ordernumber = 'P180530171009550' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222416'
                WHERE ordernumber = 'P200530171042439' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393101'
                WHERE ordernumber = 'P420530171229210' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393103'
                WHERE ordernumber = 'P790530171739786' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393105'
                WHERE ordernumber = 'P190530172316982' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391736'
                WHERE ordernumber = 'P420530172544426' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288667'
                WHERE ordernumber = 'P200530172639595' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288667'
                WHERE ordernumber = 'P200530172808278' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346610'
                WHERE ordernumber = 'P190530172912819' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393098'
                WHERE ordernumber = 'P180530173108854' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97468'
                WHERE ordernumber = 'P200530173150923' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393107'
                WHERE ordernumber = 'P180530173454968' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393108'
                WHERE ordernumber = 'P790530173834163' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393110'
                WHERE ordernumber = 'P180530173938226' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384016'
                WHERE ordernumber = 'P630530174028771' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384016'
                WHERE ordernumber = 'P630530174045116' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393111'
                WHERE ordernumber = 'P420530174054706' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393112'
                WHERE ordernumber = 'P200530174107382' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99239'
                WHERE ordernumber = 'P630530174556876' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393098'
                WHERE ordernumber = 'P180530174901460' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393113'
                WHERE ordernumber = 'P710530174939328' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388331'
                WHERE ordernumber = 'P200530175052180' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393115'
                WHERE ordernumber = 'P200530175554369' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393117'
                WHERE ordernumber = 'P200530175659786' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393119'
                WHERE ordernumber = 'P180530180103822' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393120'
                WHERE ordernumber = 'P180530180252663' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '156313'
                WHERE ordernumber = 'P180530180541877' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240510'
                WHERE ordernumber = 'P190530180617960' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393122'
                WHERE ordernumber = 'P180530180800220' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393123'
                WHERE ordernumber = 'P190530180938951' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392938'
                WHERE ordernumber = 'P790530181004838' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81980'
                WHERE ordernumber = 'P180530181106232' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392939'
                WHERE ordernumber = 'P790530181136303' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393125'
                WHERE ordernumber = 'P200530181459865' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393126'
                WHERE ordernumber = 'P200530181737264' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393127'
                WHERE ordernumber = 'P180530181955134' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315642'
                WHERE ordernumber = 'P180530182020410' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379179'
                WHERE ordernumber = 'P200530182218854' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383273'
                WHERE ordernumber = 'P180530182353712' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326088'
                WHERE ordernumber = 'P180530182859847' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392178'
                WHERE ordernumber = 'P200530182951603' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393131'
                WHERE ordernumber = 'P180530183007368' 
            
2024-05-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392358'
                WHERE ordernumber = 'P180530183058987' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393133'
                WHERE ordernumber = 'P180530183425456' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345295'
                WHERE ordernumber = 'P200530183434679' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '375499'
                WHERE ordernumber = 'P180530183543130' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217649'
                WHERE ordernumber = 'P200530183621145' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374267'
                WHERE ordernumber = 'P420530183730192' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393136'
                WHERE ordernumber = 'P180530183849252' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374267'
                WHERE ordernumber = 'P420530183921905' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381471'
                WHERE ordernumber = 'P180530184029223' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '76999'
                WHERE ordernumber = 'P200530184048987' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390504'
                WHERE ordernumber = 'P200530184618990' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263876'
                WHERE ordernumber = 'P190530184732880' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393137'
                WHERE ordernumber = 'P420530185015601' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393138'
                WHERE ordernumber = 'P190530185041777' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393140'
                WHERE ordernumber = 'P200530185208154' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393129'
                WHERE ordernumber = 'P790530185227683' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393141'
                WHERE ordernumber = 'P420530185350211' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340551'
                WHERE ordernumber = 'P420530185452876' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310981'
                WHERE ordernumber = 'P200530185624690' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393135'
                WHERE ordernumber = 'P790530185925845' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393143'
                WHERE ordernumber = 'P200530190147553' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102839'
                WHERE ordernumber = 'P190530190433387' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '17484'
                WHERE ordernumber = 'P200530190902368' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393144'
                WHERE ordernumber = 'P790530190912379' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386814'
                WHERE ordernumber = 'P630530191008789' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393146'
                WHERE ordernumber = 'P190530191059389' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392126'
                WHERE ordernumber = 'P790530191248650' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93655'
                WHERE ordernumber = 'P200530191333566' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393148'
                WHERE ordernumber = 'P190530191401118' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '77903'
                WHERE ordernumber = 'P200530191431522' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338056'
                WHERE ordernumber = 'P190530191609364' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393149'
                WHERE ordernumber = 'P190530191831860' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334547'
                WHERE ordernumber = 'P420530191832391' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334547'
                WHERE ordernumber = 'P420530192016153' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393151'
                WHERE ordernumber = 'P190530192332428' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393153'
                WHERE ordernumber = 'P190530192913244' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345869'
                WHERE ordernumber = 'P190530193055865' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393154'
                WHERE ordernumber = 'P190530193214472' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393155'
                WHERE ordernumber = 'P200530193354256' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393114'
                WHERE ordernumber = 'P190530193458817' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391200'
                WHERE ordernumber = 'P790530194003976' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393158'
                WHERE ordernumber = 'P190530194049265' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393156'
                WHERE ordernumber = 'P630530194202251' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393160'
                WHERE ordernumber = 'P200530194311292' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393159'
                WHERE ordernumber = 'P790530194328934' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393161'
                WHERE ordernumber = 'P790530194636444' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393164'
                WHERE ordernumber = 'P200530194856122' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393157'
                WHERE ordernumber = 'P710530195116199' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393162'
                WHERE ordernumber = 'P710530195506200' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393167'
                WHERE ordernumber = 'P630530195758944' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393168'
                WHERE ordernumber = 'P200530195855157' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393169'
                WHERE ordernumber = 'P200530200035421' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393171'
                WHERE ordernumber = 'P790530201750201' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393173'
                WHERE ordernumber = 'P790530203052847' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393172'
                WHERE ordernumber = 'P790530203127701' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '243173'
                WHERE ordernumber = 'P630530204116699' 
            
2024-05-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '206533'
                WHERE ordernumber = 'P710530210000392'