2024-07-30 01:00:03 -- 將會員中心id寫入data-lake
2024-07-30 01:00:03 -- 
            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-07-29%';
        
2024-07-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384207'
                WHERE ordernumber = 'P630729103732389' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245652'
                WHERE ordernumber = 'P200729110025517' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200729110136947' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403755'
                WHERE ordernumber = 'P200729110318603' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403757'
                WHERE ordernumber = 'P200729110452728' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159343'
                WHERE ordernumber = 'P180729110513483' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403758'
                WHERE ordernumber = 'P190729110550724' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344250'
                WHERE ordernumber = 'P180729110623511' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296158'
                WHERE ordernumber = 'P180729110710816' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403760'
                WHERE ordernumber = 'P180729111135444' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354202'
                WHERE ordernumber = 'P200729111342443' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '202853'
                WHERE ordernumber = 'P420729111457332' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294695'
                WHERE ordernumber = 'P200729111522138' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100292'
                WHERE ordernumber = 'P180729111537323' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173627'
                WHERE ordernumber = 'P180729112111793' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403761'
                WHERE ordernumber = 'P190729112843319' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190729113100273' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403763'
                WHERE ordernumber = 'P420729113246663' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403765'
                WHERE ordernumber = 'P180729113523686' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306214'
                WHERE ordernumber = 'P180729113648144' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403766'
                WHERE ordernumber = 'P420729113810352' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388894'
                WHERE ordernumber = 'P180729114729225' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403768'
                WHERE ordernumber = 'P200729114818498' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299703'
                WHERE ordernumber = 'P200729115054885' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403769'
                WHERE ordernumber = 'P180729120214472' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403770'
                WHERE ordernumber = 'P420729120321782' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402530'
                WHERE ordernumber = 'P420729120706715' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354444'
                WHERE ordernumber = 'P180729120758246' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403188'
                WHERE ordernumber = 'P630729120919762' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403771'
                WHERE ordernumber = 'P200729121346604' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235837'
                WHERE ordernumber = 'P180729121449370' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403772'
                WHERE ordernumber = 'P180729121632210' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403773'
                WHERE ordernumber = 'P420729122213454' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243579'
                WHERE ordernumber = 'P200729122241460' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403775'
                WHERE ordernumber = 'P420729122511827' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403776'
                WHERE ordernumber = 'P420729122853787' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297380'
                WHERE ordernumber = 'P420729123309563' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403777'
                WHERE ordernumber = 'P180729123505804' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297233'
                WHERE ordernumber = 'P420729123622690' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403778'
                WHERE ordernumber = 'P630729123727890' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99512'
                WHERE ordernumber = 'P180729123728897' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106706'
                WHERE ordernumber = 'P420729124114171' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401277'
                WHERE ordernumber = 'P180729124646888' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403781'
                WHERE ordernumber = 'P180729125254178' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342020'
                WHERE ordernumber = 'P200729125839323' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403785'
                WHERE ordernumber = 'P420729130828820' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390480'
                WHERE ordernumber = 'P180729130835483' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344600'
                WHERE ordernumber = 'P200729130842256' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '8776'
                WHERE ordernumber = 'P180729130958921' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180729131102669' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401645'
                WHERE ordernumber = 'P190729131135218' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102473'
                WHERE ordernumber = 'P180729131256590' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '36170'
                WHERE ordernumber = 'P180729131843465' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242916'
                WHERE ordernumber = 'P190729131910617' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403788'
                WHERE ordernumber = 'P200729132100892' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403789'
                WHERE ordernumber = 'P200729132200613' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218716'
                WHERE ordernumber = 'P200729132358487' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297157'
                WHERE ordernumber = 'P420729133152314' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403791'
                WHERE ordernumber = 'P420729133258137' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286124'
                WHERE ordernumber = 'P180729133602969' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403795'
                WHERE ordernumber = 'P420729134453209' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '52369'
                WHERE ordernumber = 'P180729134515466' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403796'
                WHERE ordernumber = 'P200729134539542' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '52369'
                WHERE ordernumber = 'P180729134625572' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129132'
                WHERE ordernumber = 'P180729135000165' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403797'
                WHERE ordernumber = 'P630729135114285' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272489'
                WHERE ordernumber = 'P200729135249896' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391832'
                WHERE ordernumber = 'P180729135255724' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403798'
                WHERE ordernumber = 'P180729135636588' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403802'
                WHERE ordernumber = 'P180729140235709' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403804'
                WHERE ordernumber = 'P180729140414741' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288090'
                WHERE ordernumber = 'P180729140512726' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403807'
                WHERE ordernumber = 'P180729140700595' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318048'
                WHERE ordernumber = 'P200729141706385' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319896'
                WHERE ordernumber = 'P420729142532190' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369507'
                WHERE ordernumber = 'P420729142650787' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374169'
                WHERE ordernumber = 'P200729142717447' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403809'
                WHERE ordernumber = 'P200729142829136' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403811'
                WHERE ordernumber = 'P420729143342858' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '198834'
                WHERE ordernumber = 'P180729143957801' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403813'
                WHERE ordernumber = 'P180729144138218' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '198834'
                WHERE ordernumber = 'P180729144330753' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403816'
                WHERE ordernumber = 'P200729144756159' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244559'
                WHERE ordernumber = 'P180729145251328' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293528'
                WHERE ordernumber = 'P180729145335201' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352784'
                WHERE ordernumber = 'P420729145544540' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338766'
                WHERE ordernumber = 'P180729145955652' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403494'
                WHERE ordernumber = 'P180729150229508' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403819'
                WHERE ordernumber = 'P200729150353346' 
            
2024-07-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279863'
                WHERE ordernumber = 'P200729150716471' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403778'
                WHERE ordernumber = 'P630729150821244' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97445'
                WHERE ordernumber = 'P180729150848918' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403821'
                WHERE ordernumber = 'P180729151004513' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403778'
                WHERE ordernumber = 'P630729151740516' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128554'
                WHERE ordernumber = 'P590729151743133' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403823'
                WHERE ordernumber = 'P180729151844153' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403823'
                WHERE ordernumber = 'P180729151919405' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403824'
                WHERE ordernumber = 'P180729152102352' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403824'
                WHERE ordernumber = 'P180729152258192' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403825'
                WHERE ordernumber = 'P420729152326450' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403828'
                WHERE ordernumber = 'P180729153009670' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403829'
                WHERE ordernumber = 'P420729153221472' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340276'
                WHERE ordernumber = 'P420729154255529' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103320'
                WHERE ordernumber = 'P180729154353205' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297135'
                WHERE ordernumber = 'P420729154503827' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403832'
                WHERE ordernumber = 'P420729155253890' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343179'
                WHERE ordernumber = 'P180729155555829' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403834'
                WHERE ordernumber = 'P200729160111669' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403835'
                WHERE ordernumber = 'P420729160132750' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349169'
                WHERE ordernumber = 'P180729160145871' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '71878'
                WHERE ordernumber = 'P200729161032898' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '156737'
                WHERE ordernumber = 'P180729161251884' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403838'
                WHERE ordernumber = 'P180729161523264' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403839'
                WHERE ordernumber = 'P420729161742234' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403841'
                WHERE ordernumber = 'P180729162149244' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '85093'
                WHERE ordernumber = 'P200729162420208' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403843'
                WHERE ordernumber = 'P420729162552338' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403844'
                WHERE ordernumber = 'P180729162830675' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342834'
                WHERE ordernumber = 'P420729163128392' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403845'
                WHERE ordernumber = 'P200729163458361' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403846'
                WHERE ordernumber = 'P180729163504371' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403847'
                WHERE ordernumber = 'P420729163744912' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '122761'
                WHERE ordernumber = 'P420729163930966' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215837'
                WHERE ordernumber = 'P190729164229535' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388031'
                WHERE ordernumber = 'P180729164506154' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314499'
                WHERE ordernumber = 'P190729164826822' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403745'
                WHERE ordernumber = 'P180729164912543' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403848'
                WHERE ordernumber = 'P190729165028464' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403853'
                WHERE ordernumber = 'P180729165234608' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167176'
                WHERE ordernumber = 'P200729165504767' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403854'
                WHERE ordernumber = 'P630729165519241' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402876'
                WHERE ordernumber = 'P590729165555177' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403855'
                WHERE ordernumber = 'P200729165603113' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '88636'
                WHERE ordernumber = 'P190729170152776' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381595'
                WHERE ordernumber = 'P420729170417520' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305246'
                WHERE ordernumber = 'P200729170719929' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403858'
                WHERE ordernumber = 'P180729170945236' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403857'
                WHERE ordernumber = 'P200729171007925' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403859'
                WHERE ordernumber = 'P200729171449809' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398582'
                WHERE ordernumber = 'P190729171607293' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403860'
                WHERE ordernumber = 'P180729171615348' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403861'
                WHERE ordernumber = 'P200729171627878' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346209'
                WHERE ordernumber = 'P420729171808925' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '223545'
                WHERE ordernumber = 'P180729171959238' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403862'
                WHERE ordernumber = 'P420729172124580' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248440'
                WHERE ordernumber = 'P180729172145790' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403863'
                WHERE ordernumber = 'P200729172307173' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403864'
                WHERE ordernumber = 'P180729172546202' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '77799'
                WHERE ordernumber = 'P180729172749489' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286880'
                WHERE ordernumber = 'P200729172804313' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '246143'
                WHERE ordernumber = 'P200729173008444' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368215'
                WHERE ordernumber = 'P420729173226321' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403866'
                WHERE ordernumber = 'P180729173514194' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334890'
                WHERE ordernumber = 'P200729173757641' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200729173935937' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403869'
                WHERE ordernumber = 'P200729174216521' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101291'
                WHERE ordernumber = 'P420729174259549' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '111134'
                WHERE ordernumber = 'P180729174411454' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '111134'
                WHERE ordernumber = 'P180729174502637' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '138130'
                WHERE ordernumber = 'P420729174647632' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P420729175110372' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403138'
                WHERE ordernumber = 'P200729175320746' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342089'
                WHERE ordernumber = 'P200729175514228' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P420729175524793' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403873'
                WHERE ordernumber = 'P180729175704722' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403874'
                WHERE ordernumber = 'P630729175808211' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '114779'
                WHERE ordernumber = 'P180729180053478' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366800'
                WHERE ordernumber = 'P180729180135287' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329832'
                WHERE ordernumber = 'P420729180140714' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P180729180758384' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96007'
                WHERE ordernumber = 'P180729180858871' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P180729180926364' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403875'
                WHERE ordernumber = 'P200729180944244' 
            
2024-07-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221027'
                WHERE ordernumber = 'P630729181059914' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '144265'
                WHERE ordernumber = 'P420729182405848' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403876'
                WHERE ordernumber = 'P420729182811805' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403878'
                WHERE ordernumber = 'P420729183840691' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403878'
                WHERE ordernumber = 'P420729184014809' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '299923'
                WHERE ordernumber = 'P200729184250162' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '199835'
                WHERE ordernumber = 'P420729184328926' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403880'
                WHERE ordernumber = 'P200729184426823' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '139001'
                WHERE ordernumber = 'P200729185027462' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403882'
                WHERE ordernumber = 'P200729185533571' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '240726'
                WHERE ordernumber = 'P190729185556577' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403875'
                WHERE ordernumber = 'P200729185829630' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402618'
                WHERE ordernumber = 'P190729190346433' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403885'
                WHERE ordernumber = 'P200729190818587' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386814'
                WHERE ordernumber = 'P630729190914957' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '306397'
                WHERE ordernumber = 'P190729190927509' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '381870'
                WHERE ordernumber = 'P190729191340756' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403889'
                WHERE ordernumber = 'P190729191531563' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403890'
                WHERE ordernumber = 'P200729191603999' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '96452'
                WHERE ordernumber = 'P190729191801497' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '392009'
                WHERE ordernumber = 'P190729191918588' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '117205'
                WHERE ordernumber = 'P200729192005371' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403891'
                WHERE ordernumber = 'P190729192213635' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403892'
                WHERE ordernumber = 'P200729192813937' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '113510'
                WHERE ordernumber = 'P190729192910958' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '229208'
                WHERE ordernumber = 'P190729193512492' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '202561'
                WHERE ordernumber = 'P190729193753577' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '158000'
                WHERE ordernumber = 'P200729193942603' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '382885'
                WHERE ordernumber = 'P190729194719966' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403903'
                WHERE ordernumber = 'P190729195701298' 
            
2024-07-30 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403903'
                WHERE ordernumber = 'P190729195805706'