2025-02-20 01:00:02 -- 將會員中心id寫入data-lake
2025-02-20 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-02-19%';
        
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P2502190000013' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456917'
                WHERE ordernumber = 'P2502190000015' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329718'
                WHERE ordernumber = 'P2502190000016' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432638'
                WHERE ordernumber = 'P2502190000017' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347323'
                WHERE ordernumber = 'P2502190000018' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456916'
                WHERE ordernumber = 'P2502190000020' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456916'
                WHERE ordernumber = 'P2502190000021' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456919'
                WHERE ordernumber = 'P2502190000024' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P2502190000027' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456586'
                WHERE ordernumber = 'P2502190000028' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456586'
                WHERE ordernumber = 'P2502190000030' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456593'
                WHERE ordernumber = 'P2502190000031' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456593'
                WHERE ordernumber = 'P2502190000032' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410577'
                WHERE ordernumber = 'P2502190000033' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456918'
                WHERE ordernumber = 'P2502190000035' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251911'
                WHERE ordernumber = 'P2502190000037' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239602'
                WHERE ordernumber = 'P2502190000041' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456924'
                WHERE ordernumber = 'P2502190000044' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298522'
                WHERE ordernumber = 'P2502190000045' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456926'
                WHERE ordernumber = 'P2502190000047' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385562'
                WHERE ordernumber = 'P2502190000049' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105829'
                WHERE ordernumber = 'P2502190000050' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289152'
                WHERE ordernumber = 'P2502190000053' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456928'
                WHERE ordernumber = 'P2502190000055' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456929'
                WHERE ordernumber = 'P2502190000056' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435904'
                WHERE ordernumber = 'P2502190000060' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339631'
                WHERE ordernumber = 'P2502190000068' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456935'
                WHERE ordernumber = 'P2502190000074' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143087'
                WHERE ordernumber = 'P2502190000076' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456936'
                WHERE ordernumber = 'P2502190000077' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390370'
                WHERE ordernumber = 'P2502190000079' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99926'
                WHERE ordernumber = 'P2502190000080' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334889'
                WHERE ordernumber = 'P2502190000086' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303382'
                WHERE ordernumber = 'P2502190000090' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433040'
                WHERE ordernumber = 'P2502190000096' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456942'
                WHERE ordernumber = 'P2502190000098' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142919'
                WHERE ordernumber = 'P2502190000099' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224611'
                WHERE ordernumber = 'P2502190000101' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424029'
                WHERE ordernumber = 'P2502190000103' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301585'
                WHERE ordernumber = 'P2502190000104' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456943'
                WHERE ordernumber = 'P2502190000111' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372206'
                WHERE ordernumber = 'P2502190000119' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456945'
                WHERE ordernumber = 'P2502190000120' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '447254'
                WHERE ordernumber = 'P2502190000122' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455918'
                WHERE ordernumber = 'P2502190000127' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455918'
                WHERE ordernumber = 'P2502190000128' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456948'
                WHERE ordernumber = 'P2502190000129' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456949'
                WHERE ordernumber = 'P2502190000133' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124325'
                WHERE ordernumber = 'P2502190000136' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339859'
                WHERE ordernumber = 'P2502190000137' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456950'
                WHERE ordernumber = 'P2502190000140' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '46166'
                WHERE ordernumber = 'P2502190000142' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456951'
                WHERE ordernumber = 'P2502190000144' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456952'
                WHERE ordernumber = 'P2502190000146' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456954'
                WHERE ordernumber = 'P2502190000150' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359303'
                WHERE ordernumber = 'P2502190000151' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456360'
                WHERE ordernumber = 'P2502190000155' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456955'
                WHERE ordernumber = 'P2502190000156' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456956'
                WHERE ordernumber = 'P2502190000157' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456957'
                WHERE ordernumber = 'P2502190000161' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456958'
                WHERE ordernumber = 'P2502190000162' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380201'
                WHERE ordernumber = 'P2502190000163' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456958'
                WHERE ordernumber = 'P2502190000165' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381087'
                WHERE ordernumber = 'P2502190000166' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456959'
                WHERE ordernumber = 'P2502190000169' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454573'
                WHERE ordernumber = 'P2502190000170' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456960'
                WHERE ordernumber = 'P2502190000171' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242459'
                WHERE ordernumber = 'P2502190000172' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456963'
                WHERE ordernumber = 'P2502190000173' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456964'
                WHERE ordernumber = 'P2502190000176' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456962'
                WHERE ordernumber = 'P2502190000177' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456959'
                WHERE ordernumber = 'P2502190000180' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397457'
                WHERE ordernumber = 'P2502190000181' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456965'
                WHERE ordernumber = 'P2502190000183' 
            
2025-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456966'
                WHERE ordernumber = 'P2502190000184' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456960'
                WHERE ordernumber = 'P2502190000185' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456967'
                WHERE ordernumber = 'P2502190000187' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456968'
                WHERE ordernumber = 'P2502190000188' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456967'
                WHERE ordernumber = 'P2502190000192' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456970'
                WHERE ordernumber = 'P2502190000193' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456969'
                WHERE ordernumber = 'P2502190000194' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '451186'
                WHERE ordernumber = 'P2502190000196' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309980'
                WHERE ordernumber = 'P2502190000198' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456968'
                WHERE ordernumber = 'P2502190000200' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439742'
                WHERE ordernumber = 'P2502190000203' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453713'
                WHERE ordernumber = 'P2502190000206' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456972'
                WHERE ordernumber = 'P2502190000208' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456973'
                WHERE ordernumber = 'P2502190000209' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456975'
                WHERE ordernumber = 'P2502190000214' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '134258'
                WHERE ordernumber = 'P2502190000215' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456974'
                WHERE ordernumber = 'P2502190000217' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101604'
                WHERE ordernumber = 'P2502190000226' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127912'
                WHERE ordernumber = 'P2502190000227' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456978'
                WHERE ordernumber = 'P2502190000233' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456979'
                WHERE ordernumber = 'P2502190000234' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456980'
                WHERE ordernumber = 'P2502190000235' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90867'
                WHERE ordernumber = 'P2502190000237' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '444162'
                WHERE ordernumber = 'P2502190000242' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386060'
                WHERE ordernumber = 'P2502190000243' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208926'
                WHERE ordernumber = 'P2502190000244' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143558'
                WHERE ordernumber = 'P2502190000245' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112005'
                WHERE ordernumber = 'P2502190000247' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455835'
                WHERE ordernumber = 'P2502190000248' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346050'
                WHERE ordernumber = 'P2502190000253' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456983'
                WHERE ordernumber = 'P2502190000255' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456984'
                WHERE ordernumber = 'P2502190000257' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456985'
                WHERE ordernumber = 'P2502190000259' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456983'
                WHERE ordernumber = 'P2502190000260' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456983'
                WHERE ordernumber = 'P2502190000264' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456988'
                WHERE ordernumber = 'P2502190000265' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159934'
                WHERE ordernumber = 'P2502190000268' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420013'
                WHERE ordernumber = 'P2502190000273' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136379'
                WHERE ordernumber = 'P2502190000275' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456991'
                WHERE ordernumber = 'P2502190000280' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456989'
                WHERE ordernumber = 'P2502190000281' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456992'
                WHERE ordernumber = 'P2502190000282' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413020'
                WHERE ordernumber = 'P2502190000283' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110701'
                WHERE ordernumber = 'P2502190000285' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137433'
                WHERE ordernumber = 'P2502190000288' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456993'
                WHERE ordernumber = 'P2502190000289' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285450'
                WHERE ordernumber = 'P2502190000297' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456994'
                WHERE ordernumber = 'P2502190000303' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456996'
                WHERE ordernumber = 'P2502190000305' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120891'
                WHERE ordernumber = 'P2502190000307' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324258'
                WHERE ordernumber = 'P2502190000308' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456997'
                WHERE ordernumber = 'P2502190000310' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285450'
                WHERE ordernumber = 'P2502190000311' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324258'
                WHERE ordernumber = 'P2502190000313' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320933'
                WHERE ordernumber = 'P2502190000315' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279689'
                WHERE ordernumber = 'P2502190000318' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456998'
                WHERE ordernumber = 'P2502190000325' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456999'
                WHERE ordernumber = 'P2502190000330' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387231'
                WHERE ordernumber = 'P2502190000333' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457001'
                WHERE ordernumber = 'P2502190000334' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457003'
                WHERE ordernumber = 'P2502190000337' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457004'
                WHERE ordernumber = 'P2502190000339' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457005'
                WHERE ordernumber = 'P2502190000340' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272810'
                WHERE ordernumber = 'P2502190000341' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453743'
                WHERE ordernumber = 'P2502190000342' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457007'
                WHERE ordernumber = 'P2502190000346' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457009'
                WHERE ordernumber = 'P2502190000347' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297300'
                WHERE ordernumber = 'P2502190000349' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453743'
                WHERE ordernumber = 'P2502190000350' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239205'
                WHERE ordernumber = 'P2502190000352' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457010'
                WHERE ordernumber = 'P2502190000360' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275486'
                WHERE ordernumber = 'P2502190000363' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457011'
                WHERE ordernumber = 'P2502190000368' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411708'
                WHERE ordernumber = 'P2502190000370' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345971'
                WHERE ordernumber = 'P2502190000373' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307740'
                WHERE ordernumber = 'P2502190000374' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327917'
                WHERE ordernumber = 'P2502190000377' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281400'
                WHERE ordernumber = 'P2502190000379' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457013'
                WHERE ordernumber = 'P2502190000380' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457014'
                WHERE ordernumber = 'P2502190000382' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457015'
                WHERE ordernumber = 'P2502190000383' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104445'
                WHERE ordernumber = 'P2502190000385' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420530'
                WHERE ordernumber = 'P2502190000387' 
            
2025-02-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457016'
                WHERE ordernumber = 'P2502190000389' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457017'
                WHERE ordernumber = 'P2502190000390' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457015'
                WHERE ordernumber = 'P2502190000393' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424278'
                WHERE ordernumber = 'P2502190000394' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457018'
                WHERE ordernumber = 'P2502190000396' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338764'
                WHERE ordernumber = 'P2502190000398' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457019'
                WHERE ordernumber = 'P2502190000400' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '452598'
                WHERE ordernumber = 'P2502190000401' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457020'
                WHERE ordernumber = 'P2502190000402' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424068'
                WHERE ordernumber = 'P2502190000404' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457021'
                WHERE ordernumber = 'P2502190000406' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457022'
                WHERE ordernumber = 'P2502190000408' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457023'
                WHERE ordernumber = 'P2502190000410' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '429670'
                WHERE ordernumber = 'P2502190000411' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457024'
                WHERE ordernumber = 'P2502190000413' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457025'
                WHERE ordernumber = 'P2502190000414' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457026'
                WHERE ordernumber = 'P2502190000417' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '230299'
                WHERE ordernumber = 'P2502190000418' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457028'
                WHERE ordernumber = 'P2502190000421' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457029'
                WHERE ordernumber = 'P2502190000423' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419050'
                WHERE ordernumber = 'P2502190000424' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453176'
                WHERE ordernumber = 'P2502190000425' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '181234'
                WHERE ordernumber = 'P2502190000426' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457031'
                WHERE ordernumber = 'P2502190000428' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457030'
                WHERE ordernumber = 'P2502190000429' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457032'
                WHERE ordernumber = 'P2502190000430' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457033'
                WHERE ordernumber = 'P2502190000432' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382975'
                WHERE ordernumber = 'P2502190000433' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457034'
                WHERE ordernumber = 'P2502190000435' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457035'
                WHERE ordernumber = 'P2502190000436' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '76999'
                WHERE ordernumber = 'P2502190000440' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345799'
                WHERE ordernumber = 'P2502190000442' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '258843'
                WHERE ordernumber = 'P2502190000443' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457027'
                WHERE ordernumber = 'P2502190000444' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159647'
                WHERE ordernumber = 'P2502190000445' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '57631'
                WHERE ordernumber = 'P2502190000446' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457037'
                WHERE ordernumber = 'P2502190000448' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457038'
                WHERE ordernumber = 'P2502190000451' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457039'
                WHERE ordernumber = 'P2502190000454' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263337'
                WHERE ordernumber = 'P2502190000455' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457040'
                WHERE ordernumber = 'P2502190000456' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '294025'
                WHERE ordernumber = 'P2502190000459' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249648'
                WHERE ordernumber = 'P2502190000461' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404559'
                WHERE ordernumber = 'P2502190000462' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249648'
                WHERE ordernumber = 'P2502190000464' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457043'
                WHERE ordernumber = 'P2502190000465' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457042'
                WHERE ordernumber = 'P2502190000466' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457044'
                WHERE ordernumber = 'P2502190000471' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457045'
                WHERE ordernumber = 'P2502190000479' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '448223'
                WHERE ordernumber = 'P2502190000486' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457048'
                WHERE ordernumber = 'P2502190000488' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457046'
                WHERE ordernumber = 'P2502190000489' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457049'
                WHERE ordernumber = 'P2502190000493' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457050'
                WHERE ordernumber = 'P2502190000498' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457053'
                WHERE ordernumber = 'P2502190000499' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457052'
                WHERE ordernumber = 'P2502190000501' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456891'
                WHERE ordernumber = 'P2502190000502' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457051'
                WHERE ordernumber = 'P2502190000505' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457055'
                WHERE ordernumber = 'P2502190000506' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457056'
                WHERE ordernumber = 'P2502190000509' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457057'
                WHERE ordernumber = 'P2502190000510' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220446'
                WHERE ordernumber = 'P2502190000514' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457051'
                WHERE ordernumber = 'P2502190000517' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457060'
                WHERE ordernumber = 'P2502190000518' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236409'
                WHERE ordernumber = 'P2502190000519' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457061'
                WHERE ordernumber = 'P2502190000520' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '132933'
                WHERE ordernumber = 'P2502190000521' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99369'
                WHERE ordernumber = 'P2502190000523' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457056'
                WHERE ordernumber = 'P2502190000525' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347415'
                WHERE ordernumber = 'P2502190000526' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457064'
                WHERE ordernumber = 'P2502190000527' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409939'
                WHERE ordernumber = 'P2502190000529' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298292'
                WHERE ordernumber = 'P2502190000528' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402374'
                WHERE ordernumber = 'P2502190000530' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424029'
                WHERE ordernumber = 'P2502190000531' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457065'
                WHERE ordernumber = 'P2502190000533' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457066'
                WHERE ordernumber = 'P2502190000537' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314395'
                WHERE ordernumber = 'P2502190000538' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456872'
                WHERE ordernumber = 'P2502190000540' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218728'
                WHERE ordernumber = 'P2502190000542' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279795'
                WHERE ordernumber = 'P2502190000543' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '75696'
                WHERE ordernumber = 'P2502190000546' 
            
2025-02-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '204611'
                WHERE ordernumber = 'P2502190000548' 
            
2025-02-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '457067'
                WHERE ordernumber = 'P2502190000552' 
            
2025-02-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '206345'
                WHERE ordernumber = 'P2502190000554' 
            
2025-02-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '235297'
                WHERE ordernumber = 'P2502190000556' 
            
2025-02-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '457069'
                WHERE ordernumber = 'P2502190000562'