2024-12-18 01:00:01 -- 將會員中心id寫入data-lake
2024-12-18 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 '2024-12-17%';
        
2024-12-18 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '436518'
                WHERE ordernumber = 'P2412170000257' 
            
2024-12-18 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '31100'
                WHERE ordernumber = 'P2412170000367' 
            
2024-12-18 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '216569'
                WHERE ordernumber = 'P2412170000474' 
            
2024-12-18 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '436489'
                WHERE ordernumber = 'P2412170000578' 
            
2024-12-18 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '127788'
                WHERE ordernumber = 'P2412170000719' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346680'
                WHERE ordernumber = 'P2412170000819' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436521'
                WHERE ordernumber = 'P2412170000948' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213842'
                WHERE ordernumber = 'P2412170001490' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435861'
                WHERE ordernumber = 'P2412170001534' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '91363'
                WHERE ordernumber = 'P2412170001758' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229115'
                WHERE ordernumber = 'P2412170001891' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430747'
                WHERE ordernumber = 'P2412170001918' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '146510'
                WHERE ordernumber = 'P2412170002191' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436529'
                WHERE ordernumber = 'P2412170002298' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387912'
                WHERE ordernumber = 'P2412170002389' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154270'
                WHERE ordernumber = 'P2412170002483' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428021'
                WHERE ordernumber = 'P2412170002571' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167252'
                WHERE ordernumber = 'P2412170002739' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99625'
                WHERE ordernumber = 'P2412170002832' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436532'
                WHERE ordernumber = 'P2412170002969' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '265519'
                WHERE ordernumber = 'P2412170003125' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317097'
                WHERE ordernumber = 'P2412170003225' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154270'
                WHERE ordernumber = 'P2412170003435' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '1540'
                WHERE ordernumber = 'P2412170003560' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96664'
                WHERE ordernumber = 'P2412170003719' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291939'
                WHERE ordernumber = 'P2412170003893' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424027'
                WHERE ordernumber = 'P2412170004072' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97461'
                WHERE ordernumber = 'P2412170004256' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436538'
                WHERE ordernumber = 'P2412170004567' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436541'
                WHERE ordernumber = 'P2412170004737' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436544'
                WHERE ordernumber = 'P2412170004995' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232073'
                WHERE ordernumber = 'P2412170005076' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436545'
                WHERE ordernumber = 'P2412170005183' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436547'
                WHERE ordernumber = 'P2412170005380' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276908'
                WHERE ordernumber = 'P2412170006225' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284083'
                WHERE ordernumber = 'P2412170006849' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436550'
                WHERE ordernumber = 'P2412170006967' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105669'
                WHERE ordernumber = 'P2412170007362' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344253'
                WHERE ordernumber = 'P2412170007424' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436553'
                WHERE ordernumber = 'P2412170007712' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436554'
                WHERE ordernumber = 'P2412170007966' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277535'
                WHERE ordernumber = 'P2412170008081' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283876'
                WHERE ordernumber = 'P2412170008838' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121447'
                WHERE ordernumber = 'P2412170008993' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284565'
                WHERE ordernumber = 'P2412170009387' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436562'
                WHERE ordernumber = 'P2412170009559' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436560'
                WHERE ordernumber = 'P2412170009637' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436555'
                WHERE ordernumber = 'P2412170009876' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436561'
                WHERE ordernumber = 'P2412170009987' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283311'
                WHERE ordernumber = 'P2412170010038' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436566'
                WHERE ordernumber = 'P2412170010158' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '40686'
                WHERE ordernumber = 'P2412170010380' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436570'
                WHERE ordernumber = 'P2412170010664' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386388'
                WHERE ordernumber = 'P2412170010759' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386388'
                WHERE ordernumber = 'P2412170010852' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436571'
                WHERE ordernumber = 'P2412170010995' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386388'
                WHERE ordernumber = 'P2412170011119' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436570'
                WHERE ordernumber = 'P2412170011273' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99029'
                WHERE ordernumber = 'P2412170011314' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99029'
                WHERE ordernumber = 'P2412170011577' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436573'
                WHERE ordernumber = 'P2412170011711' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143048'
                WHERE ordernumber = 'P2412170011979' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436577'
                WHERE ordernumber = 'P2412170012512' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436579'
                WHERE ordernumber = 'P2412170012631' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387378'
                WHERE ordernumber = 'P2412170012719' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414268'
                WHERE ordernumber = 'P2412170012873' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433136'
                WHERE ordernumber = 'P2412170013086' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436584'
                WHERE ordernumber = 'P2412170013142' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '322480'
                WHERE ordernumber = 'P2412170013372' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436588'
                WHERE ordernumber = 'P2412170013473' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393929'
                WHERE ordernumber = 'P2412170013553' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436593'
                WHERE ordernumber = 'P2412170013661' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389353'
                WHERE ordernumber = 'P2412170013850' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293682'
                WHERE ordernumber = 'P2412170014173' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81316'
                WHERE ordernumber = 'P2412170014227' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '333790'
                WHERE ordernumber = 'P2412170014359' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369900'
                WHERE ordernumber = 'P2412170014541' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '25228'
                WHERE ordernumber = 'P2412170014632' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436601'
                WHERE ordernumber = 'P2412170014791' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366861'
                WHERE ordernumber = 'P2412170014857' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366861'
                WHERE ordernumber = 'P2412170014955' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348408'
                WHERE ordernumber = 'P2412170015146' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288822'
                WHERE ordernumber = 'P2412170016023' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217152'
                WHERE ordernumber = 'P2412170016176' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436604'
                WHERE ordernumber = 'P2412170016291' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273445'
                WHERE ordernumber = 'P2412170016885' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '256273'
                WHERE ordernumber = 'P2412170016911' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112548'
                WHERE ordernumber = 'P2412170017075' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434555'
                WHERE ordernumber = 'P2412170017218' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375337'
                WHERE ordernumber = 'P2412170017483' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436608'
                WHERE ordernumber = 'P2412170017568' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436608'
                WHERE ordernumber = 'P2412170017645' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436607'
                WHERE ordernumber = 'P2412170018023' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352417'
                WHERE ordernumber = 'P2412170018190' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239181'
                WHERE ordernumber = 'P2412170018316' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436617'
                WHERE ordernumber = 'P2412170018767' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P2412170018888' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436585'
                WHERE ordernumber = 'P2412170019019' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383212'
                WHERE ordernumber = 'P2412170019257' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433378'
                WHERE ordernumber = 'P2412170019312' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P2412170019595' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308889'
                WHERE ordernumber = 'P2412170019693' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347462'
                WHERE ordernumber = 'P2412170019893' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281356'
                WHERE ordernumber = 'P2412170019994' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99566'
                WHERE ordernumber = 'P2412170020128' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261980'
                WHERE ordernumber = 'P2412170020482' 
            
2024-12-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261980'
                WHERE ordernumber = 'P2412170020558' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436626'
                WHERE ordernumber = 'P2412170020729' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260423'
                WHERE ordernumber = 'P2412170020884' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436628'
                WHERE ordernumber = 'P2412170020955' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436630'
                WHERE ordernumber = 'P2412170021039' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226533'
                WHERE ordernumber = 'P2412170021346' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105914'
                WHERE ordernumber = 'P2412170021410' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237571'
                WHERE ordernumber = 'P2412170021549' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436635'
                WHERE ordernumber = 'P2412170021750' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436634'
                WHERE ordernumber = 'P2412170021837' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436637'
                WHERE ordernumber = 'P2412170021987' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385092'
                WHERE ordernumber = 'P2412170022089' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418390'
                WHERE ordernumber = 'P2412170022256' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117898'
                WHERE ordernumber = 'P2412170022950' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93786'
                WHERE ordernumber = 'P2412170023177' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227579'
                WHERE ordernumber = 'P2412170023575' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158951'
                WHERE ordernumber = 'P2412170023751' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128131'
                WHERE ordernumber = 'P2412170023946' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408943'
                WHERE ordernumber = 'P2412170024018' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436646'
                WHERE ordernumber = 'P2412170024684' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267164'
                WHERE ordernumber = 'P2412170024790' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211017'
                WHERE ordernumber = 'P2412170025782' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392888'
                WHERE ordernumber = 'P2412170025960' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434134'
                WHERE ordernumber = 'P2412170026416' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436648'
                WHERE ordernumber = 'P2412170026443' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434134'
                WHERE ordernumber = 'P2412170026682' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P2412170026810' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138088'
                WHERE ordernumber = 'P2412170027215' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377483'
                WHERE ordernumber = 'P2412170027375' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81074'
                WHERE ordernumber = 'P2412170027598' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436658'
                WHERE ordernumber = 'P2412170027817' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436659'
                WHERE ordernumber = 'P2412170028070' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162020'
                WHERE ordernumber = 'P2412170028620' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284565'
                WHERE ordernumber = 'P2412170028875' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429144'
                WHERE ordernumber = 'P2412170029123' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238776'
                WHERE ordernumber = 'P2412170029388' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369832'
                WHERE ordernumber = 'P2412170029558' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436667'
                WHERE ordernumber = 'P2412170029836' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136852'
                WHERE ordernumber = 'P2412170029960' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434318'
                WHERE ordernumber = 'P2412170030047' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345247'
                WHERE ordernumber = 'P2412170030138' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436668'
                WHERE ordernumber = 'P2412170030397' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P2412170030462' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299292'
                WHERE ordernumber = 'P2412170030694' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436673'
                WHERE ordernumber = 'P2412170030782' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436669'
                WHERE ordernumber = 'P2412170031076' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399550'
                WHERE ordernumber = 'P2412170031140' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344551'
                WHERE ordernumber = 'P2412170031287' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '24223'
                WHERE ordernumber = 'P2412170031316' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344551'
                WHERE ordernumber = 'P2412170031912' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436678'
                WHERE ordernumber = 'P2412170032315' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323791'
                WHERE ordernumber = 'P2412170032872' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436685'
                WHERE ordernumber = 'P2412170032983' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436685'
                WHERE ordernumber = 'P2412170033043' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311612'
                WHERE ordernumber = 'P2412170033237' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436688'
                WHERE ordernumber = 'P2412170033395' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98634'
                WHERE ordernumber = 'P2412170033466' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436691'
                WHERE ordernumber = 'P2412170033858' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436692'
                WHERE ordernumber = 'P2412170033920' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436692'
                WHERE ordernumber = 'P2412170034020' 
            
2024-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237775'
                WHERE ordernumber = 'P2412170034127'