2025-02-24 01:00:01 -- 將會員中心id寫入data-lake
2025-02-24 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-23%';
        
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380535'
                WHERE ordernumber = 'P2502230000011' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112484'
                WHERE ordernumber = 'P2502230000014' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456799'
                WHERE ordernumber = 'P2502230000015' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457662'
                WHERE ordernumber = 'P2502230000016' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276877'
                WHERE ordernumber = 'P2502230000017' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359232'
                WHERE ordernumber = 'P2502230000023' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342071'
                WHERE ordernumber = 'P2502230000024' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457664'
                WHERE ordernumber = 'P2502230000026' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212680'
                WHERE ordernumber = 'P2502230000028' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '165559'
                WHERE ordernumber = 'P2502230000030' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457666'
                WHERE ordernumber = 'P2502230000032' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240295'
                WHERE ordernumber = 'P2502230000035' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457669'
                WHERE ordernumber = 'P2502230000037' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457671'
                WHERE ordernumber = 'P2502230000038' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457668'
                WHERE ordernumber = 'P2502230000039' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309191'
                WHERE ordernumber = 'P2502230000040' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316470'
                WHERE ordernumber = 'P2502230000043' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457670'
                WHERE ordernumber = 'P2502230000045' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355043'
                WHERE ordernumber = 'P2502230000048' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457671'
                WHERE ordernumber = 'P2502230000050' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457673'
                WHERE ordernumber = 'P2502230000051' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457674'
                WHERE ordernumber = 'P2502230000053' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457675'
                WHERE ordernumber = 'P2502230000060' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456530'
                WHERE ordernumber = 'P2502230000062' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456530'
                WHERE ordernumber = 'P2502230000063' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457677'
                WHERE ordernumber = 'P2502230000068' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457678'
                WHERE ordernumber = 'P2502230000071' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390876'
                WHERE ordernumber = 'P2502230000075' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '292139'
                WHERE ordernumber = 'P2502230000078' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457680'
                WHERE ordernumber = 'P2502230000081' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457679'
                WHERE ordernumber = 'P2502230000082' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412749'
                WHERE ordernumber = 'P2502230000083' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107291'
                WHERE ordernumber = 'P2502230000086' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457682'
                WHERE ordernumber = 'P2502230000090' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457681'
                WHERE ordernumber = 'P2502230000092' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385853'
                WHERE ordernumber = 'P2502230000098' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457683'
                WHERE ordernumber = 'P2502230000102' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98968'
                WHERE ordernumber = 'P2502230000105' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99845'
                WHERE ordernumber = 'P2502230000108' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457685'
                WHERE ordernumber = 'P2502230000113' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457686'
                WHERE ordernumber = 'P2502230000115' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457687'
                WHERE ordernumber = 'P2502230000116' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457688'
                WHERE ordernumber = 'P2502230000117' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '227856'
                WHERE ordernumber = 'P2502230000118' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128783'
                WHERE ordernumber = 'P2502230000121' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456971'
                WHERE ordernumber = 'P2502230000123' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457692'
                WHERE ordernumber = 'P2502230000125' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440600'
                WHERE ordernumber = 'P2502230000127' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415019'
                WHERE ordernumber = 'P2502230000128' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457694'
                WHERE ordernumber = 'P2502230000131' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436708'
                WHERE ordernumber = 'P2502230000133' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457695'
                WHERE ordernumber = 'P2502230000142' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457696'
                WHERE ordernumber = 'P2502230000150' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457697'
                WHERE ordernumber = 'P2502230000155' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457697'
                WHERE ordernumber = 'P2502230000157' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457698'
                WHERE ordernumber = 'P2502230000158' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '92319'
                WHERE ordernumber = 'P2502230000164' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457699'
                WHERE ordernumber = 'P2502230000166' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310414'
                WHERE ordernumber = 'P2502230000175' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457701'
                WHERE ordernumber = 'P2502230000179' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457702'
                WHERE ordernumber = 'P2502230000186' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302493'
                WHERE ordernumber = 'P2502230000188' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129091'
                WHERE ordernumber = 'P2502230000189' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420086'
                WHERE ordernumber = 'P2502230000194' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355309'
                WHERE ordernumber = 'P2502230000196' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '333591'
                WHERE ordernumber = 'P2502230000198' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457679'
                WHERE ordernumber = 'P2502230000199' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457704'
                WHERE ordernumber = 'P2502230000202' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96897'
                WHERE ordernumber = 'P2502230000204' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457444'
                WHERE ordernumber = 'P2502230000205' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457705'
                WHERE ordernumber = 'P2502230000211' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457706'
                WHERE ordernumber = 'P2502230000213' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457707'
                WHERE ordernumber = 'P2502230000215' 
            
2025-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457708'
                WHERE ordernumber = 'P2502230000216' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457709'
                WHERE ordernumber = 'P2502230000218' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '24300'
                WHERE ordernumber = 'P2502230000220' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457712'
                WHERE ordernumber = 'P2502230000223' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307446'
                WHERE ordernumber = 'P2502230000226' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457709'
                WHERE ordernumber = 'P2502230000228' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457710'
                WHERE ordernumber = 'P2502230000229' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322456'
                WHERE ordernumber = 'P2502230000231' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457713'
                WHERE ordernumber = 'P2502230000233' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457713'
                WHERE ordernumber = 'P2502230000234' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457714'
                WHERE ordernumber = 'P2502230000237' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99900'
                WHERE ordernumber = 'P2502230000238' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457717'
                WHERE ordernumber = 'P2502230000247' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399262'
                WHERE ordernumber = 'P2502230000254' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457719'
                WHERE ordernumber = 'P2502230000258' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457720'
                WHERE ordernumber = 'P2502230000262' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457718'
                WHERE ordernumber = 'P2502230000264' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296753'
                WHERE ordernumber = 'P2502230000266' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398360'
                WHERE ordernumber = 'P2502230000268' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457718'
                WHERE ordernumber = 'P2502230000269' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457722'
                WHERE ordernumber = 'P2502230000272' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457716'
                WHERE ordernumber = 'P2502230000274' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457721'
                WHERE ordernumber = 'P2502230000277' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321135'
                WHERE ordernumber = 'P2502230000278' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457723'
                WHERE ordernumber = 'P2502230000279' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457724'
                WHERE ordernumber = 'P2502230000284' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457725'
                WHERE ordernumber = 'P2502230000285' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457727'
                WHERE ordernumber = 'P2502230000288' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284523'
                WHERE ordernumber = 'P2502230000291' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457728'
                WHERE ordernumber = 'P2502230000294' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321851'
                WHERE ordernumber = 'P2502230000297' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457729'
                WHERE ordernumber = 'P2502230000298' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457730'
                WHERE ordernumber = 'P2502230000301' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457724'
                WHERE ordernumber = 'P2502230000302' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457731'
                WHERE ordernumber = 'P2502230000304' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457732'
                WHERE ordernumber = 'P2502230000305' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457734'
                WHERE ordernumber = 'P2502230000312' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301523'
                WHERE ordernumber = 'P2502230000313' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457733'
                WHERE ordernumber = 'P2502230000318' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457737'
                WHERE ordernumber = 'P2502230000321' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457738'
                WHERE ordernumber = 'P2502230000322' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457739'
                WHERE ordernumber = 'P2502230000326' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457740'
                WHERE ordernumber = 'P2502230000330' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457736'
                WHERE ordernumber = 'P2502230000335' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457741'
                WHERE ordernumber = 'P2502230000337' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457742'
                WHERE ordernumber = 'P2502230000339' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457745'
                WHERE ordernumber = 'P2502230000342' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457746'
                WHERE ordernumber = 'P2502230000343' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457747'
                WHERE ordernumber = 'P2502230000345' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457743'
                WHERE ordernumber = 'P2502230000346' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457748'
                WHERE ordernumber = 'P2502230000347' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457750'
                WHERE ordernumber = 'P2502230000352' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457749'
                WHERE ordernumber = 'P2502230000354' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457752'
                WHERE ordernumber = 'P2502230000359' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457751'
                WHERE ordernumber = 'P2502230000360' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454595'
                WHERE ordernumber = 'P2502230000367' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457754'
                WHERE ordernumber = 'P2502230000369' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457755'
                WHERE ordernumber = 'P2502230000370' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457756'
                WHERE ordernumber = 'P2502230000371' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456067'
                WHERE ordernumber = 'P2502230000373' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373372'
                WHERE ordernumber = 'P2502230000379' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457758'
                WHERE ordernumber = 'P2502230000381' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457759'
                WHERE ordernumber = 'P2502230000398' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457761'
                WHERE ordernumber = 'P2502230000403' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457764'
                WHERE ordernumber = 'P2502230000404' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457763'
                WHERE ordernumber = 'P2502230000409' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314097'
                WHERE ordernumber = 'P2502230000414' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208413'
                WHERE ordernumber = 'P2502230000416' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432467'
                WHERE ordernumber = 'P2502230000418' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457765'
                WHERE ordernumber = 'P2502230000421' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457766'
                WHERE ordernumber = 'P2502230000427' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378387'
                WHERE ordernumber = 'P2502230000431' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457768'
                WHERE ordernumber = 'P2502230000436' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457769'
                WHERE ordernumber = 'P2502230000437' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99455'
                WHERE ordernumber = 'P2502230000440' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457770'
                WHERE ordernumber = 'P2502230000447' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457771'
                WHERE ordernumber = 'P2502230000449' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457772'
                WHERE ordernumber = 'P2502230000451' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457777'
                WHERE ordernumber = 'P2502230000453' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457773'
                WHERE ordernumber = 'P2502230000454' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62911'
                WHERE ordernumber = 'P2502230000457' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457777'
                WHERE ordernumber = 'P2502230000458' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457774'
                WHERE ordernumber = 'P2502230000459' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457778'
                WHERE ordernumber = 'P2502230000463' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280830'
                WHERE ordernumber = 'P2502230000467' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457779'
                WHERE ordernumber = 'P2502230000471' 
            
2025-02-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242226'
                WHERE ordernumber = 'P2502230000472' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457780'
                WHERE ordernumber = 'P2502230000475' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456668'
                WHERE ordernumber = 'P2502230000480' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457776'
                WHERE ordernumber = 'P2502230000485' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293351'
                WHERE ordernumber = 'P2502230000486' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457775'
                WHERE ordernumber = 'P2502230000487' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457781'
                WHERE ordernumber = 'P2502230000488' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349611'
                WHERE ordernumber = 'P2502230000489' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457783'
                WHERE ordernumber = 'P2502230000490' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457782'
                WHERE ordernumber = 'P2502230000492' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429060'
                WHERE ordernumber = 'P2502230000494' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453859'
                WHERE ordernumber = 'P2502230000495' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453859'
                WHERE ordernumber = 'P2502230000497' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457788'
                WHERE ordernumber = 'P2502230000498' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335468'
                WHERE ordernumber = 'P2502230000499' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457785'
                WHERE ordernumber = 'P2502230000501' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457783'
                WHERE ordernumber = 'P2502230000502' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457789'
                WHERE ordernumber = 'P2502230000504' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346578'
                WHERE ordernumber = 'P2502230000511' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '448953'
                WHERE ordernumber = 'P2502230000515' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457796'
                WHERE ordernumber = 'P2502230000517' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236671'
                WHERE ordernumber = 'P2502230000519' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457798'
                WHERE ordernumber = 'P2502230000521' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457799'
                WHERE ordernumber = 'P2502230000522' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431627'
                WHERE ordernumber = 'P2502230000525' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457798'
                WHERE ordernumber = 'P2502230000526' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457793'
                WHERE ordernumber = 'P2502230000528' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245656'
                WHERE ordernumber = 'P2502230000529' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457795'
                WHERE ordernumber = 'P2502230000531' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401256'
                WHERE ordernumber = 'P2502230000536' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457800'
                WHERE ordernumber = 'P2502230000538' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457801'
                WHERE ordernumber = 'P2502230000540' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '444620'
                WHERE ordernumber = 'P2502230000541' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455630'
                WHERE ordernumber = 'P2502230000542' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380988'
                WHERE ordernumber = 'P2502230000545' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295454'
                WHERE ordernumber = 'P2502230000547' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295454'
                WHERE ordernumber = 'P2502230000548' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166015'
                WHERE ordernumber = 'P2502230000549' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237608'
                WHERE ordernumber = 'P2502230000552' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457803'
                WHERE ordernumber = 'P2502230000556' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '156114'
                WHERE ordernumber = 'P2502230000559' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457804'
                WHERE ordernumber = 'P2502230000561' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383420'
                WHERE ordernumber = 'P2502230000562' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446532'
                WHERE ordernumber = 'P2502230000569' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239647'
                WHERE ordernumber = 'P2502230000577' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457808'
                WHERE ordernumber = 'P2502230000579' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '448759'
                WHERE ordernumber = 'P2502230000580' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405696'
                WHERE ordernumber = 'P2502230000581' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457806'
                WHERE ordernumber = 'P2502230000583' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457613'
                WHERE ordernumber = 'P2502230000584' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457807'
                WHERE ordernumber = 'P2502230000585' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457809'
                WHERE ordernumber = 'P2502230000587' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347340'
                WHERE ordernumber = 'P2502230000588' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367519'
                WHERE ordernumber = 'P2502230000589' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457811'
                WHERE ordernumber = 'P2502230000593' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457810'
                WHERE ordernumber = 'P2502230000596' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457812'
                WHERE ordernumber = 'P2502230000597' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165882'
                WHERE ordernumber = 'P2502230000600' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457813'
                WHERE ordernumber = 'P2502230000606' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457790'
                WHERE ordernumber = 'P2502230000608' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320540'
                WHERE ordernumber = 'P2502230000615' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457814'
                WHERE ordernumber = 'P2502230000623' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '450159'
                WHERE ordernumber = 'P2502230000625' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453581'
                WHERE ordernumber = 'P2502230000626' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457815'
                WHERE ordernumber = 'P2502230000630' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311369'
                WHERE ordernumber = 'P2502230000631' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457817'
                WHERE ordernumber = 'P2502230000635' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457816'
                WHERE ordernumber = 'P2502230000636' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457818'
                WHERE ordernumber = 'P2502230000637' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455475'
                WHERE ordernumber = 'P2502230000642' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457819'
                WHERE ordernumber = 'P2502230000644' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457821'
                WHERE ordernumber = 'P2502230000645' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457820'
                WHERE ordernumber = 'P2502230000646' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457822'
                WHERE ordernumber = 'P2502230000647' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457823'
                WHERE ordernumber = 'P2502230000653' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173407'
                WHERE ordernumber = 'P2502230000658' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398777'
                WHERE ordernumber = 'P2502230000661' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271526'
                WHERE ordernumber = 'P2502230000665' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166083'
                WHERE ordernumber = 'P2502230000667' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456125'
                WHERE ordernumber = 'P2502230000668' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332588'
                WHERE ordernumber = 'P2502230000672' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457826'
                WHERE ordernumber = 'P2502230000671' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457827'
                WHERE ordernumber = 'P2502230000676' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457829'
                WHERE ordernumber = 'P2502230000679' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457825'
                WHERE ordernumber = 'P2502230000681' 
            
2025-02-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457831'
                WHERE ordernumber = 'P2502230000687' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457832'
                WHERE ordernumber = 'P2502230000690' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398700'
                WHERE ordernumber = 'P2502230000691' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379878'
                WHERE ordernumber = 'P2502230000694' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423747'
                WHERE ordernumber = 'P2502230000702' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319115'
                WHERE ordernumber = 'P2502230000704' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113696'
                WHERE ordernumber = 'P2502230000707' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '454843'
                WHERE ordernumber = 'P2502230000712' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457836'
                WHERE ordernumber = 'P2502230000713' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242754'
                WHERE ordernumber = 'P2502230000716' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457837'
                WHERE ordernumber = 'P2502230000719' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457838'
                WHERE ordernumber = 'P2502230000723' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457839'
                WHERE ordernumber = 'P2502230000730' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300492'
                WHERE ordernumber = 'P2502230000732' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '65362'
                WHERE ordernumber = 'P2502230000734' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457346'
                WHERE ordernumber = 'P2502230000736' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457842'
                WHERE ordernumber = 'P2502230000740' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457844'
                WHERE ordernumber = 'P2502230000743' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '442770'
                WHERE ordernumber = 'P2502230000748' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381996'
                WHERE ordernumber = 'P2502230000749' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457845'
                WHERE ordernumber = 'P2502230000751' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457846'
                WHERE ordernumber = 'P2502230000765' 
            
2025-02-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457847'
                WHERE ordernumber = 'P2502230000767'