2023-12-20 01:00:03 -- 將會員中心id寫入data-lake
2023-12-20 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 '2023-12-19%';
        
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353410'
                WHERE ordernumber = 'P191219110540619' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353412'
                WHERE ordernumber = 'P191219110653547' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353413'
                WHERE ordernumber = 'P191219110826596' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253817'
                WHERE ordernumber = 'P201219111000513' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332938'
                WHERE ordernumber = 'P191219111022368' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332949'
                WHERE ordernumber = 'P191219111105385' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345908'
                WHERE ordernumber = 'P421219111322194' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353414'
                WHERE ordernumber = 'P421219111508818' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100834'
                WHERE ordernumber = 'P191219111513728' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311532'
                WHERE ordernumber = 'P181219111538294' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248386'
                WHERE ordernumber = 'P201219111548159' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133740'
                WHERE ordernumber = 'P201219111837381' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217707'
                WHERE ordernumber = 'P201219112006606' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275713'
                WHERE ordernumber = 'P181219112021363' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276007'
                WHERE ordernumber = 'P201219112041238' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353416'
                WHERE ordernumber = 'P191219112137410' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '18427'
                WHERE ordernumber = 'P421219112334637' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159315'
                WHERE ordernumber = 'P201219112405540' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353419'
                WHERE ordernumber = 'P191219112529541' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353418'
                WHERE ordernumber = 'P421219112529886' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212759'
                WHERE ordernumber = 'P191219113005164' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112794'
                WHERE ordernumber = 'P201219113152830' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353421'
                WHERE ordernumber = 'P201219113343267' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353295'
                WHERE ordernumber = 'P191219113408414' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112794'
                WHERE ordernumber = 'P201219113510724' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353423'
                WHERE ordernumber = 'P191219114015635' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353424'
                WHERE ordernumber = 'P201219114044436' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353426'
                WHERE ordernumber = 'P201219114240670' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301528'
                WHERE ordernumber = 'P421219114505903' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '59442'
                WHERE ordernumber = 'P191219114735142' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301704'
                WHERE ordernumber = 'P191219115308776' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282418'
                WHERE ordernumber = 'P201219115609899' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97052'
                WHERE ordernumber = 'P191219115708705' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353430'
                WHERE ordernumber = 'P201219115803451' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239321'
                WHERE ordernumber = 'P191219120423710' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353435'
                WHERE ordernumber = 'P421219120834752' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283472'
                WHERE ordernumber = 'P191219120851676' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353436'
                WHERE ordernumber = 'P201219121313190' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353437'
                WHERE ordernumber = 'P191219121343752' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105578'
                WHERE ordernumber = 'P201219122134154' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '84598'
                WHERE ordernumber = 'P191219122445406' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P191219122622575' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338412'
                WHERE ordernumber = 'P191219122721464' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208332'
                WHERE ordernumber = 'P191219123304801' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97477'
                WHERE ordernumber = 'P201219123310953' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165422'
                WHERE ordernumber = 'P201219123534813' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353441'
                WHERE ordernumber = 'P191219123934185' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111120'
                WHERE ordernumber = 'P201219124054155' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282966'
                WHERE ordernumber = 'P201219124415146' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353444'
                WHERE ordernumber = 'P191219124435160' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297714'
                WHERE ordernumber = 'P421219125121889' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300753'
                WHERE ordernumber = 'P201219125456201' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353448'
                WHERE ordernumber = 'P201219125605359' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299101'
                WHERE ordernumber = 'P191219125744629' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353450'
                WHERE ordernumber = 'P201219130431536' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303002'
                WHERE ordernumber = 'P201219130538610' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322201'
                WHERE ordernumber = 'P181219130717827' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353452'
                WHERE ordernumber = 'P421219130719586' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338908'
                WHERE ordernumber = 'P181219130929210' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353455'
                WHERE ordernumber = 'P201219131306806' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353456'
                WHERE ordernumber = 'P181219131437889' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352546'
                WHERE ordernumber = 'P181219131549214' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101781'
                WHERE ordernumber = 'P191219132318919' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353458'
                WHERE ordernumber = 'P191219132521955' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '56224'
                WHERE ordernumber = 'P201219133101738' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353461'
                WHERE ordernumber = 'P421219133212429' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '56224'
                WHERE ordernumber = 'P201219133217445' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353462'
                WHERE ordernumber = 'P181219133609667' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353463'
                WHERE ordernumber = 'P191219133820138' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P191219133850587' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276483'
                WHERE ordernumber = 'P191219134016345' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235059'
                WHERE ordernumber = 'P201219134328695' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251223'
                WHERE ordernumber = 'P191219135531257' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223929'
                WHERE ordernumber = 'P201219135712898' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353466'
                WHERE ordernumber = 'P191219135911427' 
            
2023-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353466'
                WHERE ordernumber = 'P191219140040451' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160114'
                WHERE ordernumber = 'P191219140155364' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329671'
                WHERE ordernumber = 'P191219140310566' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338431'
                WHERE ordernumber = 'P201219140425891' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353469'
                WHERE ordernumber = 'P191219140754592' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235985'
                WHERE ordernumber = 'P201219140803255' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353470'
                WHERE ordernumber = 'P191219141255557' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227749'
                WHERE ordernumber = 'P201219141644937' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353472'
                WHERE ordernumber = 'P201219141851798' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353470'
                WHERE ordernumber = 'P191219142059131' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353474'
                WHERE ordernumber = 'P201219142139333' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346845'
                WHERE ordernumber = 'P201219142439721' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '138233'
                WHERE ordernumber = 'P201219142540752' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353476'
                WHERE ordernumber = 'P201219142811775' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '127313'
                WHERE ordernumber = 'P191219143019858' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353480'
                WHERE ordernumber = 'P191219143451995' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353481'
                WHERE ordernumber = 'P421219143456624' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353483'
                WHERE ordernumber = 'P191219143929891' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353484'
                WHERE ordernumber = 'P191219144414558' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '144114'
                WHERE ordernumber = 'P191219144531378' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215024'
                WHERE ordernumber = 'P201219144729179' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215024'
                WHERE ordernumber = 'P201219144823956' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353487'
                WHERE ordernumber = 'P191219144931326' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353488'
                WHERE ordernumber = 'P201219145046250' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '315256'
                WHERE ordernumber = 'P201219145145891' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296878'
                WHERE ordernumber = 'P191219145554475' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277801'
                WHERE ordernumber = 'P201219145641654' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353490'
                WHERE ordernumber = 'P191219145907431' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353490'
                WHERE ordernumber = 'P191219150021956' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353491'
                WHERE ordernumber = 'P191219150205905' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247064'
                WHERE ordernumber = 'P201219150406945' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '78115'
                WHERE ordernumber = 'P201219150555725' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '78115'
                WHERE ordernumber = 'P201219150650540' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '268279'
                WHERE ordernumber = 'P201219150905763' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353492'
                WHERE ordernumber = 'P191219150921528' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334734'
                WHERE ordernumber = 'P191219151030442' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353493'
                WHERE ordernumber = 'P201219151100417' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344425'
                WHERE ordernumber = 'P191219151251738' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '209570'
                WHERE ordernumber = 'P191219151601799' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284402'
                WHERE ordernumber = 'P421219151712732' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95375'
                WHERE ordernumber = 'P191219153449436' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93976'
                WHERE ordernumber = 'P201219153655214' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247106'
                WHERE ordernumber = 'P191219153706853' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353496'
                WHERE ordernumber = 'P191219154513987' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298227'
                WHERE ordernumber = 'P191219154618705' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '129895'
                WHERE ordernumber = 'P191219154806669' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '141962'
                WHERE ordernumber = 'P201219154842393' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '107702'
                WHERE ordernumber = 'P201219155026496' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348780'
                WHERE ordernumber = 'P191219155040653' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '140858'
                WHERE ordernumber = 'P191219155314808' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353501'
                WHERE ordernumber = 'P191219155502306' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101435'
                WHERE ordernumber = 'P201219155539683' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278615'
                WHERE ordernumber = 'P191219155918145' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353502'
                WHERE ordernumber = 'P191219160117179' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214006'
                WHERE ordernumber = 'P201219160412460' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310882'
                WHERE ordernumber = 'P201219161221440' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248077'
                WHERE ordernumber = 'P191219161548839' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '328944'
                WHERE ordernumber = 'P201219161736234' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234324'
                WHERE ordernumber = 'P201219161918848' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353504'
                WHERE ordernumber = 'P191219162022137' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353505'
                WHERE ordernumber = 'P201219162305254' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353506'
                WHERE ordernumber = 'P191219162406901' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353507'
                WHERE ordernumber = 'P201219162428638' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353508'
                WHERE ordernumber = 'P201219162656551' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '322436'
                WHERE ordernumber = 'P191219162803978' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353428'
                WHERE ordernumber = 'P191219162932402' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237389'
                WHERE ordernumber = 'P201219163003844' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353428'
                WHERE ordernumber = 'P191219163025785' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353510'
                WHERE ordernumber = 'P191219163121930' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353511'
                WHERE ordernumber = 'P191219164027655' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352140'
                WHERE ordernumber = 'P421219164118871' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353514'
                WHERE ordernumber = 'P191219164436394' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353516'
                WHERE ordernumber = 'P191219165058880' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353517'
                WHERE ordernumber = 'P421219165339206' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353519'
                WHERE ordernumber = 'P191219165548476' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270176'
                WHERE ordernumber = 'P201219165601747' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305549'
                WHERE ordernumber = 'P421219170309179' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353520'
                WHERE ordernumber = 'P201219170329778' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104695'
                WHERE ordernumber = 'P191219170332932' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287446'
                WHERE ordernumber = 'P191219170514577' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '27604'
                WHERE ordernumber = 'P201219170808699' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167722'
                WHERE ordernumber = 'P191219170815850' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167722'
                WHERE ordernumber = 'P191219170858205' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353523'
                WHERE ordernumber = 'P191219171135571' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P181219171140377' 
            
2023-12-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353524'
                WHERE ordernumber = 'P191219171416504' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353525'
                WHERE ordernumber = 'P191219171603408' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '226130'
                WHERE ordernumber = 'P191219171740310' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '95460'
                WHERE ordernumber = 'P191219171941761' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '349107'
                WHERE ordernumber = 'P421219172153539' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353528'
                WHERE ordernumber = 'P201219172713590' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353529'
                WHERE ordernumber = 'P421219172826374' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '252077'
                WHERE ordernumber = 'P191219172840333' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '303757'
                WHERE ordernumber = 'P191219173045600' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '342512'
                WHERE ordernumber = 'P191219173235599' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '248384'
                WHERE ordernumber = 'P201219173458349' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353531'
                WHERE ordernumber = 'P191219173734132' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350048'
                WHERE ordernumber = 'P201219173836722' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353532'
                WHERE ordernumber = 'P191219174017222' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '319816'
                WHERE ordernumber = 'P201219174103758' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353534'
                WHERE ordernumber = 'P421219174246924' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353536'
                WHERE ordernumber = 'P191219174358804' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353538'
                WHERE ordernumber = 'P191219174812689' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353539'
                WHERE ordernumber = 'P201219175201593' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '248977'
                WHERE ordernumber = 'P201219175452851' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '99149'
                WHERE ordernumber = 'P191219175700372' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '81699'
                WHERE ordernumber = 'P191219175850990' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '219277'
                WHERE ordernumber = 'P201219175901136' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353541'
                WHERE ordernumber = 'P421219180743198' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '341236'
                WHERE ordernumber = 'P191219180808293' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353542'
                WHERE ordernumber = 'P201219181829708' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353544'
                WHERE ordernumber = 'P201219182201476' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '134844'
                WHERE ordernumber = 'P421219182259436' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353546'
                WHERE ordernumber = 'P191219182537140' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P191219182751393' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '339987'
                WHERE ordernumber = 'P201219182755283' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '319534'
                WHERE ordernumber = 'P421219182820146' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '58674'
                WHERE ordernumber = 'P201219183128220' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '258620'
                WHERE ordernumber = 'P201219183427190' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '234101'
                WHERE ordernumber = 'P201219183617768' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353550'
                WHERE ordernumber = 'P201219183812962' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353232'
                WHERE ordernumber = 'P201219184747550' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353554'
                WHERE ordernumber = 'P191219185010475' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353558'
                WHERE ordernumber = 'P201219185922692' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '89059'
                WHERE ordernumber = 'P201219190038937' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353559'
                WHERE ordernumber = 'P191219190129422' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '310242'
                WHERE ordernumber = 'P201219190333647' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '99060'
                WHERE ordernumber = 'P201219190654378' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '299840'
                WHERE ordernumber = 'P201219190759784' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '299840'
                WHERE ordernumber = 'P201219190836937' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353562'
                WHERE ordernumber = 'P201219191017590' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '274943'
                WHERE ordernumber = 'P191219191049823' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353563'
                WHERE ordernumber = 'P201219191330795' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '237681'
                WHERE ordernumber = 'P191219192035307' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '349828'
                WHERE ordernumber = 'P201219192237440' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353566'
                WHERE ordernumber = 'P201219192421958' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353564'
                WHERE ordernumber = 'P201219192533228' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '245271'
                WHERE ordernumber = 'P201219192618950' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353569'
                WHERE ordernumber = 'P201219193838166' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '290331'
                WHERE ordernumber = 'P201219193938408' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353570'
                WHERE ordernumber = 'P201219194154908' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '136257'
                WHERE ordernumber = 'P201219194357774' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353502'
                WHERE ordernumber = 'P191219194429698' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '143813'
                WHERE ordernumber = 'P191219194639806' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '127043'
                WHERE ordernumber = 'P191219194800229' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353571'
                WHERE ordernumber = 'P201219194955636' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353572'
                WHERE ordernumber = 'P201219195104997' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353573'
                WHERE ordernumber = 'P201219195527937' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353575'
                WHERE ordernumber = 'P201219195954329' 
            
2023-12-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353577'
                WHERE ordernumber = 'P191219200707786'