2024-12-02 01:00:01 -- 將會員中心id寫入data-lake
2024-12-02 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-12-01%';
        
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95310'
                WHERE ordernumber = 'P2412010000112' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425490'
                WHERE ordernumber = 'P2412010000274' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '327936'
                WHERE ordernumber = 'P2412010000395' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291184'
                WHERE ordernumber = 'P2412010000587' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236208'
                WHERE ordernumber = 'P2412010000647' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397754'
                WHERE ordernumber = 'P2412010000892' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432583'
                WHERE ordernumber = 'P2412010000952' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432585'
                WHERE ordernumber = 'P2412010001035' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432586'
                WHERE ordernumber = 'P2412010001245' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432588'
                WHERE ordernumber = 'P2412010001314' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432584'
                WHERE ordernumber = 'P2412010001498' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420969'
                WHERE ordernumber = 'P2412010001645' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430298'
                WHERE ordernumber = 'P2412010001741' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247082'
                WHERE ordernumber = 'P2412010001859' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432590'
                WHERE ordernumber = 'P2412010001920' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432591'
                WHERE ordernumber = 'P2412010002058' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432592'
                WHERE ordernumber = 'P2412010002184' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432593'
                WHERE ordernumber = 'P2412010002272' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432591'
                WHERE ordernumber = 'P2412010002426' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424461'
                WHERE ordernumber = 'P2412010002416' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '71351'
                WHERE ordernumber = 'P2412010002621' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432596'
                WHERE ordernumber = 'P2412010002949' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432595'
                WHERE ordernumber = 'P2412010003035' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397994'
                WHERE ordernumber = 'P2412010003119' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248757'
                WHERE ordernumber = 'P2412010003235' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432597'
                WHERE ordernumber = 'P2412010003376' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102428'
                WHERE ordernumber = 'P2412010003531' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432598'
                WHERE ordernumber = 'P2412010003639' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432599'
                WHERE ordernumber = 'P2412010003814' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264863'
                WHERE ordernumber = 'P2412010003945' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432602'
                WHERE ordernumber = 'P2412010004076' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432604'
                WHERE ordernumber = 'P2412010004291' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432605'
                WHERE ordernumber = 'P2412010004451' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432606'
                WHERE ordernumber = 'P2412010004597' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234310'
                WHERE ordernumber = 'P2412010004727' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432607'
                WHERE ordernumber = 'P2412010004885' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247870'
                WHERE ordernumber = 'P2412010004929' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432608'
                WHERE ordernumber = 'P2412010005580' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380001'
                WHERE ordernumber = 'P2412010005645' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425720'
                WHERE ordernumber = 'P2412010006033' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296591'
                WHERE ordernumber = 'P2412010006275' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284501'
                WHERE ordernumber = 'P2412010006460' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432610'
                WHERE ordernumber = 'P2412010006677' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432611'
                WHERE ordernumber = 'P2412010006730' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432612'
                WHERE ordernumber = 'P2412010006953' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365566'
                WHERE ordernumber = 'P2412010007474' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432614'
                WHERE ordernumber = 'P2412010007621' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432615'
                WHERE ordernumber = 'P2412010007956' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274867'
                WHERE ordernumber = 'P2412010008057' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250733'
                WHERE ordernumber = 'P2412010008183' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432616'
                WHERE ordernumber = 'P2412010008250' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432620'
                WHERE ordernumber = 'P2412010008380' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428462'
                WHERE ordernumber = 'P2412010008452' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432622'
                WHERE ordernumber = 'P2412010008651' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432621'
                WHERE ordernumber = 'P2412010008721' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432623'
                WHERE ordernumber = 'P2412010008951' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389522'
                WHERE ordernumber = 'P2412010009064' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236708'
                WHERE ordernumber = 'P2412010009252' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432625'
                WHERE ordernumber = 'P2412010009344' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '361100'
                WHERE ordernumber = 'P2412010009762' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248682'
                WHERE ordernumber = 'P2412010010125' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432626'
                WHERE ordernumber = 'P2412010010362' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432628'
                WHERE ordernumber = 'P2412010010590' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2412010010649' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432629'
                WHERE ordernumber = 'P2412010010797' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99647'
                WHERE ordernumber = 'P2412010010849' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81645'
                WHERE ordernumber = 'P2412010010978' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270599'
                WHERE ordernumber = 'P2412010011056' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432633'
                WHERE ordernumber = 'P2412010011170' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432634'
                WHERE ordernumber = 'P2412010011283' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393473'
                WHERE ordernumber = 'P2412010011590' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432630'
                WHERE ordernumber = 'P2412010011669' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432636'
                WHERE ordernumber = 'P2412010011857' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245453'
                WHERE ordernumber = 'P2412010011977' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432636'
                WHERE ordernumber = 'P2412010012054' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432637'
                WHERE ordernumber = 'P2412010012274' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432638'
                WHERE ordernumber = 'P2412010012383' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432639'
                WHERE ordernumber = 'P2412010012576' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98149'
                WHERE ordernumber = 'P2412010012626' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432641'
                WHERE ordernumber = 'P2412010012836' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432642'
                WHERE ordernumber = 'P2412010012996' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '182404'
                WHERE ordernumber = 'P2412010013111' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429814'
                WHERE ordernumber = 'P2412010013221' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248668'
                WHERE ordernumber = 'P2412010013498' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432643'
                WHERE ordernumber = 'P2412010013786' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432645'
                WHERE ordernumber = 'P2412010013980' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432646'
                WHERE ordernumber = 'P2412010014077' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237360'
                WHERE ordernumber = 'P2412010014186' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '147583'
                WHERE ordernumber = 'P2412010014260' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432647'
                WHERE ordernumber = 'P2412010014488' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432649'
                WHERE ordernumber = 'P2412010014725' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432650'
                WHERE ordernumber = 'P2412010015362' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286337'
                WHERE ordernumber = 'P2412010015481' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432653'
                WHERE ordernumber = 'P2412010015755' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429508'
                WHERE ordernumber = 'P2412010015940' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432654'
                WHERE ordernumber = 'P2412010016040' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432656'
                WHERE ordernumber = 'P2412010016664' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432651'
                WHERE ordernumber = 'P2412010016868' 
            
2024-12-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432651'
                WHERE ordernumber = 'P2412010016980' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432648'
                WHERE ordernumber = 'P2412010017051' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381052'
                WHERE ordernumber = 'P2412010017892' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380743'
                WHERE ordernumber = 'P2412010017925' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432660'
                WHERE ordernumber = 'P2412010018069' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432662'
                WHERE ordernumber = 'P2412010018190' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432663'
                WHERE ordernumber = 'P2412010018267' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432660'
                WHERE ordernumber = 'P2412010018357' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141777'
                WHERE ordernumber = 'P2412010018474' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432661'
                WHERE ordernumber = 'P2412010018597' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149078'
                WHERE ordernumber = 'P2412010018635' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432664'
                WHERE ordernumber = 'P2412010019159' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432461'
                WHERE ordernumber = 'P2412010019229' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100488'
                WHERE ordernumber = 'P2412010019348' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432665'
                WHERE ordernumber = 'P2412010019463' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397882'
                WHERE ordernumber = 'P2412010019514' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430511'
                WHERE ordernumber = 'P2412010019691' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432668'
                WHERE ordernumber = 'P2412010019932' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432668'
                WHERE ordernumber = 'P2412010020062' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295570'
                WHERE ordernumber = 'P2412010020147' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115796'
                WHERE ordernumber = 'P2412010020350' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432666'
                WHERE ordernumber = 'P2412010020454' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282424'
                WHERE ordernumber = 'P2412010020775' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428641'
                WHERE ordernumber = 'P2412010020942' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423594'
                WHERE ordernumber = 'P2412010021429' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309283'
                WHERE ordernumber = 'P2412010021519' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209267'
                WHERE ordernumber = 'P2412010021640' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P2412010021757' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432674'
                WHERE ordernumber = 'P2412010021876' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432672'
                WHERE ordernumber = 'P2412010021927' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432673'
                WHERE ordernumber = 'P2412010022197' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430349'
                WHERE ordernumber = 'P2412010022239' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432676'
                WHERE ordernumber = 'P2412010022313' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430557'
                WHERE ordernumber = 'P2412010023110' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431597'
                WHERE ordernumber = 'P2412010023215' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395318'
                WHERE ordernumber = 'P2412010023454' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432680'
                WHERE ordernumber = 'P2412010023518' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65626'
                WHERE ordernumber = 'P2412010023792' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432682'
                WHERE ordernumber = 'P2412010024052' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256077'
                WHERE ordernumber = 'P2412010024288' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118323'
                WHERE ordernumber = 'P2412010024335' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432684'
                WHERE ordernumber = 'P2412010024484' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131372'
                WHERE ordernumber = 'P2412010024510' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432685'
                WHERE ordernumber = 'P2412010024644' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280392'
                WHERE ordernumber = 'P2412010024736' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432686'
                WHERE ordernumber = 'P2412010025135' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432687'
                WHERE ordernumber = 'P2412010025296' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432688'
                WHERE ordernumber = 'P2412010025495' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432689'
                WHERE ordernumber = 'P2412010025871' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432690'
                WHERE ordernumber = 'P2412010025913' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432692'
                WHERE ordernumber = 'P2412010026055' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142180'
                WHERE ordernumber = 'P2412010026195' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248589'
                WHERE ordernumber = 'P2412010026476' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432695'
                WHERE ordernumber = 'P2412010026749' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237666'
                WHERE ordernumber = 'P2412010026823' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432698'
                WHERE ordernumber = 'P2412010027154' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432165'
                WHERE ordernumber = 'P2412010027258' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379527'
                WHERE ordernumber = 'P2412010027332' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432699'
                WHERE ordernumber = 'P2412010027496' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432700'
                WHERE ordernumber = 'P2412010027573' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136864'
                WHERE ordernumber = 'P2412010027614' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96862'
                WHERE ordernumber = 'P2412010027711' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432703'
                WHERE ordernumber = 'P2412010028443' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240724'
                WHERE ordernumber = 'P2412010028591' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432706'
                WHERE ordernumber = 'P2412010028773' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432671'
                WHERE ordernumber = 'P2412010028911' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428591'
                WHERE ordernumber = 'P2412010029285' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396899'
                WHERE ordernumber = 'P2412010029440' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428592'
                WHERE ordernumber = 'P2412010029556' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432705'
                WHERE ordernumber = 'P2412010029614' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270166'
                WHERE ordernumber = 'P2412010029797' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94550'
                WHERE ordernumber = 'P2412010029895' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262148'
                WHERE ordernumber = 'P2412010030124' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276752'
                WHERE ordernumber = 'P2412010030348' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432709'
                WHERE ordernumber = 'P2412010030572' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432710'
                WHERE ordernumber = 'P2412010030766' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2412010031026' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432712'
                WHERE ordernumber = 'P2412010031263' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432715'
                WHERE ordernumber = 'P2412010031355' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432713'
                WHERE ordernumber = 'P2412010031421' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432716'
                WHERE ordernumber = 'P2412010031751' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432718'
                WHERE ordernumber = 'P2412010032192' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432720'
                WHERE ordernumber = 'P2412010032537' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432720'
                WHERE ordernumber = 'P2412010032625' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314801'
                WHERE ordernumber = 'P2412010032756' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432723'
                WHERE ordernumber = 'P2412010032862' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400885'
                WHERE ordernumber = 'P2412010032965' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432723'
                WHERE ordernumber = 'P2412010033023' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2412010033426' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236290'
                WHERE ordernumber = 'P2412010033510' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167292'
                WHERE ordernumber = 'P2412010033732' 
            
2024-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165635'
                WHERE ordernumber = 'P2412010033873'