2024-11-16 01:00:02 -- 將會員中心id寫入data-lake
2024-11-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-11-15%';
        
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283168'
                WHERE ordernumber = 'P2411150000198' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399673'
                WHERE ordernumber = 'P2411150000297' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396700'
                WHERE ordernumber = 'P2411150000388' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102473'
                WHERE ordernumber = 'P2411150000528' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '713'
                WHERE ordernumber = 'P2411150000673' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214813'
                WHERE ordernumber = 'P2411150000754' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132653'
                WHERE ordernumber = 'P2411150000818' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2411150000958' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P2411150001040' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430304'
                WHERE ordernumber = 'P2411150001137' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382153'
                WHERE ordernumber = 'P2411150001272' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430305'
                WHERE ordernumber = 'P2411150001322' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '120933'
                WHERE ordernumber = 'P2411150001438' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430307'
                WHERE ordernumber = 'P2411150001748' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429406'
                WHERE ordernumber = 'P2411150001844' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320673'
                WHERE ordernumber = 'P2411150002360' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '54776'
                WHERE ordernumber = 'P2411150002457' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98337'
                WHERE ordernumber = 'P2411150002671' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430310'
                WHERE ordernumber = 'P2411150002782' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365159'
                WHERE ordernumber = 'P2411150002852' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315279'
                WHERE ordernumber = 'P2411150003097' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391488'
                WHERE ordernumber = 'P2411150003288' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429895'
                WHERE ordernumber = 'P2411150003471' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390066'
                WHERE ordernumber = 'P2411150003782' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385657'
                WHERE ordernumber = 'P2411150003810' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167291'
                WHERE ordernumber = 'P2411150004070' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430311'
                WHERE ordernumber = 'P2411150004224' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430312'
                WHERE ordernumber = 'P2411150004391' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430312'
                WHERE ordernumber = 'P2411150004545' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302669'
                WHERE ordernumber = 'P2411150004626' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430313'
                WHERE ordernumber = 'P2411150004734' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430316'
                WHERE ordernumber = 'P2411150005199' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270906'
                WHERE ordernumber = 'P2411150005399' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429505'
                WHERE ordernumber = 'P2411150005596' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339052'
                WHERE ordernumber = 'P2411150005735' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270515'
                WHERE ordernumber = 'P2411150005899' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425428'
                WHERE ordernumber = 'P2411150005933' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252548'
                WHERE ordernumber = 'P2411150006035' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430318'
                WHERE ordernumber = 'P2411150006275' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430319'
                WHERE ordernumber = 'P2411150006495' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353941'
                WHERE ordernumber = 'P2411150006658' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410211'
                WHERE ordernumber = 'P2411150006940' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259307'
                WHERE ordernumber = 'P2411150007087' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88867'
                WHERE ordernumber = 'P2411150007266' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430320'
                WHERE ordernumber = 'P2411150007427' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430322'
                WHERE ordernumber = 'P2411150007630' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244672'
                WHERE ordernumber = 'P2411150007867' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424995'
                WHERE ordernumber = 'P2411150008127' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430324'
                WHERE ordernumber = 'P2411150008786' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93756'
                WHERE ordernumber = 'P2411150008859' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430325'
                WHERE ordernumber = 'P2411150008984' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430326'
                WHERE ordernumber = 'P2411150009114' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430328'
                WHERE ordernumber = 'P2411150009358' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294000'
                WHERE ordernumber = 'P2411150009412' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391604'
                WHERE ordernumber = 'P2411150009551' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430174'
                WHERE ordernumber = 'P2411150009742' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270523'
                WHERE ordernumber = 'P2411150009918' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430145'
                WHERE ordernumber = 'P2411150010086' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430330'
                WHERE ordernumber = 'P2411150010182' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430332'
                WHERE ordernumber = 'P2411150010249' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430331'
                WHERE ordernumber = 'P2411150010347' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430333'
                WHERE ordernumber = 'P2411150010662' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430334'
                WHERE ordernumber = 'P2411150010769' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430336'
                WHERE ordernumber = 'P2411150010988' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430337'
                WHERE ordernumber = 'P2411150011071' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430335'
                WHERE ordernumber = 'P2411150011144' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430338'
                WHERE ordernumber = 'P2411150011230' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398629'
                WHERE ordernumber = 'P2411150011375' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389594'
                WHERE ordernumber = 'P2411150011477' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287246'
                WHERE ordernumber = 'P2411150011817' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430340'
                WHERE ordernumber = 'P2411150012029' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275812'
                WHERE ordernumber = 'P2411150012214' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430342'
                WHERE ordernumber = 'P2411150012428' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278683'
                WHERE ordernumber = 'P2411150012553' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286464'
                WHERE ordernumber = 'P2411150012913' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94814'
                WHERE ordernumber = 'P2411150013036' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324229'
                WHERE ordernumber = 'P2411150013210' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400212'
                WHERE ordernumber = 'P2411150013578' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430343'
                WHERE ordernumber = 'P2411150013774' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430344'
                WHERE ordernumber = 'P2411150014042' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430343'
                WHERE ordernumber = 'P2411150014194' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386613'
                WHERE ordernumber = 'P2411150014335' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231387'
                WHERE ordernumber = 'P2411150014459' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249350'
                WHERE ordernumber = 'P2411150014746' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430348'
                WHERE ordernumber = 'P2411150014995' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340903'
                WHERE ordernumber = 'P2411150015029' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430349'
                WHERE ordernumber = 'P2411150015240' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284599'
                WHERE ordernumber = 'P2411150015670' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284924'
                WHERE ordernumber = 'P2411150015872' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406981'
                WHERE ordernumber = 'P2411150015940' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283039'
                WHERE ordernumber = 'P2411150016194' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '3334'
                WHERE ordernumber = 'P2411150016213' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430351'
                WHERE ordernumber = 'P2411150016362' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430352'
                WHERE ordernumber = 'P2411150016431' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258030'
                WHERE ordernumber = 'P2411150016582' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430354'
                WHERE ordernumber = 'P2411150016850' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334332'
                WHERE ordernumber = 'P2411150016940' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430356'
                WHERE ordernumber = 'P2411150017187' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430355'
                WHERE ordernumber = 'P2411150017222' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393066'
                WHERE ordernumber = 'P2411150017315' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430357'
                WHERE ordernumber = 'P2411150017440' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423672'
                WHERE ordernumber = 'P2411150017675' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344745'
                WHERE ordernumber = 'P2411150017722' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308887'
                WHERE ordernumber = 'P2411150017933' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426496'
                WHERE ordernumber = 'P2411150018082' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430358'
                WHERE ordernumber = 'P2411150018115' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430359'
                WHERE ordernumber = 'P2411150018448' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343936'
                WHERE ordernumber = 'P2411150018734' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430360'
                WHERE ordernumber = 'P2411150018944' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118999'
                WHERE ordernumber = 'P2411150019020' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65115'
                WHERE ordernumber = 'P2411150019218' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430362'
                WHERE ordernumber = 'P2411150019443' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424106'
                WHERE ordernumber = 'P2411150019595' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234886'
                WHERE ordernumber = 'P2411150019691' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430369'
                WHERE ordernumber = 'P2411150019897' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379300'
                WHERE ordernumber = 'P2411150020066' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429942'
                WHERE ordernumber = 'P2411150020217' 
            
2024-11-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232055'
                WHERE ordernumber = 'P2411150020543' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102960'
                WHERE ordernumber = 'P2411150020658' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430371'
                WHERE ordernumber = 'P2411150020831' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388725'
                WHERE ordernumber = 'P2411150020948' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87028'
                WHERE ordernumber = 'P2411150021195' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430372'
                WHERE ordernumber = 'P2411150021259' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430055'
                WHERE ordernumber = 'P2411150021466' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430373'
                WHERE ordernumber = 'P2411150021595' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430375'
                WHERE ordernumber = 'P2411150021889' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307696'
                WHERE ordernumber = 'P2411150022025' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430376'
                WHERE ordernumber = 'P2411150022543' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216607'
                WHERE ordernumber = 'P2411150022794' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343179'
                WHERE ordernumber = 'P2411150023094' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430376'
                WHERE ordernumber = 'P2411150023198' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323002'
                WHERE ordernumber = 'P2411150023356' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430377'
                WHERE ordernumber = 'P2411150023421' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98920'
                WHERE ordernumber = 'P2411150023524' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233873'
                WHERE ordernumber = 'P2411150023669' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430378'
                WHERE ordernumber = 'P2411150023756' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430380'
                WHERE ordernumber = 'P2411150024291' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '53920'
                WHERE ordernumber = 'P2411150024541' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378809'
                WHERE ordernumber = 'P2411150025060' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350181'
                WHERE ordernumber = 'P2411150025599' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '170060'
                WHERE ordernumber = 'P2411150025884' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221452'
                WHERE ordernumber = 'P2411150026263' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424945'
                WHERE ordernumber = 'P2411150026683' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221452'
                WHERE ordernumber = 'P2411150026739' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110736'
                WHERE ordernumber = 'P2411150027071' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430389'
                WHERE ordernumber = 'P2411150027245' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430388'
                WHERE ordernumber = 'P2411150027318' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430390'
                WHERE ordernumber = 'P2411150027420' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430391'
                WHERE ordernumber = 'P2411150027613' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226174'
                WHERE ordernumber = 'P2411150027863' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430392'
                WHERE ordernumber = 'P2411150027925' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165293'
                WHERE ordernumber = 'P2411150028117' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301616'
                WHERE ordernumber = 'P2411150028257' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424260'
                WHERE ordernumber = 'P2411150028465' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382426'
                WHERE ordernumber = 'P2411150028541' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364943'
                WHERE ordernumber = 'P2411150028820' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P2411150028939' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430398'
                WHERE ordernumber = 'P2411150029113' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430399'
                WHERE ordernumber = 'P2411150029241' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235646'
                WHERE ordernumber = 'P2411150029372' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388725'
                WHERE ordernumber = 'P2411150029566' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430400'
                WHERE ordernumber = 'P2411150029677' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430385'
                WHERE ordernumber = 'P2411150029769' 
            
2024-11-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427922'
                WHERE ordernumber = 'P2411150029822'