2024-04-08 01:00:02 -- 將會員中心id寫入data-lake
2024-04-08 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-04-07%';
        
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90803'
                WHERE ordernumber = 'P630407103341992' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384714'
                WHERE ordernumber = 'P420407105231150' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368806'
                WHERE ordernumber = 'P420407105558238' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316199'
                WHERE ordernumber = 'P200407110158816' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93821'
                WHERE ordernumber = 'P180407111820882' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100292'
                WHERE ordernumber = 'P190407112414730' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384715'
                WHERE ordernumber = 'P420407112653280' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286955'
                WHERE ordernumber = 'P180407112953253' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368176'
                WHERE ordernumber = 'P420407112955207' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282361'
                WHERE ordernumber = 'P200407113313195' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279040'
                WHERE ordernumber = 'P180407115310789' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384718'
                WHERE ordernumber = 'P180407115508962' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112218'
                WHERE ordernumber = 'P190407115556632' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384719'
                WHERE ordernumber = 'P180407120259727' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274876'
                WHERE ordernumber = 'P200407120756825' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384720'
                WHERE ordernumber = 'P180407121054192' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384721'
                WHERE ordernumber = 'P190407121245696' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384722'
                WHERE ordernumber = 'P420407121531616' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384724'
                WHERE ordernumber = 'P420407122346785' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238570'
                WHERE ordernumber = 'P200407122432271' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98582'
                WHERE ordernumber = 'P200407123255130' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384725'
                WHERE ordernumber = 'P180407123351750' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384726'
                WHERE ordernumber = 'P420407123828768' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384727'
                WHERE ordernumber = 'P420407124139418' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384728'
                WHERE ordernumber = 'P200407124353285' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124325'
                WHERE ordernumber = 'P190407125204235' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '59442'
                WHERE ordernumber = 'P180407131715364' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384731'
                WHERE ordernumber = 'P200407131858465' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384732'
                WHERE ordernumber = 'P420407132129479' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337863'
                WHERE ordernumber = 'P420407132249656' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384733'
                WHERE ordernumber = 'P420407132523999' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384393'
                WHERE ordernumber = 'P180407132642889' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180407133235435' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384736'
                WHERE ordernumber = 'P420407133650212' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383056'
                WHERE ordernumber = 'P200407133901741' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383990'
                WHERE ordernumber = 'P630407134425311' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384738'
                WHERE ordernumber = 'P420407134443297' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309583'
                WHERE ordernumber = 'P180407134620773' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264675'
                WHERE ordernumber = 'P180407134947809' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384739'
                WHERE ordernumber = 'P630407135146516' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244337'
                WHERE ordernumber = 'P180407135235650' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384737'
                WHERE ordernumber = 'P180407135500280' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382806'
                WHERE ordernumber = 'P180407135527510' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231332'
                WHERE ordernumber = 'P190407135701111' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219117'
                WHERE ordernumber = 'P190407135812773' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384740'
                WHERE ordernumber = 'P190407135917334' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276748'
                WHERE ordernumber = 'P420407140209369' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '203253'
                WHERE ordernumber = 'P200407140335809' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340679'
                WHERE ordernumber = 'P180407140636681' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279300'
                WHERE ordernumber = 'P200407141058202' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384742'
                WHERE ordernumber = 'P200407141451785' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277769'
                WHERE ordernumber = 'P200407141639248' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383615'
                WHERE ordernumber = 'P180407141940655' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292480'
                WHERE ordernumber = 'P630407142017329' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302233'
                WHERE ordernumber = 'P420407142119705' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368687'
                WHERE ordernumber = 'P420407142235565' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280038'
                WHERE ordernumber = 'P180407142249832' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384743'
                WHERE ordernumber = 'P630407142258799' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384744'
                WHERE ordernumber = 'P190407142502589' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219678'
                WHERE ordernumber = 'P200407142901502' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291340'
                WHERE ordernumber = 'P180407143255788' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380791'
                WHERE ordernumber = 'P180407143526548' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384745'
                WHERE ordernumber = 'P590407143719322' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346901'
                WHERE ordernumber = 'P420407143847421' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '197126'
                WHERE ordernumber = 'P420407144031186' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380686'
                WHERE ordernumber = 'P630407144104675' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384747'
                WHERE ordernumber = 'P420407145111244' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285923'
                WHERE ordernumber = 'P180407145332896' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384748'
                WHERE ordernumber = 'P200407145516900' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384749'
                WHERE ordernumber = 'P180407145706617' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P190407145834116' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384750'
                WHERE ordernumber = 'P200407145911681' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384751'
                WHERE ordernumber = 'P180407150235611' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384753'
                WHERE ordernumber = 'P420407150446495' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384752'
                WHERE ordernumber = 'P200407150446779' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241808'
                WHERE ordernumber = 'P200407150525445' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384754'
                WHERE ordernumber = 'P200407150931219' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384754'
                WHERE ordernumber = 'P200407151052603' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121839'
                WHERE ordernumber = 'P200407151437742' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212791'
                WHERE ordernumber = 'P180407151458229' 
            
2024-04-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384755'
                WHERE ordernumber = 'P420407151541615' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346410'
                WHERE ordernumber = 'P180407151607997' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384756'
                WHERE ordernumber = 'P630407151704515' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340762'
                WHERE ordernumber = 'P180407151812745' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384754'
                WHERE ordernumber = 'P200407151839340' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325160'
                WHERE ordernumber = 'P420407151959531' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346410'
                WHERE ordernumber = 'P180407152136761' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382923'
                WHERE ordernumber = 'P180407152351457' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382923'
                WHERE ordernumber = 'P190407152516835' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163759'
                WHERE ordernumber = 'P200407152526638' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384758'
                WHERE ordernumber = 'P420407152633574' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384449'
                WHERE ordernumber = 'P180407152647275' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311650'
                WHERE ordernumber = 'P200407152743454' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384759'
                WHERE ordernumber = 'P420407153323154' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384760'
                WHERE ordernumber = 'P180407153634759' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281958'
                WHERE ordernumber = 'P190407153722841' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384761'
                WHERE ordernumber = 'P630407153841139' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214135'
                WHERE ordernumber = 'P630407153919528' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269450'
                WHERE ordernumber = 'P200407154259299' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258197'
                WHERE ordernumber = 'P630407154442329' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384762'
                WHERE ordernumber = 'P180407154508146' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149389'
                WHERE ordernumber = 'P200407154603327' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275905'
                WHERE ordernumber = 'P420407154843197' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335196'
                WHERE ordernumber = 'P180407154913991' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382338'
                WHERE ordernumber = 'P630407155004629' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97572'
                WHERE ordernumber = 'P200407155524163' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157227'
                WHERE ordernumber = 'P200407155600610' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102691'
                WHERE ordernumber = 'P200407155714248' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281733'
                WHERE ordernumber = 'P180407155735378' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384763'
                WHERE ordernumber = 'P180407155853983' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384764'
                WHERE ordernumber = 'P420407160247368' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381493'
                WHERE ordernumber = 'P420407160420486' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311061'
                WHERE ordernumber = 'P180407160422917' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384765'
                WHERE ordernumber = 'P200407160531843' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384766'
                WHERE ordernumber = 'P420407161633403' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384767'
                WHERE ordernumber = 'P420407162515655' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384768'
                WHERE ordernumber = 'P420407162944714' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382486'
                WHERE ordernumber = 'P200407163418149' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293682'
                WHERE ordernumber = 'P200407163801347' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283692'
                WHERE ordernumber = 'P200407164113340' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384770'
                WHERE ordernumber = 'P420407164302923' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378766'
                WHERE ordernumber = 'P200407164522909' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384772'
                WHERE ordernumber = 'P420407164524177' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384773'
                WHERE ordernumber = 'P420407164707930' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373242'
                WHERE ordernumber = 'P420407165007228' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213665'
                WHERE ordernumber = 'P630407165145455' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384711'
                WHERE ordernumber = 'P200407165322397' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379367'
                WHERE ordernumber = 'P420407165707957' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384774'
                WHERE ordernumber = 'P420407165854495' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340315'
                WHERE ordernumber = 'P200407170438149' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384776'
                WHERE ordernumber = 'P420407170448708' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229352'
                WHERE ordernumber = 'P180407170602265' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384777'
                WHERE ordernumber = 'P180407170959538' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384778'
                WHERE ordernumber = 'P180407171119975' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382139'
                WHERE ordernumber = 'P200407171159856' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383126'
                WHERE ordernumber = 'P420407171237631' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309530'
                WHERE ordernumber = 'P180407171400151' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286464'
                WHERE ordernumber = 'P180407171558937' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384780'
                WHERE ordernumber = 'P180407172857421' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384781'
                WHERE ordernumber = 'P190407173316409' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109020'
                WHERE ordernumber = 'P180407173413711' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384782'
                WHERE ordernumber = 'P200407173512116' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '49080'
                WHERE ordernumber = 'P190407174026595' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384783'
                WHERE ordernumber = 'P590407174126512' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304369'
                WHERE ordernumber = 'P200407174216878' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384784'
                WHERE ordernumber = 'P190407174517366' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384785'
                WHERE ordernumber = 'P590407174836925' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384786'
                WHERE ordernumber = 'P180407175208135' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228197'
                WHERE ordernumber = 'P190407175317231' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384768'
                WHERE ordernumber = 'P420407175317255' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384787'
                WHERE ordernumber = 'P180407175536274' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384789'
                WHERE ordernumber = 'P420407180245447' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380016'
                WHERE ordernumber = 'P200407180345580' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384791'
                WHERE ordernumber = 'P180407180534550' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384792'
                WHERE ordernumber = 'P200407180655162' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384794'
                WHERE ordernumber = 'P180407181737141' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384795'
                WHERE ordernumber = 'P630407181828483' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384796'
                WHERE ordernumber = 'P180407182336577' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384798'
                WHERE ordernumber = 'P180407182624124' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384797'
                WHERE ordernumber = 'P200407182858809' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373451'
                WHERE ordernumber = 'P420407183129721' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348730'
                WHERE ordernumber = 'P180407183203998' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384800'
                WHERE ordernumber = 'P190407184233949' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384801'
                WHERE ordernumber = 'P420407184343842' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165672'
                WHERE ordernumber = 'P630407184359986' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384802'
                WHERE ordernumber = 'P190407184512321' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131414'
                WHERE ordernumber = 'P190407184943260' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383378'
                WHERE ordernumber = 'P190407185446423' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200407185724244' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97867'
                WHERE ordernumber = 'P420407190943907' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384804'
                WHERE ordernumber = 'P420407191311492' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384805'
                WHERE ordernumber = 'P420407191645958' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378725'
                WHERE ordernumber = 'P190407191854719' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384808'
                WHERE ordernumber = 'P630407203443879' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383170'
                WHERE ordernumber = 'P630407204933916' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '156938'
                WHERE ordernumber = 'P590407205238893' 
            
2024-04-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377501'
                WHERE ordernumber = 'P630407205921977'