2024-04-30 01:00:02 -- 將會員中心id寫入data-lake
2024-04-30 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-04-29%';
        
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387458'
                WHERE ordernumber = 'P630429101045846' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387462'
                WHERE ordernumber = 'P630429105358292' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387463'
                WHERE ordernumber = 'P190429110604131' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387464'
                WHERE ordernumber = 'P190429110828810' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100813'
                WHERE ordernumber = 'P200429110856767' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387466'
                WHERE ordernumber = 'P180429110929210' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387467'
                WHERE ordernumber = 'P630429111021609' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345565'
                WHERE ordernumber = 'P420429111658424' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387469'
                WHERE ordernumber = 'P200429111947347' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387470'
                WHERE ordernumber = 'P180429112240522' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387471'
                WHERE ordernumber = 'P200429112532676' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387474'
                WHERE ordernumber = 'P180429112852912' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387475'
                WHERE ordernumber = 'P180429113133539' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387476'
                WHERE ordernumber = 'P180429113432612' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245761'
                WHERE ordernumber = 'P420429114006865' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387481'
                WHERE ordernumber = 'P200429114534456' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387479'
                WHERE ordernumber = 'P420429114534183' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318581'
                WHERE ordernumber = 'P180429114828646' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '267203'
                WHERE ordernumber = 'P180429115518682' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387483'
                WHERE ordernumber = 'P200429115626166' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387484'
                WHERE ordernumber = 'P200429115714618' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224390'
                WHERE ordernumber = 'P180429115823279' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '193074'
                WHERE ordernumber = 'P190429115824836' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130063'
                WHERE ordernumber = 'P190429115852228' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206570'
                WHERE ordernumber = 'P180429120503161' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200429120713426' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266327'
                WHERE ordernumber = 'P180429121548211' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387487'
                WHERE ordernumber = 'P420429121702438' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282700'
                WHERE ordernumber = 'P200429124512710' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387489'
                WHERE ordernumber = 'P200429124622304' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387490'
                WHERE ordernumber = 'P200429124755691' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334350'
                WHERE ordernumber = 'P420429125026448' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387492'
                WHERE ordernumber = 'P190429125303712' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81150'
                WHERE ordernumber = 'P190429125407782' 
            
2024-04-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190429125450422' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387493'
                WHERE ordernumber = 'P180429125619756' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235986'
                WHERE ordernumber = 'P200429125759582' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246060'
                WHERE ordernumber = 'P180429130532421' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387494'
                WHERE ordernumber = 'P590429131258350' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138079'
                WHERE ordernumber = 'P180429132339685' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387495'
                WHERE ordernumber = 'P200429133329638' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387496'
                WHERE ordernumber = 'P200429133546132' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127697'
                WHERE ordernumber = 'P420429133627182' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369422'
                WHERE ordernumber = 'P180429134631205' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378465'
                WHERE ordernumber = 'P200429134929661' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260341'
                WHERE ordernumber = 'P200429135705382' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165039'
                WHERE ordernumber = 'P200429135827479' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385853'
                WHERE ordernumber = 'P180429140235126' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387499'
                WHERE ordernumber = 'P180429140513900' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385853'
                WHERE ordernumber = 'P180429140925192' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268715'
                WHERE ordernumber = 'P180429141006381' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346235'
                WHERE ordernumber = 'P420429141103203' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318961'
                WHERE ordernumber = 'P180429141116526' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241105'
                WHERE ordernumber = 'P200429141435859' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328011'
                WHERE ordernumber = 'P420429142309958' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96407'
                WHERE ordernumber = 'P200429142817909' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P630429142949386' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387500'
                WHERE ordernumber = 'P420429143126274' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387501'
                WHERE ordernumber = 'P200429143156846' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229236'
                WHERE ordernumber = 'P180429143159807' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274955'
                WHERE ordernumber = 'P180429143323136' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200429144132872' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372374'
                WHERE ordernumber = 'P180429144237274' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326714'
                WHERE ordernumber = 'P180429144428379' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380263'
                WHERE ordernumber = 'P420429144521960' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112778'
                WHERE ordernumber = 'P190429144958295' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248742'
                WHERE ordernumber = 'P190429145211450' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105607'
                WHERE ordernumber = 'P180429145237345' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387502'
                WHERE ordernumber = 'P190429145356535' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387503'
                WHERE ordernumber = 'P180429145813279' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374145'
                WHERE ordernumber = 'P180429150135758' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113467'
                WHERE ordernumber = 'P180429150426920' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387506'
                WHERE ordernumber = 'P180429150609880' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385841'
                WHERE ordernumber = 'P200429150718910' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228918'
                WHERE ordernumber = 'P180429151019406' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387508'
                WHERE ordernumber = 'P180429151217539' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353323'
                WHERE ordernumber = 'P180429151243849' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387509'
                WHERE ordernumber = 'P590429152006213' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387510'
                WHERE ordernumber = 'P180429152538711' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145830'
                WHERE ordernumber = 'P630429152800850' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301590'
                WHERE ordernumber = 'P420429152950131' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387512'
                WHERE ordernumber = 'P200429153627886' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387513'
                WHERE ordernumber = 'P200429153820234' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387511'
                WHERE ordernumber = 'P420429153846591' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387514'
                WHERE ordernumber = 'P200429153937694' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387515'
                WHERE ordernumber = 'P180429154705676' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227749'
                WHERE ordernumber = 'P200429154931319' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385406'
                WHERE ordernumber = 'P180429155025343' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387517'
                WHERE ordernumber = 'P180429155222499' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387518'
                WHERE ordernumber = 'P180429155316584' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387519'
                WHERE ordernumber = 'P420429155501904' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387520'
                WHERE ordernumber = 'P180429155842466' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387521'
                WHERE ordernumber = 'P420429155959119' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387522'
                WHERE ordernumber = 'P180429160127465' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382785'
                WHERE ordernumber = 'P420429160238691' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387523'
                WHERE ordernumber = 'P180429160303167' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180429160347858' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281676'
                WHERE ordernumber = 'P200429161112664' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310730'
                WHERE ordernumber = 'P200429161236589' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387525'
                WHERE ordernumber = 'P200429162046505' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387524'
                WHERE ordernumber = 'P180429162349734' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336612'
                WHERE ordernumber = 'P200429162523597' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278936'
                WHERE ordernumber = 'P200429162607516' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378296'
                WHERE ordernumber = 'P180429162637455' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381787'
                WHERE ordernumber = 'P180429162720501' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289861'
                WHERE ordernumber = 'P200429162928566' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94007'
                WHERE ordernumber = 'P180429163425481' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387527'
                WHERE ordernumber = 'P630429163549366' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240340'
                WHERE ordernumber = 'P200429164122213' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102970'
                WHERE ordernumber = 'P200429164154918' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387528'
                WHERE ordernumber = 'P200429164638495' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347676'
                WHERE ordernumber = 'P180429165439520' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279917'
                WHERE ordernumber = 'P180429170127242' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387533'
                WHERE ordernumber = 'P200429170756846' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252207'
                WHERE ordernumber = 'P180429170913500' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387534'
                WHERE ordernumber = 'P180429171256563' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296804'
                WHERE ordernumber = 'P200429171409200' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383986'
                WHERE ordernumber = 'P200429171616768' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387535'
                WHERE ordernumber = 'P180429171833511' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387536'
                WHERE ordernumber = 'P200429171943499' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265350'
                WHERE ordernumber = 'P200429172117601' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387538'
                WHERE ordernumber = 'P420429172427537' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387537'
                WHERE ordernumber = 'P200429172843347' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387537'
                WHERE ordernumber = 'P200429172902211' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320456'
                WHERE ordernumber = 'P200429172956973' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387540'
                WHERE ordernumber = 'P200429174220469' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279886'
                WHERE ordernumber = 'P180429174227672' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312978'
                WHERE ordernumber = 'P420429174420302' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387541'
                WHERE ordernumber = 'P420429174553306' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387543'
                WHERE ordernumber = 'P180429174847156' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353100'
                WHERE ordernumber = 'P180429175131983' 
            
2024-04-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348268'
                WHERE ordernumber = 'P200429175437701' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387544'
                WHERE ordernumber = 'P200429175528876' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387545'
                WHERE ordernumber = 'P180429175653597' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384933'
                WHERE ordernumber = 'P420429175744500' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387546'
                WHERE ordernumber = 'P190429175903827' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130789'
                WHERE ordernumber = 'P190429180045233' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387548'
                WHERE ordernumber = 'P180429180113986' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277009'
                WHERE ordernumber = 'P200429180126359' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276569'
                WHERE ordernumber = 'P180429180350427' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230269'
                WHERE ordernumber = 'P180429180847538' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347543'
                WHERE ordernumber = 'P180429181127561' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384829'
                WHERE ordernumber = 'P420429181217917' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379027'
                WHERE ordernumber = 'P190429181516515' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387291'
                WHERE ordernumber = 'P420429181926774' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233074'
                WHERE ordernumber = 'P200429182003123' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387549'
                WHERE ordernumber = 'P420429182712744' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383380'
                WHERE ordernumber = 'P190429182830303' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297220'
                WHERE ordernumber = 'P420429183118190' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387551'
                WHERE ordernumber = 'P420429183233850' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387550'
                WHERE ordernumber = 'P590429183245733' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387552'
                WHERE ordernumber = 'P190429183314870' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64035'
                WHERE ordernumber = 'P200429183552537' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262762'
                WHERE ordernumber = 'P190429183921402' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387554'
                WHERE ordernumber = 'P200429184430685' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387556'
                WHERE ordernumber = 'P190429185005198' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291574'
                WHERE ordernumber = 'P200429185024404' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339398'
                WHERE ordernumber = 'P420429185357169' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387557'
                WHERE ordernumber = 'P200429185956955' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387559'
                WHERE ordernumber = 'P200429190431663' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281796'
                WHERE ordernumber = 'P190429190631427' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167649'
                WHERE ordernumber = 'P200429190817747' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387274'
                WHERE ordernumber = 'P200429191452720' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275959'
                WHERE ordernumber = 'P200429191602199' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387561'
                WHERE ordernumber = 'P630429192615942' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246000'
                WHERE ordernumber = 'P190429192909184' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387563'
                WHERE ordernumber = 'P590429193630251' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76607'
                WHERE ordernumber = 'P190429193842693' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387564'
                WHERE ordernumber = 'P190429193955361' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386869'
                WHERE ordernumber = 'P190429194039789' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387565'
                WHERE ordernumber = 'P200429194235992' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386869'
                WHERE ordernumber = 'P190429194329671' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387343'
                WHERE ordernumber = 'P190429194432599' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344013'
                WHERE ordernumber = 'P420429194701314' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387566'
                WHERE ordernumber = 'P420429195344528' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387566'
                WHERE ordernumber = 'P420429195621565' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387567'
                WHERE ordernumber = 'P200429195659390' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293682'
                WHERE ordernumber = 'P590429213013804' 
            
2024-04-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387575'
                WHERE ordernumber = 'P590429213710997'