2024-06-02 01:00:02 -- 將會員中心id寫入data-lake
2024-06-02 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-06-01%';
        
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393433'
                WHERE ordernumber = 'P630601100627901' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241808'
                WHERE ordernumber = 'P200601110115236' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326369'
                WHERE ordernumber = 'P190601110734657' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393437'
                WHERE ordernumber = 'P200601110735710' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218516'
                WHERE ordernumber = 'P190601110853138' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393438'
                WHERE ordernumber = 'P200601111024521' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380671'
                WHERE ordernumber = 'P180601111025874' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '134226'
                WHERE ordernumber = 'P190601111124938' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393440'
                WHERE ordernumber = 'P420601111324922' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238448'
                WHERE ordernumber = 'P200601111406134' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393442'
                WHERE ordernumber = 'P180601111654243' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328644'
                WHERE ordernumber = 'P420601111708141' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392013'
                WHERE ordernumber = 'P190601111739253' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328644'
                WHERE ordernumber = 'P420601111916657' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393443'
                WHERE ordernumber = 'P180601111922260' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '141131'
                WHERE ordernumber = 'P200601112204977' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393444'
                WHERE ordernumber = 'P190601112212514' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316018'
                WHERE ordernumber = 'P420601112258815' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393289'
                WHERE ordernumber = 'P180601112503499' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '11981'
                WHERE ordernumber = 'P180601112734191' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81972'
                WHERE ordernumber = 'P200601112735223' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '124687'
                WHERE ordernumber = 'P420601112827722' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393447'
                WHERE ordernumber = 'P420601113021890' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393446'
                WHERE ordernumber = 'P780601113154258' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '373451'
                WHERE ordernumber = 'P420601113203400' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392565'
                WHERE ordernumber = 'P190601113247866' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393448'
                WHERE ordernumber = 'P420601113324895' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95801'
                WHERE ordernumber = 'P200601113826251' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393450'
                WHERE ordernumber = 'P630601113849224' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393451'
                WHERE ordernumber = 'P200601114030727' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360176'
                WHERE ordernumber = 'P200601114527753' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393452'
                WHERE ordernumber = 'P200601114706475' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393453'
                WHERE ordernumber = 'P200601115159186' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393455'
                WHERE ordernumber = 'P420601115417305' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393457'
                WHERE ordernumber = 'P180601115442725' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393458'
                WHERE ordernumber = 'P420601115653590' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393459'
                WHERE ordernumber = 'P180601115710923' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393460'
                WHERE ordernumber = 'P180601120003943' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123302'
                WHERE ordernumber = 'P200601120146272' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393461'
                WHERE ordernumber = 'P180601120259703' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393462'
                WHERE ordernumber = 'P190601120550894' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383776'
                WHERE ordernumber = 'P180601120612354' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385099'
                WHERE ordernumber = 'P200601120752947' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393463'
                WHERE ordernumber = 'P180601120904552' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393464'
                WHERE ordernumber = 'P630601121256574' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358762'
                WHERE ordernumber = 'P200601121505494' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '163435'
                WHERE ordernumber = 'P180601121634897' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393465'
                WHERE ordernumber = 'P190601121637969' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393466'
                WHERE ordernumber = 'P420601121826259' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100514'
                WHERE ordernumber = 'P190601121953829' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393467'
                WHERE ordernumber = 'P200601122303766' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393468'
                WHERE ordernumber = 'P190601122448803' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366041'
                WHERE ordernumber = 'P420601122528260' 
            
2024-06-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393470'
                WHERE ordernumber = 'P420601123206870' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '4920'
                WHERE ordernumber = 'P180601123229699' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389914'
                WHERE ordernumber = 'P630601123324563' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393471'
                WHERE ordernumber = 'P180601123753725' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283600'
                WHERE ordernumber = 'P180601124001574' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393428'
                WHERE ordernumber = 'P180601124156662' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393473'
                WHERE ordernumber = 'P420601124313792' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390945'
                WHERE ordernumber = 'P180601124357696' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393472'
                WHERE ordernumber = 'P200601124432976' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309518'
                WHERE ordernumber = 'P200601124639591' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304095'
                WHERE ordernumber = 'P180601125009127' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123898'
                WHERE ordernumber = 'P200601125020794' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392355'
                WHERE ordernumber = 'P200601125207627' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392355'
                WHERE ordernumber = 'P200601125409270' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393477'
                WHERE ordernumber = 'P180601125557278' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393478'
                WHERE ordernumber = 'P180601125848678' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214714'
                WHERE ordernumber = 'P420601130545287' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239838'
                WHERE ordernumber = 'P200601130625359' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337262'
                WHERE ordernumber = 'P420601130855806' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393479'
                WHERE ordernumber = 'P420601131214411' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393480'
                WHERE ordernumber = 'P180601131321966' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393481'
                WHERE ordernumber = 'P190601131441703' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393483'
                WHERE ordernumber = 'P710601131508789' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393485'
                WHERE ordernumber = 'P180601131535686' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393484'
                WHERE ordernumber = 'P780601131617790' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393486'
                WHERE ordernumber = 'P200601131802610' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393487'
                WHERE ordernumber = 'P180601132028864' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393482'
                WHERE ordernumber = 'P710601132145752' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '45677'
                WHERE ordernumber = 'P780601132203707' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345354'
                WHERE ordernumber = 'P630601132219583' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393489'
                WHERE ordernumber = 'P180601132254417' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393488'
                WHERE ordernumber = 'P630601132444793' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108403'
                WHERE ordernumber = 'P180601132555810' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342567'
                WHERE ordernumber = 'P420601132637974' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353669'
                WHERE ordernumber = 'P180601133108986' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100326'
                WHERE ordernumber = 'P190601133739669' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393491'
                WHERE ordernumber = 'P710601133900683' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348889'
                WHERE ordernumber = 'P200601134023177' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379762'
                WHERE ordernumber = 'P200601134423325' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393494'
                WHERE ordernumber = 'P180601134849949' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162239'
                WHERE ordernumber = 'P200601135056291' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393435'
                WHERE ordernumber = 'P420601135215772' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392562'
                WHERE ordernumber = 'P180601135237537' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365140'
                WHERE ordernumber = 'P420601135400427' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93672'
                WHERE ordernumber = 'P200601135706601' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109268'
                WHERE ordernumber = 'P180601135914208' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342590'
                WHERE ordernumber = 'P420601140358744' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393500'
                WHERE ordernumber = 'P190601140428569' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147303'
                WHERE ordernumber = 'P180601140601711' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393501'
                WHERE ordernumber = 'P710601140608569' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291396'
                WHERE ordernumber = 'P780601140824636' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391906'
                WHERE ordernumber = 'P710601140854789' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393488'
                WHERE ordernumber = 'P630601141142852' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393503'
                WHERE ordernumber = 'P190601141239711' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393505'
                WHERE ordernumber = 'P710601141443406' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276920'
                WHERE ordernumber = 'P180601141507987' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349012'
                WHERE ordernumber = 'P780601141827120' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390757'
                WHERE ordernumber = 'P180601141833163' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393506'
                WHERE ordernumber = 'P190601141954295' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393507'
                WHERE ordernumber = 'P180601142112700' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393508'
                WHERE ordernumber = 'P200601142346631' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393509'
                WHERE ordernumber = 'P190601142624909' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276699'
                WHERE ordernumber = 'P190601142933448' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393511'
                WHERE ordernumber = 'P190601143105337' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306842'
                WHERE ordernumber = 'P200601143129899' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393506'
                WHERE ordernumber = 'P190601143403221' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107844'
                WHERE ordernumber = 'P200601143543903' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '148763'
                WHERE ordernumber = 'P420601144023810' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '46454'
                WHERE ordernumber = 'P180601144330622' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393514'
                WHERE ordernumber = 'P180601144417947' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393516'
                WHERE ordernumber = 'P200601144441375' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393517'
                WHERE ordernumber = 'P190601144536709' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254228'
                WHERE ordernumber = 'P190601144824757' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341498'
                WHERE ordernumber = 'P180601145031548' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393492'
                WHERE ordernumber = 'P200601145100144' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393518'
                WHERE ordernumber = 'P190601145109178' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93404'
                WHERE ordernumber = 'P180601145216600' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274633'
                WHERE ordernumber = 'P180601145401834' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238862'
                WHERE ordernumber = 'P180601145507855' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207883'
                WHERE ordernumber = 'P180601150154506' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343044'
                WHERE ordernumber = 'P190601150246806' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251683'
                WHERE ordernumber = 'P200601150330783' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263785'
                WHERE ordernumber = 'P180601150419967' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393521'
                WHERE ordernumber = 'P780601150434310' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266256'
                WHERE ordernumber = 'P200601150734769' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393522'
                WHERE ordernumber = 'P180601150827684' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393523'
                WHERE ordernumber = 'P180601151016459' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393524'
                WHERE ordernumber = 'P200601151018417' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393525'
                WHERE ordernumber = 'P780601151256610' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276826'
                WHERE ordernumber = 'P190601151400165' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393526'
                WHERE ordernumber = 'P200601151430724' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393527'
                WHERE ordernumber = 'P180601151505532' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393528'
                WHERE ordernumber = 'P200601151604218' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393529'
                WHERE ordernumber = 'P190601151628226' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237174'
                WHERE ordernumber = 'P200601151841165' 
            
2024-06-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386120'
                WHERE ordernumber = 'P200601152019570' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163771'
                WHERE ordernumber = 'P190601152325259' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384477'
                WHERE ordernumber = 'P190601152505517' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143193'
                WHERE ordernumber = 'P190601152828893' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393533'
                WHERE ordernumber = 'P420601153156628' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311320'
                WHERE ordernumber = 'P200601154358615' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393534'
                WHERE ordernumber = 'P780601154401352' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P190601154446647' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393536'
                WHERE ordernumber = 'P190601154917228' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393535'
                WHERE ordernumber = 'P780601154933415' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389787'
                WHERE ordernumber = 'P200601155000509' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88157'
                WHERE ordernumber = 'P420601155036878' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393537'
                WHERE ordernumber = 'P180601155132647' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393538'
                WHERE ordernumber = 'P190601155136266' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267362'
                WHERE ordernumber = 'P200601155348201' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '83836'
                WHERE ordernumber = 'P420601155537549' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340236'
                WHERE ordernumber = 'P420601155844684' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393540'
                WHERE ordernumber = 'P420601160352179' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393541'
                WHERE ordernumber = 'P630601160457460' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393543'
                WHERE ordernumber = 'P180601160711643' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219559'
                WHERE ordernumber = 'P420601160740840' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393544'
                WHERE ordernumber = 'P200601160851628' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393545'
                WHERE ordernumber = 'P190601160921659' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393546'
                WHERE ordernumber = 'P420601160929464' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P180601161002233' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393547'
                WHERE ordernumber = 'P190601161054833' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393548'
                WHERE ordernumber = 'P180601161148728' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121434'
                WHERE ordernumber = 'P190601161213704' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393549'
                WHERE ordernumber = 'P180601161306752' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '156998'
                WHERE ordernumber = 'P190601161416947' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393551'
                WHERE ordernumber = 'P180601161547272' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393552'
                WHERE ordernumber = 'P190601162022709' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337116'
                WHERE ordernumber = 'P200601162052573' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230585'
                WHERE ordernumber = 'P200601162443475' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262490'
                WHERE ordernumber = 'P200601162517640' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '186987'
                WHERE ordernumber = 'P780601162544455' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393553'
                WHERE ordernumber = 'P180601162610533' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393554'
                WHERE ordernumber = 'P420601162704471' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '49891'
                WHERE ordernumber = 'P190601162909346' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393555'
                WHERE ordernumber = 'P180601162954580' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393556'
                WHERE ordernumber = 'P190601163128436' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P190601163821280' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393557'
                WHERE ordernumber = 'P180601164010258' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393558'
                WHERE ordernumber = 'P190601164214852' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393559'
                WHERE ordernumber = 'P180601164217910' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393559'
                WHERE ordernumber = 'P180601164240594' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393560'
                WHERE ordernumber = 'P180601164407816' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393562'
                WHERE ordernumber = 'P190601164848839' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393498'
                WHERE ordernumber = 'P180601165001153' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393563'
                WHERE ordernumber = 'P710601165333465' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315226'
                WHERE ordernumber = 'P420601165353720' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318790'
                WHERE ordernumber = 'P200601170018883' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393566'
                WHERE ordernumber = 'P180601170100835' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216990'
                WHERE ordernumber = 'P200601170235251' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393567'
                WHERE ordernumber = 'P710601170304159' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393568'
                WHERE ordernumber = 'P780601170330949' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393569'
                WHERE ordernumber = 'P780601170541774' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393571'
                WHERE ordernumber = 'P180601170547430' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393572'
                WHERE ordernumber = 'P180601170802944' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166469'
                WHERE ordernumber = 'P780601171136935' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393541'
                WHERE ordernumber = 'P420601171437820' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309371'
                WHERE ordernumber = 'P780601171527688' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104420'
                WHERE ordernumber = 'P180601171531947' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393574'
                WHERE ordernumber = 'P710601171918308' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350054'
                WHERE ordernumber = 'P180601171929479' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387037'
                WHERE ordernumber = 'P630601172005572' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393576'
                WHERE ordernumber = 'P180601172102421' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341702'
                WHERE ordernumber = 'P200601172308861' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166285'
                WHERE ordernumber = 'P190601172335384' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393577'
                WHERE ordernumber = 'P710601172341429' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393579'
                WHERE ordernumber = 'P420601172409680' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87579'
                WHERE ordernumber = 'P180601172441534' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393578'
                WHERE ordernumber = 'P190601172859713' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393580'
                WHERE ordernumber = 'P710601173013259' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287805'
                WHERE ordernumber = 'P180601173348268' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393582'
                WHERE ordernumber = 'P780601173355115' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82442'
                WHERE ordernumber = 'P180601173614642' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393565'
                WHERE ordernumber = 'P180601173804575' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360115'
                WHERE ordernumber = 'P420601173904543' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360115'
                WHERE ordernumber = 'P420601174045903' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393583'
                WHERE ordernumber = 'P180601174056136' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161089'
                WHERE ordernumber = 'P420601174318887' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393584'
                WHERE ordernumber = 'P630601174352600' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393587'
                WHERE ordernumber = 'P200601174417240' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120263'
                WHERE ordernumber = 'P180601174438828' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393585'
                WHERE ordernumber = 'P780601174538442' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393588'
                WHERE ordernumber = 'P190601174614535' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '75879'
                WHERE ordernumber = 'P630601174704141' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232646'
                WHERE ordernumber = 'P180601174711279' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242216'
                WHERE ordernumber = 'P190601174721352' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393589'
                WHERE ordernumber = 'P200601174901253' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P180601175254556' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393592'
                WHERE ordernumber = 'P710601175259332' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393593'
                WHERE ordernumber = 'P780601175645552' 
            
2024-06-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250493'
                WHERE ordernumber = 'P200601175717326' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295243'
                WHERE ordernumber = 'P200601175819985' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81065'
                WHERE ordernumber = 'P420601175943516' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '131221'
                WHERE ordernumber = 'P200601180136764' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352938'
                WHERE ordernumber = 'P420601180214188' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393594'
                WHERE ordernumber = 'P200601180332297' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P780601180538834' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393595'
                WHERE ordernumber = 'P420601180549494' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358840'
                WHERE ordernumber = 'P200601180706111' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393590'
                WHERE ordernumber = 'P180601180738275' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393184'
                WHERE ordernumber = 'P200601180937955' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393596'
                WHERE ordernumber = 'P180601181015270' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393598'
                WHERE ordernumber = 'P420601181217828' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276996'
                WHERE ordernumber = 'P190601181458631' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393597'
                WHERE ordernumber = 'P200601181631946' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393599'
                WHERE ordernumber = 'P180601181633964' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393597'
                WHERE ordernumber = 'P200601181717455' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393600'
                WHERE ordernumber = 'P200601181952544' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '165837'
                WHERE ordernumber = 'P780601182417533' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393601'
                WHERE ordernumber = 'P200601182745954' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393601'
                WHERE ordernumber = 'P200601182821246' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387919'
                WHERE ordernumber = 'P180601183636921' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379333'
                WHERE ordernumber = 'P200601184047792' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393604'
                WHERE ordernumber = 'P180601184333568' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393605'
                WHERE ordernumber = 'P420601184353924' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393607'
                WHERE ordernumber = 'P190601184720248' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264900'
                WHERE ordernumber = 'P200601184831871' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393609'
                WHERE ordernumber = 'P180601184901270' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393606'
                WHERE ordernumber = 'P780601184949719' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393608'
                WHERE ordernumber = 'P180601185048995' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393610'
                WHERE ordernumber = 'P200601185406615' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388356'
                WHERE ordernumber = 'P190601185611609' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385398'
                WHERE ordernumber = 'P200601185827950' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393611'
                WHERE ordernumber = 'P190601190623811' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '125140'
                WHERE ordernumber = 'P200601190810524' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393612'
                WHERE ordernumber = 'P190601191039603' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '62893'
                WHERE ordernumber = 'P190601191400904' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393614'
                WHERE ordernumber = 'P190601191946422' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393615'
                WHERE ordernumber = 'P200601192155588' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393616'
                WHERE ordernumber = 'P200601192311524' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104534'
                WHERE ordernumber = 'P190601192340179' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393618'
                WHERE ordernumber = 'P710601192504351' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '158000'
                WHERE ordernumber = 'P200601192540734' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273371'
                WHERE ordernumber = 'P190601192601299' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '171250'
                WHERE ordernumber = 'P630601193252237' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384980'
                WHERE ordernumber = 'P200601193400921' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393620'
                WHERE ordernumber = 'P190601193410469' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393591'
                WHERE ordernumber = 'P190601193531620' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393622'
                WHERE ordernumber = 'P200601194148796' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302915'
                WHERE ordernumber = 'P190601194150817' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313776'
                WHERE ordernumber = 'P190601195042844' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289261'
                WHERE ordernumber = 'P200601195137377' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393625'
                WHERE ordernumber = 'P190601195436533' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360115'
                WHERE ordernumber = 'P630601195505861' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '62166'
                WHERE ordernumber = 'P710601195610345' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393629'
                WHERE ordernumber = 'P630601201355873' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393628'
                WHERE ordernumber = 'P710601201358439' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393621'
                WHERE ordernumber = 'P710601201557704' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393630'
                WHERE ordernumber = 'P710601202210522' 
            
2024-06-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '173298'
                WHERE ordernumber = 'P710601212116513'