2024-07-18 01:00:03 -- 將會員中心id寫入data-lake
2024-07-18 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-07-17%';
        
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401659'
                WHERE ordernumber = 'P630717100326832' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401661'
                WHERE ordernumber = 'P630717100617437' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401668'
                WHERE ordernumber = 'P420717110258198' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118039'
                WHERE ordernumber = 'P180717110632839' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299091'
                WHERE ordernumber = 'P180717111026140' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401673'
                WHERE ordernumber = 'P180717111337663' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401671'
                WHERE ordernumber = 'P180717111430846' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116809'
                WHERE ordernumber = 'P180717111558784' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401677'
                WHERE ordernumber = 'P180717111837330' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258516'
                WHERE ordernumber = 'P200717111945189' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393875'
                WHERE ordernumber = 'P200717112308746' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401678'
                WHERE ordernumber = 'P200717112455338' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393037'
                WHERE ordernumber = 'P190717112742416' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401679'
                WHERE ordernumber = 'P420717112754532' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312194'
                WHERE ordernumber = 'P180717112821883' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P420717112851309' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262581'
                WHERE ordernumber = 'P180717112930618' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344823'
                WHERE ordernumber = 'P200717113234697' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401683'
                WHERE ordernumber = 'P200717113904208' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286112'
                WHERE ordernumber = 'P200717114631585' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401685'
                WHERE ordernumber = 'P180717115435659' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345014'
                WHERE ordernumber = 'P180717115725357' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341905'
                WHERE ordernumber = 'P180717115833765' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401686'
                WHERE ordernumber = 'P190717120136418' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248680'
                WHERE ordernumber = 'P180717120147622' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217542'
                WHERE ordernumber = 'P420717120218856' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401625'
                WHERE ordernumber = 'P180717121058837' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395696'
                WHERE ordernumber = 'P180717121330868' 
            
2024-07-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401687'
                WHERE ordernumber = 'P630717121827993' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397741'
                WHERE ordernumber = 'P420717121926860' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249880'
                WHERE ordernumber = 'P180717122519983' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401688'
                WHERE ordernumber = 'P420717123857843' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401652'
                WHERE ordernumber = 'P180717124311120' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401652'
                WHERE ordernumber = 'P180717124345211' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302437'
                WHERE ordernumber = 'P200717125037845' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401692'
                WHERE ordernumber = 'P200717125439986' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398150'
                WHERE ordernumber = 'P420717130249564' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337892'
                WHERE ordernumber = 'P180717131738883' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401694'
                WHERE ordernumber = 'P180717132115902' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401697'
                WHERE ordernumber = 'P180717133339318' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334995'
                WHERE ordernumber = 'P180717133734326' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401698'
                WHERE ordernumber = 'P420717134425665' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100206'
                WHERE ordernumber = 'P200717134831869' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401699'
                WHERE ordernumber = 'P200717135400604' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401702'
                WHERE ordernumber = 'P420717140557509' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401704'
                WHERE ordernumber = 'P200717141039261' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401705'
                WHERE ordernumber = 'P200717141453966' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117912'
                WHERE ordernumber = 'P200717141744755' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180717142205967' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401708'
                WHERE ordernumber = 'P200717142207747' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401710'
                WHERE ordernumber = 'P420717142913159' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401711'
                WHERE ordernumber = 'P190717143200627' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401712'
                WHERE ordernumber = 'P200717143243152' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271382'
                WHERE ordernumber = 'P190717143510868' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391150'
                WHERE ordernumber = 'P200717143549937' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401714'
                WHERE ordernumber = 'P200717143717584' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394137'
                WHERE ordernumber = 'P200717143845456' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401716'
                WHERE ordernumber = 'P180717144143747' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390149'
                WHERE ordernumber = 'P420717144227111' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383190'
                WHERE ordernumber = 'P200717144227713' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390147'
                WHERE ordernumber = 'P420717144322150' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248757'
                WHERE ordernumber = 'P200717144851226' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324640'
                WHERE ordernumber = 'P180717144938147' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392677'
                WHERE ordernumber = 'P180717145226716' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401720'
                WHERE ordernumber = 'P420717145541900' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351421'
                WHERE ordernumber = 'P200717145759752' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401722'
                WHERE ordernumber = 'P200717150005488' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316629'
                WHERE ordernumber = 'P190717150445713' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '51825'
                WHERE ordernumber = 'P180717150605546' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401723'
                WHERE ordernumber = 'P190717150605847' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401727'
                WHERE ordernumber = 'P180717152401261' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401730'
                WHERE ordernumber = 'P180717153726497' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401731'
                WHERE ordernumber = 'P180717153920682' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401733'
                WHERE ordernumber = 'P190717154520913' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401734'
                WHERE ordernumber = 'P420717154547742' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347676'
                WHERE ordernumber = 'P190717154834140' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401733'
                WHERE ordernumber = 'P190717155017436' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323666'
                WHERE ordernumber = 'P190717155235127' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401735'
                WHERE ordernumber = 'P420717155808699' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401736'
                WHERE ordernumber = 'P180717155910981' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275912'
                WHERE ordernumber = 'P180717160742690' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401739'
                WHERE ordernumber = 'P420717161345896' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401740'
                WHERE ordernumber = 'P200717161621764' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '762'
                WHERE ordernumber = 'P200717162102516' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '762'
                WHERE ordernumber = 'P200717162143762' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337850'
                WHERE ordernumber = 'P200717162652966' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401741'
                WHERE ordernumber = 'P420717162748353' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99761'
                WHERE ordernumber = 'P190717162952523' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81108'
                WHERE ordernumber = 'P180717163018548' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401742'
                WHERE ordernumber = 'P190717163215137' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401743'
                WHERE ordernumber = 'P190717163507454' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401744'
                WHERE ordernumber = 'P180717163759413' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401745'
                WHERE ordernumber = 'P200717163805261' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227915'
                WHERE ordernumber = 'P180717163902914' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400524'
                WHERE ordernumber = 'P200717164209882' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401747'
                WHERE ordernumber = 'P420717164619654' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100949'
                WHERE ordernumber = 'P180717164704334' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100949'
                WHERE ordernumber = 'P180717164800510' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401749'
                WHERE ordernumber = 'P420717164901853' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401748'
                WHERE ordernumber = 'P630717164917127' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82787'
                WHERE ordernumber = 'P420717165020557' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401751'
                WHERE ordernumber = 'P180717170824660' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335347'
                WHERE ordernumber = 'P200717171122636' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383361'
                WHERE ordernumber = 'P420717171206352' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335347'
                WHERE ordernumber = 'P200717171311608' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '897'
                WHERE ordernumber = 'P180717171927339' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397653'
                WHERE ordernumber = 'P630717172132425' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237079'
                WHERE ordernumber = 'P200717172555223' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382685'
                WHERE ordernumber = 'P420717172740980' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310323'
                WHERE ordernumber = 'P200717172843930' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353532'
                WHERE ordernumber = 'P180717173009234' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385157'
                WHERE ordernumber = 'P630717173126832' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382250'
                WHERE ordernumber = 'P590717173807766' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '65054'
                WHERE ordernumber = 'P200717173831285' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401759'
                WHERE ordernumber = 'P630717174444341' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334829'
                WHERE ordernumber = 'P180717174607191' 
            
2024-07-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117500'
                WHERE ordernumber = 'P180717174750350' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291574'
                WHERE ordernumber = 'P200717174813168' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401760'
                WHERE ordernumber = 'P200717174907966' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401761'
                WHERE ordernumber = 'P200717175213353' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218945'
                WHERE ordernumber = 'P200717175326302' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401762'
                WHERE ordernumber = 'P180717175702697' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161128'
                WHERE ordernumber = 'P590717180119898' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401301'
                WHERE ordernumber = 'P180717180530824' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236997'
                WHERE ordernumber = 'P180717180740800' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314078'
                WHERE ordernumber = 'P200717181234120' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '31994'
                WHERE ordernumber = 'P180717181336875' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '268682'
                WHERE ordernumber = 'P420717181337252' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394421'
                WHERE ordernumber = 'P420717181550224' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137509'
                WHERE ordernumber = 'P180717181646302' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249489'
                WHERE ordernumber = 'P180717182221811' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279465'
                WHERE ordernumber = 'P180717182311383' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400263'
                WHERE ordernumber = 'P180717182822468' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105913'
                WHERE ordernumber = 'P200717182832783' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81074'
                WHERE ordernumber = 'P200717183007912' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401765'
                WHERE ordernumber = 'P180717183351814' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313163'
                WHERE ordernumber = 'P180717183459353' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401766'
                WHERE ordernumber = 'P420717183654568' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401766'
                WHERE ordernumber = 'P420717183738791' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401769'
                WHERE ordernumber = 'P200717184918274' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401770'
                WHERE ordernumber = 'P420717185240638' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '164144'
                WHERE ordernumber = 'P180717185246548' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401771'
                WHERE ordernumber = 'P200717185307392' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249879'
                WHERE ordernumber = 'P200717185542329' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '253771'
                WHERE ordernumber = 'P190717190002307' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100575'
                WHERE ordernumber = 'P190717190057629' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401774'
                WHERE ordernumber = 'P420717190146659' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P200717191424612' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401778'
                WHERE ordernumber = 'P190717192044259' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '261573'
                WHERE ordernumber = 'P190717192144924' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '331314'
                WHERE ordernumber = 'P190717192248239' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275200'
                WHERE ordernumber = 'P200717192614987' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248978'
                WHERE ordernumber = 'P190717193306446' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401609'
                WHERE ordernumber = 'P200717193840636' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401675'
                WHERE ordernumber = 'P200717194120828' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '173014'
                WHERE ordernumber = 'P190717195006228' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399762'
                WHERE ordernumber = 'P200717195643967' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304662'
                WHERE ordernumber = 'P590717202735984' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389481'
                WHERE ordernumber = 'P630717204738112' 
            
2024-07-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389481'
                WHERE ordernumber = 'P630717204738112'