2025-03-10 01:00:01 -- 將會員中心id寫入data-lake
2025-03-10 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 '2025-03-09%';
        
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281354'
                WHERE ordernumber = 'P2503090000011' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377742'
                WHERE ordernumber = 'P2503090000012' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '126845'
                WHERE ordernumber = 'P2503090000014' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136868'
                WHERE ordernumber = 'P2503090000015' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P2503090000016' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460124'
                WHERE ordernumber = 'P2503090000020' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460125'
                WHERE ordernumber = 'P2503090000022' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '126845'
                WHERE ordernumber = 'P2503090000023' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237069'
                WHERE ordernumber = 'P2503090000024' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460126'
                WHERE ordernumber = 'P2503090000026' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259849'
                WHERE ordernumber = 'P2503090000027' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240295'
                WHERE ordernumber = 'P2503090000030' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460128'
                WHERE ordernumber = 'P2503090000031' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136082'
                WHERE ordernumber = 'P2503090000034' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460131'
                WHERE ordernumber = 'P2503090000037' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460129'
                WHERE ordernumber = 'P2503090000038' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460128'
                WHERE ordernumber = 'P2503090000042' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394744'
                WHERE ordernumber = 'P2503090000044' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460132'
                WHERE ordernumber = 'P2503090000045' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460133'
                WHERE ordernumber = 'P2503090000046' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '181802'
                WHERE ordernumber = 'P2503090000047' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398430'
                WHERE ordernumber = 'P2503090000048' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460130'
                WHERE ordernumber = 'P2503090000049' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460130'
                WHERE ordernumber = 'P2503090000052' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460136'
                WHERE ordernumber = 'P2503090000054' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460134'
                WHERE ordernumber = 'P2503090000055' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460135'
                WHERE ordernumber = 'P2503090000058' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '148149'
                WHERE ordernumber = 'P2503090000064' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345872'
                WHERE ordernumber = 'P2503090000066' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460138'
                WHERE ordernumber = 'P2503090000067' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460138'
                WHERE ordernumber = 'P2503090000068' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328644'
                WHERE ordernumber = 'P2503090000069' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460140'
                WHERE ordernumber = 'P2503090000070' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460139'
                WHERE ordernumber = 'P2503090000071' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114930'
                WHERE ordernumber = 'P2503090000075' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460141'
                WHERE ordernumber = 'P2503090000078' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460141'
                WHERE ordernumber = 'P2503090000079' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460142'
                WHERE ordernumber = 'P2503090000081' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384168'
                WHERE ordernumber = 'P2503090000084' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435161'
                WHERE ordernumber = 'P2503090000087' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '184590'
                WHERE ordernumber = 'P2503090000090' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252285'
                WHERE ordernumber = 'P2503090000092' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460143'
                WHERE ordernumber = 'P2503090000095' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '184590'
                WHERE ordernumber = 'P2503090000096' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379109'
                WHERE ordernumber = 'P2503090000100' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276042'
                WHERE ordernumber = 'P2503090000102' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460146'
                WHERE ordernumber = 'P2503090000105' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460147'
                WHERE ordernumber = 'P2503090000107' 
            
2025-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460145'
                WHERE ordernumber = 'P2503090000109' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459893'
                WHERE ordernumber = 'P2503090000111' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460148'
                WHERE ordernumber = 'P2503090000113' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460144'
                WHERE ordernumber = 'P2503090000118' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460144'
                WHERE ordernumber = 'P2503090000120' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460152'
                WHERE ordernumber = 'P2503090000124' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460153'
                WHERE ordernumber = 'P2503090000128' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460155'
                WHERE ordernumber = 'P2503090000131' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460158'
                WHERE ordernumber = 'P2503090000132' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460156'
                WHERE ordernumber = 'P2503090000133' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460154'
                WHERE ordernumber = 'P2503090000134' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327917'
                WHERE ordernumber = 'P2503090000136' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460159'
                WHERE ordernumber = 'P2503090000138' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211882'
                WHERE ordernumber = 'P2503090000140' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459559'
                WHERE ordernumber = 'P2503090000141' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460162'
                WHERE ordernumber = 'P2503090000151' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343927'
                WHERE ordernumber = 'P2503090000153' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460163'
                WHERE ordernumber = 'P2503090000154' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457741'
                WHERE ordernumber = 'P2503090000155' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392263'
                WHERE ordernumber = 'P2503090000158' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460164'
                WHERE ordernumber = 'P2503090000166' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234716'
                WHERE ordernumber = 'P2503090000168' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248343'
                WHERE ordernumber = 'P2503090000170' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460166'
                WHERE ordernumber = 'P2503090000171' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460167'
                WHERE ordernumber = 'P2503090000174' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424541'
                WHERE ordernumber = 'P2503090000176' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460168'
                WHERE ordernumber = 'P2503090000177' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308928'
                WHERE ordernumber = 'P2503090000179' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421263'
                WHERE ordernumber = 'P2503090000184' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421263'
                WHERE ordernumber = 'P2503090000185' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385233'
                WHERE ordernumber = 'P2503090000188' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460171'
                WHERE ordernumber = 'P2503090000190' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460174'
                WHERE ordernumber = 'P2503090000191' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460175'
                WHERE ordernumber = 'P2503090000192' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460173'
                WHERE ordernumber = 'P2503090000193' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415119'
                WHERE ordernumber = 'P2503090000200' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460176'
                WHERE ordernumber = 'P2503090000203' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334987'
                WHERE ordernumber = 'P2503090000207' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239527'
                WHERE ordernumber = 'P2503090000208' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273629'
                WHERE ordernumber = 'P2503090000210' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460181'
                WHERE ordernumber = 'P2503090000214' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460180'
                WHERE ordernumber = 'P2503090000217' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259735'
                WHERE ordernumber = 'P2503090000218' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '181239'
                WHERE ordernumber = 'P2503090000220' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460182'
                WHERE ordernumber = 'P2503090000223' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218516'
                WHERE ordernumber = 'P2503090000225' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460183'
                WHERE ordernumber = 'P2503090000227' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460184'
                WHERE ordernumber = 'P2503090000235' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460185'
                WHERE ordernumber = 'P2503090000236' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347340'
                WHERE ordernumber = 'P2503090000239' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432814'
                WHERE ordernumber = 'P2503090000240' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460188'
                WHERE ordernumber = 'P2503090000243' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343961'
                WHERE ordernumber = 'P2503090000245' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460177'
                WHERE ordernumber = 'P2503090000246' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460177'
                WHERE ordernumber = 'P2503090000248' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460190'
                WHERE ordernumber = 'P2503090000249' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460192'
                WHERE ordernumber = 'P2503090000250' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460191'
                WHERE ordernumber = 'P2503090000252' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239719'
                WHERE ordernumber = 'P2503090000253' 
            
2025-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277647'
                WHERE ordernumber = 'P2503090000254' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457311'
                WHERE ordernumber = 'P2503090000257' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213784'
                WHERE ordernumber = 'P2503090000260' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460193'
                WHERE ordernumber = 'P2503090000262' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460194'
                WHERE ordernumber = 'P2503090000263' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460195'
                WHERE ordernumber = 'P2503090000265' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213784'
                WHERE ordernumber = 'P2503090000266' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433040'
                WHERE ordernumber = 'P2503090000268' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354800'
                WHERE ordernumber = 'P2503090000271' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460196'
                WHERE ordernumber = 'P2503090000277' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105896'
                WHERE ordernumber = 'P2503090000280' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460197'
                WHERE ordernumber = 'P2503090000281' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460198'
                WHERE ordernumber = 'P2503090000282' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '454914'
                WHERE ordernumber = 'P2503090000283' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460165'
                WHERE ordernumber = 'P2503090000284' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460199'
                WHERE ordernumber = 'P2503090000286' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460200'
                WHERE ordernumber = 'P2503090000293' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227932'
                WHERE ordernumber = 'P2503090000294' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460204'
                WHERE ordernumber = 'P2503090000296' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221036'
                WHERE ordernumber = 'P2503090000303' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P2503090000304' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460205'
                WHERE ordernumber = 'P2503090000305' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460206'
                WHERE ordernumber = 'P2503090000311' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460207'
                WHERE ordernumber = 'P2503090000315' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314916'
                WHERE ordernumber = 'P2503090000319' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460208'
                WHERE ordernumber = 'P2503090000322' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460209'
                WHERE ordernumber = 'P2503090000326' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460210'
                WHERE ordernumber = 'P2503090000330' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381653'
                WHERE ordernumber = 'P2503090000331' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460211'
                WHERE ordernumber = 'P2503090000334' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387776'
                WHERE ordernumber = 'P2503090000338' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460212'
                WHERE ordernumber = 'P2503090000340' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460215'
                WHERE ordernumber = 'P2503090000342' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433949'
                WHERE ordernumber = 'P2503090000343' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '448462'
                WHERE ordernumber = 'P2503090000346' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410095'
                WHERE ordernumber = 'P2503090000349' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460216'
                WHERE ordernumber = 'P2503090000350' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460212'
                WHERE ordernumber = 'P2503090000351' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460213'
                WHERE ordernumber = 'P2503090000352' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111419'
                WHERE ordernumber = 'P2503090000354' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404497'
                WHERE ordernumber = 'P2503090000355' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357458'
                WHERE ordernumber = 'P2503090000359' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455341'
                WHERE ordernumber = 'P2503090000360' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460217'
                WHERE ordernumber = 'P2503090000364' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460221'
                WHERE ordernumber = 'P2503090000373' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460219'
                WHERE ordernumber = 'P2503090000377' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432649'
                WHERE ordernumber = 'P2503090000382' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300665'
                WHERE ordernumber = 'P2503090000391' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460224'
                WHERE ordernumber = 'P2503090000393' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460225'
                WHERE ordernumber = 'P2503090000399' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258044'
                WHERE ordernumber = 'P2503090000405' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460226'
                WHERE ordernumber = 'P2503090000408' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435694'
                WHERE ordernumber = 'P2503090000409' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460227'
                WHERE ordernumber = 'P2503090000410' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220614'
                WHERE ordernumber = 'P2503090000418' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101769'
                WHERE ordernumber = 'P2503090000420' 
            
2025-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '460229'
                WHERE ordernumber = 'P2503090000421' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460228'
                WHERE ordernumber = 'P2503090000422' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383364'
                WHERE ordernumber = 'P2503090000426' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401606'
                WHERE ordernumber = 'P2503090000428' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460230'
                WHERE ordernumber = 'P2503090000431' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '91830'
                WHERE ordernumber = 'P2503090000434' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401606'
                WHERE ordernumber = 'P2503090000436' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460232'
                WHERE ordernumber = 'P2503090000438' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460233'
                WHERE ordernumber = 'P2503090000441' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349921'
                WHERE ordernumber = 'P2503090000443' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306320'
                WHERE ordernumber = 'P2503090000445' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460231'
                WHERE ordernumber = 'P2503090000449' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455030'
                WHERE ordernumber = 'P2503090000451' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '57124'
                WHERE ordernumber = 'P2503090000457' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350631'
                WHERE ordernumber = 'P2503090000459' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460235'
                WHERE ordernumber = 'P2503090000462' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240539'
                WHERE ordernumber = 'P2503090000464' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460236'
                WHERE ordernumber = 'P2503090000466' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95479'
                WHERE ordernumber = 'P2503090000467' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460237'
                WHERE ordernumber = 'P2503090000469' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460239'
                WHERE ordernumber = 'P2503090000471' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460240'
                WHERE ordernumber = 'P2503090000475' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378409'
                WHERE ordernumber = 'P2503090000477' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460234'
                WHERE ordernumber = 'P2503090000478' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460241'
                WHERE ordernumber = 'P2503090000484' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460237'
                WHERE ordernumber = 'P2503090000486' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '447312'
                WHERE ordernumber = 'P2503090000487' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460242'
                WHERE ordernumber = 'P2503090000490' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460243'
                WHERE ordernumber = 'P2503090000494' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460238'
                WHERE ordernumber = 'P2503090000497' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460244'
                WHERE ordernumber = 'P2503090000503' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379498'
                WHERE ordernumber = 'P2503090000506' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459592'
                WHERE ordernumber = 'P2503090000509' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460245'
                WHERE ordernumber = 'P2503090000510' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460247'
                WHERE ordernumber = 'P2503090000515' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460248'
                WHERE ordernumber = 'P2503090000519' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460249'
                WHERE ordernumber = 'P2503090000523' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460250'
                WHERE ordernumber = 'P2503090000524' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '323947'
                WHERE ordernumber = 'P2503090000528' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460252'
                WHERE ordernumber = 'P2503090000530' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460251'
                WHERE ordernumber = 'P2503090000531' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '213859'
                WHERE ordernumber = 'P2503090000536' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293848'
                WHERE ordernumber = 'P2503090000547' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229983'
                WHERE ordernumber = 'P2503090000551' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293848'
                WHERE ordernumber = 'P2503090000552' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457816'
                WHERE ordernumber = 'P2503090000559' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398524'
                WHERE ordernumber = 'P2503090000566' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460254'
                WHERE ordernumber = 'P2503090000567' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288047'
                WHERE ordernumber = 'P2503090000572' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460256'
                WHERE ordernumber = 'P2503090000573' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460255'
                WHERE ordernumber = 'P2503090000574' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398524'
                WHERE ordernumber = 'P2503090000577' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460257'
                WHERE ordernumber = 'P2503090000581' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266888'
                WHERE ordernumber = 'P2503090000582' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460258'
                WHERE ordernumber = 'P2503090000585' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359372'
                WHERE ordernumber = 'P2503090000587' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '89711'
                WHERE ordernumber = 'P2503090000590' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '125233'
                WHERE ordernumber = 'P2503090000593' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P2503090000594' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460260'
                WHERE ordernumber = 'P2503090000596' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460261'
                WHERE ordernumber = 'P2503090000597' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '429292'
                WHERE ordernumber = 'P2503090000598' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384659'
                WHERE ordernumber = 'P2503090000602' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460265'
                WHERE ordernumber = 'P2503090000603' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460263'
                WHERE ordernumber = 'P2503090000604' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457195'
                WHERE ordernumber = 'P2503090000605' 
            
2025-03-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '460266'
                WHERE ordernumber = 'P2503090000606' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460267'
                WHERE ordernumber = 'P2503090000607' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460269'
                WHERE ordernumber = 'P2503090000611' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460268'
                WHERE ordernumber = 'P2503090000614' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460270'
                WHERE ordernumber = 'P2503090000619' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460271'
                WHERE ordernumber = 'P2503090000620' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '312240'
                WHERE ordernumber = 'P2503090000628' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455493'
                WHERE ordernumber = 'P2503090000637' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '106604'
                WHERE ordernumber = 'P2503090000641' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460275'
                WHERE ordernumber = 'P2503090000642' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460274'
                WHERE ordernumber = 'P2503090000643' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '282775'
                WHERE ordernumber = 'P2503090000645' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460276'
                WHERE ordernumber = 'P2503090000648' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460277'
                WHERE ordernumber = 'P2503090000652' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459759'
                WHERE ordernumber = 'P2503090000654' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456302'
                WHERE ordernumber = 'P2503090000656' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '426553'
                WHERE ordernumber = 'P2503090000657' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460279'
                WHERE ordernumber = 'P2503090000658' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '433358'
                WHERE ordernumber = 'P2503090000666' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460117'
                WHERE ordernumber = 'P2503090000667' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460282'
                WHERE ordernumber = 'P2503090000676' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460283'
                WHERE ordernumber = 'P2503090000678' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460284'
                WHERE ordernumber = 'P2503090000679' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460283'
                WHERE ordernumber = 'P2503090000681' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460285'
                WHERE ordernumber = 'P2503090000683' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460287'
                WHERE ordernumber = 'P2503090000685' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '457823'
                WHERE ordernumber = 'P2503090000686' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '189783'
                WHERE ordernumber = 'P2503090000687' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '333176'
                WHERE ordernumber = 'P2503090000689' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460289'
                WHERE ordernumber = 'P2503090000691' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '196157'
                WHERE ordernumber = 'P2503090000688' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '93809'
                WHERE ordernumber = 'P2503090000695' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '93809'
                WHERE ordernumber = 'P2503090000695' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460291'
                WHERE ordernumber = 'P2503090000703' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '437679'
                WHERE ordernumber = 'P2503090000707' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460292'
                WHERE ordernumber = 'P2503090000709' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '146920'
                WHERE ordernumber = 'P2503090000714' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '140194'
                WHERE ordernumber = 'P2503090000716' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '283552'
                WHERE ordernumber = 'P2503090000717' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460293'
                WHERE ordernumber = 'P2503090000722' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460296'
                WHERE ordernumber = 'P2503090000724' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460298'
                WHERE ordernumber = 'P2503090000733' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '381664'
                WHERE ordernumber = 'P2503090000741' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460300'
                WHERE ordernumber = 'P2503090000744' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '381576'
                WHERE ordernumber = 'P2503090000748' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460301'
                WHERE ordernumber = 'P2503090000751' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '413221'
                WHERE ordernumber = 'P2503090000754' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '413221'
                WHERE ordernumber = 'P2503090000759' 
            
2025-03-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '460303'
                WHERE ordernumber = 'P2503090000760'