2024-11-15 01:00:02 -- 將會員中心id寫入data-lake
2024-11-15 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-11-14%';
        
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430169'
                WHERE ordernumber = 'P2411140000229' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228801'
                WHERE ordernumber = 'P2411140000362' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392765'
                WHERE ordernumber = 'P2411140000496' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430167'
                WHERE ordernumber = 'P2411140000553' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428958'
                WHERE ordernumber = 'P2411140000625' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288967'
                WHERE ordernumber = 'P2411140000799' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353408'
                WHERE ordernumber = 'P2411140000856' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430170'
                WHERE ordernumber = 'P2411140001276' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430173'
                WHERE ordernumber = 'P2411140001477' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219210'
                WHERE ordernumber = 'P2411140001562' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363267'
                WHERE ordernumber = 'P2411140001825' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420874'
                WHERE ordernumber = 'P2411140001943' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430175'
                WHERE ordernumber = 'P2411140002059' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430176'
                WHERE ordernumber = 'P2411140002323' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101905'
                WHERE ordernumber = 'P2411140002489' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347408'
                WHERE ordernumber = 'P2411140002638' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430178'
                WHERE ordernumber = 'P2411140002712' 
            
2024-11-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393292'
                WHERE ordernumber = 'P2411140002823' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274874'
                WHERE ordernumber = 'P2411140003035' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430180'
                WHERE ordernumber = 'P2411140003264' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404229'
                WHERE ordernumber = 'P2411140003421' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142066'
                WHERE ordernumber = 'P2411140003561' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430181'
                WHERE ordernumber = 'P2411140003667' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95873'
                WHERE ordernumber = 'P2411140003739' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430182'
                WHERE ordernumber = 'P2411140003947' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430183'
                WHERE ordernumber = 'P2411140004285' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429804'
                WHERE ordernumber = 'P2411140004339' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430160'
                WHERE ordernumber = 'P2411140004445' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430185'
                WHERE ordernumber = 'P2411140004575' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430177'
                WHERE ordernumber = 'P2411140004722' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342428'
                WHERE ordernumber = 'P2411140004871' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303674'
                WHERE ordernumber = 'P2411140004977' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430186'
                WHERE ordernumber = 'P2411140005041' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232299'
                WHERE ordernumber = 'P2411140005148' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430189'
                WHERE ordernumber = 'P2411140005411' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253661'
                WHERE ordernumber = 'P2411140005656' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430190'
                WHERE ordernumber = 'P2411140005797' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421309'
                WHERE ordernumber = 'P2411140005829' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421309'
                WHERE ordernumber = 'P2411140005939' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264650'
                WHERE ordernumber = 'P2411140006014' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430193'
                WHERE ordernumber = 'P2411140006135' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286100'
                WHERE ordernumber = 'P2411140006258' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430193'
                WHERE ordernumber = 'P2411140006399' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430191'
                WHERE ordernumber = 'P2411140006463' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430191'
                WHERE ordernumber = 'P2411140006563' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420128'
                WHERE ordernumber = 'P2411140006615' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430191'
                WHERE ordernumber = 'P2411140006730' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430198'
                WHERE ordernumber = 'P2411140007028' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282846'
                WHERE ordernumber = 'P2411140007184' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302505'
                WHERE ordernumber = 'P2411140007262' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P2411140007361' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430201'
                WHERE ordernumber = 'P2411140007523' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237868'
                WHERE ordernumber = 'P2411140007633' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430202'
                WHERE ordernumber = 'P2411140007796' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430206'
                WHERE ordernumber = 'P2411140007844' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430204'
                WHERE ordernumber = 'P2411140007962' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430208'
                WHERE ordernumber = 'P2411140008082' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285867'
                WHERE ordernumber = 'P2411140008117' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430207'
                WHERE ordernumber = 'P2411140008251' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430198'
                WHERE ordernumber = 'P2411140008377' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122705'
                WHERE ordernumber = 'P2411140008494' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430209'
                WHERE ordernumber = 'P2411140008558' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305593'
                WHERE ordernumber = 'P2411140008823' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427011'
                WHERE ordernumber = 'P2411140008986' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312960'
                WHERE ordernumber = 'P2411140009297' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427011'
                WHERE ordernumber = 'P2411140009371' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430211'
                WHERE ordernumber = 'P2411140009458' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430212'
                WHERE ordernumber = 'P2411140009916' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430213'
                WHERE ordernumber = 'P2411140010151' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429943'
                WHERE ordernumber = 'P2411140010269' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282839'
                WHERE ordernumber = 'P2411140010551' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313776'
                WHERE ordernumber = 'P2411140010778' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430217'
                WHERE ordernumber = 'P2411140010824' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380097'
                WHERE ordernumber = 'P2411140011044' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430223'
                WHERE ordernumber = 'P2411140011427' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430222'
                WHERE ordernumber = 'P2411140011612' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289178'
                WHERE ordernumber = 'P2411140011725' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347513'
                WHERE ordernumber = 'P2411140012058' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102081'
                WHERE ordernumber = 'P2411140012254' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430225'
                WHERE ordernumber = 'P2411140012321' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100500'
                WHERE ordernumber = 'P2411140012499' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286411'
                WHERE ordernumber = 'P2411140012643' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430228'
                WHERE ordernumber = 'P2411140013590' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344582'
                WHERE ordernumber = 'P2411140013636' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430229'
                WHERE ordernumber = 'P2411140013761' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430227'
                WHERE ordernumber = 'P2411140013859' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430231'
                WHERE ordernumber = 'P2411140014046' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430230'
                WHERE ordernumber = 'P2411140014119' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430232'
                WHERE ordernumber = 'P2411140014485' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281602'
                WHERE ordernumber = 'P2411140014516' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430234'
                WHERE ordernumber = 'P2411140014652' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430236'
                WHERE ordernumber = 'P2411140014774' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430238'
                WHERE ordernumber = 'P2411140015045' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303987'
                WHERE ordernumber = 'P2411140015259' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157525'
                WHERE ordernumber = 'P2411140015436' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430239'
                WHERE ordernumber = 'P2411140015543' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430241'
                WHERE ordernumber = 'P2411140015881' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430243'
                WHERE ordernumber = 'P2411140015980' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430244'
                WHERE ordernumber = 'P2411140016062' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295570'
                WHERE ordernumber = 'P2411140016187' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412902'
                WHERE ordernumber = 'P2411140016229' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246930'
                WHERE ordernumber = 'P2411140016362' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430245'
                WHERE ordernumber = 'P2411140016516' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430246'
                WHERE ordernumber = 'P2411140016659' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430247'
                WHERE ordernumber = 'P2411140016845' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275295'
                WHERE ordernumber = 'P2411140016975' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255632'
                WHERE ordernumber = 'P2411140017061' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430248'
                WHERE ordernumber = 'P2411140017152' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279846'
                WHERE ordernumber = 'P2411140017251' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430249'
                WHERE ordernumber = 'P2411140017683' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430250'
                WHERE ordernumber = 'P2411140017779' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302188'
                WHERE ordernumber = 'P2411140018059' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266453'
                WHERE ordernumber = 'P2411140018193' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430251'
                WHERE ordernumber = 'P2411140018456' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430040'
                WHERE ordernumber = 'P2411140018672' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426487'
                WHERE ordernumber = 'P2411140018766' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381661'
                WHERE ordernumber = 'P2411140018932' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324752'
                WHERE ordernumber = 'P2411140019148' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430253'
                WHERE ordernumber = 'P2411140019256' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394860'
                WHERE ordernumber = 'P2411140019458' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430258'
                WHERE ordernumber = 'P2411140019634' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398151'
                WHERE ordernumber = 'P2411140019866' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430255'
                WHERE ordernumber = 'P2411140020118' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276877'
                WHERE ordernumber = 'P2411140020228' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398072'
                WHERE ordernumber = 'P2411140020518' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288783'
                WHERE ordernumber = 'P2411140020797' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430261'
                WHERE ordernumber = 'P2411140020876' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430260'
                WHERE ordernumber = 'P2411140020913' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99048'
                WHERE ordernumber = 'P2411140021150' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430261'
                WHERE ordernumber = 'P2411140021540' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339398'
                WHERE ordernumber = 'P2411140021738' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430263'
                WHERE ordernumber = 'P2411140021881' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276742'
                WHERE ordernumber = 'P2411140022064' 
            
2024-11-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265944'
                WHERE ordernumber = 'P2411140022113' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430264'
                WHERE ordernumber = 'P2411140022293' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383317'
                WHERE ordernumber = 'P2411140022328' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240520'
                WHERE ordernumber = 'P2411140022516' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348642'
                WHERE ordernumber = 'P2411140022623' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430265'
                WHERE ordernumber = 'P2411140022783' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293456'
                WHERE ordernumber = 'P2411140022957' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428340'
                WHERE ordernumber = 'P2411140023013' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423814'
                WHERE ordernumber = 'P2411140023153' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430267'
                WHERE ordernumber = 'P2411140023226' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430266'
                WHERE ordernumber = 'P2411140023315' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337510'
                WHERE ordernumber = 'P2411140023481' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430268'
                WHERE ordernumber = 'P2411140023537' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430269'
                WHERE ordernumber = 'P2411140023637' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275106'
                WHERE ordernumber = 'P2411140023763' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101291'
                WHERE ordernumber = 'P2411140023829' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P2411140023918' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430271'
                WHERE ordernumber = 'P2411140024177' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428983'
                WHERE ordernumber = 'P2411140024213' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428983'
                WHERE ordernumber = 'P2411140024386' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430272'
                WHERE ordernumber = 'P2411140024486' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319905'
                WHERE ordernumber = 'P2411140024589' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430274'
                WHERE ordernumber = 'P2411140024644' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228348'
                WHERE ordernumber = 'P2411140024734' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '144385'
                WHERE ordernumber = 'P2411140024867' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273186'
                WHERE ordernumber = 'P2411140024912' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289149'
                WHERE ordernumber = 'P2411140025084' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430275'
                WHERE ordernumber = 'P2411140025129' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430276'
                WHERE ordernumber = 'P2411140025374' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276117'
                WHERE ordernumber = 'P2411140025488' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430277'
                WHERE ordernumber = 'P2411140025996' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394883'
                WHERE ordernumber = 'P2411140026088' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391632'
                WHERE ordernumber = 'P2411140026380' 
            
2024-11-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82588'
                WHERE ordernumber = 'P2411140026427'