2024-09-24 01:00:02 -- 將會員中心id寫入data-lake
2024-09-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-09-23%';
        
2024-09-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '122243'
                WHERE ordernumber = 'P200923110325676' 
            
2024-09-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418898'
                WHERE ordernumber = 'P420923110533661' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422445'
                WHERE ordernumber = 'P200923110541458' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388429'
                WHERE ordernumber = 'P200923110710229' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422446'
                WHERE ordernumber = 'P420923110711664' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422448'
                WHERE ordernumber = 'P420923110911586' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218591'
                WHERE ordernumber = 'P200923110931487' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412521'
                WHERE ordernumber = 'P420923111119166' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422449'
                WHERE ordernumber = 'P190923111552584' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264014'
                WHERE ordernumber = 'P190923111703128' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253538'
                WHERE ordernumber = 'P190923111755548' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422450'
                WHERE ordernumber = 'P190923111841685' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P190923111907652' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216961'
                WHERE ordernumber = 'P190923112026846' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398342'
                WHERE ordernumber = 'P420923112217503' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401189'
                WHERE ordernumber = 'P200923112435250' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116277'
                WHERE ordernumber = 'P190923112439719' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289050'
                WHERE ordernumber = 'P200923112736611' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422451'
                WHERE ordernumber = 'P190923112913698' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99933'
                WHERE ordernumber = 'P200923114128685' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270393'
                WHERE ordernumber = 'P190923114439209' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421404'
                WHERE ordernumber = 'P200923114532511' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102081'
                WHERE ordernumber = 'P190923115949539' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422453'
                WHERE ordernumber = 'P710923120110681' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110816'
                WHERE ordernumber = 'P180923120305699' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122761'
                WHERE ordernumber = 'P200923120923151' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P420923121807719' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422456'
                WHERE ordernumber = 'P190923122236619' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340608'
                WHERE ordernumber = 'P420923123219813' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421655'
                WHERE ordernumber = 'P200923123257879' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422457'
                WHERE ordernumber = 'P420923123713416' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422458'
                WHERE ordernumber = 'P420923123837189' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111887'
                WHERE ordernumber = 'P180923123952434' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422459'
                WHERE ordernumber = 'P180923124133862' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422461'
                WHERE ordernumber = 'P200923124436575' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347653'
                WHERE ordernumber = 'P200923124605401' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236476'
                WHERE ordernumber = 'P180923124716391' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422462'
                WHERE ordernumber = 'P420923124736890' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420473'
                WHERE ordernumber = 'P180923124918565' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402034'
                WHERE ordernumber = 'P200923124947609' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422463'
                WHERE ordernumber = 'P730923125623820' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422466'
                WHERE ordernumber = 'P180923125758164' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167862'
                WHERE ordernumber = 'P200923130238767' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421398'
                WHERE ordernumber = 'P180923130601630' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422469'
                WHERE ordernumber = 'P710923130638393' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239838'
                WHERE ordernumber = 'P200923130832449' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421975'
                WHERE ordernumber = 'P200923131147705' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422474'
                WHERE ordernumber = 'P420923131506603' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380161'
                WHERE ordernumber = 'P420923131749669' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422472'
                WHERE ordernumber = 'P730923131840788' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P630923131852272' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380161'
                WHERE ordernumber = 'P420923131921646' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422477'
                WHERE ordernumber = 'P180923132540263' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422478'
                WHERE ordernumber = 'P200923133114789' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278597'
                WHERE ordernumber = 'P420923133349848' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421734'
                WHERE ordernumber = 'P420923133712712' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422480'
                WHERE ordernumber = 'P180923133753626' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247088'
                WHERE ordernumber = 'P420923134156925' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378213'
                WHERE ordernumber = 'P200923134454647' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422483'
                WHERE ordernumber = 'P180923134631948' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422484'
                WHERE ordernumber = 'P200923135106338' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422485'
                WHERE ordernumber = 'P420923135334717' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420120'
                WHERE ordernumber = 'P180923135403189' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101737'
                WHERE ordernumber = 'P200923135511140' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422486'
                WHERE ordernumber = 'P200923135747740' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422487'
                WHERE ordernumber = 'P730923140227700' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111127'
                WHERE ordernumber = 'P180923140308648' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378472'
                WHERE ordernumber = 'P180923140618671' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422488'
                WHERE ordernumber = 'P200923140830881' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249648'
                WHERE ordernumber = 'P200923141014192' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404559'
                WHERE ordernumber = 'P200923141047252' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346687'
                WHERE ordernumber = 'P180923141424440' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422489'
                WHERE ordernumber = 'P200923141842198' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287996'
                WHERE ordernumber = 'P180923142306962' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422491'
                WHERE ordernumber = 'P200923142452364' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422490'
                WHERE ordernumber = 'P180923142455271' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99659'
                WHERE ordernumber = 'P180923143403394' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422494'
                WHERE ordernumber = 'P730923143822123' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393537'
                WHERE ordernumber = 'P180923144709191' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422476'
                WHERE ordernumber = 'P180923144907155' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335760'
                WHERE ordernumber = 'P200923145112360' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422498'
                WHERE ordernumber = 'P710923150305709' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200923151048881' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180923151213125' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422423'
                WHERE ordernumber = 'P730923151250390' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422501'
                WHERE ordernumber = 'P730923151730647' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422502'
                WHERE ordernumber = 'P710923151842977' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422503'
                WHERE ordernumber = 'P710923152016302' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380658'
                WHERE ordernumber = 'P180923152021776' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422453'
                WHERE ordernumber = 'P710923152236240' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376631'
                WHERE ordernumber = 'P180923152816643' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311575'
                WHERE ordernumber = 'P420923152952773' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422505'
                WHERE ordernumber = 'P420923153131884' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422506'
                WHERE ordernumber = 'P200923153135143' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422507'
                WHERE ordernumber = 'P180923153503280' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422508'
                WHERE ordernumber = 'P180923153552994' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422509'
                WHERE ordernumber = 'P710923154018675' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422511'
                WHERE ordernumber = 'P200923154158780' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422513'
                WHERE ordernumber = 'P420923154246211' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306488'
                WHERE ordernumber = 'P200923154444890' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422515'
                WHERE ordernumber = 'P730923154854785' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396097'
                WHERE ordernumber = 'P180923155336885' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324722'
                WHERE ordernumber = 'P630923160401881' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421743'
                WHERE ordernumber = 'P420923160503366' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149333'
                WHERE ordernumber = 'P200923160547557' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115139'
                WHERE ordernumber = 'P180923160855754' 
            
2024-09-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221741'
                WHERE ordernumber = 'P420923160945727' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422519'
                WHERE ordernumber = 'P200923161619641' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208069'
                WHERE ordernumber = 'P730923161710972' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422520'
                WHERE ordernumber = 'P200923161916538' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236318'
                WHERE ordernumber = 'P200923161957453' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163205'
                WHERE ordernumber = 'P420923162420490' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315379'
                WHERE ordernumber = 'P200923162611417' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420128'
                WHERE ordernumber = 'P420923162734826' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422523'
                WHERE ordernumber = 'P200923163048660' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403382'
                WHERE ordernumber = 'P180923163146236' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422525'
                WHERE ordernumber = 'P180923163420665' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404599'
                WHERE ordernumber = 'P420923163734874' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422527'
                WHERE ordernumber = 'P710923164518134' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422528'
                WHERE ordernumber = 'P730923164559298' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422530'
                WHERE ordernumber = 'P180923164816399' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331186'
                WHERE ordernumber = 'P200923165331285' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338257'
                WHERE ordernumber = 'P200923165607206' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325003'
                WHERE ordernumber = 'P180923170307750' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422533'
                WHERE ordernumber = 'P200923170523467' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422533'
                WHERE ordernumber = 'P200923170543789' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422534'
                WHERE ordernumber = 'P730923170624430' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300784'
                WHERE ordernumber = 'P200923170809179' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416844'
                WHERE ordernumber = 'P200923171622475' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421739'
                WHERE ordernumber = 'P200923171656582' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376451'
                WHERE ordernumber = 'P180923172219253' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351933'
                WHERE ordernumber = 'P200923172513842' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332962'
                WHERE ordernumber = 'P200923172615245' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '31317'
                WHERE ordernumber = 'P200923172702406' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335298'
                WHERE ordernumber = 'P420923172803891' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421611'
                WHERE ordernumber = 'P200923172819816' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422535'
                WHERE ordernumber = 'P710923172929932' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422226'
                WHERE ordernumber = 'P420923173031551' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422226'
                WHERE ordernumber = 'P420923173118960' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105630'
                WHERE ordernumber = 'P200923173640896' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422540'
                WHERE ordernumber = 'P420923173703394' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422537'
                WHERE ordernumber = 'P730923173742573' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422303'
                WHERE ordernumber = 'P200923173936301' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422538'
                WHERE ordernumber = 'P730923174002848' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422541'
                WHERE ordernumber = 'P730923174129580' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383109'
                WHERE ordernumber = 'P180923174456534' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422543'
                WHERE ordernumber = 'P710923174739762' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348671'
                WHERE ordernumber = 'P420923175130472' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422544'
                WHERE ordernumber = 'P710923175409579' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292038'
                WHERE ordernumber = 'P200923175823368' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99009'
                WHERE ordernumber = 'P190923180244439' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252616'
                WHERE ordernumber = 'P420923180348588' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '63785'
                WHERE ordernumber = 'P180923181057385' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422547'
                WHERE ordernumber = 'P730923181111488' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '196771'
                WHERE ordernumber = 'P180923181216630' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422548'
                WHERE ordernumber = 'P730923181246234' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420909'
                WHERE ordernumber = 'P630923181543396' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422539'
                WHERE ordernumber = 'P180923182050992' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398514'
                WHERE ordernumber = 'P180923182353680' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422539'
                WHERE ordernumber = 'P180923182453702' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341988'
                WHERE ordernumber = 'P420923182601746' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420671'
                WHERE ordernumber = 'P180923183327347' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422552'
                WHERE ordernumber = 'P190923183356440' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331449'
                WHERE ordernumber = 'P190923184443630' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422492'
                WHERE ordernumber = 'P200923185330422' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422492'
                WHERE ordernumber = 'P200923185438669' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422555'
                WHERE ordernumber = 'P200923185746736' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422557'
                WHERE ordernumber = 'P710923190100365' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422558'
                WHERE ordernumber = 'P190923190158328' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421769'
                WHERE ordernumber = 'P190923190332772' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422560'
                WHERE ordernumber = 'P710923191030245' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422561'
                WHERE ordernumber = 'P730923191036395' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422563'
                WHERE ordernumber = 'P190923191101980' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140510'
                WHERE ordernumber = 'P190923191222206' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422564'
                WHERE ordernumber = 'P710923192304293' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '30659'
                WHERE ordernumber = 'P190923193440842' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422567'
                WHERE ordernumber = 'P710923201245764' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422570'
                WHERE ordernumber = 'P730923203547568' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422571'
                WHERE ordernumber = 'P730923204752771' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422572'
                WHERE ordernumber = 'P710923210222268' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422574'
                WHERE ordernumber = 'P710923211325769' 
            
2024-09-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408492'
                WHERE ordernumber = 'P630923212937156'