2024-12-27 01:00:02 -- 將會員中心id寫入data-lake
2024-12-27 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-12-26%';
        
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261096'
                WHERE ordernumber = 'P2412260000011' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261096'
                WHERE ordernumber = 'P2412260000015' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269132'
                WHERE ordernumber = 'P2412260000017' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430715'
                WHERE ordernumber = 'P2412260000019' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439622'
                WHERE ordernumber = 'P2412260000021' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439623'
                WHERE ordernumber = 'P2412260000022' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420555'
                WHERE ordernumber = 'P2412260000026' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433737'
                WHERE ordernumber = 'P2412260000028' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '267583'
                WHERE ordernumber = 'P2412260000029' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401994'
                WHERE ordernumber = 'P2412260000030' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439626'
                WHERE ordernumber = 'P2412260000032' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '147331'
                WHERE ordernumber = 'P2412260000033' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420555'
                WHERE ordernumber = 'P2412260000035' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439628'
                WHERE ordernumber = 'P2412260000038' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439631'
                WHERE ordernumber = 'P2412260000042' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439633'
                WHERE ordernumber = 'P2412260000047' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2412260000048' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420409'
                WHERE ordernumber = 'P2412260000053' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439635'
                WHERE ordernumber = 'P2412260000057' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238188'
                WHERE ordernumber = 'P2412260000059' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439640'
                WHERE ordernumber = 'P2412260000061' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '169018'
                WHERE ordernumber = 'P2412260000062' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96382'
                WHERE ordernumber = 'P2412260000069' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438619'
                WHERE ordernumber = 'P2412260000070' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439644'
                WHERE ordernumber = 'P2412260000071' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433738'
                WHERE ordernumber = 'P2412260000072' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439059'
                WHERE ordernumber = 'P2412260000073' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '169018'
                WHERE ordernumber = 'P2412260000075' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293883'
                WHERE ordernumber = 'P2412260000078' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326714'
                WHERE ordernumber = 'P2412260000080' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99845'
                WHERE ordernumber = 'P2412260000081' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381089'
                WHERE ordernumber = 'P2412260000083' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439649'
                WHERE ordernumber = 'P2412260000084' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439650'
                WHERE ordernumber = 'P2412260000085' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336546'
                WHERE ordernumber = 'P2412260000086' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293529'
                WHERE ordernumber = 'P2412260000089' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275564'
                WHERE ordernumber = 'P2412260000090' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431853'
                WHERE ordernumber = 'P2412260000091' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439643'
                WHERE ordernumber = 'P2412260000094' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439658'
                WHERE ordernumber = 'P2412260000099' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439657'
                WHERE ordernumber = 'P2412260000100' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434092'
                WHERE ordernumber = 'P2412260000101' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355166'
                WHERE ordernumber = 'P2412260000102' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439659'
                WHERE ordernumber = 'P2412260000103' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439660'
                WHERE ordernumber = 'P2412260000107' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438721'
                WHERE ordernumber = 'P2412260000108' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253902'
                WHERE ordernumber = 'P2412260000111' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390980'
                WHERE ordernumber = 'P2412260000112' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105430'
                WHERE ordernumber = 'P2412260000117' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439665'
                WHERE ordernumber = 'P2412260000126' 
            
2024-12-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222335'
                WHERE ordernumber = 'P2412260000130' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88195'
                WHERE ordernumber = 'P2412260000131' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251957'
                WHERE ordernumber = 'P2412260000132' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291738'
                WHERE ordernumber = 'P2412260000136' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313067'
                WHERE ordernumber = 'P2412260000138' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223674'
                WHERE ordernumber = 'P2412260000139' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295679'
                WHERE ordernumber = 'P2412260000141' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439667'
                WHERE ordernumber = 'P2412260000143' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309301'
                WHERE ordernumber = 'P2412260000147' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439670'
                WHERE ordernumber = 'P2412260000148' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439674'
                WHERE ordernumber = 'P2412260000149' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439672'
                WHERE ordernumber = 'P2412260000150' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259538'
                WHERE ordernumber = 'P2412260000151' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295679'
                WHERE ordernumber = 'P2412260000152' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347659'
                WHERE ordernumber = 'P2412260000153' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408675'
                WHERE ordernumber = 'P2412260000155' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153595'
                WHERE ordernumber = 'P2412260000163' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274905'
                WHERE ordernumber = 'P2412260000165' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439679'
                WHERE ordernumber = 'P2412260000172' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336711'
                WHERE ordernumber = 'P2412260000173' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336711'
                WHERE ordernumber = 'P2412260000174' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439682'
                WHERE ordernumber = 'P2412260000175' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '3749'
                WHERE ordernumber = 'P2412260000182' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382014'
                WHERE ordernumber = 'P2412260000184' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425878'
                WHERE ordernumber = 'P2412260000185' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438307'
                WHERE ordernumber = 'P2412260000186' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438307'
                WHERE ordernumber = 'P2412260000187' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439690'
                WHERE ordernumber = 'P2412260000189' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227301'
                WHERE ordernumber = 'P2412260000191' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '3749'
                WHERE ordernumber = 'P2412260000194' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258822'
                WHERE ordernumber = 'P2412260000201' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258822'
                WHERE ordernumber = 'P2412260000203' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397978'
                WHERE ordernumber = 'P2412260000207' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127420'
                WHERE ordernumber = 'P2412260000215' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439692'
                WHERE ordernumber = 'P2412260000218' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P2412260000220' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293837'
                WHERE ordernumber = 'P2412260000222' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297438'
                WHERE ordernumber = 'P2412260000226' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439697'
                WHERE ordernumber = 'P2412260000229' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '40950'
                WHERE ordernumber = 'P2412260000233' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432415'
                WHERE ordernumber = 'P2412260000235' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439699'
                WHERE ordernumber = 'P2412260000237' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381612'
                WHERE ordernumber = 'P2412260000249' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262046'
                WHERE ordernumber = 'P2412260000252' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439705'
                WHERE ordernumber = 'P2412260000258' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435704'
                WHERE ordernumber = 'P2412260000261' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209574'
                WHERE ordernumber = 'P2412260000262' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435990'
                WHERE ordernumber = 'P2412260000263' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283168'
                WHERE ordernumber = 'P2412260000265' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286959'
                WHERE ordernumber = 'P2412260000267' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374291'
                WHERE ordernumber = 'P2412260000269' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437166'
                WHERE ordernumber = 'P2412260000270' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374291'
                WHERE ordernumber = 'P2412260000272' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439706'
                WHERE ordernumber = 'P2412260000277' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431986'
                WHERE ordernumber = 'P2412260000281' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437441'
                WHERE ordernumber = 'P2412260000292' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439709'
                WHERE ordernumber = 'P2412260000293' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381367'
                WHERE ordernumber = 'P2412260000294' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439711'
                WHERE ordernumber = 'P2412260000296' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439714'
                WHERE ordernumber = 'P2412260000297' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439716'
                WHERE ordernumber = 'P2412260000302' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439719'
                WHERE ordernumber = 'P2412260000312' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439721'
                WHERE ordernumber = 'P2412260000314' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346680'
                WHERE ordernumber = 'P2412260000315' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '148024'
                WHERE ordernumber = 'P2412260000318' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357914'
                WHERE ordernumber = 'P2412260000319' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439722'
                WHERE ordernumber = 'P2412260000322' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422235'
                WHERE ordernumber = 'P2412260000328' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439725'
                WHERE ordernumber = 'P2412260000333' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438849'
                WHERE ordernumber = 'P2412260000343' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439727'
                WHERE ordernumber = 'P2412260000345' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439728'
                WHERE ordernumber = 'P2412260000346' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157069'
                WHERE ordernumber = 'P2412260000349' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427026'
                WHERE ordernumber = 'P2412260000350' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439735'
                WHERE ordernumber = 'P2412260000353' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352835'
                WHERE ordernumber = 'P2412260000355' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380967'
                WHERE ordernumber = 'P2412260000360' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439735'
                WHERE ordernumber = 'P2412260000362' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404300'
                WHERE ordernumber = 'P2412260000363' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439736'
                WHERE ordernumber = 'P2412260000364' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439738'
                WHERE ordernumber = 'P2412260000367' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439247'
                WHERE ordernumber = 'P2412260000369' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338812'
                WHERE ordernumber = 'P2412260000371' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352563'
                WHERE ordernumber = 'P2412260000373' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439741'
                WHERE ordernumber = 'P2412260000378' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P2412260000381' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439742'
                WHERE ordernumber = 'P2412260000383' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439743'
                WHERE ordernumber = 'P2412260000384' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439744'
                WHERE ordernumber = 'P2412260000386' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439745'
                WHERE ordernumber = 'P2412260000387' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245310'
                WHERE ordernumber = 'P2412260000390' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300227'
                WHERE ordernumber = 'P2412260000394' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369394'
                WHERE ordernumber = 'P2412260000396' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439748'
                WHERE ordernumber = 'P2412260000398' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372860'
                WHERE ordernumber = 'P2412260000402' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286502'
                WHERE ordernumber = 'P2412260000406' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433010'
                WHERE ordernumber = 'P2412260000410' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439754'
                WHERE ordernumber = 'P2412260000412' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429886'
                WHERE ordernumber = 'P2412260000413' 
            
2024-12-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406353'
                WHERE ordernumber = 'P2412260000420' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246453'
                WHERE ordernumber = 'P2412260000423' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439759'
                WHERE ordernumber = 'P2412260000425' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439761'
                WHERE ordernumber = 'P2412260000428' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217463'
                WHERE ordernumber = 'P2412260000429' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434579'
                WHERE ordernumber = 'P2412260000432' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439762'
                WHERE ordernumber = 'P2412260000433' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439763'
                WHERE ordernumber = 'P2412260000435' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439764'
                WHERE ordernumber = 'P2412260000436' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426958'
                WHERE ordernumber = 'P2412260000437' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236420'
                WHERE ordernumber = 'P2412260000440' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439572'
                WHERE ordernumber = 'P2412260000443' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439766'
                WHERE ordernumber = 'P2412260000452' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266054'
                WHERE ordernumber = 'P2412260000453' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439769'
                WHERE ordernumber = 'P2412260000454' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439772'
                WHERE ordernumber = 'P2412260000456' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439770'
                WHERE ordernumber = 'P2412260000462' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100928'
                WHERE ordernumber = 'P2412260000471' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439774'
                WHERE ordernumber = 'P2412260000476' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268471'
                WHERE ordernumber = 'P2412260000477' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347492'
                WHERE ordernumber = 'P2412260000479' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437016'
                WHERE ordernumber = 'P2412260000481' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210362'
                WHERE ordernumber = 'P2412260000482' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347444'
                WHERE ordernumber = 'P2412260000485' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432607'
                WHERE ordernumber = 'P2412260000492' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439778'
                WHERE ordernumber = 'P2412260000494' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '188917'
                WHERE ordernumber = 'P2412260000499' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164908'
                WHERE ordernumber = 'P2412260000501' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '188917'
                WHERE ordernumber = 'P2412260000502' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280451'
                WHERE ordernumber = 'P2412260000505' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400648'
                WHERE ordernumber = 'P2412260000508' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439782'
                WHERE ordernumber = 'P2412260000509' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439783'
                WHERE ordernumber = 'P2412260000510' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244831'
                WHERE ordernumber = 'P2412260000511' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244831'
                WHERE ordernumber = 'P2412260000513' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439785'
                WHERE ordernumber = 'P2412260000516' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439786'
                WHERE ordernumber = 'P2412260000517' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439784'
                WHERE ordernumber = 'P2412260000519' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394388'
                WHERE ordernumber = 'P2412260000520' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439787'
                WHERE ordernumber = 'P2412260000524' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439788'
                WHERE ordernumber = 'P2412260000528' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252044'
                WHERE ordernumber = 'P2412260000532' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439791'
                WHERE ordernumber = 'P2412260000542' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439793'
                WHERE ordernumber = 'P2412260000545' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356035'
                WHERE ordernumber = 'P2412260000553' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211590'
                WHERE ordernumber = 'P2412260000556' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302125'
                WHERE ordernumber = 'P2412260000558' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398072'
                WHERE ordernumber = 'P2412260000559' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221647'
                WHERE ordernumber = 'P2412260000560' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437229'
                WHERE ordernumber = 'P2412260000561' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76607'
                WHERE ordernumber = 'P2412260000562' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439796'
                WHERE ordernumber = 'P2412260000564' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439798'
                WHERE ordernumber = 'P2412260000566' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274699'
                WHERE ordernumber = 'P2412260000569' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439801'
                WHERE ordernumber = 'P2412260000578' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380095'
                WHERE ordernumber = 'P2412260000580' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439803'
                WHERE ordernumber = 'P2412260000583' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439805'
                WHERE ordernumber = 'P2412260000584' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308245'
                WHERE ordernumber = 'P2412260000590' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376383'
                WHERE ordernumber = 'P2412260000597' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439811'
                WHERE ordernumber = 'P2412260000602' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383183'
                WHERE ordernumber = 'P2412260000607' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87593'
                WHERE ordernumber = 'P2412260000609' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439814'
                WHERE ordernumber = 'P2412260000612' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439816'
                WHERE ordernumber = 'P2412260000622' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439817'
                WHERE ordernumber = 'P2412260000623' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439819'
                WHERE ordernumber = 'P2412260000626' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439820'
                WHERE ordernumber = 'P2412260000625' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220482'
                WHERE ordernumber = 'P2412260000627' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96799'
                WHERE ordernumber = 'P2412260000636' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439823'
                WHERE ordernumber = 'P2412260000639' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395851'
                WHERE ordernumber = 'P2412260000643' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439822'
                WHERE ordernumber = 'P2412260000648' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429864'
                WHERE ordernumber = 'P2412260000651' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439828'
                WHERE ordernumber = 'P2412260000652' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439827'
                WHERE ordernumber = 'P2412260000653' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101604'
                WHERE ordernumber = 'P2412260000658' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357646'
                WHERE ordernumber = 'P2412260000659' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '1296'
                WHERE ordernumber = 'P2412260000665' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439831'
                WHERE ordernumber = 'P2412260000666' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313872'
                WHERE ordernumber = 'P2412260000671' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439832'
                WHERE ordernumber = 'P2412260000672' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247765'
                WHERE ordernumber = 'P2412260000673' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378003'
                WHERE ordernumber = 'P2412260000676' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439835'
                WHERE ordernumber = 'P2412260000678' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317600'
                WHERE ordernumber = 'P2412260000679' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '53871'
                WHERE ordernumber = 'P2412260000680' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439837'
                WHERE ordernumber = 'P2412260000684' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387244'
                WHERE ordernumber = 'P2412260000685' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439836'
                WHERE ordernumber = 'P2412260000688' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213453'
                WHERE ordernumber = 'P2412260000689' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439839'
                WHERE ordernumber = 'P2412260000690' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137127'
                WHERE ordernumber = 'P2412260000691' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298460'
                WHERE ordernumber = 'P2412260000692' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426426'
                WHERE ordernumber = 'P2412260000696' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257815'
                WHERE ordernumber = 'P2412260000697' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439845'
                WHERE ordernumber = 'P2412260000706' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439849'
                WHERE ordernumber = 'P2412260000715' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436627'
                WHERE ordernumber = 'P2412260000720' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439853'
                WHERE ordernumber = 'P2412260000722' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241726'
                WHERE ordernumber = 'P2412260000726' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252566'
                WHERE ordernumber = 'P2412260000728' 
            
2024-12-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351020'
                WHERE ordernumber = 'P2412260000730' 
            
2024-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439855'
                WHERE ordernumber = 'P2412260000736' 
            
2024-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358899'
                WHERE ordernumber = 'P2412260000738' 
            
2024-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439856'
                WHERE ordernumber = 'P2412260000741' 
            
2024-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422563'
                WHERE ordernumber = 'P2412260000748' 
            
2024-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '115648'
                WHERE ordernumber = 'P2412260000750' 
            
2024-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P2412260000751' 
            
2024-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98874'
                WHERE ordernumber = 'P2412260000762' 
            
2024-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439865'
                WHERE ordernumber = 'P2412260000767' 
            
2024-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277179'
                WHERE ordernumber = 'P2412260000769' 
            
2024-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '321732'
                WHERE ordernumber = 'P2412260000773' 
            
2024-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '253045'
                WHERE ordernumber = 'P2412260000777' 
            
2024-12-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249522'
                WHERE ordernumber = 'P2412260000788'