2025-01-01 01:00:02 -- 將會員中心id寫入data-lake
2025-01-01 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 '2024-12-31%';
        
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '441952'
                WHERE ordernumber = 'P2412310000011' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99991'
                WHERE ordernumber = 'P2412310000013' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380031'
                WHERE ordernumber = 'P2412310000016' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '441954'
                WHERE ordernumber = 'P2412310000015' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P2412310000017' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '62902'
                WHERE ordernumber = 'P2412310000019' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '441955'
                WHERE ordernumber = 'P2412310000021' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302397'
                WHERE ordernumber = 'P2412310000025' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318625'
                WHERE ordernumber = 'P2412310000026' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '441957'
                WHERE ordernumber = 'P2412310000028' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302397'
                WHERE ordernumber = 'P2412310000029' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '441749'
                WHERE ordernumber = 'P2412310000031' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '441947'
                WHERE ordernumber = 'P2412310000032' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302892'
                WHERE ordernumber = 'P2412310000037' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404382'
                WHERE ordernumber = 'P2412310000038' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404761'
                WHERE ordernumber = 'P2412310000039' 
            
2025-01-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '441958'
                WHERE ordernumber = 'P2412310000042' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434578'
                WHERE ordernumber = 'P2412310000045' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441959'
                WHERE ordernumber = 'P2412310000048' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441961'
                WHERE ordernumber = 'P2412310000050' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214003'
                WHERE ordernumber = 'P2412310000052' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232303'
                WHERE ordernumber = 'P2412310000054' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441967'
                WHERE ordernumber = 'P2412310000055' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408715'
                WHERE ordernumber = 'P2412310000059' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248577'
                WHERE ordernumber = 'P2412310000060' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238090'
                WHERE ordernumber = 'P2412310000064' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269062'
                WHERE ordernumber = 'P2412310000065' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97525'
                WHERE ordernumber = 'P2412310000066' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426390'
                WHERE ordernumber = 'P2412310000067' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354442'
                WHERE ordernumber = 'P2412310000069' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '203673'
                WHERE ordernumber = 'P2412310000070' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441973'
                WHERE ordernumber = 'P2412310000072' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219653'
                WHERE ordernumber = 'P2412310000074' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438084'
                WHERE ordernumber = 'P2412310000075' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219653'
                WHERE ordernumber = 'P2412310000076' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441978'
                WHERE ordernumber = 'P2412310000077' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441977'
                WHERE ordernumber = 'P2412310000079' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441980'
                WHERE ordernumber = 'P2412310000080' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63197'
                WHERE ordernumber = 'P2412310000083' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441965'
                WHERE ordernumber = 'P2412310000088' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441987'
                WHERE ordernumber = 'P2412310000103' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441988'
                WHERE ordernumber = 'P2412310000105' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392414'
                WHERE ordernumber = 'P2412310000108' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334955'
                WHERE ordernumber = 'P2412310000109' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441989'
                WHERE ordernumber = 'P2412310000115' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163702'
                WHERE ordernumber = 'P2412310000116' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401085'
                WHERE ordernumber = 'P2412310000121' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229791'
                WHERE ordernumber = 'P2412310000124' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424749'
                WHERE ordernumber = 'P2412310000125' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396702'
                WHERE ordernumber = 'P2412310000126' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287953'
                WHERE ordernumber = 'P2412310000127' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236189'
                WHERE ordernumber = 'P2412310000129' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441993'
                WHERE ordernumber = 'P2412310000130' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441991'
                WHERE ordernumber = 'P2412310000133' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441993'
                WHERE ordernumber = 'P2412310000135' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441995'
                WHERE ordernumber = 'P2412310000136' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432378'
                WHERE ordernumber = 'P2412310000137' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320706'
                WHERE ordernumber = 'P2412310000139' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400344'
                WHERE ordernumber = 'P2412310000141' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441998'
                WHERE ordernumber = 'P2412310000148' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441999'
                WHERE ordernumber = 'P2412310000149' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440196'
                WHERE ordernumber = 'P2412310000151' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432378'
                WHERE ordernumber = 'P2412310000154' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372264'
                WHERE ordernumber = 'P2412310000159' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442002'
                WHERE ordernumber = 'P2412310000166' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442004'
                WHERE ordernumber = 'P2412310000171' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360432'
                WHERE ordernumber = 'P2412310000173' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434783'
                WHERE ordernumber = 'P2412310000177' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322258'
                WHERE ordernumber = 'P2412310000181' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P2412310000187' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93642'
                WHERE ordernumber = 'P2412310000190' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442010'
                WHERE ordernumber = 'P2412310000195' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346680'
                WHERE ordernumber = 'P2412310000196' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442011'
                WHERE ordernumber = 'P2412310000199' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317714'
                WHERE ordernumber = 'P2412310000201' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442012'
                WHERE ordernumber = 'P2412310000203' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116454'
                WHERE ordernumber = 'P2412310000204' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431192'
                WHERE ordernumber = 'P2412310000208' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442009'
                WHERE ordernumber = 'P2412310000216' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442016'
                WHERE ordernumber = 'P2412310000217' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442018'
                WHERE ordernumber = 'P2412310000218' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67929'
                WHERE ordernumber = 'P2412310000219' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442016'
                WHERE ordernumber = 'P2412310000226' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90212'
                WHERE ordernumber = 'P2412310000227' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442014'
                WHERE ordernumber = 'P2412310000228' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90212'
                WHERE ordernumber = 'P2412310000232' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339912'
                WHERE ordernumber = 'P2412310000234' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395962'
                WHERE ordernumber = 'P2412310000237' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137061'
                WHERE ordernumber = 'P2412310000239' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395962'
                WHERE ordernumber = 'P2412310000241' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341736'
                WHERE ordernumber = 'P2412310000242' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410717'
                WHERE ordernumber = 'P2412310000248' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272184'
                WHERE ordernumber = 'P2412310000249' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440980'
                WHERE ordernumber = 'P2412310000251' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442027'
                WHERE ordernumber = 'P2412310000252' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442028'
                WHERE ordernumber = 'P2412310000257' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397499'
                WHERE ordernumber = 'P2412310000258' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442031'
                WHERE ordernumber = 'P2412310000259' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378164'
                WHERE ordernumber = 'P2412310000260' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380498'
                WHERE ordernumber = 'P2412310000261' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442030'
                WHERE ordernumber = 'P2412310000264' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442035'
                WHERE ordernumber = 'P2412310000269' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217809'
                WHERE ordernumber = 'P2412310000272' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216260'
                WHERE ordernumber = 'P2412310000273' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P2412310000275' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442038'
                WHERE ordernumber = 'P2412310000276' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442034'
                WHERE ordernumber = 'P2412310000277' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282735'
                WHERE ordernumber = 'P2412310000281' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442034'
                WHERE ordernumber = 'P2412310000282' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171872'
                WHERE ordernumber = 'P2412310000283' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442037'
                WHERE ordernumber = 'P2412310000286' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442044'
                WHERE ordernumber = 'P2412310000288' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247184'
                WHERE ordernumber = 'P2412310000292' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323004'
                WHERE ordernumber = 'P2412310000306' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403893'
                WHERE ordernumber = 'P2412310000307' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116037'
                WHERE ordernumber = 'P2412310000309' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218948'
                WHERE ordernumber = 'P2412310000310' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '17484'
                WHERE ordernumber = 'P2412310000314' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442052'
                WHERE ordernumber = 'P2412310000319' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441335'
                WHERE ordernumber = 'P2412310000327' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271243'
                WHERE ordernumber = 'P2412310000328' 
            
2025-01-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437524'
                WHERE ordernumber = 'P2412310000330' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403893'
                WHERE ordernumber = 'P2412310000331' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395608'
                WHERE ordernumber = 'P2412310000334' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438584'
                WHERE ordernumber = 'P2412310000336' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301528'
                WHERE ordernumber = 'P2412310000338' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312299'
                WHERE ordernumber = 'P2412310000341' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312299'
                WHERE ordernumber = 'P2412310000343' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276877'
                WHERE ordernumber = 'P2412310000348' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437332'
                WHERE ordernumber = 'P2412310000349' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437332'
                WHERE ordernumber = 'P2412310000350' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363651'
                WHERE ordernumber = 'P2412310000351' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428879'
                WHERE ordernumber = 'P2412310000354' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '68106'
                WHERE ordernumber = 'P2412310000356' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442061'
                WHERE ordernumber = 'P2412310000359' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442063'
                WHERE ordernumber = 'P2412310000363' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99718'
                WHERE ordernumber = 'P2412310000367' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428879'
                WHERE ordernumber = 'P2412310000373' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387226'
                WHERE ordernumber = 'P2412310000378' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442065'
                WHERE ordernumber = 'P2412310000380' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442062'
                WHERE ordernumber = 'P2412310000383' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428879'
                WHERE ordernumber = 'P2412310000390' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439408'
                WHERE ordernumber = 'P2412310000391' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434729'
                WHERE ordernumber = 'P2412310000396' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442068'
                WHERE ordernumber = 'P2412310000400' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432502'
                WHERE ordernumber = 'P2412310000411' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306273'
                WHERE ordernumber = 'P2412310000423' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440832'
                WHERE ordernumber = 'P2412310000424' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420127'
                WHERE ordernumber = 'P2412310000426' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415800'
                WHERE ordernumber = 'P2412310000430' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414719'
                WHERE ordernumber = 'P2412310000433' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442073'
                WHERE ordernumber = 'P2412310000434' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89653'
                WHERE ordernumber = 'P2412310000436' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442075'
                WHERE ordernumber = 'P2412310000437' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424887'
                WHERE ordernumber = 'P2412310000439' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424029'
                WHERE ordernumber = 'P2412310000440' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281064'
                WHERE ordernumber = 'P2412310000442' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442079'
                WHERE ordernumber = 'P2412310000443' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442080'
                WHERE ordernumber = 'P2412310000449' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217939'
                WHERE ordernumber = 'P2412310000455' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442087'
                WHERE ordernumber = 'P2412310000470' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436961'
                WHERE ordernumber = 'P2412310000472' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340034'
                WHERE ordernumber = 'P2412310000478' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442091'
                WHERE ordernumber = 'P2412310000481' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101028'
                WHERE ordernumber = 'P2412310000486' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442095'
                WHERE ordernumber = 'P2412310000489' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106157'
                WHERE ordernumber = 'P2412310000490' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P2412310000495' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442096'
                WHERE ordernumber = 'P2412310000497' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442098'
                WHERE ordernumber = 'P2412310000499' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439340'
                WHERE ordernumber = 'P2412310000503' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334889'
                WHERE ordernumber = 'P2412310000508' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334889'
                WHERE ordernumber = 'P2412310000512' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382685'
                WHERE ordernumber = 'P2412310000513' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334889'
                WHERE ordernumber = 'P2412310000516' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442100'
                WHERE ordernumber = 'P2412310000520' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442099'
                WHERE ordernumber = 'P2412310000521' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442101'
                WHERE ordernumber = 'P2412310000523' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280856'
                WHERE ordernumber = 'P2412310000525' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122600'
                WHERE ordernumber = 'P2412310000526' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435459'
                WHERE ordernumber = 'P2412310000527' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122600'
                WHERE ordernumber = 'P2412310000530' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317740'
                WHERE ordernumber = 'P2412310000534' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130600'
                WHERE ordernumber = 'P2412310000537' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442042'
                WHERE ordernumber = 'P2412310000541' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312643'
                WHERE ordernumber = 'P2412310000545' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439995'
                WHERE ordernumber = 'P2412310000546' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430443'
                WHERE ordernumber = 'P2412310000548' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442112'
                WHERE ordernumber = 'P2412310000549' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433157'
                WHERE ordernumber = 'P2412310000564' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352016'
                WHERE ordernumber = 'P2412310000567' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442120'
                WHERE ordernumber = 'P2412310000573' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442121'
                WHERE ordernumber = 'P2412310000575' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303945'
                WHERE ordernumber = 'P2412310000577' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442122'
                WHERE ordernumber = 'P2412310000578' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442122'
                WHERE ordernumber = 'P2412310000579' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P2412310000580' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '441753'
                WHERE ordernumber = 'P2412310000581' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442123'
                WHERE ordernumber = 'P2412310000584' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278133'
                WHERE ordernumber = 'P2412310000585' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442124'
                WHERE ordernumber = 'P2412310000587' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288991'
                WHERE ordernumber = 'P2412310000588' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231268'
                WHERE ordernumber = 'P2412310000593' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442126'
                WHERE ordernumber = 'P2412310000601' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442128'
                WHERE ordernumber = 'P2412310000608' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253422'
                WHERE ordernumber = 'P2412310000616' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316424'
                WHERE ordernumber = 'P2412310000621' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '435914'
                WHERE ordernumber = 'P2412310000623' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440673'
                WHERE ordernumber = 'P2412310000625' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442133'
                WHERE ordernumber = 'P2412310000626' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442135'
                WHERE ordernumber = 'P2412310000627' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425251'
                WHERE ordernumber = 'P2412310000630' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278926'
                WHERE ordernumber = 'P2412310000637' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442141'
                WHERE ordernumber = 'P2412310000642' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90274'
                WHERE ordernumber = 'P2412310000644' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442142'
                WHERE ordernumber = 'P2412310000647' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103830'
                WHERE ordernumber = 'P2412310000650' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442143'
                WHERE ordernumber = 'P2412310000652' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241068'
                WHERE ordernumber = 'P2412310000664' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212237'
                WHERE ordernumber = 'P2412310000667' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2412310000668' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442146'
                WHERE ordernumber = 'P2412310000672' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2412310000673' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260304'
                WHERE ordernumber = 'P2412310000676' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442147'
                WHERE ordernumber = 'P2412310000679' 
            
2025-01-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442149'
                WHERE ordernumber = 'P2412310000681' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '244185'
                WHERE ordernumber = 'P2412310000684' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '441449'
                WHERE ordernumber = 'P2412310000688' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442150'
                WHERE ordernumber = 'P2412310000691' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '441449'
                WHERE ordernumber = 'P2412310000693' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '413447'
                WHERE ordernumber = 'P2412310000698' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442152'
                WHERE ordernumber = 'P2412310000702' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2412310000703' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442153'
                WHERE ordernumber = 'P2412310000705' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '432607'
                WHERE ordernumber = 'P2412310000708' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '441646'
                WHERE ordernumber = 'P2412310000717' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98093'
                WHERE ordernumber = 'P2412310000721' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '434069'
                WHERE ordernumber = 'P2412310000722' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442159'
                WHERE ordernumber = 'P2412310000724' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '108322'
                WHERE ordernumber = 'P2412310000727' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '428599'
                WHERE ordernumber = 'P2412310000731' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299523'
                WHERE ordernumber = 'P2412310000732' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436236'
                WHERE ordernumber = 'P2412310000736' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '441162'
                WHERE ordernumber = 'P2412310000739' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '438225'
                WHERE ordernumber = 'P2412310000741' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384168'
                WHERE ordernumber = 'P2412310000743' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '330839'
                WHERE ordernumber = 'P2412310000745' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101270'
                WHERE ordernumber = 'P2412310000748' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442165'
                WHERE ordernumber = 'P2412310000751' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437882'
                WHERE ordernumber = 'P2412310000759' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377518'
                WHERE ordernumber = 'P2412310000765' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '267008'
                WHERE ordernumber = 'P2412310000768' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442168'
                WHERE ordernumber = 'P2412310000771' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '435807'
                WHERE ordernumber = 'P2412310000775' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442169'
                WHERE ordernumber = 'P2412310000776' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442173'
                WHERE ordernumber = 'P2412310000780' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '136524'
                WHERE ordernumber = 'P2412310000781' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '88636'
                WHERE ordernumber = 'P2412310000782' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442173'
                WHERE ordernumber = 'P2412310000784' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '224853'
                WHERE ordernumber = 'P2412310000788' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440207'
                WHERE ordernumber = 'P2412310000789' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '420658'
                WHERE ordernumber = 'P2412310000790' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '429723'
                WHERE ordernumber = 'P2412310000793' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P2412310000794' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436836'
                WHERE ordernumber = 'P2412310000797' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440819'
                WHERE ordernumber = 'P2412310000798' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442177'
                WHERE ordernumber = 'P2412310000800' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442178'
                WHERE ordernumber = 'P2412310000802' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '136082'
                WHERE ordernumber = 'P2412310000805' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297586'
                WHERE ordernumber = 'P2412310000823' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442185'
                WHERE ordernumber = 'P2412310000825' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296980'
                WHERE ordernumber = 'P2412310000829' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442185'
                WHERE ordernumber = 'P2412310000836' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '435182'
                WHERE ordernumber = 'P2412310000839' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442190'
                WHERE ordernumber = 'P2412310000843' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '432415'
                WHERE ordernumber = 'P2412310000849' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442193'
                WHERE ordernumber = 'P2412310000851' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442194'
                WHERE ordernumber = 'P2412310000856' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353554'
                WHERE ordernumber = 'P2412310000861' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '290215'
                WHERE ordernumber = 'P2412310000862' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442197'
                WHERE ordernumber = 'P2412310000866' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442198'
                WHERE ordernumber = 'P2412310000868' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442199'
                WHERE ordernumber = 'P2412310000871' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273534'
                WHERE ordernumber = 'P2412310000872' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409791'
                WHERE ordernumber = 'P2412310000877' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289391'
                WHERE ordernumber = 'P2412310000882' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442204'
                WHERE ordernumber = 'P2412310000886' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226962'
                WHERE ordernumber = 'P2412310000887' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442206'
                WHERE ordernumber = 'P2412310000889' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285282'
                WHERE ordernumber = 'P2412310000891' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442208'
                WHERE ordernumber = 'P2412310000896' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442210'
                WHERE ordernumber = 'P2412310000897' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442213'
                WHERE ordernumber = 'P2412310000902' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96628'
                WHERE ordernumber = 'P2412310000919' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '441845'
                WHERE ordernumber = 'P2412310000925' 
            
2025-01-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442216'
                WHERE ordernumber = 'P2412310000928'