2024-07-24 01:00:03 -- 將會員中心id寫入data-lake
2024-07-24 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-23%';
        
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348746'
                WHERE ordernumber = 'P180723110501462' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400758'
                WHERE ordernumber = 'P180723110601375' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402691'
                WHERE ordernumber = 'P630723110827680' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275012'
                WHERE ordernumber = 'P420723110902391' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402693'
                WHERE ordernumber = 'P180723110925151' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180723111342958' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389388'
                WHERE ordernumber = 'P180723111509279' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402694'
                WHERE ordernumber = 'P190723111630123' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402677'
                WHERE ordernumber = 'P180723111957390' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P420723112027276' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401915'
                WHERE ordernumber = 'P420723112326458' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335123'
                WHERE ordernumber = 'P180723112408819' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P420723112611457' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402697'
                WHERE ordernumber = 'P180723112709732' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307428'
                WHERE ordernumber = 'P180723113454329' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307428'
                WHERE ordernumber = 'P180723113550820' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378990'
                WHERE ordernumber = 'P180723113657505' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402699'
                WHERE ordernumber = 'P180723113827520' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389657'
                WHERE ordernumber = 'P190723113910500' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402700'
                WHERE ordernumber = 'P420723114117393' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402701'
                WHERE ordernumber = 'P200723114443783' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402706'
                WHERE ordernumber = 'P420723115524742' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402708'
                WHERE ordernumber = 'P190723115651868' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88454'
                WHERE ordernumber = 'P180723120014806' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402712'
                WHERE ordernumber = 'P200723120834277' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402715'
                WHERE ordernumber = 'P180723121505204' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392613'
                WHERE ordernumber = 'P200723122404600' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400354'
                WHERE ordernumber = 'P180723122417313' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263408'
                WHERE ordernumber = 'P200723122658897' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402054'
                WHERE ordernumber = 'P200723123350202' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '48124'
                WHERE ordernumber = 'P200723124346449' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402720'
                WHERE ordernumber = 'P200723124514868' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402721'
                WHERE ordernumber = 'P200723124656784' 
            
2024-07-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402722'
                WHERE ordernumber = 'P180723125048397' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402723'
                WHERE ordernumber = 'P180723125515120' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313187'
                WHERE ordernumber = 'P180723125741171' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94941'
                WHERE ordernumber = 'P200723131341734' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402452'
                WHERE ordernumber = 'P180723131548422' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402726'
                WHERE ordernumber = 'P180723131750781' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310806'
                WHERE ordernumber = 'P180723131859456' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '361240'
                WHERE ordernumber = 'P180723132356652' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402727'
                WHERE ordernumber = 'P180723134320277' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402728'
                WHERE ordernumber = 'P180723134453977' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402729'
                WHERE ordernumber = 'P180723134651338' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371602'
                WHERE ordernumber = 'P180723135539142' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355738'
                WHERE ordernumber = 'P180723140028492' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402733'
                WHERE ordernumber = 'P180723140544373' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402028'
                WHERE ordernumber = 'P180723140849652' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P190723140933398' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402738'
                WHERE ordernumber = 'P180723142049392' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402739'
                WHERE ordernumber = 'P180723142258396' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402740'
                WHERE ordernumber = 'P200723142740552' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301769'
                WHERE ordernumber = 'P200723143239442' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215040'
                WHERE ordernumber = 'P200723143534606' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241483'
                WHERE ordernumber = 'P180723143625920' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87773'
                WHERE ordernumber = 'P200723144042674' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402742'
                WHERE ordernumber = 'P190723144236588' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357546'
                WHERE ordernumber = 'P420723144329685' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394739'
                WHERE ordernumber = 'P420723144627979' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161113'
                WHERE ordernumber = 'P200723144909473' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300866'
                WHERE ordernumber = 'P200723145015149' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243898'
                WHERE ordernumber = 'P200723145103140' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402743'
                WHERE ordernumber = 'P420723145112347' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402240'
                WHERE ordernumber = 'P420723145346529' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396827'
                WHERE ordernumber = 'P190723145523671' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402744'
                WHERE ordernumber = 'P420723150121437' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99638'
                WHERE ordernumber = 'P190723150243363' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '197927'
                WHERE ordernumber = 'P180723150304746' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402746'
                WHERE ordernumber = 'P420723150436701' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215107'
                WHERE ordernumber = 'P590723150559956' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402750'
                WHERE ordernumber = 'P420723151054341' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348862'
                WHERE ordernumber = 'P420723151511114' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381950'
                WHERE ordernumber = 'P630723151636260' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402749'
                WHERE ordernumber = 'P190723152356471' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402732'
                WHERE ordernumber = 'P180723152655504' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118667'
                WHERE ordernumber = 'P200723152701565' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377422'
                WHERE ordernumber = 'P420723152834233' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402755'
                WHERE ordernumber = 'P180723153118621' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397375'
                WHERE ordernumber = 'P190723153548213' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344013'
                WHERE ordernumber = 'P420723154506275' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386742'
                WHERE ordernumber = 'P180723154537257' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402760'
                WHERE ordernumber = 'P200723154655366' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326275'
                WHERE ordernumber = 'P200723154811171' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402761'
                WHERE ordernumber = 'P180723154835815' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402762'
                WHERE ordernumber = 'P420723155125592' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399947'
                WHERE ordernumber = 'P180723155209878' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391016'
                WHERE ordernumber = 'P420723155411629' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402759'
                WHERE ordernumber = 'P180723155608581' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402765'
                WHERE ordernumber = 'P200723155811630' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388788'
                WHERE ordernumber = 'P180723160608421' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402770'
                WHERE ordernumber = 'P420723161124892' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402771'
                WHERE ordernumber = 'P180723161223627' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231594'
                WHERE ordernumber = 'P180723161659242' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304893'
                WHERE ordernumber = 'P200723162340391' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402773'
                WHERE ordernumber = 'P180723162800820' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365625'
                WHERE ordernumber = 'P420723163502223' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142462'
                WHERE ordernumber = 'P190723163605759' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229518'
                WHERE ordernumber = 'P190723163730666' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402774'
                WHERE ordernumber = 'P420723163803717' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344743'
                WHERE ordernumber = 'P180723163929320' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396443'
                WHERE ordernumber = 'P200723164051569' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402495'
                WHERE ordernumber = 'P630723164119702' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387244'
                WHERE ordernumber = 'P180723164325352' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391227'
                WHERE ordernumber = 'P200723164858648' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400658'
                WHERE ordernumber = 'P200723171458394' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125487'
                WHERE ordernumber = 'P180723171504810' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136997'
                WHERE ordernumber = 'P190723171645215' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402781'
                WHERE ordernumber = 'P190723171803785' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346054'
                WHERE ordernumber = 'P190723171843290' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402782'
                WHERE ordernumber = 'P200723171915525' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245134'
                WHERE ordernumber = 'P200723172259127' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402785'
                WHERE ordernumber = 'P180723172729993' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303791'
                WHERE ordernumber = 'P420723173021365' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402786'
                WHERE ordernumber = 'P180723173041138' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402787'
                WHERE ordernumber = 'P180723173409503' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402789'
                WHERE ordernumber = 'P180723173735738' 
            
2024-07-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402790'
                WHERE ordernumber = 'P180723173943704' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379280'
                WHERE ordernumber = 'P200723174004717' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402792'
                WHERE ordernumber = 'P180723174142494' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402788'
                WHERE ordernumber = 'P180723174449886' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402788'
                WHERE ordernumber = 'P180723174526277' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '356070'
                WHERE ordernumber = 'P180723174636229' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '326618'
                WHERE ordernumber = 'P200723174701758' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402794'
                WHERE ordernumber = 'P180723174756868' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400688'
                WHERE ordernumber = 'P420723175158758' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402796'
                WHERE ordernumber = 'P180723175310542' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402797'
                WHERE ordernumber = 'P180723175532785' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391565'
                WHERE ordernumber = 'P200723175637654' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402798'
                WHERE ordernumber = 'P180723175942484' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94987'
                WHERE ordernumber = 'P190723180007329' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402799'
                WHERE ordernumber = 'P180723180142314' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402800'
                WHERE ordernumber = 'P190723180538231' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '168516'
                WHERE ordernumber = 'P200723180738333' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402801'
                WHERE ordernumber = 'P190723180746811' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402027'
                WHERE ordernumber = 'P200723180846649' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402802'
                WHERE ordernumber = 'P190723181017634' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402803'
                WHERE ordernumber = 'P180723181253369' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402804'
                WHERE ordernumber = 'P190723181324248' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402805'
                WHERE ordernumber = 'P200723181621228' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402807'
                WHERE ordernumber = 'P190723181909643' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402806'
                WHERE ordernumber = 'P420723181917648' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402803'
                WHERE ordernumber = 'P180723182123457' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264480'
                WHERE ordernumber = 'P180723182604232' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402808'
                WHERE ordernumber = 'P200723182822377' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212547'
                WHERE ordernumber = 'P180723183119742' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402809'
                WHERE ordernumber = 'P200723183554965' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313052'
                WHERE ordernumber = 'P180723184025382' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208071'
                WHERE ordernumber = 'P180723184201267' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '376350'
                WHERE ordernumber = 'P190723184505528' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402494'
                WHERE ordernumber = 'P190723185000922' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '216410'
                WHERE ordernumber = 'P200723185023605' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402812'
                WHERE ordernumber = 'P420723185346760' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '308125'
                WHERE ordernumber = 'P190723185354519' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '135807'
                WHERE ordernumber = 'P190723185618626' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402813'
                WHERE ordernumber = 'P190723185956808' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402814'
                WHERE ordernumber = 'P190723190154785' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249879'
                WHERE ordernumber = 'P200723190756551' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402816'
                WHERE ordernumber = 'P200723191020724' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '84019'
                WHERE ordernumber = 'P190723191137658' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '112005'
                WHERE ordernumber = 'P190723191408948' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287466'
                WHERE ordernumber = 'P200723191850741' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349433'
                WHERE ordernumber = 'P190723191955451' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222080'
                WHERE ordernumber = 'P190723192206372' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402818'
                WHERE ordernumber = 'P200723192327127' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402819'
                WHERE ordernumber = 'P190723192342284' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '138586'
                WHERE ordernumber = 'P630723192731972' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235646'
                WHERE ordernumber = 'P200723193400901' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297104'
                WHERE ordernumber = 'P200723193559330' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '107291'
                WHERE ordernumber = 'P190723194317259' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P190723195451559' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402123'
                WHERE ordernumber = 'P200723195507969' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402821'
                WHERE ordernumber = 'P200723195850323' 
            
2024-07-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169009'
                WHERE ordernumber = 'P590723205433301'