2024-09-08 01:00:01 -- 將會員中心id寫入data-lake
2024-09-08 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-09-07%';
        
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419736'
                WHERE ordernumber = 'P420907110254149' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346418'
                WHERE ordernumber = 'P180907110321994' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410427'
                WHERE ordernumber = 'P200907110336475' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402678'
                WHERE ordernumber = 'P420907110359314' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417520'
                WHERE ordernumber = 'P420907110518838' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419730'
                WHERE ordernumber = 'P180907110532584' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419732'
                WHERE ordernumber = 'P420907110645404' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419671'
                WHERE ordernumber = 'P200907110811229' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338139'
                WHERE ordernumber = 'P200907111011888' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417938'
                WHERE ordernumber = 'P190907111054630' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419727'
                WHERE ordernumber = 'P180907111125584' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415227'
                WHERE ordernumber = 'P200907111312746' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268953'
                WHERE ordernumber = 'P200907111437794' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382686'
                WHERE ordernumber = 'P420907111502989' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419729'
                WHERE ordernumber = 'P180907111552338' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133451'
                WHERE ordernumber = 'P200907111623196' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419744'
                WHERE ordernumber = 'P420907111724480' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419735'
                WHERE ordernumber = 'P420907111959667' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369825'
                WHERE ordernumber = 'P420907112213463' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419734'
                WHERE ordernumber = 'P180907112228896' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404863'
                WHERE ordernumber = 'P420907112309718' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394292'
                WHERE ordernumber = 'P180907112313349' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235646'
                WHERE ordernumber = 'P200907112356824' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419746'
                WHERE ordernumber = 'P420907112432742' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303129'
                WHERE ordernumber = 'P200907112455978' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391405'
                WHERE ordernumber = 'P180907112503418' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419737'
                WHERE ordernumber = 'P180907112543810' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357114'
                WHERE ordernumber = 'P180907112611128' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418485'
                WHERE ordernumber = 'P420907112640262' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419738'
                WHERE ordernumber = 'P180907112703800' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419748'
                WHERE ordernumber = 'P420907112913845' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380784'
                WHERE ordernumber = 'P420907113238522' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419752'
                WHERE ordernumber = 'P420907113419723' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419753'
                WHERE ordernumber = 'P420907113541799' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418451'
                WHERE ordernumber = 'P180907113557559' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419754'
                WHERE ordernumber = 'P420907113727723' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249763'
                WHERE ordernumber = 'P200907114039378' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '119163'
                WHERE ordernumber = 'P420907114146276' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417769'
                WHERE ordernumber = 'P180907114254932' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419758'
                WHERE ordernumber = 'P420907114328758' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419743'
                WHERE ordernumber = 'P180907114700907' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338216'
                WHERE ordernumber = 'P180907114855593' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419761'
                WHERE ordernumber = 'P420907114959709' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '88195'
                WHERE ordernumber = 'P180907115011924' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381655'
                WHERE ordernumber = 'P200907115050176' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419740'
                WHERE ordernumber = 'P180907115250835' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419742'
                WHERE ordernumber = 'P180907115345308' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406319'
                WHERE ordernumber = 'P180907115433165' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335499'
                WHERE ordernumber = 'P420907115458824' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299142'
                WHERE ordernumber = 'P420907115522584' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406319'
                WHERE ordernumber = 'P180907115556704' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419763'
                WHERE ordernumber = 'P200907115634875' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409507'
                WHERE ordernumber = 'P200907115818955' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419741'
                WHERE ordernumber = 'P180907120035687' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348261'
                WHERE ordernumber = 'P180907120149133' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419749'
                WHERE ordernumber = 'P190907120527836' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419770'
                WHERE ordernumber = 'P420907120909628' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '227936'
                WHERE ordernumber = 'P180907121030497' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419767'
                WHERE ordernumber = 'P190907121205237' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406319'
                WHERE ordernumber = 'P180907121239721' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419771'
                WHERE ordernumber = 'P420907121247575' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413585'
                WHERE ordernumber = 'P190907121447544' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380807'
                WHERE ordernumber = 'P420907121527457' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406319'
                WHERE ordernumber = 'P190907121612542' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419756'
                WHERE ordernumber = 'P180907121622173' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380807'
                WHERE ordernumber = 'P420907121800339' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419759'
                WHERE ordernumber = 'P190907121953253' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365079'
                WHERE ordernumber = 'P180907122009518' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239679'
                WHERE ordernumber = 'P200907122135752' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P200907122302313' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346324'
                WHERE ordernumber = 'P180907122310893' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419759'
                WHERE ordernumber = 'P190907122311241' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419766'
                WHERE ordernumber = 'P190907122515505' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419766'
                WHERE ordernumber = 'P190907122607407' 
            
2024-09-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P420907122617229' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327682'
                WHERE ordernumber = 'P190907122803829' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419762'
                WHERE ordernumber = 'P180907122820251' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419760'
                WHERE ordernumber = 'P190907122957214' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419773'
                WHERE ordernumber = 'P180907123005496' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410963'
                WHERE ordernumber = 'P190907123222778' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401188'
                WHERE ordernumber = 'P420907123404744' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206858'
                WHERE ordernumber = 'P190907123431190' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419772'
                WHERE ordernumber = 'P180907123535172' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419769'
                WHERE ordernumber = 'P180907123711890' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243459'
                WHERE ordernumber = 'P190907123832945' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419768'
                WHERE ordernumber = 'P180907123845136' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276880'
                WHERE ordernumber = 'P180907124046338' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419778'
                WHERE ordernumber = 'P420907124051710' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315918'
                WHERE ordernumber = 'P420907124140390' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419774'
                WHERE ordernumber = 'P180907124215254' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403429'
                WHERE ordernumber = 'P420907124320919' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419775'
                WHERE ordernumber = 'P190907124411275' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '19162'
                WHERE ordernumber = 'P180907124443662' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261063'
                WHERE ordernumber = 'P420907124550886' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419777'
                WHERE ordernumber = 'P180907124610116' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419776'
                WHERE ordernumber = 'P180907124725995' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419778'
                WHERE ordernumber = 'P420907124928220' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216961'
                WHERE ordernumber = 'P190907125018306' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419779'
                WHERE ordernumber = 'P180907125243940' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351439'
                WHERE ordernumber = 'P190907125515199' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419781'
                WHERE ordernumber = 'P420907125516466' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419783'
                WHERE ordernumber = 'P420907125651521' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335196'
                WHERE ordernumber = 'P180907125740179' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386243'
                WHERE ordernumber = 'P180907125825269' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405430'
                WHERE ordernumber = 'P190907130104746' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396291'
                WHERE ordernumber = 'P420907130120281' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238090'
                WHERE ordernumber = 'P180907130131256' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419784'
                WHERE ordernumber = 'P180907130241148' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158680'
                WHERE ordernumber = 'P180907130342687' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418758'
                WHERE ordernumber = 'P420907130649651' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96074'
                WHERE ordernumber = 'P190907130900837' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99866'
                WHERE ordernumber = 'P190907131025390' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419785'
                WHERE ordernumber = 'P420907131117911' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392781'
                WHERE ordernumber = 'P180907131641278' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419788'
                WHERE ordernumber = 'P190907132025729' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419789'
                WHERE ordernumber = 'P420907132155924' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374969'
                WHERE ordernumber = 'P190907132252341' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417562'
                WHERE ordernumber = 'P420907132258915' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415876'
                WHERE ordernumber = 'P420907132443982' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419790'
                WHERE ordernumber = 'P420907132627154' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295295'
                WHERE ordernumber = 'P190907132635811' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419791'
                WHERE ordernumber = 'P420907132724493' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391382'
                WHERE ordernumber = 'P190907132819883' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419793'
                WHERE ordernumber = 'P420907133012292' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238012'
                WHERE ordernumber = 'P180907133352814' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419795'
                WHERE ordernumber = 'P420907133502227' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269120'
                WHERE ordernumber = 'P180907133529978' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419796'
                WHERE ordernumber = 'P190907133531164' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352892'
                WHERE ordernumber = 'P200907133701335' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419797'
                WHERE ordernumber = 'P420907133953788' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419798'
                WHERE ordernumber = 'P180907134231211' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414956'
                WHERE ordernumber = 'P420907134332356' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412050'
                WHERE ordernumber = 'P200907134418220' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417958'
                WHERE ordernumber = 'P420907134429466' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378678'
                WHERE ordernumber = 'P420907134611597' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419801'
                WHERE ordernumber = 'P200907134654144' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419802'
                WHERE ordernumber = 'P200907134904173' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418507'
                WHERE ordernumber = 'P420907134922860' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248077'
                WHERE ordernumber = 'P180907135118834' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250778'
                WHERE ordernumber = 'P180907135353592' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252313'
                WHERE ordernumber = 'P180907135433178' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307771'
                WHERE ordernumber = 'P190907135507712' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419800'
                WHERE ordernumber = 'P180907135546741' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387207'
                WHERE ordernumber = 'P420907135632275' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283263'
                WHERE ordernumber = 'P180907135642152' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215169'
                WHERE ordernumber = 'P200907135727217' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419803'
                WHERE ordernumber = 'P420907135944369' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328624'
                WHERE ordernumber = 'P180907140016113' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418833'
                WHERE ordernumber = 'P420907140249258' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419802'
                WHERE ordernumber = 'P200907140436404' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242818'
                WHERE ordernumber = 'P200907140710200' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128020'
                WHERE ordernumber = 'P190907140835673' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419781'
                WHERE ordernumber = 'P420907140913213' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413056'
                WHERE ordernumber = 'P200907140932449' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419804'
                WHERE ordernumber = 'P420907141026190' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413738'
                WHERE ordernumber = 'P200907141043770' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364706'
                WHERE ordernumber = 'P200907141241507' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419805'
                WHERE ordernumber = 'P420907141308245' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419807'
                WHERE ordernumber = 'P200907141658462' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390229'
                WHERE ordernumber = 'P200907141759310' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419808'
                WHERE ordernumber = 'P420907141859581' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255354'
                WHERE ordernumber = 'P200907141905193' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419809'
                WHERE ordernumber = 'P420907142003876' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419810'
                WHERE ordernumber = 'P200907142147181' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419811'
                WHERE ordernumber = 'P420907142158318' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252864'
                WHERE ordernumber = 'P180907142216466' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419812'
                WHERE ordernumber = 'P200907142354253' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419813'
                WHERE ordernumber = 'P420907142430206' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399522'
                WHERE ordernumber = 'P190907142450470' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405365'
                WHERE ordernumber = 'P180907142428933' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389004'
                WHERE ordernumber = 'P180907142534965' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416676'
                WHERE ordernumber = 'P200907142630137' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419814'
                WHERE ordernumber = 'P420907142653490' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416676'
                WHERE ordernumber = 'P200907142733414' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282048'
                WHERE ordernumber = 'P200907142948571' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399767'
                WHERE ordernumber = 'P200907143106625' 
            
2024-09-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246226'
                WHERE ordernumber = 'P200907143157935' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395053'
                WHERE ordernumber = 'P180907143212592' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132376'
                WHERE ordernumber = 'P180907143342141' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411931'
                WHERE ordernumber = 'P180907143533272' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142615'
                WHERE ordernumber = 'P200907143744150' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100197'
                WHERE ordernumber = 'P180907144121842' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310164'
                WHERE ordernumber = 'P200907144124931' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419676'
                WHERE ordernumber = 'P420907144300425' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136870'
                WHERE ordernumber = 'P200907144930698' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417714'
                WHERE ordernumber = 'P180907145459422' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419819'
                WHERE ordernumber = 'P200907145520249' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '178924'
                WHERE ordernumber = 'P180907145653248' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419820'
                WHERE ordernumber = 'P200907145735388' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385332'
                WHERE ordernumber = 'P420907150252185' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419821'
                WHERE ordernumber = 'P200907150415807' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88694'
                WHERE ordernumber = 'P180907150442528' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413120'
                WHERE ordernumber = 'P200907150551821' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413120'
                WHERE ordernumber = 'P200907150656514' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '77985'
                WHERE ordernumber = 'P630907150806801' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398917'
                WHERE ordernumber = 'P180907150825491' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419822'
                WHERE ordernumber = 'P420907150825766' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356715'
                WHERE ordernumber = 'P180907150950734' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385400'
                WHERE ordernumber = 'P180907151040734' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418988'
                WHERE ordernumber = 'P200907151044493' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217206'
                WHERE ordernumber = 'P190907151532670' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313877'
                WHERE ordernumber = 'P200907151823434' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419824'
                WHERE ordernumber = 'P420907151829276' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419826'
                WHERE ordernumber = 'P200907152105458' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324997'
                WHERE ordernumber = 'P180907152154547' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417408'
                WHERE ordernumber = 'P420907152202331' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111709'
                WHERE ordernumber = 'P180907152311191' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419827'
                WHERE ordernumber = 'P420907152406838' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373339'
                WHERE ordernumber = 'P200907152427448' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373339'
                WHERE ordernumber = 'P200907152500546' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410932'
                WHERE ordernumber = 'P420907152512669' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410932'
                WHERE ordernumber = 'P420907152602793' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410932'
                WHERE ordernumber = 'P420907152648332' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237482'
                WHERE ordernumber = 'P200907152648156' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '73536'
                WHERE ordernumber = 'P420907152831120' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419828'
                WHERE ordernumber = 'P200907152840860' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126582'
                WHERE ordernumber = 'P180907153214929' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418009'
                WHERE ordernumber = 'P420907153243521' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260853'
                WHERE ordernumber = 'P180907153559827' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419829'
                WHERE ordernumber = 'P420907153906937' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111387'
                WHERE ordernumber = 'P180907153917178' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385358'
                WHERE ordernumber = 'P190907154102145' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350923'
                WHERE ordernumber = 'P200907154304673' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419830'
                WHERE ordernumber = 'P180907154430821' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418913'
                WHERE ordernumber = 'P420907155049664' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94515'
                WHERE ordernumber = 'P180907155348981' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290554'
                WHERE ordernumber = 'P630907155853348' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '72152'
                WHERE ordernumber = 'P420907160351465' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '72152'
                WHERE ordernumber = 'P420907160450435' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348816'
                WHERE ordernumber = 'P200907160709478' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410281'
                WHERE ordernumber = 'P420907160754892' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419833'
                WHERE ordernumber = 'P180907160801379' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419834'
                WHERE ordernumber = 'P190907161134691' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419835'
                WHERE ordernumber = 'P190907161243564' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406801'
                WHERE ordernumber = 'P190907162432869' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128551'
                WHERE ordernumber = 'P190907162939210' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374936'
                WHERE ordernumber = 'P180907163131887' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374267'
                WHERE ordernumber = 'P420907163237608' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349248'
                WHERE ordernumber = 'P200907163341702' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404378'
                WHERE ordernumber = 'P420907163741962' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419840'
                WHERE ordernumber = 'P200907163808725' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207919'
                WHERE ordernumber = 'P180907163948161' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418226'
                WHERE ordernumber = 'P190907164100353' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419842'
                WHERE ordernumber = 'P180907164822420' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401442'
                WHERE ordernumber = 'P180907164926791' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161305'
                WHERE ordernumber = 'P200907165826373' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417787'
                WHERE ordernumber = 'P420907165937491' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419844'
                WHERE ordernumber = 'P180907171000809' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419842'
                WHERE ordernumber = 'P180907171301278' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419845'
                WHERE ordernumber = 'P420907171744590' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419847'
                WHERE ordernumber = 'P180907173128771' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419849'
                WHERE ordernumber = 'P420907173538497' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411012'
                WHERE ordernumber = 'P420907174316686' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419765'
                WHERE ordernumber = 'P420907174918811' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224229'
                WHERE ordernumber = 'P180907175759868' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416125'
                WHERE ordernumber = 'P420907175923158' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412202'
                WHERE ordernumber = 'P200907180605864' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154886'
                WHERE ordernumber = 'P420907180642987' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102337'
                WHERE ordernumber = 'P180907181907560' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294959'
                WHERE ordernumber = 'P420907182009930' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '44246'
                WHERE ordernumber = 'P180907182758939' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419853'
                WHERE ordernumber = 'P420907183131793' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335278'
                WHERE ordernumber = 'P420907183453440' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419854'
                WHERE ordernumber = 'P420907183619839' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105116'
                WHERE ordernumber = 'P200907184304940' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335460'
                WHERE ordernumber = 'P420907184610735' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335460'
                WHERE ordernumber = 'P420907184653285' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335460'
                WHERE ordernumber = 'P420907184721347' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411297'
                WHERE ordernumber = 'P630907184950629' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419859'
                WHERE ordernumber = 'P200907185417985' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419860'
                WHERE ordernumber = 'P420907185434168' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267401'
                WHERE ordernumber = 'P200907185520125' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419861'
                WHERE ordernumber = 'P200907190225560' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333672'
                WHERE ordernumber = 'P200907190545522' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P420907191050114' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P420907191253270' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416105'
                WHERE ordernumber = 'P180907195036520' 
            
2024-09-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '146348'
                WHERE ordernumber = 'P200907195905515'