2024-12-14 01:00:01 -- 將會員中心id寫入data-lake
2024-12-14 01:00:01 -- 
            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-12-13%';
        
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '430417'
                WHERE ordernumber = 'P2412130000162' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '435280'
                WHERE ordernumber = 'P2412130000231' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '341009'
                WHERE ordernumber = 'P2412130000375' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '238978'
                WHERE ordernumber = 'P2412130000682' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '311333'
                WHERE ordernumber = 'P2412130000897' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '135689'
                WHERE ordernumber = 'P2412130000911' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '435281'
                WHERE ordernumber = 'P2412130001014' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '403285'
                WHERE ordernumber = 'P2412130001416' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '434773'
                WHERE ordernumber = 'P2412130002335' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '131886'
                WHERE ordernumber = 'P2412130002556' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '87107'
                WHERE ordernumber = 'P2412130002817' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '96086'
                WHERE ordernumber = 'P2412130003153' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '338630'
                WHERE ordernumber = 'P2412130003243' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '419560'
                WHERE ordernumber = 'P2412130003360' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '347822'
                WHERE ordernumber = 'P2412130003482' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '435294'
                WHERE ordernumber = 'P2412130003589' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '353947'
                WHERE ordernumber = 'P2412130003683' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '225010'
                WHERE ordernumber = 'P2412130003784' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '431023'
                WHERE ordernumber = 'P2412130003866' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '435297'
                WHERE ordernumber = 'P2412130004265' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '435299'
                WHERE ordernumber = 'P2412130004371' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '96536'
                WHERE ordernumber = 'P2412130004753' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '435302'
                WHERE ordernumber = 'P2412130004819' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '353461'
                WHERE ordernumber = 'P2412130005045' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '374702'
                WHERE ordernumber = 'P2412130005333' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '96536'
                WHERE ordernumber = 'P2412130005466' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '431780'
                WHERE ordernumber = 'P2412130005671' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '428919'
                WHERE ordernumber = 'P2412130005764' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '236018'
                WHERE ordernumber = 'P2412130005960' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '211100'
                WHERE ordernumber = 'P2412130006256' 
            
2024-12-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '157906'
                WHERE ordernumber = 'P2412130006342' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96536'
                WHERE ordernumber = 'P2412130006430' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96065'
                WHERE ordernumber = 'P2412130006636' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426515'
                WHERE ordernumber = 'P2412130006838' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434773'
                WHERE ordernumber = 'P2412130007821' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294471'
                WHERE ordernumber = 'P2412130007946' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428124'
                WHERE ordernumber = 'P2412130008185' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297678'
                WHERE ordernumber = 'P2412130008262' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133351'
                WHERE ordernumber = 'P2412130008469' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391719'
                WHERE ordernumber = 'P2412130008533' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408675'
                WHERE ordernumber = 'P2412130008628' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426593'
                WHERE ordernumber = 'P2412130008721' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213859'
                WHERE ordernumber = 'P2412130008856' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353974'
                WHERE ordernumber = 'P2412130009134' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '132169'
                WHERE ordernumber = 'P2412130009230' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435311'
                WHERE ordernumber = 'P2412130009354' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435312'
                WHERE ordernumber = 'P2412130009431' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426593'
                WHERE ordernumber = 'P2412130009518' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103853'
                WHERE ordernumber = 'P2412130009857' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416428'
                WHERE ordernumber = 'P2412130009963' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435316'
                WHERE ordernumber = 'P2412130010069' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435318'
                WHERE ordernumber = 'P2412130010318' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314449'
                WHERE ordernumber = 'P2412130010445' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435323'
                WHERE ordernumber = 'P2412130010565' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435322'
                WHERE ordernumber = 'P2412130010638' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435323'
                WHERE ordernumber = 'P2412130010868' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435322'
                WHERE ordernumber = 'P2412130010952' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415293'
                WHERE ordernumber = 'P2412130011040' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435319'
                WHERE ordernumber = 'P2412130011172' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435320'
                WHERE ordernumber = 'P2412130011422' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287227'
                WHERE ordernumber = 'P2412130011657' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435324'
                WHERE ordernumber = 'P2412130011749' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435327'
                WHERE ordernumber = 'P2412130011934' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435328'
                WHERE ordernumber = 'P2412130012078' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435318'
                WHERE ordernumber = 'P2412130012193' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435329'
                WHERE ordernumber = 'P2412130012349' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435325'
                WHERE ordernumber = 'P2412130012465' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435332'
                WHERE ordernumber = 'P2412130012588' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307227'
                WHERE ordernumber = 'P2412130012636' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435266'
                WHERE ordernumber = 'P2412130012835' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435337'
                WHERE ordernumber = 'P2412130013055' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435342'
                WHERE ordernumber = 'P2412130013398' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435343'
                WHERE ordernumber = 'P2412130013424' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435340'
                WHERE ordernumber = 'P2412130014062' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435345'
                WHERE ordernumber = 'P2412130014335' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424869'
                WHERE ordernumber = 'P2412130014412' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431877'
                WHERE ordernumber = 'P2412130014616' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435245'
                WHERE ordernumber = 'P2412130015060' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '120991'
                WHERE ordernumber = 'P2412130015181' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435347'
                WHERE ordernumber = 'P2412130016042' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435349'
                WHERE ordernumber = 'P2412130016140' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133478'
                WHERE ordernumber = 'P2412130016293' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435350'
                WHERE ordernumber = 'P2412130016573' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435348'
                WHERE ordernumber = 'P2412130016861' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435351'
                WHERE ordernumber = 'P2412130017149' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435352'
                WHERE ordernumber = 'P2412130017259' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435353'
                WHERE ordernumber = 'P2412130017561' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435356'
                WHERE ordernumber = 'P2412130017874' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435358'
                WHERE ordernumber = 'P2412130017920' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '135579'
                WHERE ordernumber = 'P2412130018018' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435359'
                WHERE ordernumber = 'P2412130018134' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435360'
                WHERE ordernumber = 'P2412130018275' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '292151'
                WHERE ordernumber = 'P2412130018346' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105447'
                WHERE ordernumber = 'P2412130018675' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100793'
                WHERE ordernumber = 'P2412130018762' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413955'
                WHERE ordernumber = 'P2412130018870' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433508'
                WHERE ordernumber = 'P2412130019074' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430062'
                WHERE ordernumber = 'P2412130019199' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '321136'
                WHERE ordernumber = 'P2412130019235' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251957'
                WHERE ordernumber = 'P2412130019430' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435363'
                WHERE ordernumber = 'P2412130019543' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '227178'
                WHERE ordernumber = 'P2412130019828' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387190'
                WHERE ordernumber = 'P2412130019976' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348868'
                WHERE ordernumber = 'P2412130020060' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428159'
                WHERE ordernumber = 'P2412130020127' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236840'
                WHERE ordernumber = 'P2412130020224' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387511'
                WHERE ordernumber = 'P2412130020414' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296804'
                WHERE ordernumber = 'P2412130020518' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429685'
                WHERE ordernumber = 'P2412130020662' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435367'
                WHERE ordernumber = 'P2412130020864' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112916'
                WHERE ordernumber = 'P2412130020971' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431884'
                WHERE ordernumber = 'P2412130021272' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369316'
                WHERE ordernumber = 'P2412130021462' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352635'
                WHERE ordernumber = 'P2412130021545' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432831'
                WHERE ordernumber = 'P2412130021627' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433040'
                WHERE ordernumber = 'P2412130021719' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435370'
                WHERE ordernumber = 'P2412130021898' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435371'
                WHERE ordernumber = 'P2412130022064' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208905'
                WHERE ordernumber = 'P2412130022229' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435372'
                WHERE ordernumber = 'P2412130022470' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128999'
                WHERE ordernumber = 'P2412130022533' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435374'
                WHERE ordernumber = 'P2412130022643' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359042'
                WHERE ordernumber = 'P2412130022767' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231433'
                WHERE ordernumber = 'P2412130022885' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P2412130022963' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429360'
                WHERE ordernumber = 'P2412130023037' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427507'
                WHERE ordernumber = 'P2412130023112' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435374'
                WHERE ordernumber = 'P2412130023318' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434309'
                WHERE ordernumber = 'P2412130023535' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270504'
                WHERE ordernumber = 'P2412130023642' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434309'
                WHERE ordernumber = 'P2412130023953' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270504'
                WHERE ordernumber = 'P2412130024030' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435380'
                WHERE ordernumber = 'P2412130024127' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97778'
                WHERE ordernumber = 'P2412130024224' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435386'
                WHERE ordernumber = 'P2412130024837' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212247'
                WHERE ordernumber = 'P2412130025143' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435383'
                WHERE ordernumber = 'P2412130025261' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435390'
                WHERE ordernumber = 'P2412130025383' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100493'
                WHERE ordernumber = 'P2412130025566' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '207236'
                WHERE ordernumber = 'P2412130025742' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435391'
                WHERE ordernumber = 'P2412130025832' 
            
2024-12-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353528'
                WHERE ordernumber = 'P2412130025952' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435392'
                WHERE ordernumber = 'P2412130026080' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419700'
                WHERE ordernumber = 'P2412130026588' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435393'
                WHERE ordernumber = 'P2412130026643' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435394'
                WHERE ordernumber = 'P2412130026872' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435398'
                WHERE ordernumber = 'P2412130027028' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435396'
                WHERE ordernumber = 'P2412130027269' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261147'
                WHERE ordernumber = 'P2412130027323' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433518'
                WHERE ordernumber = 'P2412130027691' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102976'
                WHERE ordernumber = 'P2412130027823' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435131'
                WHERE ordernumber = 'P2412130027952' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435402'
                WHERE ordernumber = 'P2412130028095' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435403'
                WHERE ordernumber = 'P2412130028164' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435405'
                WHERE ordernumber = 'P2412130028324' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224778'
                WHERE ordernumber = 'P2412130028531' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435406'
                WHERE ordernumber = 'P2412130028694' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340830'
                WHERE ordernumber = 'P2412130028797' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435408'
                WHERE ordernumber = 'P2412130028848' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434794'
                WHERE ordernumber = 'P2412130028980' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310246'
                WHERE ordernumber = 'P2412130029239' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435409'
                WHERE ordernumber = 'P2412130029464' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388164'
                WHERE ordernumber = 'P2412130029537' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430369'
                WHERE ordernumber = 'P2412130029696' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435411'
                WHERE ordernumber = 'P2412130029714' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161876'
                WHERE ordernumber = 'P2412130029836' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433251'
                WHERE ordernumber = 'P2412130030014' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433251'
                WHERE ordernumber = 'P2412130030144' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435419'
                WHERE ordernumber = 'P2412130030265' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435422'
                WHERE ordernumber = 'P2412130030324' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435418'
                WHERE ordernumber = 'P2412130030429' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435423'
                WHERE ordernumber = 'P2412130030717' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172'
                WHERE ordernumber = 'P2412130031019' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296352'
                WHERE ordernumber = 'P2412130031388' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81402'
                WHERE ordernumber = 'P2412130031433' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435426'
                WHERE ordernumber = 'P2412130031515' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435407'
                WHERE ordernumber = 'P2412130031776' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435407'
                WHERE ordernumber = 'P2412130031893' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281063'
                WHERE ordernumber = 'P2412130031992' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435339'
                WHERE ordernumber = 'P2412130032191' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173533'
                WHERE ordernumber = 'P2412130032883' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '1296'
                WHERE ordernumber = 'P2412130032971' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173533'
                WHERE ordernumber = 'P2412130033230' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435434'
                WHERE ordernumber = 'P2412130033356' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173533'
                WHERE ordernumber = 'P2412130033598' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173533'
                WHERE ordernumber = 'P2412130033710' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173533'
                WHERE ordernumber = 'P2412130033898' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239181'
                WHERE ordernumber = 'P2412130034011' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435437'
                WHERE ordernumber = 'P2412130034162' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298392'
                WHERE ordernumber = 'P2412130034242' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298392'
                WHERE ordernumber = 'P2412130034360' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435439'
                WHERE ordernumber = 'P2412130034858' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435442'
                WHERE ordernumber = 'P2412130035017' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435443'
                WHERE ordernumber = 'P2412130035181' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435444'
                WHERE ordernumber = 'P2412130035224' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435412'
                WHERE ordernumber = 'P2412130035359' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226971'
                WHERE ordernumber = 'P2412130035584' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435440'
                WHERE ordernumber = 'P2412130035627' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435447'
                WHERE ordernumber = 'P2412130035746' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432187'
                WHERE ordernumber = 'P2412130036223' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315247'
                WHERE ordernumber = 'P2412130036372' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '152613'
                WHERE ordernumber = 'P2412130036412' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300072'
                WHERE ordernumber = 'P2412130036599' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167129'
                WHERE ordernumber = 'P2412130036694' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315247'
                WHERE ordernumber = 'P2412130036749' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431210'
                WHERE ordernumber = 'P2412130036932' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435452'
                WHERE ordernumber = 'P2412130037116' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435448'
                WHERE ordernumber = 'P2412130037275' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '176708'
                WHERE ordernumber = 'P2412130037383' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435453'
                WHERE ordernumber = 'P2412130037440' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435455'
                WHERE ordernumber = 'P2412130037627' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435450'
                WHERE ordernumber = 'P2412130037790' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403797'
                WHERE ordernumber = 'P2412130037819' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396308'
                WHERE ordernumber = 'P2412130038286' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433656'
                WHERE ordernumber = 'P2412130038389' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218728'
                WHERE ordernumber = 'P2412130038447' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435458'
                WHERE ordernumber = 'P2412130038567' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435459'
                WHERE ordernumber = 'P2412130038635' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233074'
                WHERE ordernumber = 'P2412130038730' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435454'
                WHERE ordernumber = 'P2412130038932' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272784'
                WHERE ordernumber = 'P2412130039196' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276598'
                WHERE ordernumber = 'P2412130039758' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341933'
                WHERE ordernumber = 'P2412130039993' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141799'
                WHERE ordernumber = 'P2412130040663' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435469'
                WHERE ordernumber = 'P2412130041037' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435470'
                WHERE ordernumber = 'P2412130041228' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435472'
                WHERE ordernumber = 'P2412130041526' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424995'
                WHERE ordernumber = 'P2412130041696' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166831'
                WHERE ordernumber = 'P2412130041880' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351008'
                WHERE ordernumber = 'P2412130041985' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435473'
                WHERE ordernumber = 'P2412130042028' 
            
2024-12-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435474'
                WHERE ordernumber = 'P2412130042298'