2023-12-16 01:00:03 -- 將會員中心id寫入data-lake
2023-12-16 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-15%';
        
2023-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289499'
                WHERE ordernumber = 'P201215104226384' 
            
2023-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128338'
                WHERE ordernumber = 'P191215110122371' 
            
2023-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352532'
                WHERE ordernumber = 'P421215110454389' 
            
2023-12-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352533'
                WHERE ordernumber = 'P421215110852158' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273084'
                WHERE ordernumber = 'P201215111017847' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300204'
                WHERE ordernumber = 'P201215111057764' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307658'
                WHERE ordernumber = 'P421215111309817' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320337'
                WHERE ordernumber = 'P191215111349937' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280750'
                WHERE ordernumber = 'P201215111439990' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352536'
                WHERE ordernumber = 'P421215111630734' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352537'
                WHERE ordernumber = 'P191215111702386' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100706'
                WHERE ordernumber = 'P191215111824410' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352538'
                WHERE ordernumber = 'P201215112030944' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126820'
                WHERE ordernumber = 'P191215112047752' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295667'
                WHERE ordernumber = 'P421215112421422' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100896'
                WHERE ordernumber = 'P191215112437697' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352539'
                WHERE ordernumber = 'P201215112541673' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352540'
                WHERE ordernumber = 'P191215112552388' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114891'
                WHERE ordernumber = 'P181215112631665' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114891'
                WHERE ordernumber = 'P181215112703918' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97783'
                WHERE ordernumber = 'P181215112814390' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114891'
                WHERE ordernumber = 'P181215113107762' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114891'
                WHERE ordernumber = 'P181215113135753' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352542'
                WHERE ordernumber = 'P191215113453196' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352543'
                WHERE ordernumber = 'P421215113653603' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352545'
                WHERE ordernumber = 'P201215114027448' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352546'
                WHERE ordernumber = 'P181215114222735' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118631'
                WHERE ordernumber = 'P181215114349841' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276758'
                WHERE ordernumber = 'P181215114449608' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352547'
                WHERE ordernumber = 'P181215114840882' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352549'
                WHERE ordernumber = 'P421215115147195' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311532'
                WHERE ordernumber = 'P181215115317279' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346678'
                WHERE ordernumber = 'P201215115453136' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107391'
                WHERE ordernumber = 'P181215115551328' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352551'
                WHERE ordernumber = 'P201215115710198' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352552'
                WHERE ordernumber = 'P181215115725314' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339858'
                WHERE ordernumber = 'P201215115824678' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '31832'
                WHERE ordernumber = 'P201215115909679' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95205'
                WHERE ordernumber = 'P201215120201657' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352553'
                WHERE ordernumber = 'P201215120832586' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352554'
                WHERE ordernumber = 'P181215120834125' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352557'
                WHERE ordernumber = 'P181215121129804' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236637'
                WHERE ordernumber = 'P201215121142130' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352559'
                WHERE ordernumber = 'P191215121424729' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352560'
                WHERE ordernumber = 'P181215121524116' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317561'
                WHERE ordernumber = 'P181215121801237' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352563'
                WHERE ordernumber = 'P201215122059480' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302125'
                WHERE ordernumber = 'P201215122136776' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137990'
                WHERE ordernumber = 'P191215123221393' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303152'
                WHERE ordernumber = 'P201215123238350' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297787'
                WHERE ordernumber = 'P181215123456299' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '196719'
                WHERE ordernumber = 'P421215123533261' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352567'
                WHERE ordernumber = 'P181215123551511' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92224'
                WHERE ordernumber = 'P421215123747236' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275963'
                WHERE ordernumber = 'P421215123844349' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352569'
                WHERE ordernumber = 'P181215124304123' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94358'
                WHERE ordernumber = 'P201215124702736' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352572'
                WHERE ordernumber = 'P181215125251893' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352571'
                WHERE ordernumber = 'P201215125302122' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352574'
                WHERE ordernumber = 'P181215125504648' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352575'
                WHERE ordernumber = 'P201215125813663' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352576'
                WHERE ordernumber = 'P181215130031235' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352576'
                WHERE ordernumber = 'P181215130109681' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352577'
                WHERE ordernumber = 'P201215130139586' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '203511'
                WHERE ordernumber = 'P181215130200482' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352578'
                WHERE ordernumber = 'P201215130234739' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235645'
                WHERE ordernumber = 'P181215130514341' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352581'
                WHERE ordernumber = 'P181215131148651' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310335'
                WHERE ordernumber = 'P181215131301942' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352582'
                WHERE ordernumber = 'P421215131714517' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274683'
                WHERE ordernumber = 'P181215131743639' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299060'
                WHERE ordernumber = 'P201215132024848' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346698'
                WHERE ordernumber = 'P191215132957382' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352587'
                WHERE ordernumber = 'P191215133635928' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352588'
                WHERE ordernumber = 'P191215133802320' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352589'
                WHERE ordernumber = 'P201215133842476' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349079'
                WHERE ordernumber = 'P191215134047622' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352590'
                WHERE ordernumber = 'P201215134210430' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352591'
                WHERE ordernumber = 'P191215134503765' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352593'
                WHERE ordernumber = 'P201215134609239' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352047'
                WHERE ordernumber = 'P191215134610128' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352594'
                WHERE ordernumber = 'P201215135135591' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '62660'
                WHERE ordernumber = 'P181215135814824' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352596'
                WHERE ordernumber = 'P181215140408685' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352595'
                WHERE ordernumber = 'P181215140547186' 
            
2023-12-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352595'
                WHERE ordernumber = 'P181215140623178' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352598'
                WHERE ordernumber = 'P181215140729426' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352599'
                WHERE ordernumber = 'P181215140953801' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344300'
                WHERE ordernumber = 'P181215141306486' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352600'
                WHERE ordernumber = 'P181215141414994' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352601'
                WHERE ordernumber = 'P181215141519869' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345743'
                WHERE ordernumber = 'P201215141757530' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352602'
                WHERE ordernumber = 'P181215141951912' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248970'
                WHERE ordernumber = 'P201215142237323' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297233'
                WHERE ordernumber = 'P421215142609356' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350177'
                WHERE ordernumber = 'P421215143030406' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100793'
                WHERE ordernumber = 'P201215143214609' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350809'
                WHERE ordernumber = 'P181215143220224' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350809'
                WHERE ordernumber = 'P181215143320899' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81933'
                WHERE ordernumber = 'P201215143331135' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352604'
                WHERE ordernumber = 'P201215143621983' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352604'
                WHERE ordernumber = 'P201215143708193' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284853'
                WHERE ordernumber = 'P201215144327475' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81933'
                WHERE ordernumber = 'P201215144508692' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352608'
                WHERE ordernumber = 'P201215144828565' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300103'
                WHERE ordernumber = 'P421215144908535' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286963'
                WHERE ordernumber = 'P181215144924158' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343918'
                WHERE ordernumber = 'P181215145044210' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352610'
                WHERE ordernumber = 'P421215145314499' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352611'
                WHERE ordernumber = 'P181215145337321' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352612'
                WHERE ordernumber = 'P201215145345252' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '250232'
                WHERE ordernumber = 'P201215145529849' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352614'
                WHERE ordernumber = 'P181215145900674' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352616'
                WHERE ordernumber = 'P181215150728971' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352617'
                WHERE ordernumber = 'P201215150958773' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352619'
                WHERE ordernumber = 'P181215151139123' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352621'
                WHERE ordernumber = 'P181215151546987' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352620'
                WHERE ordernumber = 'P421215151615553' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352622'
                WHERE ordernumber = 'P181215151942621' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352623'
                WHERE ordernumber = 'P201215152356423' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P191215152421814' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352625'
                WHERE ordernumber = 'P191215152532415' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212340'
                WHERE ordernumber = 'P191215152650623' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '265708'
                WHERE ordernumber = 'P191215152748553' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285235'
                WHERE ordernumber = 'P191215153004395' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352626'
                WHERE ordernumber = 'P191215153158480' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254872'
                WHERE ordernumber = 'P191215153227401' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352627'
                WHERE ordernumber = 'P201215153305162' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345587'
                WHERE ordernumber = 'P191215153325637' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350341'
                WHERE ordernumber = 'P421215153339776' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352630'
                WHERE ordernumber = 'P201215153623190' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352631'
                WHERE ordernumber = 'P201215153713832' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345125'
                WHERE ordernumber = 'P191215153800899' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234151'
                WHERE ordernumber = 'P201215154100739' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352632'
                WHERE ordernumber = 'P421215154120375' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352633'
                WHERE ordernumber = 'P201215154154409' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352634'
                WHERE ordernumber = 'P201215154240686' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352635'
                WHERE ordernumber = 'P201215154443830' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352636'
                WHERE ordernumber = 'P201215154545688' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '62902'
                WHERE ordernumber = 'P191215154651240' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352637'
                WHERE ordernumber = 'P421215154750406' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352640'
                WHERE ordernumber = 'P421215155140641' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352641'
                WHERE ordernumber = 'P421215155342493' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342876'
                WHERE ordernumber = 'P191215155607918' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351584'
                WHERE ordernumber = 'P421215155700412' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352642'
                WHERE ordernumber = 'P191215155714776' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352643'
                WHERE ordernumber = 'P191215155829269' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '164613'
                WHERE ordernumber = 'P191215155918699' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310904'
                WHERE ordernumber = 'P421215155954802' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352644'
                WHERE ordernumber = 'P191215160311548' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '135594'
                WHERE ordernumber = 'P201215160616968' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352645'
                WHERE ordernumber = 'P191215160627998' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P191215160713648' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352646'
                WHERE ordernumber = 'P421215161035138' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352647'
                WHERE ordernumber = 'P191215161109344' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352648'
                WHERE ordernumber = 'P191215161702996' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352649'
                WHERE ordernumber = 'P191215161807803' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352650'
                WHERE ordernumber = 'P191215161924802' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352651'
                WHERE ordernumber = 'P421215162037240' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352654'
                WHERE ordernumber = 'P201215162701990' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352654'
                WHERE ordernumber = 'P201215162701990' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352656'
                WHERE ordernumber = 'P181215163304518' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352652'
                WHERE ordernumber = 'P181215163414258' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352652'
                WHERE ordernumber = 'P181215163529223' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293826'
                WHERE ordernumber = 'P201215163907183' 
            
2023-12-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '251560'
                WHERE ordernumber = 'P181215164338446' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352657'
                WHERE ordernumber = 'P181215164536842' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352658'
                WHERE ordernumber = 'P181215164653556' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352659'
                WHERE ordernumber = 'P181215164848755' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352660'
                WHERE ordernumber = 'P201215165017151' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '263337'
                WHERE ordernumber = 'P201215165136345' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '293690'
                WHERE ordernumber = 'P191215165328857' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352661'
                WHERE ordernumber = 'P191215165441603' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '116319'
                WHERE ordernumber = 'P191215165729120' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352158'
                WHERE ordernumber = 'P421215165946244' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352664'
                WHERE ordernumber = 'P421215170143131' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '119106'
                WHERE ordernumber = 'P191215170245539' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352665'
                WHERE ordernumber = 'P421215170442508' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352667'
                WHERE ordernumber = 'P181215170931563' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352668'
                WHERE ordernumber = 'P181215171415846' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352669'
                WHERE ordernumber = 'P181215171804983' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352671'
                WHERE ordernumber = 'P181215172135243' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '94461'
                WHERE ordernumber = 'P181215172619387' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352672'
                WHERE ordernumber = 'P181215172800133' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352674'
                WHERE ordernumber = 'P181215173121981' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352675'
                WHERE ordernumber = 'P181215173304351' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352677'
                WHERE ordernumber = 'P201215173318117' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352678'
                WHERE ordernumber = 'P181215173419193' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '312777'
                WHERE ordernumber = 'P181215173724664' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '17708'
                WHERE ordernumber = 'P201215174104986' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '215833'
                WHERE ordernumber = 'P181215174120940' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352683'
                WHERE ordernumber = 'P181215174548529' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '154617'
                WHERE ordernumber = 'P201215174555729' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '131290'
                WHERE ordernumber = 'P181215175450488' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352684'
                WHERE ordernumber = 'P421215175506733' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352686'
                WHERE ordernumber = 'P201215175753195' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P181215175935570' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352688'
                WHERE ordernumber = 'P181215180307986' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '213101'
                WHERE ordernumber = 'P201215180410895' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '129353'
                WHERE ordernumber = 'P181215180511847' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352689'
                WHERE ordernumber = 'P181215180608498' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '91679'
                WHERE ordernumber = 'P201215180743366' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352690'
                WHERE ordernumber = 'P201215180915694' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352691'
                WHERE ordernumber = 'P181215181140322' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352692'
                WHERE ordernumber = 'P181215181309230' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352693'
                WHERE ordernumber = 'P181215181409823' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352695'
                WHERE ordernumber = 'P181215181623884' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '348484'
                WHERE ordernumber = 'P201215181632137' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '347408'
                WHERE ordernumber = 'P181215181701193' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352696'
                WHERE ordernumber = 'P181215181812197' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352697'
                WHERE ordernumber = 'P181215181912464' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352699'
                WHERE ordernumber = 'P181215182239254' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '265842'
                WHERE ordernumber = 'P421215182517750' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352257'
                WHERE ordernumber = 'P201215182735487' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352178'
                WHERE ordernumber = 'P181215182747649' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '309643'
                WHERE ordernumber = 'P181215182921577' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '196771'
                WHERE ordernumber = 'P191215183055958' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '287102'
                WHERE ordernumber = 'P191215183154550' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350014'
                WHERE ordernumber = 'P201215183252946' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350014'
                WHERE ordernumber = 'P201215183451326' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '129909'
                WHERE ordernumber = 'P191215183515338' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '300665'
                WHERE ordernumber = 'P421215183522878' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352700'
                WHERE ordernumber = 'P201215183558718' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352701'
                WHERE ordernumber = 'P191215183905667' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '346646'
                WHERE ordernumber = 'P191215184125349' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352702'
                WHERE ordernumber = 'P201215184241376' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352703'
                WHERE ordernumber = 'P191215184258477' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '217062'
                WHERE ordernumber = 'P191215184345901' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '255745'
                WHERE ordernumber = 'P201215184426888' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352705'
                WHERE ordernumber = 'P191215184455990' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352706'
                WHERE ordernumber = 'P191215184618720' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352708'
                WHERE ordernumber = 'P191215184807320' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '218428'
                WHERE ordernumber = 'P421215184858557' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352709'
                WHERE ordernumber = 'P201215185026414' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '288395'
                WHERE ordernumber = 'P191215185132122' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '299342'
                WHERE ordernumber = 'P421215185212158' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '340828'
                WHERE ordernumber = 'P201215185512611' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '278839'
                WHERE ordernumber = 'P191215185540288' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352711'
                WHERE ordernumber = 'P191215185652147' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350446'
                WHERE ordernumber = 'P191215185903474' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '297993'
                WHERE ordernumber = 'P201215185939707' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352713'
                WHERE ordernumber = 'P191215190042866' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352714'
                WHERE ordernumber = 'P201215190110161' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '124068'
                WHERE ordernumber = 'P191215190121141' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '294187'
                WHERE ordernumber = 'P421215190159639' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352714'
                WHERE ordernumber = 'P201215190245729' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352713'
                WHERE ordernumber = 'P191215190319779' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352715'
                WHERE ordernumber = 'P191215190505743' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '276480'
                WHERE ordernumber = 'P421215190622998' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350911'
                WHERE ordernumber = 'P201215190656771' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P191215190901470' 
            
2023-12-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352716'
                WHERE ordernumber = 'P421215190927212' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '227749'
                WHERE ordernumber = 'P201215191048955' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '352717'
                WHERE ordernumber = 'P191215191107396' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '352718'
                WHERE ordernumber = 'P191215191501235' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '352718'
                WHERE ordernumber = 'P191215191528637' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '352719'
                WHERE ordernumber = 'P201215191605633' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '352720'
                WHERE ordernumber = 'P421215191748252' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '277953'
                WHERE ordernumber = 'P201215192224943' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '352723'
                WHERE ordernumber = 'P191215193113846' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '352725'
                WHERE ordernumber = 'P191215193341794' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '336056'
                WHERE ordernumber = 'P201215194014469' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '352727'
                WHERE ordernumber = 'P201215194127882' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '304033'
                WHERE ordernumber = 'P201215195736433' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '289391'
                WHERE ordernumber = 'P191215195854601' 
            
2023-12-16 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '109690'
                WHERE ordernumber = 'P191215200127137'