2024-05-25 01:00:02 -- 將會員中心id寫入data-lake
2024-05-25 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-05-24%';
        
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391652'
                WHERE ordernumber = 'P630524103751940' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389567'
                WHERE ordernumber = 'P200524110152554' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382606'
                WHERE ordernumber = 'P420524110206236' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180524110411836' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391676'
                WHERE ordernumber = 'P180524110742943' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312940'
                WHERE ordernumber = 'P180524110839275' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307366'
                WHERE ordernumber = 'P420524110936571' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93985'
                WHERE ordernumber = 'P630524111015870' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391677'
                WHERE ordernumber = 'P180524111247621' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391677'
                WHERE ordernumber = 'P180524111346151' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '215517'
                WHERE ordernumber = 'P200524111415884' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137703'
                WHERE ordernumber = 'P200524111606813' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391632'
                WHERE ordernumber = 'P180524112335650' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391678'
                WHERE ordernumber = 'P180524112604306' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111677'
                WHERE ordernumber = 'P180524113152836' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391681'
                WHERE ordernumber = 'P200524113657375' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344666'
                WHERE ordernumber = 'P180524113827359' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326187'
                WHERE ordernumber = 'P180524114101653' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240795'
                WHERE ordernumber = 'P200524114520916' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130149'
                WHERE ordernumber = 'P180524114552295' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391683'
                WHERE ordernumber = 'P790524114935235' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391684'
                WHERE ordernumber = 'P200524115036568' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313319'
                WHERE ordernumber = 'P420524115237451' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391685'
                WHERE ordernumber = 'P200524115524505' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391687'
                WHERE ordernumber = 'P180524115852129' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317718'
                WHERE ordernumber = 'P420524115906199' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391688'
                WHERE ordernumber = 'P420524120130270' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301938'
                WHERE ordernumber = 'P200524120947926' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391690'
                WHERE ordernumber = 'P790524121215238' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391691'
                WHERE ordernumber = 'P420524121400137' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391692'
                WHERE ordernumber = 'P630524121534150' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391694'
                WHERE ordernumber = 'P200524121857460' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391694'
                WHERE ordernumber = 'P200524121952509' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391695'
                WHERE ordernumber = 'P420524122057974' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388234'
                WHERE ordernumber = 'P180524122224915' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391697'
                WHERE ordernumber = 'P420524122622899' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '4'
                WHERE ordernumber = 'P420524122729775' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '117532'
                WHERE ordernumber = 'P190524122809208' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391696'
                WHERE ordernumber = 'P790524122921194' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99421'
                WHERE ordernumber = 'P180524122924456' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '87627'
                WHERE ordernumber = 'P180524123125444' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391698'
                WHERE ordernumber = 'P790524123127866' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391700'
                WHERE ordernumber = 'P790524123546839' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107818'
                WHERE ordernumber = 'P200524123759122' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391486'
                WHERE ordernumber = 'P200524124003630' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247164'
                WHERE ordernumber = 'P200524124207620' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '256216'
                WHERE ordernumber = 'P180524124221820' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '65115'
                WHERE ordernumber = 'P200524124449201' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381199'
                WHERE ordernumber = 'P420524124504171' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391703'
                WHERE ordernumber = 'P200524124752618' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336285'
                WHERE ordernumber = 'P200524125031718' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391704'
                WHERE ordernumber = 'P180524125134869' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391705'
                WHERE ordernumber = 'P420524125351623' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329424'
                WHERE ordernumber = 'P200524125430571' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390828'
                WHERE ordernumber = 'P200524125958346' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390828'
                WHERE ordernumber = 'P200524130048206' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391709'
                WHERE ordernumber = 'P200524130307640' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391710'
                WHERE ordernumber = 'P180524130449931' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391712'
                WHERE ordernumber = 'P180524130658437' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391713'
                WHERE ordernumber = 'P790524130900309' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391714'
                WHERE ordernumber = 'P180524131246222' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391715'
                WHERE ordernumber = 'P180524131402999' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317861'
                WHERE ordernumber = 'P420524131921640' 
            
2024-05-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252933'
                WHERE ordernumber = 'P200524132444621' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242509'
                WHERE ordernumber = 'P190524132713606' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391719'
                WHERE ordernumber = 'P200524132837713' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101636'
                WHERE ordernumber = 'P180524132928547' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391717'
                WHERE ordernumber = 'P710524132944362' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224776'
                WHERE ordernumber = 'P180524133107921' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391720'
                WHERE ordernumber = 'P420524134027157' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209723'
                WHERE ordernumber = 'P180524134505639' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391721'
                WHERE ordernumber = 'P200524134542880' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391722'
                WHERE ordernumber = 'P790524135105184' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391724'
                WHERE ordernumber = 'P790524135520577' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391725'
                WHERE ordernumber = 'P190524135536165' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391727'
                WHERE ordernumber = 'P200524135636321' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391726'
                WHERE ordernumber = 'P420524135652702' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390810'
                WHERE ordernumber = 'P710524135803757' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391723'
                WHERE ordernumber = 'P790524135824875' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391725'
                WHERE ordernumber = 'P180524140031626' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136084'
                WHERE ordernumber = 'P200524140204378' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391404'
                WHERE ordernumber = 'P710524140800312' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112543'
                WHERE ordernumber = 'P190524141610604' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391729'
                WHERE ordernumber = 'P420524141715388' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P200524141759156' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391730'
                WHERE ordernumber = 'P420524142124739' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '15611'
                WHERE ordernumber = 'P420524142222241' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334545'
                WHERE ordernumber = 'P180524142848369' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391732'
                WHERE ordernumber = 'P180524143056127' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264565'
                WHERE ordernumber = 'P200524143232348' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350416'
                WHERE ordernumber = 'P180524143612780' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123891'
                WHERE ordernumber = 'P190524143726514' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389388'
                WHERE ordernumber = 'P180524144002556' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123891'
                WHERE ordernumber = 'P180524144100634' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345773'
                WHERE ordernumber = 'P190524144121246' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221314'
                WHERE ordernumber = 'P180524144319662' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391735'
                WHERE ordernumber = 'P190524144439556' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391734'
                WHERE ordernumber = 'P630524144600585' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '40337'
                WHERE ordernumber = 'P420524144730796' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305271'
                WHERE ordernumber = 'P200524145156790' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391738'
                WHERE ordernumber = 'P180524145556227' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391740'
                WHERE ordernumber = 'P200524145623731' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391742'
                WHERE ordernumber = 'P180524145715130' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390699'
                WHERE ordernumber = 'P180524150200501' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391738'
                WHERE ordernumber = 'P180524150456786' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391737'
                WHERE ordernumber = 'P420524150510537' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358870'
                WHERE ordernumber = 'P200524150659686' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391744'
                WHERE ordernumber = 'P180524150909490' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391746'
                WHERE ordernumber = 'P420524151032217' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391747'
                WHERE ordernumber = 'P190524151108180' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391748'
                WHERE ordernumber = 'P200524151127755' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391749'
                WHERE ordernumber = 'P180524151138115' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391750'
                WHERE ordernumber = 'P180524151636247' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391752'
                WHERE ordernumber = 'P420524152320716' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391751'
                WHERE ordernumber = 'P790524152801375' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391754'
                WHERE ordernumber = 'P710524153259710' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377384'
                WHERE ordernumber = 'P180524153710586' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391755'
                WHERE ordernumber = 'P200524153723144' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325741'
                WHERE ordernumber = 'P190524154104871' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368215'
                WHERE ordernumber = 'P420524154622381' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391759'
                WHERE ordernumber = 'P420524154741129' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391758'
                WHERE ordernumber = 'P200524154743836' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391762'
                WHERE ordernumber = 'P180524155316726' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391763'
                WHERE ordernumber = 'P190524155332172' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102102'
                WHERE ordernumber = 'P180524155445505' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391757'
                WHERE ordernumber = 'P790524155533634' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391764'
                WHERE ordernumber = 'P200524160112159' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365729'
                WHERE ordernumber = 'P180524160137331' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97293'
                WHERE ordernumber = 'P200524160313375' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391765'
                WHERE ordernumber = 'P630524160835215' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385857'
                WHERE ordernumber = 'P630524160921496' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307366'
                WHERE ordernumber = 'P420524161122389' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '144274'
                WHERE ordernumber = 'P200524161210922' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387953'
                WHERE ordernumber = 'P420524162011694' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358895'
                WHERE ordernumber = 'P200524162346773' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391766'
                WHERE ordernumber = 'P420524162817775' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391767'
                WHERE ordernumber = 'P420524162913743' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391769'
                WHERE ordernumber = 'P190524163219216' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391768'
                WHERE ordernumber = 'P180524163314627' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391770'
                WHERE ordernumber = 'P200524163349331' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391771'
                WHERE ordernumber = 'P200524163644843' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391772'
                WHERE ordernumber = 'P200524163751501' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391773'
                WHERE ordernumber = 'P180524163828138' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391775'
                WHERE ordernumber = 'P190524164041754' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100658'
                WHERE ordernumber = 'P200524164343871' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391776'
                WHERE ordernumber = 'P790524164710264' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112848'
                WHERE ordernumber = 'P590524164748953' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385965'
                WHERE ordernumber = 'P630524164950932' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106473'
                WHERE ordernumber = 'P180524165128449' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391778'
                WHERE ordernumber = 'P190524165241407' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391779'
                WHERE ordernumber = 'P420524165310381' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391781'
                WHERE ordernumber = 'P630524165538665' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391780'
                WHERE ordernumber = 'P790524165554175' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391782'
                WHERE ordernumber = 'P200524165554776' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391066'
                WHERE ordernumber = 'P200524165703139' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391783'
                WHERE ordernumber = 'P790524171239349' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391784'
                WHERE ordernumber = 'P190524171309619' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391787'
                WHERE ordernumber = 'P200524171647559' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349196'
                WHERE ordernumber = 'P200524171733704' 
            
2024-05-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391788'
                WHERE ordernumber = 'P420524171908488' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334831'
                WHERE ordernumber = 'P180524172421177' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383353'
                WHERE ordernumber = 'P420524172433801' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235944'
                WHERE ordernumber = 'P710524172437448' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207135'
                WHERE ordernumber = 'P190524172749788' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P180524173200805' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391790'
                WHERE ordernumber = 'P190524173211229' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391793'
                WHERE ordernumber = 'P420524174608924' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228713'
                WHERE ordernumber = 'P200524174802252' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284600'
                WHERE ordernumber = 'P180524174905454' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391795'
                WHERE ordernumber = 'P200524174913647' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389144'
                WHERE ordernumber = 'P420524174924842' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391796'
                WHERE ordernumber = 'P190524175032256' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220362'
                WHERE ordernumber = 'P180524175508709' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105986'
                WHERE ordernumber = 'P180524175857334' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391799'
                WHERE ordernumber = 'P790524180043306' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391800'
                WHERE ordernumber = 'P180524180300847' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '189996'
                WHERE ordernumber = 'P180524180817194' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391801'
                WHERE ordernumber = 'P790524181058560' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391802'
                WHERE ordernumber = 'P180524181309266' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391804'
                WHERE ordernumber = 'P180524181625161' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372870'
                WHERE ordernumber = 'P180524181840696' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391806'
                WHERE ordernumber = 'P200524181939336' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129219'
                WHERE ordernumber = 'P180524182058657' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391810'
                WHERE ordernumber = 'P200524182124134' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388525'
                WHERE ordernumber = 'P200524182246992' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279795'
                WHERE ordernumber = 'P180524182413351' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278056'
                WHERE ordernumber = 'P190524182503579' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '69101'
                WHERE ordernumber = 'P790524182529956' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391811'
                WHERE ordernumber = 'P200524183513793' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391813'
                WHERE ordernumber = 'P200524184315285' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391812'
                WHERE ordernumber = 'P790524184429559' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391815'
                WHERE ordernumber = 'P200524184430158' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160220'
                WHERE ordernumber = 'P190524184531769' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173393'
                WHERE ordernumber = 'P630524184635591' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391814'
                WHERE ordernumber = 'P710524184703316' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391807'
                WHERE ordernumber = 'P790524184715958' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391809'
                WHERE ordernumber = 'P790524184850864' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391816'
                WHERE ordernumber = 'P790524184933342' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93881'
                WHERE ordernumber = 'P710524184955748' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290536'
                WHERE ordernumber = 'P200524185031773' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235944'
                WHERE ordernumber = 'P710524185313639' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P190524190006326' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391821'
                WHERE ordernumber = 'P420524190531727' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389972'
                WHERE ordernumber = 'P420524190917321' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218049'
                WHERE ordernumber = 'P710524191726748' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351233'
                WHERE ordernumber = 'P190524191902334' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391824'
                WHERE ordernumber = 'P790524192009539' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391818'
                WHERE ordernumber = 'P790524192053685' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391822'
                WHERE ordernumber = 'P190524192109223' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391823'
                WHERE ordernumber = 'P790524192130592' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391808'
                WHERE ordernumber = 'P790524192437939' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391827'
                WHERE ordernumber = 'P190524192509886' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391826'
                WHERE ordernumber = 'P790524192534824' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391828'
                WHERE ordernumber = 'P190524192555335' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278318'
                WHERE ordernumber = 'P190524192638913' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391675'
                WHERE ordernumber = 'P630524193100763' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391675'
                WHERE ordernumber = 'P630524193538244' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391830'
                WHERE ordernumber = 'P630524193850326' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245620'
                WHERE ordernumber = 'P190524194018674' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391829'
                WHERE ordernumber = 'P710524194031245' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105630'
                WHERE ordernumber = 'P200524194216952' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391805'
                WHERE ordernumber = 'P790524194726632' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321877'
                WHERE ordernumber = 'P420524194844316' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371409'
                WHERE ordernumber = 'P200524194925474' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391831'
                WHERE ordernumber = 'P710524195143162' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391832'
                WHERE ordernumber = 'P190524195324385' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391834'
                WHERE ordernumber = 'P630524195824164' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391833'
                WHERE ordernumber = 'P710524195827706' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391836'
                WHERE ordernumber = 'P630524200531835' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244343'
                WHERE ordernumber = 'P630524200656489' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388574'
                WHERE ordernumber = 'P710524200819873' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388915'
                WHERE ordernumber = 'P630524201133236' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391837'
                WHERE ordernumber = 'P790524201304419' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391838'
                WHERE ordernumber = 'P710524202348796' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391840'
                WHERE ordernumber = 'P790524203203999' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391841'
                WHERE ordernumber = 'P790524203309649' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163657'
                WHERE ordernumber = 'P630524204641622' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391846'
                WHERE ordernumber = 'P710524211932448' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391847'
                WHERE ordernumber = 'P790524212109161' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391849'
                WHERE ordernumber = 'P710524212833820' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173249'
                WHERE ordernumber = 'P790524214258183' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391853'
                WHERE ordernumber = 'P790524214549986' 
            
2024-05-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391855'
                WHERE ordernumber = 'P790524215600432'