2024-08-28 01:00:02 -- 將會員中心id寫入data-lake
2024-08-28 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-08-27%';
        
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '29716'
                WHERE ordernumber = 'P630827104612499' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P190827110247237' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414532'
                WHERE ordernumber = 'P190827110433820' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414531'
                WHERE ordernumber = 'P180827110452421' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96489'
                WHERE ordernumber = 'P420827110524394' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230522'
                WHERE ordernumber = 'P190827110525526' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414542'
                WHERE ordernumber = 'P190827110652396' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294892'
                WHERE ordernumber = 'P200827110653594' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414529'
                WHERE ordernumber = 'P190827110808393' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414543'
                WHERE ordernumber = 'P420827110820438' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398015'
                WHERE ordernumber = 'P190827111021279' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291742'
                WHERE ordernumber = 'P200827111107302' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397977'
                WHERE ordernumber = 'P630827111124255' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266521'
                WHERE ordernumber = 'P420827111244582' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414547'
                WHERE ordernumber = 'P180827111340518' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402011'
                WHERE ordernumber = 'P190827111353889' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414548'
                WHERE ordernumber = 'P200827111455773' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414550'
                WHERE ordernumber = 'P420827111557949' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414553'
                WHERE ordernumber = 'P180827111748440' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '182519'
                WHERE ordernumber = 'P180827111910150' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414556'
                WHERE ordernumber = 'P420827112024277' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414557'
                WHERE ordernumber = 'P180827112030845' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414558'
                WHERE ordernumber = 'P180827112306868' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94924'
                WHERE ordernumber = 'P180827112407831' 
            
2024-08-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '124614'
                WHERE ordernumber = 'P190827112619688' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124614'
                WHERE ordernumber = 'P190827112643980' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401824'
                WHERE ordernumber = 'P420827112753223' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74167'
                WHERE ordernumber = 'P200827112850237' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157383'
                WHERE ordernumber = 'P190827113023381' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414563'
                WHERE ordernumber = 'P420827113104931' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414564'
                WHERE ordernumber = 'P180827113152656' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100714'
                WHERE ordernumber = 'P180827113526309' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414567'
                WHERE ordernumber = 'P190827113803413' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386849'
                WHERE ordernumber = 'P180827113927250' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99933'
                WHERE ordernumber = 'P200827114057525' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414573'
                WHERE ordernumber = 'P180827114228179' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414575'
                WHERE ordernumber = 'P180827114432967' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308114'
                WHERE ordernumber = 'P420827114438476' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414374'
                WHERE ordernumber = 'P180827114552299' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335673'
                WHERE ordernumber = 'P180827114711791' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337311'
                WHERE ordernumber = 'P420827115000246' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414582'
                WHERE ordernumber = 'P190827115039725' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414584'
                WHERE ordernumber = 'P180827115210353' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79058'
                WHERE ordernumber = 'P420827115323881' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414586'
                WHERE ordernumber = 'P180827115342501' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414574'
                WHERE ordernumber = 'P180827115358400' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414588'
                WHERE ordernumber = 'P420827115825860' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '197445'
                WHERE ordernumber = 'P200827120133686' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408822'
                WHERE ordernumber = 'P420827120410294' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180827120618474' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414594'
                WHERE ordernumber = 'P180827120736721' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230984'
                WHERE ordernumber = 'P200827120737754' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '91733'
                WHERE ordernumber = 'P180827120938799' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369186'
                WHERE ordernumber = 'P420827120945165' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162138'
                WHERE ordernumber = 'P180827121026369' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102966'
                WHERE ordernumber = 'P180827121442369' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414602'
                WHERE ordernumber = 'P180827121607742' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '91709'
                WHERE ordernumber = 'P180827121729201' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414558'
                WHERE ordernumber = 'P180827121809435' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '72415'
                WHERE ordernumber = 'P200827121841652' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414603'
                WHERE ordernumber = 'P180827122006292' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282077'
                WHERE ordernumber = 'P200827122527492' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305366'
                WHERE ordernumber = 'P180827122534781' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277541'
                WHERE ordernumber = 'P200827122628964' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414606'
                WHERE ordernumber = 'P180827122723871' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414608'
                WHERE ordernumber = 'P420827122728460' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414610'
                WHERE ordernumber = 'P200827122818511' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414606'
                WHERE ordernumber = 'P180827122822915' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411014'
                WHERE ordernumber = 'P180827123010598' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397137'
                WHERE ordernumber = 'P630827123332957' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90887'
                WHERE ordernumber = 'P180827123417904' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218580'
                WHERE ordernumber = 'P200827123431985' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336616'
                WHERE ordernumber = 'P200827123749424' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355605'
                WHERE ordernumber = 'P420827123809957' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377729'
                WHERE ordernumber = 'P190827124120117' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414623'
                WHERE ordernumber = 'P420827124316700' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414626'
                WHERE ordernumber = 'P190827124444668' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377729'
                WHERE ordernumber = 'P190827124520220' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360649'
                WHERE ordernumber = 'P420827124816875' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414634'
                WHERE ordernumber = 'P190827125250761' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283536'
                WHERE ordernumber = 'P200827125345636' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414637'
                WHERE ordernumber = 'P420827125457841' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414639'
                WHERE ordernumber = 'P200827125542243' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414632'
                WHERE ordernumber = 'P420827125654816' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414641'
                WHERE ordernumber = 'P180827125714721' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390588'
                WHERE ordernumber = 'P420827125819546' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332144'
                WHERE ordernumber = 'P420827125941865' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414644'
                WHERE ordernumber = 'P420827130059315' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414645'
                WHERE ordernumber = 'P420827130218340' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409940'
                WHERE ordernumber = 'P420827130637764' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414649'
                WHERE ordernumber = 'P180827131120786' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414655'
                WHERE ordernumber = 'P190827131406274' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329610'
                WHERE ordernumber = 'P420827131443111' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414656'
                WHERE ordernumber = 'P180827131637677' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '29716'
                WHERE ordernumber = 'P630827132044591' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88988'
                WHERE ordernumber = 'P420827132602134' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414660'
                WHERE ordernumber = 'P200827132633135' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414664'
                WHERE ordernumber = 'P180827132746583' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414666'
                WHERE ordernumber = 'P200827133345198' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414668'
                WHERE ordernumber = 'P180827133548284' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336116'
                WHERE ordernumber = 'P200827133850616' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402126'
                WHERE ordernumber = 'P190827134345678' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414675'
                WHERE ordernumber = 'P180827134552153' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379133'
                WHERE ordernumber = 'P180827134629448' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330724'
                WHERE ordernumber = 'P190827134723790' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414679'
                WHERE ordernumber = 'P180827135319270' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100928'
                WHERE ordernumber = 'P200827135826698' 
            
2024-08-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214415'
                WHERE ordernumber = 'P180827135935282' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414680'
                WHERE ordernumber = 'P190827140402188' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414682'
                WHERE ordernumber = 'P420827140433764' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301528'
                WHERE ordernumber = 'P420827140522270' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414683'
                WHERE ordernumber = 'P420827140642958' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414684'
                WHERE ordernumber = 'P190827140655471' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392772'
                WHERE ordernumber = 'P200827140845507' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414687'
                WHERE ordernumber = 'P420827141329198' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249469'
                WHERE ordernumber = 'P200827141626883' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228013'
                WHERE ordernumber = 'P180827141745941' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414693'
                WHERE ordernumber = 'P420827141758202' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401440'
                WHERE ordernumber = 'P180827142103291' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276738'
                WHERE ordernumber = 'P180827142612544' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414698'
                WHERE ordernumber = 'P200827142629781' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388071'
                WHERE ordernumber = 'P180827142742733' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '91507'
                WHERE ordernumber = 'P200827142839740' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414702'
                WHERE ordernumber = 'P420827143007972' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396443'
                WHERE ordernumber = 'P200827143231150' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368915'
                WHERE ordernumber = 'P200827143332332' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380155'
                WHERE ordernumber = 'P180827143516654' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131196'
                WHERE ordernumber = 'P180827143605548' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334631'
                WHERE ordernumber = 'P420827143619977' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217291'
                WHERE ordernumber = 'P200827143632172' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366745'
                WHERE ordernumber = 'P190827144228418' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414081'
                WHERE ordernumber = 'P190827144348906' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414712'
                WHERE ordernumber = 'P180827144437836' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413784'
                WHERE ordernumber = 'P200827144534808' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414714'
                WHERE ordernumber = 'P420827144805876' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414716'
                WHERE ordernumber = 'P420827144954876' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414717'
                WHERE ordernumber = 'P180827145335235' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414719'
                WHERE ordernumber = 'P180827145652807' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362423'
                WHERE ordernumber = 'P180827145948127' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414722'
                WHERE ordernumber = 'P420827150006320' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414722'
                WHERE ordernumber = 'P420827150047408' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414724'
                WHERE ordernumber = 'P200827150154548' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414725'
                WHERE ordernumber = 'P420827150215523' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414727'
                WHERE ordernumber = 'P180827150358793' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396082'
                WHERE ordernumber = 'P200827150517625' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414731'
                WHERE ordernumber = 'P180827150729300' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414734'
                WHERE ordernumber = 'P200827150759813' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396082'
                WHERE ordernumber = 'P200827150840529' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414738'
                WHERE ordernumber = 'P200827151105316' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414736'
                WHERE ordernumber = 'P420827151127952' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414735'
                WHERE ordernumber = 'P180827151141838' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414742'
                WHERE ordernumber = 'P420827151740564' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124039'
                WHERE ordernumber = 'P200827151905680' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414744'
                WHERE ordernumber = 'P180827151940422' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414749'
                WHERE ordernumber = 'P200827152625781' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414748'
                WHERE ordernumber = 'P180827152625895' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164298'
                WHERE ordernumber = 'P180827152909129' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414753'
                WHERE ordernumber = 'P420827153019902' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414755'
                WHERE ordernumber = 'P200827153143895' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246045'
                WHERE ordernumber = 'P420827153200817' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402693'
                WHERE ordernumber = 'P180827153257721' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414756'
                WHERE ordernumber = 'P420827153330557' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354353'
                WHERE ordernumber = 'P420827153448230' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226896'
                WHERE ordernumber = 'P200827153550272' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414759'
                WHERE ordernumber = 'P420827153804141' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414760'
                WHERE ordernumber = 'P180827154006554' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414764'
                WHERE ordernumber = 'P420827154030148' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414767'
                WHERE ordernumber = 'P180827154423156' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396438'
                WHERE ordernumber = 'P180827154548188' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200827154833861' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104695'
                WHERE ordernumber = 'P180827155613592' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309255'
                WHERE ordernumber = 'P190827155751539' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414775'
                WHERE ordernumber = 'P420827160107163' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82116'
                WHERE ordernumber = 'P190827160117800' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268279'
                WHERE ordernumber = 'P200827160159149' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400842'
                WHERE ordernumber = 'P420827160216171' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414777'
                WHERE ordernumber = 'P420827160428271' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408848'
                WHERE ordernumber = 'P180827160457661' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284049'
                WHERE ordernumber = 'P190827160910708' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259176'
                WHERE ordernumber = 'P200827161052421' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414780'
                WHERE ordernumber = 'P180827161336367' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '60999'
                WHERE ordernumber = 'P590827161631241' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322291'
                WHERE ordernumber = 'P200827161916655' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414786'
                WHERE ordernumber = 'P420827162155861' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100750'
                WHERE ordernumber = 'P180827162236305' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298884'
                WHERE ordernumber = 'P200827162456714' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342567'
                WHERE ordernumber = 'P420827162638870' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340513'
                WHERE ordernumber = 'P200827162906351' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390006'
                WHERE ordernumber = 'P190827163029427' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414793'
                WHERE ordernumber = 'P200827163149994' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397634'
                WHERE ordernumber = 'P190827163207146' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320225'
                WHERE ordernumber = 'P190827163455911' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '144849'
                WHERE ordernumber = 'P190827163711291' 
            
2024-08-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222590'
                WHERE ordernumber = 'P200827163843808' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414802'
                WHERE ordernumber = 'P190827164827930' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394604'
                WHERE ordernumber = 'P190827165025116' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405120'
                WHERE ordernumber = 'P190827165218912' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414809'
                WHERE ordernumber = 'P180827165606305' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313517'
                WHERE ordernumber = 'P420827165650627' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414812'
                WHERE ordernumber = 'P180827165939275' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '290405'
                WHERE ordernumber = 'P180827170124697' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414814'
                WHERE ordernumber = 'P420827170156214' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '163532'
                WHERE ordernumber = 'P200827170235497' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300056'
                WHERE ordernumber = 'P180827170300944' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101997'
                WHERE ordernumber = 'P200827170345787' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352938'
                WHERE ordernumber = 'P420827170349402' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '131177'
                WHERE ordernumber = 'P180827170829929' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399716'
                WHERE ordernumber = 'P200827170954678' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414816'
                WHERE ordernumber = 'P190827171255334' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414382'
                WHERE ordernumber = 'P190827171352829' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353285'
                WHERE ordernumber = 'P190827171529335' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405095'
                WHERE ordernumber = 'P420827171610141' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414819'
                WHERE ordernumber = 'P420827171754540' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283657'
                WHERE ordernumber = 'P200827171824973' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414820'
                WHERE ordernumber = 'P420827172148923' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218573'
                WHERE ordernumber = 'P200827172236252' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414823'
                WHERE ordernumber = 'P190827172255707' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283536'
                WHERE ordernumber = 'P200827172451152' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414827'
                WHERE ordernumber = 'P180827172617445' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228024'
                WHERE ordernumber = 'P200827172759290' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414827'
                WHERE ordernumber = 'P180827172816472' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414830'
                WHERE ordernumber = 'P180827172958538' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282700'
                WHERE ordernumber = 'P200827173012368' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180827173309743' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414832'
                WHERE ordernumber = 'P420827173313235' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414834'
                WHERE ordernumber = 'P420827173419269' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414835'
                WHERE ordernumber = 'P420827173545951' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414830'
                WHERE ordernumber = 'P180827173627529' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414837'
                WHERE ordernumber = 'P200827173801901' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414838'
                WHERE ordernumber = 'P180827173931247' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '207977'
                WHERE ordernumber = 'P200827173945957' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '127915'
                WHERE ordernumber = 'P180827174132182' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236518'
                WHERE ordernumber = 'P200827174219746' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414698'
                WHERE ordernumber = 'P200827174332982' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237070'
                WHERE ordernumber = 'P200827174441768' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '173327'
                WHERE ordernumber = 'P200827174544604' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411839'
                WHERE ordernumber = 'P420827174750767' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414844'
                WHERE ordernumber = 'P200827174850137' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '146119'
                WHERE ordernumber = 'P200827175131453' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414463'
                WHERE ordernumber = 'P180827175205692' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200827175258528' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414851'
                WHERE ordernumber = 'P200827175459631' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414852'
                WHERE ordernumber = 'P180827175515127' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414853'
                WHERE ordernumber = 'P200827175629821' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352026'
                WHERE ordernumber = 'P180827175647246' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352026'
                WHERE ordernumber = 'P180827175945169' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414855'
                WHERE ordernumber = 'P200827180440318' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352026'
                WHERE ordernumber = 'P180827180517256' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411282'
                WHERE ordernumber = 'P420827180559929' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388473'
                WHERE ordernumber = 'P200827180630177' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414856'
                WHERE ordernumber = 'P180827180856998' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414857'
                WHERE ordernumber = 'P180827181024909' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414859'
                WHERE ordernumber = 'P190827181045218' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414860'
                WHERE ordernumber = 'P180827181136817' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391040'
                WHERE ordernumber = 'P180827181236967' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414858'
                WHERE ordernumber = 'P200827181328538' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414863'
                WHERE ordernumber = 'P420827181704152' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414307'
                WHERE ordernumber = 'P200827181928949' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348437'
                WHERE ordernumber = 'P180827182333998' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389408'
                WHERE ordernumber = 'P200827182423479' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414869'
                WHERE ordernumber = 'P200827182828631' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414869'
                WHERE ordernumber = 'P200827182908416' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96821'
                WHERE ordernumber = 'P180827182937439' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96821'
                WHERE ordernumber = 'P180827183023841' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239096'
                WHERE ordernumber = 'P200827183024444' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414876'
                WHERE ordernumber = 'P180827183230171' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414877'
                WHERE ordernumber = 'P420827183348310' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '202170'
                WHERE ordernumber = 'P420827183609502' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414878'
                WHERE ordernumber = 'P180827183619648' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317600'
                WHERE ordernumber = 'P180827183737207' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404138'
                WHERE ordernumber = 'P200827183740537' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '143337'
                WHERE ordernumber = 'P200827183956463' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '186818'
                WHERE ordernumber = 'P180827184601112' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293682'
                WHERE ordernumber = 'P200827184613499' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414885'
                WHERE ordernumber = 'P200827184724996' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414104'
                WHERE ordernumber = 'P180827185619333' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414889'
                WHERE ordernumber = 'P420827185752819' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386047'
                WHERE ordernumber = 'P200827185956982' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414892'
                WHERE ordernumber = 'P420827190007496' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '335626'
                WHERE ordernumber = 'P200827190507498' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348112'
                WHERE ordernumber = 'P200827190613629' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '252298'
                WHERE ordernumber = 'P190827190938188' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414894'
                WHERE ordernumber = 'P200827191134136' 
            
2024-08-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414299'
                WHERE ordernumber = 'P190827191309416' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '167388'
                WHERE ordernumber = 'P200827191415561' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399591'
                WHERE ordernumber = 'P190827191913278' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '414897'
                WHERE ordernumber = 'P200827192426861' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '337407'
                WHERE ordernumber = 'P190827192553131' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '414903'
                WHERE ordernumber = 'P200827193104963' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '298235'
                WHERE ordernumber = 'P200827193618479' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '298235'
                WHERE ordernumber = 'P200827193708637' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '243723'
                WHERE ordernumber = 'P200827193822313' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '392518'
                WHERE ordernumber = 'P200827193948829' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '414906'
                WHERE ordernumber = 'P190827194002689' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '414908'
                WHERE ordernumber = 'P200827194157946' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '114408'
                WHERE ordernumber = 'P190827194249885' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '414905'
                WHERE ordernumber = 'P190827194421774' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '414906'
                WHERE ordernumber = 'P190827194806899' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '95650'
                WHERE ordernumber = 'P190827195008427' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '414910'
                WHERE ordernumber = 'P200827195210154' 
            
2024-08-28 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '414912'
                WHERE ordernumber = 'P200827195513736'