2024-10-11 01:00:02 -- 將會員中心id寫入data-lake 2024-10-11 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-10-10%'; 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '423133' WHERE ordernumber = 'P711010104508198' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '423159' WHERE ordernumber = 'P711010104855861' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '425022' WHERE ordernumber = 'P711010105130228' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P181010110124884' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '416708' WHERE ordernumber = 'P181010110238856' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '425024' WHERE ordernumber = 'P711010110409574' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '127878' WHERE ordernumber = 'P201010110545351' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '425023' WHERE ordernumber = 'P421010110646815' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '295422' WHERE ordernumber = 'P201010110653613' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '250336' WHERE ordernumber = 'P711010110704439' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '425025' WHERE ordernumber = 'P421010110741481' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '243856' WHERE ordernumber = 'P201010110801948' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '425026' WHERE ordernumber = 'P421010111015289' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '109737' WHERE ordernumber = 'P191010111129569' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '419803' WHERE ordernumber = 'P421010111515893' 2024-10-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '216506' WHERE ordernumber = 'P201010111623647' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425027' WHERE ordernumber = 'P421010111814932' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '147379' WHERE ordernumber = 'P201010111954546' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425031' WHERE ordernumber = 'P711010112024624' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425028' WHERE ordernumber = 'P421010112033872' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '251678' WHERE ordernumber = 'P731010112205673' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425032' WHERE ordernumber = 'P421010112206402' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425029' WHERE ordernumber = 'P421010112303172' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425033' WHERE ordernumber = 'P191010112339396' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '423449' WHERE ordernumber = 'P181010112413619' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425035' WHERE ordernumber = 'P201010112714364' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425034' WHERE ordernumber = 'P181010112742862' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '424902' WHERE ordernumber = 'P181010113521452' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425037' WHERE ordernumber = 'P711010113655654' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425036' WHERE ordernumber = 'P181010113837597' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '118183' WHERE ordernumber = 'P181010114059157' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425041' WHERE ordernumber = 'P201010114159254' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425040' WHERE ordernumber = 'P191010114456929' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425038' WHERE ordernumber = 'P711010115236319' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425043' WHERE ordernumber = 'P201010115250149' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '283039' WHERE ordernumber = 'P181010115336934' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425046' WHERE ordernumber = 'P201010115539807' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425038' WHERE ordernumber = 'P711010115550519' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425042' WHERE ordernumber = 'P191010115633699' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425045' WHERE ordernumber = 'P421010115633829' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425038' WHERE ordernumber = 'P711010115702391' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425044' WHERE ordernumber = 'P711010115858273' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '208671' WHERE ordernumber = 'P181010115904913' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '105283' WHERE ordernumber = 'P711010120115997' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425048' WHERE ordernumber = 'P711010120549974' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425049' WHERE ordernumber = 'P421010120928403' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425050' WHERE ordernumber = 'P711010121141574' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '307610' WHERE ordernumber = 'P181010121209602' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425047' WHERE ordernumber = 'P191010121258648' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '341314' WHERE ordernumber = 'P181010121530940' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '379963' WHERE ordernumber = 'P181010122237135' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '86113' WHERE ordernumber = 'P181010122318762' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '285866' WHERE ordernumber = 'P191010122451572' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '281084' WHERE ordernumber = 'P201010122544186' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425053' WHERE ordernumber = 'P711010122611661' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425055' WHERE ordernumber = 'P421010122721466' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '424944' WHERE ordernumber = 'P181010122944775' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425056' WHERE ordernumber = 'P421010122946812' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425059' WHERE ordernumber = 'P711010122955754' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '285866' WHERE ordernumber = 'P191010123036749' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425058' WHERE ordernumber = 'P421010123038673' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425057' WHERE ordernumber = 'P421010123116526' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '352022' WHERE ordernumber = 'P201010123343467' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425060' WHERE ordernumber = 'P181010123658904' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425061' WHERE ordernumber = 'P731010124404751' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425062' WHERE ordernumber = 'P421010124618448' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425065' WHERE ordernumber = 'P201010124708141' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425063' WHERE ordernumber = 'P181010124827502' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425066' WHERE ordernumber = 'P201010124937825' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425064' WHERE ordernumber = 'P181010125024972' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425067' WHERE ordernumber = 'P421010125201599' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '423714' WHERE ordernumber = 'P421010125747292' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425068' WHERE ordernumber = 'P711010125933969' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425069' WHERE ordernumber = 'P421010130312772' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425070' WHERE ordernumber = 'P711010130737553' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '105075' WHERE ordernumber = 'P201010130906435' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425072' WHERE ordernumber = 'P421010130941984' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425071' WHERE ordernumber = 'P181010130942507' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425073' WHERE ordernumber = 'P711010131117724' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '423287' WHERE ordernumber = 'P201010131141380' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '149907' WHERE ordernumber = 'P181010131508220' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425075' WHERE ordernumber = 'P711010131631715' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425074' WHERE ordernumber = 'P181010131641705' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '106382' WHERE ordernumber = 'P181010132536254' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425077' WHERE ordernumber = 'P421010132604134' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425079' WHERE ordernumber = 'P711010132805839' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425078' WHERE ordernumber = 'P181010132927988' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '346957' WHERE ordernumber = 'P181010133427587' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '273181' WHERE ordernumber = 'P191010133754789' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '273181' WHERE ordernumber = 'P191010134032923' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425080' WHERE ordernumber = 'P711010134820324' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '312248' WHERE ordernumber = 'P191010134848322' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425082' WHERE ordernumber = 'P201010134936653' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425081' WHERE ordernumber = 'P201010134939148' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '157720' WHERE ordernumber = 'P711010135010953' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425084' WHERE ordernumber = 'P711010135326317' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425083' WHERE ordernumber = 'P731010135556138' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '302037' WHERE ordernumber = 'P201010135623365' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '294055' WHERE ordernumber = 'P421010135710257' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '100760' WHERE ordernumber = 'P191010135743397' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '425088' WHERE ordernumber = 'P201010135931933' 2024-10-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '319590' WHERE ordernumber = 'P421010140103769' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425089' WHERE ordernumber = 'P421010140309116' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425090' WHERE ordernumber = 'P191010140454798' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425092' WHERE ordernumber = 'P421010140859652' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425094' WHERE ordernumber = 'P711010141127130' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '359064' WHERE ordernumber = 'P201010141249775' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425091' WHERE ordernumber = 'P191010141319573' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425093' WHERE ordernumber = 'P201010141321431' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425099' WHERE ordernumber = 'P201010141618834' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425096' WHERE ordernumber = 'P711010141639294' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425095' WHERE ordernumber = 'P191010141718137' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425100' WHERE ordernumber = 'P201010141729430' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '163179' WHERE ordernumber = 'P201010142034133' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '163179' WHERE ordernumber = 'P201010142231526' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425098' WHERE ordernumber = 'P181010142254465' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '424997' WHERE ordernumber = 'P731010142426959' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425097' WHERE ordernumber = 'P181010142516706' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425102' WHERE ordernumber = 'P711010142707284' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425101' WHERE ordernumber = 'P191010142852960' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '341808' WHERE ordernumber = 'P711010143104877' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425105' WHERE ordernumber = 'P731010143542747' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425104' WHERE ordernumber = 'P421010143603562' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425103' WHERE ordernumber = 'P181010143608943' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425106' WHERE ordernumber = 'P201010143613408' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '303332' WHERE ordernumber = 'P181010143751530' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425107' WHERE ordernumber = 'P421010143815422' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425108' WHERE ordernumber = 'P201010143858644' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425109' WHERE ordernumber = 'P731010143926853' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425108' WHERE ordernumber = 'P201010143957917' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '362228' WHERE ordernumber = 'P181010144044518' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425110' WHERE ordernumber = 'P421010144215238' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425111' WHERE ordernumber = 'P421010144359811' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425114' WHERE ordernumber = 'P421010144507898' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425116' WHERE ordernumber = 'P731010144633279' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425117' WHERE ordernumber = 'P421010144905192' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425118' WHERE ordernumber = 'P731010144928616' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425115' WHERE ordernumber = 'P181010144957976' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425113' WHERE ordernumber = 'P181010145315734' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '293249' WHERE ordernumber = 'P181010145452307' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '280100' WHERE ordernumber = 'P181010145554756' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425121' WHERE ordernumber = 'P711010145649388' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '249752' WHERE ordernumber = 'P181010145657871' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '293405' WHERE ordernumber = 'P181010145806942' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '414563' WHERE ordernumber = 'P421010145856616' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '414563' WHERE ordernumber = 'P421010150314633' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425122' WHERE ordernumber = 'P181010150326303' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '102493' WHERE ordernumber = 'P421010150430502' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425123' WHERE ordernumber = 'P711010150455636' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425026' WHERE ordernumber = 'P421010150553146' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425124' WHERE ordernumber = 'P421010150813180' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425125' WHERE ordernumber = 'P731010150900429' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425126' WHERE ordernumber = 'P421010151140954' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '301971' WHERE ordernumber = 'P421010151213200' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425128' WHERE ordernumber = 'P201010151351377' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425127' WHERE ordernumber = 'P711010151403172' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '314688' WHERE ordernumber = 'P181010151549346' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '310632' WHERE ordernumber = 'P181010151701132' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425129' WHERE ordernumber = 'P711010151706171' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '210683' WHERE ordernumber = 'P181010152214410' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425134' WHERE ordernumber = 'P421010152547983' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425132' WHERE ordernumber = 'P181010152718666' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '219036' WHERE ordernumber = 'P191010153103750' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425131' WHERE ordernumber = 'P181010153311502' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425135' WHERE ordernumber = 'P181010153414411' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '319175' WHERE ordernumber = 'P711010153445826' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425140' WHERE ordernumber = 'P421010153702698' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425138' WHERE ordernumber = 'P191010153712464' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425144' WHERE ordernumber = 'P711010153819766' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425139' WHERE ordernumber = 'P191010153937938' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425146' WHERE ordernumber = 'P421010154137597' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425142' WHERE ordernumber = 'P181010154147597' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425151' WHERE ordernumber = 'P421010154321442' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425143' WHERE ordernumber = 'P181010154328529' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425136' WHERE ordernumber = 'P181010154506557' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425137' WHERE ordernumber = 'P181010154528881' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425147' WHERE ordernumber = 'P181010154547420' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425150' WHERE ordernumber = 'P191010154653992' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '220126' WHERE ordernumber = 'P191010155146276' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425145' WHERE ordernumber = 'P181010155235525' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425152' WHERE ordernumber = 'P181010155251869' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425155' WHERE ordernumber = 'P711010155300280' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425154' WHERE ordernumber = 'P421010155336721' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425153' WHERE ordernumber = 'P181010155501584' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425157' WHERE ordernumber = 'P711010155511914' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '381815' WHERE ordernumber = 'P421010155643314' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '365200' WHERE ordernumber = 'P421010155842992' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425158' WHERE ordernumber = 'P421010155949635' 2024-10-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425160' WHERE ordernumber = 'P421010160112428' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425159' WHERE ordernumber = 'P181010160359319' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425161' WHERE ordernumber = 'P421010160540892' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '279939' WHERE ordernumber = 'P191010160606504' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425166' WHERE ordernumber = 'P201010160649294' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425162' WHERE ordernumber = 'P181010160711477' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425164' WHERE ordernumber = 'P191010160756156' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425166' WHERE ordernumber = 'P201010160809632' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425167' WHERE ordernumber = 'P421010160916131' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425168' WHERE ordernumber = 'P711010160942361' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '304229' WHERE ordernumber = 'P631010161209165' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425163' WHERE ordernumber = 'P181010161256132' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425171' WHERE ordernumber = 'P201010161419181' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364608' WHERE ordernumber = 'P711010161536780' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425174' WHERE ordernumber = 'P181010161649279' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425170' WHERE ordernumber = 'P711010161851244' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '219234' WHERE ordernumber = 'P181010161852646' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425177' WHERE ordernumber = 'P201010162029719' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425176' WHERE ordernumber = 'P421010162036916' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '119949' WHERE ordernumber = 'P191010162040812' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425173' WHERE ordernumber = 'P181010162342484' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425169' WHERE ordernumber = 'P191010162520909' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425179' WHERE ordernumber = 'P421010162534800' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425182' WHERE ordernumber = 'P421010162823228' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425178' WHERE ordernumber = 'P181010162826529' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425181' WHERE ordernumber = 'P631010162850945' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425183' WHERE ordernumber = 'P191010163117595' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425185' WHERE ordernumber = 'P421010163140837' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '377356' WHERE ordernumber = 'P191010163257242' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '351147' WHERE ordernumber = 'P201010163407248' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '424559' WHERE ordernumber = 'P421010163530183' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425186' WHERE ordernumber = 'P711010163546342' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '351147' WHERE ordernumber = 'P201010163641286' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '398038' WHERE ordernumber = 'P631010163645481' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425188' WHERE ordernumber = 'P421010163956863' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '375802' WHERE ordernumber = 'P191010164106714' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425187' WHERE ordernumber = 'P181010164312536' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425189' WHERE ordernumber = 'P191010164545806' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '259579' WHERE ordernumber = 'P181010164735123' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425193' WHERE ordernumber = 'P181010164924795' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425195' WHERE ordernumber = 'P421010165009373' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '64791' WHERE ordernumber = 'P421010165105966' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425190' WHERE ordernumber = 'P191010165126234' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425192' WHERE ordernumber = 'P181010165144401' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425196' WHERE ordernumber = 'P711010165250373' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425194' WHERE ordernumber = 'P191010165255687' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '225393' WHERE ordernumber = 'P631010165506905' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '353680' WHERE ordernumber = 'P181010165523332' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425197' WHERE ordernumber = 'P421010165630747' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '394036' WHERE ordernumber = 'P201010165650598' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '283600' WHERE ordernumber = 'P181010165919709' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425190' WHERE ordernumber = 'P191010165950277' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425028' WHERE ordernumber = 'P421010170023899' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425198' WHERE ordernumber = 'P711010170049201' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '228348' WHERE ordernumber = 'P181010170148794' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425199' WHERE ordernumber = 'P421010170222774' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425203' WHERE ordernumber = 'P201010170526210' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '373360' WHERE ordernumber = 'P421010170604700' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425200' WHERE ordernumber = 'P181010170712906' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425201' WHERE ordernumber = 'P191010170853856' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '374458' WHERE ordernumber = 'P201010170912492' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425202' WHERE ordernumber = 'P191010171050471' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425205' WHERE ordernumber = 'P201010171249846' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '310460' WHERE ordernumber = 'P181010171327181' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '380016' WHERE ordernumber = 'P201010171433951' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425206' WHERE ordernumber = 'P421010171618778' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425207' WHERE ordernumber = 'P421010171658719' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '318455' WHERE ordernumber = 'P181010171806375' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '118258' WHERE ordernumber = 'P181010171951605' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425208' WHERE ordernumber = 'P711010172012684' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '356625' WHERE ordernumber = 'P421010172015903' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425207' WHERE ordernumber = 'P421010172136566' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425209' WHERE ordernumber = 'P711010172205836' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425211' WHERE ordernumber = 'P421010172409878' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425210' WHERE ordernumber = 'P421010172608843' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425215' WHERE ordernumber = 'P421010172937259' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425213' WHERE ordernumber = 'P711010173016960' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '381774' WHERE ordernumber = 'P421010173520363' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425216' WHERE ordernumber = 'P711010173613993' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425217' WHERE ordernumber = 'P421010173933798' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425214' WHERE ordernumber = 'P181010173945832' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425219' WHERE ordernumber = 'P201010174136572' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425218' WHERE ordernumber = 'P711010174205762' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '136134' WHERE ordernumber = 'P201010174508851' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '424849' WHERE ordernumber = 'P181010174709784' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '287713' WHERE ordernumber = 'P201010174751892' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '93319' WHERE ordernumber = 'P711010175450466' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '280830' WHERE ordernumber = 'P181010175525640' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '413656' WHERE ordernumber = 'P421010180035565' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425222' WHERE ordernumber = 'P201010180055170' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '102664' WHERE ordernumber = 'P181010180639292' 2024-10-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '425223' WHERE ordernumber = 'P201010181323233' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '376131' WHERE ordernumber = 'P181010181335290' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '287776' WHERE ordernumber = 'P191010181515172' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '319079' WHERE ordernumber = 'P181010181845500' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425224' WHERE ordernumber = 'P731010182134446' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '179236' WHERE ordernumber = 'P711010182526294' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '424681' WHERE ordernumber = 'P181010182750722' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '267401' WHERE ordernumber = 'P201010182929372' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '244056' WHERE ordernumber = 'P191010183315770' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425225' WHERE ordernumber = 'P191010183832737' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425226' WHERE ordernumber = 'P191010184034930' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '342482' WHERE ordernumber = 'P201010184037147' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425229' WHERE ordernumber = 'P731010184323765' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425227' WHERE ordernumber = 'P191010184325962' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '228944' WHERE ordernumber = 'P191010184444410' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425228' WHERE ordernumber = 'P191010184724983' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425231' WHERE ordernumber = 'P421010184757120' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425232' WHERE ordernumber = 'P421010184850578' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425233' WHERE ordernumber = 'P421010184947187' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '289391' WHERE ordernumber = 'P181010185325692' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '310323' WHERE ordernumber = 'P201010185519395' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '294401' WHERE ordernumber = 'P421010185522158' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '949' WHERE ordernumber = 'P191010190557874' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425235' WHERE ordernumber = 'P711010190602533' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '276668' WHERE ordernumber = 'P191010190943230' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '193615' WHERE ordernumber = 'P191010191301510' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425237' WHERE ordernumber = 'P201010191328577' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425238' WHERE ordernumber = 'P711010192052525' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425240' WHERE ordernumber = 'P201010192137810' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425141' WHERE ordernumber = 'P201010192233582' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425239' WHERE ordernumber = 'P191010192549354' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425241' WHERE ordernumber = 'P201010192850298' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '250493' WHERE ordernumber = 'P201010193304830' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '366352' WHERE ordernumber = 'P191010193547664' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425242' WHERE ordernumber = 'P711010193651966' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425243' WHERE ordernumber = 'P201010193859195' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '167846' WHERE ordernumber = 'P191010193915112' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '416235' WHERE ordernumber = 'P711010194129259' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '130397' WHERE ordernumber = 'P711010194655851' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '340548' WHERE ordernumber = 'P201010194943649' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425244' WHERE ordernumber = 'P201010195225283' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425245' WHERE ordernumber = 'P201010195431236' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425247' WHERE ordernumber = 'P191010200139629' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425250' WHERE ordernumber = 'P711010202142547' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425249' WHERE ordernumber = 'P631010202622710' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425251' WHERE ordernumber = 'P711010203024749' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425252' WHERE ordernumber = 'P711010203139144' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '425253' WHERE ordernumber = 'P711010203627430' 2024-10-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '218037' WHERE ordernumber = 'P711010214246426'