2024-09-02 01:00:02 -- 將會員中心id寫入data-lake
2024-09-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-09-01%';
        
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415481'
                WHERE ordernumber = 'P630901100337918' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276671'
                WHERE ordernumber = 'P200901110245648' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417130'
                WHERE ordernumber = 'P420901110249154' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355907'
                WHERE ordernumber = 'P180901110304154' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403172'
                WHERE ordernumber = 'P420901110323736' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417126'
                WHERE ordernumber = 'P190901110359857' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417132'
                WHERE ordernumber = 'P420901110419929' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338978'
                WHERE ordernumber = 'P180901110419352' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413035'
                WHERE ordernumber = 'P200901110534594' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417136'
                WHERE ordernumber = 'P420901110630862' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417138'
                WHERE ordernumber = 'P420901110743520' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313392'
                WHERE ordernumber = 'P180901110756331' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397612'
                WHERE ordernumber = 'P190901110911998' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412962'
                WHERE ordernumber = 'P420901111105378' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417140'
                WHERE ordernumber = 'P190901111143608' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417141'
                WHERE ordernumber = 'P180901111211836' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311650'
                WHERE ordernumber = 'P200901111550611' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417142'
                WHERE ordernumber = 'P200901111756868' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380438'
                WHERE ordernumber = 'P180901111831690' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417144'
                WHERE ordernumber = 'P200901112113696' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417141'
                WHERE ordernumber = 'P180901112237898' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116975'
                WHERE ordernumber = 'P200901112434753' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417145'
                WHERE ordernumber = 'P420901112517838' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380009'
                WHERE ordernumber = 'P190901112807555' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408566'
                WHERE ordernumber = 'P420901112913914' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417148'
                WHERE ordernumber = 'P200901112915645' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417149'
                WHERE ordernumber = 'P420901113049756' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302281'
                WHERE ordernumber = 'P190901113050853' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417149'
                WHERE ordernumber = 'P420901113137617' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '325008'
                WHERE ordernumber = 'P200901113220315' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417152'
                WHERE ordernumber = 'P420901113305119' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417070'
                WHERE ordernumber = 'P420901113352697' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417153'
                WHERE ordernumber = 'P180901113459354' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '192937'
                WHERE ordernumber = 'P420901113554396' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417156'
                WHERE ordernumber = 'P180901113559634' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417145'
                WHERE ordernumber = 'P420901113656757' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417158'
                WHERE ordernumber = 'P420901113835939' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417159'
                WHERE ordernumber = 'P190901113920499' 
            
2024-09-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415820'
                WHERE ordernumber = 'P420901114215156' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417160'
                WHERE ordernumber = 'P420901114439616' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368029'
                WHERE ordernumber = 'P200901114440412' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417162'
                WHERE ordernumber = 'P420901114649687' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84774'
                WHERE ordernumber = 'P200901114726522' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346078'
                WHERE ordernumber = 'P180901114758642' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269428'
                WHERE ordernumber = 'P200901115859206' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248977'
                WHERE ordernumber = 'P200901120148289' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417172'
                WHERE ordernumber = 'P420901120335869' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417174'
                WHERE ordernumber = 'P420901120454705' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335335'
                WHERE ordernumber = 'P180901120543695' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414794'
                WHERE ordernumber = 'P420901120740850' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354552'
                WHERE ordernumber = 'P180901120930944' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377386'
                WHERE ordernumber = 'P420901122150320' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269531'
                WHERE ordernumber = 'P200901122159807' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414875'
                WHERE ordernumber = 'P420901123004487' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88581'
                WHERE ordernumber = 'P180901123006863' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417185'
                WHERE ordernumber = 'P200901123052761' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417187'
                WHERE ordernumber = 'P420901123634271' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417190'
                WHERE ordernumber = 'P420901123941368' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417193'
                WHERE ordernumber = 'P420901124103338' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417195'
                WHERE ordernumber = 'P420901124306933' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417198'
                WHERE ordernumber = 'P420901124606933' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380284'
                WHERE ordernumber = 'P420901124711935' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417199'
                WHERE ordernumber = 'P200901124918677' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P420901125041406' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416717'
                WHERE ordernumber = 'P180901125243879' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304870'
                WHERE ordernumber = 'P180901125600871' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258101'
                WHERE ordernumber = 'P180901125857454' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417164'
                WHERE ordernumber = 'P190901125947182' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334875'
                WHERE ordernumber = 'P420901130435609' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415743'
                WHERE ordernumber = 'P180901130539111' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416873'
                WHERE ordernumber = 'P180901130724837' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416873'
                WHERE ordernumber = 'P180901130805273' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '29680'
                WHERE ordernumber = 'P420901130915630' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417209'
                WHERE ordernumber = 'P420901131222985' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417208'
                WHERE ordernumber = 'P200901131332731' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282484'
                WHERE ordernumber = 'P180901131432779' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P200901131504399' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417212'
                WHERE ordernumber = 'P190901131839855' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289207'
                WHERE ordernumber = 'P180901132131435' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300402'
                WHERE ordernumber = 'P180901132724479' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241638'
                WHERE ordernumber = 'P180901133037251' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409258'
                WHERE ordernumber = 'P200901133049325' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417221'
                WHERE ordernumber = 'P420901133805644' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271505'
                WHERE ordernumber = 'P180901133951370' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417223'
                WHERE ordernumber = 'P420901134006270' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161081'
                WHERE ordernumber = 'P200901134026359' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417224'
                WHERE ordernumber = 'P420901134038792' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415448'
                WHERE ordernumber = 'P190901134107995' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417227'
                WHERE ordernumber = 'P200901134358809' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417229'
                WHERE ordernumber = 'P420901134433621' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298155'
                WHERE ordernumber = 'P420901134603871' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414168'
                WHERE ordernumber = 'P180901134708136' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234028'
                WHERE ordernumber = 'P190901134717740' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417232'
                WHERE ordernumber = 'P190901135002992' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417235'
                WHERE ordernumber = 'P420901135537113' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85633'
                WHERE ordernumber = 'P190901135630187' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211759'
                WHERE ordernumber = 'P420901135719248' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270609'
                WHERE ordernumber = 'P180901135720290' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417240'
                WHERE ordernumber = 'P200901140123935' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339387'
                WHERE ordernumber = 'P200901140723513' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414678'
                WHERE ordernumber = 'P200901140937598' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414678'
                WHERE ordernumber = 'P200901141019931' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230102'
                WHERE ordernumber = 'P180901141100481' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242439'
                WHERE ordernumber = 'P200901141344357' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339387'
                WHERE ordernumber = 'P200901141525302' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417248'
                WHERE ordernumber = 'P200901141747986' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417250'
                WHERE ordernumber = 'P420901142012913' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '201633'
                WHERE ordernumber = 'P200901142104825' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399892'
                WHERE ordernumber = 'P200901142656530' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291564'
                WHERE ordernumber = 'P420901142807282' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417253'
                WHERE ordernumber = 'P420901143341360' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417254'
                WHERE ordernumber = 'P200901143450785' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416431'
                WHERE ordernumber = 'P420901143525508' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417176'
                WHERE ordernumber = 'P200901143619798' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417255'
                WHERE ordernumber = 'P200901143754965' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417256'
                WHERE ordernumber = 'P420901143856362' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417260'
                WHERE ordernumber = 'P420901144242970' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417261'
                WHERE ordernumber = 'P420901144403342' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '68768'
                WHERE ordernumber = 'P180901144654517' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417222'
                WHERE ordernumber = 'P420901144749882' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396952'
                WHERE ordernumber = 'P200901145343784' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417269'
                WHERE ordernumber = 'P420901145400248' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417271'
                WHERE ordernumber = 'P420901145801933' 
            
2024-09-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417273'
                WHERE ordernumber = 'P420901145925572' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405041'
                WHERE ordernumber = 'P630901145929839' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417274'
                WHERE ordernumber = 'P200901150332923' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417276'
                WHERE ordernumber = 'P180901150445826' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417204'
                WHERE ordernumber = 'P200901150636908' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417273'
                WHERE ordernumber = 'P420901150843702' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241417'
                WHERE ordernumber = 'P200901150855599' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417281'
                WHERE ordernumber = 'P200901151009806' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417282'
                WHERE ordernumber = 'P180901151223368' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '43289'
                WHERE ordernumber = 'P200901151408918' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417286'
                WHERE ordernumber = 'P180901152147724' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190901152516171' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417290'
                WHERE ordernumber = 'P200901152519487' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373410'
                WHERE ordernumber = 'P420901152850340' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379878'
                WHERE ordernumber = 'P200901153116287' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415217'
                WHERE ordernumber = 'P420901153153420' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379878'
                WHERE ordernumber = 'P200901153446897' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417298'
                WHERE ordernumber = 'P420901153455492' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293958'
                WHERE ordernumber = 'P190901153723743' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417301'
                WHERE ordernumber = 'P420901154142130' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411715'
                WHERE ordernumber = 'P200901154316947' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411715'
                WHERE ordernumber = 'P200901154436416' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335331'
                WHERE ordernumber = 'P200901154636859' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215420'
                WHERE ordernumber = 'P190901154708238' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215423'
                WHERE ordernumber = 'P190901154847768' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417305'
                WHERE ordernumber = 'P180901154934868' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417309'
                WHERE ordernumber = 'P420901155613859' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376204'
                WHERE ordernumber = 'P190901155814973' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233212'
                WHERE ordernumber = 'P420901155827411' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128851'
                WHERE ordernumber = 'P200901160016554' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417311'
                WHERE ordernumber = 'P420901160404660' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '85633'
                WHERE ordernumber = 'P180901160454679' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416855'
                WHERE ordernumber = 'P420901160550855' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417314'
                WHERE ordernumber = 'P200901160802335' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417316'
                WHERE ordernumber = 'P420901160830658' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417317'
                WHERE ordernumber = 'P200901160915317' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417317'
                WHERE ordernumber = 'P200901161156658' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227972'
                WHERE ordernumber = 'P200901161249919' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133387'
                WHERE ordernumber = 'P420901161419878' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414889'
                WHERE ordernumber = 'P420901161832717' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417321'
                WHERE ordernumber = 'P200901162015801' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227972'
                WHERE ordernumber = 'P200901162101828' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417322'
                WHERE ordernumber = 'P200901162347830' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '171667'
                WHERE ordernumber = 'P200901162728384' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413176'
                WHERE ordernumber = 'P190901162826712' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417324'
                WHERE ordernumber = 'P420901162921267' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312749'
                WHERE ordernumber = 'P200901163600698' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253376'
                WHERE ordernumber = 'P420901163824652' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281285'
                WHERE ordernumber = 'P190901163938387' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414974'
                WHERE ordernumber = 'P180901164053225' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415067'
                WHERE ordernumber = 'P420901164156810' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417333'
                WHERE ordernumber = 'P200901164403338' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227972'
                WHERE ordernumber = 'P200901164511543' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125170'
                WHERE ordernumber = 'P200901164821622' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252711'
                WHERE ordernumber = 'P180901164901797' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336724'
                WHERE ordernumber = 'P420901165151718' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408816'
                WHERE ordernumber = 'P190901165243241' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417336'
                WHERE ordernumber = 'P180901165335196' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417334'
                WHERE ordernumber = 'P190901165429348' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417334'
                WHERE ordernumber = 'P190901165454164' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417337'
                WHERE ordernumber = 'P180901165921275' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417338'
                WHERE ordernumber = 'P420901170145875' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417337'
                WHERE ordernumber = 'P180901170248466' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219239'
                WHERE ordernumber = 'P190901170845929' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416563'
                WHERE ordernumber = 'P190901171024303' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416563'
                WHERE ordernumber = 'P190901171055338' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417347'
                WHERE ordernumber = 'P200901171112487' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417348'
                WHERE ordernumber = 'P420901171235180' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349263'
                WHERE ordernumber = 'P420901171603446' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272355'
                WHERE ordernumber = 'P420901171738436' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417353'
                WHERE ordernumber = 'P420901172816167' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417355'
                WHERE ordernumber = 'P200901173003435' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417356'
                WHERE ordernumber = 'P420901173038183' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180901173802504' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417362'
                WHERE ordernumber = 'P200901173853717' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417363'
                WHERE ordernumber = 'P420901174037683' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417224'
                WHERE ordernumber = 'P420901174357841' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114408'
                WHERE ordernumber = 'P180901174626989' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385168'
                WHERE ordernumber = 'P200901174835923' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415928'
                WHERE ordernumber = 'P420901175007515' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399917'
                WHERE ordernumber = 'P420901175058247' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417373'
                WHERE ordernumber = 'P420901175453679' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '193941'
                WHERE ordernumber = 'P590901180110542' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266145'
                WHERE ordernumber = 'P200901180114169' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400622'
                WHERE ordernumber = 'P420901180157421' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416893'
                WHERE ordernumber = 'P420901180552956' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228542'
                WHERE ordernumber = 'P200901180641822' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387524'
                WHERE ordernumber = 'P180901181009982' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417380'
                WHERE ordernumber = 'P200901181042656' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417381'
                WHERE ordernumber = 'P420901181202238' 
            
2024-09-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389538'
                WHERE ordernumber = 'P420901181351719' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417377'
                WHERE ordernumber = 'P180901181426439' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417377'
                WHERE ordernumber = 'P180901181454781' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '335001'
                WHERE ordernumber = 'P420901181556455' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417384'
                WHERE ordernumber = 'P200901182043916' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417388'
                WHERE ordernumber = 'P200901182226984' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '195649'
                WHERE ordernumber = 'P180901182527908' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417394'
                WHERE ordernumber = 'P200901182838475' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417133'
                WHERE ordernumber = 'P180901183036229' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417395'
                WHERE ordernumber = 'P200901183050176' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417396'
                WHERE ordernumber = 'P420901183116586' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415202'
                WHERE ordernumber = 'P190901183149459' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417397'
                WHERE ordernumber = 'P200901183234519' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408359'
                WHERE ordernumber = 'P420901183636467' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414845'
                WHERE ordernumber = 'P200901184015501' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310335'
                WHERE ordernumber = 'P180901184038920' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414845'
                WHERE ordernumber = 'P200901184134506' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417133'
                WHERE ordernumber = 'P180901184306313' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417404'
                WHERE ordernumber = 'P200901184519371' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417406'
                WHERE ordernumber = 'P200901184640853' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414845'
                WHERE ordernumber = 'P200901184720608' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417408'
                WHERE ordernumber = 'P420901184801608' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417410'
                WHERE ordernumber = 'P200901184902697' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417412'
                WHERE ordernumber = 'P420901185003488' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417414'
                WHERE ordernumber = 'P200901185215689' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416938'
                WHERE ordernumber = 'P200901185541268' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416938'
                WHERE ordernumber = 'P200901185709323' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417414'
                WHERE ordernumber = 'P200901185825617' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94536'
                WHERE ordernumber = 'P200901190522751' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399149'
                WHERE ordernumber = 'P200901190758372' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '140175'
                WHERE ordernumber = 'P630901191049271' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219240'
                WHERE ordernumber = 'P200901191624324' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405282'
                WHERE ordernumber = 'P180901191636623' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '168956'
                WHERE ordernumber = 'P180901192138849' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104347'
                WHERE ordernumber = 'P200901192213774' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '413058'
                WHERE ordernumber = 'P200901192951191' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249752'
                WHERE ordernumber = 'P200901194251190' 
            
2024-09-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406053'
                WHERE ordernumber = 'P200901200151788'