2024-08-22 01:00:02 -- 將會員中心id寫入data-lake
2024-08-22 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-08-21%';
        
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404262'
                WHERE ordernumber = 'P180821110238761' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237298'
                WHERE ordernumber = 'P180821110446510' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372408'
                WHERE ordernumber = 'P420821110526193' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269473'
                WHERE ordernumber = 'P200821110534205' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411412'
                WHERE ordernumber = 'P200821110835171' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411413'
                WHERE ordernumber = 'P190821110925601' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229958'
                WHERE ordernumber = 'P200821110929256' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410422'
                WHERE ordernumber = 'P180821111156794' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411418'
                WHERE ordernumber = 'P180821111641219' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350876'
                WHERE ordernumber = 'P200821111815752' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411419'
                WHERE ordernumber = 'P190821111819194' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411420'
                WHERE ordernumber = 'P180821111819542' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383567'
                WHERE ordernumber = 'P180821112028929' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253286'
                WHERE ordernumber = 'P180821112201699' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411425'
                WHERE ordernumber = 'P200821112519402' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411277'
                WHERE ordernumber = 'P180821112628225' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393007'
                WHERE ordernumber = 'P190821112746869' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385059'
                WHERE ordernumber = 'P190821112858833' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P200821112929869' 
            
2024-08-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200821113030320' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411429'
                WHERE ordernumber = 'P420821113035590' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296511'
                WHERE ordernumber = 'P420821113156365' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411431'
                WHERE ordernumber = 'P420821113412872' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259238'
                WHERE ordernumber = 'P200821113855997' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267579'
                WHERE ordernumber = 'P180821114227504' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411440'
                WHERE ordernumber = 'P180821114606586' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411443'
                WHERE ordernumber = 'P180821115233794' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402552'
                WHERE ordernumber = 'P420821115240537' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411446'
                WHERE ordernumber = 'P180821115416426' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411448'
                WHERE ordernumber = 'P420821115744520' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411450'
                WHERE ordernumber = 'P420821120146482' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411451'
                WHERE ordernumber = 'P200821120358466' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215525'
                WHERE ordernumber = 'P180821120727605' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '120922'
                WHERE ordernumber = 'P180821120932979' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206819'
                WHERE ordernumber = 'P190821121230964' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411457'
                WHERE ordernumber = 'P200821121311220' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206819'
                WHERE ordernumber = 'P190821121334622' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206819'
                WHERE ordernumber = 'P190821121457370' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206819'
                WHERE ordernumber = 'P190821121541904' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411461'
                WHERE ordernumber = 'P420821122338649' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411465'
                WHERE ordernumber = 'P420821123139522' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251957'
                WHERE ordernumber = 'P180821123239586' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340551'
                WHERE ordernumber = 'P420821123247341' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316929'
                WHERE ordernumber = 'P200821123422160' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411466'
                WHERE ordernumber = 'P420821123533827' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289838'
                WHERE ordernumber = 'P180821123803230' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411468'
                WHERE ordernumber = 'P180821123902636' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411469'
                WHERE ordernumber = 'P200821124126564' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215627'
                WHERE ordernumber = 'P180821124141252' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211099'
                WHERE ordernumber = 'P200821124333290' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257723'
                WHERE ordernumber = 'P180821124527194' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282487'
                WHERE ordernumber = 'P200821124633795' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408787'
                WHERE ordernumber = 'P180821124716480' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408787'
                WHERE ordernumber = 'P180821124756213' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358342'
                WHERE ordernumber = 'P420821124757828' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411473'
                WHERE ordernumber = 'P180821124922191' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369623'
                WHERE ordernumber = 'P180821125106867' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411475'
                WHERE ordernumber = 'P420821125321602' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235621'
                WHERE ordernumber = 'P180821125343699' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411478'
                WHERE ordernumber = 'P180821125629550' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309074'
                WHERE ordernumber = 'P180821125733768' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397045'
                WHERE ordernumber = 'P180821125859421' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266880'
                WHERE ordernumber = 'P180821130032230' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363039'
                WHERE ordernumber = 'P180821130144125' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411486'
                WHERE ordernumber = 'P200821130734742' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398163'
                WHERE ordernumber = 'P200821130857703' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411487'
                WHERE ordernumber = 'P180821130906722' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409940'
                WHERE ordernumber = 'P420821131017374' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138587'
                WHERE ordernumber = 'P180821131017518' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95110'
                WHERE ordernumber = 'P180821131144742' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386972'
                WHERE ordernumber = 'P190821131223538' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411490'
                WHERE ordernumber = 'P420821131234791' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409940'
                WHERE ordernumber = 'P420821131336340' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391432'
                WHERE ordernumber = 'P200821132021169' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406570'
                WHERE ordernumber = 'P420821132534543' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224877'
                WHERE ordernumber = 'P200821132616838' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411498'
                WHERE ordernumber = 'P190821132718750' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411501'
                WHERE ordernumber = 'P180821133013632' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411502'
                WHERE ordernumber = 'P200821133044561' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327883'
                WHERE ordernumber = 'P420821133329193' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411503'
                WHERE ordernumber = 'P180821133328973' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411506'
                WHERE ordernumber = 'P200821133409679' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327883'
                WHERE ordernumber = 'P420821133524649' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96489'
                WHERE ordernumber = 'P420821133705166' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283997'
                WHERE ordernumber = 'P420821133933553' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407903'
                WHERE ordernumber = 'P420821134225777' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98694'
                WHERE ordernumber = 'P420821134747803' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410985'
                WHERE ordernumber = 'P180821135205542' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380016'
                WHERE ordernumber = 'P200821135957143' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P200821140134137' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411526'
                WHERE ordernumber = 'P200821140439143' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '1785'
                WHERE ordernumber = 'P180821140534849' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411530'
                WHERE ordernumber = 'P180821141053991' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '196981'
                WHERE ordernumber = 'P180821141218302' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259598'
                WHERE ordernumber = 'P200821141355600' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411531'
                WHERE ordernumber = 'P420821141356601' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411530'
                WHERE ordernumber = 'P180821141553478' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376110'
                WHERE ordernumber = 'P180821141715340' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410429'
                WHERE ordernumber = 'P420821141757200' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337443'
                WHERE ordernumber = 'P200821142046988' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411535'
                WHERE ordernumber = 'P190821142114767' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411537'
                WHERE ordernumber = 'P420821142148856' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411539'
                WHERE ordernumber = 'P180821142319941' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338204'
                WHERE ordernumber = 'P180821142511543' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411535'
                WHERE ordernumber = 'P180821142558508' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180821143003870' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411543'
                WHERE ordernumber = 'P420821143006679' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367983'
                WHERE ordernumber = 'P420821143052157' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411544'
                WHERE ordernumber = 'P180821143144383' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180821143413584' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217542'
                WHERE ordernumber = 'P420821143428549' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411549'
                WHERE ordernumber = 'P200821143635241' 
            
2024-08-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403089'
                WHERE ordernumber = 'P200821143758634' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '172856'
                WHERE ordernumber = 'P590821144220216' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230241'
                WHERE ordernumber = 'P190821144557781' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402695'
                WHERE ordernumber = 'P200821144831554' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277377'
                WHERE ordernumber = 'P200821144918739' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230241'
                WHERE ordernumber = 'P190821144925522' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402695'
                WHERE ordernumber = 'P200821145146528' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253575'
                WHERE ordernumber = 'P200821145318923' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289713'
                WHERE ordernumber = 'P200821145707783' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411561'
                WHERE ordernumber = 'P180821150219630' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411565'
                WHERE ordernumber = 'P420821150626668' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404969'
                WHERE ordernumber = 'P630821150655427' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273051'
                WHERE ordernumber = 'P420821150725539' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306273'
                WHERE ordernumber = 'P180821150951145' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399841'
                WHERE ordernumber = 'P180821151325759' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411569'
                WHERE ordernumber = 'P180821151537678' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107391'
                WHERE ordernumber = 'P180821151834781' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411486'
                WHERE ordernumber = 'P200821151957666' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411571'
                WHERE ordernumber = 'P420821152152871' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264677'
                WHERE ordernumber = 'P180821152410860' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411573'
                WHERE ordernumber = 'P180821152526505' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411575'
                WHERE ordernumber = 'P180821152644947' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365314'
                WHERE ordernumber = 'P180821152855357' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138496'
                WHERE ordernumber = 'P200821153446417' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222195'
                WHERE ordernumber = 'P420821153811945' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411583'
                WHERE ordernumber = 'P200821153832577' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411584'
                WHERE ordernumber = 'P180821154144859' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411585'
                WHERE ordernumber = 'P200821154146768' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P200821154347685' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98143'
                WHERE ordernumber = 'P180821154736726' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132575'
                WHERE ordernumber = 'P200821155309280' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387799'
                WHERE ordernumber = 'P420821155416842' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166785'
                WHERE ordernumber = 'P180821155501243' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411594'
                WHERE ordernumber = 'P200821160021701' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411596'
                WHERE ordernumber = 'P180821160454365' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340805'
                WHERE ordernumber = 'P190821160812940' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411598'
                WHERE ordernumber = 'P200821161025457' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296122'
                WHERE ordernumber = 'P180821161128768' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411601'
                WHERE ordernumber = 'P200821161245578' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411602'
                WHERE ordernumber = 'P190821161308500' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126705'
                WHERE ordernumber = 'P180821161321165' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226564'
                WHERE ordernumber = 'P180821161515862' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411604'
                WHERE ordernumber = 'P180821161755145' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241226'
                WHERE ordernumber = 'P180821161905785' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245332'
                WHERE ordernumber = 'P200821162017716' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411610'
                WHERE ordernumber = 'P180821162118593' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261216'
                WHERE ordernumber = 'P200821162125358' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163575'
                WHERE ordernumber = 'P180821162341250' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411612'
                WHERE ordernumber = 'P200821162435874' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411614'
                WHERE ordernumber = 'P180821162515229' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372252'
                WHERE ordernumber = 'P420821162527367' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293745'
                WHERE ordernumber = 'P200821162554667' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372252'
                WHERE ordernumber = 'P420821162617811' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88832'
                WHERE ordernumber = 'P420821162833505' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326943'
                WHERE ordernumber = 'P180821162836140' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223953'
                WHERE ordernumber = 'P200821162923673' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356084'
                WHERE ordernumber = 'P180821163049926' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356084'
                WHERE ordernumber = 'P180821163220402' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208332'
                WHERE ordernumber = 'P180821163431901' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411621'
                WHERE ordernumber = 'P200821163943220' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411622'
                WHERE ordernumber = 'P180821164055273' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411621'
                WHERE ordernumber = 'P200821164107909' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411626'
                WHERE ordernumber = 'P180821164543151' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411628'
                WHERE ordernumber = 'P200821164829657' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246026'
                WHERE ordernumber = 'P200821164912870' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '179907'
                WHERE ordernumber = 'P200821165042884' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411630'
                WHERE ordernumber = 'P190821165133744' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90165'
                WHERE ordernumber = 'P200821165223330' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400213'
                WHERE ordernumber = 'P200821165348176' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410051'
                WHERE ordernumber = 'P180821165523831' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410051'
                WHERE ordernumber = 'P180821165606219' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384260'
                WHERE ordernumber = 'P420821165848961' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347462'
                WHERE ordernumber = 'P180821170144962' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209443'
                WHERE ordernumber = 'P180821171208872' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408708'
                WHERE ordernumber = 'P200821171356691' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411635'
                WHERE ordernumber = 'P180821171415913' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398016'
                WHERE ordernumber = 'P200821171428605' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215272'
                WHERE ordernumber = 'P180821171631418' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215272'
                WHERE ordernumber = 'P180821171727913' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411649'
                WHERE ordernumber = 'P200821172002147' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99246'
                WHERE ordernumber = 'P190821172158640' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411653'
                WHERE ordernumber = 'P190821172408161' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411655'
                WHERE ordernumber = 'P200821172614579' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411656'
                WHERE ordernumber = 'P180821172810119' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214293'
                WHERE ordernumber = 'P180821172903458' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227260'
                WHERE ordernumber = 'P180821172930192' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352727'
                WHERE ordernumber = 'P200821173353530' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411663'
                WHERE ordernumber = 'P200821174005424' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411664'
                WHERE ordernumber = 'P200821174218938' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332647'
                WHERE ordernumber = 'P200821174333526' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411666'
                WHERE ordernumber = 'P200821174518518' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411667'
                WHERE ordernumber = 'P180821174558767' 
            
2024-08-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411668'
                WHERE ordernumber = 'P200821174652557' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411669'
                WHERE ordernumber = 'P180821174833687' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406778'
                WHERE ordernumber = 'P180821175001565' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128516'
                WHERE ordernumber = 'P180821175150226' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411673'
                WHERE ordernumber = 'P200821175350836' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411675'
                WHERE ordernumber = 'P180821175604691' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '233044'
                WHERE ordernumber = 'P180821175718994' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411682'
                WHERE ordernumber = 'P420821180428884' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411683'
                WHERE ordernumber = 'P180821180446752' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411681'
                WHERE ordernumber = 'P200821180545540' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318415'
                WHERE ordernumber = 'P420821180602886' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286728'
                WHERE ordernumber = 'P180821180704312' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397626'
                WHERE ordernumber = 'P200821180800688' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102047'
                WHERE ordernumber = 'P200821180902331' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411685'
                WHERE ordernumber = 'P420821181236430' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411686'
                WHERE ordernumber = 'P420821181357501' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411687'
                WHERE ordernumber = 'P200821182049336' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411688'
                WHERE ordernumber = 'P200821182238183' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225205'
                WHERE ordernumber = 'P180821182640974' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411303'
                WHERE ordernumber = 'P180821183203579' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406177'
                WHERE ordernumber = 'P200821183306783' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411690'
                WHERE ordernumber = 'P180821183357865' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411693'
                WHERE ordernumber = 'P180821183512440' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411694'
                WHERE ordernumber = 'P200821183638869' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411695'
                WHERE ordernumber = 'P420821183916685' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411697'
                WHERE ordernumber = 'P180821184316637' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411695'
                WHERE ordernumber = 'P420821184416494' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '363483'
                WHERE ordernumber = 'P200821184507477' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387790'
                WHERE ordernumber = 'P420821184514177' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411699'
                WHERE ordernumber = 'P180821184733693' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411700'
                WHERE ordernumber = 'P190821184830960' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97077'
                WHERE ordernumber = 'P190821190643238' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '206594'
                WHERE ordernumber = 'P190821190836195' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367176'
                WHERE ordernumber = 'P190821191030444' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '111367'
                WHERE ordernumber = 'P190821191233708' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '131589'
                WHERE ordernumber = 'P190821191521997' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277867'
                WHERE ordernumber = 'P190821191803763' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411391'
                WHERE ordernumber = 'P190821192223241' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411711'
                WHERE ordernumber = 'P190821192327950' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '165635'
                WHERE ordernumber = 'P190821192833386' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411715'
                WHERE ordernumber = 'P200821192834583' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411718'
                WHERE ordernumber = 'P190821192951629' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411719'
                WHERE ordernumber = 'P200821193125258' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411716'
                WHERE ordernumber = 'P200821193304324' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411721'
                WHERE ordernumber = 'P190821193823960' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '147815'
                WHERE ordernumber = 'P200821193858690' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411724'
                WHERE ordernumber = 'P200821194048212' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411725'
                WHERE ordernumber = 'P200821194305787' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '147815'
                WHERE ordernumber = 'P200821194356165' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118209'
                WHERE ordernumber = 'P190821194811865' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411727'
                WHERE ordernumber = 'P190821194919745' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408492'
                WHERE ordernumber = 'P630821194957483' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214805'
                WHERE ordernumber = 'P190821195046931' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283578'
                WHERE ordernumber = 'P190821195317478' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411731'
                WHERE ordernumber = 'P190821195412385' 
            
2024-08-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '109478'
                WHERE ordernumber = 'P200821200255859'