2023-12-15 01:00:03 -- 將會員中心id寫入data-lake
2023-12-15 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 '2023-12-14%';
        
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247577'
                WHERE ordernumber = 'P181214110225920' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352043'
                WHERE ordernumber = 'P181214110302426' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284673'
                WHERE ordernumber = 'P201214110358978' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319400'
                WHERE ordernumber = 'P181214110503281' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327225'
                WHERE ordernumber = 'P421214110556749' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243664'
                WHERE ordernumber = 'P201214110712982' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224216'
                WHERE ordernumber = 'P181214110724289' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352351'
                WHERE ordernumber = 'P421214110724308' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255814'
                WHERE ordernumber = 'P181214110836517' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243664'
                WHERE ordernumber = 'P201214110840206' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246022'
                WHERE ordernumber = 'P181214110920585' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352353'
                WHERE ordernumber = 'P201214110935859' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127752'
                WHERE ordernumber = 'P181214111045779' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341501'
                WHERE ordernumber = 'P191214111128687' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229245'
                WHERE ordernumber = 'P191214111229521' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352354'
                WHERE ordernumber = 'P191214111438555' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352355'
                WHERE ordernumber = 'P181214111553218' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352356'
                WHERE ordernumber = 'P181214111645700' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352357'
                WHERE ordernumber = 'P181214111814802' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352358'
                WHERE ordernumber = 'P181214112205456' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348622'
                WHERE ordernumber = 'P181214112352274' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268787'
                WHERE ordernumber = 'P201214112408898' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342792'
                WHERE ordernumber = 'P191214112455534' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214738'
                WHERE ordernumber = 'P181214112526551' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226347'
                WHERE ordernumber = 'P181214112647171' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110913'
                WHERE ordernumber = 'P201214113033846' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278076'
                WHERE ordernumber = 'P181214113242346' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237041'
                WHERE ordernumber = 'P201214113352810' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352361'
                WHERE ordernumber = 'P181214113502856' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352360'
                WHERE ordernumber = 'P201214113515247' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257909'
                WHERE ordernumber = 'P201214113914354' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257909'
                WHERE ordernumber = 'P201214113947963' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352364'
                WHERE ordernumber = 'P181214114136117' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352365'
                WHERE ordernumber = 'P181214114240253' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352363'
                WHERE ordernumber = 'P201214114410187' 
            
2023-12-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352367'
                WHERE ordernumber = 'P181214114509731' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81673'
                WHERE ordernumber = 'P181214115024253' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273033'
                WHERE ordernumber = 'P181214120006189' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352368'
                WHERE ordernumber = 'P421214120639929' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352368'
                WHERE ordernumber = 'P421214121137664' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352369'
                WHERE ordernumber = 'P181214121153123' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236131'
                WHERE ordernumber = 'P201214121338681' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352370'
                WHERE ordernumber = 'P181214121531869' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352371'
                WHERE ordernumber = 'P181214121641602' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89059'
                WHERE ordernumber = 'P201214121910502' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301938'
                WHERE ordernumber = 'P201214122010647' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313349'
                WHERE ordernumber = 'P181214122209600' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141288'
                WHERE ordernumber = 'P201214122215290' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181214122607248' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344376'
                WHERE ordernumber = 'P201214122951492' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159979'
                WHERE ordernumber = 'P201214123235897' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352377'
                WHERE ordernumber = 'P181214123648677' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352378'
                WHERE ordernumber = 'P181214124012411' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237644'
                WHERE ordernumber = 'P181214124104592' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289885'
                WHERE ordernumber = 'P181214124433399' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352380'
                WHERE ordernumber = 'P181214124645319' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281700'
                WHERE ordernumber = 'P201214124901850' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241124'
                WHERE ordernumber = 'P191214125152389' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352381'
                WHERE ordernumber = 'P201214125614866' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137756'
                WHERE ordernumber = 'P181214130114530' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352382'
                WHERE ordernumber = 'P421214130141862' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352383'
                WHERE ordernumber = 'P181214130427483' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129132'
                WHERE ordernumber = 'P181214130545239' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352384'
                WHERE ordernumber = 'P181214131104235' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212049'
                WHERE ordernumber = 'P181214131205888' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352385'
                WHERE ordernumber = 'P181214131547191' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81908'
                WHERE ordernumber = 'P181214133134740' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267557'
                WHERE ordernumber = 'P201214133301782' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248734'
                WHERE ordernumber = 'P421214133314584' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352386'
                WHERE ordernumber = 'P201214133611332' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352390'
                WHERE ordernumber = 'P181214134258233' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352391'
                WHERE ordernumber = 'P421214134555447' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348989'
                WHERE ordernumber = 'P181214134746504' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338423'
                WHERE ordernumber = 'P181214135058412' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97355'
                WHERE ordernumber = 'P201214135535432' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97441'
                WHERE ordernumber = 'P201214135638505' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245852'
                WHERE ordernumber = 'P201214135717890' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352394'
                WHERE ordernumber = 'P201214140022761' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163825'
                WHERE ordernumber = 'P181214140601707' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320337'
                WHERE ordernumber = 'P181214140714201' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163825'
                WHERE ordernumber = 'P181214140840764' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344148'
                WHERE ordernumber = 'P181214141029151' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352395'
                WHERE ordernumber = 'P201214141505589' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345923'
                WHERE ordernumber = 'P201214141730735' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125215'
                WHERE ordernumber = 'P201214143023161' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242581'
                WHERE ordernumber = 'P181214143320689' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242581'
                WHERE ordernumber = 'P181214143356633' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242581'
                WHERE ordernumber = 'P181214143501903' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318092'
                WHERE ordernumber = 'P421214144626760' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352397'
                WHERE ordernumber = 'P181214144902955' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338168'
                WHERE ordernumber = 'P181214144943590' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352398'
                WHERE ordernumber = 'P181214145133378' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352400'
                WHERE ordernumber = 'P181214145236843' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349239'
                WHERE ordernumber = 'P181214145410758' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352399'
                WHERE ordernumber = 'P201214145426836' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241983'
                WHERE ordernumber = 'P201214145648199' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352402'
                WHERE ordernumber = 'P181214145807863' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64670'
                WHERE ordernumber = 'P201214145910334' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288236'
                WHERE ordernumber = 'P201214150013640' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105100'
                WHERE ordernumber = 'P201214150057855' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338429'
                WHERE ordernumber = 'P421214150317529' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339803'
                WHERE ordernumber = 'P181214150408119' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275015'
                WHERE ordernumber = 'P421214151033205' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352404'
                WHERE ordernumber = 'P181214151509881' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352405'
                WHERE ordernumber = 'P181214151907822' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352406'
                WHERE ordernumber = 'P181214152041493' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352407'
                WHERE ordernumber = 'P181214152227507' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352408'
                WHERE ordernumber = 'P201214152833205' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336633'
                WHERE ordernumber = 'P201214152952800' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352410'
                WHERE ordernumber = 'P181214153114708' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352411'
                WHERE ordernumber = 'P201214153305485' 
            
2023-12-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352412'
                WHERE ordernumber = 'P181214153340544' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291851'
                WHERE ordernumber = 'P181214153745419' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313813'
                WHERE ordernumber = 'P201214153850585' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352415'
                WHERE ordernumber = 'P191214154421842' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249504'
                WHERE ordernumber = 'P181214154437654' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299631'
                WHERE ordernumber = 'P201214154551159' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352416'
                WHERE ordernumber = 'P191214154822405' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352417'
                WHERE ordernumber = 'P191214154943888' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352418'
                WHERE ordernumber = 'P181214155137375' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '336794'
                WHERE ordernumber = 'P421214155307268' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348932'
                WHERE ordernumber = 'P191214155856552' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319483'
                WHERE ordernumber = 'P421214160021183' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352419'
                WHERE ordernumber = 'P201214160530944' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293814'
                WHERE ordernumber = 'P201214160753832' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208567'
                WHERE ordernumber = 'P191214160839206' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352420'
                WHERE ordernumber = 'P181214161037896' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278859'
                WHERE ordernumber = 'P191214161045481' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352422'
                WHERE ordernumber = 'P201214161533519' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352423'
                WHERE ordernumber = 'P191214161554744' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352424'
                WHERE ordernumber = 'P181214162000710' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352425'
                WHERE ordernumber = 'P201214162027954' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101007'
                WHERE ordernumber = 'P201214162242483' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227610'
                WHERE ordernumber = 'P191214162419316' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352428'
                WHERE ordernumber = 'P181214162748202' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352429'
                WHERE ordernumber = 'P181214163142496' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352430'
                WHERE ordernumber = 'P181214163504360' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352431'
                WHERE ordernumber = 'P201214163507799' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226633'
                WHERE ordernumber = 'P181214164322204' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '135816'
                WHERE ordernumber = 'P201214164525814' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352132'
                WHERE ordernumber = 'P191214164533170' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352132'
                WHERE ordernumber = 'P191214164607714' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350894'
                WHERE ordernumber = 'P181214164644982' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '261238'
                WHERE ordernumber = 'P191214164814388' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '127781'
                WHERE ordernumber = 'P201214165356715' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283764'
                WHERE ordernumber = 'P181214165729946' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352393'
                WHERE ordernumber = 'P191214165809486' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100658'
                WHERE ordernumber = 'P201214165840628' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352393'
                WHERE ordernumber = 'P191214165853956' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303586'
                WHERE ordernumber = 'P181214165916947' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352438'
                WHERE ordernumber = 'P421214165944553' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93887'
                WHERE ordernumber = 'P201214170104931' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352440'
                WHERE ordernumber = 'P201214170235600' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352442'
                WHERE ordernumber = 'P201214170422509' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96878'
                WHERE ordernumber = 'P201214170628316' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283811'
                WHERE ordernumber = 'P181214170738793' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245850'
                WHERE ordernumber = 'P201214170912514' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '265048'
                WHERE ordernumber = 'P181214170923585' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352443'
                WHERE ordernumber = 'P201214171136572' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284155'
                WHERE ordernumber = 'P201214171226217' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352445'
                WHERE ordernumber = 'P181214171357881' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352447'
                WHERE ordernumber = 'P191214171812878' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352451'
                WHERE ordernumber = 'P181214172538460' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352452'
                WHERE ordernumber = 'P181214172715259' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266483'
                WHERE ordernumber = 'P201214172827186' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352453'
                WHERE ordernumber = 'P181214172901652' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352454'
                WHERE ordernumber = 'P201214172944228' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352456'
                WHERE ordernumber = 'P191214173131226' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266483'
                WHERE ordernumber = 'P201214173225805' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100928'
                WHERE ordernumber = 'P201214173344447' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '142615'
                WHERE ordernumber = 'P201214173954646' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289735'
                WHERE ordernumber = 'P191214174117479' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352458'
                WHERE ordernumber = 'P201214175600664' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352459'
                WHERE ordernumber = 'P191214175606242' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352460'
                WHERE ordernumber = 'P201214175711447' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346492'
                WHERE ordernumber = 'P201214175930566' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221131'
                WHERE ordernumber = 'P191214180143443' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352460'
                WHERE ordernumber = 'P201214180322443' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352462'
                WHERE ordernumber = 'P181214181233716' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352463'
                WHERE ordernumber = 'P181214181409443' 
            
2023-12-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248969'
                WHERE ordernumber = 'P201214181938667' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '238263'
                WHERE ordernumber = 'P181214181948519' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '121440'
                WHERE ordernumber = 'P181214182129627' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '217777'
                WHERE ordernumber = 'P181214182233203' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '96570'
                WHERE ordernumber = 'P201214182552707' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352467'
                WHERE ordernumber = 'P181214182934214' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352468'
                WHERE ordernumber = 'P191214183026557' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352469'
                WHERE ordernumber = 'P201214183834798' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352471'
                WHERE ordernumber = 'P201214184422174' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352472'
                WHERE ordernumber = 'P201214184558783' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352473'
                WHERE ordernumber = 'P421214184830458' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352474'
                WHERE ordernumber = 'P201214184958884' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '242434'
                WHERE ordernumber = 'P201214185217224' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352475'
                WHERE ordernumber = 'P201214185555180' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352476'
                WHERE ordernumber = 'P181214185709747' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352477'
                WHERE ordernumber = 'P201214190539860' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '41701'
                WHERE ordernumber = 'P191214190633381' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352480'
                WHERE ordernumber = 'P191214190732749' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352481'
                WHERE ordernumber = 'P191214190826869' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '167388'
                WHERE ordernumber = 'P201214190859602' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352482'
                WHERE ordernumber = 'P201214191039338' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '234893'
                WHERE ordernumber = 'P201214191242462' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '144747'
                WHERE ordernumber = 'P191214191247765' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352479'
                WHERE ordernumber = 'P201214191335471' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352483'
                WHERE ordernumber = 'P191214191408590' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '304008'
                WHERE ordernumber = 'P201214192005310' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352487'
                WHERE ordernumber = 'P191214192411616' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352488'
                WHERE ordernumber = 'P201214192536737' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '225202'
                WHERE ordernumber = 'P191214192641304' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352489'
                WHERE ordernumber = 'P421214192642371' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '343090'
                WHERE ordernumber = 'P201214192734149' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352490'
                WHERE ordernumber = 'P191214192827843' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '120047'
                WHERE ordernumber = 'P191214192939135' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352492'
                WHERE ordernumber = 'P191214193148328' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '71505'
                WHERE ordernumber = 'P191214193348930' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '309425'
                WHERE ordernumber = 'P191214193447373' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '291899'
                WHERE ordernumber = 'P201214193845364' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '317327'
                WHERE ordernumber = 'P191214193945248' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352495'
                WHERE ordernumber = 'P201214194458218' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '249488'
                WHERE ordernumber = 'P191214194817230' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352496'
                WHERE ordernumber = 'P201214195046221' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '224174'
                WHERE ordernumber = 'P201214195743314' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '348119'
                WHERE ordernumber = 'P421214195955242' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352497'
                WHERE ordernumber = 'P191214200118972' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352497'
                WHERE ordernumber = 'P191214200146994' 
            
2023-12-15 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '352498'
                WHERE ordernumber = 'P201214200629347'