2023-12-04 01:00:02 -- 將會員中心id寫入data-lake
2023-12-04 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-03%';
        
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350514'
                WHERE ordernumber = 'P421203103541182' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250647'
                WHERE ordernumber = 'P421203105451860' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350515'
                WHERE ordernumber = 'P421203105719717' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283437'
                WHERE ordernumber = 'P181203110240632' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350516'
                WHERE ordernumber = 'P191203110434509' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271522'
                WHERE ordernumber = 'P201203110450812' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252804'
                WHERE ordernumber = 'P191203110629539' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341412'
                WHERE ordernumber = 'P201203111926375' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246602'
                WHERE ordernumber = 'P201203112157754' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341412'
                WHERE ordernumber = 'P201203112428239' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '327990'
                WHERE ordernumber = 'P191203112450539' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345044'
                WHERE ordernumber = 'P191203112651891' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349486'
                WHERE ordernumber = 'P421203112707402' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350517'
                WHERE ordernumber = 'P181203112726896' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274518'
                WHERE ordernumber = 'P201203112813721' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350518'
                WHERE ordernumber = 'P191203113023468' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329550'
                WHERE ordernumber = 'P201203113026744' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139196'
                WHERE ordernumber = 'P181203113143162' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350519'
                WHERE ordernumber = 'P421203113258217' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350520'
                WHERE ordernumber = 'P191203113353210' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350521'
                WHERE ordernumber = 'P181203113400548' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96014'
                WHERE ordernumber = 'P181203114343774' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129873'
                WHERE ordernumber = 'P181203114533569' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350523'
                WHERE ordernumber = 'P191203114730949' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350524'
                WHERE ordernumber = 'P181203114931610' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350525'
                WHERE ordernumber = 'P191203115039929' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307608'
                WHERE ordernumber = 'P181203115108763' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249589'
                WHERE ordernumber = 'P421203115350219' 
            
2023-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350526'
                WHERE ordernumber = 'P181203115437342' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328624'
                WHERE ordernumber = 'P181203115528881' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340347'
                WHERE ordernumber = 'P201203115558860' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350528'
                WHERE ordernumber = 'P181203115628114' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350527'
                WHERE ordernumber = 'P201203115704751' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350529'
                WHERE ordernumber = 'P201203115809791' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228204'
                WHERE ordernumber = 'P181203120026599' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267420'
                WHERE ordernumber = 'P201203120041223' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350532'
                WHERE ordernumber = 'P181203120225758' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350531'
                WHERE ordernumber = 'P201203120237793' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84930'
                WHERE ordernumber = 'P201203120522969' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242835'
                WHERE ordernumber = 'P201203121246156' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350533'
                WHERE ordernumber = 'P181203121445999' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350534'
                WHERE ordernumber = 'P181203122007378' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286167'
                WHERE ordernumber = 'P181203122654281' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350536'
                WHERE ordernumber = 'P191203122924169' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350537'
                WHERE ordernumber = 'P181203122946958' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99430'
                WHERE ordernumber = 'P191203123339399' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350538'
                WHERE ordernumber = 'P191203123527659' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350539'
                WHERE ordernumber = 'P421203124121703' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143604'
                WHERE ordernumber = 'P181203124503485' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350540'
                WHERE ordernumber = 'P181203124930176' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350541'
                WHERE ordernumber = 'P181203125049665' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344238'
                WHERE ordernumber = 'P421203125305649' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241480'
                WHERE ordernumber = 'P181203125421116' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350542'
                WHERE ordernumber = 'P201203125442445' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233738'
                WHERE ordernumber = 'P201203125537158' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242845'
                WHERE ordernumber = 'P181203125655884' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350543'
                WHERE ordernumber = 'P201203125931255' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300625'
                WHERE ordernumber = 'P181203130057419' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348746'
                WHERE ordernumber = 'P181203130533544' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350546'
                WHERE ordernumber = 'P421203130857580' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281059'
                WHERE ordernumber = 'P201203131329146' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350547'
                WHERE ordernumber = 'P181203131445970' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287211'
                WHERE ordernumber = 'P201203131745767' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289500'
                WHERE ordernumber = 'P181203131942829' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347254'
                WHERE ordernumber = 'P181203132440760' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350548'
                WHERE ordernumber = 'P181203132907227' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173682'
                WHERE ordernumber = 'P201203133155623' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173682'
                WHERE ordernumber = 'P201203133341804' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255938'
                WHERE ordernumber = 'P201203133531422' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350551'
                WHERE ordernumber = 'P181203133842812' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307000'
                WHERE ordernumber = 'P181203134932330' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350554'
                WHERE ordernumber = 'P201203135028641' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350555'
                WHERE ordernumber = 'P181203135236983' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347683'
                WHERE ordernumber = 'P181203135346122' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347683'
                WHERE ordernumber = 'P181203135418449' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350556'
                WHERE ordernumber = 'P421203140134755' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350557'
                WHERE ordernumber = 'P191203140313641' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350558'
                WHERE ordernumber = 'P181203140334669' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350559'
                WHERE ordernumber = 'P201203140952557' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '8677'
                WHERE ordernumber = 'P181203141117350' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307328'
                WHERE ordernumber = 'P201203141559480' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340267'
                WHERE ordernumber = 'P181203141640759' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224338'
                WHERE ordernumber = 'P181203142013680' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350560'
                WHERE ordernumber = 'P181203142759988' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333555'
                WHERE ordernumber = 'P201203142800831' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350561'
                WHERE ordernumber = 'P201203143042823' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350562'
                WHERE ordernumber = 'P191203143500666' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158668'
                WHERE ordernumber = 'P181203143501955' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318047'
                WHERE ordernumber = 'P181203144028877' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104860'
                WHERE ordernumber = 'P191203144109486' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318047'
                WHERE ordernumber = 'P181203144231896' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350563'
                WHERE ordernumber = 'P181203144415945' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236810'
                WHERE ordernumber = 'P201203144840477' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350565'
                WHERE ordernumber = 'P181203144935390' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350566'
                WHERE ordernumber = 'P181203145332181' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124593'
                WHERE ordernumber = 'P201203145358119' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350567'
                WHERE ordernumber = 'P181203145616263' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350568'
                WHERE ordernumber = 'P191203145858662' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153663'
                WHERE ordernumber = 'P191203150009265' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350570'
                WHERE ordernumber = 'P181203150433390' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350569'
                WHERE ordernumber = 'P421203150510432' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111386'
                WHERE ordernumber = 'P181203150731896' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340943'
                WHERE ordernumber = 'P421203150827118' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350572'
                WHERE ordernumber = 'P181203150934658' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104299'
                WHERE ordernumber = 'P181203151033704' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P201203151117975' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350574'
                WHERE ordernumber = 'P181203151232680' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350575'
                WHERE ordernumber = 'P421203151355950' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350577'
                WHERE ordernumber = 'P191203151727958' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293470'
                WHERE ordernumber = 'P191203151818251' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350578'
                WHERE ordernumber = 'P181203152023960' 
            
2023-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350579'
                WHERE ordernumber = 'P181203152329275' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323241'
                WHERE ordernumber = 'P421203152347548' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350564'
                WHERE ordernumber = 'P201203153028128' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350581'
                WHERE ordernumber = 'P181203153117755' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303495'
                WHERE ordernumber = 'P201203153143319' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266755'
                WHERE ordernumber = 'P201203153410552' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350582'
                WHERE ordernumber = 'P201203153918840' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350583'
                WHERE ordernumber = 'P201203154148360' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350584'
                WHERE ordernumber = 'P181203154413447' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238800'
                WHERE ordernumber = 'P181203154644398' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350585'
                WHERE ordernumber = 'P181203154957751' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223171'
                WHERE ordernumber = 'P191203155210688' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350586'
                WHERE ordernumber = 'P181203155244441' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263078'
                WHERE ordernumber = 'P191203155351308' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344164'
                WHERE ordernumber = 'P181203155555968' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344164'
                WHERE ordernumber = 'P181203155649169' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350587'
                WHERE ordernumber = 'P191203155706380' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350589'
                WHERE ordernumber = 'P181203155941397' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350590'
                WHERE ordernumber = 'P421203160336719' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350591'
                WHERE ordernumber = 'P181203160418938' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350588'
                WHERE ordernumber = 'P181203160633457' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350588'
                WHERE ordernumber = 'P181203160653698' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248174'
                WHERE ordernumber = 'P191203160731534' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350593'
                WHERE ordernumber = 'P181203160832686' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350594'
                WHERE ordernumber = 'P191203161012611' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350594'
                WHERE ordernumber = 'P191203161042324' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301778'
                WHERE ordernumber = 'P201203161341259' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350596'
                WHERE ordernumber = 'P181203161533733' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337669'
                WHERE ordernumber = 'P191203161600506' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350597'
                WHERE ordernumber = 'P181203161647417' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330152'
                WHERE ordernumber = 'P191203161752809' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350599'
                WHERE ordernumber = 'P191203162022327' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99048'
                WHERE ordernumber = 'P421203162822802' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120528'
                WHERE ordernumber = 'P181203162914305' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350604'
                WHERE ordernumber = 'P191203163008464' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349004'
                WHERE ordernumber = 'P181203163048567' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350605'
                WHERE ordernumber = 'P191203163120146' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350606'
                WHERE ordernumber = 'P191203163230492' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350607'
                WHERE ordernumber = 'P181203163309786' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350609'
                WHERE ordernumber = 'P191203163327486' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350611'
                WHERE ordernumber = 'P181203163500418' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350610'
                WHERE ordernumber = 'P421203163526224' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344744'
                WHERE ordernumber = 'P431203163527158' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257348'
                WHERE ordernumber = 'P191203163603628' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350611'
                WHERE ordernumber = 'P181203163655775' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350601'
                WHERE ordernumber = 'P431203163915468' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350614'
                WHERE ordernumber = 'P181203164008111' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213209'
                WHERE ordernumber = 'P191203164012370' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350615'
                WHERE ordernumber = 'P421203164042848' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350601'
                WHERE ordernumber = 'P431203164107937' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350616'
                WHERE ordernumber = 'P191203164429945' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350617'
                WHERE ordernumber = 'P181203164614532' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350619'
                WHERE ordernumber = 'P181203164822135' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350620'
                WHERE ordernumber = 'P181203165009294' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350624'
                WHERE ordernumber = 'P181203165904837' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297228'
                WHERE ordernumber = 'P421203170209527' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345565'
                WHERE ordernumber = 'P421203170409968' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293690'
                WHERE ordernumber = 'P191203170546720' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350625'
                WHERE ordernumber = 'P191203170644153' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225720'
                WHERE ordernumber = 'P201203170723424' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225720'
                WHERE ordernumber = 'P201203170756790' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310432'
                WHERE ordernumber = 'P431203170818466' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343632'
                WHERE ordernumber = 'P421203170819713' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350520'
                WHERE ordernumber = 'P191203170900143' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350627'
                WHERE ordernumber = 'P201203170911533' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350630'
                WHERE ordernumber = 'P191203171324567' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166292'
                WHERE ordernumber = 'P191203171416764' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350632'
                WHERE ordernumber = 'P421203171512885' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104586'
                WHERE ordernumber = 'P201203171726179' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350633'
                WHERE ordernumber = 'P421203172343823' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350634'
                WHERE ordernumber = 'P181203172518299' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350635'
                WHERE ordernumber = 'P181203172628730' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310580'
                WHERE ordernumber = 'P181203172812280' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350636'
                WHERE ordernumber = 'P181203172943807' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350636'
                WHERE ordernumber = 'P181203173043678' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87190'
                WHERE ordernumber = 'P201203173252222' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305059'
                WHERE ordernumber = 'P421203173624680' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350638'
                WHERE ordernumber = 'P201203173834741' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247581'
                WHERE ordernumber = 'P191203174758790' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247581'
                WHERE ordernumber = 'P191203174841283' 
            
2023-12-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350642'
                WHERE ordernumber = 'P191203175451706' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350643'
                WHERE ordernumber = 'P191203175811196' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350645'
                WHERE ordernumber = 'P191203175953619' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350645'
                WHERE ordernumber = 'P191203180209503' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270284'
                WHERE ordernumber = 'P201203180824197' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350647'
                WHERE ordernumber = 'P181203180913408' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229602'
                WHERE ordernumber = 'P181203181239800' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229602'
                WHERE ordernumber = 'P181203181732861' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121743'
                WHERE ordernumber = 'P181203182056959' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350648'
                WHERE ordernumber = 'P201203182430776' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302977'
                WHERE ordernumber = 'P181203182643918' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350652'
                WHERE ordernumber = 'P191203183740948' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350652'
                WHERE ordernumber = 'P191203183837462' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '87257'
                WHERE ordernumber = 'P191203184415734' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350653'
                WHERE ordernumber = 'P201203184615587' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350655'
                WHERE ordernumber = 'P191203190614487' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '244286'
                WHERE ordernumber = 'P421203190618552' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350656'
                WHERE ordernumber = 'P201203190640551' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239677'
                WHERE ordernumber = 'P191203190808256' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239677'
                WHERE ordernumber = 'P191203190911160' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350655'
                WHERE ordernumber = 'P191203191230362' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350660'
                WHERE ordernumber = 'P421203192310269' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220444'
                WHERE ordernumber = 'P191203192338849' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346894'
                WHERE ordernumber = 'P201203192751737' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220444'
                WHERE ordernumber = 'P191203193257283' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98302'
                WHERE ordernumber = 'P201203193348161' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116377'
                WHERE ordernumber = 'P201203194411861' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350667'
                WHERE ordernumber = 'P191203195055394' 
            
2023-12-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266076'
                WHERE ordernumber = 'P201203195657976'