2025-01-07 01:00:02 -- 將會員中心id寫入data-lake
2025-01-07 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2025-01-06%';
        
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '49860'
                WHERE ordernumber = 'P2501060000010' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '444974'
                WHERE ordernumber = 'P2501060000012' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '444974'
                WHERE ordernumber = 'P2501060000014' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123611'
                WHERE ordernumber = 'P2501060000015' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99139'
                WHERE ordernumber = 'P2501060000016' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '49860'
                WHERE ordernumber = 'P2501060000018' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291415'
                WHERE ordernumber = 'P2501060000019' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114267'
                WHERE ordernumber = 'P2501060000020' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394071'
                WHERE ordernumber = 'P2501060000023' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276379'
                WHERE ordernumber = 'P2501060000026' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302614'
                WHERE ordernumber = 'P2501060000029' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '444981'
                WHERE ordernumber = 'P2501060000031' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381786'
                WHERE ordernumber = 'P2501060000032' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302397'
                WHERE ordernumber = 'P2501060000033' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252332'
                WHERE ordernumber = 'P2501060000034' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '444982'
                WHERE ordernumber = 'P2501060000035' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369186'
                WHERE ordernumber = 'P2501060000036' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438417'
                WHERE ordernumber = 'P2501060000038' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438417'
                WHERE ordernumber = 'P2501060000041' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '201559'
                WHERE ordernumber = 'P2501060000042' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312010'
                WHERE ordernumber = 'P2501060000044' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338639'
                WHERE ordernumber = 'P2501060000047' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '444991'
                WHERE ordernumber = 'P2501060000048' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '444995'
                WHERE ordernumber = 'P2501060000049' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243770'
                WHERE ordernumber = 'P2501060000054' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '443804'
                WHERE ordernumber = 'P2501060000055' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '443804'
                WHERE ordernumber = 'P2501060000056' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '443804'
                WHERE ordernumber = 'P2501060000057' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '444999'
                WHERE ordernumber = 'P2501060000059' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301138'
                WHERE ordernumber = 'P2501060000060' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166544'
                WHERE ordernumber = 'P2501060000062' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445003'
                WHERE ordernumber = 'P2501060000066' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '443684'
                WHERE ordernumber = 'P2501060000069' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '443684'
                WHERE ordernumber = 'P2501060000070' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2501060000072' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445005'
                WHERE ordernumber = 'P2501060000073' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '132866'
                WHERE ordernumber = 'P2501060000074' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429870'
                WHERE ordernumber = 'P2501060000076' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392009'
                WHERE ordernumber = 'P2501060000082' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445008'
                WHERE ordernumber = 'P2501060000083' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431853'
                WHERE ordernumber = 'P2501060000089' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445018'
                WHERE ordernumber = 'P2501060000093' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103520'
                WHERE ordernumber = 'P2501060000096' 
            
2025-01-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '445011'
                WHERE ordernumber = 'P2501060000102' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443475'
                WHERE ordernumber = 'P2501060000103' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397025'
                WHERE ordernumber = 'P2501060000105' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276041'
                WHERE ordernumber = 'P2501060000110' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123223'
                WHERE ordernumber = 'P2501060000113' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311958'
                WHERE ordernumber = 'P2501060000115' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123223'
                WHERE ordernumber = 'P2501060000123' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315795'
                WHERE ordernumber = 'P2501060000124' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P2501060000125' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445033'
                WHERE ordernumber = 'P2501060000126' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415328'
                WHERE ordernumber = 'P2501060000127' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441676'
                WHERE ordernumber = 'P2501060000134' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429290'
                WHERE ordernumber = 'P2501060000136' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445045'
                WHERE ordernumber = 'P2501060000139' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296904'
                WHERE ordernumber = 'P2501060000146' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440980'
                WHERE ordernumber = 'P2501060000150' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '192556'
                WHERE ordernumber = 'P2501060000151' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445055'
                WHERE ordernumber = 'P2501060000152' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430236'
                WHERE ordernumber = 'P2501060000155' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346678'
                WHERE ordernumber = 'P2501060000157' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311867'
                WHERE ordernumber = 'P2501060000159' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '444446'
                WHERE ordernumber = 'P2501060000165' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417958'
                WHERE ordernumber = 'P2501060000168' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248386'
                WHERE ordernumber = 'P2501060000170' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211298'
                WHERE ordernumber = 'P2501060000171' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445064'
                WHERE ordernumber = 'P2501060000172' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100346'
                WHERE ordernumber = 'P2501060000174' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114151'
                WHERE ordernumber = 'P2501060000175' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337747'
                WHERE ordernumber = 'P2501060000176' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211298'
                WHERE ordernumber = 'P2501060000177' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313933'
                WHERE ordernumber = 'P2501060000179' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445068'
                WHERE ordernumber = 'P2501060000181' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145382'
                WHERE ordernumber = 'P2501060000188' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337926'
                WHERE ordernumber = 'P2501060000190' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145382'
                WHERE ordernumber = 'P2501060000192' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101882'
                WHERE ordernumber = 'P2501060000193' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445073'
                WHERE ordernumber = 'P2501060000195' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396949'
                WHERE ordernumber = 'P2501060000196' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417811'
                WHERE ordernumber = 'P2501060000197' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445080'
                WHERE ordernumber = 'P2501060000206' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247665'
                WHERE ordernumber = 'P2501060000207' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290339'
                WHERE ordernumber = 'P2501060000208' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281382'
                WHERE ordernumber = 'P2501060000210' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127514'
                WHERE ordernumber = 'P2501060000211' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132169'
                WHERE ordernumber = 'P2501060000215' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357143'
                WHERE ordernumber = 'P2501060000216' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443817'
                WHERE ordernumber = 'P2501060000218' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109895'
                WHERE ordernumber = 'P2501060000219' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445089'
                WHERE ordernumber = 'P2501060000221' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378990'
                WHERE ordernumber = 'P2501060000225' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443314'
                WHERE ordernumber = 'P2501060000231' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445098'
                WHERE ordernumber = 'P2501060000233' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394199'
                WHERE ordernumber = 'P2501060000235' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425623'
                WHERE ordernumber = 'P2501060000246' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230984'
                WHERE ordernumber = 'P2501060000248' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98774'
                WHERE ordernumber = 'P2501060000250' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442399'
                WHERE ordernumber = 'P2501060000252' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296998'
                WHERE ordernumber = 'P2501060000255' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P2501060000256' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445112'
                WHERE ordernumber = 'P2501060000259' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P2501060000262' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '201031'
                WHERE ordernumber = 'P2501060000267' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271831'
                WHERE ordernumber = 'P2501060000269' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440092'
                WHERE ordernumber = 'P2501060000270' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435306'
                WHERE ordernumber = 'P2501060000279' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445108'
                WHERE ordernumber = 'P2501060000280' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445110'
                WHERE ordernumber = 'P2501060000281' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270609'
                WHERE ordernumber = 'P2501060000282' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445118'
                WHERE ordernumber = 'P2501060000286' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362292'
                WHERE ordernumber = 'P2501060000287' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445123'
                WHERE ordernumber = 'P2501060000291' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296572'
                WHERE ordernumber = 'P2501060000296' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445131'
                WHERE ordernumber = 'P2501060000299' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431868'
                WHERE ordernumber = 'P2501060000300' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325030'
                WHERE ordernumber = 'P2501060000304' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317716'
                WHERE ordernumber = 'P2501060000309' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445129'
                WHERE ordernumber = 'P2501060000311' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395528'
                WHERE ordernumber = 'P2501060000314' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41164'
                WHERE ordernumber = 'P2501060000315' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39039'
                WHERE ordernumber = 'P2501060000316' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339205'
                WHERE ordernumber = 'P2501060000317' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445139'
                WHERE ordernumber = 'P2501060000320' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438214'
                WHERE ordernumber = 'P2501060000323' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445145'
                WHERE ordernumber = 'P2501060000324' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282480'
                WHERE ordernumber = 'P2501060000325' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441596'
                WHERE ordernumber = 'P2501060000326' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445147'
                WHERE ordernumber = 'P2501060000327' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445146'
                WHERE ordernumber = 'P2501060000328' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445151'
                WHERE ordernumber = 'P2501060000334' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106185'
                WHERE ordernumber = 'P2501060000337' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445156'
                WHERE ordernumber = 'P2501060000345' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442344'
                WHERE ordernumber = 'P2501060000348' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445160'
                WHERE ordernumber = 'P2501060000349' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334937'
                WHERE ordernumber = 'P2501060000355' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389093'
                WHERE ordernumber = 'P2501060000356' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445156'
                WHERE ordernumber = 'P2501060000363' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254509'
                WHERE ordernumber = 'P2501060000366' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232805'
                WHERE ordernumber = 'P2501060000367' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353527'
                WHERE ordernumber = 'P2501060000369' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '37954'
                WHERE ordernumber = 'P2501060000372' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353527'
                WHERE ordernumber = 'P2501060000373' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387919'
                WHERE ordernumber = 'P2501060000376' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269032'
                WHERE ordernumber = 'P2501060000377' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445174'
                WHERE ordernumber = 'P2501060000383' 
            
2025-01-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '202133'
                WHERE ordernumber = 'P2501060000386' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445181'
                WHERE ordernumber = 'P2501060000391' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264487'
                WHERE ordernumber = 'P2501060000395' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81671'
                WHERE ordernumber = 'P2501060000402' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445184'
                WHERE ordernumber = 'P2501060000407' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390936'
                WHERE ordernumber = 'P2501060000411' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88985'
                WHERE ordernumber = 'P2501060000416' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445187'
                WHERE ordernumber = 'P2501060000417' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237985'
                WHERE ordernumber = 'P2501060000419' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363902'
                WHERE ordernumber = 'P2501060000425' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261924'
                WHERE ordernumber = 'P2501060000427' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93395'
                WHERE ordernumber = 'P2501060000431' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445191'
                WHERE ordernumber = 'P2501060000432' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429060'
                WHERE ordernumber = 'P2501060000434' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93395'
                WHERE ordernumber = 'P2501060000435' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347515'
                WHERE ordernumber = 'P2501060000443' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407174'
                WHERE ordernumber = 'P2501060000445' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380016'
                WHERE ordernumber = 'P2501060000446' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279396'
                WHERE ordernumber = 'P2501060000447' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364715'
                WHERE ordernumber = 'P2501060000453' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438525'
                WHERE ordernumber = 'P2501060000454' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344424'
                WHERE ordernumber = 'P2501060000459' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '444408'
                WHERE ordernumber = 'P2501060000460' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P2501060000476' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343537'
                WHERE ordernumber = 'P2501060000482' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406463'
                WHERE ordernumber = 'P2501060000488' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406463'
                WHERE ordernumber = 'P2501060000490' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289110'
                WHERE ordernumber = 'P2501060000492' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445214'
                WHERE ordernumber = 'P2501060000494' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445207'
                WHERE ordernumber = 'P2501060000496' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '444874'
                WHERE ordernumber = 'P2501060000501' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '441002'
                WHERE ordernumber = 'P2501060000517' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '441642'
                WHERE ordernumber = 'P2501060000520' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445218'
                WHERE ordernumber = 'P2501060000526' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216961'
                WHERE ordernumber = 'P2501060000527' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272166'
                WHERE ordernumber = 'P2501060000528' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263990'
                WHERE ordernumber = 'P2501060000531' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445227'
                WHERE ordernumber = 'P2501060000535' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139381'
                WHERE ordernumber = 'P2501060000536' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358443'
                WHERE ordernumber = 'P2501060000543' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427764'
                WHERE ordernumber = 'P2501060000551' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445227'
                WHERE ordernumber = 'P2501060000555' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283963'
                WHERE ordernumber = 'P2501060000556' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445230'
                WHERE ordernumber = 'P2501060000557' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341057'
                WHERE ordernumber = 'P2501060000558' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445232'
                WHERE ordernumber = 'P2501060000559' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445234'
                WHERE ordernumber = 'P2501060000563' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445235'
                WHERE ordernumber = 'P2501060000565' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236189'
                WHERE ordernumber = 'P2501060000567' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384276'
                WHERE ordernumber = 'P2501060000570' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445241'
                WHERE ordernumber = 'P2501060000572' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292220'
                WHERE ordernumber = 'P2501060000573' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429064'
                WHERE ordernumber = 'P2501060000576' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381870'
                WHERE ordernumber = 'P2501060000577' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445243'
                WHERE ordernumber = 'P2501060000578' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442092'
                WHERE ordernumber = 'P2501060000580' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427026'
                WHERE ordernumber = 'P2501060000581' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442092'
                WHERE ordernumber = 'P2501060000584' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '16439'
                WHERE ordernumber = 'P2501060000585' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439163'
                WHERE ordernumber = 'P2501060000592' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328932'
                WHERE ordernumber = 'P2501060000600' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445245'
                WHERE ordernumber = 'P2501060000606' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379943'
                WHERE ordernumber = 'P2501060000607' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445025'
                WHERE ordernumber = 'P2501060000608' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439478'
                WHERE ordernumber = 'P2501060000609' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333899'
                WHERE ordernumber = 'P2501060000610' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345372'
                WHERE ordernumber = 'P2501060000614' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280616'
                WHERE ordernumber = 'P2501060000616' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442199'
                WHERE ordernumber = 'P2501060000623' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445262'
                WHERE ordernumber = 'P2501060000625' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294266'
                WHERE ordernumber = 'P2501060000627' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442199'
                WHERE ordernumber = 'P2501060000623' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96181'
                WHERE ordernumber = 'P2501060000630' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445264'
                WHERE ordernumber = 'P2501060000634' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445264'
                WHERE ordernumber = 'P2501060000635' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245511'
                WHERE ordernumber = 'P2501060000636' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445270'
                WHERE ordernumber = 'P2501060000637' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445269'
                WHERE ordernumber = 'P2501060000638' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445264'
                WHERE ordernumber = 'P2501060000641' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445271'
                WHERE ordernumber = 'P2501060000650' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '441572'
                WHERE ordernumber = 'P2501060000655' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '441572'
                WHERE ordernumber = 'P2501060000656' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445270'
                WHERE ordernumber = 'P2501060000657' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272784'
                WHERE ordernumber = 'P2501060000658' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445274'
                WHERE ordernumber = 'P2501060000660' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445267'
                WHERE ordernumber = 'P2501060000661' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384874'
                WHERE ordernumber = 'P2501060000662' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222366'
                WHERE ordernumber = 'P2501060000663' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445272'
                WHERE ordernumber = 'P2501060000670' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445278'
                WHERE ordernumber = 'P2501060000671' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168576'
                WHERE ordernumber = 'P2501060000673' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168576'
                WHERE ordernumber = 'P2501060000675' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445282'
                WHERE ordernumber = 'P2501060000679' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '152613'
                WHERE ordernumber = 'P2501060000681' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445286'
                WHERE ordernumber = 'P2501060000684' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '61511'
                WHERE ordernumber = 'P2501060000685' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445281'
                WHERE ordernumber = 'P2501060000686' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445279'
                WHERE ordernumber = 'P2501060000688' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301997'
                WHERE ordernumber = 'P2501060000695' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224465'
                WHERE ordernumber = 'P2501060000697' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445296'
                WHERE ordernumber = 'P2501060000701' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96109'
                WHERE ordernumber = 'P2501060000703' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141692'
                WHERE ordernumber = 'P2501060000709' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378379'
                WHERE ordernumber = 'P2501060000712' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '445304'
                WHERE ordernumber = 'P2501060000717' 
            
2025-01-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300147'
                WHERE ordernumber = 'P2501060000719' 
            
2025-01-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239207'
                WHERE ordernumber = 'P2501060000720' 
            
2025-01-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239207'
                WHERE ordernumber = 'P2501060000722'