2024-12-24 01:00:02 -- 將會員中心id寫入data-lake
2024-12-24 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-23%';
        
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418078'
                WHERE ordernumber = 'P2412230000014' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438407'
                WHERE ordernumber = 'P2412230000016' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423406'
                WHERE ordernumber = 'P2412230000017' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423406'
                WHERE ordernumber = 'P2412230000018' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438408'
                WHERE ordernumber = 'P2412230000019' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '3447'
                WHERE ordernumber = 'P2412230000020' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427245'
                WHERE ordernumber = 'P2412230000022' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438411'
                WHERE ordernumber = 'P2412230000024' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380797'
                WHERE ordernumber = 'P2412230000027' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250493'
                WHERE ordernumber = 'P2412230000031' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '207702'
                WHERE ordernumber = 'P2412230000032' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382066'
                WHERE ordernumber = 'P2412230000033' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434851'
                WHERE ordernumber = 'P2412230000040' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434851'
                WHERE ordernumber = 'P2412230000042' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434851'
                WHERE ordernumber = 'P2412230000045' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438420'
                WHERE ordernumber = 'P2412230000048' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271033'
                WHERE ordernumber = 'P2412230000051' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434746'
                WHERE ordernumber = 'P2412230000053' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438422'
                WHERE ordernumber = 'P2412230000054' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2412230000057' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438425'
                WHERE ordernumber = 'P2412230000060' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438428'
                WHERE ordernumber = 'P2412230000061' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438422'
                WHERE ordernumber = 'P2412230000065' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438423'
                WHERE ordernumber = 'P2412230000070' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438430'
                WHERE ordernumber = 'P2412230000074' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P2412230000078' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438431'
                WHERE ordernumber = 'P2412230000080' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386477'
                WHERE ordernumber = 'P2412230000084' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258236'
                WHERE ordernumber = 'P2412230000088' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258236'
                WHERE ordernumber = 'P2412230000089' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2412230000090' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94256'
                WHERE ordernumber = 'P2412230000098' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '165442'
                WHERE ordernumber = 'P2412230000100' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '165442'
                WHERE ordernumber = 'P2412230000106' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355081'
                WHERE ordernumber = 'P2412230000107' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335730'
                WHERE ordernumber = 'P2412230000109' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432841'
                WHERE ordernumber = 'P2412230000112' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438438'
                WHERE ordernumber = 'P2412230000130' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438440'
                WHERE ordernumber = 'P2412230000136' 
            
2024-12-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438445'
                WHERE ordernumber = 'P2412230000142' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438445'
                WHERE ordernumber = 'P2412230000145' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438444'
                WHERE ordernumber = 'P2412230000147' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438449'
                WHERE ordernumber = 'P2412230000149' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104624'
                WHERE ordernumber = 'P2412230000153' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416386'
                WHERE ordernumber = 'P2412230000154' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212021'
                WHERE ordernumber = 'P2412230000157' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351884'
                WHERE ordernumber = 'P2412230000158' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429811'
                WHERE ordernumber = 'P2412230000159' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300867'
                WHERE ordernumber = 'P2412230000162' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287062'
                WHERE ordernumber = 'P2412230000169' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234739'
                WHERE ordernumber = 'P2412230000170' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438450'
                WHERE ordernumber = 'P2412230000171' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103011'
                WHERE ordernumber = 'P2412230000172' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438450'
                WHERE ordernumber = 'P2412230000174' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438458'
                WHERE ordernumber = 'P2412230000178' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324062'
                WHERE ordernumber = 'P2412230000182' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82831'
                WHERE ordernumber = 'P2412230000184' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438462'
                WHERE ordernumber = 'P2412230000185' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '91426'
                WHERE ordernumber = 'P2412230000187' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297605'
                WHERE ordernumber = 'P2412230000190' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438466'
                WHERE ordernumber = 'P2412230000191' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390050'
                WHERE ordernumber = 'P2412230000208' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438471'
                WHERE ordernumber = 'P2412230000210' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427011'
                WHERE ordernumber = 'P2412230000212' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228852'
                WHERE ordernumber = 'P2412230000217' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438483'
                WHERE ordernumber = 'P2412230000222' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391082'
                WHERE ordernumber = 'P2412230000224' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98774'
                WHERE ordernumber = 'P2412230000229' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438486'
                WHERE ordernumber = 'P2412230000232' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384877'
                WHERE ordernumber = 'P2412230000233' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438487'
                WHERE ordernumber = 'P2412230000235' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383419'
                WHERE ordernumber = 'P2412230000238' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357006'
                WHERE ordernumber = 'P2412230000239' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438490'
                WHERE ordernumber = 'P2412230000242' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438491'
                WHERE ordernumber = 'P2412230000244' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P2412230000246' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433656'
                WHERE ordernumber = 'P2412230000250' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '7906'
                WHERE ordernumber = 'P2412230000253' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438495'
                WHERE ordernumber = 'P2412230000256' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265656'
                WHERE ordernumber = 'P2412230000257' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292393'
                WHERE ordernumber = 'P2412230000258' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438499'
                WHERE ordernumber = 'P2412230000259' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247197'
                WHERE ordernumber = 'P2412230000262' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289087'
                WHERE ordernumber = 'P2412230000265' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438507'
                WHERE ordernumber = 'P2412230000267' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438509'
                WHERE ordernumber = 'P2412230000269' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233874'
                WHERE ordernumber = 'P2412230000277' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438513'
                WHERE ordernumber = 'P2412230000278' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354444'
                WHERE ordernumber = 'P2412230000281' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438510'
                WHERE ordernumber = 'P2412230000282' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435999'
                WHERE ordernumber = 'P2412230000283' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438516'
                WHERE ordernumber = 'P2412230000284' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438521'
                WHERE ordernumber = 'P2412230000294' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '200795'
                WHERE ordernumber = 'P2412230000295' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438525'
                WHERE ordernumber = 'P2412230000301' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438526'
                WHERE ordernumber = 'P2412230000307' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400910'
                WHERE ordernumber = 'P2412230000309' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391919'
                WHERE ordernumber = 'P2412230000313' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438535'
                WHERE ordernumber = 'P2412230000315' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305084'
                WHERE ordernumber = 'P2412230000318' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '77058'
                WHERE ordernumber = 'P2412230000320' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262581'
                WHERE ordernumber = 'P2412230000322' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438541'
                WHERE ordernumber = 'P2412230000325' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437398'
                WHERE ordernumber = 'P2412230000330' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245310'
                WHERE ordernumber = 'P2412230000336' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438543'
                WHERE ordernumber = 'P2412230000339' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284565'
                WHERE ordernumber = 'P2412230000341' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161483'
                WHERE ordernumber = 'P2412230000343' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391082'
                WHERE ordernumber = 'P2412230000352' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216242'
                WHERE ordernumber = 'P2412230000354' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159536'
                WHERE ordernumber = 'P2412230000359' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431862'
                WHERE ordernumber = 'P2412230000360' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438548'
                WHERE ordernumber = 'P2412230000365' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164789'
                WHERE ordernumber = 'P2412230000366' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438547'
                WHERE ordernumber = 'P2412230000369' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438549'
                WHERE ordernumber = 'P2412230000372' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438553'
                WHERE ordernumber = 'P2412230000377' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438552'
                WHERE ordernumber = 'P2412230000379' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438555'
                WHERE ordernumber = 'P2412230000381' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378666'
                WHERE ordernumber = 'P2412230000387' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161910'
                WHERE ordernumber = 'P2412230000397' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438558'
                WHERE ordernumber = 'P2412230000398' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433592'
                WHERE ordernumber = 'P2412230000399' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438559'
                WHERE ordernumber = 'P2412230000401' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305084'
                WHERE ordernumber = 'P2412230000404' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438561'
                WHERE ordernumber = 'P2412230000406' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438562'
                WHERE ordernumber = 'P2412230000407' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438562'
                WHERE ordernumber = 'P2412230000408' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430109'
                WHERE ordernumber = 'P2412230000413' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212700'
                WHERE ordernumber = 'P2412230000417' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287235'
                WHERE ordernumber = 'P2412230000420' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117033'
                WHERE ordernumber = 'P2412230000427' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241147'
                WHERE ordernumber = 'P2412230000430' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438574'
                WHERE ordernumber = 'P2412230000433' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438575'
                WHERE ordernumber = 'P2412230000439' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305480'
                WHERE ordernumber = 'P2412230000443' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438578'
                WHERE ordernumber = 'P2412230000444' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325137'
                WHERE ordernumber = 'P2412230000449' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386309'
                WHERE ordernumber = 'P2412230000450' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121876'
                WHERE ordernumber = 'P2412230000454' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438579'
                WHERE ordernumber = 'P2412230000455' 
            
2024-12-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107391'
                WHERE ordernumber = 'P2412230000463' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94047'
                WHERE ordernumber = 'P2412230000467' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220138'
                WHERE ordernumber = 'P2412230000470' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258822'
                WHERE ordernumber = 'P2412230000476' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321300'
                WHERE ordernumber = 'P2412230000484' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223875'
                WHERE ordernumber = 'P2412230000489' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219796'
                WHERE ordernumber = 'P2412230000504' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427922'
                WHERE ordernumber = 'P2412230000506' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432152'
                WHERE ordernumber = 'P2412230000513' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438594'
                WHERE ordernumber = 'P2412230000514' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438597'
                WHERE ordernumber = 'P2412230000517' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234413'
                WHERE ordernumber = 'P2412230000519' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365755'
                WHERE ordernumber = 'P2412230000522' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438599'
                WHERE ordernumber = 'P2412230000524' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438601'
                WHERE ordernumber = 'P2412230000525' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373348'
                WHERE ordernumber = 'P2412230000530' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438604'
                WHERE ordernumber = 'P2412230000536' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438571'
                WHERE ordernumber = 'P2412230000543' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438607'
                WHERE ordernumber = 'P2412230000544' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438607'
                WHERE ordernumber = 'P2412230000546' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438608'
                WHERE ordernumber = 'P2412230000547' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438609'
                WHERE ordernumber = 'P2412230000549' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307486'
                WHERE ordernumber = 'P2412230000550' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273032'
                WHERE ordernumber = 'P2412230000553' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438613'
                WHERE ordernumber = 'P2412230000556' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437469'
                WHERE ordernumber = 'P2412230000570' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252016'
                WHERE ordernumber = 'P2412230000574' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438619'
                WHERE ordernumber = 'P2412230000578' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438621'
                WHERE ordernumber = 'P2412230000585' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387231'
                WHERE ordernumber = 'P2412230000594' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438627'
                WHERE ordernumber = 'P2412230000595' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438629'
                WHERE ordernumber = 'P2412230000597' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380655'
                WHERE ordernumber = 'P2412230000598' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433339'
                WHERE ordernumber = 'P2412230000599' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258048'
                WHERE ordernumber = 'P2412230000600' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380655'
                WHERE ordernumber = 'P2412230000601' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438630'
                WHERE ordernumber = 'P2412230000605' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438630'
                WHERE ordernumber = 'P2412230000611' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438632'
                WHERE ordernumber = 'P2412230000615' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438637'
                WHERE ordernumber = 'P2412230000624' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285911'
                WHERE ordernumber = 'P2412230000629' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98293'
                WHERE ordernumber = 'P2412230000632' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285911'
                WHERE ordernumber = 'P2412230000635' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438640'
                WHERE ordernumber = 'P2412230000639' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438646'
                WHERE ordernumber = 'P2412230000647' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297170'
                WHERE ordernumber = 'P2412230000649' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368588'
                WHERE ordernumber = 'P2412230000658' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438648'
                WHERE ordernumber = 'P2412230000666' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438653'
                WHERE ordernumber = 'P2412230000672' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '56632'
                WHERE ordernumber = 'P2412230000676' 
            
2024-12-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436942'
                WHERE ordernumber = 'P2412230000678'