2024-08-08 01:00:03 -- 將會員中心id寫入data-lake
2024-08-08 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-08-07%';
        
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P180807094856257' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P180807095236824' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P180807095441833' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P180807095823686' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381315'
                WHERE ordernumber = 'P420807110119911' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305084'
                WHERE ordernumber = 'P420807110301922' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291414'
                WHERE ordernumber = 'P180807110547344' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329718'
                WHERE ordernumber = 'P420807110601357' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405979'
                WHERE ordernumber = 'P190807110612778' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405981'
                WHERE ordernumber = 'P180807110827672' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405978'
                WHERE ordernumber = 'P190807110913530' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123629'
                WHERE ordernumber = 'P200807110915212' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343510'
                WHERE ordernumber = 'P180807110952269' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234948'
                WHERE ordernumber = 'P200807111004323' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237359'
                WHERE ordernumber = 'P190807111008228' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102205'
                WHERE ordernumber = 'P200807111040698' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405983'
                WHERE ordernumber = 'P180807111118742' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405987'
                WHERE ordernumber = 'P200807111449371' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405987'
                WHERE ordernumber = 'P200807111601331' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329718'
                WHERE ordernumber = 'P420807111642423' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405987'
                WHERE ordernumber = 'P200807111949457' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405989'
                WHERE ordernumber = 'P420807112101561' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405990'
                WHERE ordernumber = 'P190807112332126' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405992'
                WHERE ordernumber = 'P180807112716783' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405993'
                WHERE ordernumber = 'P420807112822129' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262027'
                WHERE ordernumber = 'P190807113748434' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403761'
                WHERE ordernumber = 'P180807114207379' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405996'
                WHERE ordernumber = 'P200807114422176' 
            
2024-08-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405997'
                WHERE ordernumber = 'P180807114805689' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406000'
                WHERE ordernumber = 'P190807115230334' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276466'
                WHERE ordernumber = 'P200807115407251' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406001'
                WHERE ordernumber = 'P180807115414866' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405803'
                WHERE ordernumber = 'P200807115813130' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405547'
                WHERE ordernumber = 'P200807120211918' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406005'
                WHERE ordernumber = 'P180807120253972' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '168485'
                WHERE ordernumber = 'P200807120310517' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314754'
                WHERE ordernumber = 'P420807120833374' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406009'
                WHERE ordernumber = 'P420807121342214' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104404'
                WHERE ordernumber = 'P200807121520189' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406010'
                WHERE ordernumber = 'P420807121527536' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406011'
                WHERE ordernumber = 'P180807121620450' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406014'
                WHERE ordernumber = 'P180807122115982' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103320'
                WHERE ordernumber = 'P180807122554591' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406015'
                WHERE ordernumber = 'P420807122636645' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406016'
                WHERE ordernumber = 'P190807122708334' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406018'
                WHERE ordernumber = 'P200807122709800' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293485'
                WHERE ordernumber = 'P200807122802328' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406019'
                WHERE ordernumber = 'P180807122846904' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272460'
                WHERE ordernumber = 'P200807122927703' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406014'
                WHERE ordernumber = 'P180807123106539' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285414'
                WHERE ordernumber = 'P200807123157961' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266459'
                WHERE ordernumber = 'P630807123324740' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406021'
                WHERE ordernumber = 'P420807123324384' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405415'
                WHERE ordernumber = 'P200807123455553' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395568'
                WHERE ordernumber = 'P420807123829644' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406026'
                WHERE ordernumber = 'P200807123949707' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '58269'
                WHERE ordernumber = 'P180807124129253' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406027'
                WHERE ordernumber = 'P200807124606305' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406030'
                WHERE ordernumber = 'P420807125331175' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406029'
                WHERE ordernumber = 'P180807125335729' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348458'
                WHERE ordernumber = 'P420807125411875' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406031'
                WHERE ordernumber = 'P200807125442710' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406033'
                WHERE ordernumber = 'P200807125800861' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406034'
                WHERE ordernumber = 'P180807125904400' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406035'
                WHERE ordernumber = 'P420807130302224' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406036'
                WHERE ordernumber = 'P200807130916579' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406038'
                WHERE ordernumber = 'P200807131350715' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406039'
                WHERE ordernumber = 'P180807131409374' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283472'
                WHERE ordernumber = 'P180807131548115' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406041'
                WHERE ordernumber = 'P180807131700321' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406043'
                WHERE ordernumber = 'P420807131909556' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167164'
                WHERE ordernumber = 'P200807132237350' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406044'
                WHERE ordernumber = 'P180807132301300' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94390'
                WHERE ordernumber = 'P180807132558486' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399525'
                WHERE ordernumber = 'P200807132845439' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406048'
                WHERE ordernumber = 'P180807132902542' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '148994'
                WHERE ordernumber = 'P180807133105311' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406050'
                WHERE ordernumber = 'P180807133313343' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406050'
                WHERE ordernumber = 'P180807133351986' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384966'
                WHERE ordernumber = 'P590807133543439' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209774'
                WHERE ordernumber = 'P180807133628881' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406052'
                WHERE ordernumber = 'P420807133846175' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406053'
                WHERE ordernumber = 'P200807133934664' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406054'
                WHERE ordernumber = 'P420807134015699' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309980'
                WHERE ordernumber = 'P180807134247942' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309980'
                WHERE ordernumber = 'P180807134313211' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180807134836957' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252472'
                WHERE ordernumber = 'P180807140200447' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406063'
                WHERE ordernumber = 'P420807140228258' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218548'
                WHERE ordernumber = 'P200807140832253' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255138'
                WHERE ordernumber = 'P420807141055660' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406068'
                WHERE ordernumber = 'P180807141619159' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406069'
                WHERE ordernumber = 'P180807141821155' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406070'
                WHERE ordernumber = 'P420807142002418' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284241'
                WHERE ordernumber = 'P180807142451214' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P190807142828332' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347230'
                WHERE ordernumber = 'P180807143054391' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406074'
                WHERE ordernumber = 'P180807143317969' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297338'
                WHERE ordernumber = 'P420807143526808' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406077'
                WHERE ordernumber = 'P180807143859197' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388973'
                WHERE ordernumber = 'P200807143903278' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406078'
                WHERE ordernumber = 'P200807144040262' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406080'
                WHERE ordernumber = 'P200807144404676' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406081'
                WHERE ordernumber = 'P180807144541161' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406082'
                WHERE ordernumber = 'P200807144746902' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103940'
                WHERE ordernumber = 'P180807145042111' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P180807145113450' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161876'
                WHERE ordernumber = 'P200807145153534' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406084'
                WHERE ordernumber = 'P420807145828550' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406086'
                WHERE ordernumber = 'P180807145944716' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138070'
                WHERE ordernumber = 'P180807150015845' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274566'
                WHERE ordernumber = 'P200807150228938' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406091'
                WHERE ordernumber = 'P200807151101436' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406092'
                WHERE ordernumber = 'P180807151138868' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280432'
                WHERE ordernumber = 'P420807151407793' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406093'
                WHERE ordernumber = 'P180807151443448' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406094'
                WHERE ordernumber = 'P190807151555645' 
            
2024-08-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391769'
                WHERE ordernumber = 'P180807151643143' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '154291'
                WHERE ordernumber = 'P630807152314471' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406098'
                WHERE ordernumber = 'P180807153145822' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406099'
                WHERE ordernumber = 'P200807153225263' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381145'
                WHERE ordernumber = 'P420807153232668' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100928'
                WHERE ordernumber = 'P200807154013752' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406102'
                WHERE ordernumber = 'P200807154212180' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118479'
                WHERE ordernumber = 'P180807154246218' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406105'
                WHERE ordernumber = 'P200807154354624' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406106'
                WHERE ordernumber = 'P200807154429340' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303145'
                WHERE ordernumber = 'P200807154546760' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406107'
                WHERE ordernumber = 'P180807154549316' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406102'
                WHERE ordernumber = 'P200807154736578' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406108'
                WHERE ordernumber = 'P200807154951318' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97583'
                WHERE ordernumber = 'P630807155110175' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406109'
                WHERE ordernumber = 'P200807155136189' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226896'
                WHERE ordernumber = 'P200807155224895' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219667'
                WHERE ordernumber = 'P200807155313711' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319423'
                WHERE ordernumber = 'P200807155714508' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288772'
                WHERE ordernumber = 'P190807160319777' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406114'
                WHERE ordernumber = 'P200807160635521' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406113'
                WHERE ordernumber = 'P180807160638375' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395709'
                WHERE ordernumber = 'P420807160731319' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284827'
                WHERE ordernumber = 'P180807161303909' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337398'
                WHERE ordernumber = 'P180807161635632' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310383'
                WHERE ordernumber = 'P420807161721970' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406118'
                WHERE ordernumber = 'P180807162357573' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '120173'
                WHERE ordernumber = 'P180807162726399' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406122'
                WHERE ordernumber = 'P200807163400400' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406123'
                WHERE ordernumber = 'P200807163443422' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348437'
                WHERE ordernumber = 'P180807163515314' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '106897'
                WHERE ordernumber = 'P180807163609887' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406124'
                WHERE ordernumber = 'P180807163725267' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395831'
                WHERE ordernumber = 'P420807164348811' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '111709'
                WHERE ordernumber = 'P180807164452350' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377568'
                WHERE ordernumber = 'P180807164609437' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285449'
                WHERE ordernumber = 'P200807164634877' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234274'
                WHERE ordernumber = 'P180807164645335' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295485'
                WHERE ordernumber = 'P200807164720178' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406126'
                WHERE ordernumber = 'P180807164856388' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406128'
                WHERE ordernumber = 'P200807164901473' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285902'
                WHERE ordernumber = 'P200807164932671' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '87785'
                WHERE ordernumber = 'P200807165005513' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406130'
                WHERE ordernumber = 'P420807165204416' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406131'
                WHERE ordernumber = 'P420807165344240' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393465'
                WHERE ordernumber = 'P180807165423989' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406132'
                WHERE ordernumber = 'P200807165700362' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279371'
                WHERE ordernumber = 'P180807165854923' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270643'
                WHERE ordernumber = 'P200807170311150' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116255'
                WHERE ordernumber = 'P420807170414227' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406135'
                WHERE ordernumber = 'P200807170447847' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '326762'
                WHERE ordernumber = 'P180807170619238' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406138'
                WHERE ordernumber = 'P190807170953929' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406140'
                WHERE ordernumber = 'P180807171200991' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399943'
                WHERE ordernumber = 'P180807171315617' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406141'
                WHERE ordernumber = 'P200807171814145' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406141'
                WHERE ordernumber = 'P200807171939243' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406144'
                WHERE ordernumber = 'P200807172351703' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '243770'
                WHERE ordernumber = 'P180807172414667' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '114432'
                WHERE ordernumber = 'P180807172532519' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406130'
                WHERE ordernumber = 'P420807172740199' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406145'
                WHERE ordernumber = 'P420807172938785' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406146'
                WHERE ordernumber = 'P180807173317494' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305825'
                WHERE ordernumber = 'P180807173658330' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406149'
                WHERE ordernumber = 'P200807173858748' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406148'
                WHERE ordernumber = 'P420807173935737' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404501'
                WHERE ordernumber = 'P200807174034299' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406150'
                WHERE ordernumber = 'P420807174047617' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406151'
                WHERE ordernumber = 'P200807174248256' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '308363'
                WHERE ordernumber = 'P180807174719356' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406154'
                WHERE ordernumber = 'P180807174919355' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406156'
                WHERE ordernumber = 'P200807175044412' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364038'
                WHERE ordernumber = 'P180807175206273' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227031'
                WHERE ordernumber = 'P190807175319461' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219754'
                WHERE ordernumber = 'P190807175452766' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406158'
                WHERE ordernumber = 'P420807175546561' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368215'
                WHERE ordernumber = 'P420807175620574' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319139'
                WHERE ordernumber = 'P190807175623462' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102337'
                WHERE ordernumber = 'P180807175645748' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368215'
                WHERE ordernumber = 'P420807175658879' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406160'
                WHERE ordernumber = 'P420807175932470' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406161'
                WHERE ordernumber = 'P180807180013151' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348622'
                WHERE ordernumber = 'P190807180025865' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86387'
                WHERE ordernumber = 'P420807180108276' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406162'
                WHERE ordernumber = 'P180807180217672' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347901'
                WHERE ordernumber = 'P180807181007919' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P420807181334782' 
            
2024-08-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406164'
                WHERE ordernumber = 'P180807181706471' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406165'
                WHERE ordernumber = 'P180807181806955' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406166'
                WHERE ordernumber = 'P420807181836451' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180807181839121' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '208509'
                WHERE ordernumber = 'P190807181904644' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406167'
                WHERE ordernumber = 'P180807182010667' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '227278'
                WHERE ordernumber = 'P180807182202967' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406169'
                WHERE ordernumber = 'P200807182203824' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '394397'
                WHERE ordernumber = 'P200807182333780' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406172'
                WHERE ordernumber = 'P420807182950620' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406173'
                WHERE ordernumber = 'P420807183113697' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '103594'
                WHERE ordernumber = 'P180807183212955' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '377388'
                WHERE ordernumber = 'P200807183308466' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '334128'
                WHERE ordernumber = 'P180807183320479' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406176'
                WHERE ordernumber = 'P420807183553752' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406177'
                WHERE ordernumber = 'P200807183826742' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '319135'
                WHERE ordernumber = 'P420807184307777' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403382'
                WHERE ordernumber = 'P180807184536428' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406181'
                WHERE ordernumber = 'P200807184705378' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405914'
                WHERE ordernumber = 'P180807184838264' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406183'
                WHERE ordernumber = 'P420807184935344' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '368618'
                WHERE ordernumber = 'P420807185212384' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406185'
                WHERE ordernumber = 'P190807185437415' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406186'
                WHERE ordernumber = 'P420807185542239' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406188'
                WHERE ordernumber = 'P190807185923161' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406189'
                WHERE ordernumber = 'P420807185949936' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '279954'
                WHERE ordernumber = 'P630807190011584' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406190'
                WHERE ordernumber = 'P200807190018537' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406191'
                WHERE ordernumber = 'P190807190042727' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '231862'
                WHERE ordernumber = 'P190807190555289' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406193'
                WHERE ordernumber = 'P200807190846401' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406194'
                WHERE ordernumber = 'P190807191219130' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406196'
                WHERE ordernumber = 'P200807191402716' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '376070'
                WHERE ordernumber = 'P190807192526491' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '66372'
                WHERE ordernumber = 'P200807192544974' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '307513'
                WHERE ordernumber = 'P200807192643331' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406199'
                WHERE ordernumber = 'P200807192846395' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405937'
                WHERE ordernumber = 'P190807192922284' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406200'
                WHERE ordernumber = 'P200807193106191' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '217677'
                WHERE ordernumber = 'P200807193608977' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '96948'
                WHERE ordernumber = 'P190807194006386' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '159824'
                WHERE ordernumber = 'P190807195202145' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '114408'
                WHERE ordernumber = 'P190807195900900' 
            
2024-08-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '160964'
                WHERE ordernumber = 'P190807195952485'