2024-04-02 01:00:02 -- 將會員中心id寫入data-lake
2024-04-02 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-04-01%';
        
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383989'
                WHERE ordernumber = 'P630401110032971' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239648'
                WHERE ordernumber = 'P180401110139642' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383990'
                WHERE ordernumber = 'P630401110357928' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242506'
                WHERE ordernumber = 'P180401110407627' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383991'
                WHERE ordernumber = 'P200401110502378' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265504'
                WHERE ordernumber = 'P180401110956734' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380154'
                WHERE ordernumber = 'P420401111006504' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383992'
                WHERE ordernumber = 'P180401111153706' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277423'
                WHERE ordernumber = 'P190401111418298' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383994'
                WHERE ordernumber = 'P180401111458982' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383996'
                WHERE ordernumber = 'P190401111615607' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336569'
                WHERE ordernumber = 'P420401112152916' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218542'
                WHERE ordernumber = 'P180401112931422' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244090'
                WHERE ordernumber = 'P180401113230880' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229003'
                WHERE ordernumber = 'P200401113421682' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338779'
                WHERE ordernumber = 'P420401113802648' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334859'
                WHERE ordernumber = 'P180401113823652' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96157'
                WHERE ordernumber = 'P180401114054264' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '198012'
                WHERE ordernumber = 'P180401115142595' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384001'
                WHERE ordernumber = 'P420401115253707' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320225'
                WHERE ordernumber = 'P180401115325496' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287531'
                WHERE ordernumber = 'P200401115421409' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384002'
                WHERE ordernumber = 'P180401115530867' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321756'
                WHERE ordernumber = 'P180401115759299' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420401115923419' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384003'
                WHERE ordernumber = 'P420401120356947' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237408'
                WHERE ordernumber = 'P200401120428147' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384004'
                WHERE ordernumber = 'P630401121604759' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103023'
                WHERE ordernumber = 'P420401122444422' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180401122612870' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384006'
                WHERE ordernumber = 'P420401122626787' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129715'
                WHERE ordernumber = 'P180401122823896' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381448'
                WHERE ordernumber = 'P420401122912725' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384005'
                WHERE ordernumber = 'P590401123114154' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330195'
                WHERE ordernumber = 'P420401123209838' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383995'
                WHERE ordernumber = 'P200401123237925' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384007'
                WHERE ordernumber = 'P180401123643223' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384009'
                WHERE ordernumber = 'P200401124235458' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384010'
                WHERE ordernumber = 'P200401124412478' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384011'
                WHERE ordernumber = 'P630401124652645' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286337'
                WHERE ordernumber = 'P200401125048661' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309517'
                WHERE ordernumber = 'P180401125051736' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235646'
                WHERE ordernumber = 'P200401125143516' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '150183'
                WHERE ordernumber = 'P180401125245531' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384012'
                WHERE ordernumber = 'P180401130404405' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97773'
                WHERE ordernumber = 'P200401130607538' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348951'
                WHERE ordernumber = 'P200401131036599' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283209'
                WHERE ordernumber = 'P180401131330266' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384013'
                WHERE ordernumber = 'P180401131503202' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384014'
                WHERE ordernumber = 'P420401131922878' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281131'
                WHERE ordernumber = 'P420401132038704' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384015'
                WHERE ordernumber = 'P420401132444292' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301971'
                WHERE ordernumber = 'P420401132650740' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247870'
                WHERE ordernumber = 'P200401133538484' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223959'
                WHERE ordernumber = 'P200401134258467' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384019'
                WHERE ordernumber = 'P180401135016560' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276029'
                WHERE ordernumber = 'P180401135358544' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384020'
                WHERE ordernumber = 'P200401135401113' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384021'
                WHERE ordernumber = 'P200401140944469' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384023'
                WHERE ordernumber = 'P180401141523779' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384026'
                WHERE ordernumber = 'P180401142110899' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345438'
                WHERE ordernumber = 'P180401142228568' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238188'
                WHERE ordernumber = 'P200401142244710' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305444'
                WHERE ordernumber = 'P420401142245352' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384027'
                WHERE ordernumber = 'P200401142437394' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384028'
                WHERE ordernumber = 'P180401142703209' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297157'
                WHERE ordernumber = 'P420401142723409' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384029'
                WHERE ordernumber = 'P180401143603666' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384030'
                WHERE ordernumber = 'P420401143616530' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142568'
                WHERE ordernumber = 'P200401143652146' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380031'
                WHERE ordernumber = 'P200401144751494' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383930'
                WHERE ordernumber = 'P200401144852209' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384031'
                WHERE ordernumber = 'P180401145409551' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384032'
                WHERE ordernumber = 'P180401145703375' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384033'
                WHERE ordernumber = 'P180401145947821' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383280'
                WHERE ordernumber = 'P200401150027973' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '134849'
                WHERE ordernumber = 'P190401150053281' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256850'
                WHERE ordernumber = 'P200401150114638' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81134'
                WHERE ordernumber = 'P180401150536974' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383945'
                WHERE ordernumber = 'P180401151139623' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384035'
                WHERE ordernumber = 'P180401151541374' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384036'
                WHERE ordernumber = 'P180401151848649' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '46367'
                WHERE ordernumber = 'P190401152309191' 
            
2024-04-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384037'
                WHERE ordernumber = 'P420401152728808' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109905'
                WHERE ordernumber = 'P420401153310955' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384038'
                WHERE ordernumber = 'P200401153359703' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383896'
                WHERE ordernumber = 'P180401153423249' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384040'
                WHERE ordernumber = 'P630401153439717' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384042'
                WHERE ordernumber = 'P420401153641796' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375793'
                WHERE ordernumber = 'P190401153738459' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P190401154236831' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384044'
                WHERE ordernumber = 'P180401154603798' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382190'
                WHERE ordernumber = 'P180401154645619' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378685'
                WHERE ordernumber = 'P200401155301891' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360180'
                WHERE ordernumber = 'P200401155513303' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384046'
                WHERE ordernumber = 'P420401155739117' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325953'
                WHERE ordernumber = 'P420401155845600' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384047'
                WHERE ordernumber = 'P420401160019952' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382190'
                WHERE ordernumber = 'P180401160333339' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384048'
                WHERE ordernumber = 'P420401160608233' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164261'
                WHERE ordernumber = 'P190401160709412' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384051'
                WHERE ordernumber = 'P180401160724593' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384053'
                WHERE ordernumber = 'P180401160816438' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384052'
                WHERE ordernumber = 'P420401160819234' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247096'
                WHERE ordernumber = 'P190401161233628' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384054'
                WHERE ordernumber = 'P420401161320381' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384050'
                WHERE ordernumber = 'P630401162203250' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352011'
                WHERE ordernumber = 'P180401162312596' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384055'
                WHERE ordernumber = 'P200401162507753' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383272'
                WHERE ordernumber = 'P200401162653402' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384056'
                WHERE ordernumber = 'P200401162936371' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384057'
                WHERE ordernumber = 'P180401163138597' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384058'
                WHERE ordernumber = 'P200401163716234' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384062'
                WHERE ordernumber = 'P200401163952706' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380301'
                WHERE ordernumber = 'P200401164122533' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137217'
                WHERE ordernumber = 'P200401164159369' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384060'
                WHERE ordernumber = 'P590401164205533' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384063'
                WHERE ordernumber = 'P180401164300525' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118270'
                WHERE ordernumber = 'P180401164400820' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384061'
                WHERE ordernumber = 'P590401164439517' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384064'
                WHERE ordernumber = 'P420401164634534' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384065'
                WHERE ordernumber = 'P180401164813294' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384066'
                WHERE ordernumber = 'P180401164938893' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319017'
                WHERE ordernumber = 'P200401170034454' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117390'
                WHERE ordernumber = 'P630401170300316' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358098'
                WHERE ordernumber = 'P420401170354589' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384068'
                WHERE ordernumber = 'P180401170911483' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384070'
                WHERE ordernumber = 'P190401171311520' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384071'
                WHERE ordernumber = 'P420401171844397' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384072'
                WHERE ordernumber = 'P630401172002942' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324388'
                WHERE ordernumber = 'P420401172008705' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123641'
                WHERE ordernumber = 'P200401173059288' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384073'
                WHERE ordernumber = 'P200401173716958' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384074'
                WHERE ordernumber = 'P420401173923635' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293584'
                WHERE ordernumber = 'P190401175130828' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384075'
                WHERE ordernumber = 'P180401175657425' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127159'
                WHERE ordernumber = 'P180401180201211' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384076'
                WHERE ordernumber = 'P180401181353124' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87785'
                WHERE ordernumber = 'P200401181451292' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '176708'
                WHERE ordernumber = 'P200401182010625' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384078'
                WHERE ordernumber = 'P200401182145279' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383829'
                WHERE ordernumber = 'P180401182200847' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339831'
                WHERE ordernumber = 'P420401183127445' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384082'
                WHERE ordernumber = 'P200401183348345' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383829'
                WHERE ordernumber = 'P180401183349528' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337525'
                WHERE ordernumber = 'P180401183752282' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104586'
                WHERE ordernumber = 'P200401184428384' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167603'
                WHERE ordernumber = 'P190401185253543' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384084'
                WHERE ordernumber = 'P630401190804946' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384085'
                WHERE ordernumber = 'P200401190913856' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383865'
                WHERE ordernumber = 'P190401191044211' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383865'
                WHERE ordernumber = 'P190401191242378' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236627'
                WHERE ordernumber = 'P200401191338655' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221487'
                WHERE ordernumber = 'P200401191710220' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384079'
                WHERE ordernumber = 'P190401191850964' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384087'
                WHERE ordernumber = 'P190401192036526' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384087'
                WHERE ordernumber = 'P190401192100605' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137334'
                WHERE ordernumber = 'P200401192606410' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384088'
                WHERE ordernumber = 'P190401192756501' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '62622'
                WHERE ordernumber = 'P420401192837840' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283272'
                WHERE ordernumber = 'P190401193151556' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310746'
                WHERE ordernumber = 'P190401193405703' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384089'
                WHERE ordernumber = 'P200401193500903' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384090'
                WHERE ordernumber = 'P190401193628508' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309074'
                WHERE ordernumber = 'P190401194306918' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382162'
                WHERE ordernumber = 'P200401200426501' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384094'
                WHERE ordernumber = 'P590401205413652' 
            
2024-04-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286378'
                WHERE ordernumber = 'P630401212020224'