2024-09-23 01:00:02 -- 將會員中心id寫入data-lake
2024-09-23 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-22%';
        
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P190922110155589' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422232'
                WHERE ordernumber = 'P420922110502931' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '200874'
                WHERE ordernumber = 'P200922110553350' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '195936'
                WHERE ordernumber = 'P420922110724529' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422234'
                WHERE ordernumber = 'P180922110737611' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422235'
                WHERE ordernumber = 'P180922110855693' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P200922110933731' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243544'
                WHERE ordernumber = 'P180922111039209' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116456'
                WHERE ordernumber = 'P180922111235964' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419990'
                WHERE ordernumber = 'P420922111239941' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421439'
                WHERE ordernumber = 'P420922111336538' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422237'
                WHERE ordernumber = 'P180922111624400' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214522'
                WHERE ordernumber = 'P420922111731604' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422238'
                WHERE ordernumber = 'P180922111732436' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422239'
                WHERE ordernumber = 'P180922111903948' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422240'
                WHERE ordernumber = 'P180922112253449' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299720'
                WHERE ordernumber = 'P180922112456423' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378664'
                WHERE ordernumber = 'P420922112507737' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320950'
                WHERE ordernumber = 'P180922112617409' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '185949'
                WHERE ordernumber = 'P180922112904286' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422243'
                WHERE ordernumber = 'P180922113116400' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283374'
                WHERE ordernumber = 'P180922113321830' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422242'
                WHERE ordernumber = 'P730922113418228' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422244'
                WHERE ordernumber = 'P200922113454214' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422245'
                WHERE ordernumber = 'P180922113455294' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422246'
                WHERE ordernumber = 'P180922113552676' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104035'
                WHERE ordernumber = 'P180922113713876' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422249'
                WHERE ordernumber = 'P420922115014436' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422248'
                WHERE ordernumber = 'P180922115042777' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422250'
                WHERE ordernumber = 'P180922115156292' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '158162'
                WHERE ordernumber = 'P730922115720922' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422251'
                WHERE ordernumber = 'P180922120029237' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422252'
                WHERE ordernumber = 'P180922120216962' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422253'
                WHERE ordernumber = 'P730922120347605' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422254'
                WHERE ordernumber = 'P180922120353528' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422255'
                WHERE ordernumber = 'P180922120522144' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319835'
                WHERE ordernumber = 'P200922120854747' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422256'
                WHERE ordernumber = 'P710922121028887' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413026'
                WHERE ordernumber = 'P180922121108888' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422258'
                WHERE ordernumber = 'P190922121322485' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422259'
                WHERE ordernumber = 'P190922121456767' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395549'
                WHERE ordernumber = 'P200922122436462' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237579'
                WHERE ordernumber = 'P200922122621222' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318562'
                WHERE ordernumber = 'P420922122752527' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422261'
                WHERE ordernumber = 'P180922123035959' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422262'
                WHERE ordernumber = 'P180922123239795' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310806'
                WHERE ordernumber = 'P420922123303129' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422260'
                WHERE ordernumber = 'P710922123437136' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '92690'
                WHERE ordernumber = 'P710922123525689' 
            
2024-09-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422256'
                WHERE ordernumber = 'P710922123555717' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422263'
                WHERE ordernumber = 'P180922123824354' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346820'
                WHERE ordernumber = 'P180922124006558' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422004'
                WHERE ordernumber = 'P420922124053939' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235221'
                WHERE ordernumber = 'P180922124120794' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422264'
                WHERE ordernumber = 'P200922124348538' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422265'
                WHERE ordernumber = 'P180922124711965' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422266'
                WHERE ordernumber = 'P710922125250494' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360845'
                WHERE ordernumber = 'P200922130526886' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422270'
                WHERE ordernumber = 'P180922130700757' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422271'
                WHERE ordernumber = 'P420922130753728' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422272'
                WHERE ordernumber = 'P420922130854604' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142114'
                WHERE ordernumber = 'P200922131031132' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422274'
                WHERE ordernumber = 'P180922131552437' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422275'
                WHERE ordernumber = 'P200922131717272' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276566'
                WHERE ordernumber = 'P190922132527393' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280585'
                WHERE ordernumber = 'P190922132743499' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384983'
                WHERE ordernumber = 'P200922132759652' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422277'
                WHERE ordernumber = 'P730922132831381' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422278'
                WHERE ordernumber = 'P200922132921956' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229496'
                WHERE ordernumber = 'P190922133211916' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422279'
                WHERE ordernumber = 'P710922133356872' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422281'
                WHERE ordernumber = 'P190922133404452' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386257'
                WHERE ordernumber = 'P190922133459843' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328566'
                WHERE ordernumber = 'P190922133714880' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248558'
                WHERE ordernumber = 'P730922134240840' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422274'
                WHERE ordernumber = 'P190922134400492' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422282'
                WHERE ordernumber = 'P710922134627181' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401297'
                WHERE ordernumber = 'P420922134822195' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216876'
                WHERE ordernumber = 'P730922135004849' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104230'
                WHERE ordernumber = 'P190922135236293' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293042'
                WHERE ordernumber = 'P420922135802574' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422287'
                WHERE ordernumber = 'P190922135919404' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422290'
                WHERE ordernumber = 'P190922140248355' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422289'
                WHERE ordernumber = 'P420922140249199' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422291'
                WHERE ordernumber = 'P190922140408339' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422288'
                WHERE ordernumber = 'P710922140505162' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422292'
                WHERE ordernumber = 'P420922140610346' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422239'
                WHERE ordernumber = 'P190922140704896' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422293'
                WHERE ordernumber = 'P190922141219748' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81972'
                WHERE ordernumber = 'P200922141250690' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422294'
                WHERE ordernumber = 'P190922141349665' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422297'
                WHERE ordernumber = 'P190922141942257' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422299'
                WHERE ordernumber = 'P420922142242609' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406014'
                WHERE ordernumber = 'P190922142255894' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422298'
                WHERE ordernumber = 'P730922142413863' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422301'
                WHERE ordernumber = 'P420922142419262' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422296'
                WHERE ordernumber = 'P190922142431316' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422295'
                WHERE ordernumber = 'P190922142509405' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422302'
                WHERE ordernumber = 'P420922142552675' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422300'
                WHERE ordernumber = 'P710922142609141' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277585'
                WHERE ordernumber = 'P190922142639534' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168160'
                WHERE ordernumber = 'P190922142743832' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422304'
                WHERE ordernumber = 'P190922142846814' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422302'
                WHERE ordernumber = 'P420922142852764' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422304'
                WHERE ordernumber = 'P190922142952853' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422305'
                WHERE ordernumber = 'P180922143624234' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422306'
                WHERE ordernumber = 'P200922144256821' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422307'
                WHERE ordernumber = 'P180922144413153' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67845'
                WHERE ordernumber = 'P180922144746200' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305961'
                WHERE ordernumber = 'P200922144803809' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422308'
                WHERE ordernumber = 'P180922144900886' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422310'
                WHERE ordernumber = 'P710922145456587' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66318'
                WHERE ordernumber = 'P180922150203728' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422311'
                WHERE ordernumber = 'P180922150427293' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422312'
                WHERE ordernumber = 'P180922150959391' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422313'
                WHERE ordernumber = 'P180922151047307' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '195643'
                WHERE ordernumber = 'P730922151414944' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422314'
                WHERE ordernumber = 'P180922151451804' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237283'
                WHERE ordernumber = 'P710922151620329' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422315'
                WHERE ordernumber = 'P180922151814838' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80968'
                WHERE ordernumber = 'P180922151847174' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422316'
                WHERE ordernumber = 'P180922152023608' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422318'
                WHERE ordernumber = 'P420922152134676' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422319'
                WHERE ordernumber = 'P180922152213152' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422317'
                WHERE ordernumber = 'P200922152225299' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422320'
                WHERE ordernumber = 'P710922152628490' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422323'
                WHERE ordernumber = 'P180922152643454' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422317'
                WHERE ordernumber = 'P200922152706564' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267579'
                WHERE ordernumber = 'P180922152852727' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422321'
                WHERE ordernumber = 'P180922153000558' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422321'
                WHERE ordernumber = 'P180922153042197' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422322'
                WHERE ordernumber = 'P180922153107955' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422324'
                WHERE ordernumber = 'P180922153248931' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342513'
                WHERE ordernumber = 'P180922153700536' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422325'
                WHERE ordernumber = 'P180922154025876' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422191'
                WHERE ordernumber = 'P710922154108332' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299221'
                WHERE ordernumber = 'P420922154240342' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422326'
                WHERE ordernumber = 'P710922154457765' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228404'
                WHERE ordernumber = 'P180922154644368' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422329'
                WHERE ordernumber = 'P180922154939539' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422328'
                WHERE ordernumber = 'P710922155124588' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410124'
                WHERE ordernumber = 'P200922155249979' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422331'
                WHERE ordernumber = 'P710922155810960' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422332'
                WHERE ordernumber = 'P180922160347636' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422334'
                WHERE ordernumber = 'P420922160536703' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422333'
                WHERE ordernumber = 'P710922160617453' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422335'
                WHERE ordernumber = 'P710922160946373' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422333'
                WHERE ordernumber = 'P710922161205497' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422337'
                WHERE ordernumber = 'P180922161345810' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422338'
                WHERE ordernumber = 'P710922161542300' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167325'
                WHERE ordernumber = 'P200922161903649' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422339'
                WHERE ordernumber = 'P180922162233389' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422341'
                WHERE ordernumber = 'P180922162511636' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422340'
                WHERE ordernumber = 'P710922162700311' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422342'
                WHERE ordernumber = 'P180922162723376' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422343'
                WHERE ordernumber = 'P180922162826153' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422344'
                WHERE ordernumber = 'P180922162926937' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112005'
                WHERE ordernumber = 'P180922163536131' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407020'
                WHERE ordernumber = 'P180922164255542' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422345'
                WHERE ordernumber = 'P730922164308495' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422347'
                WHERE ordernumber = 'P180922164530801' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419241'
                WHERE ordernumber = 'P190922164848630' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422348'
                WHERE ordernumber = 'P710922164916193' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422349'
                WHERE ordernumber = 'P420922165009839' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422350'
                WHERE ordernumber = 'P710922165043165' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332511'
                WHERE ordernumber = 'P190922165048549' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422349'
                WHERE ordernumber = 'P420922165103741' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '1522'
                WHERE ordernumber = 'P180922165120931' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422349'
                WHERE ordernumber = 'P420922165138295' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422349'
                WHERE ordernumber = 'P420922165214531' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421595'
                WHERE ordernumber = 'P200922165225746' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422351'
                WHERE ordernumber = 'P710922165344754' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422355'
                WHERE ordernumber = 'P190922165432476' 
            
2024-09-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422352'
                WHERE ordernumber = 'P710922165543520' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422354'
                WHERE ordernumber = 'P710922165720330' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422356'
                WHERE ordernumber = 'P180922170151916' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422358'
                WHERE ordernumber = 'P180922170920989' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422359'
                WHERE ordernumber = 'P180922171237751' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422361'
                WHERE ordernumber = 'P180922171441311' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422360'
                WHERE ordernumber = 'P710922171446626' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422362'
                WHERE ordernumber = 'P730922171852142' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422364'
                WHERE ordernumber = 'P710922171943857' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422366'
                WHERE ordernumber = 'P730922172221899' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316212'
                WHERE ordernumber = 'P420922172336980' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '17382'
                WHERE ordernumber = 'P710922172340760' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422367'
                WHERE ordernumber = 'P730922172352531' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402022'
                WHERE ordernumber = 'P180922173353945' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422370'
                WHERE ordernumber = 'P200922174353113' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422370'
                WHERE ordernumber = 'P200922174439564' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102851'
                WHERE ordernumber = 'P200922174518244' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422371'
                WHERE ordernumber = 'P730922174708722' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298460'
                WHERE ordernumber = 'P420922175001479' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422373'
                WHERE ordernumber = 'P710922175123748' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298460'
                WHERE ordernumber = 'P420922175148682' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422374'
                WHERE ordernumber = 'P180922175207246' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '153464'
                WHERE ordernumber = 'P730922175428751' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417256'
                WHERE ordernumber = 'P420922175754760' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422376'
                WHERE ordernumber = 'P420922175918329' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422380'
                WHERE ordernumber = 'P200922180749383' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422381'
                WHERE ordernumber = 'P200922181051320' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420717'
                WHERE ordernumber = 'P180922181134321' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422382'
                WHERE ordernumber = 'P420922181358895' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422383'
                WHERE ordernumber = 'P420922181551356' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422384'
                WHERE ordernumber = 'P180922181626134' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115088'
                WHERE ordernumber = 'P710922181708515' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422386'
                WHERE ordernumber = 'P180922182211981' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422387'
                WHERE ordernumber = 'P200922182223986' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '199011'
                WHERE ordernumber = 'P730922182316824' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100188'
                WHERE ordernumber = 'P200922182725642' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422389'
                WHERE ordernumber = 'P710922183255738' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259367'
                WHERE ordernumber = 'P200922183934543' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244547'
                WHERE ordernumber = 'P200922184104628' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343808'
                WHERE ordernumber = 'P200922184756139' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422392'
                WHERE ordernumber = 'P710922185309499' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422378'
                WHERE ordernumber = 'P630922185648840' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422393'
                WHERE ordernumber = 'P190922190613113' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392106'
                WHERE ordernumber = 'P710922190643794' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126295'
                WHERE ordernumber = 'P190922190739316' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422394'
                WHERE ordernumber = 'P190922191122768' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293377'
                WHERE ordernumber = 'P710922191226191' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255135'
                WHERE ordernumber = 'P710922192356193' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314401'
                WHERE ordernumber = 'P710922192601896' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391855'
                WHERE ordernumber = 'P710922193506493' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422396'
                WHERE ordernumber = 'P730922194400619' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422400'
                WHERE ordernumber = 'P190922195003884' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398703'
                WHERE ordernumber = 'P710922195020304' 
            
2024-09-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142377'
                WHERE ordernumber = 'P730922201452927'