2024-07-21 01:00:03 -- 將會員ä¸å¿ƒid寫入data-lake 2024-07-21 01:00:03 -- SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at FROM `purchases` p LEFT JOIN user_relations ur on p.user_relation_id = ur.id LEFT JOIN users u on ur.user_id = u.id WHERE p.order_code LIKE 'P%' and p.created_at like '2024-07-20%'; 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '400030' WHERE ordernumber = 'P180720110224710' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '363165' WHERE ordernumber = 'P420720110233171' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '395164' WHERE ordernumber = 'P420720110359300' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '399279' WHERE ordernumber = 'P420720110602228' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '402156' WHERE ordernumber = 'P200720110630981' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '401060' WHERE ordernumber = 'P180720111059392' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '299936' WHERE ordernumber = 'P190720111147994' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '392331' WHERE ordernumber = 'P180720111215701' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '402159' WHERE ordernumber = 'P200720111621757' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '402161' WHERE ordernumber = 'P180720111947138' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '402162' WHERE ordernumber = 'P180720112137184' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '95016' WHERE ordernumber = 'P180720112353693' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '332133' WHERE ordernumber = 'P200720112409477' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '400089' WHERE ordernumber = 'P180720112538856' 2024-07-21 01:00:03 -- UPDATE `omo_order_list` SET userId = '275706' WHERE ordernumber = 'P180720112946501' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '348964' WHERE ordernumber = 'P180720113137254' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '380575' WHERE ordernumber = 'P200720113455786' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402165' WHERE ordernumber = 'P420720113533148' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '348261' WHERE ordernumber = 'P180720113533817' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402167' WHERE ordernumber = 'P180720114201443' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402166' WHERE ordernumber = 'P200720114410828' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402168' WHERE ordernumber = 'P180720114433121' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402169' WHERE ordernumber = 'P420720114521692' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402148' WHERE ordernumber = 'P200720114542830' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402148' WHERE ordernumber = 'P200720114616939' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402170' WHERE ordernumber = 'P420720114635851' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '348046' WHERE ordernumber = 'P180720114649664' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402171' WHERE ordernumber = 'P190720114739437' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '167240' WHERE ordernumber = 'P190720115313143' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '384721' WHERE ordernumber = 'P180720115450700' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402173' WHERE ordernumber = 'P200720115650855' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '220173' WHERE ordernumber = 'P190720115710566' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '393929' WHERE ordernumber = 'P200720121010396' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '384241' WHERE ordernumber = 'P180720121522834' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402176' WHERE ordernumber = 'P420720122133503' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '249896' WHERE ordernumber = 'P180720122433458' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '235053' WHERE ordernumber = 'P190720122501240' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '272136' WHERE ordernumber = 'P420720122510433' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '348677' WHERE ordernumber = 'P180720123510958' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402174' WHERE ordernumber = 'P180720123539379' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402174' WHERE ordernumber = 'P180720123622739' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '108125' WHERE ordernumber = 'P180720123741372' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402179' WHERE ordernumber = 'P200720124049908' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402180' WHERE ordernumber = 'P420720124241745' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '191090' WHERE ordernumber = 'P200720124333707' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402181' WHERE ordernumber = 'P190720124949558' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402183' WHERE ordernumber = 'P200720125040803' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402184' WHERE ordernumber = 'P200720125445505' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402185' WHERE ordernumber = 'P200720125550163' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '226754' WHERE ordernumber = 'P180720125756899' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '400656' WHERE ordernumber = 'P200720130055857' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402186' WHERE ordernumber = 'P180720130110395' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '395582' WHERE ordernumber = 'P420720130311566' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '389478' WHERE ordernumber = 'P200720130414960' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '375539' WHERE ordernumber = 'P420720130756922' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402188' WHERE ordernumber = 'P180720131219691' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402189' WHERE ordernumber = 'P180720131534432' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402190' WHERE ordernumber = 'P190720131750582' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '126351' WHERE ordernumber = 'P180720131751599' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402187' WHERE ordernumber = 'P180720131815703' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402191' WHERE ordernumber = 'P420720132101552' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '84253' WHERE ordernumber = 'P180720132101583' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '84253' WHERE ordernumber = 'P180720132611692' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '121744' WHERE ordernumber = 'P180720133149446' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '363317' WHERE ordernumber = 'P200720133406445' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '65865' WHERE ordernumber = 'P190720133525180' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402193' WHERE ordernumber = 'P180720133648165' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402194' WHERE ordernumber = 'P200720133658927' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '387819' WHERE ordernumber = 'P200720133748919' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402195' WHERE ordernumber = 'P180720133812927' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402196' WHERE ordernumber = 'P200720133943363' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402197' WHERE ordernumber = 'P190720134143135' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '397430' WHERE ordernumber = 'P420720134212688' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '401277' WHERE ordernumber = 'P180720134439982' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402198' WHERE ordernumber = 'P190720134835637' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402199' WHERE ordernumber = 'P180720135151254' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '401657' WHERE ordernumber = 'P190720135233375' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402200' WHERE ordernumber = 'P180720135702657' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '312525' WHERE ordernumber = 'P200720140136157' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '13235' WHERE ordernumber = 'P200720140240124' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402201' WHERE ordernumber = 'P420720140326500' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402202' WHERE ordernumber = 'P200720140401712' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402114' WHERE ordernumber = 'P200720140802496' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402202' WHERE ordernumber = 'P200720141024869' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402204' WHERE ordernumber = 'P180720141557382' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '120508' WHERE ordernumber = 'P200720141703623' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '384453' WHERE ordernumber = 'P180720141804787' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '310632' WHERE ordernumber = 'P180720141933604' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '359823' WHERE ordernumber = 'P200720141939474' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402205' WHERE ordernumber = 'P200720142317610' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402206' WHERE ordernumber = 'P420720142449409' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402207' WHERE ordernumber = 'P200720142537858' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402208' WHERE ordernumber = 'P420720143223979' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '364448' WHERE ordernumber = 'P420720143802262' 2024-07-21 01:00:04 -- UPDATE `omo_order_list` SET userId = '402210' WHERE ordernumber = 'P180720144000910' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '394713' WHERE ordernumber = 'P420720144434220' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '389490' WHERE ordernumber = 'P200720144642898' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '401958' WHERE ordernumber = 'P180720144935655' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402211' WHERE ordernumber = 'P180720144956647' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402215' WHERE ordernumber = 'P420720150239936' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402214' WHERE ordernumber = 'P180720150244832' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402213' WHERE ordernumber = 'P200720150256208' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402215' WHERE ordernumber = 'P420720150336281' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402217' WHERE ordernumber = 'P180720150430387' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402218' WHERE ordernumber = 'P180720150950145' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '324062' WHERE ordernumber = 'P190720151132599' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402220' WHERE ordernumber = 'P420720151254962' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402221' WHERE ordernumber = 'P180720151358295' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402222' WHERE ordernumber = 'P420720151536900' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '339950' WHERE ordernumber = 'P420720152142259' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '396134' WHERE ordernumber = 'P200720152513693' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '391904' WHERE ordernumber = 'P190720152634580' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402225' WHERE ordernumber = 'P420720152657555' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '151323' WHERE ordernumber = 'P180720152725656' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402225' WHERE ordernumber = 'P420720152735220' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '399498' WHERE ordernumber = 'P190720152803235' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '328917' WHERE ordernumber = 'P420720152902710' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '260310' WHERE ordernumber = 'P200720152917465' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402227' WHERE ordernumber = 'P190720153006409' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '401780' WHERE ordernumber = 'P200720153128754' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '102862' WHERE ordernumber = 'P180720153250256' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '392501' WHERE ordernumber = 'P200720153310942' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402228' WHERE ordernumber = 'P420720153621940' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '376353' WHERE ordernumber = 'P180720153802811' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402229' WHERE ordernumber = 'P190720153852954' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402230' WHERE ordernumber = 'P420720153945345' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402231' WHERE ordernumber = 'P420720154119888' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402232' WHERE ordernumber = 'P190720154601715' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '357689' WHERE ordernumber = 'P200720154723750' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '338504' WHERE ordernumber = 'P180720155242602' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '160711' WHERE ordernumber = 'P200720155352510' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '379326' WHERE ordernumber = 'P420720155429586' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402234' WHERE ordernumber = 'P180720155533575' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402235' WHERE ordernumber = 'P200720155617233' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402237' WHERE ordernumber = 'P180720160400238' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '287234' WHERE ordernumber = 'P200720160415206' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402238' WHERE ordernumber = 'P180720160516825' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402239' WHERE ordernumber = 'P180720160818796' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '326943' WHERE ordernumber = 'P180720161104165' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '254395' WHERE ordernumber = 'P190720161255371' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402243' WHERE ordernumber = 'P190720161447810' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '189763' WHERE ordernumber = 'P180720161610725' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402244' WHERE ordernumber = 'P420720161724115' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '394913' WHERE ordernumber = 'P200720161840740' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402246' WHERE ordernumber = 'P420720161928863' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '387945' WHERE ordernumber = 'P420720162019567' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402247' WHERE ordernumber = 'P200720162031639' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402248' WHERE ordernumber = 'P180720162610457' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '142727' WHERE ordernumber = 'P190720162633711' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '273977' WHERE ordernumber = 'P180720163138330' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '256489' WHERE ordernumber = 'P200720163159758' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402250' WHERE ordernumber = 'P420720163206794' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '398435' WHERE ordernumber = 'P200720163417644' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '136062' WHERE ordernumber = 'P190720163854633' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402253' WHERE ordernumber = 'P180720163904400' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '153282' WHERE ordernumber = 'P190720164049120' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402252' WHERE ordernumber = 'P180720164120558' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '400543' WHERE ordernumber = 'P190720164343319' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402254' WHERE ordernumber = 'P180720164718494' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '303945' WHERE ordernumber = 'P200720164757270' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402255' WHERE ordernumber = 'P180720164859880' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '397556' WHERE ordernumber = 'P190720164909136' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402254' WHERE ordernumber = 'P180720164953540' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402256' WHERE ordernumber = 'P180720165401796' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402258' WHERE ordernumber = 'P200720170127726' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '387045' WHERE ordernumber = 'P180720170226119' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402258' WHERE ordernumber = 'P200720170346753' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '402259' WHERE ordernumber = 'P180720170508704' 2024-07-21 01:00:05 -- UPDATE `omo_order_list` SET userId = '228511' WHERE ordernumber = 'P180720170823124' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402162' WHERE ordernumber = 'P190720170932216' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '303900' WHERE ordernumber = 'P180720170946435' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402261' WHERE ordernumber = 'P200720170954404' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402260' WHERE ordernumber = 'P190720171113388' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '380901' WHERE ordernumber = 'P420720171339213' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '374695' WHERE ordernumber = 'P190720171450915' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402263' WHERE ordernumber = 'P190720171644217' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402262' WHERE ordernumber = 'P180720171717838' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '231451' WHERE ordernumber = 'P180720171834618' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '359823' WHERE ordernumber = 'P200720172201399' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402265' WHERE ordernumber = 'P180720172307293' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402266' WHERE ordernumber = 'P180720172608472' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '111805' WHERE ordernumber = 'P190720172650854' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402267' WHERE ordernumber = 'P180720172819482' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '207207' WHERE ordernumber = 'P190720172945913' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '254476' WHERE ordernumber = 'P200720173015180' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '207207' WHERE ordernumber = 'P190720173217523' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '375751' WHERE ordernumber = 'P180720173305813' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402270' WHERE ordernumber = 'P200720173436724' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '220125' WHERE ordernumber = 'P180720173503930' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402269' WHERE ordernumber = 'P180720173555663' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '285282' WHERE ordernumber = 'P190720173815457' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402271' WHERE ordernumber = 'P180720174044337' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '214193' WHERE ordernumber = 'P180720174236844' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402272' WHERE ordernumber = 'P180720174454763' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402273' WHERE ordernumber = 'P420720174751691' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402274' WHERE ordernumber = 'P190720175132707' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '393892' WHERE ordernumber = 'P420720175313809' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '270378' WHERE ordernumber = 'P200720175331562' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402275' WHERE ordernumber = 'P180720175416236' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402276' WHERE ordernumber = 'P180720175602380' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '317784' WHERE ordernumber = 'P420720175602370' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402277' WHERE ordernumber = 'P420720175737135' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402278' WHERE ordernumber = 'P420720175833351' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402279' WHERE ordernumber = 'P420720180006928' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '126828' WHERE ordernumber = 'P180720180432358' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '362075' WHERE ordernumber = 'P420720180452665' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402280' WHERE ordernumber = 'P190720180538661' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '277987' WHERE ordernumber = 'P190720180655684' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402281' WHERE ordernumber = 'P180720180751604' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '261033' WHERE ordernumber = 'P200720180759484' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '364063' WHERE ordernumber = 'P200720181020733' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402282' WHERE ordernumber = 'P420720181045376' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '399775' WHERE ordernumber = 'P200720181621989' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402285' WHERE ordernumber = 'P420720182521146' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '358902' WHERE ordernumber = 'P630720183000853' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402287' WHERE ordernumber = 'P180720183021485' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '401888' WHERE ordernumber = 'P420720183212715' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '297030' WHERE ordernumber = 'P420720183419965' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '96007' WHERE ordernumber = 'P180720184123616' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '96007' WHERE ordernumber = 'P180720184158879' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402288' WHERE ordernumber = 'P200720184358559' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '388816' WHERE ordernumber = 'P420720184550943' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '94980' WHERE ordernumber = 'P190720184847498' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '311545' WHERE ordernumber = 'P190720185100296' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '133037' WHERE ordernumber = 'P200720185107340' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '399593' WHERE ordernumber = 'P200720185531997' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '367218' WHERE ordernumber = 'P190720190754730' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402293' WHERE ordernumber = 'P190720191313165' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402294' WHERE ordernumber = 'P190720191500847' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402295' WHERE ordernumber = 'P190720191551238' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402296' WHERE ordernumber = 'P190720191652561' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402298' WHERE ordernumber = 'P190720192242181' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '360338' WHERE ordernumber = 'P190720192450488' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402299' WHERE ordernumber = 'P190720192641650' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '302915' WHERE ordernumber = 'P190720192804293' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '99043' WHERE ordernumber = 'P190720193119580' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '27793' WHERE ordernumber = 'P190720193341858' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402301' WHERE ordernumber = 'P200720193449515' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402302' WHERE ordernumber = 'P200720193632538' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '395031' WHERE ordernumber = 'P190720193657499' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '402303' WHERE ordernumber = 'P190720193944861' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '212551' WHERE ordernumber = 'P190720194528170' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '321118' WHERE ordernumber = 'P190720194950210' 2024-07-21 01:00:06 -- UPDATE `omo_order_list` SET userId = '332698' WHERE ordernumber = 'P190720195437583' 2024-07-21 01:00:07 -- UPDATE `omo_order_list` SET userId = '350157' WHERE ordernumber = 'P190720195551952' 2024-07-21 01:00:07 -- UPDATE `omo_order_list` SET userId = '334136' WHERE ordernumber = 'P200720195733773'