2024-10-08 01:00:02 -- 將會員中心id寫入data-lake
2024-10-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-10-07%';
        
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407903'
                WHERE ordernumber = 'P421007110122308' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315690'
                WHERE ordernumber = 'P201007110303518' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401994'
                WHERE ordernumber = 'P421007110609964' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424598'
                WHERE ordernumber = 'P201007110803743' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424599'
                WHERE ordernumber = 'P181007111056927' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424600'
                WHERE ordernumber = 'P711007111525434' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245997'
                WHERE ordernumber = 'P181007111730117' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '156431'
                WHERE ordernumber = 'P711007111735896' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231268'
                WHERE ordernumber = 'P181007111751380' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424601'
                WHERE ordernumber = 'P181007111855936' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162149'
                WHERE ordernumber = 'P711007111943928' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105630'
                WHERE ordernumber = 'P201007112135782' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255002'
                WHERE ordernumber = 'P181007112211978' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268836'
                WHERE ordernumber = 'P181007112917200' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424604'
                WHERE ordernumber = 'P181007113101279' 
            
2024-10-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '122246'
                WHERE ordernumber = 'P201007113420467' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424603'
                WHERE ordernumber = 'P181007113616903' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403059'
                WHERE ordernumber = 'P191007115029648' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253784'
                WHERE ordernumber = 'P181007115918982' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314651'
                WHERE ordernumber = 'P191007120248624' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424607'
                WHERE ordernumber = 'P201007120253688' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342428'
                WHERE ordernumber = 'P421007120323222' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39181'
                WHERE ordernumber = 'P181007121017459' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424612'
                WHERE ordernumber = 'P191007121527633' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P421007121909987' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424609'
                WHERE ordernumber = 'P181007121947563' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424613'
                WHERE ordernumber = 'P201007121958426' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424614'
                WHERE ordernumber = 'P201007122044632' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424615'
                WHERE ordernumber = 'P181007123036627' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423763'
                WHERE ordernumber = 'P421007123312327' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388774'
                WHERE ordernumber = 'P201007123315755' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424618'
                WHERE ordernumber = 'P421007124656252' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424619'
                WHERE ordernumber = 'P201007125058788' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424621'
                WHERE ordernumber = 'P421007125104392' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401740'
                WHERE ordernumber = 'P201007125133249' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356336'
                WHERE ordernumber = 'P421007125226552' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342979'
                WHERE ordernumber = 'P181007130013174' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424624'
                WHERE ordernumber = 'P201007130541779' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '193524'
                WHERE ordernumber = 'P201007131210927' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89059'
                WHERE ordernumber = 'P201007131408530' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344013'
                WHERE ordernumber = 'P421007131419942' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400212'
                WHERE ordernumber = 'P201007131454638' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306583'
                WHERE ordernumber = 'P201007131923636' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424625'
                WHERE ordernumber = 'P421007132225807' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397006'
                WHERE ordernumber = 'P181007132425607' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424629'
                WHERE ordernumber = 'P421007133432648' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369334'
                WHERE ordernumber = 'P631007134607814' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273583'
                WHERE ordernumber = 'P201007134706212' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424632'
                WHERE ordernumber = 'P421007140100404' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400532'
                WHERE ordernumber = 'P731007140229850' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82548'
                WHERE ordernumber = 'P201007140513583' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400352'
                WHERE ordernumber = 'P201007140641240' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377649'
                WHERE ordernumber = 'P181007141049144' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424633'
                WHERE ordernumber = 'P421007141618980' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211344'
                WHERE ordernumber = 'P181007141755680' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424633'
                WHERE ordernumber = 'P421007142131788' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214193'
                WHERE ordernumber = 'P181007142143114' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368009'
                WHERE ordernumber = 'P201007142144468' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136122'
                WHERE ordernumber = 'P201007142514167' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424635'
                WHERE ordernumber = 'P181007142650810' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424636'
                WHERE ordernumber = 'P201007142734764' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424639'
                WHERE ordernumber = 'P201007143409341' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424638'
                WHERE ordernumber = 'P711007143421222' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239481'
                WHERE ordernumber = 'P181007143440442' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424635'
                WHERE ordernumber = 'P181007143929211' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424640'
                WHERE ordernumber = 'P421007145151933' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299722'
                WHERE ordernumber = 'P711007145840659' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424642'
                WHERE ordernumber = 'P201007145843252' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424643'
                WHERE ordernumber = 'P731007150216927' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280260'
                WHERE ordernumber = 'P191007150312499' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424644'
                WHERE ordernumber = 'P191007150515570' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406154'
                WHERE ordernumber = 'P181007150617600' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212031'
                WHERE ordernumber = 'P731007150749169' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424646'
                WHERE ordernumber = 'P191007151141520' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266880'
                WHERE ordernumber = 'P191007151556457' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424647'
                WHERE ordernumber = 'P421007151914804' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153549'
                WHERE ordernumber = 'P731007152120896' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355717'
                WHERE ordernumber = 'P181007152324587' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424651'
                WHERE ordernumber = 'P181007153315433' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424653'
                WHERE ordernumber = 'P421007153359940' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424650'
                WHERE ordernumber = 'P181007153407919' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411724'
                WHERE ordernumber = 'P201007153446171' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424652'
                WHERE ordernumber = 'P421007153709250' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350350'
                WHERE ordernumber = 'P421007154151695' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399870'
                WHERE ordernumber = 'P201007154243402' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424655'
                WHERE ordernumber = 'P421007154315144' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424655'
                WHERE ordernumber = 'P421007154428608' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424656'
                WHERE ordernumber = 'P711007154713481' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424657'
                WHERE ordernumber = 'P421007155424908' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424659'
                WHERE ordernumber = 'P421007160336410' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424379'
                WHERE ordernumber = 'P201007160815814' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424658'
                WHERE ordernumber = 'P191007160854794' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424661'
                WHERE ordernumber = 'P421007161521295' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424662'
                WHERE ordernumber = 'P181007162716246' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424664'
                WHERE ordernumber = 'P421007162745320' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422310'
                WHERE ordernumber = 'P201007163529860' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306773'
                WHERE ordernumber = 'P181007164204673' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287386'
                WHERE ordernumber = 'P181007165329415' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386114'
                WHERE ordernumber = 'P191007165507228' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304185'
                WHERE ordernumber = 'P201007165623113' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424668'
                WHERE ordernumber = 'P181007170357895' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424670'
                WHERE ordernumber = 'P201007171016366' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254453'
                WHERE ordernumber = 'P201007171420712' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401701'
                WHERE ordernumber = 'P421007171606789' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424671'
                WHERE ordernumber = 'P421007171751844' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422597'
                WHERE ordernumber = 'P201007171929745' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286626'
                WHERE ordernumber = 'P191007172500773' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424673'
                WHERE ordernumber = 'P201007172601789' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286626'
                WHERE ordernumber = 'P191007172754953' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424673'
                WHERE ordernumber = 'P201007172840540' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424673'
                WHERE ordernumber = 'P201007173005967' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424675'
                WHERE ordernumber = 'P421007173851878' 
            
2024-10-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84172'
                WHERE ordernumber = 'P201007174354508' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P191007174449856' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214117'
                WHERE ordernumber = 'P181007174714971' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422544'
                WHERE ordernumber = 'P711007174736370' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417386'
                WHERE ordernumber = 'P201007174801851' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '175432'
                WHERE ordernumber = 'P711007175031549' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137509'
                WHERE ordernumber = 'P191007175128620' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313776'
                WHERE ordernumber = 'P181007175136456' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424678'
                WHERE ordernumber = 'P191007175317696' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424677'
                WHERE ordernumber = 'P181007175449896' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299544'
                WHERE ordernumber = 'P191007175701666' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424679'
                WHERE ordernumber = 'P631007175923808' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424682'
                WHERE ordernumber = 'P201007180458530' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424519'
                WHERE ordernumber = 'P421007181044520' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220362'
                WHERE ordernumber = 'P181007181414688' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424683'
                WHERE ordernumber = 'P711007181428722' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P201007181449445' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324732'
                WHERE ordernumber = 'P421007181833352' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220362'
                WHERE ordernumber = 'P181007181905298' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424686'
                WHERE ordernumber = 'P731007182108525' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98293'
                WHERE ordernumber = 'P201007182219462' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375132'
                WHERE ordernumber = 'P711007182310225' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302825'
                WHERE ordernumber = 'P201007182817493' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296819'
                WHERE ordernumber = 'P421007182856394' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424687'
                WHERE ordernumber = 'P191007183807239' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394393'
                WHERE ordernumber = 'P191007184248556' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424688'
                WHERE ordernumber = 'P421007184328631' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242782'
                WHERE ordernumber = 'P181007184552610' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424689'
                WHERE ordernumber = 'P631007185242978' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424691'
                WHERE ordernumber = 'P711007185837896' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424690'
                WHERE ordernumber = 'P421007190014685' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216410'
                WHERE ordernumber = 'P201007190108183' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232612'
                WHERE ordernumber = 'P711007190358599' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140510'
                WHERE ordernumber = 'P191007190406592' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355659'
                WHERE ordernumber = 'P191007190840856' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424693'
                WHERE ordernumber = 'P731007192616984' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424694'
                WHERE ordernumber = 'P201007193201268' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393538'
                WHERE ordernumber = 'P191007194430419' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215948'
                WHERE ordernumber = 'P191007195116742' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424697'
                WHERE ordernumber = 'P191007195545185' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230554'
                WHERE ordernumber = 'P191007195636624' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424701'
                WHERE ordernumber = 'P731007205441959' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424702'
                WHERE ordernumber = 'P711007205713728' 
            
2024-10-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421596'
                WHERE ordernumber = 'P731007212816952'