2024-12-16 01:00:02 -- 將會員中心id寫入data-lake
2024-12-16 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-12-15%';
        
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435895'
                WHERE ordernumber = 'P2412150000252' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435794'
                WHERE ordernumber = 'P2412150000426' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435898'
                WHERE ordernumber = 'P2412150000783' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435902'
                WHERE ordernumber = 'P2412150000945' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435899'
                WHERE ordernumber = 'P2412150001023' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435903'
                WHERE ordernumber = 'P2412150001122' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271609'
                WHERE ordernumber = 'P2412150001496' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434614'
                WHERE ordernumber = 'P2412150001574' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435907'
                WHERE ordernumber = 'P2412150001656' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435909'
                WHERE ordernumber = 'P2412150001731' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329206'
                WHERE ordernumber = 'P2412150001894' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428908'
                WHERE ordernumber = 'P2412150001975' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429761'
                WHERE ordernumber = 'P2412150002244' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435912'
                WHERE ordernumber = 'P2412150002327' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435915'
                WHERE ordernumber = 'P2412150002494' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435830'
                WHERE ordernumber = 'P2412150002581' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406442'
                WHERE ordernumber = 'P2412150002780' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435916'
                WHERE ordernumber = 'P2412150002868' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435917'
                WHERE ordernumber = 'P2412150002970' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435918'
                WHERE ordernumber = 'P2412150003051' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272210'
                WHERE ordernumber = 'P2412150003138' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435920'
                WHERE ordernumber = 'P2412150003295' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435921'
                WHERE ordernumber = 'P2412150003382' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412049'
                WHERE ordernumber = 'P2412150003443' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435922'
                WHERE ordernumber = 'P2412150003511' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435914'
                WHERE ordernumber = 'P2412150003623' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284049'
                WHERE ordernumber = 'P2412150003722' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356405'
                WHERE ordernumber = 'P2412150003957' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435924'
                WHERE ordernumber = 'P2412150004235' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435925'
                WHERE ordernumber = 'P2412150004328' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435918'
                WHERE ordernumber = 'P2412150004555' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283168'
                WHERE ordernumber = 'P2412150004870' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435926'
                WHERE ordernumber = 'P2412150004987' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435927'
                WHERE ordernumber = 'P2412150005047' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435928'
                WHERE ordernumber = 'P2412150005220' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434462'
                WHERE ordernumber = 'P2412150005595' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435931'
                WHERE ordernumber = 'P2412150005667' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '267868'
                WHERE ordernumber = 'P2412150005720' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '109582'
                WHERE ordernumber = 'P2412150005944' 
            
2024-12-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425686'
                WHERE ordernumber = 'P2412150006219' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P2412150006378' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292403'
                WHERE ordernumber = 'P2412150006565' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435938'
                WHERE ordernumber = 'P2412150006773' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344248'
                WHERE ordernumber = 'P2412150006955' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84687'
                WHERE ordernumber = 'P2412150007124' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162020'
                WHERE ordernumber = 'P2412150007356' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435942'
                WHERE ordernumber = 'P2412150007460' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P2412150007546' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435945'
                WHERE ordernumber = 'P2412150007821' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433199'
                WHERE ordernumber = 'P2412150008011' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389464'
                WHERE ordernumber = 'P2412150008189' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413149'
                WHERE ordernumber = 'P2412150008384' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419556'
                WHERE ordernumber = 'P2412150008590' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434058'
                WHERE ordernumber = 'P2412150008744' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435941'
                WHERE ordernumber = 'P2412150008858' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409396'
                WHERE ordernumber = 'P2412150009023' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434058'
                WHERE ordernumber = 'P2412150009278' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435950'
                WHERE ordernumber = 'P2412150009485' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434113'
                WHERE ordernumber = 'P2412150009580' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433410'
                WHERE ordernumber = 'P2412150010349' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435137'
                WHERE ordernumber = 'P2412150010416' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435958'
                WHERE ordernumber = 'P2412150010725' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435959'
                WHERE ordernumber = 'P2412150011191' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434573'
                WHERE ordernumber = 'P2412150011259' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244638'
                WHERE ordernumber = 'P2412150011327' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326615'
                WHERE ordernumber = 'P2412150011585' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424653'
                WHERE ordernumber = 'P2412150011682' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435960'
                WHERE ordernumber = 'P2412150011725' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435955'
                WHERE ordernumber = 'P2412150012150' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221676'
                WHERE ordernumber = 'P2412150012292' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361520'
                WHERE ordernumber = 'P2412150012367' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435957'
                WHERE ordernumber = 'P2412150012416' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435964'
                WHERE ordernumber = 'P2412150012525' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305353'
                WHERE ordernumber = 'P2412150012643' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435965'
                WHERE ordernumber = 'P2412150012882' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435967'
                WHERE ordernumber = 'P2412150012933' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395384'
                WHERE ordernumber = 'P2412150013111' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431739'
                WHERE ordernumber = 'P2412150013287' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435968'
                WHERE ordernumber = 'P2412150013433' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435971'
                WHERE ordernumber = 'P2412150013591' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435967'
                WHERE ordernumber = 'P2412150013657' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435969'
                WHERE ordernumber = 'P2412150013746' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264008'
                WHERE ordernumber = 'P2412150014034' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '200504'
                WHERE ordernumber = 'P2412150014221' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435970'
                WHERE ordernumber = 'P2412150014477' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435972'
                WHERE ordernumber = 'P2412150014566' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432223'
                WHERE ordernumber = 'P2412150014793' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431740'
                WHERE ordernumber = 'P2412150014862' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353159'
                WHERE ordernumber = 'P2412150015371' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100687'
                WHERE ordernumber = 'P2412150015418' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435975'
                WHERE ordernumber = 'P2412150015590' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434153'
                WHERE ordernumber = 'P2412150015680' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435977'
                WHERE ordernumber = 'P2412150015765' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355302'
                WHERE ordernumber = 'P2412150015890' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435978'
                WHERE ordernumber = 'P2412150016061' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428674'
                WHERE ordernumber = 'P2412150016268' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384507'
                WHERE ordernumber = 'P2412150016372' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435976'
                WHERE ordernumber = 'P2412150016468' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435979'
                WHERE ordernumber = 'P2412150016481' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391928'
                WHERE ordernumber = 'P2412150016685' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435977'
                WHERE ordernumber = 'P2412150016740' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435981'
                WHERE ordernumber = 'P2412150016959' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435983'
                WHERE ordernumber = 'P2412150017278' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337540'
                WHERE ordernumber = 'P2412150017398' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435985'
                WHERE ordernumber = 'P2412150017459' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356807'
                WHERE ordernumber = 'P2412150017513' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258137'
                WHERE ordernumber = 'P2412150017713' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318159'
                WHERE ordernumber = 'P2412150017873' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129975'
                WHERE ordernumber = 'P2412150018023' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435982'
                WHERE ordernumber = 'P2412150018316' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435995'
                WHERE ordernumber = 'P2412150018411' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401879'
                WHERE ordernumber = 'P2412150018540' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435988'
                WHERE ordernumber = 'P2412150018781' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348889'
                WHERE ordernumber = 'P2412150018845' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435991'
                WHERE ordernumber = 'P2412150018913' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435996'
                WHERE ordernumber = 'P2412150019035' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435997'
                WHERE ordernumber = 'P2412150019136' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424898'
                WHERE ordernumber = 'P2412150019291' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304926'
                WHERE ordernumber = 'P2412150019296' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300260'
                WHERE ordernumber = 'P2412150019466' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435999'
                WHERE ordernumber = 'P2412150019675' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335634'
                WHERE ordernumber = 'P2412150019761' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294635'
                WHERE ordernumber = 'P2412150019962' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436000'
                WHERE ordernumber = 'P2412150020028' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436001'
                WHERE ordernumber = 'P2412150020146' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436002'
                WHERE ordernumber = 'P2412150020215' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392643'
                WHERE ordernumber = 'P2412150020450' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436003'
                WHERE ordernumber = 'P2412150020537' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434394'
                WHERE ordernumber = 'P2412150020688' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289710'
                WHERE ordernumber = 'P2412150020760' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94472'
                WHERE ordernumber = 'P2412150020812' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122228'
                WHERE ordernumber = 'P2412150020989' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434478'
                WHERE ordernumber = 'P2412150021126' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253658'
                WHERE ordernumber = 'P2412150021277' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436006'
                WHERE ordernumber = 'P2412150021339' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436000'
                WHERE ordernumber = 'P2412150021549' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436007'
                WHERE ordernumber = 'P2412150021720' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431843'
                WHERE ordernumber = 'P2412150021876' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218428'
                WHERE ordernumber = 'P2412150022052' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436009'
                WHERE ordernumber = 'P2412150022178' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436007'
                WHERE ordernumber = 'P2412150022288' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436010'
                WHERE ordernumber = 'P2412150022320' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373341'
                WHERE ordernumber = 'P2412150022457' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436008'
                WHERE ordernumber = 'P2412150022659' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436013'
                WHERE ordernumber = 'P2412150022818' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436012'
                WHERE ordernumber = 'P2412150022971' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436010'
                WHERE ordernumber = 'P2412150023095' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436004'
                WHERE ordernumber = 'P2412150023110' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436015'
                WHERE ordernumber = 'P2412150023226' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390247'
                WHERE ordernumber = 'P2412150023381' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436016'
                WHERE ordernumber = 'P2412150023486' 
            
2024-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436017'
                WHERE ordernumber = 'P2412150023665' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395703'
                WHERE ordernumber = 'P2412150023827' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429634'
                WHERE ordernumber = 'P2412150023984' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436020'
                WHERE ordernumber = 'P2412150024230' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436019'
                WHERE ordernumber = 'P2412150024373' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436018'
                WHERE ordernumber = 'P2412150024585' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247872'
                WHERE ordernumber = 'P2412150024784' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436027'
                WHERE ordernumber = 'P2412150024860' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281041'
                WHERE ordernumber = 'P2412150025176' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100636'
                WHERE ordernumber = 'P2412150025249' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436028'
                WHERE ordernumber = 'P2412150025357' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436029'
                WHERE ordernumber = 'P2412150025552' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89667'
                WHERE ordernumber = 'P2412150025741' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436033'
                WHERE ordernumber = 'P2412150025823' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436034'
                WHERE ordernumber = 'P2412150025995' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169154'
                WHERE ordernumber = 'P2412150026069' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421658'
                WHERE ordernumber = 'P2412150026167' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436036'
                WHERE ordernumber = 'P2412150026282' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346977'
                WHERE ordernumber = 'P2412150026440' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370423'
                WHERE ordernumber = 'P2412150026520' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436038'
                WHERE ordernumber = 'P2412150026615' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436032'
                WHERE ordernumber = 'P2412150026793' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436040'
                WHERE ordernumber = 'P2412150026939' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346977'
                WHERE ordernumber = 'P2412150027055' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320317'
                WHERE ordernumber = 'P2412150027144' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416617'
                WHERE ordernumber = 'P2412150027255' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436042'
                WHERE ordernumber = 'P2412150027313' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436043'
                WHERE ordernumber = 'P2412150027643' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436044'
                WHERE ordernumber = 'P2412150027773' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216755'
                WHERE ordernumber = 'P2412150027822' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379326'
                WHERE ordernumber = 'P2412150027999' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430351'
                WHERE ordernumber = 'P2412150028074' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435200'
                WHERE ordernumber = 'P2412150028157' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74302'
                WHERE ordernumber = 'P2412150028511' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436045'
                WHERE ordernumber = 'P2412150028910' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376532'
                WHERE ordernumber = 'P2412150029143' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377580'
                WHERE ordernumber = 'P2412150029297' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436046'
                WHERE ordernumber = 'P2412150029585' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241198'
                WHERE ordernumber = 'P2412150029797' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104143'
                WHERE ordernumber = 'P2412150029847' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P2412150029970' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241198'
                WHERE ordernumber = 'P2412150030016' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436051'
                WHERE ordernumber = 'P2412150030150' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436052'
                WHERE ordernumber = 'P2412150030240' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321657'
                WHERE ordernumber = 'P2412150030379' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436054'
                WHERE ordernumber = 'P2412150030513' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281733'
                WHERE ordernumber = 'P2412150030675' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436046'
                WHERE ordernumber = 'P2412150030741' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237288'
                WHERE ordernumber = 'P2412150030912' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435750'
                WHERE ordernumber = 'P2412150031116' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436057'
                WHERE ordernumber = 'P2412150031610' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435200'
                WHERE ordernumber = 'P2412150031729' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138146'
                WHERE ordernumber = 'P2412150031883' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141799'
                WHERE ordernumber = 'P2412150031913' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314307'
                WHERE ordernumber = 'P2412150032096' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436062'
                WHERE ordernumber = 'P2412150032144' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436061'
                WHERE ordernumber = 'P2412150032287' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436061'
                WHERE ordernumber = 'P2412150032334' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295796'
                WHERE ordernumber = 'P2412150032571' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436064'
                WHERE ordernumber = 'P2412150032767' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436065'
                WHERE ordernumber = 'P2412150033028' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436063'
                WHERE ordernumber = 'P2412150033229' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431564'
                WHERE ordernumber = 'P2412150033335' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436067'
                WHERE ordernumber = 'P2412150033494' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434675'
                WHERE ordernumber = 'P2412150033591' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436068'
                WHERE ordernumber = 'P2412150033664' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276379'
                WHERE ordernumber = 'P2412150033795' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436070'
                WHERE ordernumber = 'P2412150034058' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436071'
                WHERE ordernumber = 'P2412150034241' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436072'
                WHERE ordernumber = 'P2412150034420' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436074'
                WHERE ordernumber = 'P2412150034530' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112014'
                WHERE ordernumber = 'P2412150034739' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257894'
                WHERE ordernumber = 'P2412150034872' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282147'
                WHERE ordernumber = 'P2412150035142' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436075'
                WHERE ordernumber = 'P2412150035718' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '4489'
                WHERE ordernumber = 'P2412150036530' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435563'
                WHERE ordernumber = 'P2412150036731' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436077'
                WHERE ordernumber = 'P2412150037013' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436041'
                WHERE ordernumber = 'P2412150037147' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436041'
                WHERE ordernumber = 'P2412150037245' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340315'
                WHERE ordernumber = 'P2412150037370' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436079'
                WHERE ordernumber = 'P2412150037430' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436080'
                WHERE ordernumber = 'P2412150037672' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436081'
                WHERE ordernumber = 'P2412150037793' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436082'
                WHERE ordernumber = 'P2412150037912' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435040'
                WHERE ordernumber = 'P2412150038093' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436084'
                WHERE ordernumber = 'P2412150038126' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436085'
                WHERE ordernumber = 'P2412150038394' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436086'
                WHERE ordernumber = 'P2412150038484' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435980'
                WHERE ordernumber = 'P2412150038588' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436087'
                WHERE ordernumber = 'P2412150038642' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292023'
                WHERE ordernumber = 'P2412150038786' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383364'
                WHERE ordernumber = 'P2412150038828' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378878'
                WHERE ordernumber = 'P2412150038919' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436089'
                WHERE ordernumber = 'P2412150039152' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436091'
                WHERE ordernumber = 'P2412150039291' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P2412150039343' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227634'
                WHERE ordernumber = 'P2412150039483' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301616'
                WHERE ordernumber = 'P2412150039619' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436093'
                WHERE ordernumber = 'P2412150039827' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436095'
                WHERE ordernumber = 'P2412150040086' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428978'
                WHERE ordernumber = 'P2412150040287' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436097'
                WHERE ordernumber = 'P2412150040334' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433369'
                WHERE ordernumber = 'P2412150040430' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436098'
                WHERE ordernumber = 'P2412150040531' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2412150040780' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425504'
                WHERE ordernumber = 'P2412150040971' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426393'
                WHERE ordernumber = 'P2412150041165' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396818'
                WHERE ordernumber = 'P2412150041239' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436101'
                WHERE ordernumber = 'P2412150041427' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436103'
                WHERE ordernumber = 'P2412150041662' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330997'
                WHERE ordernumber = 'P2412150041765' 
            
2024-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428211'
                WHERE ordernumber = 'P2412150041836' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436108'
                WHERE ordernumber = 'P2412150042055' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390383'
                WHERE ordernumber = 'P2412150042387' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436109'
                WHERE ordernumber = 'P2412150042471' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436111'
                WHERE ordernumber = 'P2412150042529' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436107'
                WHERE ordernumber = 'P2412150042645' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436110'
                WHERE ordernumber = 'P2412150042927' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353186'
                WHERE ordernumber = 'P2412150043361' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '429529'
                WHERE ordernumber = 'P2412150043524' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436116'
                WHERE ordernumber = 'P2412150043773' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436114'
                WHERE ordernumber = 'P2412150044051' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '151947'
                WHERE ordernumber = 'P2412150044141' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307847'
                WHERE ordernumber = 'P2412150044286' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '432086'
                WHERE ordernumber = 'P2412150044344' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '431667'
                WHERE ordernumber = 'P2412150044464' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436120'
                WHERE ordernumber = 'P2412150044764' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436121'
                WHERE ordernumber = 'P2412150044883' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436122'
                WHERE ordernumber = 'P2412150044941' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280631'
                WHERE ordernumber = 'P2412150045113' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436125'
                WHERE ordernumber = 'P2412150045494' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '431015'
                WHERE ordernumber = 'P2412150045543' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436129'
                WHERE ordernumber = 'P2412150046322' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436131'
                WHERE ordernumber = 'P2412150046716' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436139'
                WHERE ordernumber = 'P2412150046933' 
            
2024-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436142'
                WHERE ordernumber = 'P2412150047297'