2024-06-10 01:00:02 -- 將會員ä¸å¿ƒid寫入data-lake 2024-06-10 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-09%'; 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '93632' WHERE ordernumber = 'P200609110148276' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '382724' WHERE ordernumber = 'P630609110210340' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395122' WHERE ordernumber = 'P180609110228263' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395123' WHERE ordernumber = 'P200609110303689' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '389920' WHERE ordernumber = 'P200609110354650' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '375514' WHERE ordernumber = 'P180609110415926' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '389920' WHERE ordernumber = 'P200609110451879' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395124' WHERE ordernumber = 'P420609110501481' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395121' WHERE ordernumber = 'P180609110514210' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395125' WHERE ordernumber = 'P420609110609178' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395126' WHERE ordernumber = 'P200609110644460' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '329666' WHERE ordernumber = 'P180609110703322' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395127' WHERE ordernumber = 'P200609110821779' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395130' WHERE ordernumber = 'P180609110840833' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395132' WHERE ordernumber = 'P200609110932396' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395128' WHERE ordernumber = 'P420609110955820' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '394271' WHERE ordernumber = 'P190609111120427' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '242282' WHERE ordernumber = 'P180609111136922' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '113474' WHERE ordernumber = 'P200609111200966' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395133' WHERE ordernumber = 'P180609111252703' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395131' WHERE ordernumber = 'P190609111315982' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '250596' WHERE ordernumber = 'P180609111342782' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '287627' WHERE ordernumber = 'P200609111515234' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '395135' WHERE ordernumber = 'P420609111851175' 2024-06-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '227579' WHERE ordernumber = 'P190609112155991' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '393465' WHERE ordernumber = 'P180609112252805' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395137' WHERE ordernumber = 'P180609112447566' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395138' WHERE ordernumber = 'P180609112847791' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395139' WHERE ordernumber = 'P180609113458857' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395140' WHERE ordernumber = 'P190609113508289' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '376293' WHERE ordernumber = 'P180609113539456' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395141' WHERE ordernumber = 'P180609113749508' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395142' WHERE ordernumber = 'P190609113803566' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '173536' WHERE ordernumber = 'P200609113804447' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395143' WHERE ordernumber = 'P190609113914391' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '386961' WHERE ordernumber = 'P200609114033912' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '392530' WHERE ordernumber = 'P180609114120561' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '128308' WHERE ordernumber = 'P200609115131490' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '393615' WHERE ordernumber = 'P200609115220763' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '381792' WHERE ordernumber = 'P200609115501655' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '296246' WHERE ordernumber = 'P180609115710637' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395145' WHERE ordernumber = 'P190609115738303' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '77711' WHERE ordernumber = 'P180609120032895' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395146' WHERE ordernumber = 'P200609120143360' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395147' WHERE ordernumber = 'P180609120232453' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395146' WHERE ordernumber = 'P200609120323777' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395148' WHERE ordernumber = 'P420609120352550' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '335815' WHERE ordernumber = 'P630609120846374' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395151' WHERE ordernumber = 'P420609120908509' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395150' WHERE ordernumber = 'P190609120919611' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '81850' WHERE ordernumber = 'P420609121120774' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395152' WHERE ordernumber = 'P190609121120857' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '247601' WHERE ordernumber = 'P190609121431235' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '317018' WHERE ordernumber = 'P420609121748930' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395153' WHERE ordernumber = 'P190609122202661' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395154' WHERE ordernumber = 'P190609122541218' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395156' WHERE ordernumber = 'P180609122728256' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '364642' WHERE ordernumber = 'P180609123437789' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '251059' WHERE ordernumber = 'P420609123625727' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395157' WHERE ordernumber = 'P200609124326602' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '57188' WHERE ordernumber = 'P180609124521189' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '160421' WHERE ordernumber = 'P180609124628394' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '119011' WHERE ordernumber = 'P180609124804333' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '211607' WHERE ordernumber = 'P190609124819228' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395159' WHERE ordernumber = 'P180609125551352' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395158' WHERE ordernumber = 'P420609125615798' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '96452' WHERE ordernumber = 'P180609125638200' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '376204' WHERE ordernumber = 'P180609125824845' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395160' WHERE ordernumber = 'P420609125903829' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '54377' WHERE ordernumber = 'P710609125929934' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395161' WHERE ordernumber = 'P420609130048677' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '291742' WHERE ordernumber = 'P200609130107735' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395162' WHERE ordernumber = 'P420609130212239' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395163' WHERE ordernumber = 'P200609130315719' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395164' WHERE ordernumber = 'P420609131014661' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '337926' WHERE ordernumber = 'P200609131221805' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395165' WHERE ordernumber = 'P200609131433337' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '392160' WHERE ordernumber = 'P180609131935157' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395166' WHERE ordernumber = 'P200609132219166' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395167' WHERE ordernumber = 'P180609132431927' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '345197' WHERE ordernumber = 'P180609132814334' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395168' WHERE ordernumber = 'P420609132938421' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '287978' WHERE ordernumber = 'P420609133024964' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '278520' WHERE ordernumber = 'P200609134454217' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '219333' WHERE ordernumber = 'P180609134548274' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '269173' WHERE ordernumber = 'P200609135306762' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '387244' WHERE ordernumber = 'P180609135626811' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '393984' WHERE ordernumber = 'P190609135857283' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395175' WHERE ordernumber = 'P420609135904268' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395176' WHERE ordernumber = 'P180609135922444' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '389962' WHERE ordernumber = 'P420609140002653' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395177' WHERE ordernumber = 'P180609140051904' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395175' WHERE ordernumber = 'P420609140151528' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '376567' WHERE ordernumber = 'P180609140231292' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395179' WHERE ordernumber = 'P420609140433726' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '49763' WHERE ordernumber = 'P180609140437905' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395177' WHERE ordernumber = 'P180609140615919' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395177' WHERE ordernumber = 'P180609140731769' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395181' WHERE ordernumber = 'P180609140909486' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '394434' WHERE ordernumber = 'P180609141025242' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395183' WHERE ordernumber = 'P180609141152782' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395182' WHERE ordernumber = 'P200609141307384' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395185' WHERE ordernumber = 'P180609141443307' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '313766' WHERE ordernumber = 'P180609141807529' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395187' WHERE ordernumber = 'P180609141927965' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395186' WHERE ordernumber = 'P420609141940968' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395188' WHERE ordernumber = 'P200609141943758' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395189' WHERE ordernumber = 'P180609142045641' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395190' WHERE ordernumber = 'P180609142157870' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '280058' WHERE ordernumber = 'P420609142201363' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395191' WHERE ordernumber = 'P180609142252921' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '273897' WHERE ordernumber = 'P200609142356355' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395192' WHERE ordernumber = 'P180609142717251' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '377637' WHERE ordernumber = 'P180609142841214' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395193' WHERE ordernumber = 'P200609142849525' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '309711' WHERE ordernumber = 'P200609142958618' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '177053' WHERE ordernumber = 'P420609143006980' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '173298' WHERE ordernumber = 'P710609143107324' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395194' WHERE ordernumber = 'P420609143121836' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395197' WHERE ordernumber = 'P180609143235922' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395195' WHERE ordernumber = 'P420609143238835' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '354420' WHERE ordernumber = 'P180609143428330' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '395198' WHERE ordernumber = 'P420609143459391' 2024-06-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '340280' WHERE ordernumber = 'P420609143536613' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395199' WHERE ordernumber = 'P420609143728559' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395170' WHERE ordernumber = 'P190609143940877' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395201' WHERE ordernumber = 'P180609144032699' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395170' WHERE ordernumber = 'P190609144046507' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395203' WHERE ordernumber = 'P180609144136578' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395202' WHERE ordernumber = 'P200609144148354' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '375511' WHERE ordernumber = 'P180609144404329' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395204' WHERE ordernumber = 'P190609144559423' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395205' WHERE ordernumber = 'P420609144834612' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395206' WHERE ordernumber = 'P180609144914402' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '299626' WHERE ordernumber = 'P200609145127639' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '56295' WHERE ordernumber = 'P180609145546417' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '310755' WHERE ordernumber = 'P180609145639429' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '272343' WHERE ordernumber = 'P630609145643445' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '394978' WHERE ordernumber = 'P180609145741443' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395209' WHERE ordernumber = 'P420609150046473' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395210' WHERE ordernumber = 'P180609150109715' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395211' WHERE ordernumber = 'P420609150254222' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '306065' WHERE ordernumber = 'P190609150326859' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395212' WHERE ordernumber = 'P420609150345186' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '341136' WHERE ordernumber = 'P180609150433816' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '229003' WHERE ordernumber = 'P200609150539124' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '390324' WHERE ordernumber = 'P180609150609351' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '385363' WHERE ordernumber = 'P420609150614962' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395192' WHERE ordernumber = 'P180609150721122' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395213' WHERE ordernumber = 'P420609150957236' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395214' WHERE ordernumber = 'P180609151354999' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '161053' WHERE ordernumber = 'P180609151456714' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395216' WHERE ordernumber = 'P180609151704235' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395217' WHERE ordernumber = 'P420609151824129' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395218' WHERE ordernumber = 'P190609151853935' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395220' WHERE ordernumber = 'P190609151947936' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395214' WHERE ordernumber = 'P180609152007513' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395219' WHERE ordernumber = 'P780609152122989' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395222' WHERE ordernumber = 'P420609152226945' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '325649' WHERE ordernumber = 'P180609152251384' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '297540' WHERE ordernumber = 'P420609152334184' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395223' WHERE ordernumber = 'P630609152931476' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '385355' WHERE ordernumber = 'P200609153002770' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395227' WHERE ordernumber = 'P420609153457764' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '350930' WHERE ordernumber = 'P200609153641190' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395228' WHERE ordernumber = 'P180609153643755' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395229' WHERE ordernumber = 'P420609153706722' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395230' WHERE ordernumber = 'P420609153842343' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '206407' WHERE ordernumber = 'P180609153926660' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395231' WHERE ordernumber = 'P180609154042689' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395232' WHERE ordernumber = 'P200609154255573' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395224' WHERE ordernumber = 'P200609154810950' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '391549' WHERE ordernumber = 'P180609154941322' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395233' WHERE ordernumber = 'P200609154954327' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395234' WHERE ordernumber = 'P200609155305822' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395235' WHERE ordernumber = 'P420609155348508' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '349788' WHERE ordernumber = 'P180609155412473' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '345093' WHERE ordernumber = 'P180609155833672' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395236' WHERE ordernumber = 'P780609155842276' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '81316' WHERE ordernumber = 'P180609155948344' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395237' WHERE ordernumber = 'P190609160042805' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '331410' WHERE ordernumber = 'P180609160120636' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '387696' WHERE ordernumber = 'P420609160217728' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395238' WHERE ordernumber = 'P630609160332166' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '393548' WHERE ordernumber = 'P180609160341523' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '271863' WHERE ordernumber = 'P420609160450352' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395239' WHERE ordernumber = 'P180609160501419' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '339940' WHERE ordernumber = 'P200609160542728' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395240' WHERE ordernumber = 'P190609160723165' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395241' WHERE ordernumber = 'P180609160751441' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395243' WHERE ordernumber = 'P200609161004419' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395244' WHERE ordernumber = 'P180609161119617' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395245' WHERE ordernumber = 'P190609161154136' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '378019' WHERE ordernumber = 'P420609161400751' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395246' WHERE ordernumber = 'P190609161402295' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395247' WHERE ordernumber = 'P200609161409939' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395248' WHERE ordernumber = 'P200609161514288' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '214488' WHERE ordernumber = 'P200609161541141' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395249' WHERE ordernumber = 'P180609161644370' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '251552' WHERE ordernumber = 'P190609161718179' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395250' WHERE ordernumber = 'P420609161749153' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395251' WHERE ordernumber = 'P180609162233159' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '366515' WHERE ordernumber = 'P190609162327402' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '237408' WHERE ordernumber = 'P200609162346363' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395252' WHERE ordernumber = 'P200609162436286' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '354489' WHERE ordernumber = 'P630609162541705' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '357984' WHERE ordernumber = 'P200609162645818' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395253' WHERE ordernumber = 'P180609162709658' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '113555' WHERE ordernumber = 'P180609162758820' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395254' WHERE ordernumber = 'P180609162919546' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395255' WHERE ordernumber = 'P180609163233129' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '307431' WHERE ordernumber = 'P190609163249673' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '106086' WHERE ordernumber = 'P180609163357202' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395257' WHERE ordernumber = 'P190609163456735' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '388518' WHERE ordernumber = 'P200609163659832' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '98315' WHERE ordernumber = 'P200609163818859' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395260' WHERE ordernumber = 'P200609163907392' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395259' WHERE ordernumber = 'P420609163914468' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395261' WHERE ordernumber = 'P190609164304674' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395262' WHERE ordernumber = 'P180609164338511' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '297310' WHERE ordernumber = 'P180609164552816' 2024-06-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395263' WHERE ordernumber = 'P180609164815298' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '4489' WHERE ordernumber = 'P200609164850504' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '259709' WHERE ordernumber = 'P200609164933301' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '258194' WHERE ordernumber = 'P200609165354328' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395264' WHERE ordernumber = 'P180609165411948' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '207236' WHERE ordernumber = 'P180609165630574' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395265' WHERE ordernumber = 'P180609165750592' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395266' WHERE ordernumber = 'P180609165933283' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395267' WHERE ordernumber = 'P180609170756370' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '385841' WHERE ordernumber = 'P200609171419136' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '298418' WHERE ordernumber = 'P420609171455780' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395268' WHERE ordernumber = 'P420609171656650' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '344253' WHERE ordernumber = 'P180609171701193' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395269' WHERE ordernumber = 'P180609171904439' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395270' WHERE ordernumber = 'P420609172051313' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395271' WHERE ordernumber = 'P420609172202288' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '348565' WHERE ordernumber = 'P200609172222981' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '368009' WHERE ordernumber = 'P200609172408899' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395272' WHERE ordernumber = 'P420609172412716' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395273' WHERE ordernumber = 'P200609172536827' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395274' WHERE ordernumber = 'P420609172631690' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395275' WHERE ordernumber = 'P180609172724345' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395276' WHERE ordernumber = 'P200609172758605' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '82093' WHERE ordernumber = 'P180609172909599' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395277' WHERE ordernumber = 'P180609172959917' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '387626' WHERE ordernumber = 'P200609173002586' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395278' WHERE ordernumber = 'P180609173148931' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395279' WHERE ordernumber = 'P180609173256202' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395277' WHERE ordernumber = 'P190609173314307' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '387866' WHERE ordernumber = 'P180609173405826' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '388112' WHERE ordernumber = 'P200609173702765' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395280' WHERE ordernumber = 'P180609173747478' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395281' WHERE ordernumber = 'P190609173837984' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395282' WHERE ordernumber = 'P420609174202113' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '311364' WHERE ordernumber = 'P630609174448479' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395283' WHERE ordernumber = 'P420609174512174' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395284' WHERE ordernumber = 'P180609174626390' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '91524' WHERE ordernumber = 'P420609175113514' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395122' WHERE ordernumber = 'P180609175303205' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '267800' WHERE ordernumber = 'P180609175624611' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395285' WHERE ordernumber = 'P180609180656313' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395286' WHERE ordernumber = 'P420609180810552' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395287' WHERE ordernumber = 'P180609180816199' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395288' WHERE ordernumber = 'P190609180843578' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395289' WHERE ordernumber = 'P180609180926904' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '102419' WHERE ordernumber = 'P200609181607421' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395290' WHERE ordernumber = 'P180609182020979' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395291' WHERE ordernumber = 'P420609182451927' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '315924' WHERE ordernumber = 'P180609182537812' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '366300' WHERE ordernumber = 'P420609183016517' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '310632' WHERE ordernumber = 'P190609183933349' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395293' WHERE ordernumber = 'P180609184057571' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '332571' WHERE ordernumber = 'P590609184324284' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395294' WHERE ordernumber = 'P180609184425806' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395295' WHERE ordernumber = 'P200609184451425' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '277329' WHERE ordernumber = 'P180609184602724' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395296' WHERE ordernumber = 'P190609185013481' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '161151' WHERE ordernumber = 'P190609185114533' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '207373' WHERE ordernumber = 'P200609185123731' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '394700' WHERE ordernumber = 'P190609185541773' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395297' WHERE ordernumber = 'P200609185815477' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395237' WHERE ordernumber = 'P190609185831134' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395298' WHERE ordernumber = 'P200609190154626' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395299' WHERE ordernumber = 'P190609190206730' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395301' WHERE ordernumber = 'P190609190535359' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395302' WHERE ordernumber = 'P190609190638203' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395300' WHERE ordernumber = 'P200609190701142' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395303' WHERE ordernumber = 'P190609190822298' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395305' WHERE ordernumber = 'P190609190947994' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395086' WHERE ordernumber = 'P200609191036426' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395306' WHERE ordernumber = 'P190609191245381' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395307' WHERE ordernumber = 'P200609191605672' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395308' WHERE ordernumber = 'P630609191627594' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395309' WHERE ordernumber = 'P200609191755668' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395310' WHERE ordernumber = 'P190609192430968' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395292' WHERE ordernumber = 'P190609192630324' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395292' WHERE ordernumber = 'P190609192721694' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395313' WHERE ordernumber = 'P190609192950197' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395312' WHERE ordernumber = 'P630609193018480' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395314' WHERE ordernumber = 'P190609193235499' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '111817' WHERE ordernumber = 'P190609193807489' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '289391' WHERE ordernumber = 'P190609193919574' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395316' WHERE ordernumber = 'P200609193935202' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395317' WHERE ordernumber = 'P200609194216938' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395318' WHERE ordernumber = 'P190609194429301' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395319' WHERE ordernumber = 'P190609195104756' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '276566' WHERE ordernumber = 'P190609195141882' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '217445' WHERE ordernumber = 'P190609195352639' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '217445' WHERE ordernumber = 'P190609195442662' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395320' WHERE ordernumber = 'P630609195834767' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '213727' WHERE ordernumber = 'P710609201030604' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395322' WHERE ordernumber = 'P780609203703830' 2024-06-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '395322' WHERE ordernumber = 'P780609204221594'