2024-03-17 01:00:02 -- 將會員ä¸å¿ƒid寫入data-lake 2024-03-17 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-03-16%'; 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '298137' WHERE ordernumber = 'P420316105515782' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P180316110125130' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '81933' WHERE ordernumber = 'P200316110316934' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '160744' WHERE ordernumber = 'P200316110403411' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '77642' WHERE ordernumber = 'P180316110628582' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '314818' WHERE ordernumber = 'P180316110713288' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '339387' WHERE ordernumber = 'P200316110752583' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '218734' WHERE ordernumber = 'P200316110911713' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381725' WHERE ordernumber = 'P200316111123365' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '349826' WHERE ordernumber = 'P180316111142729' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381726' WHERE ordernumber = 'P180316111326665' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381727' WHERE ordernumber = 'P180316111427344' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381728' WHERE ordernumber = 'P180316111625163' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '317568' WHERE ordernumber = 'P180316111719356' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381730' WHERE ordernumber = 'P200316112209609' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381731' WHERE ordernumber = 'P420316112342796' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381732' WHERE ordernumber = 'P180316112515391' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381733' WHERE ordernumber = 'P180316112617636' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381734' WHERE ordernumber = 'P200316112749884' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '213044' WHERE ordernumber = 'P180316112847644' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '129092' WHERE ordernumber = 'P190316113225150' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381735' WHERE ordernumber = 'P180316113333623' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381737' WHERE ordernumber = 'P180316113534675' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381739' WHERE ordernumber = 'P180316113706176' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381738' WHERE ordernumber = 'P590316113716636' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '126295' WHERE ordernumber = 'P180316113917489' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '303554' WHERE ordernumber = 'P180316113938762' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381740' WHERE ordernumber = 'P420316114031185' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '357654' WHERE ordernumber = 'P200316114110281' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '96645' WHERE ordernumber = 'P200316114229176' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381741' WHERE ordernumber = 'P200316114846579' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '346546' WHERE ordernumber = 'P200316115155533' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381742' WHERE ordernumber = 'P180316115526830' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '245513' WHERE ordernumber = 'P180316120315415' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381745' WHERE ordernumber = 'P420316120343441' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381747' WHERE ordernumber = 'P180316120505415' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381672' WHERE ordernumber = 'P180316120617284' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381748' WHERE ordernumber = 'P180316121001117' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381749' WHERE ordernumber = 'P180316121154884' 2024-03-17 01:00:02 -- UPDATE `omo_order_list` SET userId = '381750' WHERE ordernumber = 'P420316121201209' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381751' WHERE ordernumber = 'P420316121352614' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '287818' WHERE ordernumber = 'P180316121402849' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '229236' WHERE ordernumber = 'P180316121626240' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '348554' WHERE ordernumber = 'P420316121637204' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '365583' WHERE ordernumber = 'P180316121731379' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '365583' WHERE ordernumber = 'P180316121813922' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381752' WHERE ordernumber = 'P200316122005113' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381753' WHERE ordernumber = 'P180316122118209' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '275486' WHERE ordernumber = 'P200316122327524' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381755' WHERE ordernumber = 'P180316122524602' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381756' WHERE ordernumber = 'P420316122559991' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '378763' WHERE ordernumber = 'P200316122637834' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '222852' WHERE ordernumber = 'P200316122756119' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381757' WHERE ordernumber = 'P180316123008913' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '142285' WHERE ordernumber = 'P420316123423509' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '346752' WHERE ordernumber = 'P590316124002133' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '209646' WHERE ordernumber = 'P180316124004158' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381759' WHERE ordernumber = 'P180316124159587' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '340476' WHERE ordernumber = 'P180316124240733' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '220080' WHERE ordernumber = 'P180316124413938' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381760' WHERE ordernumber = 'P180316124530566' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '350514' WHERE ordernumber = 'P420316124612988' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '118273' WHERE ordernumber = 'P180316125149570' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '96007' WHERE ordernumber = 'P190316125228311' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381761' WHERE ordernumber = 'P180316130101863' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '96074' WHERE ordernumber = 'P180316130406271' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '380804' WHERE ordernumber = 'P180316130528166' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381763' WHERE ordernumber = 'P180316130723588' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381765' WHERE ordernumber = 'P180316131326157' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381766' WHERE ordernumber = 'P420316131658246' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '341235' WHERE ordernumber = 'P420316131800506' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381767' WHERE ordernumber = 'P180316131857304' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '359853' WHERE ordernumber = 'P180316132106491' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381769' WHERE ordernumber = 'P180316132416515' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '245292' WHERE ordernumber = 'P200316132512579' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '163743' WHERE ordernumber = 'P200316132730471' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '224834' WHERE ordernumber = 'P420316132733703' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381770' WHERE ordernumber = 'P180316133355348' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '379826' WHERE ordernumber = 'P420316133407258' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '379826' WHERE ordernumber = 'P420316133524207' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381771' WHERE ordernumber = 'P180316133800511' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '102564' WHERE ordernumber = 'P180316134034410' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '248077' WHERE ordernumber = 'P190316134204348' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381772' WHERE ordernumber = 'P180316134433226' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '379469' WHERE ordernumber = 'P200316134555352' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381446' WHERE ordernumber = 'P180316134622476' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381773' WHERE ordernumber = 'P180316134907938' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '243519' WHERE ordernumber = 'P180316135527675' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381648' WHERE ordernumber = 'P190316135529639' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '380317' WHERE ordernumber = 'P420316135614837' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '348809' WHERE ordernumber = 'P180316135931301' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381775' WHERE ordernumber = 'P200316140227448' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381776' WHERE ordernumber = 'P420316140242865' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381777' WHERE ordernumber = 'P180316140406281' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381774' WHERE ordernumber = 'P590316140654408' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381778' WHERE ordernumber = 'P420316140854948' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '88957' WHERE ordernumber = 'P200316141159292' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381780' WHERE ordernumber = 'P180316141216189' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381780' WHERE ordernumber = 'P180316141307927' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381781' WHERE ordernumber = 'P420316141308280' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '342538' WHERE ordernumber = 'P420316141358421' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '379914' WHERE ordernumber = 'P200316141559991' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '377207' WHERE ordernumber = 'P420316141618139' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '275261' WHERE ordernumber = 'P180316141817261' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381782' WHERE ordernumber = 'P200316141937570' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381783' WHERE ordernumber = 'P180316142128348' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '380647' WHERE ordernumber = 'P200316142322188' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '77445' WHERE ordernumber = 'P200316142535824' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381786' WHERE ordernumber = 'P200316142738295' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '220427' WHERE ordernumber = 'P200316142811818' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381787' WHERE ordernumber = 'P180316142924216' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381788' WHERE ordernumber = 'P420316143007177' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '288248' WHERE ordernumber = 'P180316143313356' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381789' WHERE ordernumber = 'P420316143632517' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381790' WHERE ordernumber = 'P180316143941157' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381791' WHERE ordernumber = 'P420316144210448' 2024-03-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '381792' WHERE ordernumber = 'P200316144731679' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381793' WHERE ordernumber = 'P200316145134870' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381794' WHERE ordernumber = 'P180316145215755' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '275526' WHERE ordernumber = 'P420316145337165' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381795' WHERE ordernumber = 'P200316145438179' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '351519' WHERE ordernumber = 'P200316145601872' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381796' WHERE ordernumber = 'P180316145739876' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '284509' WHERE ordernumber = 'P180316145947172' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381797' WHERE ordernumber = 'P180316150344452' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381797' WHERE ordernumber = 'P180316150441538' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '282143' WHERE ordernumber = 'P200316150453116' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '149668' WHERE ordernumber = 'P200316150745180' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '369810' WHERE ordernumber = 'P200316151017239' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '237738' WHERE ordernumber = 'P590316151245806' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '248929' WHERE ordernumber = 'P420316151327967' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '302597' WHERE ordernumber = 'P180316151333329' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381714' WHERE ordernumber = 'P180316151506820' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381714' WHERE ordernumber = 'P180316151644557' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '355398' WHERE ordernumber = 'P200316151648713' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381779' WHERE ordernumber = 'P180316151922572' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190316152013696' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381798' WHERE ordernumber = 'P190316152056669' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190316152337563' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381799' WHERE ordernumber = 'P420316152405922' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381799' WHERE ordernumber = 'P420316152547125' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190316152605648' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '375834' WHERE ordernumber = 'P180316152623498' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190316152809533' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190316152950332' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381802' WHERE ordernumber = 'P420316153444805' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381754' WHERE ordernumber = 'P180316153647118' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381801' WHERE ordernumber = 'P590316153749839' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381803' WHERE ordernumber = 'P420316153837660' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381804' WHERE ordernumber = 'P200316153838370' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381805' WHERE ordernumber = 'P200316154341440' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '102149' WHERE ordernumber = 'P200316154709858' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190316154848708' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190316155014886' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381806' WHERE ordernumber = 'P420316155024967' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190316155245541' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381807' WHERE ordernumber = 'P420316155321759' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381809' WHERE ordernumber = 'P420316155457553' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190316155603704' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '126064' WHERE ordernumber = 'P180316155704851' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381810' WHERE ordernumber = 'P420316155747382' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '136223' WHERE ordernumber = 'P200316155844266' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '95352' WHERE ordernumber = 'P180316160055193' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '272196' WHERE ordernumber = 'P420316160158190' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381812' WHERE ordernumber = 'P420316160524715' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381813' WHERE ordernumber = 'P420316160633348' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '248085' WHERE ordernumber = 'P180316160702208' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381811' WHERE ordernumber = 'P420316160808139' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '366147' WHERE ordernumber = 'P180316160845476' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381815' WHERE ordernumber = 'P420316161114598' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381814' WHERE ordernumber = 'P180316161135650' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381816' WHERE ordernumber = 'P420316161200888' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381817' WHERE ordernumber = 'P180316161324168' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381817' WHERE ordernumber = 'P180316161432517' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381818' WHERE ordernumber = 'P420316161509248' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381819' WHERE ordernumber = 'P180316161555728' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '153148' WHERE ordernumber = 'P180316161718243' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '310473' WHERE ordernumber = 'P180316161804704' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381820' WHERE ordernumber = 'P180316161857224' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381122' WHERE ordernumber = 'P180316161925795' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381821' WHERE ordernumber = 'P180316162120534' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381823' WHERE ordernumber = 'P420316162605979' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '245477' WHERE ordernumber = 'P180316162914960' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381824' WHERE ordernumber = 'P190316162951769' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '316470' WHERE ordernumber = 'P180316163421637' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381827' WHERE ordernumber = 'P180316163547152' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381828' WHERE ordernumber = 'P420316163756578' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '114381' WHERE ordernumber = 'P180316163916684' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '312643' WHERE ordernumber = 'P420316163943785' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381830' WHERE ordernumber = 'P180316164338467' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '298283' WHERE ordernumber = 'P420316164340743' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '341685' WHERE ordernumber = 'P180316164536266' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '321402' WHERE ordernumber = 'P420316164538557' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381832' WHERE ordernumber = 'P420316164630820' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '261736' WHERE ordernumber = 'P180316164706907' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381834' WHERE ordernumber = 'P180316164934130' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381835' WHERE ordernumber = 'P180316165225141' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381836' WHERE ordernumber = 'P190316165312147' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381833' WHERE ordernumber = 'P200316165419379' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381837' WHERE ordernumber = 'P190316165509359' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '297054' WHERE ordernumber = 'P180316165752968' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '354426' WHERE ordernumber = 'P180316170206314' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381840' WHERE ordernumber = 'P420316170402258' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381841' WHERE ordernumber = 'P420316170509888' 2024-03-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '381842' WHERE ordernumber = 'P420316170813311' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '304095' WHERE ordernumber = 'P180316171220396' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381844' WHERE ordernumber = 'P180316171426749' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '365741' WHERE ordernumber = 'P420316171453670' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381845' WHERE ordernumber = 'P180316171602156' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381631' WHERE ordernumber = 'P180316171810729' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381846' WHERE ordernumber = 'P180316171910805' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '256085' WHERE ordernumber = 'P180316172007906' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '288433' WHERE ordernumber = 'P200316172140499' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381849' WHERE ordernumber = 'P180316172622296' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '171626' WHERE ordernumber = 'P180316173143116' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '343629' WHERE ordernumber = 'P200316173353122' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '297637' WHERE ordernumber = 'P200316173659863' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '235981' WHERE ordernumber = 'P420316173810566' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '239187' WHERE ordernumber = 'P180316173836975' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381854' WHERE ordernumber = 'P200316174551271' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381855' WHERE ordernumber = 'P180316175312270' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '309225' WHERE ordernumber = 'P200316175346724' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '340830' WHERE ordernumber = 'P190316175705371' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381856' WHERE ordernumber = 'P420316175716828' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381857' WHERE ordernumber = 'P180316180039556' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '343732' WHERE ordernumber = 'P180316180217404' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '340830' WHERE ordernumber = 'P190316180320991' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '247504' WHERE ordernumber = 'P180316180346273' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '244361' WHERE ordernumber = 'P180316180457618' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '163308' WHERE ordernumber = 'P180316180808558' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381858' WHERE ordernumber = 'P420316180852374' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381860' WHERE ordernumber = 'P420316181948923' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381861' WHERE ordernumber = 'P180316182317541' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381862' WHERE ordernumber = 'P420316182403889' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '121141' WHERE ordernumber = 'P200316183052740' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381863' WHERE ordernumber = 'P180316183452847' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '134872' WHERE ordernumber = 'P200316184251433' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381864' WHERE ordernumber = 'P180316184304371' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '237010' WHERE ordernumber = 'P200316184504391' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381865' WHERE ordernumber = 'P200316184812605' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381866' WHERE ordernumber = 'P180316185001190' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381865' WHERE ordernumber = 'P200316185147254' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381867' WHERE ordernumber = 'P180316185307468' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '274943' WHERE ordernumber = 'P190316185312912' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381868' WHERE ordernumber = 'P420316185535300' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381869' WHERE ordernumber = 'P180316185809166' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381870' WHERE ordernumber = 'P190316185917805' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '227972' WHERE ordernumber = 'P200316190343910' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '380525' WHERE ordernumber = 'P190316190504336' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381872' WHERE ordernumber = 'P420316190923297' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381873' WHERE ordernumber = 'P190316191238418' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '216155' WHERE ordernumber = 'P420316191258873' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '257894' WHERE ordernumber = 'P190316191345433' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '96911' WHERE ordernumber = 'P190316192041683' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381874' WHERE ordernumber = 'P420316192126174' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '286200' WHERE ordernumber = 'P190316194520245' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381876' WHERE ordernumber = 'P200316194916692' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '360735' WHERE ordernumber = 'P190316195426934' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '307698' WHERE ordernumber = 'P190316195541821' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381877' WHERE ordernumber = 'P190316195803833' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '275063' WHERE ordernumber = 'P420316195938708' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '263796' WHERE ordernumber = 'P590316211906763' 2024-03-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '381883' WHERE ordernumber = 'P590316212001811'