2023-12-02 01:00:03 -- 將會員中心id寫入data-lake
2023-12-02 01:00:03 -- 
            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 '2023-12-01%';
        
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349239'
                WHERE ordernumber = 'P181201110225748' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230454'
                WHERE ordernumber = 'P181201110514439' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231698'
                WHERE ordernumber = 'P181201110606119' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231119'
                WHERE ordernumber = 'P421201110833864' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233981'
                WHERE ordernumber = 'P201201110930218' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350131'
                WHERE ordernumber = 'P191201111253692' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350132'
                WHERE ordernumber = 'P181201111424608' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346416'
                WHERE ordernumber = 'P181201111524286' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350131'
                WHERE ordernumber = 'P191201111630148' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350133'
                WHERE ordernumber = 'P421201111804441' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249654'
                WHERE ordernumber = 'P191201111840635' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350134'
                WHERE ordernumber = 'P191201112057335' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350135'
                WHERE ordernumber = 'P421201112130725' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350136'
                WHERE ordernumber = 'P191201112201191' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158510'
                WHERE ordernumber = 'P181201112249850' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105563'
                WHERE ordernumber = 'P191201112340706' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337999'
                WHERE ordernumber = 'P201201112844758' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289684'
                WHERE ordernumber = 'P181201112851948' 
            
2023-12-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350138'
                WHERE ordernumber = 'P191201113853412' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240185'
                WHERE ordernumber = 'P181201113908453' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133280'
                WHERE ordernumber = 'P181201114500128' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350140'
                WHERE ordernumber = 'P181201114745196' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100574'
                WHERE ordernumber = 'P201201114810725' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350141'
                WHERE ordernumber = 'P191201114921781' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350142'
                WHERE ordernumber = 'P421201114928956' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328201'
                WHERE ordernumber = 'P181201114936365' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221223'
                WHERE ordernumber = 'P201201115828225' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350144'
                WHERE ordernumber = 'P421201115946351' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350145'
                WHERE ordernumber = 'P421201120251811' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350146'
                WHERE ordernumber = 'P421201120555239' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275123'
                WHERE ordernumber = 'P191201120856994' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275181'
                WHERE ordernumber = 'P191201121028747' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350147'
                WHERE ordernumber = 'P421201121035611' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '146104'
                WHERE ordernumber = 'P201201121255643' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223891'
                WHERE ordernumber = 'P181201121715222' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322169'
                WHERE ordernumber = 'P191201122622939' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '32144'
                WHERE ordernumber = 'P421201123001786' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345729'
                WHERE ordernumber = 'P181201123102939' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350148'
                WHERE ordernumber = 'P421201123227427' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350149'
                WHERE ordernumber = 'P181201123357394' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350150'
                WHERE ordernumber = 'P201201123903273' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98265'
                WHERE ordernumber = 'P181201123918565' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346311'
                WHERE ordernumber = 'P181201124437273' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350152'
                WHERE ordernumber = 'P191201124651783' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236420'
                WHERE ordernumber = 'P421201124725762' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350153'
                WHERE ordernumber = 'P201201125008392' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350155'
                WHERE ordernumber = 'P421201125431859' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140799'
                WHERE ordernumber = 'P201201130055234' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350158'
                WHERE ordernumber = 'P191201131657725' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323640'
                WHERE ordernumber = 'P421201131905456' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350159'
                WHERE ordernumber = 'P181201132156266' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274667'
                WHERE ordernumber = 'P191201133322430' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350162'
                WHERE ordernumber = 'P181201133616227' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252779'
                WHERE ordernumber = 'P181201133838752' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348880'
                WHERE ordernumber = 'P181201134424811' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350164'
                WHERE ordernumber = 'P181201134802640' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350166'
                WHERE ordernumber = 'P421201135010546' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350165'
                WHERE ordernumber = 'P191201135047556' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350167'
                WHERE ordernumber = 'P181201135234315' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263282'
                WHERE ordernumber = 'P421201135427524' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '156098'
                WHERE ordernumber = 'P201201135608941' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350168'
                WHERE ordernumber = 'P191201135719466' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350169'
                WHERE ordernumber = 'P201201140109544' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350170'
                WHERE ordernumber = 'P191201140218993' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307329'
                WHERE ordernumber = 'P191201140525851' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237422'
                WHERE ordernumber = 'P191201141128435' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350172'
                WHERE ordernumber = 'P191201141342410' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350171'
                WHERE ordernumber = 'P181201141404899' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283767'
                WHERE ordernumber = 'P201201141718241' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297388'
                WHERE ordernumber = 'P421201141742600' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '134877'
                WHERE ordernumber = 'P201201142317590' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350174'
                WHERE ordernumber = 'P191201142355199' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '202092'
                WHERE ordernumber = 'P201201142838159' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '202092'
                WHERE ordernumber = 'P201201143014601' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339680'
                WHERE ordernumber = 'P421201143248717' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350176'
                WHERE ordernumber = 'P181201143335712' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350177'
                WHERE ordernumber = 'P421201143602350' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350178'
                WHERE ordernumber = 'P201201143856350' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327485'
                WHERE ordernumber = 'P201201144034437' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350179'
                WHERE ordernumber = 'P421201144055860' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118273'
                WHERE ordernumber = 'P181201144144637' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114545'
                WHERE ordernumber = 'P181201144801604' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291320'
                WHERE ordernumber = 'P181201144904860' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216090'
                WHERE ordernumber = 'P201201145310731' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350181'
                WHERE ordernumber = 'P191201145335767' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304578'
                WHERE ordernumber = 'P421201150224488' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240068'
                WHERE ordernumber = 'P191201150239764' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119701'
                WHERE ordernumber = 'P201201150251407' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101791'
                WHERE ordernumber = 'P201201150519792' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277354'
                WHERE ordernumber = 'P181201150908461' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350183'
                WHERE ordernumber = 'P421201151256899' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350185'
                WHERE ordernumber = 'P181201152425276' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334015'
                WHERE ordernumber = 'P201201152621785' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350188'
                WHERE ordernumber = 'P181201152857975' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350187'
                WHERE ordernumber = 'P191201152901312' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99659'
                WHERE ordernumber = 'P181201153016157' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346770'
                WHERE ordernumber = 'P201201153409161' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238422'
                WHERE ordernumber = 'P191201153413223' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98423'
                WHERE ordernumber = 'P201201153455934' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350190'
                WHERE ordernumber = 'P191201153611831' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346770'
                WHERE ordernumber = 'P201201153805550' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248480'
                WHERE ordernumber = 'P191201153905695' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287310'
                WHERE ordernumber = 'P421201153917691' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232119'
                WHERE ordernumber = 'P191201154211920' 
            
2023-12-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299907'
                WHERE ordernumber = 'P421201154524512' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350193'
                WHERE ordernumber = 'P201201155107418' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350194'
                WHERE ordernumber = 'P421201155233629' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350196'
                WHERE ordernumber = 'P191201155457217' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222730'
                WHERE ordernumber = 'P191201160008330' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '290328'
                WHERE ordernumber = 'P181201160237973' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350199'
                WHERE ordernumber = 'P191201160840386' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350201'
                WHERE ordernumber = 'P191201161157419' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350202'
                WHERE ordernumber = 'P421201161500865' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297170'
                WHERE ordernumber = 'P201201161533721' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350200'
                WHERE ordernumber = 'P181201161637988' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350203'
                WHERE ordernumber = 'P181201161806865' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105869'
                WHERE ordernumber = 'P201201161825926' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '143271'
                WHERE ordernumber = 'P181201161908555' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350204'
                WHERE ordernumber = 'P181201162438410' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350206'
                WHERE ordernumber = 'P181201163206134' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338630'
                WHERE ordernumber = 'P201201163214436' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350207'
                WHERE ordernumber = 'P181201163324193' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231037'
                WHERE ordernumber = 'P201201163602678' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346545'
                WHERE ordernumber = 'P181201163712685' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350209'
                WHERE ordernumber = 'P201201163847299' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208804'
                WHERE ordernumber = 'P181201164140878' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350211'
                WHERE ordernumber = 'P181201164731154' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350212'
                WHERE ordernumber = 'P181201165017371' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287386'
                WHERE ordernumber = 'P181201165418910' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350213'
                WHERE ordernumber = 'P181201165611499' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350215'
                WHERE ordernumber = 'P181201170542973' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '315224'
                WHERE ordernumber = 'P181201170659584' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240974'
                WHERE ordernumber = 'P181201170832602' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '309611'
                WHERE ordernumber = 'P201201170842707' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350216'
                WHERE ordernumber = 'P181201171252774' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350218'
                WHERE ordernumber = 'P181201171731457' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P191201172140647' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286596'
                WHERE ordernumber = 'P181201172221298' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286596'
                WHERE ordernumber = 'P181201172326587' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96092'
                WHERE ordernumber = 'P191201172408912' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350219'
                WHERE ordernumber = 'P191201172545635' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218428'
                WHERE ordernumber = 'P421201172619186' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350220'
                WHERE ordernumber = 'P201201172710509' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317194'
                WHERE ordernumber = 'P181201172803427' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350221'
                WHERE ordernumber = 'P181201173011207' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350222'
                WHERE ordernumber = 'P181201173205685' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350223'
                WHERE ordernumber = 'P201201173217317' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '88468'
                WHERE ordernumber = 'P421201173414723' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350224'
                WHERE ordernumber = 'P181201173509460' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350225'
                WHERE ordernumber = 'P201201174247451' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245869'
                WHERE ordernumber = 'P181201174310714' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346628'
                WHERE ordernumber = 'P181201174354208' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350226'
                WHERE ordernumber = 'P201201174526824' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350227'
                WHERE ordernumber = 'P181201174657149' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338700'
                WHERE ordernumber = 'P421201174914654' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234402'
                WHERE ordernumber = 'P201201174959121' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348463'
                WHERE ordernumber = 'P181201175126743' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344474'
                WHERE ordernumber = 'P181201175243640' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232783'
                WHERE ordernumber = 'P181201175406902' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247917'
                WHERE ordernumber = 'P201201175420134' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346763'
                WHERE ordernumber = 'P181201175858512' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350230'
                WHERE ordernumber = 'P201201180741216' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350231'
                WHERE ordernumber = 'P181201181037913' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237236'
                WHERE ordernumber = 'P421201181424448' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350232'
                WHERE ordernumber = 'P181201181439576' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350233'
                WHERE ordernumber = 'P181201181710959' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313314'
                WHERE ordernumber = 'P421201182515411' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '255832'
                WHERE ordernumber = 'P181201182557969' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350234'
                WHERE ordernumber = 'P421201183723849' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236244'
                WHERE ordernumber = 'P201201183805520' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299342'
                WHERE ordernumber = 'P421201184205908' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167388'
                WHERE ordernumber = 'P201201184259499' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '213925'
                WHERE ordernumber = 'P191201184425869' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214414'
                WHERE ordernumber = 'P191201184514337' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '138580'
                WHERE ordernumber = 'P191201184641115' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306198'
                WHERE ordernumber = 'P191201184906335' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347329'
                WHERE ordernumber = 'P201201185258906' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350236'
                WHERE ordernumber = 'P191201185350630' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350237'
                WHERE ordernumber = 'P191201185524945' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340828'
                WHERE ordernumber = 'P201201185710729' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '320829'
                WHERE ordernumber = 'P191201185830780' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350238'
                WHERE ordernumber = 'P191201190134991' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '123995'
                WHERE ordernumber = 'P191201190530596' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347653'
                WHERE ordernumber = 'P201201190622212' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350240'
                WHERE ordernumber = 'P421201190957220' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288989'
                WHERE ordernumber = 'P201201191455322' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350243'
                WHERE ordernumber = 'P201201192955796' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350244'
                WHERE ordernumber = 'P421201193352592' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350245'
                WHERE ordernumber = 'P201201193636655' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293814'
                WHERE ordernumber = 'P201201193902189' 
            
2023-12-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273839'
                WHERE ordernumber = 'P201201194009807' 
            
2023-12-02 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350246'
                WHERE ordernumber = 'P421201194337543' 
            
2023-12-02 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '260446'
                WHERE ordernumber = 'P201201194345516' 
            
2023-12-02 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '346398'
                WHERE ordernumber = 'P421201194805868' 
            
2023-12-02 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '4568'
                WHERE ordernumber = 'P201201194819641' 
            
2023-12-02 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350247'
                WHERE ordernumber = 'P201201194928665' 
            
2023-12-02 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '146294'
                WHERE ordernumber = 'P201201195323419' 
            
2023-12-02 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '209032'
                WHERE ordernumber = 'P191201200101594'