2024-06-24 01:00:02 -- 將會員中心id寫入data-lake 2024-06-24 01:00:02 -- SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at FROM `purchases` p LEFT JOIN user_relations ur on p.user_relation_id = ur.id LEFT JOIN users u on ur.user_id = u.id WHERE p.order_code LIKE 'P%' and p.created_at like '2024-06-23%'; 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '384016' WHERE ordernumber = 'P630623100701121' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '192056' WHERE ordernumber = 'P630623101625237' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '304155' WHERE ordernumber = 'P630623104616568' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '395522' WHERE ordernumber = 'P200623110215288' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '395128' WHERE ordernumber = 'P420623110300704' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '272214' WHERE ordernumber = 'P180623110403813' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '296980' WHERE ordernumber = 'P420623110528645' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397514' WHERE ordernumber = 'P180623110555734' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397515' WHERE ordernumber = 'P190623110659473' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397516' WHERE ordernumber = 'P180623110721733' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '221941' WHERE ordernumber = 'P200623110846166' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397517' WHERE ordernumber = 'P190623110849140' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '137992' WHERE ordernumber = 'P200623111017854' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '247115' WHERE ordernumber = 'P180623111027608' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397518' WHERE ordernumber = 'P190623111053889' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '396249' WHERE ordernumber = 'P180623111437921' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '96561' WHERE ordernumber = 'P190623111511516' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397519' WHERE ordernumber = 'P590623111512232' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397518' WHERE ordernumber = 'P190623111619198' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397519' WHERE ordernumber = 'P590623111749275' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '309445' WHERE ordernumber = 'P180623111803321' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '287627' WHERE ordernumber = 'P200623111907559' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '396045' WHERE ordernumber = 'P200623112129856' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397521' WHERE ordernumber = 'P590623112411285' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '396983' WHERE ordernumber = 'P200623112536753' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397522' WHERE ordernumber = 'P200623112921186' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397523' WHERE ordernumber = 'P180623113036918' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '167650' WHERE ordernumber = 'P420623113106998' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397524' WHERE ordernumber = 'P180623113154355' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397525' WHERE ordernumber = 'P420623113510192' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '393664' WHERE ordernumber = 'P420623113713238' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397526' WHERE ordernumber = 'P630623113951698' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '285180' WHERE ordernumber = 'P590623114121636' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '316361' WHERE ordernumber = 'P180623114444623' 2024-06-24 01:00:02 -- UPDATE `omo_order_list` SET userId = '397527' WHERE ordernumber = 'P200623114550678' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '396360' WHERE ordernumber = 'P630623114607875' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '361358' WHERE ordernumber = 'P180623114952467' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '208484' WHERE ordernumber = 'P190623115254667' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '281716' WHERE ordernumber = 'P200623115421637' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '395583' WHERE ordernumber = 'P180623115557538' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '221802' WHERE ordernumber = 'P180623115820670' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397528' WHERE ordernumber = 'P180623120053330' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '110764' WHERE ordernumber = 'P190623120057676' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '317192' WHERE ordernumber = 'P180623120247229' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397530' WHERE ordernumber = 'P190623120348551' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '388323' WHERE ordernumber = 'P180623120407757' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '284194' WHERE ordernumber = 'P180623120513371' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '385853' WHERE ordernumber = 'P190623120838525' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397533' WHERE ordernumber = 'P420623120933168' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397531' WHERE ordernumber = 'P180623121031785' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '273273' WHERE ordernumber = 'P190623121058958' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397534' WHERE ordernumber = 'P590623121141125' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '379300' WHERE ordernumber = 'P420623121313291' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '332236' WHERE ordernumber = 'P200623121506924' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '117108' WHERE ordernumber = 'P190623121518540' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '356390' WHERE ordernumber = 'P190623121704576' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '304346' WHERE ordernumber = 'P780623121927779' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397535' WHERE ordernumber = 'P180623121940387' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '341526' WHERE ordernumber = 'P180623122114528' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '135049' WHERE ordernumber = 'P200623122744745' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '394836' WHERE ordernumber = 'P180623122849604' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '317689' WHERE ordernumber = 'P190623123010241' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '185948' WHERE ordernumber = 'P420623123115525' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '130531' WHERE ordernumber = 'P180623123129599' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '305943' WHERE ordernumber = 'P190623123225668' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397539' WHERE ordernumber = 'P420623123451792' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '99175' WHERE ordernumber = 'P590623123532811' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '289937' WHERE ordernumber = 'P180623123541686' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397540' WHERE ordernumber = 'P630623124220425' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '127145' WHERE ordernumber = 'P180623124328942' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397543' WHERE ordernumber = 'P190623124522203' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397541' WHERE ordernumber = 'P180623124625996' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397544' WHERE ordernumber = 'P590623124712151' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '379127' WHERE ordernumber = 'P420623124754491' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '244638' WHERE ordernumber = 'P180623124900879' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '286821' WHERE ordernumber = 'P180623124957746' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397545' WHERE ordernumber = 'P420623125208253' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397546' WHERE ordernumber = 'P180623125403154' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397547' WHERE ordernumber = 'P420623125416455' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397549' WHERE ordernumber = 'P180623125710604' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397552' WHERE ordernumber = 'P180623125824534' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397551' WHERE ordernumber = 'P200623125834245' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '382975' WHERE ordernumber = 'P190623125850294' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397548' WHERE ordernumber = 'P630623130322989' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397554' WHERE ordernumber = 'P780623130338619' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397555' WHERE ordernumber = 'P180623130357641' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397556' WHERE ordernumber = 'P180623130802170' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '395604' WHERE ordernumber = 'P180623131105275' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397557' WHERE ordernumber = 'P180623131232435' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397558' WHERE ordernumber = 'P180623131734805' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '220286' WHERE ordernumber = 'P180623131931132' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397488' WHERE ordernumber = 'P180623132040354' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397560' WHERE ordernumber = 'P420623132048713' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397559' WHERE ordernumber = 'P590623132057203' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '280164' WHERE ordernumber = 'P420623132227301' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '311903' WHERE ordernumber = 'P180623132650137' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397562' WHERE ordernumber = 'P200623132923538' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397563' WHERE ordernumber = 'P420623133054905' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397564' WHERE ordernumber = 'P180623133102457' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '169' WHERE ordernumber = 'P180623133302657' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397565' WHERE ordernumber = 'P630623133338602' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397566' WHERE ordernumber = 'P180623133412900' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397567' WHERE ordernumber = 'P630623133455349' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397568' WHERE ordernumber = 'P180623133625425' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '350507' WHERE ordernumber = 'P180623133708997' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '387741' WHERE ordernumber = 'P190623133757923' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397570' WHERE ordernumber = 'P420623134008208' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397571' WHERE ordernumber = 'P180623134119865' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '383239' WHERE ordernumber = 'P180623134936847' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397573' WHERE ordernumber = 'P420623134957113' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '142735' WHERE ordernumber = 'P420623135200802' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397574' WHERE ordernumber = 'P180623135455300' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397575' WHERE ordernumber = 'P630623135602449' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397576' WHERE ordernumber = 'P180623135856462' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '66860' WHERE ordernumber = 'P180623140333256' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397577' WHERE ordernumber = 'P200623140753380' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397578' WHERE ordernumber = 'P590623141027663' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397579' WHERE ordernumber = 'P200623141313372' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397580' WHERE ordernumber = 'P590623141333814' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397581' WHERE ordernumber = 'P590623141607457' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '309527' WHERE ordernumber = 'P200623141615872' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397582' WHERE ordernumber = 'P420623141853490' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '252246' WHERE ordernumber = 'P180623142248170' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '130649' WHERE ordernumber = 'P420623142252992' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397583' WHERE ordernumber = 'P180623142611426' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '212585' WHERE ordernumber = 'P180623143439119' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '96007' WHERE ordernumber = 'P180623143913625' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397584' WHERE ordernumber = 'P180623144110396' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397542' WHERE ordernumber = 'P780623144246950' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '309057' WHERE ordernumber = 'P180623144346518' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397585' WHERE ordernumber = 'P590623144420991' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397586' WHERE ordernumber = 'P780623144507735' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '240026' WHERE ordernumber = 'P630623144627380' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397589' WHERE ordernumber = 'P630623144732949' 2024-06-24 01:00:03 -- UPDATE `omo_order_list` SET userId = '397588' WHERE ordernumber = 'P180623144809599' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '373857' WHERE ordernumber = 'P420623144900151' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '126582' WHERE ordernumber = 'P180623145025608' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '388493' WHERE ordernumber = 'P420623145028522' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '189455' WHERE ordernumber = 'P420623145146646' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397591' WHERE ordernumber = 'P420623145241466' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397592' WHERE ordernumber = 'P180623145329806' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397590' WHERE ordernumber = 'P190623145428124' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397593' WHERE ordernumber = 'P420623145457967' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397594' WHERE ordernumber = 'P180623145615257' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397595' WHERE ordernumber = 'P190623145703958' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397596' WHERE ordernumber = 'P200623150159277' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397597' WHERE ordernumber = 'P780623150159268' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397598' WHERE ordernumber = 'P200623150434921' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '60519' WHERE ordernumber = 'P420623150530951' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397599' WHERE ordernumber = 'P420623150711693' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397600' WHERE ordernumber = 'P420623150834148' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397601' WHERE ordernumber = 'P200623151003347' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397597' WHERE ordernumber = 'P780623151143233' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397602' WHERE ordernumber = 'P420623151258864' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '342538' WHERE ordernumber = 'P420623151449796' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '100889' WHERE ordernumber = 'P180623151808848' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397604' WHERE ordernumber = 'P590623151819944' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '273696' WHERE ordernumber = 'P200623151832766' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397603' WHERE ordernumber = 'P420623151847658' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '273696' WHERE ordernumber = 'P200623151928862' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '124590' WHERE ordernumber = 'P180623152159926' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '358374' WHERE ordernumber = 'P420623152216198' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397606' WHERE ordernumber = 'P420623152438735' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397607' WHERE ordernumber = 'P420623152622764' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397608' WHERE ordernumber = 'P180623152631437' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397609' WHERE ordernumber = 'P190623152633814' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397610' WHERE ordernumber = 'P200623152718828' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397609' WHERE ordernumber = 'P190623152725691' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397611' WHERE ordernumber = 'P190623152826721' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '140799' WHERE ordernumber = 'P200623152827345' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397605' WHERE ordernumber = 'P590623153227929' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397609' WHERE ordernumber = 'P180623153234637' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '227698' WHERE ordernumber = 'P180623153509558' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397612' WHERE ordernumber = 'P180623153632518' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397613' WHERE ordernumber = 'P190623153655136' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397614' WHERE ordernumber = 'P180623153809201' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397615' WHERE ordernumber = 'P180623153947702' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397616' WHERE ordernumber = 'P180623154309313' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '266022' WHERE ordernumber = 'P200623154436434' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397617' WHERE ordernumber = 'P180623154506453' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397618' WHERE ordernumber = 'P180623154708209' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397619' WHERE ordernumber = 'P420623155004352' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397620' WHERE ordernumber = 'P630623155456246' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397622' WHERE ordernumber = 'P180623160257473' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397622' WHERE ordernumber = 'P180623160427804' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397624' WHERE ordernumber = 'P630623160621488' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397623' WHERE ordernumber = 'P420623160634137' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397625' WHERE ordernumber = 'P780623160844477' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397628' WHERE ordernumber = 'P180623161255609' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397626' WHERE ordernumber = 'P420623161337759' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '116203' WHERE ordernumber = 'P190623161355386' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397629' WHERE ordernumber = 'P180623161419582' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397630' WHERE ordernumber = 'P630623161525388' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '296397' WHERE ordernumber = 'P200623161654726' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397631' WHERE ordernumber = 'P420623161659874' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397632' WHERE ordernumber = 'P180623161725450' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '347603' WHERE ordernumber = 'P200623161900434' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397634' WHERE ordernumber = 'P630623161917771' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397633' WHERE ordernumber = 'P190623161940390' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397635' WHERE ordernumber = 'P630623162116248' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '394775' WHERE ordernumber = 'P180623162431153' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397636' WHERE ordernumber = 'P630623162435929' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '394775' WHERE ordernumber = 'P180623162628393' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '323657' WHERE ordernumber = 'P180623162726194' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397639' WHERE ordernumber = 'P420623163356688' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397643' WHERE ordernumber = 'P200623163456723' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397645' WHERE ordernumber = 'P780623163529266' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397646' WHERE ordernumber = 'P420623163602760' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397640' WHERE ordernumber = 'P180623163605727' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397647' WHERE ordernumber = 'P190623163746851' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397648' WHERE ordernumber = 'P180623164256511' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '29930' WHERE ordernumber = 'P200623164343764' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '283108' WHERE ordernumber = 'P180623164349994' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397649' WHERE ordernumber = 'P420623164529996' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397650' WHERE ordernumber = 'P630623164552746' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '394393' WHERE ordernumber = 'P180623164615450' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '115609' WHERE ordernumber = 'P780623164728811' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397651' WHERE ordernumber = 'P780623164937872' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397654' WHERE ordernumber = 'P200623165358422' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397655' WHERE ordernumber = 'P780623165447506' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397656' WHERE ordernumber = 'P180623165448160' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '387976' WHERE ordernumber = 'P190623165547947' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397657' WHERE ordernumber = 'P180623165730434' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '298591' WHERE ordernumber = 'P180623165919218' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '113566' WHERE ordernumber = 'P200623165930543' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397658' WHERE ordernumber = 'P200623170156764' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397659' WHERE ordernumber = 'P180623170532130' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397662' WHERE ordernumber = 'P630623171456649' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397660' WHERE ordernumber = 'P630623171459248' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397661' WHERE ordernumber = 'P590623171514631' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397663' WHERE ordernumber = 'P630623171721462' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397665' WHERE ordernumber = 'P420623171838809' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '389490' WHERE ordernumber = 'P200623171947281' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397668' WHERE ordernumber = 'P190623172133441' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397669' WHERE ordernumber = 'P180623172627560' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397670' WHERE ordernumber = 'P420623172634177' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397671' WHERE ordernumber = 'P780623172733527' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397672' WHERE ordernumber = 'P630623172845231' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '252533' WHERE ordernumber = 'P180623172908985' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397673' WHERE ordernumber = 'P630623173038814' 2024-06-24 01:00:04 -- UPDATE `omo_order_list` SET userId = '397674' WHERE ordernumber = 'P630623173206435' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '195649' WHERE ordernumber = 'P180623173246654' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397676' WHERE ordernumber = 'P200623173458475' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397677' WHERE ordernumber = 'P190623173508219' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397678' WHERE ordernumber = 'P630623173529483' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '98426' WHERE ordernumber = 'P200623173648741' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '98426' WHERE ordernumber = 'P200623173805808' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397529' WHERE ordernumber = 'P190623173812518' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397679' WHERE ordernumber = 'P420623173813488' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397680' WHERE ordernumber = 'P180623173856483' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397681' WHERE ordernumber = 'P630623174036929' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397682' WHERE ordernumber = 'P200623174135920' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397683' WHERE ordernumber = 'P630623174229261' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397684' WHERE ordernumber = 'P420623174456147' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '396657' WHERE ordernumber = 'P200623175114263' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397686' WHERE ordernumber = 'P780623175607975' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397685' WHERE ordernumber = 'P200623175623399' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397653' WHERE ordernumber = 'P200623175918984' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397688' WHERE ordernumber = 'P420623180308734' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397690' WHERE ordernumber = 'P180623180655691' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397689' WHERE ordernumber = 'P200623180659198' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '273696' WHERE ordernumber = 'P200623180925723' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '256865' WHERE ordernumber = 'P420623181057799' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397691' WHERE ordernumber = 'P180623181528526' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '301771' WHERE ordernumber = 'P190623181724438' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397692' WHERE ordernumber = 'P200623181848136' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397695' WHERE ordernumber = 'P180623182023875' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '159051' WHERE ordernumber = 'P200623182043326' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397696' WHERE ordernumber = 'P590623182049826' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '121961' WHERE ordernumber = 'P590623182151275' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397694' WHERE ordernumber = 'P590623182218840' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '356802' WHERE ordernumber = 'P200623182339537' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '301850' WHERE ordernumber = 'P420623182401633' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '390908' WHERE ordernumber = 'P420623182640209' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397698' WHERE ordernumber = 'P630623182759296' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397699' WHERE ordernumber = 'P420623182814925' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397700' WHERE ordernumber = 'P200623182956963' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397701' WHERE ordernumber = 'P180623183015162' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397702' WHERE ordernumber = 'P200623183143553' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397703' WHERE ordernumber = 'P780623183446857' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '161128' WHERE ordernumber = 'P590623183457711' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397705' WHERE ordernumber = 'P420623183734727' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397704' WHERE ordernumber = 'P200623183746267' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '250255' WHERE ordernumber = 'P190623183846832' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '385800' WHERE ordernumber = 'P200623183935522' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '392009' WHERE ordernumber = 'P190623184143226' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397707' WHERE ordernumber = 'P200623184156840' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '114409' WHERE ordernumber = 'P190623185009650' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '94496' WHERE ordernumber = 'P190623185300767' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397708' WHERE ordernumber = 'P190623185703788' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '214444' WHERE ordernumber = 'P190623185828868' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '380174' WHERE ordernumber = 'P590623190157679' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P190623190443220' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397710' WHERE ordernumber = 'P200623190528937' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397712' WHERE ordernumber = 'P190623190830271' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397713' WHERE ordernumber = 'P200623191537336' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397714' WHERE ordernumber = 'P190623191633649' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397709' WHERE ordernumber = 'P780623192016182' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '351819' WHERE ordernumber = 'P200623192256302' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '343490' WHERE ordernumber = 'P780623193121185' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397716' WHERE ordernumber = 'P630623193129373' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '374526' WHERE ordernumber = 'P630623193208885' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397717' WHERE ordernumber = 'P190623193257746' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '99802' WHERE ordernumber = 'P190623193637952' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397718' WHERE ordernumber = 'P780623193901727' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397719' WHERE ordernumber = 'P190623194000468' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397721' WHERE ordernumber = 'P630623194144938' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397720' WHERE ordernumber = 'P190623194150315' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397722' WHERE ordernumber = 'P780623194228311' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397723' WHERE ordernumber = 'P190623194332940' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '388525' WHERE ordernumber = 'P200623194514725' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397724' WHERE ordernumber = 'P200623195049234' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397727' WHERE ordernumber = 'P630623200521897' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397728' WHERE ordernumber = 'P630623201413699' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397733' WHERE ordernumber = 'P780623202159128' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397731' WHERE ordernumber = 'P780623202353701' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397735' WHERE ordernumber = 'P630623204213911' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397742' WHERE ordernumber = 'P780623212943769' 2024-06-24 01:00:05 -- UPDATE `omo_order_list` SET userId = '397743' WHERE ordernumber = 'P780623213806595'