2024-11-25 01:00:02 -- 將會員中心id寫入data-lake
2024-11-25 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-24%';
        
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283437'
                WHERE ordernumber = 'P2411240000146' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283437'
                WHERE ordernumber = 'P2411240000292' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238572'
                WHERE ordernumber = 'P2411240000366' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422446'
                WHERE ordernumber = 'P2411240000574' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374231'
                WHERE ordernumber = 'P2411240000925' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431171'
                WHERE ordernumber = 'P2411240001027' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230677'
                WHERE ordernumber = 'P2411240001181' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118801'
                WHERE ordernumber = 'P2411240001221' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389574'
                WHERE ordernumber = 'P2411240001593' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280077'
                WHERE ordernumber = 'P2411240001628' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431555'
                WHERE ordernumber = 'P2411240001795' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431553'
                WHERE ordernumber = 'P2411240001959' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431556'
                WHERE ordernumber = 'P2411240002277' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245281'
                WHERE ordernumber = 'P2411240002485' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431557'
                WHERE ordernumber = 'P2411240002572' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431559'
                WHERE ordernumber = 'P2411240002676' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431558'
                WHERE ordernumber = 'P2411240002781' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395391'
                WHERE ordernumber = 'P2411240002865' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430443'
                WHERE ordernumber = 'P2411240002935' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431529'
                WHERE ordernumber = 'P2411240003094' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431561'
                WHERE ordernumber = 'P2411240003138' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431560'
                WHERE ordernumber = 'P2411240003285' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216890'
                WHERE ordernumber = 'P2411240003374' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431563'
                WHERE ordernumber = 'P2411240003487' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431562'
                WHERE ordernumber = 'P2411240003598' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431564'
                WHERE ordernumber = 'P2411240003726' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431565'
                WHERE ordernumber = 'P2411240004044' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '160402'
                WHERE ordernumber = 'P2411240004184' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '57347'
                WHERE ordernumber = 'P2411240004258' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431567'
                WHERE ordernumber = 'P2411240004454' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431568'
                WHERE ordernumber = 'P2411240004530' 
            
2024-11-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309074'
                WHERE ordernumber = 'P2411240004657' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431571'
                WHERE ordernumber = 'P2411240004811' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431569'
                WHERE ordernumber = 'P2411240005027' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431569'
                WHERE ordernumber = 'P2411240005122' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431572'
                WHERE ordernumber = 'P2411240005325' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429486'
                WHERE ordernumber = 'P2411240005484' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431576'
                WHERE ordernumber = 'P2411240005522' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283493'
                WHERE ordernumber = 'P2411240005699' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431578'
                WHERE ordernumber = 'P2411240005896' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431577'
                WHERE ordernumber = 'P2411240005985' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431574'
                WHERE ordernumber = 'P2411240006033' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431579'
                WHERE ordernumber = 'P2411240006570' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431582'
                WHERE ordernumber = 'P2411240006631' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354158'
                WHERE ordernumber = 'P2411240006754' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416337'
                WHERE ordernumber = 'P2411240006825' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350993'
                WHERE ordernumber = 'P2411240006912' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431584'
                WHERE ordernumber = 'P2411240007064' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424855'
                WHERE ordernumber = 'P2411240007242' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424855'
                WHERE ordernumber = 'P2411240007347' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431585'
                WHERE ordernumber = 'P2411240007781' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96631'
                WHERE ordernumber = 'P2411240008019' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431586'
                WHERE ordernumber = 'P2411240008231' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260405'
                WHERE ordernumber = 'P2411240008347' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427277'
                WHERE ordernumber = 'P2411240008524' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102335'
                WHERE ordernumber = 'P2411240008725' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389464'
                WHERE ordernumber = 'P2411240008914' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '148758'
                WHERE ordernumber = 'P2411240009162' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431587'
                WHERE ordernumber = 'P2411240009564' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238896'
                WHERE ordernumber = 'P2411240009736' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431592'
                WHERE ordernumber = 'P2411240010412' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431591'
                WHERE ordernumber = 'P2411240010629' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431593'
                WHERE ordernumber = 'P2411240010845' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360297'
                WHERE ordernumber = 'P2411240010937' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394327'
                WHERE ordernumber = 'P2411240011067' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429547'
                WHERE ordernumber = 'P2411240011389' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286093'
                WHERE ordernumber = 'P2411240011466' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431597'
                WHERE ordernumber = 'P2411240011937' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431595'
                WHERE ordernumber = 'P2411240012139' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431596'
                WHERE ordernumber = 'P2411240012359' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '152506'
                WHERE ordernumber = 'P2411240012512' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301815'
                WHERE ordernumber = 'P2411240012628' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97674'
                WHERE ordernumber = 'P2411240012846' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383719'
                WHERE ordernumber = 'P2411240013038' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97674'
                WHERE ordernumber = 'P2411240013178' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361358'
                WHERE ordernumber = 'P2411240013266' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431600'
                WHERE ordernumber = 'P2411240013360' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399425'
                WHERE ordernumber = 'P2411240013882' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347849'
                WHERE ordernumber = 'P2411240013944' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431601'
                WHERE ordernumber = 'P2411240014097' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281891'
                WHERE ordernumber = 'P2411240014185' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363091'
                WHERE ordernumber = 'P2411240014620' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363091'
                WHERE ordernumber = 'P2411240014721' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425661'
                WHERE ordernumber = 'P2411240014888' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431602'
                WHERE ordernumber = 'P2411240015064' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322383'
                WHERE ordernumber = 'P2411240015297' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423422'
                WHERE ordernumber = 'P2411240015376' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135323'
                WHERE ordernumber = 'P2411240015545' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321276'
                WHERE ordernumber = 'P2411240015662' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166311'
                WHERE ordernumber = 'P2411240015799' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260977'
                WHERE ordernumber = 'P2411240016035' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431605'
                WHERE ordernumber = 'P2411240016456' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234133'
                WHERE ordernumber = 'P2411240016581' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137725'
                WHERE ordernumber = 'P2411240016769' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431609'
                WHERE ordernumber = 'P2411240016870' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431607'
                WHERE ordernumber = 'P2411240016996' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371078'
                WHERE ordernumber = 'P2411240017079' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431610'
                WHERE ordernumber = 'P2411240017123' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292257'
                WHERE ordernumber = 'P2411240017498' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231400'
                WHERE ordernumber = 'P2411240017680' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431607'
                WHERE ordernumber = 'P2411240017719' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431613'
                WHERE ordernumber = 'P2411240018061' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231400'
                WHERE ordernumber = 'P2411240018129' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431612'
                WHERE ordernumber = 'P2411240018216' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314818'
                WHERE ordernumber = 'P2411240018380' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423449'
                WHERE ordernumber = 'P2411240018469' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360233'
                WHERE ordernumber = 'P2411240018645' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431611'
                WHERE ordernumber = 'P2411240019060' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255925'
                WHERE ordernumber = 'P2411240019176' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129091'
                WHERE ordernumber = 'P2411240019285' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431614'
                WHERE ordernumber = 'P2411240019380' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431617'
                WHERE ordernumber = 'P2411240019564' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426246'
                WHERE ordernumber = 'P2411240019772' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342632'
                WHERE ordernumber = 'P2411240019940' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431619'
                WHERE ordernumber = 'P2411240020086' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280077'
                WHERE ordernumber = 'P2411240020317' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285478'
                WHERE ordernumber = 'P2411240020627' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280077'
                WHERE ordernumber = 'P2411240020788' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431620'
                WHERE ordernumber = 'P2411240020831' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273434'
                WHERE ordernumber = 'P2411240020954' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '190612'
                WHERE ordernumber = 'P2411240021082' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229920'
                WHERE ordernumber = 'P2411240021243' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431622'
                WHERE ordernumber = 'P2411240021842' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431623'
                WHERE ordernumber = 'P2411240022169' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423411'
                WHERE ordernumber = 'P2411240022380' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431621'
                WHERE ordernumber = 'P2411240022532' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413462'
                WHERE ordernumber = 'P2411240022642' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431624'
                WHERE ordernumber = 'P2411240022786' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431627'
                WHERE ordernumber = 'P2411240023253' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431625'
                WHERE ordernumber = 'P2411240023374' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345721'
                WHERE ordernumber = 'P2411240023446' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396794'
                WHERE ordernumber = 'P2411240023635' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430239'
                WHERE ordernumber = 'P2411240024116' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431628'
                WHERE ordernumber = 'P2411240024354' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431629'
                WHERE ordernumber = 'P2411240024444' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427722'
                WHERE ordernumber = 'P2411240024641' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345721'
                WHERE ordernumber = 'P2411240024754' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387229'
                WHERE ordernumber = 'P2411240025154' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '189575'
                WHERE ordernumber = 'P2411240025230' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431631'
                WHERE ordernumber = 'P2411240025595' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426798'
                WHERE ordernumber = 'P2411240025870' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431632'
                WHERE ordernumber = 'P2411240026152' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431633'
                WHERE ordernumber = 'P2411240026322' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431634'
                WHERE ordernumber = 'P2411240026540' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410211'
                WHERE ordernumber = 'P2411240026859' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430165'
                WHERE ordernumber = 'P2411240026983' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427526'
                WHERE ordernumber = 'P2411240027085' 
            
2024-11-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424408'
                WHERE ordernumber = 'P2411240027269' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264832'
                WHERE ordernumber = 'P2411240027326' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409235'
                WHERE ordernumber = 'P2411240027515' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431638'
                WHERE ordernumber = 'P2411240027679' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431636'
                WHERE ordernumber = 'P2411240027872' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431642'
                WHERE ordernumber = 'P2411240028085' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '170493'
                WHERE ordernumber = 'P2411240028399' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431640'
                WHERE ordernumber = 'P2411240028860' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431645'
                WHERE ordernumber = 'P2411240029226' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431646'
                WHERE ordernumber = 'P2411240029326' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339940'
                WHERE ordernumber = 'P2411240029480' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339940'
                WHERE ordernumber = 'P2411240029620' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237622'
                WHERE ordernumber = 'P2411240029867' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278936'
                WHERE ordernumber = 'P2411240029976' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '48301'
                WHERE ordernumber = 'P2411240030086' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431543'
                WHERE ordernumber = 'P2411240030276' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262592'
                WHERE ordernumber = 'P2411240030332' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431651'
                WHERE ordernumber = 'P2411240030460' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431650'
                WHERE ordernumber = 'P2411240030792' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377580'
                WHERE ordernumber = 'P2411240031024' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431652'
                WHERE ordernumber = 'P2411240031195' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431654'
                WHERE ordernumber = 'P2411240031677' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431655'
                WHERE ordernumber = 'P2411240031744' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219550'
                WHERE ordernumber = 'P2411240032161' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431656'
                WHERE ordernumber = 'P2411240032244' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431658'
                WHERE ordernumber = 'P2411240032350' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431659'
                WHERE ordernumber = 'P2411240032586' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429482'
                WHERE ordernumber = 'P2411240033966' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314154'
                WHERE ordernumber = 'P2411240034091' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431661'
                WHERE ordernumber = 'P2411240034235' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431662'
                WHERE ordernumber = 'P2411240034319' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431663'
                WHERE ordernumber = 'P2411240034448' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431664'
                WHERE ordernumber = 'P2411240034540' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334948'
                WHERE ordernumber = 'P2411240034653' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427929'
                WHERE ordernumber = 'P2411240034739' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431598'
                WHERE ordernumber = 'P2411240034899' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431668'
                WHERE ordernumber = 'P2411240035943' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363219'
                WHERE ordernumber = 'P2411240036262' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431670'
                WHERE ordernumber = 'P2411240036660' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431671'
                WHERE ordernumber = 'P2411240036759' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423142'
                WHERE ordernumber = 'P2411240036974' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431667'
                WHERE ordernumber = 'P2411240037271' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426194'
                WHERE ordernumber = 'P2411240037398' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431675'
                WHERE ordernumber = 'P2411240037418' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431676'
                WHERE ordernumber = 'P2411240037591' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426194'
                WHERE ordernumber = 'P2411240037783' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431677'
                WHERE ordernumber = 'P2411240037835' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '91003'
                WHERE ordernumber = 'P2411240037971' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2411240038010' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431679'
                WHERE ordernumber = 'P2411240038226' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276582'
                WHERE ordernumber = 'P2411240038386' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265203'
                WHERE ordernumber = 'P2411240038411' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428342'
                WHERE ordernumber = 'P2411240038580' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431681'
                WHERE ordernumber = 'P2411240039040' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289391'
                WHERE ordernumber = 'P2411240039172' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388971'
                WHERE ordernumber = 'P2411240039214' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431683'
                WHERE ordernumber = 'P2411240039310' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431683'
                WHERE ordernumber = 'P2411240039472' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431684'
                WHERE ordernumber = 'P2411240039628' 
            
2024-11-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320706'
                WHERE ordernumber = 'P2411240039773'