2024-03-11 01:00:02 -- 將會員中心id寫入data-lake
2024-03-11 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-03-10%';
        
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380875'
                WHERE ordernumber = 'P420310103942966' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380876'
                WHERE ordernumber = 'P420310104738541' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380877'
                WHERE ordernumber = 'P420310104959817' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380879'
                WHERE ordernumber = 'P420310105337569' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380880'
                WHERE ordernumber = 'P590310110240156' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380881'
                WHERE ordernumber = 'P180310110444271' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285577'
                WHERE ordernumber = 'P200310110456437' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285577'
                WHERE ordernumber = 'P200310110530695' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285577'
                WHERE ordernumber = 'P200310110626752' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142196'
                WHERE ordernumber = 'P200310110655582' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380882'
                WHERE ordernumber = 'P180310110938513' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337407'
                WHERE ordernumber = 'P180310111225373' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380883'
                WHERE ordernumber = 'P420310111601666' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380884'
                WHERE ordernumber = 'P180310112315341' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380885'
                WHERE ordernumber = 'P190310112359468' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379696'
                WHERE ordernumber = 'P180310112445383' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278150'
                WHERE ordernumber = 'P180310112740359' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105064'
                WHERE ordernumber = 'P180310113136716' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379562'
                WHERE ordernumber = 'P180310113346976' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380886'
                WHERE ordernumber = 'P190310113448854' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379562'
                WHERE ordernumber = 'P180310113545298' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275636'
                WHERE ordernumber = 'P200310113550919' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380485'
                WHERE ordernumber = 'P200310113939408' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106026'
                WHERE ordernumber = 'P180310114248762' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278597'
                WHERE ordernumber = 'P420310114513570' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275905'
                WHERE ordernumber = 'P420310114757126' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282921'
                WHERE ordernumber = 'P190310114811587' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380889'
                WHERE ordernumber = 'P190310115054799' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380610'
                WHERE ordernumber = 'P420310115131274' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380610'
                WHERE ordernumber = 'P420310115427766' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348901'
                WHERE ordernumber = 'P590310115430461' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367046'
                WHERE ordernumber = 'P200310115506314' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380892'
                WHERE ordernumber = 'P420310115540832' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380893'
                WHERE ordernumber = 'P420310115639528' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '323615'
                WHERE ordernumber = 'P420310115723951' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380890'
                WHERE ordernumber = 'P420310115811932' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283209'
                WHERE ordernumber = 'P180310115852984' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280346'
                WHERE ordernumber = 'P180310120225230' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380891'
                WHERE ordernumber = 'P180310120316918' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380891'
                WHERE ordernumber = 'P180310120328740' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279261'
                WHERE ordernumber = 'P420310120414131' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380894'
                WHERE ordernumber = 'P200310120756199' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '67684'
                WHERE ordernumber = 'P200310121240908' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303011'
                WHERE ordernumber = 'P200310121338970' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380895'
                WHERE ordernumber = 'P180310121614960' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287300'
                WHERE ordernumber = 'P190310122051439' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283963'
                WHERE ordernumber = 'P200310122117683' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380897'
                WHERE ordernumber = 'P420310123939694' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380898'
                WHERE ordernumber = 'P420310124131398' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '196250'
                WHERE ordernumber = 'P180310124952150' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377930'
                WHERE ordernumber = 'P190310125022233' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380900'
                WHERE ordernumber = 'P200310125051599' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380901'
                WHERE ordernumber = 'P420310125124234' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341175'
                WHERE ordernumber = 'P180310125128383' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P180310125417159' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380903'
                WHERE ordernumber = 'P420310125444313' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208688'
                WHERE ordernumber = 'P200310125642414' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274717'
                WHERE ordernumber = 'P180310125844973' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278858'
                WHERE ordernumber = 'P200310125926979' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380905'
                WHERE ordernumber = 'P420310130124553' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380907'
                WHERE ordernumber = 'P200310130319208' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237294'
                WHERE ordernumber = 'P590310130600987' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380906'
                WHERE ordernumber = 'P180310130624917' 
            
2024-03-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380906'
                WHERE ordernumber = 'P180310130702191' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380909'
                WHERE ordernumber = 'P180310130830433' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347636'
                WHERE ordernumber = 'P200310131047274' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380910'
                WHERE ordernumber = 'P180310131342308' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380912'
                WHERE ordernumber = 'P420310131658750' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350159'
                WHERE ordernumber = 'P180310132619284' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342223'
                WHERE ordernumber = 'P180310132736842' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380914'
                WHERE ordernumber = 'P420310132813702' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380915'
                WHERE ordernumber = 'P180310133006643' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380916'
                WHERE ordernumber = 'P420310133258609' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98260'
                WHERE ordernumber = 'P180310133343647' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380917'
                WHERE ordernumber = 'P180310133714451' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128783'
                WHERE ordernumber = 'P420310133957768' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380918'
                WHERE ordernumber = 'P180310134152224' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380408'
                WHERE ordernumber = 'P420310134344960' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357054'
                WHERE ordernumber = 'P180310134414569' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380921'
                WHERE ordernumber = 'P180310134824575' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94536'
                WHERE ordernumber = 'P200310134910739' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102823'
                WHERE ordernumber = 'P420310135054146' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380919'
                WHERE ordernumber = 'P180310135514920' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380923'
                WHERE ordernumber = 'P420310135538873' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380919'
                WHERE ordernumber = 'P180310135542448' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278904'
                WHERE ordernumber = 'P200310135623790' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380924'
                WHERE ordernumber = 'P420310135711226' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380922'
                WHERE ordernumber = 'P180310135830140' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380922'
                WHERE ordernumber = 'P180310135852629' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380925'
                WHERE ordernumber = 'P200310140147261' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380926'
                WHERE ordernumber = 'P420310140559412' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345773'
                WHERE ordernumber = 'P180310141148976' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366315'
                WHERE ordernumber = 'P200310141325974' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374198'
                WHERE ordernumber = 'P420310141648378' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361473'
                WHERE ordernumber = 'P200310141751166' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380929'
                WHERE ordernumber = 'P420310141831406' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380930'
                WHERE ordernumber = 'P180310141930881' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380931'
                WHERE ordernumber = 'P180310142209779' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356522'
                WHERE ordernumber = 'P200310142336997' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380162'
                WHERE ordernumber = 'P180310142348159' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348935'
                WHERE ordernumber = 'P180310142433797' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380927'
                WHERE ordernumber = 'P180310143141513' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380927'
                WHERE ordernumber = 'P180310143219824' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380928'
                WHERE ordernumber = 'P180310143310266' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380928'
                WHERE ordernumber = 'P180310143353182' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378791'
                WHERE ordernumber = 'P180310143653425' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348878'
                WHERE ordernumber = 'P190310143656417' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348022'
                WHERE ordernumber = 'P200310144000409' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363934'
                WHERE ordernumber = 'P180310144131422' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380932'
                WHERE ordernumber = 'P420310144403131' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333022'
                WHERE ordernumber = 'P420310144557390' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227076'
                WHERE ordernumber = 'P200310145346977' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380933'
                WHERE ordernumber = 'P180310145401819' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380934'
                WHERE ordernumber = 'P420310145458518' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380935'
                WHERE ordernumber = 'P180310145504290' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288910'
                WHERE ordernumber = 'P200310145614183' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380936'
                WHERE ordernumber = 'P180310145646883' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378059'
                WHERE ordernumber = 'P180310145902421' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380937'
                WHERE ordernumber = 'P420310145902898' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380938'
                WHERE ordernumber = 'P420310150042139' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378059'
                WHERE ordernumber = 'P190310150111955' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277846'
                WHERE ordernumber = 'P180310150158332' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345398'
                WHERE ordernumber = 'P420310150252446' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380939'
                WHERE ordernumber = 'P190310150256727' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380940'
                WHERE ordernumber = 'P420310150728364' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380941'
                WHERE ordernumber = 'P200310151524442' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380942'
                WHERE ordernumber = 'P420310151617259' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297104'
                WHERE ordernumber = 'P420310151632274' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302285'
                WHERE ordernumber = 'P180310151835277' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380540'
                WHERE ordernumber = 'P180310152629802' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380540'
                WHERE ordernumber = 'P180310152632434' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372709'
                WHERE ordernumber = 'P420310153107580' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380943'
                WHERE ordernumber = 'P180310153234832' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354447'
                WHERE ordernumber = 'P190310153317991' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380944'
                WHERE ordernumber = 'P420310153331246' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380946'
                WHERE ordernumber = 'P200310153430162' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380945'
                WHERE ordernumber = 'P180310153723203' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380945'
                WHERE ordernumber = 'P180310153738306' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379475'
                WHERE ordernumber = 'P200310153752685' 
            
2024-03-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380947'
                WHERE ordernumber = 'P420310153809842' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380948'
                WHERE ordernumber = 'P200310154040345' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380950'
                WHERE ordernumber = 'P420310154054167' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380949'
                WHERE ordernumber = 'P180310154059208' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380952'
                WHERE ordernumber = 'P420310154439616' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380954'
                WHERE ordernumber = 'P180310154618749' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209382'
                WHERE ordernumber = 'P180310154702403' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380956'
                WHERE ordernumber = 'P420310154847828' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380958'
                WHERE ordernumber = 'P180310154917519' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380951'
                WHERE ordernumber = 'P590310155052996' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P420310155119948' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380961'
                WHERE ordernumber = 'P200310155248758' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284608'
                WHERE ordernumber = 'P180310155555908' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380963'
                WHERE ordernumber = 'P420310155625997' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380964'
                WHERE ordernumber = 'P420310160055894' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380965'
                WHERE ordernumber = 'P420310160158612' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380966'
                WHERE ordernumber = 'P200310160207361' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380967'
                WHERE ordernumber = 'P180310160646114' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360071'
                WHERE ordernumber = 'P420310160934799' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132818'
                WHERE ordernumber = 'P200310161101828' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380968'
                WHERE ordernumber = 'P180310161235439' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344866'
                WHERE ordernumber = 'P200310161355209' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373086'
                WHERE ordernumber = 'P420310161832320' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332079'
                WHERE ordernumber = 'P200310161839359' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P420310162412743' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '171207'
                WHERE ordernumber = 'P420310162514268' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380972'
                WHERE ordernumber = 'P420310162937603' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380459'
                WHERE ordernumber = 'P420310163012580' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304762'
                WHERE ordernumber = 'P200310163111581' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380969'
                WHERE ordernumber = 'P590310163119510' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380970'
                WHERE ordernumber = 'P590310163142295' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380971'
                WHERE ordernumber = 'P590310163207181' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380973'
                WHERE ordernumber = 'P420310163319663' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379992'
                WHERE ordernumber = 'P180310163525406' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379992'
                WHERE ordernumber = 'P180310163539282' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340845'
                WHERE ordernumber = 'P420310163657443' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380974'
                WHERE ordernumber = 'P420310163908442' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294147'
                WHERE ordernumber = 'P420310163952151' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242490'
                WHERE ordernumber = 'P180310164227347' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380975'
                WHERE ordernumber = 'P180310164503755' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379281'
                WHERE ordernumber = 'P420310164505504' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380976'
                WHERE ordernumber = 'P590310164546460' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379977'
                WHERE ordernumber = 'P180310164706735' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300100'
                WHERE ordernumber = 'P180310164759345' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380977'
                WHERE ordernumber = 'P420310164942589' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380978'
                WHERE ordernumber = 'P180310164957786' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380979'
                WHERE ordernumber = 'P180310165105758' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214699'
                WHERE ordernumber = 'P200310165144506' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380980'
                WHERE ordernumber = 'P180310165211930' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340845'
                WHERE ordernumber = 'P420310165305934' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209438'
                WHERE ordernumber = 'P180310165602146' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362427'
                WHERE ordernumber = 'P190310165811272' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380981'
                WHERE ordernumber = 'P180310170030506' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254478'
                WHERE ordernumber = 'P190310170206147' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380983'
                WHERE ordernumber = 'P420310170336798' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380985'
                WHERE ordernumber = 'P200310170813827' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380988'
                WHERE ordernumber = 'P420310171043855' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271564'
                WHERE ordernumber = 'P200310171431231' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129895'
                WHERE ordernumber = 'P190310171625290' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311243'
                WHERE ordernumber = 'P420310171639733' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380989'
                WHERE ordernumber = 'P180310171748453' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380990'
                WHERE ordernumber = 'P420310171848804' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380991'
                WHERE ordernumber = 'P180310171924695' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294327'
                WHERE ordernumber = 'P420310171947890' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365801'
                WHERE ordernumber = 'P420310172104804' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264118'
                WHERE ordernumber = 'P200310172206731' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380992'
                WHERE ordernumber = 'P180310173130971' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366312'
                WHERE ordernumber = 'P420310173345538' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372971'
                WHERE ordernumber = 'P200310173751347' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380994'
                WHERE ordernumber = 'P190310174641360' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378376'
                WHERE ordernumber = 'P420310174642326' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380996'
                WHERE ordernumber = 'P420310174737213' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380997'
                WHERE ordernumber = 'P190310175308300' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124590'
                WHERE ordernumber = 'P190310175701192' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378376'
                WHERE ordernumber = 'P420310175836500' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249554'
                WHERE ordernumber = 'P200310175852980' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380999'
                WHERE ordernumber = 'P420310175927400' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '187606'
                WHERE ordernumber = 'P420310180136793' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381000'
                WHERE ordernumber = 'P200310180328949' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381001'
                WHERE ordernumber = 'P420310180535789' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381003'
                WHERE ordernumber = 'P420310180612606' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381004'
                WHERE ordernumber = 'P420310180705931' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99303'
                WHERE ordernumber = 'P200310181438211' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317103'
                WHERE ordernumber = 'P190310181520329' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381007'
                WHERE ordernumber = 'P200310181634741' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297663'
                WHERE ordernumber = 'P190310181801455' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381009'
                WHERE ordernumber = 'P420310182159859' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381011'
                WHERE ordernumber = 'P420310183356192' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238560'
                WHERE ordernumber = 'P200310184243462' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381012'
                WHERE ordernumber = 'P200310184455571' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354586'
                WHERE ordernumber = 'P190310184606755' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381013'
                WHERE ordernumber = 'P420310184824599' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217445'
                WHERE ordernumber = 'P190310185418719' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242234'
                WHERE ordernumber = 'P200310192113409' 
            
2024-03-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118039'
                WHERE ordernumber = 'P190310192403268' 
            
2024-03-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379424'
                WHERE ordernumber = 'P190310192715665' 
            
2024-03-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283266'
                WHERE ordernumber = 'P190310193114773' 
            
2024-03-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379300'
                WHERE ordernumber = 'P420310193338130' 
            
2024-03-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240044'
                WHERE ordernumber = 'P190310193343142' 
            
2024-03-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346613'
                WHERE ordernumber = 'P420310193544222' 
            
2024-03-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379537'
                WHERE ordernumber = 'P420310194239463' 
            
2024-03-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167292'
                WHERE ordernumber = 'P200310194648276' 
            
2024-03-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381016'
                WHERE ordernumber = 'P420310195656940' 
            
2024-03-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381017'
                WHERE ordernumber = 'P200310195747448'