2024-07-10 01:00:03 -- 將會員中心id寫入data-lake
2024-07-10 01:00:03 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-07-09%';
        
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '52557'
                WHERE ordernumber = 'P630709100510542' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358902'
                WHERE ordernumber = 'P630709102727962' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399476'
                WHERE ordernumber = 'P630709105239467' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400443'
                WHERE ordernumber = 'P420709110318492' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '35793'
                WHERE ordernumber = 'P630709110326469' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247930'
                WHERE ordernumber = 'P180709110432610' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400445'
                WHERE ordernumber = 'P420709110500557' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400446'
                WHERE ordernumber = 'P630709110553467' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400447'
                WHERE ordernumber = 'P180709110649606' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '83824'
                WHERE ordernumber = 'P180709110837980' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400448'
                WHERE ordernumber = 'P180709111404485' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400449'
                WHERE ordernumber = 'P420709112124349' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400450'
                WHERE ordernumber = 'P420709112303834' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400451'
                WHERE ordernumber = 'P180709112323664' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400396'
                WHERE ordernumber = 'P200709112351870' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400452'
                WHERE ordernumber = 'P420709112636345' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114971'
                WHERE ordernumber = 'P180709113245475' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298835'
                WHERE ordernumber = 'P420709113608262' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385157'
                WHERE ordernumber = 'P630709113713433' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400454'
                WHERE ordernumber = 'P180709113816949' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393183'
                WHERE ordernumber = 'P630709114137492' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400455'
                WHERE ordernumber = 'P630709114453340' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400456'
                WHERE ordernumber = 'P630709114652842' 
            
2024-07-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266705'
                WHERE ordernumber = 'P180709114804183' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400458'
                WHERE ordernumber = 'P180709120020232' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400460'
                WHERE ordernumber = 'P180709120154759' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400462'
                WHERE ordernumber = 'P200709120919214' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400463'
                WHERE ordernumber = 'P630709121151643' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351655'
                WHERE ordernumber = 'P180709121223375' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400464'
                WHERE ordernumber = 'P630709121412385' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97952'
                WHERE ordernumber = 'P200709121514489' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97952'
                WHERE ordernumber = 'P200709121518439' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '189982'
                WHERE ordernumber = 'P200709121828183' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400465'
                WHERE ordernumber = 'P630709122908280' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214193'
                WHERE ordernumber = 'P180709123119993' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314822'
                WHERE ordernumber = 'P200709123137124' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P200709123228627' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104847'
                WHERE ordernumber = 'P200709123313761' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400467'
                WHERE ordernumber = 'P630709123703935' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138016'
                WHERE ordernumber = 'P630709123901837' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400468'
                WHERE ordernumber = 'P630709124032372' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400469'
                WHERE ordernumber = 'P180709124355489' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303485'
                WHERE ordernumber = 'P180709125045992' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386122'
                WHERE ordernumber = 'P630709125128542' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400472'
                WHERE ordernumber = 'P180709125344311' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260341'
                WHERE ordernumber = 'P200709125548975' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400471'
                WHERE ordernumber = 'P200709125800201' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118039'
                WHERE ordernumber = 'P190709125803329' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400472'
                WHERE ordernumber = 'P180709125806156' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399457'
                WHERE ordernumber = 'P200709130045718' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400474'
                WHERE ordernumber = 'P180709130304264' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399457'
                WHERE ordernumber = 'P200709130339247' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400475'
                WHERE ordernumber = 'P180709130948259' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400476'
                WHERE ordernumber = 'P180709131137867' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400477'
                WHERE ordernumber = 'P180709131242571' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400478'
                WHERE ordernumber = 'P180709131346839' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286124'
                WHERE ordernumber = 'P180709132924710' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394485'
                WHERE ordernumber = 'P180709133242410' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400484'
                WHERE ordernumber = 'P180709133636611' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400485'
                WHERE ordernumber = 'P180709133817868' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214211'
                WHERE ordernumber = 'P180709134051238' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263148'
                WHERE ordernumber = 'P180709134333239' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400487'
                WHERE ordernumber = 'P180709134437704' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400488'
                WHERE ordernumber = 'P630709134706281' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400489'
                WHERE ordernumber = 'P630709134939319' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98774'
                WHERE ordernumber = 'P200709135022114' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400490'
                WHERE ordernumber = 'P190709135536903' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246892'
                WHERE ordernumber = 'P200709135818840' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128867'
                WHERE ordernumber = 'P200709135947561' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397997'
                WHERE ordernumber = 'P180709140303460' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P180709140440274' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345365'
                WHERE ordernumber = 'P200709140545628' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336631'
                WHERE ordernumber = 'P180709141325452' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345365'
                WHERE ordernumber = 'P200709141413120' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112848'
                WHERE ordernumber = 'P590709141605238' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400479'
                WHERE ordernumber = 'P180709142547309' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357946'
                WHERE ordernumber = 'P200709143018707' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400495'
                WHERE ordernumber = 'P630709143335780' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400498'
                WHERE ordernumber = 'P630709143830850' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400497'
                WHERE ordernumber = 'P420709143848622' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238456'
                WHERE ordernumber = 'P420709144841510' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400499'
                WHERE ordernumber = 'P190709144859483' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389365'
                WHERE ordernumber = 'P180709145034576' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400501'
                WHERE ordernumber = 'P190709145335848' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P200709145744484' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400502'
                WHERE ordernumber = 'P420709145755628' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400503'
                WHERE ordernumber = 'P420709145928229' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318415'
                WHERE ordernumber = 'P420709150048191' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400504'
                WHERE ordernumber = 'P180709150231786' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398447'
                WHERE ordernumber = 'P190709150440608' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235014'
                WHERE ordernumber = 'P200709150631793' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400505'
                WHERE ordernumber = 'P200709151008388' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94455'
                WHERE ordernumber = 'P180709151048528' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400506'
                WHERE ordernumber = 'P190709151716357' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400507'
                WHERE ordernumber = 'P180709152057190' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P180709152711183' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400510'
                WHERE ordernumber = 'P190709153109704' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300227'
                WHERE ordernumber = 'P180709153314209' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320487'
                WHERE ordernumber = 'P190709153412741' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259850'
                WHERE ordernumber = 'P180709153843878' 
            
2024-07-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '193981'
                WHERE ordernumber = 'P180709154000574' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374922'
                WHERE ordernumber = 'P180709154250314' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234444'
                WHERE ordernumber = 'P420709154257643' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303580'
                WHERE ordernumber = 'P190709154327939' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '233739'
                WHERE ordernumber = 'P180709154418186' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400511'
                WHERE ordernumber = 'P180709154529132' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '91648'
                WHERE ordernumber = 'P180709154839173' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '91648'
                WHERE ordernumber = 'P180709154910563' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180709155825808' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180709160652962' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387632'
                WHERE ordernumber = 'P180709160817268' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279319'
                WHERE ordernumber = 'P180709161722672' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400515'
                WHERE ordernumber = 'P180709161825547' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396275'
                WHERE ordernumber = 'P180709161908582' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387222'
                WHERE ordernumber = 'P180709161952976' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400516'
                WHERE ordernumber = 'P180709162330626' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306252'
                WHERE ordernumber = 'P200709162714972' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381117'
                WHERE ordernumber = 'P200709163541564' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400520'
                WHERE ordernumber = 'P180709163640555' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400520'
                WHERE ordernumber = 'P180709163724585' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295733'
                WHERE ordernumber = 'P200709164406355' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400523'
                WHERE ordernumber = 'P630709165121889' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400524'
                WHERE ordernumber = 'P200709165153415' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400525'
                WHERE ordernumber = 'P200709165406166' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400526'
                WHERE ordernumber = 'P200709170440336' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398893'
                WHERE ordernumber = 'P630709170542880' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387506'
                WHERE ordernumber = 'P180709170826721' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343265'
                WHERE ordernumber = 'P200709170849198' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159170'
                WHERE ordernumber = 'P200709171016422' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318659'
                WHERE ordernumber = 'P180709171032163' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400529'
                WHERE ordernumber = 'P180709171357887' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400531'
                WHERE ordernumber = 'P180709171847929' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383666'
                WHERE ordernumber = 'P180709172300222' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397652'
                WHERE ordernumber = 'P590709173443578' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400534'
                WHERE ordernumber = 'P630709173458871' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397652'
                WHERE ordernumber = 'P590709173811234' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400534'
                WHERE ordernumber = 'P630709174016920' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400536'
                WHERE ordernumber = 'P200709174118269' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400537'
                WHERE ordernumber = 'P180709174146676' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400538'
                WHERE ordernumber = 'P180709174332157' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306821'
                WHERE ordernumber = 'P180709174641477' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400539'
                WHERE ordernumber = 'P420709174944431' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300239'
                WHERE ordernumber = 'P420709180024590' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400544'
                WHERE ordernumber = 'P200709180027576' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400545'
                WHERE ordernumber = 'P420709180149878' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400546'
                WHERE ordernumber = 'P200709180251163' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400547'
                WHERE ordernumber = 'P200709180807801' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400548'
                WHERE ordernumber = 'P420709180907371' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400549'
                WHERE ordernumber = 'P200709181155451' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400553'
                WHERE ordernumber = 'P200709182256656' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400555'
                WHERE ordernumber = 'P200709182603792' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238469'
                WHERE ordernumber = 'P180709182800543' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400557'
                WHERE ordernumber = 'P200709183137200' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400558'
                WHERE ordernumber = 'P420709183827851' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400288'
                WHERE ordernumber = 'P420709184318716' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400560'
                WHERE ordernumber = 'P200709185013251' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291269'
                WHERE ordernumber = 'P190709185312536' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291269'
                WHERE ordernumber = 'P190709185913597' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400562'
                WHERE ordernumber = 'P190709190429586' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400562'
                WHERE ordernumber = 'P190709190542479' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400059'
                WHERE ordernumber = 'P200709190657123' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400563'
                WHERE ordernumber = 'P190709190816200' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '375511'
                WHERE ordernumber = 'P190709190934422' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94310'
                WHERE ordernumber = 'P200709191109430' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400564'
                WHERE ordernumber = 'P190709191212264' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400565'
                WHERE ordernumber = 'P190709191426444' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400566'
                WHERE ordernumber = 'P190709192303645' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400567'
                WHERE ordernumber = 'P190709192639728' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400568'
                WHERE ordernumber = 'P190709192932444' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400569'
                WHERE ordernumber = 'P630709193203318' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400543'
                WHERE ordernumber = 'P190709193650960' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '207110'
                WHERE ordernumber = 'P190709193901187' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400572'
                WHERE ordernumber = 'P190709194423502' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392009'
                WHERE ordernumber = 'P190709194520414' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292403'
                WHERE ordernumber = 'P190709195128364' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128867'
                WHERE ordernumber = 'P200709195351416' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283390'
                WHERE ordernumber = 'P190709195816411' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283390'
                WHERE ordernumber = 'P190709200027461' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400574'
                WHERE ordernumber = 'P630709205405608' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400575'
                WHERE ordernumber = 'P630709205626169' 
            
2024-07-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372907'
                WHERE ordernumber = 'P630709210502450'