2024-03-21 01:00:02 -- 將會員中心id寫入data-lake
2024-03-21 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-03-20%';
        
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162606'
                WHERE ordernumber = 'P190320110401325' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200320110402615' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378158'
                WHERE ordernumber = 'P180320110709980' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217639'
                WHERE ordernumber = 'P190320110829418' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P420320110945204' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101861'
                WHERE ordernumber = 'P190320111001545' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288489'
                WHERE ordernumber = 'P200320111057764' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382267'
                WHERE ordernumber = 'P200320111405793' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343868'
                WHERE ordernumber = 'P420320111509235' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81599'
                WHERE ordernumber = 'P190320111544204' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285340'
                WHERE ordernumber = 'P190320112011353' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377631'
                WHERE ordernumber = 'P190320112252162' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314983'
                WHERE ordernumber = 'P190320112342956' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P420320112355433' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378484'
                WHERE ordernumber = 'P190320112446714' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382271'
                WHERE ordernumber = 'P420320112934492' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '88949'
                WHERE ordernumber = 'P200320113534794' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '25556'
                WHERE ordernumber = 'P190320113649455' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338947'
                WHERE ordernumber = 'P420320113730790' 
            
2024-03-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382273'
                WHERE ordernumber = 'P200320114116313' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382275'
                WHERE ordernumber = 'P190320114341564' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313349'
                WHERE ordernumber = 'P190320114435171' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309074'
                WHERE ordernumber = 'P190320114602833' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264502'
                WHERE ordernumber = 'P190320115423230' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382277'
                WHERE ordernumber = 'P190320115653251' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113138'
                WHERE ordernumber = 'P180320120106565' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105863'
                WHERE ordernumber = 'P200320120459758' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222164'
                WHERE ordernumber = 'P190320120859326' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382278'
                WHERE ordernumber = 'P190320121144683' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344591'
                WHERE ordernumber = 'P200320121333668' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382279'
                WHERE ordernumber = 'P420320121559757' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109223'
                WHERE ordernumber = 'P190320121626683' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109223'
                WHERE ordernumber = 'P190320121801823' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345880'
                WHERE ordernumber = 'P420320122158669' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382280'
                WHERE ordernumber = 'P420320122431344' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337166'
                WHERE ordernumber = 'P420320122645189' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337166'
                WHERE ordernumber = 'P420320122727781' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238127'
                WHERE ordernumber = 'P200320123022510' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382282'
                WHERE ordernumber = 'P420320123024556' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382283'
                WHERE ordernumber = 'P190320123130512' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285644'
                WHERE ordernumber = 'P200320123218971' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352563'
                WHERE ordernumber = 'P200320123533180' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240968'
                WHERE ordernumber = 'P200320124034834' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P190320124716233' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382285'
                WHERE ordernumber = 'P420320124718720' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270891'
                WHERE ordernumber = 'P190320124840442' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142903'
                WHERE ordernumber = 'P420320125214697' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342820'
                WHERE ordernumber = 'P200320130516259' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308086'
                WHERE ordernumber = 'P420320130922931' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382288'
                WHERE ordernumber = 'P420320131143579' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382289'
                WHERE ordernumber = 'P420320131247597' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96489'
                WHERE ordernumber = 'P420320131755804' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379114'
                WHERE ordernumber = 'P190320132148577' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360048'
                WHERE ordernumber = 'P190320132643736' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63111'
                WHERE ordernumber = 'P200320132836572' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190320132942763' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358738'
                WHERE ordernumber = 'P190320133131562' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300801'
                WHERE ordernumber = 'P420320133317959' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382293'
                WHERE ordernumber = 'P190320134057303' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380161'
                WHERE ordernumber = 'P420320134256725' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382294'
                WHERE ordernumber = 'P190320134621447' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111306'
                WHERE ordernumber = 'P190320134840790' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382296'
                WHERE ordernumber = 'P190320135022392' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382295'
                WHERE ordernumber = 'P200320135042664' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382297'
                WHERE ordernumber = 'P190320135156229' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103922'
                WHERE ordernumber = 'P190320135531707' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354017'
                WHERE ordernumber = 'P420320135710641' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382298'
                WHERE ordernumber = 'P190320135726214' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382302'
                WHERE ordernumber = 'P190320141814869' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382303'
                WHERE ordernumber = 'P200320141851892' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382304'
                WHERE ordernumber = 'P190320142106830' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382306'
                WHERE ordernumber = 'P190320143149820' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67370'
                WHERE ordernumber = 'P200320143155317' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115196'
                WHERE ordernumber = 'P190320143323874' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382307'
                WHERE ordernumber = 'P190320143645488' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382308'
                WHERE ordernumber = 'P420320143708728' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382309'
                WHERE ordernumber = 'P190320144018739' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257130'
                WHERE ordernumber = 'P190320144114632' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190320144527221' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381687'
                WHERE ordernumber = 'P200320144730408' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382311'
                WHERE ordernumber = 'P200320144846383' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79313'
                WHERE ordernumber = 'P420320144905879' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382314'
                WHERE ordernumber = 'P190320144934840' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382315'
                WHERE ordernumber = 'P190320145042539' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164948'
                WHERE ordernumber = 'P200320145126464' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167252'
                WHERE ordernumber = 'P190320145527712' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96900'
                WHERE ordernumber = 'P190320145815282' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220311'
                WHERE ordernumber = 'P190320150021970' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P200320150515337' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382317'
                WHERE ordernumber = 'P190320151050247' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382316'
                WHERE ordernumber = 'P190320151129952' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382318'
                WHERE ordernumber = 'P190320152241370' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382319'
                WHERE ordernumber = 'P200320152739838' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97952'
                WHERE ordernumber = 'P200320152805655' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248179'
                WHERE ordernumber = 'P190320153008140' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248179'
                WHERE ordernumber = 'P190320153012265' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382320'
                WHERE ordernumber = 'P200320153120849' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379106'
                WHERE ordernumber = 'P190320153255128' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365668'
                WHERE ordernumber = 'P420320153636579' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281650'
                WHERE ordernumber = 'P190320153647480' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379914'
                WHERE ordernumber = 'P200320153918247' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382321'
                WHERE ordernumber = 'P420320154453177' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382322'
                WHERE ordernumber = 'P590320154901463' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286085'
                WHERE ordernumber = 'P190320155003447' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345622'
                WHERE ordernumber = 'P200320155522211' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382325'
                WHERE ordernumber = 'P190320160321963' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '76607'
                WHERE ordernumber = 'P190320160412153' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225029'
                WHERE ordernumber = 'P200320161858421' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277513'
                WHERE ordernumber = 'P200320162023204' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382327'
                WHERE ordernumber = 'P420320162033765' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382328'
                WHERE ordernumber = 'P420320162209151' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82231'
                WHERE ordernumber = 'P200320162410346' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381312'
                WHERE ordernumber = 'P190320162419218' 
            
2024-03-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98582'
                WHERE ordernumber = 'P200320162442267' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382329'
                WHERE ordernumber = 'P420320162524808' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284064'
                WHERE ordernumber = 'P180320162624869' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352011'
                WHERE ordernumber = 'P180320162702414' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164029'
                WHERE ordernumber = 'P420320162702720' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282283'
                WHERE ordernumber = 'P200320162941864' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326371'
                WHERE ordernumber = 'P180320163204128' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382330'
                WHERE ordernumber = 'P200320163400174' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382331'
                WHERE ordernumber = 'P180320163411137' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334855'
                WHERE ordernumber = 'P420320163528868' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382333'
                WHERE ordernumber = 'P420320163707855' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381848'
                WHERE ordernumber = 'P180320163857806' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381848'
                WHERE ordernumber = 'P180320163914387' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382334'
                WHERE ordernumber = 'P190320164352736' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103010'
                WHERE ordernumber = 'P420320165011822' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339970'
                WHERE ordernumber = 'P420320165424727' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382335'
                WHERE ordernumber = 'P190320165446375' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382336'
                WHERE ordernumber = 'P180320165522266' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284361'
                WHERE ordernumber = 'P180320165751334' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381345'
                WHERE ordernumber = 'P180320165841176' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382337'
                WHERE ordernumber = 'P180320170012239' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299756'
                WHERE ordernumber = 'P190320171545796' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149224'
                WHERE ordernumber = 'P200320171902446' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149224'
                WHERE ordernumber = 'P200320172231282' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208599'
                WHERE ordernumber = 'P190320172440326' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357531'
                WHERE ordernumber = 'P200320172817201' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370532'
                WHERE ordernumber = 'P190320173052281' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382342'
                WHERE ordernumber = 'P200320173207495' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106772'
                WHERE ordernumber = 'P190320173238652' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382343'
                WHERE ordernumber = 'P200320173251652' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380990'
                WHERE ordernumber = 'P420320173401709' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239510'
                WHERE ordernumber = 'P200320174118354' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P200320174806926' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216932'
                WHERE ordernumber = 'P420320174934243' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382344'
                WHERE ordernumber = 'P190320174959884' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382274'
                WHERE ordernumber = 'P190320175158418' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382345'
                WHERE ordernumber = 'P190320175317431' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P420320175330950' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '49080'
                WHERE ordernumber = 'P190320175442629' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382346'
                WHERE ordernumber = 'P190320175829814' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382347'
                WHERE ordernumber = 'P180320175914842' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382348'
                WHERE ordernumber = 'P180320180208274' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238144'
                WHERE ordernumber = 'P190320180259983' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382350'
                WHERE ordernumber = 'P200320180443382' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275929'
                WHERE ordernumber = 'P200320180617976' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382346'
                WHERE ordernumber = 'P190320180725355' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283187'
                WHERE ordernumber = 'P190320180816338' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343260'
                WHERE ordernumber = 'P180320180830745' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379601'
                WHERE ordernumber = 'P200320180908280' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378896'
                WHERE ordernumber = 'P420320180915532' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382352'
                WHERE ordernumber = 'P420320181151345' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382353'
                WHERE ordernumber = 'P190320181206310' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358072'
                WHERE ordernumber = 'P590320181213502' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253995'
                WHERE ordernumber = 'P190320182058123' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120522'
                WHERE ordernumber = 'P420320182323952' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217668'
                WHERE ordernumber = 'P200320183206401' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378226'
                WHERE ordernumber = 'P200320183244147' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '191987'
                WHERE ordernumber = 'P190320183306695' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382183'
                WHERE ordernumber = 'P190320183524137' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382354'
                WHERE ordernumber = 'P590320183526974' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382356'
                WHERE ordernumber = 'P190320183802164' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317906'
                WHERE ordernumber = 'P190320184124208' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382357'
                WHERE ordernumber = 'P190320184323229' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382358'
                WHERE ordernumber = 'P590320184510755' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382359'
                WHERE ordernumber = 'P190320184524931' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382360'
                WHERE ordernumber = 'P190320184713666' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281382'
                WHERE ordernumber = 'P190320184838922' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334776'
                WHERE ordernumber = 'P420320184930207' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355375'
                WHERE ordernumber = 'P200320185101490' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165635'
                WHERE ordernumber = 'P190320185150217' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382361'
                WHERE ordernumber = 'P420320185220886' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382362'
                WHERE ordernumber = 'P190320185458565' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382362'
                WHERE ordernumber = 'P190320185529547' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382355'
                WHERE ordernumber = 'P590320185604872' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157215'
                WHERE ordernumber = 'P200320185630984' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379112'
                WHERE ordernumber = 'P420320185654561' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382363'
                WHERE ordernumber = 'P200320185909317' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228854'
                WHERE ordernumber = 'P190320185932714' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228854'
                WHERE ordernumber = 'P190320185950263' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157215'
                WHERE ordernumber = 'P200320190114259' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382365'
                WHERE ordernumber = 'P190320190212409' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382366'
                WHERE ordernumber = 'P190320190743794' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313451'
                WHERE ordernumber = 'P420320190926542' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '11032'
                WHERE ordernumber = 'P190320190933449' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382368'
                WHERE ordernumber = 'P190320191208840' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382369'
                WHERE ordernumber = 'P190320191324715' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128554'
                WHERE ordernumber = 'P590320191509898' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382370'
                WHERE ordernumber = 'P190320191524414' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249121'
                WHERE ordernumber = 'P190320192558613' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382371'
                WHERE ordernumber = 'P190320193137464' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149991'
                WHERE ordernumber = 'P200320193405490' 
            
2024-03-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329340'
                WHERE ordernumber = 'P200320194504964'