2025-01-08 01:00:02 -- 將會員中心id寫入data-lake
2025-01-08 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 '2025-01-07%';
        
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405798'
                WHERE ordernumber = 'P2501070000009' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118908'
                WHERE ordernumber = 'P2501070000010' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445588'
                WHERE ordernumber = 'P2501070000011' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445564'
                WHERE ordernumber = 'P2501070000012' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445591'
                WHERE ordernumber = 'P2501070000013' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2501070000014' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420554'
                WHERE ordernumber = 'P2501070000015' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238252'
                WHERE ordernumber = 'P2501070000016' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445592'
                WHERE ordernumber = 'P2501070000018' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '153877'
                WHERE ordernumber = 'P2501070000019' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445593'
                WHERE ordernumber = 'P2501070000021' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406754'
                WHERE ordernumber = 'P2501070000022' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P2501070000023' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '108588'
                WHERE ordernumber = 'P2501070000024' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445580'
                WHERE ordernumber = 'P2501070000026' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401189'
                WHERE ordernumber = 'P2501070000029' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318939'
                WHERE ordernumber = 'P2501070000030' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291320'
                WHERE ordernumber = 'P2501070000032' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445564'
                WHERE ordernumber = 'P2501070000033' 
            
2025-01-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383887'
                WHERE ordernumber = 'P2501070000036' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99566'
                WHERE ordernumber = 'P2501070000037' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433471'
                WHERE ordernumber = 'P2501070000038' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432977'
                WHERE ordernumber = 'P2501070000043' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442512'
                WHERE ordernumber = 'P2501070000050' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429530'
                WHERE ordernumber = 'P2501070000052' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445604'
                WHERE ordernumber = 'P2501070000054' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445601'
                WHERE ordernumber = 'P2501070000055' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445607'
                WHERE ordernumber = 'P2501070000056' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90048'
                WHERE ordernumber = 'P2501070000057' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122054'
                WHERE ordernumber = 'P2501070000060' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445610'
                WHERE ordernumber = 'P2501070000062' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445606'
                WHERE ordernumber = 'P2501070000063' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445613'
                WHERE ordernumber = 'P2501070000065' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366163'
                WHERE ordernumber = 'P2501070000066' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445616'
                WHERE ordernumber = 'P2501070000071' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366066'
                WHERE ordernumber = 'P2501070000074' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220329'
                WHERE ordernumber = 'P2501070000076' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209274'
                WHERE ordernumber = 'P2501070000077' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99933'
                WHERE ordernumber = 'P2501070000078' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395691'
                WHERE ordernumber = 'P2501070000083' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429976'
                WHERE ordernumber = 'P2501070000089' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305444'
                WHERE ordernumber = 'P2501070000091' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445625'
                WHERE ordernumber = 'P2501070000093' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167176'
                WHERE ordernumber = 'P2501070000094' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445626'
                WHERE ordernumber = 'P2501070000096' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382723'
                WHERE ordernumber = 'P2501070000098' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322147'
                WHERE ordernumber = 'P2501070000101' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368085'
                WHERE ordernumber = 'P2501070000102' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445469'
                WHERE ordernumber = 'P2501070000105' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299619'
                WHERE ordernumber = 'P2501070000106' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384758'
                WHERE ordernumber = 'P2501070000107' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430591'
                WHERE ordernumber = 'P2501070000110' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441793'
                WHERE ordernumber = 'P2501070000111' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297500'
                WHERE ordernumber = 'P2501070000113' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107946'
                WHERE ordernumber = 'P2501070000122' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339488'
                WHERE ordernumber = 'P2501070000123' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143314'
                WHERE ordernumber = 'P2501070000125' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244678'
                WHERE ordernumber = 'P2501070000127' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339282'
                WHERE ordernumber = 'P2501070000130' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445632'
                WHERE ordernumber = 'P2501070000133' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267420'
                WHERE ordernumber = 'P2501070000135' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418787'
                WHERE ordernumber = 'P2501070000137' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445633'
                WHERE ordernumber = 'P2501070000140' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333795'
                WHERE ordernumber = 'P2501070000142' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125988'
                WHERE ordernumber = 'P2501070000143' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445636'
                WHERE ordernumber = 'P2501070000148' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352080'
                WHERE ordernumber = 'P2501070000154' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445640'
                WHERE ordernumber = 'P2501070000159' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445645'
                WHERE ordernumber = 'P2501070000161' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438221'
                WHERE ordernumber = 'P2501070000162' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445649'
                WHERE ordernumber = 'P2501070000165' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439234'
                WHERE ordernumber = 'P2501070000167' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347465'
                WHERE ordernumber = 'P2501070000176' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445653'
                WHERE ordernumber = 'P2501070000177' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143159'
                WHERE ordernumber = 'P2501070000183' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124677'
                WHERE ordernumber = 'P2501070000185' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270246'
                WHERE ordernumber = 'P2501070000186' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '444664'
                WHERE ordernumber = 'P2501070000187' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '174924'
                WHERE ordernumber = 'P2501070000190' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412543'
                WHERE ordernumber = 'P2501070000191' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445658'
                WHERE ordernumber = 'P2501070000193' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445568'
                WHERE ordernumber = 'P2501070000194' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437670'
                WHERE ordernumber = 'P2501070000199' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272831'
                WHERE ordernumber = 'P2501070000202' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110061'
                WHERE ordernumber = 'P2501070000203' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '26685'
                WHERE ordernumber = 'P2501070000205' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445665'
                WHERE ordernumber = 'P2501070000208' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403138'
                WHERE ordernumber = 'P2501070000209' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '192012'
                WHERE ordernumber = 'P2501070000212' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445668'
                WHERE ordernumber = 'P2501070000213' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '55471'
                WHERE ordernumber = 'P2501070000214' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211642'
                WHERE ordernumber = 'P2501070000217' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252290'
                WHERE ordernumber = 'P2501070000221' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344755'
                WHERE ordernumber = 'P2501070000223' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445674'
                WHERE ordernumber = 'P2501070000227' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116235'
                WHERE ordernumber = 'P2501070000228' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333579'
                WHERE ordernumber = 'P2501070000229' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382566'
                WHERE ordernumber = 'P2501070000230' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445678'
                WHERE ordernumber = 'P2501070000232' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256850'
                WHERE ordernumber = 'P2501070000233' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147635'
                WHERE ordernumber = 'P2501070000238' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445680'
                WHERE ordernumber = 'P2501070000240' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416105'
                WHERE ordernumber = 'P2501070000242' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445682'
                WHERE ordernumber = 'P2501070000247' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147635'
                WHERE ordernumber = 'P2501070000248' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '150598'
                WHERE ordernumber = 'P2501070000250' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413227'
                WHERE ordernumber = 'P2501070000252' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445683'
                WHERE ordernumber = 'P2501070000253' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445685'
                WHERE ordernumber = 'P2501070000255' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445686'
                WHERE ordernumber = 'P2501070000257' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95646'
                WHERE ordernumber = 'P2501070000259' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294872'
                WHERE ordernumber = 'P2501070000265' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297429'
                WHERE ordernumber = 'P2501070000268' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445081'
                WHERE ordernumber = 'P2501070000271' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445081'
                WHERE ordernumber = 'P2501070000272' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369762'
                WHERE ordernumber = 'P2501070000274' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445081'
                WHERE ordernumber = 'P2501070000277' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398304'
                WHERE ordernumber = 'P2501070000280' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '444677'
                WHERE ordernumber = 'P2501070000282' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445081'
                WHERE ordernumber = 'P2501070000285' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263180'
                WHERE ordernumber = 'P2501070000292' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223258'
                WHERE ordernumber = 'P2501070000297' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445697'
                WHERE ordernumber = 'P2501070000299' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445703'
                WHERE ordernumber = 'P2501070000306' 
            
2025-01-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445697'
                WHERE ordernumber = 'P2501070000309' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370098'
                WHERE ordernumber = 'P2501070000311' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124614'
                WHERE ordernumber = 'P2501070000313' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234876'
                WHERE ordernumber = 'P2501070000314' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124614'
                WHERE ordernumber = 'P2501070000315' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445708'
                WHERE ordernumber = 'P2501070000316' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445710'
                WHERE ordernumber = 'P2501070000318' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445708'
                WHERE ordernumber = 'P2501070000319' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217639'
                WHERE ordernumber = 'P2501070000323' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407174'
                WHERE ordernumber = 'P2501070000324' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325287'
                WHERE ordernumber = 'P2501070000325' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252883'
                WHERE ordernumber = 'P2501070000326' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445715'
                WHERE ordernumber = 'P2501070000328' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445716'
                WHERE ordernumber = 'P2501070000330' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119972'
                WHERE ordernumber = 'P2501070000332' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '172291'
                WHERE ordernumber = 'P2501070000333' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445717'
                WHERE ordernumber = 'P2501070000334' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P2501070000335' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443480'
                WHERE ordernumber = 'P2501070000336' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440207'
                WHERE ordernumber = 'P2501070000337' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445718'
                WHERE ordernumber = 'P2501070000344' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86057'
                WHERE ordernumber = 'P2501070000345' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445722'
                WHERE ordernumber = 'P2501070000348' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285070'
                WHERE ordernumber = 'P2501070000350' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285070'
                WHERE ordernumber = 'P2501070000351' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445726'
                WHERE ordernumber = 'P2501070000353' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445725'
                WHERE ordernumber = 'P2501070000354' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436280'
                WHERE ordernumber = 'P2501070000355' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445729'
                WHERE ordernumber = 'P2501070000357' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275302'
                WHERE ordernumber = 'P2501070000358' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418950'
                WHERE ordernumber = 'P2501070000359' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445724'
                WHERE ordernumber = 'P2501070000360' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445730'
                WHERE ordernumber = 'P2501070000361' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445731'
                WHERE ordernumber = 'P2501070000362' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129909'
                WHERE ordernumber = 'P2501070000368' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445733'
                WHERE ordernumber = 'P2501070000370' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346006'
                WHERE ordernumber = 'P2501070000371' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445736'
                WHERE ordernumber = 'P2501070000378' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322440'
                WHERE ordernumber = 'P2501070000385' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445740'
                WHERE ordernumber = 'P2501070000388' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98293'
                WHERE ordernumber = 'P2501070000392' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337890'
                WHERE ordernumber = 'P2501070000394' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445742'
                WHERE ordernumber = 'P2501070000398' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251499'
                WHERE ordernumber = 'P2501070000399' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133108'
                WHERE ordernumber = 'P2501070000400' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163620'
                WHERE ordernumber = 'P2501070000401' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337890'
                WHERE ordernumber = 'P2501070000404' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445746'
                WHERE ordernumber = 'P2501070000405' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445747'
                WHERE ordernumber = 'P2501070000406' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445749'
                WHERE ordernumber = 'P2501070000407' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310858'
                WHERE ordernumber = 'P2501070000408' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445752'
                WHERE ordernumber = 'P2501070000412' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397939'
                WHERE ordernumber = 'P2501070000414' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319349'
                WHERE ordernumber = 'P2501070000415' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445753'
                WHERE ordernumber = 'P2501070000418' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445754'
                WHERE ordernumber = 'P2501070000422' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399994'
                WHERE ordernumber = 'P2501070000423' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445756'
                WHERE ordernumber = 'P2501070000430' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374536'
                WHERE ordernumber = 'P2501070000444' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445763'
                WHERE ordernumber = 'P2501070000452' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378744'
                WHERE ordernumber = 'P2501070000455' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445766'
                WHERE ordernumber = 'P2501070000458' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445767'
                WHERE ordernumber = 'P2501070000460' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445769'
                WHERE ordernumber = 'P2501070000463' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436474'
                WHERE ordernumber = 'P2501070000466' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436474'
                WHERE ordernumber = 'P2501070000467' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436474'
                WHERE ordernumber = 'P2501070000468' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298892'
                WHERE ordernumber = 'P2501070000470' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340913'
                WHERE ordernumber = 'P2501070000476' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445774'
                WHERE ordernumber = 'P2501070000479' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252377'
                WHERE ordernumber = 'P2501070000481' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445779'
                WHERE ordernumber = 'P2501070000484' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99693'
                WHERE ordernumber = 'P2501070000485' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363596'
                WHERE ordernumber = 'P2501070000494' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445785'
                WHERE ordernumber = 'P2501070000495' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389812'
                WHERE ordernumber = 'P2501070000496' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445788'
                WHERE ordernumber = 'P2501070000501' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377588'
                WHERE ordernumber = 'P2501070000503' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219860'
                WHERE ordernumber = 'P2501070000507' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445795'
                WHERE ordernumber = 'P2501070000510' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353437'
                WHERE ordernumber = 'P2501070000511' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445798'
                WHERE ordernumber = 'P2501070000513' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445801'
                WHERE ordernumber = 'P2501070000514' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426812'
                WHERE ordernumber = 'P2501070000515' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445802'
                WHERE ordernumber = 'P2501070000516' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169204'
                WHERE ordernumber = 'P2501070000517' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221426'
                WHERE ordernumber = 'P2501070000518' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260427'
                WHERE ordernumber = 'P2501070000528' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260427'
                WHERE ordernumber = 'P2501070000530' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208726'
                WHERE ordernumber = 'P2501070000532' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445807'
                WHERE ordernumber = 'P2501070000534' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289704'
                WHERE ordernumber = 'P2501070000535' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445809'
                WHERE ordernumber = 'P2501070000537' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445808'
                WHERE ordernumber = 'P2501070000538' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '148275'
                WHERE ordernumber = 'P2501070000539' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '3772'
                WHERE ordernumber = 'P2501070000540' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372416'
                WHERE ordernumber = 'P2501070000541' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445812'
                WHERE ordernumber = 'P2501070000546' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249709'
                WHERE ordernumber = 'P2501070000547' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445112'
                WHERE ordernumber = 'P2501070000549' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401915'
                WHERE ordernumber = 'P2501070000553' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445815'
                WHERE ordernumber = 'P2501070000554' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445816'
                WHERE ordernumber = 'P2501070000555' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426798'
                WHERE ordernumber = 'P2501070000556' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406752'
                WHERE ordernumber = 'P2501070000561' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374299'
                WHERE ordernumber = 'P2501070000563' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '444602'
                WHERE ordernumber = 'P2501070000567' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210362'
                WHERE ordernumber = 'P2501070000572' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286464'
                WHERE ordernumber = 'P2501070000573' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '85583'
                WHERE ordernumber = 'P2501070000577' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107391'
                WHERE ordernumber = 'P2501070000579' 
            
2025-01-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445824'
                WHERE ordernumber = 'P2501070000581' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445823'
                WHERE ordernumber = 'P2501070000582' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445825'
                WHERE ordernumber = 'P2501070000586' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445826'
                WHERE ordernumber = 'P2501070000591' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '168576'
                WHERE ordernumber = 'P2501070000593' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '272211'
                WHERE ordernumber = 'P2501070000598' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '154272'
                WHERE ordernumber = 'P2501070000599' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '432216'
                WHERE ordernumber = 'P2501070000600' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388793'
                WHERE ordernumber = 'P2501070000601' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445845'
                WHERE ordernumber = 'P2501070000614' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445845'
                WHERE ordernumber = 'P2501070000615' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226038'
                WHERE ordernumber = 'P2501070000616' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439816'
                WHERE ordernumber = 'P2501070000619' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313090'
                WHERE ordernumber = 'P2501070000622' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415875'
                WHERE ordernumber = 'P2501070000628' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445851'
                WHERE ordernumber = 'P2501070000630' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285435'
                WHERE ordernumber = 'P2501070000633' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445852'
                WHERE ordernumber = 'P2501070000634' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '76999'
                WHERE ordernumber = 'P2501070000636' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445853'
                WHERE ordernumber = 'P2501070000641' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381815'
                WHERE ordernumber = 'P2501070000642' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P2501070000644' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P2501070000646' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '250471'
                WHERE ordernumber = 'P2501070000647' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '444190'
                WHERE ordernumber = 'P2501070000650' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445424'
                WHERE ordernumber = 'P2501070000653' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '110736'
                WHERE ordernumber = 'P2501070000654' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379086'
                WHERE ordernumber = 'P2501070000655' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380886'
                WHERE ordernumber = 'P2501070000656' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445857'
                WHERE ordernumber = 'P2501070000657' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445424'
                WHERE ordernumber = 'P2501070000658' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212946'
                WHERE ordernumber = 'P2501070000660' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291184'
                WHERE ordernumber = 'P2501070000662' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214008'
                WHERE ordernumber = 'P2501070000663' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '331942'
                WHERE ordernumber = 'P2501070000665' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382646'
                WHERE ordernumber = 'P2501070000668' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340701'
                WHERE ordernumber = 'P2501070000669' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343598'
                WHERE ordernumber = 'P2501070000670' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '427639'
                WHERE ordernumber = 'P2501070000671' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445862'
                WHERE ordernumber = 'P2501070000674' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430269'
                WHERE ordernumber = 'P2501070000676' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445860'
                WHERE ordernumber = 'P2501070000677' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '322944'
                WHERE ordernumber = 'P2501070000679' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '441895'
                WHERE ordernumber = 'P2501070000688' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423349'
                WHERE ordernumber = 'P2501070000694' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371069'
                WHERE ordernumber = 'P2501070000702' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399441'
                WHERE ordernumber = 'P2501070000703' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445877'
                WHERE ordernumber = 'P2501070000706' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '441724'
                WHERE ordernumber = 'P2501070000711' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445878'
                WHERE ordernumber = 'P2501070000715' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81433'
                WHERE ordernumber = 'P2501070000718' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '373101'
                WHERE ordernumber = 'P2501070000719' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301997'
                WHERE ordernumber = 'P2501070000721' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P2501070000728' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94980'
                WHERE ordernumber = 'P2501070000732' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221844'
                WHERE ordernumber = 'P2501070000733' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '133280'
                WHERE ordernumber = 'P2501070000734' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '438595'
                WHERE ordernumber = 'P2501070000737' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '438595'
                WHERE ordernumber = 'P2501070000739' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '149802'
                WHERE ordernumber = 'P2501070000740' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445267'
                WHERE ordernumber = 'P2501070000746' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388793'
                WHERE ordernumber = 'P2501070000750' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '74730'
                WHERE ordernumber = 'P2501070000751' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '445893'
                WHERE ordernumber = 'P2501070000762' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '115998'
                WHERE ordernumber = 'P2501070000767' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '133492'
                WHERE ordernumber = 'P2501070000769' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '80490'
                WHERE ordernumber = 'P2501070000771' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '211823'
                WHERE ordernumber = 'P2501070000775' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '443759'
                WHERE ordernumber = 'P2501070000776' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430265'
                WHERE ordernumber = 'P2501070000782' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81119'
                WHERE ordernumber = 'P2501070000785' 
            
2025-01-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388793'
                WHERE ordernumber = 'P2501070000795'