2024-12-12 01:00:02 -- 將會員中心id寫入data-lake
2024-12-12 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-12-11%';
        
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381567'
                WHERE ordernumber = 'P2412110000297' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434746'
                WHERE ordernumber = 'P2412110000374' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434720'
                WHERE ordernumber = 'P2412110000731' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271511'
                WHERE ordernumber = 'P2412110000878' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434720'
                WHERE ordernumber = 'P2412110001056' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434748'
                WHERE ordernumber = 'P2412110001171' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73995'
                WHERE ordernumber = 'P2412110001268' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P2412110001555' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434753'
                WHERE ordernumber = 'P2412110001733' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249564'
                WHERE ordernumber = 'P2412110001841' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '92525'
                WHERE ordernumber = 'P2412110002244' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434760'
                WHERE ordernumber = 'P2412110002333' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241940'
                WHERE ordernumber = 'P2412110002461' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '125856'
                WHERE ordernumber = 'P2412110002517' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300411'
                WHERE ordernumber = 'P2412110002797' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '92525'
                WHERE ordernumber = 'P2412110002848' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434081'
                WHERE ordernumber = 'P2412110002979' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434767'
                WHERE ordernumber = 'P2412110003077' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97423'
                WHERE ordernumber = 'P2412110003188' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285232'
                WHERE ordernumber = 'P2412110003465' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243657'
                WHERE ordernumber = 'P2412110003534' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254447'
                WHERE ordernumber = 'P2412110003730' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434772'
                WHERE ordernumber = 'P2412110003883' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305084'
                WHERE ordernumber = 'P2412110003927' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235841'
                WHERE ordernumber = 'P2412110004086' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422999'
                WHERE ordernumber = 'P2412110004241' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223476'
                WHERE ordernumber = 'P2412110004365' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257628'
                WHERE ordernumber = 'P2412110004443' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111574'
                WHERE ordernumber = 'P2412110004564' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336979'
                WHERE ordernumber = 'P2412110004830' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434781'
                WHERE ordernumber = 'P2412110004923' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395651'
                WHERE ordernumber = 'P2412110005067' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404069'
                WHERE ordernumber = 'P2412110005127' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434783'
                WHERE ordernumber = 'P2412110005244' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434787'
                WHERE ordernumber = 'P2412110005387' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434789'
                WHERE ordernumber = 'P2412110005456' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434785'
                WHERE ordernumber = 'P2412110005670' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345748'
                WHERE ordernumber = 'P2412110005988' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434791'
                WHERE ordernumber = 'P2412110006096' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374191'
                WHERE ordernumber = 'P2412110006357' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395831'
                WHERE ordernumber = 'P2412110006412' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434793'
                WHERE ordernumber = 'P2412110006514' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431865'
                WHERE ordernumber = 'P2412110006723' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434322'
                WHERE ordernumber = 'P2412110006819' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428599'
                WHERE ordernumber = 'P2412110006943' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290018'
                WHERE ordernumber = 'P2412110007336' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353754'
                WHERE ordernumber = 'P2412110007443' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367983'
                WHERE ordernumber = 'P2412110007662' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434797'
                WHERE ordernumber = 'P2412110007742' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426331'
                WHERE ordernumber = 'P2412110007810' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167816'
                WHERE ordernumber = 'P2412110008012' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287213'
                WHERE ordernumber = 'P2412110008136' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434801'
                WHERE ordernumber = 'P2412110008341' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434522'
                WHERE ordernumber = 'P2412110008437' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434802'
                WHERE ordernumber = 'P2412110008596' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309147'
                WHERE ordernumber = 'P2412110008793' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353333'
                WHERE ordernumber = 'P2412110008873' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212720'
                WHERE ordernumber = 'P2412110008961' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352408'
                WHERE ordernumber = 'P2412110009170' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396702'
                WHERE ordernumber = 'P2412110009288' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434805'
                WHERE ordernumber = 'P2412110009354' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434806'
                WHERE ordernumber = 'P2412110009491' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434810'
                WHERE ordernumber = 'P2412110009777' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337443'
                WHERE ordernumber = 'P2412110009892' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434811'
                WHERE ordernumber = 'P2412110009946' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407550'
                WHERE ordernumber = 'P2412110010079' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142462'
                WHERE ordernumber = 'P2412110010163' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434813'
                WHERE ordernumber = 'P2412110010310' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434815'
                WHERE ordernumber = 'P2412110010483' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359403'
                WHERE ordernumber = 'P2412110010685' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434791'
                WHERE ordernumber = 'P2412110010799' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246081'
                WHERE ordernumber = 'P2412110010880' 
            
2024-12-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246081'
                WHERE ordernumber = 'P2412110011183' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133478'
                WHERE ordernumber = 'P2412110011266' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207702'
                WHERE ordernumber = 'P2412110011393' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133478'
                WHERE ordernumber = 'P2412110011413' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391150'
                WHERE ordernumber = 'P2412110011688' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P2412110011762' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433833'
                WHERE ordernumber = 'P2412110011950' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261829'
                WHERE ordernumber = 'P2412110012015' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434820'
                WHERE ordernumber = 'P2412110012295' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65398'
                WHERE ordernumber = 'P2412110012354' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434821'
                WHERE ordernumber = 'P2412110012589' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '11231'
                WHERE ordernumber = 'P2412110012625' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111094'
                WHERE ordernumber = 'P2412110012856' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155220'
                WHERE ordernumber = 'P2412110012970' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155220'
                WHERE ordernumber = 'P2412110013118' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389739'
                WHERE ordernumber = 'P2412110013284' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256877'
                WHERE ordernumber = 'P2412110013325' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117329'
                WHERE ordernumber = 'P2412110013474' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434828'
                WHERE ordernumber = 'P2412110013698' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117329'
                WHERE ordernumber = 'P2412110013798' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434827'
                WHERE ordernumber = 'P2412110013951' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434830'
                WHERE ordernumber = 'P2412110014062' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117329'
                WHERE ordernumber = 'P2412110014136' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115971'
                WHERE ordernumber = 'P2412110014383' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434832'
                WHERE ordernumber = 'P2412110014752' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360809'
                WHERE ordernumber = 'P2412110014836' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434833'
                WHERE ordernumber = 'P2412110014929' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434835'
                WHERE ordernumber = 'P2412110015062' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P2412110015167' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434837'
                WHERE ordernumber = 'P2412110015353' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434837'
                WHERE ordernumber = 'P2412110015410' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433185'
                WHERE ordernumber = 'P2412110015546' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434310'
                WHERE ordernumber = 'P2412110016119' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434310'
                WHERE ordernumber = 'P2412110016215' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434310'
                WHERE ordernumber = 'P2412110016319' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430789'
                WHERE ordernumber = 'P2412110016526' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303132'
                WHERE ordernumber = 'P2412110016633' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434842'
                WHERE ordernumber = 'P2412110016761' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396038'
                WHERE ordernumber = 'P2412110016933' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81645'
                WHERE ordernumber = 'P2412110017080' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280983'
                WHERE ordernumber = 'P2412110017190' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411681'
                WHERE ordernumber = 'P2412110017237' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100515'
                WHERE ordernumber = 'P2412110017350' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434844'
                WHERE ordernumber = 'P2412110017466' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434846'
                WHERE ordernumber = 'P2412110017665' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '148024'
                WHERE ordernumber = 'P2412110017726' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383963'
                WHERE ordernumber = 'P2412110018152' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171098'
                WHERE ordernumber = 'P2412110018485' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397534'
                WHERE ordernumber = 'P2412110018590' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290408'
                WHERE ordernumber = 'P2412110018799' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432335'
                WHERE ordernumber = 'P2412110018958' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322480'
                WHERE ordernumber = 'P2412110019358' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245523'
                WHERE ordernumber = 'P2412110019428' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434621'
                WHERE ordernumber = 'P2412110019586' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '72830'
                WHERE ordernumber = 'P2412110019763' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434796'
                WHERE ordernumber = 'P2412110019818' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434855'
                WHERE ordernumber = 'P2412110019998' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434857'
                WHERE ordernumber = 'P2412110020280' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423906'
                WHERE ordernumber = 'P2412110020517' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400798'
                WHERE ordernumber = 'P2412110020851' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434858'
                WHERE ordernumber = 'P2412110021184' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '204136'
                WHERE ordernumber = 'P2412110021372' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434862'
                WHERE ordernumber = 'P2412110021636' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103922'
                WHERE ordernumber = 'P2412110021793' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267105'
                WHERE ordernumber = 'P2412110021852' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434491'
                WHERE ordernumber = 'P2412110022327' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434866'
                WHERE ordernumber = 'P2412110022447' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169204'
                WHERE ordernumber = 'P2412110022512' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434868'
                WHERE ordernumber = 'P2412110022826' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434872'
                WHERE ordernumber = 'P2412110023247' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381071'
                WHERE ordernumber = 'P2412110023385' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434563'
                WHERE ordernumber = 'P2412110023492' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313838'
                WHERE ordernumber = 'P2412110023515' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434763'
                WHERE ordernumber = 'P2412110023684' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434875'
                WHERE ordernumber = 'P2412110023859' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434600'
                WHERE ordernumber = 'P2412110023999' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382014'
                WHERE ordernumber = 'P2412110024032' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431292'
                WHERE ordernumber = 'P2412110024249' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434874'
                WHERE ordernumber = 'P2412110024650' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239481'
                WHERE ordernumber = 'P2412110024845' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434877'
                WHERE ordernumber = 'P2412110025158' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434879'
                WHERE ordernumber = 'P2412110025399' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430109'
                WHERE ordernumber = 'P2412110025521' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431849'
                WHERE ordernumber = 'P2412110025643' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430109'
                WHERE ordernumber = 'P2412110025778' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431849'
                WHERE ordernumber = 'P2412110025817' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430109'
                WHERE ordernumber = 'P2412110025953' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431889'
                WHERE ordernumber = 'P2412110026086' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434881'
                WHERE ordernumber = 'P2412110026172' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '61977'
                WHERE ordernumber = 'P2412110026265' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434883'
                WHERE ordernumber = 'P2412110026319' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434880'
                WHERE ordernumber = 'P2412110026429' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P2412110026591' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102961'
                WHERE ordernumber = 'P2412110026653' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102961'
                WHERE ordernumber = 'P2412110026756' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67948'
                WHERE ordernumber = 'P2412110026833' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405779'
                WHERE ordernumber = 'P2412110026942' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434884'
                WHERE ordernumber = 'P2412110027160' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397229'
                WHERE ordernumber = 'P2412110027224' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434887'
                WHERE ordernumber = 'P2412110027360' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397229'
                WHERE ordernumber = 'P2412110027481' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434888'
                WHERE ordernumber = 'P2412110027536' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428342'
                WHERE ordernumber = 'P2412110027639' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332698'
                WHERE ordernumber = 'P2412110027793' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103395'
                WHERE ordernumber = 'P2412110027840' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434890'
                WHERE ordernumber = 'P2412110028192' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378387'
                WHERE ordernumber = 'P2412110028343' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298155'
                WHERE ordernumber = 'P2412110028462' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422131'
                WHERE ordernumber = 'P2412110028586' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424939'
                WHERE ordernumber = 'P2412110028695' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299213'
                WHERE ordernumber = 'P2412110028878' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305672'
                WHERE ordernumber = 'P2412110028974' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434020'
                WHERE ordernumber = 'P2412110029099' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350416'
                WHERE ordernumber = 'P2412110029124' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434020'
                WHERE ordernumber = 'P2412110029285' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299213'
                WHERE ordernumber = 'P2412110029672' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434896'
                WHERE ordernumber = 'P2412110029799' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434897'
                WHERE ordernumber = 'P2412110029860' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295530'
                WHERE ordernumber = 'P2412110029929' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '179349'
                WHERE ordernumber = 'P2412110030192' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434901'
                WHERE ordernumber = 'P2412110030260' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302195'
                WHERE ordernumber = 'P2412110030386' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358304'
                WHERE ordernumber = 'P2412110030596' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405861'
                WHERE ordernumber = 'P2412110030623' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432844'
                WHERE ordernumber = 'P2412110030756' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430125'
                WHERE ordernumber = 'P2412110030858' 
            
2024-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434904'
                WHERE ordernumber = 'P2412110030959' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434905'
                WHERE ordernumber = 'P2412110031150' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426359'
                WHERE ordernumber = 'P2412110031344' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434910'
                WHERE ordernumber = 'P2412110031825' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434911'
                WHERE ordernumber = 'P2412110031999' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430987'
                WHERE ordernumber = 'P2412110032240' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278761'
                WHERE ordernumber = 'P2412110032373' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220678'
                WHERE ordernumber = 'P2412110032464' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434917'
                WHERE ordernumber = 'P2412110032612' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434917'
                WHERE ordernumber = 'P2412110032886' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434918'
                WHERE ordernumber = 'P2412110032925' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211877'
                WHERE ordernumber = 'P2412110033030' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434919'
                WHERE ordernumber = 'P2412110033172' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434920'
                WHERE ordernumber = 'P2412110033273' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234716'
                WHERE ordernumber = 'P2412110033456' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314574'
                WHERE ordernumber = 'P2412110033758' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434922'
                WHERE ordernumber = 'P2412110033839' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '32411'
                WHERE ordernumber = 'P2412110033949' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430180'
                WHERE ordernumber = 'P2412110034186' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430180'
                WHERE ordernumber = 'P2412110034250' 
            
2024-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434927'
                WHERE ordernumber = 'P2412110034337'