2024-06-20 01:00:02 -- 將會員中心id寫入data-lake
2024-06-20 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-06-19%';
        
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353525'
                WHERE ordernumber = 'P190619110217552' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289253'
                WHERE ordernumber = 'P180619110225796' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353525'
                WHERE ordernumber = 'P190619110315159' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326963'
                WHERE ordernumber = 'P200619110948984' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '292819'
                WHERE ordernumber = 'P200619111340345' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396700'
                WHERE ordernumber = 'P190619111453240' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390816'
                WHERE ordernumber = 'P420619111520707' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180619111657125' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379895'
                WHERE ordernumber = 'P200619111715422' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396701'
                WHERE ordernumber = 'P420619111748220' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396702'
                WHERE ordernumber = 'P420619111915723' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113380'
                WHERE ordernumber = 'P180619112910409' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98527'
                WHERE ordernumber = 'P200619113149162' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98527'
                WHERE ordernumber = 'P200619113152973' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98527'
                WHERE ordernumber = 'P200619113154419' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98527'
                WHERE ordernumber = 'P200619113156708' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P200619113533231' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263110'
                WHERE ordernumber = 'P200619113705647' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392366'
                WHERE ordernumber = 'P190619114147270' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396703'
                WHERE ordernumber = 'P190619114535864' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396703'
                WHERE ordernumber = 'P190619114556257' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344223'
                WHERE ordernumber = 'P180619114617197' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277235'
                WHERE ordernumber = 'P190619115016805' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304694'
                WHERE ordernumber = 'P420619115630467' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396673'
                WHERE ordernumber = 'P180619115921157' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396673'
                WHERE ordernumber = 'P180619115948963' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377184'
                WHERE ordernumber = 'P180619120516325' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390480'
                WHERE ordernumber = 'P180619120602511' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396705'
                WHERE ordernumber = 'P420619120707635' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388879'
                WHERE ordernumber = 'P200619121148714' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377694'
                WHERE ordernumber = 'P420619121332164' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396706'
                WHERE ordernumber = 'P200619122153822' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396707'
                WHERE ordernumber = 'P780619122949836' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P180619123043421' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396708'
                WHERE ordernumber = 'P200619123121679' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383594'
                WHERE ordernumber = 'P180619123143488' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376766'
                WHERE ordernumber = 'P420619123731708' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396711'
                WHERE ordernumber = 'P180619123805880' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396712'
                WHERE ordernumber = 'P180619124045984' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396714'
                WHERE ordernumber = 'P180619124228746' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396715'
                WHERE ordernumber = 'P630619124326446' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339507'
                WHERE ordernumber = 'P420619124720666' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396716'
                WHERE ordernumber = 'P630619125131671' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247906'
                WHERE ordernumber = 'P200619125811852' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253575'
                WHERE ordernumber = 'P200619125947684' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396718'
                WHERE ordernumber = 'P200619130254394' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352212'
                WHERE ordernumber = 'P420619131510895' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396720'
                WHERE ordernumber = 'P630619131528149' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396721'
                WHERE ordernumber = 'P780619132157334' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283209'
                WHERE ordernumber = 'P180619132541112' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374248'
                WHERE ordernumber = 'P420619132940237' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396722'
                WHERE ordernumber = 'P180619133036153' 
            
2024-06-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314748'
                WHERE ordernumber = 'P180619133606434' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396723'
                WHERE ordernumber = 'P420619133656172' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P200619133717738' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P200619133754508' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396725'
                WHERE ordernumber = 'P190619133842256' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396725'
                WHERE ordernumber = 'P190619133945481' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396724'
                WHERE ordernumber = 'P180619133954672' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212585'
                WHERE ordernumber = 'P190619134130128' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P180619134226208' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138340'
                WHERE ordernumber = 'P190619134248545' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396726'
                WHERE ordernumber = 'P420619134327643' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396730'
                WHERE ordernumber = 'P180619134852785' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227034'
                WHERE ordernumber = 'P180619135125840' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357873'
                WHERE ordernumber = 'P420619135953445' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396732'
                WHERE ordernumber = 'P180619140056845' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P200619140331787' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132520'
                WHERE ordernumber = 'P180619140754972' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394400'
                WHERE ordernumber = 'P200619140814784' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369695'
                WHERE ordernumber = 'P200619140953633' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396737'
                WHERE ordernumber = 'P420619141353355' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '192556'
                WHERE ordernumber = 'P180619141425754' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396738'
                WHERE ordernumber = 'P190619141447446' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387520'
                WHERE ordernumber = 'P180619141558408' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396740'
                WHERE ordernumber = 'P180619142055199' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346631'
                WHERE ordernumber = 'P200619142224538' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200619142317120' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358425'
                WHERE ordernumber = 'P420619142736159' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396743'
                WHERE ordernumber = 'P190619143711341' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378398'
                WHERE ordernumber = 'P200619143845469' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275131'
                WHERE ordernumber = 'P180619143917716' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105583'
                WHERE ordernumber = 'P190619144003438' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396745'
                WHERE ordernumber = 'P180619144607599' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396746'
                WHERE ordernumber = 'P420619145001773' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '58275'
                WHERE ordernumber = 'P630619145437514' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396747'
                WHERE ordernumber = 'P200619145629830' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180619145816464' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396748'
                WHERE ordernumber = 'P190619145858130' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396750'
                WHERE ordernumber = 'P200619150145544' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396749'
                WHERE ordernumber = 'P630619150240197' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396751'
                WHERE ordernumber = 'P630619150529502' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283242'
                WHERE ordernumber = 'P200619150618788' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396752'
                WHERE ordernumber = 'P180619150655193' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '204807'
                WHERE ordernumber = 'P180619150950784' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396753'
                WHERE ordernumber = 'P780619151127159' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345721'
                WHERE ordernumber = 'P200619151133744' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396754'
                WHERE ordernumber = 'P180619151213496' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109804'
                WHERE ordernumber = 'P780619151435772' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289954'
                WHERE ordernumber = 'P180619151440936' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283242'
                WHERE ordernumber = 'P200619151529630' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219481'
                WHERE ordernumber = 'P180619151711857' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289954'
                WHERE ordernumber = 'P190619151741301' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396755'
                WHERE ordernumber = 'P200619151753794' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396756'
                WHERE ordernumber = 'P630619151916374' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396758'
                WHERE ordernumber = 'P180619152947656' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305527'
                WHERE ordernumber = 'P200619153122543' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396760'
                WHERE ordernumber = 'P420619153316402' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396760'
                WHERE ordernumber = 'P420619153451837' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396761'
                WHERE ordernumber = 'P180619153528986' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396762'
                WHERE ordernumber = 'P180619154104490' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287399'
                WHERE ordernumber = 'P200619154634378' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396763'
                WHERE ordernumber = 'P180619154655694' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302307'
                WHERE ordernumber = 'P630619154839450' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302413'
                WHERE ordernumber = 'P200619155736853' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396766'
                WHERE ordernumber = 'P180619155749924' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396765'
                WHERE ordernumber = 'P180619155929297' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339493'
                WHERE ordernumber = 'P630619155948735' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396768'
                WHERE ordernumber = 'P180619160047513' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95279'
                WHERE ordernumber = 'P630619160106864' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396769'
                WHERE ordernumber = 'P200619160106747' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396770'
                WHERE ordernumber = 'P180619160340330' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385812'
                WHERE ordernumber = 'P180619161347271' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396773'
                WHERE ordernumber = 'P200619161809910' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396774'
                WHERE ordernumber = 'P590619162100382' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340555'
                WHERE ordernumber = 'P420619162120999' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302322'
                WHERE ordernumber = 'P200619162618530' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396775'
                WHERE ordernumber = 'P190619162721754' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396778'
                WHERE ordernumber = 'P200619162754620' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308929'
                WHERE ordernumber = 'P180619162836449' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396775'
                WHERE ordernumber = 'P190619162848883' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396778'
                WHERE ordernumber = 'P200619162900280' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396776'
                WHERE ordernumber = 'P190619162921872' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396776'
                WHERE ordernumber = 'P190619162951176' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396779'
                WHERE ordernumber = 'P630619162954756' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396775'
                WHERE ordernumber = 'P190619163037264' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343239'
                WHERE ordernumber = 'P180619163126844' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396780'
                WHERE ordernumber = 'P420619163951464' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396781'
                WHERE ordernumber = 'P190619164148701' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396781'
                WHERE ordernumber = 'P190619164228813' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396781'
                WHERE ordernumber = 'P190619164247790' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396782'
                WHERE ordernumber = 'P630619164502424' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396783'
                WHERE ordernumber = 'P200619164533194' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255328'
                WHERE ordernumber = 'P180619164702208' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396784'
                WHERE ordernumber = 'P780619164802249' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312650'
                WHERE ordernumber = 'P200619165009380' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228200'
                WHERE ordernumber = 'P180619165038849' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396785'
                WHERE ordernumber = 'P200619165337718' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396786'
                WHERE ordernumber = 'P200619165449511' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396787'
                WHERE ordernumber = 'P200619165614559' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367207'
                WHERE ordernumber = 'P180619170053152' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88988'
                WHERE ordernumber = 'P420619170522771' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396790'
                WHERE ordernumber = 'P200619170802515' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295633'
                WHERE ordernumber = 'P630619171315729' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284337'
                WHERE ordernumber = 'P180619171540782' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396793'
                WHERE ordernumber = 'P630619171732690' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396791'
                WHERE ordernumber = 'P630619171832633' 
            
2024-06-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396794'
                WHERE ordernumber = 'P420619171853369' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396796'
                WHERE ordernumber = 'P630619172100816' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396797'
                WHERE ordernumber = 'P420619172144929' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396799'
                WHERE ordernumber = 'P630619172724803' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112530'
                WHERE ordernumber = 'P180619172735488' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396800'
                WHERE ordernumber = 'P180619172944479' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98527'
                WHERE ordernumber = 'P200619173522546' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396802'
                WHERE ordernumber = 'P630619173547925' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396803'
                WHERE ordernumber = 'P180619173712677' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334506'
                WHERE ordernumber = 'P420619173750806' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395293'
                WHERE ordernumber = 'P180619173806526' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396805'
                WHERE ordernumber = 'P180619174022648' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396806'
                WHERE ordernumber = 'P200619174103668' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324778'
                WHERE ordernumber = 'P420619174248137' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108089'
                WHERE ordernumber = 'P200619174316924' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288768'
                WHERE ordernumber = 'P420619174344426' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396807'
                WHERE ordernumber = 'P630619174408116' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396808'
                WHERE ordernumber = 'P780619174937488' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396810'
                WHERE ordernumber = 'P180619175035508' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347544'
                WHERE ordernumber = 'P180619175435789' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396812'
                WHERE ordernumber = 'P630619175443273' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396045'
                WHERE ordernumber = 'P200619175956318' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396618'
                WHERE ordernumber = 'P630619180814713' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396814'
                WHERE ordernumber = 'P420619181221373' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351296'
                WHERE ordernumber = 'P200619181421743' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353559'
                WHERE ordernumber = 'P180619181422604' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396815'
                WHERE ordernumber = 'P420619181813856' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393377'
                WHERE ordernumber = 'P630619181952355' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396816'
                WHERE ordernumber = 'P200619182047564' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396817'
                WHERE ordernumber = 'P630619182134223' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274944'
                WHERE ordernumber = 'P180619182518690' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161466'
                WHERE ordernumber = 'P180619182755538' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396818'
                WHERE ordernumber = 'P180619183117171' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161466'
                WHERE ordernumber = 'P180619183209304' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76999'
                WHERE ordernumber = 'P200619183338696' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396819'
                WHERE ordernumber = 'P180619183555210' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396820'
                WHERE ordernumber = 'P180619183607180' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162345'
                WHERE ordernumber = 'P180619184328704' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396821'
                WHERE ordernumber = 'P200619184532721' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396822'
                WHERE ordernumber = 'P200619185118294' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139595'
                WHERE ordernumber = 'P780619185128819' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '16477'
                WHERE ordernumber = 'P420619185620303' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214788'
                WHERE ordernumber = 'P190619185646216' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396824'
                WHERE ordernumber = 'P190619185749298' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396826'
                WHERE ordernumber = 'P780619190112754' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396827'
                WHERE ordernumber = 'P630619190237969' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396828'
                WHERE ordernumber = 'P200619190300303' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305958'
                WHERE ordernumber = 'P200619190338231' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304835'
                WHERE ordernumber = 'P190619190445172' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396829'
                WHERE ordernumber = 'P630619190449955' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396831'
                WHERE ordernumber = 'P780619190605228' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396832'
                WHERE ordernumber = 'P190619191131934' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396833'
                WHERE ordernumber = 'P200619191200702' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275457'
                WHERE ordernumber = 'P190619191224742' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395086'
                WHERE ordernumber = 'P200619191540809' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396834'
                WHERE ordernumber = 'P780619191816326' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219982'
                WHERE ordernumber = 'P200619191946850' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '171275'
                WHERE ordernumber = 'P190619192625801' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243502'
                WHERE ordernumber = 'P190619192706184' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396835'
                WHERE ordernumber = 'P200619192713411' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305817'
                WHERE ordernumber = 'P190619192927656' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276001'
                WHERE ordernumber = 'P200619193040619' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305817'
                WHERE ordernumber = 'P190619193056776' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236945'
                WHERE ordernumber = 'P190619193226980' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396836'
                WHERE ordernumber = 'P630619193703887' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396837'
                WHERE ordernumber = 'P780619193707542' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396838'
                WHERE ordernumber = 'P190619193708989' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89059'
                WHERE ordernumber = 'P200619193924146' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396840'
                WHERE ordernumber = 'P630619194246754' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396841'
                WHERE ordernumber = 'P190619194434115' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396842'
                WHERE ordernumber = 'P630619194813778' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396764'
                WHERE ordernumber = 'P190619195123350' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396764'
                WHERE ordernumber = 'P190619195202874' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396843'
                WHERE ordernumber = 'P630619195217383' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396844'
                WHERE ordernumber = 'P630619200533638' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396845'
                WHERE ordernumber = 'P780619203834542' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396846'
                WHERE ordernumber = 'P780619205704772' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396847'
                WHERE ordernumber = 'P630619205829474' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396848'
                WHERE ordernumber = 'P630619211519736' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396850'
                WHERE ordernumber = 'P630619212539574' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396849'
                WHERE ordernumber = 'P630619212614862' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396851'
                WHERE ordernumber = 'P780619212726861' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396852'
                WHERE ordernumber = 'P780619213333534' 
            
2024-06-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396854'
                WHERE ordernumber = 'P780619214529845'