2025-01-03 01:00:01 -- 將會員中心id寫入data-lake
2025-01-03 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-01-02%';
        
2025-01-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '377399'
                WHERE ordernumber = 'P2501020000015' 
            
2025-01-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '377399'
                WHERE ordernumber = 'P2501020000017' 
            
2025-01-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '363151'
                WHERE ordernumber = 'P2501020000020' 
            
2025-01-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '442770'
                WHERE ordernumber = 'P2501020000021' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393615'
                WHERE ordernumber = 'P2501020000023' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442772'
                WHERE ordernumber = 'P2501020000024' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363151'
                WHERE ordernumber = 'P2501020000026' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2501020000025' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442773'
                WHERE ordernumber = 'P2501020000027' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431719'
                WHERE ordernumber = 'P2501020000029' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '119332'
                WHERE ordernumber = 'P2501020000031' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442775'
                WHERE ordernumber = 'P2501020000033' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235055'
                WHERE ordernumber = 'P2501020000035' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '333795'
                WHERE ordernumber = 'P2501020000041' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '134579'
                WHERE ordernumber = 'P2501020000043' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435420'
                WHERE ordernumber = 'P2501020000045' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '43704'
                WHERE ordernumber = 'P2501020000048' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368589'
                WHERE ordernumber = 'P2501020000050' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442788'
                WHERE ordernumber = 'P2501020000051' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442787'
                WHERE ordernumber = 'P2501020000052' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442792'
                WHERE ordernumber = 'P2501020000054' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128279'
                WHERE ordernumber = 'P2501020000057' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344102'
                WHERE ordernumber = 'P2501020000060' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442794'
                WHERE ordernumber = 'P2501020000062' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442796'
                WHERE ordernumber = 'P2501020000063' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P2501020000066' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97539'
                WHERE ordernumber = 'P2501020000070' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97539'
                WHERE ordernumber = 'P2501020000071' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97539'
                WHERE ordernumber = 'P2501020000072' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97539'
                WHERE ordernumber = 'P2501020000073' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97539'
                WHERE ordernumber = 'P2501020000074' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442801'
                WHERE ordernumber = 'P2501020000079' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442805'
                WHERE ordernumber = 'P2501020000080' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442804'
                WHERE ordernumber = 'P2501020000081' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419484'
                WHERE ordernumber = 'P2501020000088' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104898'
                WHERE ordernumber = 'P2501020000089' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278288'
                WHERE ordernumber = 'P2501020000094' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442812'
                WHERE ordernumber = 'P2501020000097' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442813'
                WHERE ordernumber = 'P2501020000100' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442816'
                WHERE ordernumber = 'P2501020000106' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442817'
                WHERE ordernumber = 'P2501020000107' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442820'
                WHERE ordernumber = 'P2501020000111' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335758'
                WHERE ordernumber = 'P2501020000112' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439838'
                WHERE ordernumber = 'P2501020000113' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439838'
                WHERE ordernumber = 'P2501020000114' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442821'
                WHERE ordernumber = 'P2501020000115' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442822'
                WHERE ordernumber = 'P2501020000116' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442823'
                WHERE ordernumber = 'P2501020000121' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238267'
                WHERE ordernumber = 'P2501020000123' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442826'
                WHERE ordernumber = 'P2501020000124' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277334'
                WHERE ordernumber = 'P2501020000126' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442828'
                WHERE ordernumber = 'P2501020000127' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438051'
                WHERE ordernumber = 'P2501020000130' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318891'
                WHERE ordernumber = 'P2501020000132' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442827'
                WHERE ordernumber = 'P2501020000134' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '63197'
                WHERE ordernumber = 'P2501020000135' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '91241'
                WHERE ordernumber = 'P2501020000142' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334456'
                WHERE ordernumber = 'P2501020000145' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '91241'
                WHERE ordernumber = 'P2501020000147' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442835'
                WHERE ordernumber = 'P2501020000149' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296795'
                WHERE ordernumber = 'P2501020000155' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328860'
                WHERE ordernumber = 'P2501020000160' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '27325'
                WHERE ordernumber = 'P2501020000161' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93395'
                WHERE ordernumber = 'P2501020000162' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442839'
                WHERE ordernumber = 'P2501020000163' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99786'
                WHERE ordernumber = 'P2501020000169' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442767'
                WHERE ordernumber = 'P2501020000176' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '148305'
                WHERE ordernumber = 'P2501020000178' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '69825'
                WHERE ordernumber = 'P2501020000181' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442856'
                WHERE ordernumber = 'P2501020000188' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442858'
                WHERE ordernumber = 'P2501020000189' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439277'
                WHERE ordernumber = 'P2501020000191' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220080'
                WHERE ordernumber = 'P2501020000192' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442860'
                WHERE ordernumber = 'P2501020000193' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '163978'
                WHERE ordernumber = 'P2501020000194' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442861'
                WHERE ordernumber = 'P2501020000195' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438199'
                WHERE ordernumber = 'P2501020000196' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442862'
                WHERE ordernumber = 'P2501020000199' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '120580'
                WHERE ordernumber = 'P2501020000201' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342271'
                WHERE ordernumber = 'P2501020000203' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375683'
                WHERE ordernumber = 'P2501020000204' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359735'
                WHERE ordernumber = 'P2501020000205' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '88929'
                WHERE ordernumber = 'P2501020000207' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344546'
                WHERE ordernumber = 'P2501020000208' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442870'
                WHERE ordernumber = 'P2501020000209' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304988'
                WHERE ordernumber = 'P2501020000210' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287470'
                WHERE ordernumber = 'P2501020000212' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437154'
                WHERE ordernumber = 'P2501020000214' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216512'
                WHERE ordernumber = 'P2501020000215' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442876'
                WHERE ordernumber = 'P2501020000219' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442877'
                WHERE ordernumber = 'P2501020000223' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442878'
                WHERE ordernumber = 'P2501020000224' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393340'
                WHERE ordernumber = 'P2501020000225' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167816'
                WHERE ordernumber = 'P2501020000228' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434564'
                WHERE ordernumber = 'P2501020000230' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437783'
                WHERE ordernumber = 'P2501020000233' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442884'
                WHERE ordernumber = 'P2501020000239' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442879'
                WHERE ordernumber = 'P2501020000243' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433120'
                WHERE ordernumber = 'P2501020000247' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442888'
                WHERE ordernumber = 'P2501020000248' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442889'
                WHERE ordernumber = 'P2501020000249' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442891'
                WHERE ordernumber = 'P2501020000255' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216995'
                WHERE ordernumber = 'P2501020000257' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431485'
                WHERE ordernumber = 'P2501020000258' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272489'
                WHERE ordernumber = 'P2501020000259' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223893'
                WHERE ordernumber = 'P2501020000260' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384078'
                WHERE ordernumber = 'P2501020000263' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222505'
                WHERE ordernumber = 'P2501020000266' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '442896'
                WHERE ordernumber = 'P2501020000273' 
            
2025-01-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '152123'
                WHERE ordernumber = 'P2501020000275' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286022'
                WHERE ordernumber = 'P2501020000276' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442898'
                WHERE ordernumber = 'P2501020000277' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393274'
                WHERE ordernumber = 'P2501020000279' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442899'
                WHERE ordernumber = 'P2501020000280' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442903'
                WHERE ordernumber = 'P2501020000284' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442903'
                WHERE ordernumber = 'P2501020000286' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415160'
                WHERE ordernumber = 'P2501020000287' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441883'
                WHERE ordernumber = 'P2501020000289' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442907'
                WHERE ordernumber = 'P2501020000290' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80905'
                WHERE ordernumber = 'P2501020000292' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442900'
                WHERE ordernumber = 'P2501020000294' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385092'
                WHERE ordernumber = 'P2501020000297' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442907'
                WHERE ordernumber = 'P2501020000298' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442443'
                WHERE ordernumber = 'P2501020000299' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442908'
                WHERE ordernumber = 'P2501020000301' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442910'
                WHERE ordernumber = 'P2501020000303' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442912'
                WHERE ordernumber = 'P2501020000304' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380654'
                WHERE ordernumber = 'P2501020000305' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146104'
                WHERE ordernumber = 'P2501020000308' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442918'
                WHERE ordernumber = 'P2501020000314' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223075'
                WHERE ordernumber = 'P2501020000315' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442919'
                WHERE ordernumber = 'P2501020000316' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223075'
                WHERE ordernumber = 'P2501020000319' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442921'
                WHERE ordernumber = 'P2501020000321' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442923'
                WHERE ordernumber = 'P2501020000326' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442925'
                WHERE ordernumber = 'P2501020000328' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274078'
                WHERE ordernumber = 'P2501020000330' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442928'
                WHERE ordernumber = 'P2501020000333' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442929'
                WHERE ordernumber = 'P2501020000335' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442929'
                WHERE ordernumber = 'P2501020000337' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '203673'
                WHERE ordernumber = 'P2501020000338' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '203673'
                WHERE ordernumber = 'P2501020000339' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431055'
                WHERE ordernumber = 'P2501020000341' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260383'
                WHERE ordernumber = 'P2501020000344' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442931'
                WHERE ordernumber = 'P2501020000346' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171098'
                WHERE ordernumber = 'P2501020000347' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405313'
                WHERE ordernumber = 'P2501020000351' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442937'
                WHERE ordernumber = 'P2501020000352' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430749'
                WHERE ordernumber = 'P2501020000355' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442940'
                WHERE ordernumber = 'P2501020000357' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85910'
                WHERE ordernumber = 'P2501020000358' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426291'
                WHERE ordernumber = 'P2501020000362' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282921'
                WHERE ordernumber = 'P2501020000370' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282418'
                WHERE ordernumber = 'P2501020000373' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418745'
                WHERE ordernumber = 'P2501020000375' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100292'
                WHERE ordernumber = 'P2501020000376' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442952'
                WHERE ordernumber = 'P2501020000377' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442953'
                WHERE ordernumber = 'P2501020000378' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280655'
                WHERE ordernumber = 'P2501020000382' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424526'
                WHERE ordernumber = 'P2501020000383' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440288'
                WHERE ordernumber = 'P2501020000386' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442958'
                WHERE ordernumber = 'P2501020000389' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129398'
                WHERE ordernumber = 'P2501020000398' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390626'
                WHERE ordernumber = 'P2501020000399' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326301'
                WHERE ordernumber = 'P2501020000401' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442966'
                WHERE ordernumber = 'P2501020000402' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129398'
                WHERE ordernumber = 'P2501020000403' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281574'
                WHERE ordernumber = 'P2501020000407' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442968'
                WHERE ordernumber = 'P2501020000409' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379635'
                WHERE ordernumber = 'P2501020000410' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '187767'
                WHERE ordernumber = 'P2501020000412' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142049'
                WHERE ordernumber = 'P2501020000413' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '187767'
                WHERE ordernumber = 'P2501020000414' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442973'
                WHERE ordernumber = 'P2501020000420' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374206'
                WHERE ordernumber = 'P2501020000423' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287386'
                WHERE ordernumber = 'P2501020000432' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435137'
                WHERE ordernumber = 'P2501020000434' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424235'
                WHERE ordernumber = 'P2501020000435' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381398'
                WHERE ordernumber = 'P2501020000439' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442980'
                WHERE ordernumber = 'P2501020000443' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442981'
                WHERE ordernumber = 'P2501020000445' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442985'
                WHERE ordernumber = 'P2501020000449' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442984'
                WHERE ordernumber = 'P2501020000450' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442988'
                WHERE ordernumber = 'P2501020000452' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41587'
                WHERE ordernumber = 'P2501020000454' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41587'
                WHERE ordernumber = 'P2501020000455' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442990'
                WHERE ordernumber = 'P2501020000458' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442151'
                WHERE ordernumber = 'P2501020000459' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432670'
                WHERE ordernumber = 'P2501020000463' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312065'
                WHERE ordernumber = 'P2501020000464' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442992'
                WHERE ordernumber = 'P2501020000470' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266092'
                WHERE ordernumber = 'P2501020000481' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350054'
                WHERE ordernumber = 'P2501020000484' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442996'
                WHERE ordernumber = 'P2501020000494' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442998'
                WHERE ordernumber = 'P2501020000497' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442999'
                WHERE ordernumber = 'P2501020000498' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '441847'
                WHERE ordernumber = 'P2501020000500' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443002'
                WHERE ordernumber = 'P2501020000501' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343230'
                WHERE ordernumber = 'P2501020000507' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430749'
                WHERE ordernumber = 'P2501020000510' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238530'
                WHERE ordernumber = 'P2501020000513' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220663'
                WHERE ordernumber = 'P2501020000514' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '21841'
                WHERE ordernumber = 'P2501020000516' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443006'
                WHERE ordernumber = 'P2501020000517' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241851'
                WHERE ordernumber = 'P2501020000519' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112941'
                WHERE ordernumber = 'P2501020000522' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400781'
                WHERE ordernumber = 'P2501020000526' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443008'
                WHERE ordernumber = 'P2501020000527' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429064'
                WHERE ordernumber = 'P2501020000528' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236925'
                WHERE ordernumber = 'P2501020000529' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443014'
                WHERE ordernumber = 'P2501020000530' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443015'
                WHERE ordernumber = 'P2501020000531' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347683'
                WHERE ordernumber = 'P2501020000533' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443018'
                WHERE ordernumber = 'P2501020000534' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443017'
                WHERE ordernumber = 'P2501020000535' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245039'
                WHERE ordernumber = 'P2501020000536' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289404'
                WHERE ordernumber = 'P2501020000537' 
            
2025-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431989'
                WHERE ordernumber = 'P2501020000541' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438139'
                WHERE ordernumber = 'P2501020000542' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443009'
                WHERE ordernumber = 'P2501020000544' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443009'
                WHERE ordernumber = 'P2501020000545' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443023'
                WHERE ordernumber = 'P2501020000553' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '43704'
                WHERE ordernumber = 'P2501020000557' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223864'
                WHERE ordernumber = 'P2501020000561' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353789'
                WHERE ordernumber = 'P2501020000564' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443032'
                WHERE ordernumber = 'P2501020000566' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229626'
                WHERE ordernumber = 'P2501020000569' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368901'
                WHERE ordernumber = 'P2501020000571' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443041'
                WHERE ordernumber = 'P2501020000574' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421005'
                WHERE ordernumber = 'P2501020000579' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302243'
                WHERE ordernumber = 'P2501020000584' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439909'
                WHERE ordernumber = 'P2501020000587' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439909'
                WHERE ordernumber = 'P2501020000593' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '441019'
                WHERE ordernumber = 'P2501020000595' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442926'
                WHERE ordernumber = 'P2501020000598' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285981'
                WHERE ordernumber = 'P2501020000599' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296980'
                WHERE ordernumber = 'P2501020000600' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255201'
                WHERE ordernumber = 'P2501020000601' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443045'
                WHERE ordernumber = 'P2501020000602' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443046'
                WHERE ordernumber = 'P2501020000603' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443048'
                WHERE ordernumber = 'P2501020000610' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443050'
                WHERE ordernumber = 'P2501020000612' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443048'
                WHERE ordernumber = 'P2501020000613' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329804'
                WHERE ordernumber = 'P2501020000624' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329804'
                WHERE ordernumber = 'P2501020000628' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443055'
                WHERE ordernumber = 'P2501020000631' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443055'
                WHERE ordernumber = 'P2501020000632' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443054'
                WHERE ordernumber = 'P2501020000634' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414263'
                WHERE ordernumber = 'P2501020000635' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339987'
                WHERE ordernumber = 'P2501020000637' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443060'
                WHERE ordernumber = 'P2501020000638' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244763'
                WHERE ordernumber = 'P2501020000640' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234036'
                WHERE ordernumber = 'P2501020000641' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304111'
                WHERE ordernumber = 'P2501020000644' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443067'
                WHERE ordernumber = 'P2501020000648' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291475'
                WHERE ordernumber = 'P2501020000649' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443069'
                WHERE ordernumber = 'P2501020000653' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269470'
                WHERE ordernumber = 'P2501020000654' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443071'
                WHERE ordernumber = 'P2501020000657' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424068'
                WHERE ordernumber = 'P2501020000660' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424068'
                WHERE ordernumber = 'P2501020000662' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429317'
                WHERE ordernumber = 'P2501020000663' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443057'
                WHERE ordernumber = 'P2501020000664' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304111'
                WHERE ordernumber = 'P2501020000665' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224149'
                WHERE ordernumber = 'P2501020000667' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443078'
                WHERE ordernumber = 'P2501020000673' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443080'
                WHERE ordernumber = 'P2501020000677' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287678'
                WHERE ordernumber = 'P2501020000678' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443081'
                WHERE ordernumber = 'P2501020000679' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256554'
                WHERE ordernumber = 'P2501020000682' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443086'
                WHERE ordernumber = 'P2501020000683' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266868'
                WHERE ordernumber = 'P2501020000689' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99718'
                WHERE ordernumber = 'P2501020000698' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321364'
                WHERE ordernumber = 'P2501020000699' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284699'
                WHERE ordernumber = 'P2501020000701' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443099'
                WHERE ordernumber = 'P2501020000702' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284699'
                WHERE ordernumber = 'P2501020000703' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443100'
                WHERE ordernumber = 'P2501020000704' 
            
2025-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249708'
                WHERE ordernumber = 'P2501020000705'