2024-12-01 01:00:01 -- 將會員中心id寫入data-lake
2024-12-01 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-11-30%';
        
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428775'
                WHERE ordernumber = 'P2411300000289' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310921'
                WHERE ordernumber = 'P2411300000372' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432426'
                WHERE ordernumber = 'P2411300000497' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432429'
                WHERE ordernumber = 'P2411300000567' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95310'
                WHERE ordernumber = 'P2411300000616' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432425'
                WHERE ordernumber = 'P2411300000746' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432425'
                WHERE ordernumber = 'P2411300000972' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432430'
                WHERE ordernumber = 'P2411300001099' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432432'
                WHERE ordernumber = 'P2411300001429' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432431'
                WHERE ordernumber = 'P2411300001547' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417256'
                WHERE ordernumber = 'P2411300001769' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236243'
                WHERE ordernumber = 'P2411300001810' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432433'
                WHERE ordernumber = 'P2411300001973' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217347'
                WHERE ordernumber = 'P2411300002082' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432434'
                WHERE ordernumber = 'P2411300002175' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432435'
                WHERE ordernumber = 'P2411300002270' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397198'
                WHERE ordernumber = 'P2411300002353' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339238'
                WHERE ordernumber = 'P2411300002462' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432436'
                WHERE ordernumber = 'P2411300002618' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432437'
                WHERE ordernumber = 'P2411300002783' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '120045'
                WHERE ordernumber = 'P2411300002942' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '120045'
                WHERE ordernumber = 'P2411300003099' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432411'
                WHERE ordernumber = 'P2411300003144' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432411'
                WHERE ordernumber = 'P2411300003374' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388239'
                WHERE ordernumber = 'P2411300003691' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432440'
                WHERE ordernumber = 'P2411300003787' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106349'
                WHERE ordernumber = 'P2411300004017' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432441'
                WHERE ordernumber = 'P2411300004159' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349239'
                WHERE ordernumber = 'P2411300004350' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432442'
                WHERE ordernumber = 'P2411300004413' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P2411300004631' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '199889'
                WHERE ordernumber = 'P2411300004770' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139326'
                WHERE ordernumber = 'P2411300004854' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432443'
                WHERE ordernumber = 'P2411300004972' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138938'
                WHERE ordernumber = 'P2411300005048' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332705'
                WHERE ordernumber = 'P2411300005223' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431020'
                WHERE ordernumber = 'P2411300005376' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432444'
                WHERE ordernumber = 'P2411300005430' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432445'
                WHERE ordernumber = 'P2411300005520' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432446'
                WHERE ordernumber = 'P2411300005655' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400650'
                WHERE ordernumber = 'P2411300005619' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432098'
                WHERE ordernumber = 'P2411300005934' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432448'
                WHERE ordernumber = 'P2411300006020' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389850'
                WHERE ordernumber = 'P2411300006110' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431334'
                WHERE ordernumber = 'P2411300006277' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432450'
                WHERE ordernumber = 'P2411300006484' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432447'
                WHERE ordernumber = 'P2411300006515' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414185'
                WHERE ordernumber = 'P2411300006992' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430443'
                WHERE ordernumber = 'P2411300007088' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334890'
                WHERE ordernumber = 'P2411300007268' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432451'
                WHERE ordernumber = 'P2411300007357' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224008'
                WHERE ordernumber = 'P2411300007682' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432452'
                WHERE ordernumber = 'P2411300007810' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432451'
                WHERE ordernumber = 'P2411300008131' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123989'
                WHERE ordernumber = 'P2411300008285' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431403'
                WHERE ordernumber = 'P2411300008470' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380229'
                WHERE ordernumber = 'P2411300008686' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343382'
                WHERE ordernumber = 'P2411300008778' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286106'
                WHERE ordernumber = 'P2411300008851' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432453'
                WHERE ordernumber = 'P2411300008966' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432454'
                WHERE ordernumber = 'P2411300009187' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395898'
                WHERE ordernumber = 'P2411300009824' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432455'
                WHERE ordernumber = 'P2411300010055' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432455'
                WHERE ordernumber = 'P2411300010116' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432456'
                WHERE ordernumber = 'P2411300010241' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432459'
                WHERE ordernumber = 'P2411300010517' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395293'
                WHERE ordernumber = 'P2411300010761' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P2411300010945' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432457'
                WHERE ordernumber = 'P2411300011182' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350407'
                WHERE ordernumber = 'P2411300011253' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380966'
                WHERE ordernumber = 'P2411300011497' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352390'
                WHERE ordernumber = 'P2411300011686' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432458'
                WHERE ordernumber = 'P2411300011864' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281882'
                WHERE ordernumber = 'P2411300011986' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334136'
                WHERE ordernumber = 'P2411300012147' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432460'
                WHERE ordernumber = 'P2411300012224' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98089'
                WHERE ordernumber = 'P2411300012697' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110525'
                WHERE ordernumber = 'P2411300012938' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90879'
                WHERE ordernumber = 'P2411300013056' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430793'
                WHERE ordernumber = 'P2411300013143' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269439'
                WHERE ordernumber = 'P2411300013537' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432463'
                WHERE ordernumber = 'P2411300013727' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432464'
                WHERE ordernumber = 'P2411300013812' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242845'
                WHERE ordernumber = 'P2411300013997' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431087'
                WHERE ordernumber = 'P2411300014296' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208665'
                WHERE ordernumber = 'P2411300014421' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432466'
                WHERE ordernumber = 'P2411300014761' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242845'
                WHERE ordernumber = 'P2411300014819' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '34429'
                WHERE ordernumber = 'P2411300014988' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432467'
                WHERE ordernumber = 'P2411300015065' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430205'
                WHERE ordernumber = 'P2411300015176' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128525'
                WHERE ordernumber = 'P2411300015285' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432468'
                WHERE ordernumber = 'P2411300015489' 
            
2024-12-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428898'
                WHERE ordernumber = 'P2411300015560' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432469'
                WHERE ordernumber = 'P2411300015664' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392634'
                WHERE ordernumber = 'P2411300015965' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432470'
                WHERE ordernumber = 'P2411300016166' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431257'
                WHERE ordernumber = 'P2411300016255' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432472'
                WHERE ordernumber = 'P2411300016387' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432473'
                WHERE ordernumber = 'P2411300016438' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432473'
                WHERE ordernumber = 'P2411300016510' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432474'
                WHERE ordernumber = 'P2411300016671' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432475'
                WHERE ordernumber = 'P2411300016950' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432477'
                WHERE ordernumber = 'P2411300017012' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428711'
                WHERE ordernumber = 'P2411300017166' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432478'
                WHERE ordernumber = 'P2411300017242' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239889'
                WHERE ordernumber = 'P2411300017320' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293892'
                WHERE ordernumber = 'P2411300017497' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400675'
                WHERE ordernumber = 'P2411300017510' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432476'
                WHERE ordernumber = 'P2411300017657' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143274'
                WHERE ordernumber = 'P2411300017737' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432479'
                WHERE ordernumber = 'P2411300017926' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337747'
                WHERE ordernumber = 'P2411300018030' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432480'
                WHERE ordernumber = 'P2411300018186' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346877'
                WHERE ordernumber = 'P2411300018244' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403430'
                WHERE ordernumber = 'P2411300018386' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432481'
                WHERE ordernumber = 'P2411300018410' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432482'
                WHERE ordernumber = 'P2411300018558' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432485'
                WHERE ordernumber = 'P2411300018831' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432484'
                WHERE ordernumber = 'P2411300018925' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431403'
                WHERE ordernumber = 'P2411300019215' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283784'
                WHERE ordernumber = 'P2411300019411' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432486'
                WHERE ordernumber = 'P2411300019621' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432487'
                WHERE ordernumber = 'P2411300019742' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141930'
                WHERE ordernumber = 'P2411300019996' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '451'
                WHERE ordernumber = 'P2411300020141' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432488'
                WHERE ordernumber = 'P2411300020271' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432490'
                WHERE ordernumber = 'P2411300020435' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432489'
                WHERE ordernumber = 'P2411300020775' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '451'
                WHERE ordernumber = 'P2411300020839' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248412'
                WHERE ordernumber = 'P2411300020952' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P2411300021324' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '56884'
                WHERE ordernumber = 'P2411300021478' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432492'
                WHERE ordernumber = 'P2411300021546' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P2411300021770' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384130'
                WHERE ordernumber = 'P2411300022042' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '17928'
                WHERE ordernumber = 'P2411300022173' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110899'
                WHERE ordernumber = 'P2411300022236' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112931'
                WHERE ordernumber = 'P2411300022571' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432497'
                WHERE ordernumber = 'P2411300022858' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432498'
                WHERE ordernumber = 'P2411300023038' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65135'
                WHERE ordernumber = 'P2411300023157' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432499'
                WHERE ordernumber = 'P2411300023486' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109679'
                WHERE ordernumber = 'P2411300023521' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432151'
                WHERE ordernumber = 'P2411300023766' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432500'
                WHERE ordernumber = 'P2411300023953' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432501'
                WHERE ordernumber = 'P2411300024038' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290726'
                WHERE ordernumber = 'P2411300024190' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432505'
                WHERE ordernumber = 'P2411300024420' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432502'
                WHERE ordernumber = 'P2411300024652' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256450'
                WHERE ordernumber = 'P2411300024784' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432508'
                WHERE ordernumber = 'P2411300024840' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432508'
                WHERE ordernumber = 'P2411300024974' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432507'
                WHERE ordernumber = 'P2411300025014' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217936'
                WHERE ordernumber = 'P2411300025369' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432509'
                WHERE ordernumber = 'P2411300025481' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432511'
                WHERE ordernumber = 'P2411300025691' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432510'
                WHERE ordernumber = 'P2411300025733' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432512'
                WHERE ordernumber = 'P2411300025855' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432388'
                WHERE ordernumber = 'P2411300026329' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406753'
                WHERE ordernumber = 'P2411300026471' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104451'
                WHERE ordernumber = 'P2411300026511' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248185'
                WHERE ordernumber = 'P2411300026888' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432514'
                WHERE ordernumber = 'P2411300026935' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353814'
                WHERE ordernumber = 'P2411300027426' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248374'
                WHERE ordernumber = 'P2411300027523' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432516'
                WHERE ordernumber = 'P2411300027843' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432515'
                WHERE ordernumber = 'P2411300027975' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '195854'
                WHERE ordernumber = 'P2411300028237' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432517'
                WHERE ordernumber = 'P2411300028519' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431921'
                WHERE ordernumber = 'P2411300028687' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '881'
                WHERE ordernumber = 'P2411300028756' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432518'
                WHERE ordernumber = 'P2411300028813' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432519'
                WHERE ordernumber = 'P2411300028920' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238560'
                WHERE ordernumber = 'P2411300029175' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432520'
                WHERE ordernumber = 'P2411300029284' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432521'
                WHERE ordernumber = 'P2411300029522' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314044'
                WHERE ordernumber = 'P2411300029976' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432524'
                WHERE ordernumber = 'P2411300030333' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432168'
                WHERE ordernumber = 'P2411300030624' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432527'
                WHERE ordernumber = 'P2411300030843' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432525'
                WHERE ordernumber = 'P2411300030966' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379990'
                WHERE ordernumber = 'P2411300031016' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106604'
                WHERE ordernumber = 'P2411300031117' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432528'
                WHERE ordernumber = 'P2411300031317' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431961'
                WHERE ordernumber = 'P2411300031496' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425772'
                WHERE ordernumber = 'P2411300031535' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432530'
                WHERE ordernumber = 'P2411300031626' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432529'
                WHERE ordernumber = 'P2411300031850' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110492'
                WHERE ordernumber = 'P2411300031947' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89284'
                WHERE ordernumber = 'P2411300032082' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432531'
                WHERE ordernumber = 'P2411300032150' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255661'
                WHERE ordernumber = 'P2411300032218' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432532'
                WHERE ordernumber = 'P2411300032329' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432533'
                WHERE ordernumber = 'P2411300032541' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432404'
                WHERE ordernumber = 'P2411300032635' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432534'
                WHERE ordernumber = 'P2411300032726' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432535'
                WHERE ordernumber = 'P2411300032881' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432536'
                WHERE ordernumber = 'P2411300032926' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428401'
                WHERE ordernumber = 'P2411300033091' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121888'
                WHERE ordernumber = 'P2411300033233' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375648'
                WHERE ordernumber = 'P2411300033310' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344253'
                WHERE ordernumber = 'P2411300033445' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432539'
                WHERE ordernumber = 'P2411300033650' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432540'
                WHERE ordernumber = 'P2411300033797' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432543'
                WHERE ordernumber = 'P2411300033938' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243170'
                WHERE ordernumber = 'P2411300034046' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304578'
                WHERE ordernumber = 'P2411300034137' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422262'
                WHERE ordernumber = 'P2411300034251' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432537'
                WHERE ordernumber = 'P2411300034397' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432544'
                WHERE ordernumber = 'P2411300034539' 
            
2024-12-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432546'
                WHERE ordernumber = 'P2411300034617' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432548'
                WHERE ordernumber = 'P2411300034761' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432549'
                WHERE ordernumber = 'P2411300034961' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432545'
                WHERE ordernumber = 'P2411300035033' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219473'
                WHERE ordernumber = 'P2411300035184' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251553'
                WHERE ordernumber = 'P2411300035559' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '144795'
                WHERE ordernumber = 'P2411300035749' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411711'
                WHERE ordernumber = 'P2411300036117' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432550'
                WHERE ordernumber = 'P2411300036375' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285944'
                WHERE ordernumber = 'P2411300036799' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424047'
                WHERE ordernumber = 'P2411300037056' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432551'
                WHERE ordernumber = 'P2411300037152' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143981'
                WHERE ordernumber = 'P2411300037296' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224517'
                WHERE ordernumber = 'P2411300037338' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432553'
                WHERE ordernumber = 'P2411300037457' 
            
2024-12-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432554'
                WHERE ordernumber = 'P2411300037542'