2024-08-05 01:00:03 -- 將會員中心id寫入data-lake
2024-08-05 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 '2024-08-04%';
        
2024-08-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240584'
                WHERE ordernumber = 'P200804110209311' 
            
2024-08-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283681'
                WHERE ordernumber = 'P180804110233972' 
            
2024-08-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377184'
                WHERE ordernumber = 'P180804110501774' 
            
2024-08-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405201'
                WHERE ordernumber = 'P420804110542194' 
            
2024-08-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394974'
                WHERE ordernumber = 'P180804110940485' 
            
2024-08-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397119'
                WHERE ordernumber = 'P190804111025632' 
            
2024-08-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111289'
                WHERE ordernumber = 'P190804111104387' 
            
2024-08-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405204'
                WHERE ordernumber = 'P200804111202551' 
            
2024-08-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '33951'
                WHERE ordernumber = 'P190804111250661' 
            
2024-08-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255478'
                WHERE ordernumber = 'P180804111322248' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405205'
                WHERE ordernumber = 'P200804111415673' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369420'
                WHERE ordernumber = 'P200804111843564' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '59152'
                WHERE ordernumber = 'P180804111846159' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324831'
                WHERE ordernumber = 'P180804112021908' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306875'
                WHERE ordernumber = 'P180804112304167' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405206'
                WHERE ordernumber = 'P200804112314281' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405207'
                WHERE ordernumber = 'P420804112505723' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405209'
                WHERE ordernumber = 'P420804112959221' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405210'
                WHERE ordernumber = 'P180804113025292' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405211'
                WHERE ordernumber = 'P200804113111950' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405212'
                WHERE ordernumber = 'P420804113225243' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405213'
                WHERE ordernumber = 'P180804113252959' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405211'
                WHERE ordernumber = 'P200804113408702' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256467'
                WHERE ordernumber = 'P180804113419340' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359847'
                WHERE ordernumber = 'P420804113500609' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405214'
                WHERE ordernumber = 'P180804114047475' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405217'
                WHERE ordernumber = 'P180804114525689' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405218'
                WHERE ordernumber = 'P180804114701148' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301759'
                WHERE ordernumber = 'P630804114948819' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405221'
                WHERE ordernumber = 'P180804115000421' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136836'
                WHERE ordernumber = 'P190804115040836' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405223'
                WHERE ordernumber = 'P420804115120295' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404879'
                WHERE ordernumber = 'P420804115237670' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405223'
                WHERE ordernumber = 'P420804115334651' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405224'
                WHERE ordernumber = 'P180804115350711' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405225'
                WHERE ordernumber = 'P200804115454195' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405226'
                WHERE ordernumber = 'P420804115754335' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405227'
                WHERE ordernumber = 'P180804115825557' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305137'
                WHERE ordernumber = 'P200804115909710' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405229'
                WHERE ordernumber = 'P180804120131270' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405230'
                WHERE ordernumber = 'P180804120254237' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405231'
                WHERE ordernumber = 'P180804120404412' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248386'
                WHERE ordernumber = 'P200804120757124' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211162'
                WHERE ordernumber = 'P180804120828989' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333961'
                WHERE ordernumber = 'P420804121043569' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128783'
                WHERE ordernumber = 'P180804121250790' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404367'
                WHERE ordernumber = 'P180804121525138' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405232'
                WHERE ordernumber = 'P200804121637593' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95444'
                WHERE ordernumber = 'P190804121848541' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277549'
                WHERE ordernumber = 'P200804122019369' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290405'
                WHERE ordernumber = 'P180804122138878' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381777'
                WHERE ordernumber = 'P180804122314880' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311399'
                WHERE ordernumber = 'P180804122453270' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405234'
                WHERE ordernumber = 'P420804122738194' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405236'
                WHERE ordernumber = 'P200804123025396' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405237'
                WHERE ordernumber = 'P420804123135113' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405238'
                WHERE ordernumber = 'P180804123246859' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405240'
                WHERE ordernumber = 'P200804123525231' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261162'
                WHERE ordernumber = 'P180804123806516' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332572'
                WHERE ordernumber = 'P200804123855670' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405242'
                WHERE ordernumber = 'P180804124051771' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405243'
                WHERE ordernumber = 'P420804124325253' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275639'
                WHERE ordernumber = 'P180804124521268' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401066'
                WHERE ordernumber = 'P200804124721842' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281663'
                WHERE ordernumber = 'P180804125200940' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292363'
                WHERE ordernumber = 'P180804125534950' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405245'
                WHERE ordernumber = 'P180804125940873' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405246'
                WHERE ordernumber = 'P200804130008841' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405248'
                WHERE ordernumber = 'P420804130159248' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405250'
                WHERE ordernumber = 'P420804130831693' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405251'
                WHERE ordernumber = 'P180804130918234' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '41940'
                WHERE ordernumber = 'P200804131033387' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405252'
                WHERE ordernumber = 'P420804131218178' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341680'
                WHERE ordernumber = 'P180804131532636' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405254'
                WHERE ordernumber = 'P200804131905191' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405255'
                WHERE ordernumber = 'P200804132039438' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387364'
                WHERE ordernumber = 'P180804132107882' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66871'
                WHERE ordernumber = 'P190804132234436' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405154'
                WHERE ordernumber = 'P180804132419793' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405258'
                WHERE ordernumber = 'P420804132452298' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349114'
                WHERE ordernumber = 'P200804132458452' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405259'
                WHERE ordernumber = 'P190804132547862' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398435'
                WHERE ordernumber = 'P200804132640734' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405261'
                WHERE ordernumber = 'P420804132839359' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405260'
                WHERE ordernumber = 'P200804132903781' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405262'
                WHERE ordernumber = 'P420804133031739' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99444'
                WHERE ordernumber = 'P200804133431149' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401705'
                WHERE ordernumber = 'P200804133532854' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405263'
                WHERE ordernumber = 'P180804133623525' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '181480'
                WHERE ordernumber = 'P420804133627827' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381972'
                WHERE ordernumber = 'P180804133701438' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310972'
                WHERE ordernumber = 'P200804133902497' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264801'
                WHERE ordernumber = 'P180804134125622' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405265'
                WHERE ordernumber = 'P180804134428667' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '201949'
                WHERE ordernumber = 'P420804134433537' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252912'
                WHERE ordernumber = 'P200804134522583' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405266'
                WHERE ordernumber = 'P180804134604257' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220551'
                WHERE ordernumber = 'P180804135054750' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225462'
                WHERE ordernumber = 'P180804135250724' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405269'
                WHERE ordernumber = 'P200804135529119' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240423'
                WHERE ordernumber = 'P180804135552113' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '7403'
                WHERE ordernumber = 'P180804135852233' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218531'
                WHERE ordernumber = 'P180804135935664' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334875'
                WHERE ordernumber = 'P420804140028873' 
            
2024-08-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405268'
                WHERE ordernumber = 'P180804140158734' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405270'
                WHERE ordernumber = 'P420804140312561' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128158'
                WHERE ordernumber = 'P420804140447538' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405272'
                WHERE ordernumber = 'P180804140507543' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282921'
                WHERE ordernumber = 'P180804140635770' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405273'
                WHERE ordernumber = 'P190804140659882' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235223'
                WHERE ordernumber = 'P180804140756887' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405268'
                WHERE ordernumber = 'P180804141032173' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405275'
                WHERE ordernumber = 'P200804141235820' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401377'
                WHERE ordernumber = 'P190804141308898' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405276'
                WHERE ordernumber = 'P200804141419572' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '74956'
                WHERE ordernumber = 'P190804141746736' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400203'
                WHERE ordernumber = 'P420804141858664' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349079'
                WHERE ordernumber = 'P190804142135742' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405282'
                WHERE ordernumber = 'P190804142413911' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318464'
                WHERE ordernumber = 'P180804142447406' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405284'
                WHERE ordernumber = 'P420804142617138' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405282'
                WHERE ordernumber = 'P190804143205659' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346212'
                WHERE ordernumber = 'P190804143508626' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405285'
                WHERE ordernumber = 'P420804143603834' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405287'
                WHERE ordernumber = 'P190804143712322' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405288'
                WHERE ordernumber = 'P190804144005250' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405285'
                WHERE ordernumber = 'P420804144106127' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405289'
                WHERE ordernumber = 'P420804144322256' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400357'
                WHERE ordernumber = 'P200804144515250' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405290'
                WHERE ordernumber = 'P190804144518697' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340318'
                WHERE ordernumber = 'P190804144819876' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405294'
                WHERE ordernumber = 'P190804145119169' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '120570'
                WHERE ordernumber = 'P190804145247934' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116208'
                WHERE ordernumber = 'P420804145313338' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405293'
                WHERE ordernumber = 'P180804145534633' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '135077'
                WHERE ordernumber = 'P200804145618248' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405293'
                WHERE ordernumber = 'P180804145716498' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402209'
                WHERE ordernumber = 'P190804145838252' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313776'
                WHERE ordernumber = 'P180804145906731' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405296'
                WHERE ordernumber = 'P420804150137608' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405297'
                WHERE ordernumber = 'P200804150230756' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '40142'
                WHERE ordernumber = 'P180804150450653' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '48457'
                WHERE ordernumber = 'P180804150803329' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286955'
                WHERE ordernumber = 'P190804151040420' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405300'
                WHERE ordernumber = 'P180804151331940' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405301'
                WHERE ordernumber = 'P190804151457834' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380348'
                WHERE ordernumber = 'P180804151601507' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '40142'
                WHERE ordernumber = 'P180804151723622' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '40142'
                WHERE ordernumber = 'P180804151825147' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395102'
                WHERE ordernumber = 'P190804151830245' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396722'
                WHERE ordernumber = 'P190804151936368' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397445'
                WHERE ordernumber = 'P190804152049356' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '325240'
                WHERE ordernumber = 'P420804153004547' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '211119'
                WHERE ordernumber = 'P190804153015451' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405306'
                WHERE ordernumber = 'P190804153139297' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118039'
                WHERE ordernumber = 'P190804153403956' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401089'
                WHERE ordernumber = 'P200804153640308' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384432'
                WHERE ordernumber = 'P190804153733415' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '119047'
                WHERE ordernumber = 'P190804154230245' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400494'
                WHERE ordernumber = 'P590804154233471' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405309'
                WHERE ordernumber = 'P180804154449651' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '173590'
                WHERE ordernumber = 'P180804154620505' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405311'
                WHERE ordernumber = 'P190804154930524' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405313'
                WHERE ordernumber = 'P200804155732655' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304155'
                WHERE ordernumber = 'P630804155805965' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94237'
                WHERE ordernumber = 'P200804160119671' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405195'
                WHERE ordernumber = 'P420804160151926' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345732'
                WHERE ordernumber = 'P200804160559504' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405316'
                WHERE ordernumber = 'P190804160611523' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221265'
                WHERE ordernumber = 'P200804160824863' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405317'
                WHERE ordernumber = 'P190804160919770' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405318'
                WHERE ordernumber = 'P200804160928445' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404479'
                WHERE ordernumber = 'P180804160932752' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388679'
                WHERE ordernumber = 'P200804161713374' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405323'
                WHERE ordernumber = 'P200804161823157' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '65865'
                WHERE ordernumber = 'P180804162415305' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '65865'
                WHERE ordernumber = 'P180804162841176' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405326'
                WHERE ordernumber = 'P420804163046593' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229353'
                WHERE ordernumber = 'P190804163113946' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390211'
                WHERE ordernumber = 'P200804163151839' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229997'
                WHERE ordernumber = 'P200804163242349' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405327'
                WHERE ordernumber = 'P420804163414227' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312952'
                WHERE ordernumber = 'P180804163414706' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278734'
                WHERE ordernumber = 'P200804163528584' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405329'
                WHERE ordernumber = 'P180804163635366' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405328'
                WHERE ordernumber = 'P200804163646338' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405331'
                WHERE ordernumber = 'P180804163808643' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402654'
                WHERE ordernumber = 'P190804163911459' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226884'
                WHERE ordernumber = 'P180804164151390' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397039'
                WHERE ordernumber = 'P190804164245679' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '60459'
                WHERE ordernumber = 'P420804164406307' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299210'
                WHERE ordernumber = 'P420804164445316' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345965'
                WHERE ordernumber = 'P420804164633269' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405333'
                WHERE ordernumber = 'P180804165202556' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405334'
                WHERE ordernumber = 'P190804165220548' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405335'
                WHERE ordernumber = 'P180804165337863' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405336'
                WHERE ordernumber = 'P420804165430576' 
            
2024-08-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405337'
                WHERE ordernumber = 'P190804165533977' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '246551'
                WHERE ordernumber = 'P180804165609148' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '340831'
                WHERE ordernumber = 'P420804165757594' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '238771'
                WHERE ordernumber = 'P200804165816341' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '234511'
                WHERE ordernumber = 'P420804165959619' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405339'
                WHERE ordernumber = 'P630804170011926' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '238771'
                WHERE ordernumber = 'P200804170029589' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405341'
                WHERE ordernumber = 'P420804170142984' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '133836'
                WHERE ordernumber = 'P420804170231949' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405342'
                WHERE ordernumber = 'P200804170331341' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '136927'
                WHERE ordernumber = 'P420804171136271' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '294760'
                WHERE ordernumber = 'P200804171418700' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405233'
                WHERE ordernumber = 'P180804171537368' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405346'
                WHERE ordernumber = 'P420804171540955' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405347'
                WHERE ordernumber = 'P190804171550940' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '393620'
                WHERE ordernumber = 'P190804171634244' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405348'
                WHERE ordernumber = 'P200804171717315' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405348'
                WHERE ordernumber = 'P200804171818379' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405350'
                WHERE ordernumber = 'P190804171834698' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '391122'
                WHERE ordernumber = 'P190804171911241' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405351'
                WHERE ordernumber = 'P420804172113165' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405353'
                WHERE ordernumber = 'P180804172157523' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405354'
                WHERE ordernumber = 'P180804172500741' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405355'
                WHERE ordernumber = 'P200804172536540' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '87780'
                WHERE ordernumber = 'P180804172609214' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405358'
                WHERE ordernumber = 'P200804172734327' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405359'
                WHERE ordernumber = 'P180804172801333' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '404707'
                WHERE ordernumber = 'P190804173206576' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405365'
                WHERE ordernumber = 'P190804173634810' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '260989'
                WHERE ordernumber = 'P180804173802420' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405366'
                WHERE ordernumber = 'P190804173912626' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '220472'
                WHERE ordernumber = 'P200804174125207' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405367'
                WHERE ordernumber = 'P420804174451222' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '337773'
                WHERE ordernumber = 'P200804174806973' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405368'
                WHERE ordernumber = 'P190804174831202' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405369'
                WHERE ordernumber = 'P180804175004907' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405370'
                WHERE ordernumber = 'P190804175109132' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P180804175401127' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P180804175555596' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405372'
                WHERE ordernumber = 'P190804175613756' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405373'
                WHERE ordernumber = 'P420804175642880' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '212237'
                WHERE ordernumber = 'P180804175649114' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405374'
                WHERE ordernumber = 'P180804175831551' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405378'
                WHERE ordernumber = 'P190804180350344' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405377'
                WHERE ordernumber = 'P420804180351558' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403384'
                WHERE ordernumber = 'P420804180607402' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P590804180759631' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405379'
                WHERE ordernumber = 'P180804181018675' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353169'
                WHERE ordernumber = 'P200804181144955' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405380'
                WHERE ordernumber = 'P420804181329285' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397556'
                WHERE ordernumber = 'P190804181441834' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '369333'
                WHERE ordernumber = 'P190804181743590' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405382'
                WHERE ordernumber = 'P180804181755416' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '294984'
                WHERE ordernumber = 'P180804181813361' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '305697'
                WHERE ordernumber = 'P190804182125754' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405383'
                WHERE ordernumber = 'P420804182156472' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405385'
                WHERE ordernumber = 'P420804182454142' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '302233'
                WHERE ordernumber = 'P420804182615388' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '316825'
                WHERE ordernumber = 'P190804182656865' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '359307'
                WHERE ordernumber = 'P190804182846456' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405387'
                WHERE ordernumber = 'P180804182936585' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405388'
                WHERE ordernumber = 'P420804183040426' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405389'
                WHERE ordernumber = 'P200804183103686' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '93992'
                WHERE ordernumber = 'P200804183205712' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405390'
                WHERE ordernumber = 'P190804183213552' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '379847'
                WHERE ordernumber = 'P190804183322228' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405387'
                WHERE ordernumber = 'P180804183430751' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405392'
                WHERE ordernumber = 'P200804183749884' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405391'
                WHERE ordernumber = 'P420804184122337' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '13485'
                WHERE ordernumber = 'P180804184215904' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405394'
                WHERE ordernumber = 'P180804184451227' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405395'
                WHERE ordernumber = 'P200804184524551' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '273534'
                WHERE ordernumber = 'P200804184629941' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403284'
                WHERE ordernumber = 'P420804184714200' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405397'
                WHERE ordernumber = 'P420804184909238' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '269670'
                WHERE ordernumber = 'P200804185302349' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '272012'
                WHERE ordernumber = 'P190804185736878' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403888'
                WHERE ordernumber = 'P200804190252885' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405401'
                WHERE ordernumber = 'P190804190325643' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '238534'
                WHERE ordernumber = 'P190804190437526' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405402'
                WHERE ordernumber = 'P190804190607806' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '126272'
                WHERE ordernumber = 'P190804191205596' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405404'
                WHERE ordernumber = 'P200804191236529' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '388008'
                WHERE ordernumber = 'P190804191613464' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400285'
                WHERE ordernumber = 'P190804192011397' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405406'
                WHERE ordernumber = 'P190804192120443' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405407'
                WHERE ordernumber = 'P200804192152306' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401268'
                WHERE ordernumber = 'P200804192412629' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405409'
                WHERE ordernumber = 'P190804192419908' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405409'
                WHERE ordernumber = 'P190804192451519' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405410'
                WHERE ordernumber = 'P200804193023928' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '341635'
                WHERE ordernumber = 'P190804193138638' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405411'
                WHERE ordernumber = 'P200804193326905' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405412'
                WHERE ordernumber = 'P190804193537322' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '259773'
                WHERE ordernumber = 'P190804193644465' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '391702'
                WHERE ordernumber = 'P190804194032699' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405415'
                WHERE ordernumber = 'P200804194049433' 
            
2024-08-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405416'
                WHERE ordernumber = 'P190804194223813' 
            
2024-08-05 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '405417'
                WHERE ordernumber = 'P190804194824995'