2025-02-21 01:00:01 -- 將會員中心id寫入data-lake
2025-02-21 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-02-20%';
        
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98509'
                WHERE ordernumber = 'P2502200000010' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457097'
                WHERE ordernumber = 'P2502200000011' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378361'
                WHERE ordernumber = 'P2502200000012' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456570'
                WHERE ordernumber = 'P2502200000013' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421198'
                WHERE ordernumber = 'P2502200000015' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456905'
                WHERE ordernumber = 'P2502200000016' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456034'
                WHERE ordernumber = 'P2502200000018' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457098'
                WHERE ordernumber = 'P2502200000019' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457098'
                WHERE ordernumber = 'P2502200000020' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457099'
                WHERE ordernumber = 'P2502200000021' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457094'
                WHERE ordernumber = 'P2502200000024' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457100'
                WHERE ordernumber = 'P2502200000026' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455674'
                WHERE ordernumber = 'P2502200000027' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455674'
                WHERE ordernumber = 'P2502200000028' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457102'
                WHERE ordernumber = 'P2502200000029' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457103'
                WHERE ordernumber = 'P2502200000030' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457105'
                WHERE ordernumber = 'P2502200000032' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457104'
                WHERE ordernumber = 'P2502200000034' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457108'
                WHERE ordernumber = 'P2502200000035' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291133'
                WHERE ordernumber = 'P2502200000040' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457106'
                WHERE ordernumber = 'P2502200000042' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291133'
                WHERE ordernumber = 'P2502200000043' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287196'
                WHERE ordernumber = 'P2502200000045' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276286'
                WHERE ordernumber = 'P2502200000047' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385082'
                WHERE ordernumber = 'P2502200000048' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '215538'
                WHERE ordernumber = 'P2502200000049' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457074'
                WHERE ordernumber = 'P2502200000052' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364056'
                WHERE ordernumber = 'P2502200000054' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457112'
                WHERE ordernumber = 'P2502200000053' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457113'
                WHERE ordernumber = 'P2502200000055' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104888'
                WHERE ordernumber = 'P2502200000056' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457114'
                WHERE ordernumber = 'P2502200000057' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389388'
                WHERE ordernumber = 'P2502200000058' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457115'
                WHERE ordernumber = 'P2502200000059' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457116'
                WHERE ordernumber = 'P2502200000065' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252835'
                WHERE ordernumber = 'P2502200000066' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252835'
                WHERE ordernumber = 'P2502200000068' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252835'
                WHERE ordernumber = 'P2502200000069' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457117'
                WHERE ordernumber = 'P2502200000070' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440035'
                WHERE ordernumber = 'P2502200000072' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279198'
                WHERE ordernumber = 'P2502200000075' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457119'
                WHERE ordernumber = 'P2502200000077' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457120'
                WHERE ordernumber = 'P2502200000079' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457121'
                WHERE ordernumber = 'P2502200000080' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '153610'
                WHERE ordernumber = 'P2502200000081' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435336'
                WHERE ordernumber = 'P2502200000082' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236930'
                WHERE ordernumber = 'P2502200000084' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '773'
                WHERE ordernumber = 'P2502200000085' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457122'
                WHERE ordernumber = 'P2502200000086' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457123'
                WHERE ordernumber = 'P2502200000087' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457124'
                WHERE ordernumber = 'P2502200000089' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435336'
                WHERE ordernumber = 'P2502200000091' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349740'
                WHERE ordernumber = 'P2502200000094' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439373'
                WHERE ordernumber = 'P2502200000097' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100197'
                WHERE ordernumber = 'P2502200000103' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2502200000107' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457128'
                WHERE ordernumber = 'P2502200000110' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457127'
                WHERE ordernumber = 'P2502200000112' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457130'
                WHERE ordernumber = 'P2502200000124' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442011'
                WHERE ordernumber = 'P2502200000126' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '131303'
                WHERE ordernumber = 'P2502200000131' 
            
2025-02-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457133'
                WHERE ordernumber = 'P2502200000141' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456930'
                WHERE ordernumber = 'P2502200000143' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457125'
                WHERE ordernumber = 'P2502200000144' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457134'
                WHERE ordernumber = 'P2502200000145' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118192'
                WHERE ordernumber = 'P2502200000146' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457133'
                WHERE ordernumber = 'P2502200000148' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457135'
                WHERE ordernumber = 'P2502200000149' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118192'
                WHERE ordernumber = 'P2502200000150' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228801'
                WHERE ordernumber = 'P2502200000156' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239484'
                WHERE ordernumber = 'P2502200000157' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237810'
                WHERE ordernumber = 'P2502200000158' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457136'
                WHERE ordernumber = 'P2502200000161' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457137'
                WHERE ordernumber = 'P2502200000163' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '453442'
                WHERE ordernumber = 'P2502200000165' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384028'
                WHERE ordernumber = 'P2502200000166' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85271'
                WHERE ordernumber = 'P2502200000169' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358902'
                WHERE ordernumber = 'P2502200000170' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457139'
                WHERE ordernumber = 'P2502200000171' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457138'
                WHERE ordernumber = 'P2502200000172' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '453485'
                WHERE ordernumber = 'P2502200000173' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431970'
                WHERE ordernumber = 'P2502200000177' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457105'
                WHERE ordernumber = 'P2502200000181' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360961'
                WHERE ordernumber = 'P2502200000187' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454602'
                WHERE ordernumber = 'P2502200000188' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457140'
                WHERE ordernumber = 'P2502200000190' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457141'
                WHERE ordernumber = 'P2502200000195' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143810'
                WHERE ordernumber = 'P2502200000198' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '451243'
                WHERE ordernumber = 'P2502200000199' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457143'
                WHERE ordernumber = 'P2502200000200' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457142'
                WHERE ordernumber = 'P2502200000201' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276878'
                WHERE ordernumber = 'P2502200000205' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457145'
                WHERE ordernumber = 'P2502200000207' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426022'
                WHERE ordernumber = 'P2502200000215' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457146'
                WHERE ordernumber = 'P2502200000220' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457147'
                WHERE ordernumber = 'P2502200000221' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420131'
                WHERE ordernumber = 'P2502200000223' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380315'
                WHERE ordernumber = 'P2502200000225' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455827'
                WHERE ordernumber = 'P2502200000226' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457148'
                WHERE ordernumber = 'P2502200000232' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424129'
                WHERE ordernumber = 'P2502200000234' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457151'
                WHERE ordernumber = 'P2502200000237' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457152'
                WHERE ordernumber = 'P2502200000239' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457153'
                WHERE ordernumber = 'P2502200000241' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432175'
                WHERE ordernumber = 'P2502200000245' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457154'
                WHERE ordernumber = 'P2502200000246' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457150'
                WHERE ordernumber = 'P2502200000248' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457155'
                WHERE ordernumber = 'P2502200000249' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428163'
                WHERE ordernumber = 'P2502200000250' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102102'
                WHERE ordernumber = 'P2502200000251' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457157'
                WHERE ordernumber = 'P2502200000252' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438952'
                WHERE ordernumber = 'P2502200000256' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '450752'
                WHERE ordernumber = 'P2502200000258' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457159'
                WHERE ordernumber = 'P2502200000259' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457160'
                WHERE ordernumber = 'P2502200000260' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245533'
                WHERE ordernumber = 'P2502200000261' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110069'
                WHERE ordernumber = 'P2502200000262' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425348'
                WHERE ordernumber = 'P2502200000267' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457158'
                WHERE ordernumber = 'P2502200000268' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371353'
                WHERE ordernumber = 'P2502200000270' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457162'
                WHERE ordernumber = 'P2502200000271' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457163'
                WHERE ordernumber = 'P2502200000274' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269152'
                WHERE ordernumber = 'P2502200000277' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457161'
                WHERE ordernumber = 'P2502200000278' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '444056'
                WHERE ordernumber = 'P2502200000279' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457164'
                WHERE ordernumber = 'P2502200000281' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97993'
                WHERE ordernumber = 'P2502200000283' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457165'
                WHERE ordernumber = 'P2502200000284' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457166'
                WHERE ordernumber = 'P2502200000285' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457167'
                WHERE ordernumber = 'P2502200000287' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322324'
                WHERE ordernumber = 'P2502200000288' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457169'
                WHERE ordernumber = 'P2502200000289' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415741'
                WHERE ordernumber = 'P2502200000291' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457170'
                WHERE ordernumber = 'P2502200000293' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100163'
                WHERE ordernumber = 'P2502200000300' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457172'
                WHERE ordernumber = 'P2502200000304' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249709'
                WHERE ordernumber = 'P2502200000306' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336729'
                WHERE ordernumber = 'P2502200000307' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457175'
                WHERE ordernumber = 'P2502200000308' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457176'
                WHERE ordernumber = 'P2502200000309' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315806'
                WHERE ordernumber = 'P2502200000311' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457177'
                WHERE ordernumber = 'P2502200000313' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457178'
                WHERE ordernumber = 'P2502200000315' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317004'
                WHERE ordernumber = 'P2502200000316' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457179'
                WHERE ordernumber = 'P2502200000318' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221061'
                WHERE ordernumber = 'P2502200000321' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457180'
                WHERE ordernumber = 'P2502200000323' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128999'
                WHERE ordernumber = 'P2502200000326' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415043'
                WHERE ordernumber = 'P2502200000327' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121962'
                WHERE ordernumber = 'P2502200000328' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457182'
                WHERE ordernumber = 'P2502200000329' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457181'
                WHERE ordernumber = 'P2502200000330' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457183'
                WHERE ordernumber = 'P2502200000332' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457184'
                WHERE ordernumber = 'P2502200000337' 
            
2025-02-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455885'
                WHERE ordernumber = 'P2502200000339' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457185'
                WHERE ordernumber = 'P2502200000341' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367683'
                WHERE ordernumber = 'P2502200000344' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313792'
                WHERE ordernumber = 'P2502200000348' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421813'
                WHERE ordernumber = 'P2502200000349' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457187'
                WHERE ordernumber = 'P2502200000350' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379589'
                WHERE ordernumber = 'P2502200000351' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457188'
                WHERE ordernumber = 'P2502200000352' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278500'
                WHERE ordernumber = 'P2502200000354' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290000'
                WHERE ordernumber = 'P2502200000356' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285991'
                WHERE ordernumber = 'P2502200000358' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457190'
                WHERE ordernumber = 'P2502200000359' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109237'
                WHERE ordernumber = 'P2502200000361' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457191'
                WHERE ordernumber = 'P2502200000362' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457012'
                WHERE ordernumber = 'P2502200000368' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457193'
                WHERE ordernumber = 'P2502200000370' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457192'
                WHERE ordernumber = 'P2502200000371' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384149'
                WHERE ordernumber = 'P2502200000373' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457030'
                WHERE ordernumber = 'P2502200000375' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457156'
                WHERE ordernumber = 'P2502200000376' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289480'
                WHERE ordernumber = 'P2502200000377' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116827'
                WHERE ordernumber = 'P2502200000378' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287503'
                WHERE ordernumber = 'P2502200000379' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162020'
                WHERE ordernumber = 'P2502200000381' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398531'
                WHERE ordernumber = 'P2502200000382' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457195'
                WHERE ordernumber = 'P2502200000384' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457196'
                WHERE ordernumber = 'P2502200000386' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403590'
                WHERE ordernumber = 'P2502200000390' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345372'
                WHERE ordernumber = 'P2502200000392' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457198'
                WHERE ordernumber = 'P2502200000397' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457198'
                WHERE ordernumber = 'P2502200000400' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457199'
                WHERE ordernumber = 'P2502200000401' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457197'
                WHERE ordernumber = 'P2502200000403' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457199'
                WHERE ordernumber = 'P2502200000405' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457202'
                WHERE ordernumber = 'P2502200000410' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457203'
                WHERE ordernumber = 'P2502200000411' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457204'
                WHERE ordernumber = 'P2502200000412' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457205'
                WHERE ordernumber = 'P2502200000416' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397252'
                WHERE ordernumber = 'P2502200000417' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457206'
                WHERE ordernumber = 'P2502200000418' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397252'
                WHERE ordernumber = 'P2502200000419' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457207'
                WHERE ordernumber = 'P2502200000422' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442009'
                WHERE ordernumber = 'P2502200000424' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457208'
                WHERE ordernumber = 'P2502200000429' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457209'
                WHERE ordernumber = 'P2502200000433' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457210'
                WHERE ordernumber = 'P2502200000436' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127613'
                WHERE ordernumber = 'P2502200000437' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106772'
                WHERE ordernumber = 'P2502200000439' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117117'
                WHERE ordernumber = 'P2502200000443' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117117'
                WHERE ordernumber = 'P2502200000444' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457213'
                WHERE ordernumber = 'P2502200000447' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457214'
                WHERE ordernumber = 'P2502200000448' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154616'
                WHERE ordernumber = 'P2502200000449' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277242'
                WHERE ordernumber = 'P2502200000457' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224420'
                WHERE ordernumber = 'P2502200000459' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424974'
                WHERE ordernumber = 'P2502200000464' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220826'
                WHERE ordernumber = 'P2502200000467' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224420'
                WHERE ordernumber = 'P2502200000469' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430269'
                WHERE ordernumber = 'P2502200000470' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457215'
                WHERE ordernumber = 'P2502200000471' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457217'
                WHERE ordernumber = 'P2502200000480' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457216'
                WHERE ordernumber = 'P2502200000482' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457218'
                WHERE ordernumber = 'P2502200000483' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457219'
                WHERE ordernumber = 'P2502200000484' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453336'
                WHERE ordernumber = 'P2502200000487' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457220'
                WHERE ordernumber = 'P2502200000488' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457221'
                WHERE ordernumber = 'P2502200000489' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141809'
                WHERE ordernumber = 'P2502200000494' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162397'
                WHERE ordernumber = 'P2502200000499' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399334'
                WHERE ordernumber = 'P2502200000502' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300866'
                WHERE ordernumber = 'P2502200000505' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379256'
                WHERE ordernumber = 'P2502200000507' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457222'
                WHERE ordernumber = 'P2502200000511' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298520'
                WHERE ordernumber = 'P2502200000513' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382512'
                WHERE ordernumber = 'P2502200000514' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457223'
                WHERE ordernumber = 'P2502200000517' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99355'
                WHERE ordernumber = 'P2502200000518' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457225'
                WHERE ordernumber = 'P2502200000523' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279356'
                WHERE ordernumber = 'P2502200000524' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457226'
                WHERE ordernumber = 'P2502200000525' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286421'
                WHERE ordernumber = 'P2502200000526' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457224'
                WHERE ordernumber = 'P2502200000527' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283648'
                WHERE ordernumber = 'P2502200000528' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '447396'
                WHERE ordernumber = 'P2502200000531' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433429'
                WHERE ordernumber = 'P2502200000533' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381865'
                WHERE ordernumber = 'P2502200000536' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455021'
                WHERE ordernumber = 'P2502200000537' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248820'
                WHERE ordernumber = 'P2502200000538' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390490'
                WHERE ordernumber = 'P2502200000539' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99470'
                WHERE ordernumber = 'P2502200000540' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457228'
                WHERE ordernumber = 'P2502200000544' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457229'
                WHERE ordernumber = 'P2502200000547' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455448'
                WHERE ordernumber = 'P2502200000549' 
            
2025-02-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '134545'
                WHERE ordernumber = 'P2502200000550' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403214'
                WHERE ordernumber = 'P2502200000551' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457230'
                WHERE ordernumber = 'P2502200000554' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '150775'
                WHERE ordernumber = 'P2502200000556' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93683'
                WHERE ordernumber = 'P2502200000557' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457231'
                WHERE ordernumber = 'P2502200000559' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457232'
                WHERE ordernumber = 'P2502200000562' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457233'
                WHERE ordernumber = 'P2502200000565' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457234'
                WHERE ordernumber = 'P2502200000567' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456513'
                WHERE ordernumber = 'P2502200000570' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '69286'
                WHERE ordernumber = 'P2502200000572' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393164'
                WHERE ordernumber = 'P2502200000573' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457234'
                WHERE ordernumber = 'P2502200000578' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422748'
                WHERE ordernumber = 'P2502200000583' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457237'
                WHERE ordernumber = 'P2502200000589' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457238'
                WHERE ordernumber = 'P2502200000590' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457239'
                WHERE ordernumber = 'P2502200000591' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457240'
                WHERE ordernumber = 'P2502200000592' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '260612'
                WHERE ordernumber = 'P2502200000593' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457241'
                WHERE ordernumber = 'P2502200000594' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457242'
                WHERE ordernumber = 'P2502200000597' 
            
2025-02-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352656'
                WHERE ordernumber = 'P2502200000599'