2023-12-21 01:00:02 -- 將會員中心id寫入data-lake
2023-12-21 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 '2023-12-20%';
        
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242353'
                WHERE ordernumber = 'P191220110742812' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242353'
                WHERE ordernumber = 'P191220110823221' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242353'
                WHERE ordernumber = 'P191220110921763' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129356'
                WHERE ordernumber = 'P191220111542577' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342639'
                WHERE ordernumber = 'P191220112129581' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344166'
                WHERE ordernumber = 'P191220112432797' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353649'
                WHERE ordernumber = 'P191220112616120' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99761'
                WHERE ordernumber = 'P191220112636436' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '168335'
                WHERE ordernumber = 'P191220112739889' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206570'
                WHERE ordernumber = 'P191220113106716' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353651'
                WHERE ordernumber = 'P201220113247455' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353652'
                WHERE ordernumber = 'P191220113313785' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '207104'
                WHERE ordernumber = 'P191220113348381' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353653'
                WHERE ordernumber = 'P191220113707216' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231945'
                WHERE ordernumber = 'P191220113823827' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287869'
                WHERE ordernumber = 'P191220113908319' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219133'
                WHERE ordernumber = 'P201220113915892' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '57766'
                WHERE ordernumber = 'P421220114526931' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352671'
                WHERE ordernumber = 'P191220114658355' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353655'
                WHERE ordernumber = 'P191220114805571' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353655'
                WHERE ordernumber = 'P191220114839631' 
            
2023-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353658'
                WHERE ordernumber = 'P191220115751226' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353659'
                WHERE ordernumber = 'P191220115903137' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353661'
                WHERE ordernumber = 'P191220120227312' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97778'
                WHERE ordernumber = 'P191220120419709' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353660'
                WHERE ordernumber = 'P201220120626314' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353660'
                WHERE ordernumber = 'P201220120642305' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353662'
                WHERE ordernumber = 'P191220120923526' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353099'
                WHERE ordernumber = 'P201220120953932' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243600'
                WHERE ordernumber = 'P201220121051458' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353665'
                WHERE ordernumber = 'P191220121256753' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319393'
                WHERE ordernumber = 'P421220121325945' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P181220121755804' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353666'
                WHERE ordernumber = 'P421220121829600' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353668'
                WHERE ordernumber = 'P191220121919911' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340830'
                WHERE ordernumber = 'P191220122244450' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238440'
                WHERE ordernumber = 'P191220122430536' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348065'
                WHERE ordernumber = 'P421220122721644' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277379'
                WHERE ordernumber = 'P191220122939922' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240577'
                WHERE ordernumber = 'P191220123321782' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353672'
                WHERE ordernumber = 'P201220123654413' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353674'
                WHERE ordernumber = 'P191220123724707' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86775'
                WHERE ordernumber = 'P191220123815868' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286180'
                WHERE ordernumber = 'P421220124206718' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353677'
                WHERE ordernumber = 'P191220124544352' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353678'
                WHERE ordernumber = 'P201220124645875' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353679'
                WHERE ordernumber = 'P191220124700308' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295822'
                WHERE ordernumber = 'P181220124835971' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353680'
                WHERE ordernumber = 'P191220124858732' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353681'
                WHERE ordernumber = 'P201220125319880' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353683'
                WHERE ordernumber = 'P201220125738847' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353684'
                WHERE ordernumber = 'P421220130008824' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326368'
                WHERE ordernumber = 'P191220130041463' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353684'
                WHERE ordernumber = 'P421220130202507' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353686'
                WHERE ordernumber = 'P191220130315910' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353687'
                WHERE ordernumber = 'P191220130423893' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225810'
                WHERE ordernumber = 'P201220130533951' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299086'
                WHERE ordernumber = 'P181220130545154' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249092'
                WHERE ordernumber = 'P201220130634194' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334778'
                WHERE ordernumber = 'P421220130643715' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353408'
                WHERE ordernumber = 'P201220131335370' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217198'
                WHERE ordernumber = 'P191220131353852' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353690'
                WHERE ordernumber = 'P421220131507165' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277012'
                WHERE ordernumber = 'P201220131602665' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277012'
                WHERE ordernumber = 'P201220131657969' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344399'
                WHERE ordernumber = 'P421220132001790' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226172'
                WHERE ordernumber = 'P201220132833793' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326727'
                WHERE ordernumber = 'P421220133936555' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353694'
                WHERE ordernumber = 'P181220134137799' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353696'
                WHERE ordernumber = 'P191220134449548' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353697'
                WHERE ordernumber = 'P201220135000402' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101522'
                WHERE ordernumber = 'P201220135045592' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100292'
                WHERE ordernumber = 'P191220135137521' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353699'
                WHERE ordernumber = 'P201220135753802' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105116'
                WHERE ordernumber = 'P201220140246893' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266868'
                WHERE ordernumber = 'P201220140435840' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111723'
                WHERE ordernumber = 'P181220141410679' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353701'
                WHERE ordernumber = 'P181220141544398' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218548'
                WHERE ordernumber = 'P201220141546660' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P201220141638905' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333958'
                WHERE ordernumber = 'P201220142400896' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353703'
                WHERE ordernumber = 'P201220142542408' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277313'
                WHERE ordernumber = 'P191220142704487' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340303'
                WHERE ordernumber = 'P181220143252147' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242008'
                WHERE ordernumber = 'P201220143536657' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232832'
                WHERE ordernumber = 'P201220143830547' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331428'
                WHERE ordernumber = 'P421220144052378' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353705'
                WHERE ordernumber = 'P201220144139623' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '177234'
                WHERE ordernumber = 'P201220144325218' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353706'
                WHERE ordernumber = 'P181220144346780' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353707'
                WHERE ordernumber = 'P201220144409421' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353708'
                WHERE ordernumber = 'P181220144501619' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353711'
                WHERE ordernumber = 'P181220144630236' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322226'
                WHERE ordernumber = 'P201220145116220' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353713'
                WHERE ordernumber = 'P201220145711530' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353714'
                WHERE ordernumber = 'P181220150234353' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168576'
                WHERE ordernumber = 'P201220150410265' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353715'
                WHERE ordernumber = 'P181220150418520' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95776'
                WHERE ordernumber = 'P201220150501797' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268778'
                WHERE ordernumber = 'P201220150552171' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353717'
                WHERE ordernumber = 'P181220150753846' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '148024'
                WHERE ordernumber = 'P181220151321430' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108630'
                WHERE ordernumber = 'P181220151523725' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263553'
                WHERE ordernumber = 'P181220151941812' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '152411'
                WHERE ordernumber = 'P191220151952619' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236861'
                WHERE ordernumber = 'P191220152139412' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306059'
                WHERE ordernumber = 'P201220152224850' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81078'
                WHERE ordernumber = 'P191220152233934' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112328'
                WHERE ordernumber = 'P181220152255364' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212720'
                WHERE ordernumber = 'P181220152422130' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353719'
                WHERE ordernumber = 'P181220152632818' 
            
2023-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353719'
                WHERE ordernumber = 'P181220152703810' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353721'
                WHERE ordernumber = 'P181220152851476' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90971'
                WHERE ordernumber = 'P181220152947573' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346054'
                WHERE ordernumber = 'P181220153357698' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353723'
                WHERE ordernumber = 'P181220153542938' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353722'
                WHERE ordernumber = 'P421220153648581' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353724'
                WHERE ordernumber = 'P201220153734310' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319914'
                WHERE ordernumber = 'P201220153812121' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353725'
                WHERE ordernumber = 'P181220153947717' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353727'
                WHERE ordernumber = 'P181220154128960' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353726'
                WHERE ordernumber = 'P421220154151438' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353729'
                WHERE ordernumber = 'P201220154326711' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353731'
                WHERE ordernumber = 'P181220154732434' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353732'
                WHERE ordernumber = 'P181220155016986' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323973'
                WHERE ordernumber = 'P181220155412173' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240384'
                WHERE ordernumber = 'P201220155557228' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353731'
                WHERE ordernumber = 'P181220155605706' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353733'
                WHERE ordernumber = 'P201220160018793' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339860'
                WHERE ordernumber = 'P421220160043732' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353734'
                WHERE ordernumber = 'P181220160052928' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245369'
                WHERE ordernumber = 'P201220160447431' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353738'
                WHERE ordernumber = 'P201220160641857' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353740'
                WHERE ordernumber = 'P421220160921539' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109155'
                WHERE ordernumber = 'P181220161028568' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234709'
                WHERE ordernumber = 'P181220161340494' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353743'
                WHERE ordernumber = 'P201220161554833' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136987'
                WHERE ordernumber = 'P201220161704950' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353745'
                WHERE ordernumber = 'P181220161744562' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P181220162028671' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353746'
                WHERE ordernumber = 'P201220162257125' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353747'
                WHERE ordernumber = 'P181220162325292' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353750'
                WHERE ordernumber = 'P181220162511212' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353745'
                WHERE ordernumber = 'P181220162537125' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307113'
                WHERE ordernumber = 'P421220162610591' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352028'
                WHERE ordernumber = 'P201220162630488' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353751'
                WHERE ordernumber = 'P181220162716452' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353752'
                WHERE ordernumber = 'P181220163121582' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353753'
                WHERE ordernumber = 'P181220163246216' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353754'
                WHERE ordernumber = 'P181220163419171' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240006'
                WHERE ordernumber = 'P201220163421984' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353756'
                WHERE ordernumber = 'P181220163511749' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353757'
                WHERE ordernumber = 'P201220163551377' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114594'
                WHERE ordernumber = 'P181220163651196' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353758'
                WHERE ordernumber = 'P191220163713947' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353759'
                WHERE ordernumber = 'P181220164042151' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353760'
                WHERE ordernumber = 'P191220164221701' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353745'
                WHERE ordernumber = 'P181220164248854' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353764'
                WHERE ordernumber = 'P181220164432680' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353765'
                WHERE ordernumber = 'P421220164650344' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353767'
                WHERE ordernumber = 'P181220164828355' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239887'
                WHERE ordernumber = 'P201220164856180' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353768'
                WHERE ordernumber = 'P181220165132984' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353761'
                WHERE ordernumber = 'P181220165219844' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342339'
                WHERE ordernumber = 'P421220165256822' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353769'
                WHERE ordernumber = 'P201220165841599' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353771'
                WHERE ordernumber = 'P201220170025355' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275636'
                WHERE ordernumber = 'P201220170936535' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282362'
                WHERE ordernumber = 'P191220170941739' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353773'
                WHERE ordernumber = 'P201220171037298' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353778'
                WHERE ordernumber = 'P201220172106743' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214419'
                WHERE ordernumber = 'P191220172422541' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214419'
                WHERE ordernumber = 'P191220172711278' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353034'
                WHERE ordernumber = 'P191220173129804' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353779'
                WHERE ordernumber = 'P421220173331645' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346628'
                WHERE ordernumber = 'P181220173351656' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212237'
                WHERE ordernumber = 'P181220173752265' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353340'
                WHERE ordernumber = 'P181220174014325' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353782'
                WHERE ordernumber = 'P421220174157163' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353784'
                WHERE ordernumber = 'P181220174551507' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221817'
                WHERE ordernumber = 'P201220174833543' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311267'
                WHERE ordernumber = 'P201220175228670' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353787'
                WHERE ordernumber = 'P181220175430773' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353782'
                WHERE ordernumber = 'P421220175513316' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221617'
                WHERE ordernumber = 'P201220175736899' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353789'
                WHERE ordernumber = 'P181220180338522' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P181220180448890' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291748'
                WHERE ordernumber = 'P201220180758556' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353790'
                WHERE ordernumber = 'P181220180920474' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230870'
                WHERE ordernumber = 'P181220181115636' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118593'
                WHERE ordernumber = 'P191220181258746' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346784'
                WHERE ordernumber = 'P181220181306666' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232397'
                WHERE ordernumber = 'P201220181622993' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353792'
                WHERE ordernumber = 'P181220181629181' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248374'
                WHERE ordernumber = 'P201220182039816' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353793'
                WHERE ordernumber = 'P181220182124993' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294166'
                WHERE ordernumber = 'P201220182148840' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342831'
                WHERE ordernumber = 'P201220182228200' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353794'
                WHERE ordernumber = 'P181220182519845' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353795'
                WHERE ordernumber = 'P181220182640762' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322389'
                WHERE ordernumber = 'P191220182805751' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353799'
                WHERE ordernumber = 'P201220183140694' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353800'
                WHERE ordernumber = 'P201220183528245' 
            
2023-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284699'
                WHERE ordernumber = 'P191220183700902' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353801'
                WHERE ordernumber = 'P421220183751858' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353804'
                WHERE ordernumber = 'P421220184141446' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276855'
                WHERE ordernumber = 'P201220184223740' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353805'
                WHERE ordernumber = 'P201220184322346' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353806'
                WHERE ordernumber = 'P191220184335234' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '153378'
                WHERE ordernumber = 'P201220184406738' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353807'
                WHERE ordernumber = 'P421220184549150' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242226'
                WHERE ordernumber = 'P201220184555122' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353808'
                WHERE ordernumber = 'P191220184654915' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353809'
                WHERE ordernumber = 'P201220184839661' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347910'
                WHERE ordernumber = 'P421220184858536' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238186'
                WHERE ordernumber = 'P201220185109855' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P201220185300768' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101562'
                WHERE ordernumber = 'P201220185423265' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353810'
                WHERE ordernumber = 'P191220185434117' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101562'
                WHERE ordernumber = 'P201220185444227' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353810'
                WHERE ordernumber = 'P191220190104290' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353812'
                WHERE ordernumber = 'P201220190300282' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353194'
                WHERE ordernumber = 'P191220190310916' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353814'
                WHERE ordernumber = 'P421220190411704' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353815'
                WHERE ordernumber = 'P201220190418883' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353818'
                WHERE ordernumber = 'P191220190518552' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '256181'
                WHERE ordernumber = 'P191220191011387' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353819'
                WHERE ordernumber = 'P421220191246668' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353820'
                WHERE ordernumber = 'P421220191430475' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '119612'
                WHERE ordernumber = 'P191220191840334' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353824'
                WHERE ordernumber = 'P421220192102302' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353827'
                WHERE ordernumber = 'P201220194541519' 
            
2023-12-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104898'
                WHERE ordernumber = 'P201220194818568'