2024-06-11 01:00:03 -- 將會員中心id寫入data-lake
2024-06-11 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-06-10%';
        
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395349'
                WHERE ordernumber = 'P710610104313797' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130397'
                WHERE ordernumber = 'P710610105546331' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395350'
                WHERE ordernumber = 'P180610110202864' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384434'
                WHERE ordernumber = 'P190610110251340' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395351'
                WHERE ordernumber = 'P200610110347406' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395352'
                WHERE ordernumber = 'P180610110514778' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301428'
                WHERE ordernumber = 'P190610110640885' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395353'
                WHERE ordernumber = 'P180610110654717' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395354'
                WHERE ordernumber = 'P200610110851447' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395355'
                WHERE ordernumber = 'P200610111227254' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395356'
                WHERE ordernumber = 'P180610111424559' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384578'
                WHERE ordernumber = 'P190610111630534' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231789'
                WHERE ordernumber = 'P180610111715625' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231789'
                WHERE ordernumber = 'P180610111828453' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395358'
                WHERE ordernumber = 'P190610112104998' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82007'
                WHERE ordernumber = 'P190610112208228' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348002'
                WHERE ordernumber = 'P420610112346319' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350557'
                WHERE ordernumber = 'P180610112425797' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96171'
                WHERE ordernumber = 'P420610112450238' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395360'
                WHERE ordernumber = 'P190610112605287' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395361'
                WHERE ordernumber = 'P420610112607899' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270142'
                WHERE ordernumber = 'P180610113204248' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127611'
                WHERE ordernumber = 'P180610113531612' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395363'
                WHERE ordernumber = 'P180610113944758' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395364'
                WHERE ordernumber = 'P180610114116953' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395365'
                WHERE ordernumber = 'P180610114351691' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380829'
                WHERE ordernumber = 'P200610115130769' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386242'
                WHERE ordernumber = 'P180610120152453' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395369'
                WHERE ordernumber = 'P190610120243953' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395371'
                WHERE ordernumber = 'P420610120832858' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299746'
                WHERE ordernumber = 'P180610120943184' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395372'
                WHERE ordernumber = 'P420610121226477' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383515'
                WHERE ordernumber = 'P200610121255413' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140870'
                WHERE ordernumber = 'P200610121425906' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136257'
                WHERE ordernumber = 'P200610121505858' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383515'
                WHERE ordernumber = 'P200610122058633' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395374'
                WHERE ordernumber = 'P180610123024176' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139732'
                WHERE ordernumber = 'P630610123313870' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353910'
                WHERE ordernumber = 'P200610123531828' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394246'
                WHERE ordernumber = 'P200610123835409' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395376'
                WHERE ordernumber = 'P180610124914708' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263628'
                WHERE ordernumber = 'P420610125021254' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395377'
                WHERE ordernumber = 'P200610125419520' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395378'
                WHERE ordernumber = 'P780610125813615' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395380'
                WHERE ordernumber = 'P420610125932338' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395381'
                WHERE ordernumber = 'P180610130125933' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395382'
                WHERE ordernumber = 'P200610130330264' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158677'
                WHERE ordernumber = 'P200610130432723' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124377'
                WHERE ordernumber = 'P180610130516385' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395383'
                WHERE ordernumber = 'P420610130530528' 
            
2024-06-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395323'
                WHERE ordernumber = 'P200610130625460' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395384'
                WHERE ordernumber = 'P190610130656548' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395385'
                WHERE ordernumber = 'P420610131518243' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392155'
                WHERE ordernumber = 'P420610131700716' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312299'
                WHERE ordernumber = 'P630610132819828' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395387'
                WHERE ordernumber = 'P420610132958552' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395388'
                WHERE ordernumber = 'P420610133454217' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379221'
                WHERE ordernumber = 'P200610133613393' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281382'
                WHERE ordernumber = 'P180610133750931' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395390'
                WHERE ordernumber = 'P420610134425262' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395391'
                WHERE ordernumber = 'P200610134717196' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395392'
                WHERE ordernumber = 'P180610134951259' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395394'
                WHERE ordernumber = 'P630610135808949' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395395'
                WHERE ordernumber = 'P420610140041199' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365498'
                WHERE ordernumber = 'P180610140212675' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301501'
                WHERE ordernumber = 'P200610140629633' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395397'
                WHERE ordernumber = 'P420610141109373' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255951'
                WHERE ordernumber = 'P200610141328950' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380452'
                WHERE ordernumber = 'P180610141958293' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313832'
                WHERE ordernumber = 'P200610142115767' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313833'
                WHERE ordernumber = 'P200610142159348' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387202'
                WHERE ordernumber = 'P630610142713177' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395367'
                WHERE ordernumber = 'P180610143821506' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94626'
                WHERE ordernumber = 'P200610143845946' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395398'
                WHERE ordernumber = 'P200610144017779' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395270'
                WHERE ordernumber = 'P630610144653602' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395399'
                WHERE ordernumber = 'P180610144734550' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353546'
                WHERE ordernumber = 'P180610144854543' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291133'
                WHERE ordernumber = 'P420610144909828' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252512'
                WHERE ordernumber = 'P180610145921732' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327262'
                WHERE ordernumber = 'P200610150331382' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P200610150454525' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228218'
                WHERE ordernumber = 'P180610150621286' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395401'
                WHERE ordernumber = 'P420610151051377' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395402'
                WHERE ordernumber = 'P190610151246738' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381508'
                WHERE ordernumber = 'P180610151252256' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338908'
                WHERE ordernumber = 'P180610151510630' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395403'
                WHERE ordernumber = 'P420610151514882' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395404'
                WHERE ordernumber = 'P200610151535378' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395405'
                WHERE ordernumber = 'P420610151627904' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326370'
                WHERE ordernumber = 'P200610151717810' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380055'
                WHERE ordernumber = 'P180610151836141' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395406'
                WHERE ordernumber = 'P200610151852914' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116981'
                WHERE ordernumber = 'P180610152041900' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395407'
                WHERE ordernumber = 'P420610152105621' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291133'
                WHERE ordernumber = 'P420610152304581' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319567'
                WHERE ordernumber = 'P200610152345903' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395408'
                WHERE ordernumber = 'P180610152509966' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271548'
                WHERE ordernumber = 'P200610152519685' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141414'
                WHERE ordernumber = 'P190610152546311' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395409'
                WHERE ordernumber = 'P200610152841910' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395410'
                WHERE ordernumber = 'P420610152957414' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395411'
                WHERE ordernumber = 'P180610153032159' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395412'
                WHERE ordernumber = 'P420610153146350' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347676'
                WHERE ordernumber = 'P180610153316169' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395413'
                WHERE ordernumber = 'P780610153443707' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122240'
                WHERE ordernumber = 'P710610153506604' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395414'
                WHERE ordernumber = 'P420610153607592' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290405'
                WHERE ordernumber = 'P180610154256803' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394481'
                WHERE ordernumber = 'P200610154517463' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180610154734901' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395416'
                WHERE ordernumber = 'P200610154936512' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395418'
                WHERE ordernumber = 'P420610155226152' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395415'
                WHERE ordernumber = 'P180610155338208' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180610155705566' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386706'
                WHERE ordernumber = 'P200610160122811' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395419'
                WHERE ordernumber = 'P630610160336404' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395420'
                WHERE ordernumber = 'P190610160537999' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395421'
                WHERE ordernumber = 'P420610160646185' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395422'
                WHERE ordernumber = 'P180610160708276' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395421'
                WHERE ordernumber = 'P420610160729570' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328972'
                WHERE ordernumber = 'P420610160810995' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395423'
                WHERE ordernumber = 'P420610161114810' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395424'
                WHERE ordernumber = 'P180610161158328' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395425'
                WHERE ordernumber = 'P420610161206287' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395426'
                WHERE ordernumber = 'P180610161323463' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314289'
                WHERE ordernumber = 'P180610161515663' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395427'
                WHERE ordernumber = 'P420610161639907' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395428'
                WHERE ordernumber = 'P710610161820830' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365131'
                WHERE ordernumber = 'P420610162027736' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395430'
                WHERE ordernumber = 'P180610162059581' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '152750'
                WHERE ordernumber = 'P200610162156488' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395432'
                WHERE ordernumber = 'P420610162848439' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132756'
                WHERE ordernumber = 'P630610163057709' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392913'
                WHERE ordernumber = 'P200610163202695' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224896'
                WHERE ordernumber = 'P200610163300425' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '361654'
                WHERE ordernumber = 'P200610163623330' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343807'
                WHERE ordernumber = 'P180610164006225' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340830'
                WHERE ordernumber = 'P180610164143620' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317029'
                WHERE ordernumber = 'P180610164309525' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391928'
                WHERE ordernumber = 'P180610164400413' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238685'
                WHERE ordernumber = 'P200610164633303' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394527'
                WHERE ordernumber = 'P420610164705975' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395434'
                WHERE ordernumber = 'P180610164754760' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88175'
                WHERE ordernumber = 'P190610164803634' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395435'
                WHERE ordernumber = 'P420610164850868' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364915'
                WHERE ordernumber = 'P180610164858848' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159220'
                WHERE ordernumber = 'P200610164938452' 
            
2024-06-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395436'
                WHERE ordernumber = 'P200610165517767' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '206586'
                WHERE ordernumber = 'P180610165807650' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395437'
                WHERE ordernumber = 'P200610165843492' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '230248'
                WHERE ordernumber = 'P200610170441798' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395438'
                WHERE ordernumber = 'P780610170446434' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395439'
                WHERE ordernumber = 'P200610170621433' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395440'
                WHERE ordernumber = 'P420610170659494' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395441'
                WHERE ordernumber = 'P200610171222821' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395443'
                WHERE ordernumber = 'P420610171627708' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303682'
                WHERE ordernumber = 'P420610172601746' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395444'
                WHERE ordernumber = 'P190610172657363' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340711'
                WHERE ordernumber = 'P420610173257354' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395445'
                WHERE ordernumber = 'P420610173610755' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395447'
                WHERE ordernumber = 'P420610173728509' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395448'
                WHERE ordernumber = 'P200610174019971' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385036'
                WHERE ordernumber = 'P200610174159398' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395449'
                WHERE ordernumber = 'P180610174445996' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276524'
                WHERE ordernumber = 'P180610175246224' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395452'
                WHERE ordernumber = 'P180610175739587' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275367'
                WHERE ordernumber = 'P420610175901222' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395453'
                WHERE ordernumber = 'P420610180349484' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389729'
                WHERE ordernumber = 'P180610180351130' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380174'
                WHERE ordernumber = 'P200610180425590' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395454'
                WHERE ordernumber = 'P420610180637935' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395455'
                WHERE ordernumber = 'P420610181037692' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395456'
                WHERE ordernumber = 'P180610181508485' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378069'
                WHERE ordernumber = 'P180610181703511' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395417'
                WHERE ordernumber = 'P190610181706121' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395457'
                WHERE ordernumber = 'P200610181809470' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395458'
                WHERE ordernumber = 'P420610181825274' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395457'
                WHERE ordernumber = 'P200610182106530' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '173346'
                WHERE ordernumber = 'P710610182326185' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395459'
                WHERE ordernumber = 'P200610182920455' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395460'
                WHERE ordernumber = 'P420610183109609' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395461'
                WHERE ordernumber = 'P780610183633250' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317859'
                WHERE ordernumber = 'P200610184122186' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395462'
                WHERE ordernumber = 'P780610184132676' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287879'
                WHERE ordernumber = 'P190610184702750' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395463'
                WHERE ordernumber = 'P200610185037693' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305740'
                WHERE ordernumber = 'P200610185159747' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377290'
                WHERE ordernumber = 'P590610185423386' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234101'
                WHERE ordernumber = 'P200610185624729' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P420610185659849' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248675'
                WHERE ordernumber = 'P780610190519724' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395464'
                WHERE ordernumber = 'P200610190544407' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395464'
                WHERE ordernumber = 'P200610190637781' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395465'
                WHERE ordernumber = 'P200610190719863' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395467'
                WHERE ordernumber = 'P190610190757475' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160203'
                WHERE ordernumber = 'P190610191435225' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384983'
                WHERE ordernumber = 'P200610191550836' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395469'
                WHERE ordernumber = 'P190610192057818' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343257'
                WHERE ordernumber = 'P190610192216883' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303072'
                WHERE ordernumber = 'P190610192835829' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395473'
                WHERE ordernumber = 'P200610193726745' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395474'
                WHERE ordernumber = 'P630610194259142' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '363658'
                WHERE ordernumber = 'P190610194604219' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395476'
                WHERE ordernumber = 'P190610195312392' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395477'
                WHERE ordernumber = 'P780610195730985' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393621'
                WHERE ordernumber = 'P710610201054510' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395479'
                WHERE ordernumber = 'P710610201824716' 
            
2024-06-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '213389'
                WHERE ordernumber = 'P710610204754991'