2023-12-24 01:00:02 -- 將會員中心id寫入data-lake
2023-12-24 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 '2023-12-23%';
        
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354364'
                WHERE ordernumber = 'P191223110134431' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308582'
                WHERE ordernumber = 'P191223110200923' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328007'
                WHERE ordernumber = 'P201223110222687' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348622'
                WHERE ordernumber = 'P181223110439335' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308582'
                WHERE ordernumber = 'P191223110616409' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354365'
                WHERE ordernumber = 'P191223110804590' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354366'
                WHERE ordernumber = 'P181223110925316' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354368'
                WHERE ordernumber = 'P181223111113874' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354369'
                WHERE ordernumber = 'P201223111257558' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320379'
                WHERE ordernumber = 'P181223111633174' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354371'
                WHERE ordernumber = 'P181223111740619' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216890'
                WHERE ordernumber = 'P191223112028728' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354376'
                WHERE ordernumber = 'P181223112339558' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354370'
                WHERE ordernumber = 'P201223112405828' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354377'
                WHERE ordernumber = 'P181223112445724' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320767'
                WHERE ordernumber = 'P201223112516438' 
            
2023-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216996'
                WHERE ordernumber = 'P421223112537114' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354379'
                WHERE ordernumber = 'P181223112843976' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354380'
                WHERE ordernumber = 'P181223113016962' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P181223113051285' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354383'
                WHERE ordernumber = 'P181223113549432' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164324'
                WHERE ordernumber = 'P191223114023497' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146430'
                WHERE ordernumber = 'P201223114222504' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354384'
                WHERE ordernumber = 'P191223114301746' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242754'
                WHERE ordernumber = 'P191223114417386' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354386'
                WHERE ordernumber = 'P181223114552822' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354387'
                WHERE ordernumber = 'P191223114554795' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354389'
                WHERE ordernumber = 'P181223114720788' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255883'
                WHERE ordernumber = 'P181223114800967' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354390'
                WHERE ordernumber = 'P181223114903542' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181223115021818' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255883'
                WHERE ordernumber = 'P181223115131831' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354392'
                WHERE ordernumber = 'P181223115341715' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344841'
                WHERE ordernumber = 'P201223115452168' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354393'
                WHERE ordernumber = 'P181223115509747' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354394'
                WHERE ordernumber = 'P181223115620463' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248048'
                WHERE ordernumber = 'P181223115704587' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351928'
                WHERE ordernumber = 'P421223120031584' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354396'
                WHERE ordernumber = 'P201223120229864' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354397'
                WHERE ordernumber = 'P201223120428564' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350966'
                WHERE ordernumber = 'P201223121031973' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119574'
                WHERE ordernumber = 'P201223121510959' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231545'
                WHERE ordernumber = 'P181223121541738' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354400'
                WHERE ordernumber = 'P421223121900660' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118908'
                WHERE ordernumber = 'P191223122006245' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354401'
                WHERE ordernumber = 'P191223122202967' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267019'
                WHERE ordernumber = 'P181223122231636' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271269'
                WHERE ordernumber = 'P201223122506619' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346850'
                WHERE ordernumber = 'P201223122725501' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354402'
                WHERE ordernumber = 'P201223122840850' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210891'
                WHERE ordernumber = 'P181223123049184' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304297'
                WHERE ordernumber = 'P201223123343679' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354403'
                WHERE ordernumber = 'P201223123431788' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308903'
                WHERE ordernumber = 'P191223123759619' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219462'
                WHERE ordernumber = 'P201223123818991' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288064'
                WHERE ordernumber = 'P181223123921641' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354406'
                WHERE ordernumber = 'P181223124628606' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354405'
                WHERE ordernumber = 'P181223124806495' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167929'
                WHERE ordernumber = 'P201223124846508' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354409'
                WHERE ordernumber = 'P181223125037277' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132796'
                WHERE ordernumber = 'P181223125121188' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237298'
                WHERE ordernumber = 'P181223125211629' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354411'
                WHERE ordernumber = 'P201223125244249' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286222'
                WHERE ordernumber = 'P201223125402994' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354413'
                WHERE ordernumber = 'P201223125535876' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354412'
                WHERE ordernumber = 'P181223125549319' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252691'
                WHERE ordernumber = 'P201223125633116' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306297'
                WHERE ordernumber = 'P181223125711509' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348726'
                WHERE ordernumber = 'P421223125714258' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354381'
                WHERE ordernumber = 'P181223125813120' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318869'
                WHERE ordernumber = 'P201223130008498' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354415'
                WHERE ordernumber = 'P181223130109232' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299697'
                WHERE ordernumber = 'P421223130235635' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354417'
                WHERE ordernumber = 'P181223130422991' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248366'
                WHERE ordernumber = 'P201223130818787' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221817'
                WHERE ordernumber = 'P201223132020476' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '26071'
                WHERE ordernumber = 'P181223132217557' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354423'
                WHERE ordernumber = 'P181223132725916' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354425'
                WHERE ordernumber = 'P181223132855646' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296414'
                WHERE ordernumber = 'P421223132926770' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264610'
                WHERE ordernumber = 'P421223133026764' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354422'
                WHERE ordernumber = 'P181223133045441' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281355'
                WHERE ordernumber = 'P191223133338525' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354424'
                WHERE ordernumber = 'P421223133442911' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354428'
                WHERE ordernumber = 'P201223133542385' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354432'
                WHERE ordernumber = 'P181223133907580' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100279'
                WHERE ordernumber = 'P181223133952144' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354433'
                WHERE ordernumber = 'P181223134319184' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237023'
                WHERE ordernumber = 'P201223134323924' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354434'
                WHERE ordernumber = 'P181223134601553' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354436'
                WHERE ordernumber = 'P181223134742971' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354322'
                WHERE ordernumber = 'P181223134841986' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354442'
                WHERE ordernumber = 'P421223135913186' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354440'
                WHERE ordernumber = 'P181223135937414' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354444'
                WHERE ordernumber = 'P181223140041329' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P181223140253438' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321157'
                WHERE ordernumber = 'P181223140642164' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353342'
                WHERE ordernumber = 'P201223141148232' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354448'
                WHERE ordernumber = 'P181223141605775' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160711'
                WHERE ordernumber = 'P201223141748538' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354447'
                WHERE ordernumber = 'P191223141826538' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354451'
                WHERE ordernumber = 'P181223142047287' 
            
2023-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354452'
                WHERE ordernumber = 'P201223142154335' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99926'
                WHERE ordernumber = 'P191223142446817' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343984'
                WHERE ordernumber = 'P181223142550627' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354454'
                WHERE ordernumber = 'P201223142605328' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138749'
                WHERE ordernumber = 'P191223142700218' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74290'
                WHERE ordernumber = 'P421223142929300' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354457'
                WHERE ordernumber = 'P421223143038374' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354458'
                WHERE ordernumber = 'P181223143127156' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271599'
                WHERE ordernumber = 'P201223143200538' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '192657'
                WHERE ordernumber = 'P181223143224423' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154455'
                WHERE ordernumber = 'P421223143329523' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354459'
                WHERE ordernumber = 'P191223144251565' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354461'
                WHERE ordernumber = 'P191223144409886' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354462'
                WHERE ordernumber = 'P191223144509601' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354463'
                WHERE ordernumber = 'P191223144559968' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354464'
                WHERE ordernumber = 'P181223144630724' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354465'
                WHERE ordernumber = 'P201223144742715' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354466'
                WHERE ordernumber = 'P181223144757155' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290603'
                WHERE ordernumber = 'P421223144828914' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354467'
                WHERE ordernumber = 'P181223145020281' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354468'
                WHERE ordernumber = 'P181223145211384' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104132'
                WHERE ordernumber = 'P201223145726338' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354470'
                WHERE ordernumber = 'P421223145758900' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340050'
                WHERE ordernumber = 'P201223150000842' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254449'
                WHERE ordernumber = 'P201223150048760' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286647'
                WHERE ordernumber = 'P201223150201699' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354471'
                WHERE ordernumber = 'P201223150439959' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P181223150726705' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354472'
                WHERE ordernumber = 'P191223150844131' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324378'
                WHERE ordernumber = 'P421223150913950' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P181223150949598' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347019'
                WHERE ordernumber = 'P421223151023651' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354473'
                WHERE ordernumber = 'P191223151122581' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '199689'
                WHERE ordernumber = 'P201223151129832' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127298'
                WHERE ordernumber = 'P421223151158668' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354474'
                WHERE ordernumber = 'P181223151205824' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354475'
                WHERE ordernumber = 'P191223151303206' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354476'
                WHERE ordernumber = 'P181223151542965' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238785'
                WHERE ordernumber = 'P201223151631149' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140091'
                WHERE ordernumber = 'P201223151839386' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212791'
                WHERE ordernumber = 'P181223152051385' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288868'
                WHERE ordernumber = 'P181223152234502' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354477'
                WHERE ordernumber = 'P181223152600620' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354478'
                WHERE ordernumber = 'P181223152653892' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354480'
                WHERE ordernumber = 'P181223152751556' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181223152825978' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354482'
                WHERE ordernumber = 'P181223153117254' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354481'
                WHERE ordernumber = 'P421223153141198' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241611'
                WHERE ordernumber = 'P201223153221884' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354485'
                WHERE ordernumber = 'P181223153319960' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354486'
                WHERE ordernumber = 'P201223153327170' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280049'
                WHERE ordernumber = 'P201223153402241' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354488'
                WHERE ordernumber = 'P181223153414790' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306960'
                WHERE ordernumber = 'P181223153459212' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342670'
                WHERE ordernumber = 'P421223153500507' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354489'
                WHERE ordernumber = 'P421223153812412' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241068'
                WHERE ordernumber = 'P201223154021771' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92045'
                WHERE ordernumber = 'P421223154107422' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354491'
                WHERE ordernumber = 'P181223154218707' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354492'
                WHERE ordernumber = 'P421223154302730' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354493'
                WHERE ordernumber = 'P181223154414444' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354494'
                WHERE ordernumber = 'P181223154515360' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354495'
                WHERE ordernumber = 'P181223154633953' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256915'
                WHERE ordernumber = 'P421223154724203' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354496'
                WHERE ordernumber = 'P201223154728330' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354497'
                WHERE ordernumber = 'P181223154825477' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354498'
                WHERE ordernumber = 'P181223154950279' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354500'
                WHERE ordernumber = 'P181223155152361' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354498'
                WHERE ordernumber = 'P181223155213893' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354501'
                WHERE ordernumber = 'P181223155617239' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354503'
                WHERE ordernumber = 'P181223155800504' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353554'
                WHERE ordernumber = 'P181223160027824' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354505'
                WHERE ordernumber = 'P181223160334661' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267800'
                WHERE ordernumber = 'P181223160439311' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299744'
                WHERE ordernumber = 'P201223160731449' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350377'
                WHERE ordernumber = 'P201223161248258' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350914'
                WHERE ordernumber = 'P201223161318538' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258382'
                WHERE ordernumber = 'P201223161527863' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335629'
                WHERE ordernumber = 'P201223161601448' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245383'
                WHERE ordernumber = 'P181223161639486' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354502'
                WHERE ordernumber = 'P181223162109761' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354502'
                WHERE ordernumber = 'P181223162145170' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353484'
                WHERE ordernumber = 'P181223162509403' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323568'
                WHERE ordernumber = 'P421223162648954' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354513'
                WHERE ordernumber = 'P181223162721732' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249709'
                WHERE ordernumber = 'P201223162823745' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354515'
                WHERE ordernumber = 'P181223163021131' 
            
2023-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354517'
                WHERE ordernumber = 'P181223163155382' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354516'
                WHERE ordernumber = 'P421223163317749' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317235'
                WHERE ordernumber = 'P181223163323562' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348116'
                WHERE ordernumber = 'P181223163355212' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104770'
                WHERE ordernumber = 'P421223163557896' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354518'
                WHERE ordernumber = 'P181223163618160' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354520'
                WHERE ordernumber = 'P181223163737136' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '112794'
                WHERE ordernumber = 'P201223163825506' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354522'
                WHERE ordernumber = 'P191223164259964' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97162'
                WHERE ordernumber = 'P201223164522541' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354524'
                WHERE ordernumber = 'P201223164933837' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86548'
                WHERE ordernumber = 'P191223165143732' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354526'
                WHERE ordernumber = 'P421223165258112' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238643'
                WHERE ordernumber = 'P191223165344879' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354529'
                WHERE ordernumber = 'P191223165725323' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354530'
                WHERE ordernumber = 'P421223165859573' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354531'
                WHERE ordernumber = 'P181223170026244' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354532'
                WHERE ordernumber = 'P181223170126809' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354533'
                WHERE ordernumber = 'P191223170402830' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236997'
                WHERE ordernumber = 'P181223170412816' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354528'
                WHERE ordernumber = 'P181223171233560' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '162503'
                WHERE ordernumber = 'P421223171320723' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354537'
                WHERE ordernumber = 'P421223171439245' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314258'
                WHERE ordernumber = 'P181223171604282' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '122776'
                WHERE ordernumber = 'P201223171836184' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353279'
                WHERE ordernumber = 'P181223172122993' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354539'
                WHERE ordernumber = 'P421223172209871' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354541'
                WHERE ordernumber = 'P181223172304584' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354540'
                WHERE ordernumber = 'P201223172525258' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354542'
                WHERE ordernumber = 'P181223172629320' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353279'
                WHERE ordernumber = 'P181223172715462' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354544'
                WHERE ordernumber = 'P181223172813804' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288035'
                WHERE ordernumber = 'P201223172816235' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '211346'
                WHERE ordernumber = 'P201223172904683' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354545'
                WHERE ordernumber = 'P181223172905509' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354547'
                WHERE ordernumber = 'P181223173000675' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351233'
                WHERE ordernumber = 'P181223173042174' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222971'
                WHERE ordernumber = 'P181223173208329' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354549'
                WHERE ordernumber = 'P181223173409211' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354550'
                WHERE ordernumber = 'P181223173507934' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354552'
                WHERE ordernumber = 'P181223173617170' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '261512'
                WHERE ordernumber = 'P181223173743788' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354553'
                WHERE ordernumber = 'P181223173850942' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '23352'
                WHERE ordernumber = 'P181223174027563' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '23352'
                WHERE ordernumber = 'P181223174108149' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318312'
                WHERE ordernumber = 'P201223174314845' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341523'
                WHERE ordernumber = 'P201223174540418' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354554'
                WHERE ordernumber = 'P181223174939198' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354555'
                WHERE ordernumber = 'P181223175038616' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354554'
                WHERE ordernumber = 'P181223175625664' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '223100'
                WHERE ordernumber = 'P191223175854948' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222518'
                WHERE ordernumber = 'P181223175859496' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239428'
                WHERE ordernumber = 'P181223175958228' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354556'
                WHERE ordernumber = 'P181223180405657' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281064'
                WHERE ordernumber = 'P201223180449157' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354558'
                WHERE ordernumber = 'P181223181008465' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311675'
                WHERE ordernumber = 'P181223181352128' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '147211'
                WHERE ordernumber = 'P421223181509727' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346000'
                WHERE ordernumber = 'P181223181535888' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347940'
                WHERE ordernumber = 'P421223181724896' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217861'
                WHERE ordernumber = 'P201223181849860' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '166284'
                WHERE ordernumber = 'P181223181906160' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '335432'
                WHERE ordernumber = 'P191223181915333' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '80681'
                WHERE ordernumber = 'P181223183123614' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354561'
                WHERE ordernumber = 'P181223183510921' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353966'
                WHERE ordernumber = 'P181223183622173' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354562'
                WHERE ordernumber = 'P181223183735485' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301307'
                WHERE ordernumber = 'P181223183815505' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354563'
                WHERE ordernumber = 'P191223183934861' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287257'
                WHERE ordernumber = 'P181223184203132' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354564'
                WHERE ordernumber = 'P191223184349641' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231679'
                WHERE ordernumber = 'P191223184507330' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354564'
                WHERE ordernumber = 'P181223184513765' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '106747'
                WHERE ordernumber = 'P191223184559632' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354565'
                WHERE ordernumber = 'P421223184828851' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94067'
                WHERE ordernumber = 'P191223185017969' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249316'
                WHERE ordernumber = 'P191223185123517' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241368'
                WHERE ordernumber = 'P191223185633729' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238314'
                WHERE ordernumber = 'P201223185855991' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282814'
                WHERE ordernumber = 'P191223190243369' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354568'
                WHERE ordernumber = 'P191223190455732' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354569'
                WHERE ordernumber = 'P191223190551138' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350166'
                WHERE ordernumber = 'P421223191041837' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354572'
                WHERE ordernumber = 'P191223191255952' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282814'
                WHERE ordernumber = 'P191223191638954' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314921'
                WHERE ordernumber = 'P201223191728567' 
            
2023-12-24 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '224059'
                WHERE ordernumber = 'P201223191840577' 
            
2023-12-24 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352970'
                WHERE ordernumber = 'P201223192239653' 
            
2023-12-24 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '354084'
                WHERE ordernumber = 'P191223192411227' 
            
2023-12-24 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '279134'
                WHERE ordernumber = 'P191223192606340' 
            
2023-12-24 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '354576'
                WHERE ordernumber = 'P191223192813590' 
            
2023-12-24 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '333672'
                WHERE ordernumber = 'P201223193526795' 
            
2023-12-24 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '354574'
                WHERE ordernumber = 'P201223193754530' 
            
2023-12-24 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '354580'
                WHERE ordernumber = 'P191223194057282' 
            
2023-12-24 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '346928'
                WHERE ordernumber = 'P191223194329782' 
            
2023-12-24 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '354583'
                WHERE ordernumber = 'P191223195520370' 
            
2023-12-24 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '354586'
                WHERE ordernumber = 'P191223195700665' 
            
2023-12-24 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '248034'
                WHERE ordernumber = 'P191223195725372'