2024-11-23 01:00:01 -- 將會員中心id寫入data-lake
2024-11-23 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-11-22%';
        
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '219323'
                WHERE ordernumber = 'P2411220000297' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '426989'
                WHERE ordernumber = 'P2411220000321' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '414290'
                WHERE ordernumber = 'P2411220000476' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '162814'
                WHERE ordernumber = 'P2411220000543' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '311342'
                WHERE ordernumber = 'P2411220000657' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '431259'
                WHERE ordernumber = 'P2411220000726' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '122776'
                WHERE ordernumber = 'P2411220000927' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '139462'
                WHERE ordernumber = 'P2411220001068' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '242184'
                WHERE ordernumber = 'P2411220001189' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '139462'
                WHERE ordernumber = 'P2411220001289' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '429980'
                WHERE ordernumber = 'P2411220001433' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '395528'
                WHERE ordernumber = 'P2411220001559' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '225509'
                WHERE ordernumber = 'P2411220001631' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '385243'
                WHERE ordernumber = 'P2411220001790' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '431262'
                WHERE ordernumber = 'P2411220001924' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '347214'
                WHERE ordernumber = 'P2411220002080' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '431264'
                WHERE ordernumber = 'P2411220002312' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '431265'
                WHERE ordernumber = 'P2411220002599' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '352265'
                WHERE ordernumber = 'P2411220002740' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '216606'
                WHERE ordernumber = 'P2411220002924' 
            
2024-11-23 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '223592'
                WHERE ordernumber = 'P2411220003091' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431267'
                WHERE ordernumber = 'P2411220003174' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431267'
                WHERE ordernumber = 'P2411220003599' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431269'
                WHERE ordernumber = 'P2411220003677' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431270'
                WHERE ordernumber = 'P2411220003786' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297594'
                WHERE ordernumber = 'P2411220004033' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431269'
                WHERE ordernumber = 'P2411220004271' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337747'
                WHERE ordernumber = 'P2411220004310' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431271'
                WHERE ordernumber = 'P2411220004589' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236399'
                WHERE ordernumber = 'P2411220004885' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272211'
                WHERE ordernumber = 'P2411220005033' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272211'
                WHERE ordernumber = 'P2411220005153' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431273'
                WHERE ordernumber = 'P2411220005486' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352569'
                WHERE ordernumber = 'P2411220005549' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431276'
                WHERE ordernumber = 'P2411220005948' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '267401'
                WHERE ordernumber = 'P2411220006057' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317939'
                WHERE ordernumber = 'P2411220006133' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430164'
                WHERE ordernumber = 'P2411220006230' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431281'
                WHERE ordernumber = 'P2411220006462' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316941'
                WHERE ordernumber = 'P2411220006595' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239020'
                WHERE ordernumber = 'P2411220006667' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431282'
                WHERE ordernumber = 'P2411220006789' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431283'
                WHERE ordernumber = 'P2411220006868' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431287'
                WHERE ordernumber = 'P2411220007280' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255537'
                WHERE ordernumber = 'P2411220007344' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334044'
                WHERE ordernumber = 'P2411220007486' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429505'
                WHERE ordernumber = 'P2411220007590' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429505'
                WHERE ordernumber = 'P2411220007676' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431288'
                WHERE ordernumber = 'P2411220008025' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286550'
                WHERE ordernumber = 'P2411220008273' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429346'
                WHERE ordernumber = 'P2411220008995' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431292'
                WHERE ordernumber = 'P2411220009248' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431294'
                WHERE ordernumber = 'P2411220009626' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431295'
                WHERE ordernumber = 'P2411220009763' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416454'
                WHERE ordernumber = 'P2411220009985' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218548'
                WHERE ordernumber = 'P2411220010154' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294547'
                WHERE ordernumber = 'P2411220010652' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285926'
                WHERE ordernumber = 'P2411220011073' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392608'
                WHERE ordernumber = 'P2411220011123' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275812'
                WHERE ordernumber = 'P2411220011335' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431297'
                WHERE ordernumber = 'P2411220011455' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P2411220011585' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430273'
                WHERE ordernumber = 'P2411220011650' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350085'
                WHERE ordernumber = 'P2411220011751' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431298'
                WHERE ordernumber = 'P2411220011885' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431299'
                WHERE ordernumber = 'P2411220012027' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405596'
                WHERE ordernumber = 'P2411220012259' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357864'
                WHERE ordernumber = 'P2411220012417' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2411220012554' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431300'
                WHERE ordernumber = 'P2411220012627' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431301'
                WHERE ordernumber = 'P2411220012780' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431302'
                WHERE ordernumber = 'P2411220012838' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424887'
                WHERE ordernumber = 'P2411220013023' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329680'
                WHERE ordernumber = 'P2411220013115' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263364'
                WHERE ordernumber = 'P2411220013439' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217809'
                WHERE ordernumber = 'P2411220013515' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431305'
                WHERE ordernumber = 'P2411220013719' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269439'
                WHERE ordernumber = 'P2411220013815' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430575'
                WHERE ordernumber = 'P2411220014072' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431306'
                WHERE ordernumber = 'P2411220014161' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237810'
                WHERE ordernumber = 'P2411220014367' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396824'
                WHERE ordernumber = 'P2411220014969' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431307'
                WHERE ordernumber = 'P2411220015152' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431308'
                WHERE ordernumber = 'P2411220015498' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431309'
                WHERE ordernumber = 'P2411220015529' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349950'
                WHERE ordernumber = 'P2411220015625' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401273'
                WHERE ordernumber = 'P2411220015788' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397820'
                WHERE ordernumber = 'P2411220015847' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101905'
                WHERE ordernumber = 'P2411220016091' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431312'
                WHERE ordernumber = 'P2411220016562' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431313'
                WHERE ordernumber = 'P2411220016619' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431087'
                WHERE ordernumber = 'P2411220016761' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431315'
                WHERE ordernumber = 'P2411220016984' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431314'
                WHERE ordernumber = 'P2411220017069' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431310'
                WHERE ordernumber = 'P2411220017126' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395874'
                WHERE ordernumber = 'P2411220017432' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342676'
                WHERE ordernumber = 'P2411220017648' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431318'
                WHERE ordernumber = 'P2411220017792' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431321'
                WHERE ordernumber = 'P2411220017916' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '169022'
                WHERE ordernumber = 'P2411220018072' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431319'
                WHERE ordernumber = 'P2411220018140' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431320'
                WHERE ordernumber = 'P2411220018310' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378124'
                WHERE ordernumber = 'P2411220018421' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431322'
                WHERE ordernumber = 'P2411220018653' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308957'
                WHERE ordernumber = 'P2411220018755' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431324'
                WHERE ordernumber = 'P2411220018876' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431323'
                WHERE ordernumber = 'P2411220018936' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431326'
                WHERE ordernumber = 'P2411220019070' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353814'
                WHERE ordernumber = 'P2411220019141' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379941'
                WHERE ordernumber = 'P2411220019261' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431296'
                WHERE ordernumber = 'P2411220019547' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424532'
                WHERE ordernumber = 'P2411220019675' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339848'
                WHERE ordernumber = 'P2411220019836' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341009'
                WHERE ordernumber = 'P2411220019982' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320844'
                WHERE ordernumber = 'P2411220020558' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431327'
                WHERE ordernumber = 'P2411220020682' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '131195'
                WHERE ordernumber = 'P2411220020738' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431329'
                WHERE ordernumber = 'P2411220020924' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431330'
                WHERE ordernumber = 'P2411220021193' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431331'
                WHERE ordernumber = 'P2411220021258' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287386'
                WHERE ordernumber = 'P2411220021317' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431332'
                WHERE ordernumber = 'P2411220021464' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431331'
                WHERE ordernumber = 'P2411220021549' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431335'
                WHERE ordernumber = 'P2411220021683' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431336'
                WHERE ordernumber = 'P2411220021940' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298217'
                WHERE ordernumber = 'P2411220022193' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431337'
                WHERE ordernumber = 'P2411220022223' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104342'
                WHERE ordernumber = 'P2411220022435' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281863'
                WHERE ordernumber = 'P2411220022547' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431338'
                WHERE ordernumber = 'P2411220022770' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431340'
                WHERE ordernumber = 'P2411220022838' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431340'
                WHERE ordernumber = 'P2411220022999' 
            
2024-11-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230683'
                WHERE ordernumber = 'P2411220023061' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356033'
                WHERE ordernumber = 'P2411220023256' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356033'
                WHERE ordernumber = 'P2411220023323' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302497'
                WHERE ordernumber = 'P2411220023536' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431341'
                WHERE ordernumber = 'P2411220023663' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431342'
                WHERE ordernumber = 'P2411220023767' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431343'
                WHERE ordernumber = 'P2411220023930' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351449'
                WHERE ordernumber = 'P2411220024190' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376066'
                WHERE ordernumber = 'P2411220024285' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431346'
                WHERE ordernumber = 'P2411220024546' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431346'
                WHERE ordernumber = 'P2411220024686' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217198'
                WHERE ordernumber = 'P2411220024823' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431347'
                WHERE ordernumber = 'P2411220024962' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303338'
                WHERE ordernumber = 'P2411220025085' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398497'
                WHERE ordernumber = 'P2411220025224' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385090'
                WHERE ordernumber = 'P2411220025640' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406743'
                WHERE ordernumber = 'P2411220025859' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431349'
                WHERE ordernumber = 'P2411220025927' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431350'
                WHERE ordernumber = 'P2411220026051' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394796'
                WHERE ordernumber = 'P2411220026289' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431351'
                WHERE ordernumber = 'P2411220026489' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431352'
                WHERE ordernumber = 'P2411220026799' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431353'
                WHERE ordernumber = 'P2411220027325' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431353'
                WHERE ordernumber = 'P2411220027673' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '12532'
                WHERE ordernumber = 'P2411220027749' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431355'
                WHERE ordernumber = 'P2411220027876' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80921'
                WHERE ordernumber = 'P2411220027955' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98720'
                WHERE ordernumber = 'P2411220028165' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431356'
                WHERE ordernumber = 'P2411220028585' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430841'
                WHERE ordernumber = 'P2411220028728' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399585'
                WHERE ordernumber = 'P2411220028997' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431357'
                WHERE ordernumber = 'P2411220028860' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421254'
                WHERE ordernumber = 'P2411220029025' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379431'
                WHERE ordernumber = 'P2411220029148' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431358'
                WHERE ordernumber = 'P2411220029399' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287491'
                WHERE ordernumber = 'P2411220029426' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431359'
                WHERE ordernumber = 'P2411220029577' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431103'
                WHERE ordernumber = 'P2411220029610' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431103'
                WHERE ordernumber = 'P2411220029786' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368246'
                WHERE ordernumber = 'P2411220030067' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431361'
                WHERE ordernumber = 'P2411220030296' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214528'
                WHERE ordernumber = 'P2411220030347' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431360'
                WHERE ordernumber = 'P2411220030523' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89036'
                WHERE ordernumber = 'P2411220030747' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386984'
                WHERE ordernumber = 'P2411220031030' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234624'
                WHERE ordernumber = 'P2411220031297' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394866'
                WHERE ordernumber = 'P2411220031353' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431363'
                WHERE ordernumber = 'P2411220031480' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431362'
                WHERE ordernumber = 'P2411220031573' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143144'
                WHERE ordernumber = 'P2411220031664' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P2411220031928' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431365'
                WHERE ordernumber = 'P2411220032133' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288121'
                WHERE ordernumber = 'P2411220032498' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300072'
                WHERE ordernumber = 'P2411220032597' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294208'
                WHERE ordernumber = 'P2411220032696' 
            
2024-11-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431367'
                WHERE ordernumber = 'P2411220032786'