2024-11-28 01:00:02 -- 將會員中心id寫入data-lake
2024-11-28 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-11-27%';
        
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430752'
                WHERE ordernumber = 'P2411270000120' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430752'
                WHERE ordernumber = 'P2411270000213' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162020'
                WHERE ordernumber = 'P2411270000330' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431967'
                WHERE ordernumber = 'P2411270000648' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431969'
                WHERE ordernumber = 'P2411270000791' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431968'
                WHERE ordernumber = 'P2411270000846' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421142'
                WHERE ordernumber = 'P2411270000942' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431970'
                WHERE ordernumber = 'P2411270001017' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431248'
                WHERE ordernumber = 'P2411270001160' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116975'
                WHERE ordernumber = 'P2411270001272' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301491'
                WHERE ordernumber = 'P2411270001364' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431946'
                WHERE ordernumber = 'P2411270001531' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431972'
                WHERE ordernumber = 'P2411270001731' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431971'
                WHERE ordernumber = 'P2411270001824' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431973'
                WHERE ordernumber = 'P2411270001914' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417422'
                WHERE ordernumber = 'P2411270002034' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282647'
                WHERE ordernumber = 'P2411270002116' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162600'
                WHERE ordernumber = 'P2411270002348' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431975'
                WHERE ordernumber = 'P2411270002442' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408688'
                WHERE ordernumber = 'P2411270002610' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306553'
                WHERE ordernumber = 'P2411270002734' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431978'
                WHERE ordernumber = 'P2411270002878' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245523'
                WHERE ordernumber = 'P2411270003041' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306553'
                WHERE ordernumber = 'P2411270003129' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431980'
                WHERE ordernumber = 'P2411270003256' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268816'
                WHERE ordernumber = 'P2411270003371' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431982'
                WHERE ordernumber = 'P2411270003417' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431919'
                WHERE ordernumber = 'P2411270003526' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431984'
                WHERE ordernumber = 'P2411270003855' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431982'
                WHERE ordernumber = 'P2411270003973' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347408'
                WHERE ordernumber = 'P2411270004058' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '115139'
                WHERE ordernumber = 'P2411270004183' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431985'
                WHERE ordernumber = 'P2411270004368' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418800'
                WHERE ordernumber = 'P2411270004539' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431986'
                WHERE ordernumber = 'P2411270004668' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '69816'
                WHERE ordernumber = 'P2411270004735' 
            
2024-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388008'
                WHERE ordernumber = 'P2411270004873' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354688'
                WHERE ordernumber = 'P2411270004995' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217809'
                WHERE ordernumber = 'P2411270005017' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346441'
                WHERE ordernumber = 'P2411270005238' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431988'
                WHERE ordernumber = 'P2411270005598' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431989'
                WHERE ordernumber = 'P2411270005669' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431991'
                WHERE ordernumber = 'P2411270005855' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63286'
                WHERE ordernumber = 'P2411270005915' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256017'
                WHERE ordernumber = 'P2411270006284' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322456'
                WHERE ordernumber = 'P2411270006375' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239205'
                WHERE ordernumber = 'P2411270006765' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339438'
                WHERE ordernumber = 'P2411270006822' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389260'
                WHERE ordernumber = 'P2411270006986' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431994'
                WHERE ordernumber = 'P2411270007130' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431996'
                WHERE ordernumber = 'P2411270007332' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431995'
                WHERE ordernumber = 'P2411270007417' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432000'
                WHERE ordernumber = 'P2411270008055' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300492'
                WHERE ordernumber = 'P2411270008192' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206350'
                WHERE ordernumber = 'P2411270008322' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88929'
                WHERE ordernumber = 'P2411270008467' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432004'
                WHERE ordernumber = 'P2411270008678' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432003'
                WHERE ordernumber = 'P2411270008738' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432006'
                WHERE ordernumber = 'P2411270008897' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314514'
                WHERE ordernumber = 'P2411270008940' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237513'
                WHERE ordernumber = 'P2411270009083' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102423'
                WHERE ordernumber = 'P2411270009126' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P2411270009283' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333486'
                WHERE ordernumber = 'P2411270009372' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246185'
                WHERE ordernumber = 'P2411270009533' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432007'
                WHERE ordernumber = 'P2411270009676' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432010'
                WHERE ordernumber = 'P2411270009818' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432011'
                WHERE ordernumber = 'P2411270009975' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432012'
                WHERE ordernumber = 'P2411270010015' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432014'
                WHERE ordernumber = 'P2411270010256' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431520'
                WHERE ordernumber = 'P2411270010336' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432016'
                WHERE ordernumber = 'P2411270010452' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432016'
                WHERE ordernumber = 'P2411270010512' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432018'
                WHERE ordernumber = 'P2411270010759' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371641'
                WHERE ordernumber = 'P2411270010933' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432019'
                WHERE ordernumber = 'P2411270011191' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308329'
                WHERE ordernumber = 'P2411270011225' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208658'
                WHERE ordernumber = 'P2411270011324' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432022'
                WHERE ordernumber = 'P2411270011920' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235758'
                WHERE ordernumber = 'P2411270012121' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228102'
                WHERE ordernumber = 'P2411270012295' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432027'
                WHERE ordernumber = 'P2411270012332' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432026'
                WHERE ordernumber = 'P2411270012488' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432028'
                WHERE ordernumber = 'P2411270012567' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432030'
                WHERE ordernumber = 'P2411270012883' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432032'
                WHERE ordernumber = 'P2411270012947' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432033'
                WHERE ordernumber = 'P2411270013097' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432033'
                WHERE ordernumber = 'P2411270013163' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432034'
                WHERE ordernumber = 'P2411270013376' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432035'
                WHERE ordernumber = 'P2411270013415' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432037'
                WHERE ordernumber = 'P2411270013587' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432036'
                WHERE ordernumber = 'P2411270013649' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432038'
                WHERE ordernumber = 'P2411270013752' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421347'
                WHERE ordernumber = 'P2411270013866' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432039'
                WHERE ordernumber = 'P2411270014082' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272343'
                WHERE ordernumber = 'P2411270014232' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391719'
                WHERE ordernumber = 'P2411270014455' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316213'
                WHERE ordernumber = 'P2411270014692' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340342'
                WHERE ordernumber = 'P2411270014897' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432040'
                WHERE ordernumber = 'P2411270014977' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432042'
                WHERE ordernumber = 'P2411270015238' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247088'
                WHERE ordernumber = 'P2411270015583' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432043'
                WHERE ordernumber = 'P2411270015633' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426998'
                WHERE ordernumber = 'P2411270015921' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291975'
                WHERE ordernumber = 'P2411270016058' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432044'
                WHERE ordernumber = 'P2411270016223' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431985'
                WHERE ordernumber = 'P2411270016386' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432045'
                WHERE ordernumber = 'P2411270016468' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432049'
                WHERE ordernumber = 'P2411270016869' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432047'
                WHERE ordernumber = 'P2411270016967' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432048'
                WHERE ordernumber = 'P2411270017076' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133372'
                WHERE ordernumber = 'P2411270017152' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379601'
                WHERE ordernumber = 'P2411270017450' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432052'
                WHERE ordernumber = 'P2411270018092' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432054'
                WHERE ordernumber = 'P2411270018345' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432053'
                WHERE ordernumber = 'P2411270018764' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P2411270018911' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351590'
                WHERE ordernumber = 'P2411270019133' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431998'
                WHERE ordernumber = 'P2411270019262' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432055'
                WHERE ordernumber = 'P2411270019372' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287713'
                WHERE ordernumber = 'P2411270019499' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432059'
                WHERE ordernumber = 'P2411270019510' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '152524'
                WHERE ordernumber = 'P2411270019623' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429060'
                WHERE ordernumber = 'P2411270019735' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432056'
                WHERE ordernumber = 'P2411270019978' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432060'
                WHERE ordernumber = 'P2411270020035' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432061'
                WHERE ordernumber = 'P2411270020199' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112335'
                WHERE ordernumber = 'P2411270020214' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343306'
                WHERE ordernumber = 'P2411270020317' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322147'
                WHERE ordernumber = 'P2411270020585' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288179'
                WHERE ordernumber = 'P2411270020681' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299342'
                WHERE ordernumber = 'P2411270020890' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432064'
                WHERE ordernumber = 'P2411270020984' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432064'
                WHERE ordernumber = 'P2411270021030' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432063'
                WHERE ordernumber = 'P2411270021135' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407844'
                WHERE ordernumber = 'P2411270021239' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432067'
                WHERE ordernumber = 'P2411270021346' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297056'
                WHERE ordernumber = 'P2411270021519' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432069'
                WHERE ordernumber = 'P2411270021646' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432068'
                WHERE ordernumber = 'P2411270021726' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432071'
                WHERE ordernumber = 'P2411270021954' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432073'
                WHERE ordernumber = 'P2411270022038' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320845'
                WHERE ordernumber = 'P2411270022222' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312438'
                WHERE ordernumber = 'P2411270022380' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432074'
                WHERE ordernumber = 'P2411270022551' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432075'
                WHERE ordernumber = 'P2411270022616' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432076'
                WHERE ordernumber = 'P2411270022954' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432078'
                WHERE ordernumber = 'P2411270023075' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432079'
                WHERE ordernumber = 'P2411270023220' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344378'
                WHERE ordernumber = 'P2411270023330' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432080'
                WHERE ordernumber = 'P2411270023437' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214967'
                WHERE ordernumber = 'P2411270023635' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432081'
                WHERE ordernumber = 'P2411270023993' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432082'
                WHERE ordernumber = 'P2411270024125' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348538'
                WHERE ordernumber = 'P2411270024231' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392994'
                WHERE ordernumber = 'P2411270024398' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '16876'
                WHERE ordernumber = 'P2411270024446' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432083'
                WHERE ordernumber = 'P2411270024588' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432084'
                WHERE ordernumber = 'P2411270024621' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432086'
                WHERE ordernumber = 'P2411270024737' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432085'
                WHERE ordernumber = 'P2411270024837' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432087'
                WHERE ordernumber = 'P2411270025057' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219215'
                WHERE ordernumber = 'P2411270025349' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431927'
                WHERE ordernumber = 'P2411270025547' 
            
2024-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432091'
                WHERE ordernumber = 'P2411270025861' 
            
2024-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431088'
                WHERE ordernumber = 'P2411270025935' 
            
2024-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224256'
                WHERE ordernumber = 'P2411270026080' 
            
2024-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324599'
                WHERE ordernumber = 'P2411270026158' 
            
2024-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432089'
                WHERE ordernumber = 'P2411270026253' 
            
2024-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306298'
                WHERE ordernumber = 'P2411270026645' 
            
2024-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278377'
                WHERE ordernumber = 'P2411270026714' 
            
2024-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404126'
                WHERE ordernumber = 'P2411270026830' 
            
2024-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428538'
                WHERE ordernumber = 'P2411270026916' 
            
2024-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360364'
                WHERE ordernumber = 'P2411270027037' 
            
2024-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292297'
                WHERE ordernumber = 'P2411270027374' 
            
2024-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432097'
                WHERE ordernumber = 'P2411270027482' 
            
2024-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '32411'
                WHERE ordernumber = 'P2411270027560'