2024-12-25 01:00:01 -- 將會員中心id寫入data-lake
2024-12-25 01:00:01 -- 
            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-12-24%';
        
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435318'
                WHERE ordernumber = 'P2412240000012' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368246'
                WHERE ordernumber = 'P2412240000013' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431459'
                WHERE ordernumber = 'P2412240000016' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438578'
                WHERE ordernumber = 'P2412240000017' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378112'
                WHERE ordernumber = 'P2412240000020' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284049'
                WHERE ordernumber = 'P2412240000022' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436248'
                WHERE ordernumber = 'P2412240000024' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261687'
                WHERE ordernumber = 'P2412240000025' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438804'
                WHERE ordernumber = 'P2412240000027' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438805'
                WHERE ordernumber = 'P2412240000028' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433299'
                WHERE ordernumber = 'P2412240000031' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438802'
                WHERE ordernumber = 'P2412240000032' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384121'
                WHERE ordernumber = 'P2412240000034' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434219'
                WHERE ordernumber = 'P2412240000036' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438809'
                WHERE ordernumber = 'P2412240000037' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338215'
                WHERE ordernumber = 'P2412240000039' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438811'
                WHERE ordernumber = 'P2412240000041' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392791'
                WHERE ordernumber = 'P2412240000045' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438815'
                WHERE ordernumber = 'P2412240000047' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438816'
                WHERE ordernumber = 'P2412240000048' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100438'
                WHERE ordernumber = 'P2412240000049' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '89059'
                WHERE ordernumber = 'P2412240000050' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '160964'
                WHERE ordernumber = 'P2412240000052' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388691'
                WHERE ordernumber = 'P2412240000055' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438825'
                WHERE ordernumber = 'P2412240000056' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438827'
                WHERE ordernumber = 'P2412240000057' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274874'
                WHERE ordernumber = 'P2412240000058' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438828'
                WHERE ordernumber = 'P2412240000061' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438829'
                WHERE ordernumber = 'P2412240000063' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80892'
                WHERE ordernumber = 'P2412240000064' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438828'
                WHERE ordernumber = 'P2412240000065' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80892'
                WHERE ordernumber = 'P2412240000068' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438831'
                WHERE ordernumber = 'P2412240000069' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106911'
                WHERE ordernumber = 'P2412240000071' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '131177'
                WHERE ordernumber = 'P2412240000075' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270115'
                WHERE ordernumber = 'P2412240000078' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2412240000079' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100767'
                WHERE ordernumber = 'P2412240000081' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100574'
                WHERE ordernumber = 'P2412240000083' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299756'
                WHERE ordernumber = 'P2412240000084' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308598'
                WHERE ordernumber = 'P2412240000085' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337922'
                WHERE ordernumber = 'P2412240000086' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438835'
                WHERE ordernumber = 'P2412240000087' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438834'
                WHERE ordernumber = 'P2412240000088' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420696'
                WHERE ordernumber = 'P2412240000090' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438838'
                WHERE ordernumber = 'P2412240000094' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307121'
                WHERE ordernumber = 'P2412240000095' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438839'
                WHERE ordernumber = 'P2412240000097' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438842'
                WHERE ordernumber = 'P2412240000098' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339654'
                WHERE ordernumber = 'P2412240000103' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438845'
                WHERE ordernumber = 'P2412240000109' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404972'
                WHERE ordernumber = 'P2412240000111' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438847'
                WHERE ordernumber = 'P2412240000113' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438848'
                WHERE ordernumber = 'P2412240000117' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436935'
                WHERE ordernumber = 'P2412240000118' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254216'
                WHERE ordernumber = 'P2412240000119' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438853'
                WHERE ordernumber = 'P2412240000121' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438856'
                WHERE ordernumber = 'P2412240000127' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438855'
                WHERE ordernumber = 'P2412240000128' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236531'
                WHERE ordernumber = 'P2412240000129' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434729'
                WHERE ordernumber = 'P2412240000131' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438862'
                WHERE ordernumber = 'P2412240000137' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438859'
                WHERE ordernumber = 'P2412240000138' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433236'
                WHERE ordernumber = 'P2412240000139' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229734'
                WHERE ordernumber = 'P2412240000142' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438857'
                WHERE ordernumber = 'P2412240000148' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438865'
                WHERE ordernumber = 'P2412240000149' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438867'
                WHERE ordernumber = 'P2412240000154' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283374'
                WHERE ordernumber = 'P2412240000158' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270196'
                WHERE ordernumber = 'P2412240000159' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264514'
                WHERE ordernumber = 'P2412240000160' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P2412240000164' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438873'
                WHERE ordernumber = 'P2412240000169' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P2412240000171' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438874'
                WHERE ordernumber = 'P2412240000172' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438876'
                WHERE ordernumber = 'P2412240000173' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438879'
                WHERE ordernumber = 'P2412240000175' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424889'
                WHERE ordernumber = 'P2412240000176' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230221'
                WHERE ordernumber = 'P2412240000177' 
            
2024-12-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424889'
                WHERE ordernumber = 'P2412240000183' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429261'
                WHERE ordernumber = 'P2412240000184' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404501'
                WHERE ordernumber = 'P2412240000187' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438889'
                WHERE ordernumber = 'P2412240000191' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239464'
                WHERE ordernumber = 'P2412240000192' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338789'
                WHERE ordernumber = 'P2412240000197' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438893'
                WHERE ordernumber = 'P2412240000200' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438896'
                WHERE ordernumber = 'P2412240000209' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438897'
                WHERE ordernumber = 'P2412240000214' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438900'
                WHERE ordernumber = 'P2412240000215' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438899'
                WHERE ordernumber = 'P2412240000216' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P2412240000219' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438901'
                WHERE ordernumber = 'P2412240000220' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277459'
                WHERE ordernumber = 'P2412240000222' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438904'
                WHERE ordernumber = 'P2412240000223' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423816'
                WHERE ordernumber = 'P2412240000224' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438901'
                WHERE ordernumber = 'P2412240000225' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107946'
                WHERE ordernumber = 'P2412240000227' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438904'
                WHERE ordernumber = 'P2412240000228' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107946'
                WHERE ordernumber = 'P2412240000229' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438903'
                WHERE ordernumber = 'P2412240000232' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81394'
                WHERE ordernumber = 'P2412240000233' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81394'
                WHERE ordernumber = 'P2412240000239' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261796'
                WHERE ordernumber = 'P2412240000241' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438870'
                WHERE ordernumber = 'P2412240000244' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438910'
                WHERE ordernumber = 'P2412240000247' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438905'
                WHERE ordernumber = 'P2412240000251' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438905'
                WHERE ordernumber = 'P2412240000256' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261796'
                WHERE ordernumber = 'P2412240000259' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438912'
                WHERE ordernumber = 'P2412240000262' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438915'
                WHERE ordernumber = 'P2412240000263' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438914'
                WHERE ordernumber = 'P2412240000266' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403824'
                WHERE ordernumber = 'P2412240000268' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438917'
                WHERE ordernumber = 'P2412240000270' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438916'
                WHERE ordernumber = 'P2412240000272' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225776'
                WHERE ordernumber = 'P2412240000275' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438922'
                WHERE ordernumber = 'P2412240000277' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433455'
                WHERE ordernumber = 'P2412240000278' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438923'
                WHERE ordernumber = 'P2412240000280' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438921'
                WHERE ordernumber = 'P2412240000281' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353089'
                WHERE ordernumber = 'P2412240000283' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438926'
                WHERE ordernumber = 'P2412240000285' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438911'
                WHERE ordernumber = 'P2412240000289' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438919'
                WHERE ordernumber = 'P2412240000290' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438911'
                WHERE ordernumber = 'P2412240000293' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398596'
                WHERE ordernumber = 'P2412240000294' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438925'
                WHERE ordernumber = 'P2412240000296' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438927'
                WHERE ordernumber = 'P2412240000297' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242226'
                WHERE ordernumber = 'P2412240000298' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225117'
                WHERE ordernumber = 'P2412240000299' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438928'
                WHERE ordernumber = 'P2412240000300' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438930'
                WHERE ordernumber = 'P2412240000304' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237209'
                WHERE ordernumber = 'P2412240000307' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364155'
                WHERE ordernumber = 'P2412240000309' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271232'
                WHERE ordernumber = 'P2412240000310' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438793'
                WHERE ordernumber = 'P2412240000313' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436832'
                WHERE ordernumber = 'P2412240000317' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '20838'
                WHERE ordernumber = 'P2412240000318' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94550'
                WHERE ordernumber = 'P2412240000319' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438932'
                WHERE ordernumber = 'P2412240000321' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103898'
                WHERE ordernumber = 'P2412240000324' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438931'
                WHERE ordernumber = 'P2412240000328' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430762'
                WHERE ordernumber = 'P2412240000330' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433369'
                WHERE ordernumber = 'P2412240000332' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303279'
                WHERE ordernumber = 'P2412240000335' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393875'
                WHERE ordernumber = 'P2412240000338' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438936'
                WHERE ordernumber = 'P2412240000339' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431819'
                WHERE ordernumber = 'P2412240000341' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245310'
                WHERE ordernumber = 'P2412240000343' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348458'
                WHERE ordernumber = 'P2412240000352' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438941'
                WHERE ordernumber = 'P2412240000353' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438942'
                WHERE ordernumber = 'P2412240000358' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438944'
                WHERE ordernumber = 'P2412240000361' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334936'
                WHERE ordernumber = 'P2412240000362' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107085'
                WHERE ordernumber = 'P2412240000364' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107085'
                WHERE ordernumber = 'P2412240000365' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81760'
                WHERE ordernumber = 'P2412240000366' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438947'
                WHERE ordernumber = 'P2412240000369' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219951'
                WHERE ordernumber = 'P2412240000382' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438541'
                WHERE ordernumber = 'P2412240000383' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438952'
                WHERE ordernumber = 'P2412240000385' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438953'
                WHERE ordernumber = 'P2412240000386' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426166'
                WHERE ordernumber = 'P2412240000387' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347462'
                WHERE ordernumber = 'P2412240000394' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422698'
                WHERE ordernumber = 'P2412240000395' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339203'
                WHERE ordernumber = 'P2412240000396' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423044'
                WHERE ordernumber = 'P2412240000400' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410004'
                WHERE ordernumber = 'P2412240000403' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304327'
                WHERE ordernumber = 'P2412240000404' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438958'
                WHERE ordernumber = 'P2412240000409' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438959'
                WHERE ordernumber = 'P2412240000410' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438954'
                WHERE ordernumber = 'P2412240000412' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82728'
                WHERE ordernumber = 'P2412240000417' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114267'
                WHERE ordernumber = 'P2412240000418' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438963'
                WHERE ordernumber = 'P2412240000420' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433408'
                WHERE ordernumber = 'P2412240000422' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438966'
                WHERE ordernumber = 'P2412240000425' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206960'
                WHERE ordernumber = 'P2412240000427' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404994'
                WHERE ordernumber = 'P2412240000438' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438972'
                WHERE ordernumber = 'P2412240000442' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435374'
                WHERE ordernumber = 'P2412240000443' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438973'
                WHERE ordernumber = 'P2412240000450' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377478'
                WHERE ordernumber = 'P2412240000452' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380655'
                WHERE ordernumber = 'P2412240000455' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438975'
                WHERE ordernumber = 'P2412240000461' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438975'
                WHERE ordernumber = 'P2412240000463' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438977'
                WHERE ordernumber = 'P2412240000465' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438980'
                WHERE ordernumber = 'P2412240000468' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438982'
                WHERE ordernumber = 'P2412240000470' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435069'
                WHERE ordernumber = 'P2412240000476' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321276'
                WHERE ordernumber = 'P2412240000482' 
            
2024-12-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438989'
                WHERE ordernumber = 'P2412240000484' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324016'
                WHERE ordernumber = 'P2412240000486' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438989'
                WHERE ordernumber = 'P2412240000489' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '59486'
                WHERE ordernumber = 'P2412240000492' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389712'
                WHERE ordernumber = 'P2412240000496' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438994'
                WHERE ordernumber = 'P2412240000497' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438259'
                WHERE ordernumber = 'P2412240000500' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340663'
                WHERE ordernumber = 'P2412240000508' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126828'
                WHERE ordernumber = 'P2412240000509' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438998'
                WHERE ordernumber = 'P2412240000517' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276094'
                WHERE ordernumber = 'P2412240000518' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319052'
                WHERE ordernumber = 'P2412240000521' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439003'
                WHERE ordernumber = 'P2412240000524' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246402'
                WHERE ordernumber = 'P2412240000525' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438998'
                WHERE ordernumber = 'P2412240000526' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439006'
                WHERE ordernumber = 'P2412240000531' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225398'
                WHERE ordernumber = 'P2412240000534' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439005'
                WHERE ordernumber = 'P2412240000535' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439008'
                WHERE ordernumber = 'P2412240000537' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384432'
                WHERE ordernumber = 'P2412240000539' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439010'
                WHERE ordernumber = 'P2412240000540' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100750'
                WHERE ordernumber = 'P2412240000542' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439012'
                WHERE ordernumber = 'P2412240000546' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436960'
                WHERE ordernumber = 'P2412240000549' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439013'
                WHERE ordernumber = 'P2412240000552' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439014'
                WHERE ordernumber = 'P2412240000556' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '44396'
                WHERE ordernumber = 'P2412240000557' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439019'
                WHERE ordernumber = 'P2412240000563' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439019'
                WHERE ordernumber = 'P2412240000567' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439007'
                WHERE ordernumber = 'P2412240000568' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '7087'
                WHERE ordernumber = 'P2412240000569' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439014'
                WHERE ordernumber = 'P2412240000570' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356209'
                WHERE ordernumber = 'P2412240000574' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255925'
                WHERE ordernumber = 'P2412240000575' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439020'
                WHERE ordernumber = 'P2412240000576' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341887'
                WHERE ordernumber = 'P2412240000580' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293235'
                WHERE ordernumber = 'P2412240000584' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439025'
                WHERE ordernumber = 'P2412240000589' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439025'
                WHERE ordernumber = 'P2412240000591' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332808'
                WHERE ordernumber = 'P2412240000592' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342429'
                WHERE ordernumber = 'P2412240000594' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99103'
                WHERE ordernumber = 'P2412240000595' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343595'
                WHERE ordernumber = 'P2412240000597' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439029'
                WHERE ordernumber = 'P2412240000601' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238535'
                WHERE ordernumber = 'P2412240000603' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439031'
                WHERE ordernumber = 'P2412240000607' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351835'
                WHERE ordernumber = 'P2412240000610' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439031'
                WHERE ordernumber = 'P2412240000611' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225398'
                WHERE ordernumber = 'P2412240000612' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351835'
                WHERE ordernumber = 'P2412240000613' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439033'
                WHERE ordernumber = 'P2412240000619' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439031'
                WHERE ordernumber = 'P2412240000629' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242851'
                WHERE ordernumber = 'P2412240000634' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438715'
                WHERE ordernumber = 'P2412240000638' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435027'
                WHERE ordernumber = 'P2412240000640' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439038'
                WHERE ordernumber = 'P2412240000647' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439014'
                WHERE ordernumber = 'P2412240000649' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439041'
                WHERE ordernumber = 'P2412240000650' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439042'
                WHERE ordernumber = 'P2412240000655' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264099'
                WHERE ordernumber = 'P2412240000656' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439043'
                WHERE ordernumber = 'P2412240000660' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280077'
                WHERE ordernumber = 'P2412240000661' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99055'
                WHERE ordernumber = 'P2412240000663' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439046'
                WHERE ordernumber = 'P2412240000664' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '148501'
                WHERE ordernumber = 'P2412240000667' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309750'
                WHERE ordernumber = 'P2412240000668' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437163'
                WHERE ordernumber = 'P2412240000671' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2412240000673' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273316'
                WHERE ordernumber = 'P2412240000678' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439052'
                WHERE ordernumber = 'P2412240000683' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283208'
                WHERE ordernumber = 'P2412240000687' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304893'
                WHERE ordernumber = 'P2412240000688' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297004'
                WHERE ordernumber = 'P2412240000692' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288868'
                WHERE ordernumber = 'P2412240000693' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '68164'
                WHERE ordernumber = 'P2412240000695' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381221'
                WHERE ordernumber = 'P2412240000697' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439061'
                WHERE ordernumber = 'P2412240000706' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438850'
                WHERE ordernumber = 'P2412240000707' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439062'
                WHERE ordernumber = 'P2412240000713' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439058'
                WHERE ordernumber = 'P2412240000714' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379943'
                WHERE ordernumber = 'P2412240000717' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439066'
                WHERE ordernumber = 'P2412240000719' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215827'
                WHERE ordernumber = 'P2412240000722' 
            
2024-12-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294490'
                WHERE ordernumber = 'P2412240000727'