2024-06-06 01:00:01 -- 將會員中心id寫入data-lake
2024-06-06 01:00:01 -- 
            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-06-05%';
        
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '96489'
                WHERE ordernumber = 'P420605110231789' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '374942'
                WHERE ordernumber = 'P180605110258634' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '392570'
                WHERE ordernumber = 'P190605110333557' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '96489'
                WHERE ordernumber = 'P420605110359722' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '392331'
                WHERE ordernumber = 'P190605110443573' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '394289'
                WHERE ordernumber = 'P420605110528148' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '381144'
                WHERE ordernumber = 'P180605110618255' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '294471'
                WHERE ordernumber = 'P190605110839204' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '393185'
                WHERE ordernumber = 'P180605110904946' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '115122'
                WHERE ordernumber = 'P180605111015970' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '294471'
                WHERE ordernumber = 'P190605111127895' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '394292'
                WHERE ordernumber = 'P190605111404238' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '44919'
                WHERE ordernumber = 'P420605111435650' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '394293'
                WHERE ordernumber = 'P180605111522751' 
            
2024-06-06 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '278656'
                WHERE ordernumber = 'P420605111956973' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394294'
                WHERE ordernumber = 'P630605112051534' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394295'
                WHERE ordernumber = 'P420605112236898' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273066'
                WHERE ordernumber = 'P190605112437524' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394296'
                WHERE ordernumber = 'P180605112553398' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394297'
                WHERE ordernumber = 'P190605112644744' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374418'
                WHERE ordernumber = 'P190605112717568' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394298'
                WHERE ordernumber = 'P420605112724345' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375005'
                WHERE ordernumber = 'P180605112746850' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300622'
                WHERE ordernumber = 'P180605112916712' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394300'
                WHERE ordernumber = 'P180605113227437' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390886'
                WHERE ordernumber = 'P420605113413871' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394301'
                WHERE ordernumber = 'P200605113508499' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394066'
                WHERE ordernumber = 'P420605113916853' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113599'
                WHERE ordernumber = 'P190605114550364' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394302'
                WHERE ordernumber = 'P180605114727934' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394302'
                WHERE ordernumber = 'P180605114747257' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394302'
                WHERE ordernumber = 'P180605114817282' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335349'
                WHERE ordernumber = 'P420605114832941' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384131'
                WHERE ordernumber = 'P630605115536662' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '170686'
                WHERE ordernumber = 'P200605120205285' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389340'
                WHERE ordernumber = 'P180605120206861' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388391'
                WHERE ordernumber = 'P710605120336687' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394304'
                WHERE ordernumber = 'P420605120546112' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '175765'
                WHERE ordernumber = 'P200605120631613' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287062'
                WHERE ordernumber = 'P200605120936760' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394305'
                WHERE ordernumber = 'P180605121304457' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394306'
                WHERE ordernumber = 'P190605121414184' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394307'
                WHERE ordernumber = 'P200605121515170' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394309'
                WHERE ordernumber = 'P420605121639187' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228228'
                WHERE ordernumber = 'P180605121643956' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216943'
                WHERE ordernumber = 'P200605122021172' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374147'
                WHERE ordernumber = 'P180605122201907' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '72390'
                WHERE ordernumber = 'P420605122614796' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394312'
                WHERE ordernumber = 'P180605122751493' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P420605122846155' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '173337'
                WHERE ordernumber = 'P710605123125916' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154618'
                WHERE ordernumber = 'P200605123216662' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394314'
                WHERE ordernumber = 'P780605123315203' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394317'
                WHERE ordernumber = 'P180605123503220' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261648'
                WHERE ordernumber = 'P180605123813381' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346989'
                WHERE ordernumber = 'P190605123840312' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281418'
                WHERE ordernumber = 'P180605124008257' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222035'
                WHERE ordernumber = 'P180605124248996' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394315'
                WHERE ordernumber = 'P180605125100437' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394315'
                WHERE ordernumber = 'P180605125132719' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394321'
                WHERE ordernumber = 'P200605125403292' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355346'
                WHERE ordernumber = 'P420605125424963' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255987'
                WHERE ordernumber = 'P420605130243199' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248970'
                WHERE ordernumber = 'P200605130313994' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380177'
                WHERE ordernumber = 'P420605130838768' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138014'
                WHERE ordernumber = 'P180605131558618' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394326'
                WHERE ordernumber = 'P200605131746687' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394327'
                WHERE ordernumber = 'P200605132238654' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379131'
                WHERE ordernumber = 'P180605132307990' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394328'
                WHERE ordernumber = 'P180605132551316' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253541'
                WHERE ordernumber = 'P180605132852457' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243770'
                WHERE ordernumber = 'P180605133430368' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394331'
                WHERE ordernumber = 'P200605133558213' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394329'
                WHERE ordernumber = 'P710605133840111' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352793'
                WHERE ordernumber = 'P200605134325230' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394329'
                WHERE ordernumber = 'P710605134341913' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352047'
                WHERE ordernumber = 'P180605134455909' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100514'
                WHERE ordernumber = 'P190605134554849' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394335'
                WHERE ordernumber = 'P420605134731543' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394336'
                WHERE ordernumber = 'P200605134838584' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394337'
                WHERE ordernumber = 'P180605134859153' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232624'
                WHERE ordernumber = 'P420605134957620' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394338'
                WHERE ordernumber = 'P200605135013977' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394340'
                WHERE ordernumber = 'P420605135057462' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393152'
                WHERE ordernumber = 'P190605135306314' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394339'
                WHERE ordernumber = 'P710605135354642' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394341'
                WHERE ordernumber = 'P180605135356341' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394343'
                WHERE ordernumber = 'P200605140140192' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '256845'
                WHERE ordernumber = 'P180605140550780' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349895'
                WHERE ordernumber = 'P200605140708384' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394345'
                WHERE ordernumber = 'P180605140929545' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345943'
                WHERE ordernumber = 'P420605141318702' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123884'
                WHERE ordernumber = 'P190605141403840' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123884'
                WHERE ordernumber = 'P190605141421805' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394344'
                WHERE ordernumber = 'P200605141545975' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394348'
                WHERE ordernumber = 'P420605141653440' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394349'
                WHERE ordernumber = 'P190605141826880' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365964'
                WHERE ordernumber = 'P200605141837871' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394350'
                WHERE ordernumber = 'P180605141948723' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235779'
                WHERE ordernumber = 'P200605142003267' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391741'
                WHERE ordernumber = 'P420605142106295' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219678'
                WHERE ordernumber = 'P200605142408816' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394351'
                WHERE ordernumber = 'P420605142521837' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180605142610804' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382635'
                WHERE ordernumber = 'P420605143416457' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394353'
                WHERE ordernumber = 'P200605143624483' 
            
2024-06-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394354'
                WHERE ordernumber = 'P180605143712989' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394354'
                WHERE ordernumber = 'P180605144034459' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288062'
                WHERE ordernumber = 'P420605144134957' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383620'
                WHERE ordernumber = 'P200605144148233' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394357'
                WHERE ordernumber = 'P710605144409438' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392137'
                WHERE ordernumber = 'P180605144615391' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369716'
                WHERE ordernumber = 'P420605145451773' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394359'
                WHERE ordernumber = 'P780605145750889' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394360'
                WHERE ordernumber = 'P190605145930213' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224832'
                WHERE ordernumber = 'P200605145943227' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394361'
                WHERE ordernumber = 'P180605150009325' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100154'
                WHERE ordernumber = 'P630605150109671' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393882'
                WHERE ordernumber = 'P200605150508299' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394363'
                WHERE ordernumber = 'P200605151051335' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294085'
                WHERE ordernumber = 'P200605151203477' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394364'
                WHERE ordernumber = 'P190605151432950' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339173'
                WHERE ordernumber = 'P180605151522870' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394365'
                WHERE ordernumber = 'P420605151627982' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394367'
                WHERE ordernumber = 'P200605151822161' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394167'
                WHERE ordernumber = 'P200605151852462' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394368'
                WHERE ordernumber = 'P180605151934834' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P190605152056713' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394369'
                WHERE ordernumber = 'P180605152153703' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94941'
                WHERE ordernumber = 'P200605152244711' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394370'
                WHERE ordernumber = 'P420605152245795' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89055'
                WHERE ordernumber = 'P200605152544828' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252820'
                WHERE ordernumber = 'P200605152722582' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387456'
                WHERE ordernumber = 'P710605153214190' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96621'
                WHERE ordernumber = 'P190605153217398' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394373'
                WHERE ordernumber = 'P180605153402514' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394374'
                WHERE ordernumber = 'P180605153828435' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293405'
                WHERE ordernumber = 'P190605154034908' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394376'
                WHERE ordernumber = 'P200605154224612' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277374'
                WHERE ordernumber = 'P190605154230803' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394377'
                WHERE ordernumber = 'P190605154633181' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384178'
                WHERE ordernumber = 'P180605155008458' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229958'
                WHERE ordernumber = 'P200605155136475' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394378'
                WHERE ordernumber = 'P180605155207954' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88988'
                WHERE ordernumber = 'P590605155222514' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394380'
                WHERE ordernumber = 'P200605155555263' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '199262'
                WHERE ordernumber = 'P200605155727948' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394381'
                WHERE ordernumber = 'P180605155839638' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253543'
                WHERE ordernumber = 'P180605160551286' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394385'
                WHERE ordernumber = 'P180605161021552' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344935'
                WHERE ordernumber = 'P200605161715673' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312397'
                WHERE ordernumber = 'P180605161753735' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391992'
                WHERE ordernumber = 'P190605162609256' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394386'
                WHERE ordernumber = 'P200605162610381' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394387'
                WHERE ordernumber = 'P200605162850474' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394388'
                WHERE ordernumber = 'P180605162946634' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353435'
                WHERE ordernumber = 'P420605163044127' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337679'
                WHERE ordernumber = 'P710605163721891' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393932'
                WHERE ordernumber = 'P420605163753340' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93772'
                WHERE ordernumber = 'P200605163928711' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P200605165057135' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382946'
                WHERE ordernumber = 'P420605165057611' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '22193'
                WHERE ordernumber = 'P200605165234547' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394391'
                WHERE ordernumber = 'P200605165440910' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365728'
                WHERE ordernumber = 'P180605165447916' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394393'
                WHERE ordernumber = 'P180605170307734' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394394'
                WHERE ordernumber = 'P190605170430189' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388967'
                WHERE ordernumber = 'P180605170634750' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388967'
                WHERE ordernumber = 'P180605170709272' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394395'
                WHERE ordernumber = 'P190605170754135' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354775'
                WHERE ordernumber = 'P200605170805636' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394396'
                WHERE ordernumber = 'P190605171258808' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394397'
                WHERE ordernumber = 'P200605171313997' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259254'
                WHERE ordernumber = 'P420605171420326' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394398'
                WHERE ordernumber = 'P180605171511686' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145770'
                WHERE ordernumber = 'P200605171748985' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394333'
                WHERE ordernumber = 'P180605171750420' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394399'
                WHERE ordernumber = 'P180605171926760' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282580'
                WHERE ordernumber = 'P200605172627389' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394400'
                WHERE ordernumber = 'P200605172752848' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394404'
                WHERE ordernumber = 'P780605173459893' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394406'
                WHERE ordernumber = 'P200605173840422' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394407'
                WHERE ordernumber = 'P180605173921372' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394408'
                WHERE ordernumber = 'P200605174024632' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394409'
                WHERE ordernumber = 'P200605174230527' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394410'
                WHERE ordernumber = 'P420605174648299' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237283'
                WHERE ordernumber = 'P180605174741252' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394411'
                WHERE ordernumber = 'P710605175302648' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96197'
                WHERE ordernumber = 'P200605175414362' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394413'
                WHERE ordernumber = 'P180605175803210' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317789'
                WHERE ordernumber = 'P180605175904395' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382699'
                WHERE ordernumber = 'P200605180132615' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394414'
                WHERE ordernumber = 'P200605180254337' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390490'
                WHERE ordernumber = 'P420605180652383' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394416'
                WHERE ordernumber = 'P200605181024436' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368042'
                WHERE ordernumber = 'P420605181652313' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394417'
                WHERE ordernumber = 'P180605181832196' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394418'
                WHERE ordernumber = 'P200605182102860' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317103'
                WHERE ordernumber = 'P180605182140533' 
            
2024-06-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394419'
                WHERE ordernumber = 'P420605182227683' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160932'
                WHERE ordernumber = 'P200605182332376' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394421'
                WHERE ordernumber = 'P420605182541374' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394422'
                WHERE ordernumber = 'P180605182642141' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394423'
                WHERE ordernumber = 'P200605182853649' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348265'
                WHERE ordernumber = 'P420605183709731' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299987'
                WHERE ordernumber = 'P200605183810133' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236739'
                WHERE ordernumber = 'P180605183904480' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277459'
                WHERE ordernumber = 'P200605184339767' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394425'
                WHERE ordernumber = 'P420605184854755' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394426'
                WHERE ordernumber = 'P190605184959699' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394427'
                WHERE ordernumber = 'P200605185108733' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339052'
                WHERE ordernumber = 'P190605185427504' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354977'
                WHERE ordernumber = 'P420605185441171' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294985'
                WHERE ordernumber = 'P190605185559636' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269948'
                WHERE ordernumber = 'P420605185604133' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390879'
                WHERE ordernumber = 'P200605190159827' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394429'
                WHERE ordernumber = 'P420605190311968' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394430'
                WHERE ordernumber = 'P200605190314520' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394431'
                WHERE ordernumber = 'P200605190414424' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '36056'
                WHERE ordernumber = 'P200605190444284' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388841'
                WHERE ordernumber = 'P190605190557555' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394432'
                WHERE ordernumber = 'P190605190703167' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393998'
                WHERE ordernumber = 'P200605191256426' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108067'
                WHERE ordernumber = 'P190605191349947' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394433'
                WHERE ordernumber = 'P710605191517185' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390854'
                WHERE ordernumber = 'P200605191549357' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221011'
                WHERE ordernumber = 'P200605191703152' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394435'
                WHERE ordernumber = 'P200605191921717' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394436'
                WHERE ordernumber = 'P190605192127782' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394437'
                WHERE ordernumber = 'P190605192245380' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394438'
                WHERE ordernumber = 'P200605192415614' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312880'
                WHERE ordernumber = 'P200605192800931' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312880'
                WHERE ordernumber = 'P200605193023264' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103028'
                WHERE ordernumber = 'P200605193549373' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394440'
                WHERE ordernumber = 'P710605194506813' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268980'
                WHERE ordernumber = 'P200605194515635' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385398'
                WHERE ordernumber = 'P200605194720990' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372068'
                WHERE ordernumber = 'P200605194854640' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393888'
                WHERE ordernumber = 'P780605195532505' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394451'
                WHERE ordernumber = 'P630605210915262' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394453'
                WHERE ordernumber = 'P710605212207551' 
            
2024-06-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66095'
                WHERE ordernumber = 'P710605212507156'