2025-03-13 01:00:01 -- 將會員中心id寫入data-lake
2025-03-13 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-12%';
        
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102473'
                WHERE ordernumber = 'P2503120000010' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P2503120000011' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460609'
                WHERE ordernumber = 'P2503120000013' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '574'
                WHERE ordernumber = 'P2503120000017' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460610'
                WHERE ordernumber = 'P2503120000018' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386312'
                WHERE ordernumber = 'P2503120000019' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379588'
                WHERE ordernumber = 'P2503120000021' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392858'
                WHERE ordernumber = 'P2503120000024' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460611'
                WHERE ordernumber = 'P2503120000026' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460612'
                WHERE ordernumber = 'P2503120000027' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403768'
                WHERE ordernumber = 'P2503120000028' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308703'
                WHERE ordernumber = 'P2503120000029' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113474'
                WHERE ordernumber = 'P2503120000030' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426593'
                WHERE ordernumber = 'P2503120000031' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301415'
                WHERE ordernumber = 'P2503120000033' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460613'
                WHERE ordernumber = 'P2503120000036' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301938'
                WHERE ordernumber = 'P2503120000038' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460615'
                WHERE ordernumber = 'P2503120000040' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294579'
                WHERE ordernumber = 'P2503120000043' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314983'
                WHERE ordernumber = 'P2503120000046' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371422'
                WHERE ordernumber = 'P2503120000051' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460616'
                WHERE ordernumber = 'P2503120000052' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '158930'
                WHERE ordernumber = 'P2503120000053' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460617'
                WHERE ordernumber = 'P2503120000054' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266827'
                WHERE ordernumber = 'P2503120000055' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P2503120000056' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345751'
                WHERE ordernumber = 'P2503120000057' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458219'
                WHERE ordernumber = 'P2503120000058' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382099'
                WHERE ordernumber = 'P2503120000063' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460616'
                WHERE ordernumber = 'P2503120000066' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460616'
                WHERE ordernumber = 'P2503120000067' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251957'
                WHERE ordernumber = 'P2503120000075' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460621'
                WHERE ordernumber = 'P2503120000077' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223147'
                WHERE ordernumber = 'P2503120000079' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460624'
                WHERE ordernumber = 'P2503120000081' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460623'
                WHERE ordernumber = 'P2503120000083' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111393'
                WHERE ordernumber = 'P2503120000084' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460628'
                WHERE ordernumber = 'P2503120000085' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460626'
                WHERE ordernumber = 'P2503120000086' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460627'
                WHERE ordernumber = 'P2503120000089' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380103'
                WHERE ordernumber = 'P2503120000099' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2503120000103' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2503120000104' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96436'
                WHERE ordernumber = 'P2503120000106' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411131'
                WHERE ordernumber = 'P2503120000109' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460537'
                WHERE ordernumber = 'P2503120000113' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385619'
                WHERE ordernumber = 'P2503120000115' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338146'
                WHERE ordernumber = 'P2503120000116' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310921'
                WHERE ordernumber = 'P2503120000119' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415328'
                WHERE ordernumber = 'P2503120000121' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460633'
                WHERE ordernumber = 'P2503120000122' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274547'
                WHERE ordernumber = 'P2503120000123' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460635'
                WHERE ordernumber = 'P2503120000125' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460634'
                WHERE ordernumber = 'P2503120000126' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387761'
                WHERE ordernumber = 'P2503120000128' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460638'
                WHERE ordernumber = 'P2503120000132' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257348'
                WHERE ordernumber = 'P2503120000134' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460639'
                WHERE ordernumber = 'P2503120000139' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459466'
                WHERE ordernumber = 'P2503120000152' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412772'
                WHERE ordernumber = 'P2503120000153' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259402'
                WHERE ordernumber = 'P2503120000155' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460642'
                WHERE ordernumber = 'P2503120000157' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460640'
                WHERE ordernumber = 'P2503120000158' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460643'
                WHERE ordernumber = 'P2503120000159' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460645'
                WHERE ordernumber = 'P2503120000160' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460646'
                WHERE ordernumber = 'P2503120000164' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460648'
                WHERE ordernumber = 'P2503120000166' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299656'
                WHERE ordernumber = 'P2503120000168' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460640'
                WHERE ordernumber = 'P2503120000170' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460650'
                WHERE ordernumber = 'P2503120000174' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440237'
                WHERE ordernumber = 'P2503120000177' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431742'
                WHERE ordernumber = 'P2503120000181' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81933'
                WHERE ordernumber = 'P2503120000182' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460652'
                WHERE ordernumber = 'P2503120000183' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460651'
                WHERE ordernumber = 'P2503120000184' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387190'
                WHERE ordernumber = 'P2503120000189' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460653'
                WHERE ordernumber = 'P2503120000190' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216932'
                WHERE ordernumber = 'P2503120000191' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457455'
                WHERE ordernumber = 'P2503120000196' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460655'
                WHERE ordernumber = 'P2503120000201' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460656'
                WHERE ordernumber = 'P2503120000203' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460656'
                WHERE ordernumber = 'P2503120000205' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460656'
                WHERE ordernumber = 'P2503120000206' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386476'
                WHERE ordernumber = 'P2503120000209' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460657'
                WHERE ordernumber = 'P2503120000210' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223968'
                WHERE ordernumber = 'P2503120000214' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460659'
                WHERE ordernumber = 'P2503120000217' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257042'
                WHERE ordernumber = 'P2503120000219' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106009'
                WHERE ordernumber = 'P2503120000220' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460658'
                WHERE ordernumber = 'P2503120000222' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458515'
                WHERE ordernumber = 'P2503120000224' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457316'
                WHERE ordernumber = 'P2503120000226' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455543'
                WHERE ordernumber = 'P2503120000227' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375796'
                WHERE ordernumber = 'P2503120000238' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95398'
                WHERE ordernumber = 'P2503120000244' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460663'
                WHERE ordernumber = 'P2503120000246' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460665'
                WHERE ordernumber = 'P2503120000248' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460664'
                WHERE ordernumber = 'P2503120000249' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460662'
                WHERE ordernumber = 'P2503120000251' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460662'
                WHERE ordernumber = 'P2503120000254' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343367'
                WHERE ordernumber = 'P2503120000256' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460667'
                WHERE ordernumber = 'P2503120000259' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305137'
                WHERE ordernumber = 'P2503120000260' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459144'
                WHERE ordernumber = 'P2503120000261' 
            
2025-03-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '460669'
                WHERE ordernumber = 'P2503120000270' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460669'
                WHERE ordernumber = 'P2503120000271' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309074'
                WHERE ordernumber = 'P2503120000274' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279464'
                WHERE ordernumber = 'P2503120000277' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '152024'
                WHERE ordernumber = 'P2503120000284' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403996'
                WHERE ordernumber = 'P2503120000285' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460672'
                WHERE ordernumber = 'P2503120000292' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452682'
                WHERE ordernumber = 'P2503120000298' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251041'
                WHERE ordernumber = 'P2503120000308' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460673'
                WHERE ordernumber = 'P2503120000311' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460675'
                WHERE ordernumber = 'P2503120000313' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460676'
                WHERE ordernumber = 'P2503120000315' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460676'
                WHERE ordernumber = 'P2503120000316' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454715'
                WHERE ordernumber = 'P2503120000319' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355717'
                WHERE ordernumber = 'P2503120000320' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460677'
                WHERE ordernumber = 'P2503120000323' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130789'
                WHERE ordernumber = 'P2503120000330' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460681'
                WHERE ordernumber = 'P2503120000333' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460682'
                WHERE ordernumber = 'P2503120000335' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460307'
                WHERE ordernumber = 'P2503120000338' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287386'
                WHERE ordernumber = 'P2503120000341' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379086'
                WHERE ordernumber = 'P2503120000345' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460683'
                WHERE ordernumber = 'P2503120000347' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346563'
                WHERE ordernumber = 'P2503120000350' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436110'
                WHERE ordernumber = 'P2503120000351' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327917'
                WHERE ordernumber = 'P2503120000352' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460686'
                WHERE ordernumber = 'P2503120000355' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246986'
                WHERE ordernumber = 'P2503120000356' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457156'
                WHERE ordernumber = 'P2503120000359' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406385'
                WHERE ordernumber = 'P2503120000362' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460685'
                WHERE ordernumber = 'P2503120000363' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215829'
                WHERE ordernumber = 'P2503120000364' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84688'
                WHERE ordernumber = 'P2503120000373' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460690'
                WHERE ordernumber = 'P2503120000379' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460692'
                WHERE ordernumber = 'P2503120000383' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320964'
                WHERE ordernumber = 'P2503120000384' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460693'
                WHERE ordernumber = 'P2503120000385' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443285'
                WHERE ordernumber = 'P2503120000386' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460694'
                WHERE ordernumber = 'P2503120000387' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460694'
                WHERE ordernumber = 'P2503120000392' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440243'
                WHERE ordernumber = 'P2503120000394' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121245'
                WHERE ordernumber = 'P2503120000397' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281378'
                WHERE ordernumber = 'P2503120000398' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460700'
                WHERE ordernumber = 'P2503120000399' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460695'
                WHERE ordernumber = 'P2503120000401' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433956'
                WHERE ordernumber = 'P2503120000402' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460695'
                WHERE ordernumber = 'P2503120000407' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460699'
                WHERE ordernumber = 'P2503120000409' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460607'
                WHERE ordernumber = 'P2503120000414' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460702'
                WHERE ordernumber = 'P2503120000422' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460705'
                WHERE ordernumber = 'P2503120000425' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119328'
                WHERE ordernumber = 'P2503120000426' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2503120000431' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460707'
                WHERE ordernumber = 'P2503120000432' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154457'
                WHERE ordernumber = 'P2503120000434' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460709'
                WHERE ordernumber = 'P2503120000440' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460696'
                WHERE ordernumber = 'P2503120000441' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460697'
                WHERE ordernumber = 'P2503120000443' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460696'
                WHERE ordernumber = 'P2503120000444' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460710'
                WHERE ordernumber = 'P2503120000446' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460711'
                WHERE ordernumber = 'P2503120000449' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460687'
                WHERE ordernumber = 'P2503120000450' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2503120000451' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456698'
                WHERE ordernumber = 'P2503120000452' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460712'
                WHERE ordernumber = 'P2503120000453' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380111'
                WHERE ordernumber = 'P2503120000455' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460715'
                WHERE ordernumber = 'P2503120000456' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460716'
                WHERE ordernumber = 'P2503120000457' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460717'
                WHERE ordernumber = 'P2503120000458' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297145'
                WHERE ordernumber = 'P2503120000459' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172'
                WHERE ordernumber = 'P2503120000461' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460718'
                WHERE ordernumber = 'P2503120000462' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113416'
                WHERE ordernumber = 'P2503120000463' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '444060'
                WHERE ordernumber = 'P2503120000465' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '49345'
                WHERE ordernumber = 'P2503120000466' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431883'
                WHERE ordernumber = 'P2503120000468' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460722'
                WHERE ordernumber = 'P2503120000470' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460721'
                WHERE ordernumber = 'P2503120000471' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455492'
                WHERE ordernumber = 'P2503120000473' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110874'
                WHERE ordernumber = 'P2503120000478' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96134'
                WHERE ordernumber = 'P2503120000479' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380916'
                WHERE ordernumber = 'P2503120000481' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459324'
                WHERE ordernumber = 'P2503120000483' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460724'
                WHERE ordernumber = 'P2503120000490' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '35421'
                WHERE ordernumber = 'P2503120000491' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460725'
                WHERE ordernumber = 'P2503120000500' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286323'
                WHERE ordernumber = 'P2503120000504' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337892'
                WHERE ordernumber = 'P2503120000505' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460727'
                WHERE ordernumber = 'P2503120000509' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320448'
                WHERE ordernumber = 'P2503120000513' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460729'
                WHERE ordernumber = 'P2503120000514' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410478'
                WHERE ordernumber = 'P2503120000515' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142287'
                WHERE ordernumber = 'P2503120000518' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460731'
                WHERE ordernumber = 'P2503120000520' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141211'
                WHERE ordernumber = 'P2503120000523' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460292'
                WHERE ordernumber = 'P2503120000530' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209214'
                WHERE ordernumber = 'P2503120000533' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394804'
                WHERE ordernumber = 'P2503120000534' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460732'
                WHERE ordernumber = 'P2503120000535' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460733'
                WHERE ordernumber = 'P2503120000536' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264519'
                WHERE ordernumber = 'P2503120000539' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264519'
                WHERE ordernumber = 'P2503120000544' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '460734'
                WHERE ordernumber = 'P2503120000545' 
            
2025-03-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158957'
                WHERE ordernumber = 'P2503120000548'