2024-03-17 01:00:02 -- 將會員中心id寫入data-lake
2024-03-17 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-16%';
        
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298137'
                WHERE ordernumber = 'P420316105515782' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180316110125130' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81933'
                WHERE ordernumber = 'P200316110316934' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P200316110403411' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '77642'
                WHERE ordernumber = 'P180316110628582' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314818'
                WHERE ordernumber = 'P180316110713288' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339387'
                WHERE ordernumber = 'P200316110752583' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218734'
                WHERE ordernumber = 'P200316110911713' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381725'
                WHERE ordernumber = 'P200316111123365' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349826'
                WHERE ordernumber = 'P180316111142729' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381726'
                WHERE ordernumber = 'P180316111326665' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381727'
                WHERE ordernumber = 'P180316111427344' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381728'
                WHERE ordernumber = 'P180316111625163' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317568'
                WHERE ordernumber = 'P180316111719356' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381730'
                WHERE ordernumber = 'P200316112209609' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381731'
                WHERE ordernumber = 'P420316112342796' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381732'
                WHERE ordernumber = 'P180316112515391' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381733'
                WHERE ordernumber = 'P180316112617636' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381734'
                WHERE ordernumber = 'P200316112749884' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213044'
                WHERE ordernumber = 'P180316112847644' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129092'
                WHERE ordernumber = 'P190316113225150' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381735'
                WHERE ordernumber = 'P180316113333623' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381737'
                WHERE ordernumber = 'P180316113534675' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381739'
                WHERE ordernumber = 'P180316113706176' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381738'
                WHERE ordernumber = 'P590316113716636' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '126295'
                WHERE ordernumber = 'P180316113917489' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303554'
                WHERE ordernumber = 'P180316113938762' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381740'
                WHERE ordernumber = 'P420316114031185' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357654'
                WHERE ordernumber = 'P200316114110281' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96645'
                WHERE ordernumber = 'P200316114229176' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381741'
                WHERE ordernumber = 'P200316114846579' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346546'
                WHERE ordernumber = 'P200316115155533' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381742'
                WHERE ordernumber = 'P180316115526830' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245513'
                WHERE ordernumber = 'P180316120315415' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381745'
                WHERE ordernumber = 'P420316120343441' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381747'
                WHERE ordernumber = 'P180316120505415' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381672'
                WHERE ordernumber = 'P180316120617284' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381748'
                WHERE ordernumber = 'P180316121001117' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381749'
                WHERE ordernumber = 'P180316121154884' 
            
2024-03-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381750'
                WHERE ordernumber = 'P420316121201209' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381751'
                WHERE ordernumber = 'P420316121352614' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287818'
                WHERE ordernumber = 'P180316121402849' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229236'
                WHERE ordernumber = 'P180316121626240' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348554'
                WHERE ordernumber = 'P420316121637204' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365583'
                WHERE ordernumber = 'P180316121731379' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365583'
                WHERE ordernumber = 'P180316121813922' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381752'
                WHERE ordernumber = 'P200316122005113' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381753'
                WHERE ordernumber = 'P180316122118209' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275486'
                WHERE ordernumber = 'P200316122327524' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381755'
                WHERE ordernumber = 'P180316122524602' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381756'
                WHERE ordernumber = 'P420316122559991' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378763'
                WHERE ordernumber = 'P200316122637834' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222852'
                WHERE ordernumber = 'P200316122756119' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381757'
                WHERE ordernumber = 'P180316123008913' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142285'
                WHERE ordernumber = 'P420316123423509' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346752'
                WHERE ordernumber = 'P590316124002133' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209646'
                WHERE ordernumber = 'P180316124004158' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381759'
                WHERE ordernumber = 'P180316124159587' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340476'
                WHERE ordernumber = 'P180316124240733' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220080'
                WHERE ordernumber = 'P180316124413938' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381760'
                WHERE ordernumber = 'P180316124530566' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350514'
                WHERE ordernumber = 'P420316124612988' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118273'
                WHERE ordernumber = 'P180316125149570' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96007'
                WHERE ordernumber = 'P190316125228311' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381761'
                WHERE ordernumber = 'P180316130101863' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96074'
                WHERE ordernumber = 'P180316130406271' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380804'
                WHERE ordernumber = 'P180316130528166' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381763'
                WHERE ordernumber = 'P180316130723588' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381765'
                WHERE ordernumber = 'P180316131326157' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381766'
                WHERE ordernumber = 'P420316131658246' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341235'
                WHERE ordernumber = 'P420316131800506' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381767'
                WHERE ordernumber = 'P180316131857304' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359853'
                WHERE ordernumber = 'P180316132106491' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381769'
                WHERE ordernumber = 'P180316132416515' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245292'
                WHERE ordernumber = 'P200316132512579' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163743'
                WHERE ordernumber = 'P200316132730471' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224834'
                WHERE ordernumber = 'P420316132733703' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381770'
                WHERE ordernumber = 'P180316133355348' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379826'
                WHERE ordernumber = 'P420316133407258' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379826'
                WHERE ordernumber = 'P420316133524207' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381771'
                WHERE ordernumber = 'P180316133800511' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102564'
                WHERE ordernumber = 'P180316134034410' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248077'
                WHERE ordernumber = 'P190316134204348' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381772'
                WHERE ordernumber = 'P180316134433226' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379469'
                WHERE ordernumber = 'P200316134555352' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381446'
                WHERE ordernumber = 'P180316134622476' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381773'
                WHERE ordernumber = 'P180316134907938' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243519'
                WHERE ordernumber = 'P180316135527675' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381648'
                WHERE ordernumber = 'P190316135529639' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380317'
                WHERE ordernumber = 'P420316135614837' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348809'
                WHERE ordernumber = 'P180316135931301' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381775'
                WHERE ordernumber = 'P200316140227448' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381776'
                WHERE ordernumber = 'P420316140242865' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381777'
                WHERE ordernumber = 'P180316140406281' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381774'
                WHERE ordernumber = 'P590316140654408' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381778'
                WHERE ordernumber = 'P420316140854948' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88957'
                WHERE ordernumber = 'P200316141159292' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381780'
                WHERE ordernumber = 'P180316141216189' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381780'
                WHERE ordernumber = 'P180316141307927' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381781'
                WHERE ordernumber = 'P420316141308280' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342538'
                WHERE ordernumber = 'P420316141358421' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379914'
                WHERE ordernumber = 'P200316141559991' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377207'
                WHERE ordernumber = 'P420316141618139' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275261'
                WHERE ordernumber = 'P180316141817261' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381782'
                WHERE ordernumber = 'P200316141937570' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381783'
                WHERE ordernumber = 'P180316142128348' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380647'
                WHERE ordernumber = 'P200316142322188' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '77445'
                WHERE ordernumber = 'P200316142535824' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381786'
                WHERE ordernumber = 'P200316142738295' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220427'
                WHERE ordernumber = 'P200316142811818' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381787'
                WHERE ordernumber = 'P180316142924216' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381788'
                WHERE ordernumber = 'P420316143007177' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288248'
                WHERE ordernumber = 'P180316143313356' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381789'
                WHERE ordernumber = 'P420316143632517' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381790'
                WHERE ordernumber = 'P180316143941157' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381791'
                WHERE ordernumber = 'P420316144210448' 
            
2024-03-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381792'
                WHERE ordernumber = 'P200316144731679' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381793'
                WHERE ordernumber = 'P200316145134870' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381794'
                WHERE ordernumber = 'P180316145215755' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275526'
                WHERE ordernumber = 'P420316145337165' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381795'
                WHERE ordernumber = 'P200316145438179' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351519'
                WHERE ordernumber = 'P200316145601872' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381796'
                WHERE ordernumber = 'P180316145739876' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284509'
                WHERE ordernumber = 'P180316145947172' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381797'
                WHERE ordernumber = 'P180316150344452' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381797'
                WHERE ordernumber = 'P180316150441538' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282143'
                WHERE ordernumber = 'P200316150453116' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149668'
                WHERE ordernumber = 'P200316150745180' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369810'
                WHERE ordernumber = 'P200316151017239' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237738'
                WHERE ordernumber = 'P590316151245806' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248929'
                WHERE ordernumber = 'P420316151327967' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302597'
                WHERE ordernumber = 'P180316151333329' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381714'
                WHERE ordernumber = 'P180316151506820' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381714'
                WHERE ordernumber = 'P180316151644557' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355398'
                WHERE ordernumber = 'P200316151648713' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381779'
                WHERE ordernumber = 'P180316151922572' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P190316152013696' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381798'
                WHERE ordernumber = 'P190316152056669' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P190316152337563' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381799'
                WHERE ordernumber = 'P420316152405922' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381799'
                WHERE ordernumber = 'P420316152547125' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P190316152605648' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375834'
                WHERE ordernumber = 'P180316152623498' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P190316152809533' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P190316152950332' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381802'
                WHERE ordernumber = 'P420316153444805' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381754'
                WHERE ordernumber = 'P180316153647118' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381801'
                WHERE ordernumber = 'P590316153749839' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381803'
                WHERE ordernumber = 'P420316153837660' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381804'
                WHERE ordernumber = 'P200316153838370' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381805'
                WHERE ordernumber = 'P200316154341440' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102149'
                WHERE ordernumber = 'P200316154709858' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P190316154848708' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P190316155014886' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381806'
                WHERE ordernumber = 'P420316155024967' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P190316155245541' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381807'
                WHERE ordernumber = 'P420316155321759' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381809'
                WHERE ordernumber = 'P420316155457553' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P190316155603704' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126064'
                WHERE ordernumber = 'P180316155704851' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381810'
                WHERE ordernumber = 'P420316155747382' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136223'
                WHERE ordernumber = 'P200316155844266' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95352'
                WHERE ordernumber = 'P180316160055193' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272196'
                WHERE ordernumber = 'P420316160158190' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381812'
                WHERE ordernumber = 'P420316160524715' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381813'
                WHERE ordernumber = 'P420316160633348' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248085'
                WHERE ordernumber = 'P180316160702208' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381811'
                WHERE ordernumber = 'P420316160808139' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366147'
                WHERE ordernumber = 'P180316160845476' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381815'
                WHERE ordernumber = 'P420316161114598' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381814'
                WHERE ordernumber = 'P180316161135650' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381816'
                WHERE ordernumber = 'P420316161200888' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381817'
                WHERE ordernumber = 'P180316161324168' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381817'
                WHERE ordernumber = 'P180316161432517' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381818'
                WHERE ordernumber = 'P420316161509248' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381819'
                WHERE ordernumber = 'P180316161555728' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '153148'
                WHERE ordernumber = 'P180316161718243' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310473'
                WHERE ordernumber = 'P180316161804704' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381820'
                WHERE ordernumber = 'P180316161857224' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381122'
                WHERE ordernumber = 'P180316161925795' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381821'
                WHERE ordernumber = 'P180316162120534' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381823'
                WHERE ordernumber = 'P420316162605979' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245477'
                WHERE ordernumber = 'P180316162914960' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381824'
                WHERE ordernumber = 'P190316162951769' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316470'
                WHERE ordernumber = 'P180316163421637' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381827'
                WHERE ordernumber = 'P180316163547152' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381828'
                WHERE ordernumber = 'P420316163756578' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114381'
                WHERE ordernumber = 'P180316163916684' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312643'
                WHERE ordernumber = 'P420316163943785' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381830'
                WHERE ordernumber = 'P180316164338467' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298283'
                WHERE ordernumber = 'P420316164340743' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341685'
                WHERE ordernumber = 'P180316164536266' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321402'
                WHERE ordernumber = 'P420316164538557' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381832'
                WHERE ordernumber = 'P420316164630820' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261736'
                WHERE ordernumber = 'P180316164706907' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381834'
                WHERE ordernumber = 'P180316164934130' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381835'
                WHERE ordernumber = 'P180316165225141' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381836'
                WHERE ordernumber = 'P190316165312147' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381833'
                WHERE ordernumber = 'P200316165419379' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381837'
                WHERE ordernumber = 'P190316165509359' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297054'
                WHERE ordernumber = 'P180316165752968' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354426'
                WHERE ordernumber = 'P180316170206314' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381840'
                WHERE ordernumber = 'P420316170402258' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381841'
                WHERE ordernumber = 'P420316170509888' 
            
2024-03-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381842'
                WHERE ordernumber = 'P420316170813311' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304095'
                WHERE ordernumber = 'P180316171220396' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381844'
                WHERE ordernumber = 'P180316171426749' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365741'
                WHERE ordernumber = 'P420316171453670' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381845'
                WHERE ordernumber = 'P180316171602156' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381631'
                WHERE ordernumber = 'P180316171810729' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381846'
                WHERE ordernumber = 'P180316171910805' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '256085'
                WHERE ordernumber = 'P180316172007906' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288433'
                WHERE ordernumber = 'P200316172140499' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381849'
                WHERE ordernumber = 'P180316172622296' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '171626'
                WHERE ordernumber = 'P180316173143116' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343629'
                WHERE ordernumber = 'P200316173353122' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297637'
                WHERE ordernumber = 'P200316173659863' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235981'
                WHERE ordernumber = 'P420316173810566' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239187'
                WHERE ordernumber = 'P180316173836975' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381854'
                WHERE ordernumber = 'P200316174551271' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381855'
                WHERE ordernumber = 'P180316175312270' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '309225'
                WHERE ordernumber = 'P200316175346724' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340830'
                WHERE ordernumber = 'P190316175705371' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381856'
                WHERE ordernumber = 'P420316175716828' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381857'
                WHERE ordernumber = 'P180316180039556' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343732'
                WHERE ordernumber = 'P180316180217404' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340830'
                WHERE ordernumber = 'P190316180320991' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247504'
                WHERE ordernumber = 'P180316180346273' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '244361'
                WHERE ordernumber = 'P180316180457618' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '163308'
                WHERE ordernumber = 'P180316180808558' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381858'
                WHERE ordernumber = 'P420316180852374' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381860'
                WHERE ordernumber = 'P420316181948923' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381861'
                WHERE ordernumber = 'P180316182317541' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381862'
                WHERE ordernumber = 'P420316182403889' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121141'
                WHERE ordernumber = 'P200316183052740' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381863'
                WHERE ordernumber = 'P180316183452847' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '134872'
                WHERE ordernumber = 'P200316184251433' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381864'
                WHERE ordernumber = 'P180316184304371' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237010'
                WHERE ordernumber = 'P200316184504391' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381865'
                WHERE ordernumber = 'P200316184812605' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381866'
                WHERE ordernumber = 'P180316185001190' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381865'
                WHERE ordernumber = 'P200316185147254' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381867'
                WHERE ordernumber = 'P180316185307468' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '274943'
                WHERE ordernumber = 'P190316185312912' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381868'
                WHERE ordernumber = 'P420316185535300' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381869'
                WHERE ordernumber = 'P180316185809166' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381870'
                WHERE ordernumber = 'P190316185917805' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227972'
                WHERE ordernumber = 'P200316190343910' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380525'
                WHERE ordernumber = 'P190316190504336' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381872'
                WHERE ordernumber = 'P420316190923297' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381873'
                WHERE ordernumber = 'P190316191238418' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '216155'
                WHERE ordernumber = 'P420316191258873' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '257894'
                WHERE ordernumber = 'P190316191345433' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96911'
                WHERE ordernumber = 'P190316192041683' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381874'
                WHERE ordernumber = 'P420316192126174' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286200'
                WHERE ordernumber = 'P190316194520245' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381876'
                WHERE ordernumber = 'P200316194916692' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360735'
                WHERE ordernumber = 'P190316195426934' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307698'
                WHERE ordernumber = 'P190316195541821' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381877'
                WHERE ordernumber = 'P190316195803833' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275063'
                WHERE ordernumber = 'P420316195938708' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263796'
                WHERE ordernumber = 'P590316211906763' 
            
2024-03-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381883'
                WHERE ordernumber = 'P590316212001811'