2024-05-05 01:00:02 -- 將會員中心id寫入data-lake
2024-05-05 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-05-04%';
        
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388211'
                WHERE ordernumber = 'P630504100656759' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388212'
                WHERE ordernumber = 'P630504103101581' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388213'
                WHERE ordernumber = 'P630504103728818' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388214'
                WHERE ordernumber = 'P420504104315547' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388215'
                WHERE ordernumber = 'P630504104617648' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216410'
                WHERE ordernumber = 'P200504110706848' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285050'
                WHERE ordernumber = 'P180504110818522' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220311'
                WHERE ordernumber = 'P180504111026394' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '327300'
                WHERE ordernumber = 'P200504111241908' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388218'
                WHERE ordernumber = 'P180504111326718' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388219'
                WHERE ordernumber = 'P200504111359308' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388220'
                WHERE ordernumber = 'P420504111557665' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334872'
                WHERE ordernumber = 'P200504111622841' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388221'
                WHERE ordernumber = 'P420504112046538' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388222'
                WHERE ordernumber = 'P200504112131221' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388223'
                WHERE ordernumber = 'P180504112149385' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387583'
                WHERE ordernumber = 'P200504112514506' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387581'
                WHERE ordernumber = 'P200504112549532' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388224'
                WHERE ordernumber = 'P180504112559139' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388226'
                WHERE ordernumber = 'P200504112723805' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388227'
                WHERE ordernumber = 'P180504112732306' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383920'
                WHERE ordernumber = 'P180504112954453' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388228'
                WHERE ordernumber = 'P420504113357866' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388211'
                WHERE ordernumber = 'P630504113430802' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388229'
                WHERE ordernumber = 'P200504113501514' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300205'
                WHERE ordernumber = 'P180504113507252' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388227'
                WHERE ordernumber = 'P180504113556601' 
            
2024-05-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388230'
                WHERE ordernumber = 'P420504113627728' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388228'
                WHERE ordernumber = 'P420504113702643' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119803'
                WHERE ordernumber = 'P190504113923710' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388231'
                WHERE ordernumber = 'P200504114210454' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299553'
                WHERE ordernumber = 'P200504114331358' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388209'
                WHERE ordernumber = 'P180504114434432' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241208'
                WHERE ordernumber = 'P200504114436486' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180504114543490' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388233'
                WHERE ordernumber = 'P200504115048948' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62816'
                WHERE ordernumber = 'P180504115139836' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380347'
                WHERE ordernumber = 'P200504115150973' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388234'
                WHERE ordernumber = 'P180504115325879' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272737'
                WHERE ordernumber = 'P180504115358919' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387945'
                WHERE ordernumber = 'P420504115429331' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388235'
                WHERE ordernumber = 'P630504115609786' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388236'
                WHERE ordernumber = 'P180504115629498' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388238'
                WHERE ordernumber = 'P180504120024248' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P420504120038164' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257551'
                WHERE ordernumber = 'P190504120309924' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388239'
                WHERE ordernumber = 'P420504120333686' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386942'
                WHERE ordernumber = 'P420504120419981' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281090'
                WHERE ordernumber = 'P190504120428406' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240185'
                WHERE ordernumber = 'P180504120457297' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P200504121414649' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388243'
                WHERE ordernumber = 'P190504121507720' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388241'
                WHERE ordernumber = 'P180504121511686' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162735'
                WHERE ordernumber = 'P190504121647414' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388241'
                WHERE ordernumber = 'P180504121949677' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238609'
                WHERE ordernumber = 'P180504122933287' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388244'
                WHERE ordernumber = 'P200504123227522' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250776'
                WHERE ordernumber = 'P180504123253190' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388246'
                WHERE ordernumber = 'P180504123936477' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285964'
                WHERE ordernumber = 'P180504124039684' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388247'
                WHERE ordernumber = 'P200504124131142' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344843'
                WHERE ordernumber = 'P180504124237694' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101160'
                WHERE ordernumber = 'P200504124753931' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386094'
                WHERE ordernumber = 'P420504124814975' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385267'
                WHERE ordernumber = 'P180504124832151' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388249'
                WHERE ordernumber = 'P420504124913452' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385207'
                WHERE ordernumber = 'P180504125204773' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388250'
                WHERE ordernumber = 'P180504125853873' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388251'
                WHERE ordernumber = 'P180504130003664' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388252'
                WHERE ordernumber = 'P180504130317790' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388252'
                WHERE ordernumber = 'P180504130401346' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388253'
                WHERE ordernumber = 'P420504130502266' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319478'
                WHERE ordernumber = 'P200504130510550' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388254'
                WHERE ordernumber = 'P420504130932841' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112107'
                WHERE ordernumber = 'P180504130959212' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388256'
                WHERE ordernumber = 'P180504131129420' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208583'
                WHERE ordernumber = 'P180504131414649' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352826'
                WHERE ordernumber = 'P420504131819979' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231490'
                WHERE ordernumber = 'P180504132041845' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142916'
                WHERE ordernumber = 'P200504132057187' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172744'
                WHERE ordernumber = 'P420504132339557' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317938'
                WHERE ordernumber = 'P200504132420940' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300472'
                WHERE ordernumber = 'P180504132508674' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226815'
                WHERE ordernumber = 'P200504132902337' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388257'
                WHERE ordernumber = 'P790504133842930' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346202'
                WHERE ordernumber = 'P420504134017543' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388259'
                WHERE ordernumber = 'P790504134145669' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123697'
                WHERE ordernumber = 'P180504134207967' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388258'
                WHERE ordernumber = 'P790504134222646' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388260'
                WHERE ordernumber = 'P790504134310145' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167906'
                WHERE ordernumber = 'P200504134329597' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353357'
                WHERE ordernumber = 'P200504134728740' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349716'
                WHERE ordernumber = 'P190504134802370' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388262'
                WHERE ordernumber = 'P190504134904336' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388263'
                WHERE ordernumber = 'P200504134959462' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388264'
                WHERE ordernumber = 'P420504135352510' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388261'
                WHERE ordernumber = 'P630504135500249' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388265'
                WHERE ordernumber = 'P190504135536920' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352798'
                WHERE ordernumber = 'P180504135759563' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315387'
                WHERE ordernumber = 'P420504135955713' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246226'
                WHERE ordernumber = 'P200504140752547' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286984'
                WHERE ordernumber = 'P180504141015120' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388266'
                WHERE ordernumber = 'P790504141710551' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388269'
                WHERE ordernumber = 'P180504141825306' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388268'
                WHERE ordernumber = 'P790504141946552' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388270'
                WHERE ordernumber = 'P190504142220424' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294793'
                WHERE ordernumber = 'P200504142224346' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388271'
                WHERE ordernumber = 'P200504142345423' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289253'
                WHERE ordernumber = 'P180504142938949' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388272'
                WHERE ordernumber = 'P180504143109562' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388276'
                WHERE ordernumber = 'P630504143859879' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388277'
                WHERE ordernumber = 'P420504143901733' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259678'
                WHERE ordernumber = 'P180504144556716' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388280'
                WHERE ordernumber = 'P420504144617537' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388279'
                WHERE ordernumber = 'P790504144721827' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388278'
                WHERE ordernumber = 'P200504144742744' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388282'
                WHERE ordernumber = 'P200504144828324' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298817'
                WHERE ordernumber = 'P420504144930682' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267404'
                WHERE ordernumber = 'P200504144953321' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388283'
                WHERE ordernumber = 'P180504145120966' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388285'
                WHERE ordernumber = 'P180504145301660' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302951'
                WHERE ordernumber = 'P190504145353271' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244322'
                WHERE ordernumber = 'P180504145413969' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388287'
                WHERE ordernumber = 'P630504145450489' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388286'
                WHERE ordernumber = 'P790504145513762' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388288'
                WHERE ordernumber = 'P190504145524994' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388289'
                WHERE ordernumber = 'P790504145712438' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388291'
                WHERE ordernumber = 'P420504150036320' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388292'
                WHERE ordernumber = 'P420504150119882' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388294'
                WHERE ordernumber = 'P200504150219681' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388293'
                WHERE ordernumber = 'P180504150229617' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96783'
                WHERE ordernumber = 'P420504150352729' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '185024'
                WHERE ordernumber = 'P200504150412606' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388295'
                WHERE ordernumber = 'P200504150523780' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388294'
                WHERE ordernumber = 'P200504150613957' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388296'
                WHERE ordernumber = 'P420504150649562' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96884'
                WHERE ordernumber = 'P630504150734130' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307071'
                WHERE ordernumber = 'P190504150813203' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388298'
                WHERE ordernumber = 'P180504151133626' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388300'
                WHERE ordernumber = 'P190504151307802' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388299'
                WHERE ordernumber = 'P790504151346695' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115311'
                WHERE ordernumber = 'P790504151552579' 
            
2024-05-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388301'
                WHERE ordernumber = 'P180504151908913' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269551'
                WHERE ordernumber = 'P630504151909349' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384403'
                WHERE ordernumber = 'P420504152125980' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388302'
                WHERE ordernumber = 'P790504152206730' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388303'
                WHERE ordernumber = 'P180504152208133' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115984'
                WHERE ordernumber = 'P190504152241546' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287880'
                WHERE ordernumber = 'P180504152337125' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253538'
                WHERE ordernumber = 'P180504152458362' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388304'
                WHERE ordernumber = 'P200504152606223' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388305'
                WHERE ordernumber = 'P200504152707134' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386737'
                WHERE ordernumber = 'P420504152723339' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388306'
                WHERE ordernumber = 'P180504153050417' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388307'
                WHERE ordernumber = 'P180504153228408' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388281'
                WHERE ordernumber = 'P630504153331187' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310110'
                WHERE ordernumber = 'P190504154037360' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330824'
                WHERE ordernumber = 'P180504154210148' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213893'
                WHERE ordernumber = 'P190504154213934' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209634'
                WHERE ordernumber = 'P420504154225207' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388310'
                WHERE ordernumber = 'P200504154353774' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385004'
                WHERE ordernumber = 'P420504154426929' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379993'
                WHERE ordernumber = 'P200504154547570' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287906'
                WHERE ordernumber = 'P180504154552896' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320894'
                WHERE ordernumber = 'P180504154649991' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388309'
                WHERE ordernumber = 'P190504154924290' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388312'
                WHERE ordernumber = 'P190504155251740' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128867'
                WHERE ordernumber = 'P200504155559805' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '180730'
                WHERE ordernumber = 'P200504155712744' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259729'
                WHERE ordernumber = 'P190504155732165' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388313'
                WHERE ordernumber = 'P180504155928684' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260426'
                WHERE ordernumber = 'P200504160122671' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388315'
                WHERE ordernumber = 'P180504160141721' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388316'
                WHERE ordernumber = 'P180504160712394' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377535'
                WHERE ordernumber = 'P200504160814711' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384421'
                WHERE ordernumber = 'P420504160818955' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319393'
                WHERE ordernumber = 'P420504160900962' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341317'
                WHERE ordernumber = 'P180504161022956' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388317'
                WHERE ordernumber = 'P420504161136748' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112054'
                WHERE ordernumber = 'P200504161242869' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382216'
                WHERE ordernumber = 'P180504161245485' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374703'
                WHERE ordernumber = 'P190504161304362' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140350'
                WHERE ordernumber = 'P630504161441851' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133443'
                WHERE ordernumber = 'P180504161554346' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100070'
                WHERE ordernumber = 'P200504161650366' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388318'
                WHERE ordernumber = 'P180504161737551' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217684'
                WHERE ordernumber = 'P190504161742646' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388319'
                WHERE ordernumber = 'P420504161818651' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388320'
                WHERE ordernumber = 'P420504162113704' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247016'
                WHERE ordernumber = 'P180504162150890' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360096'
                WHERE ordernumber = 'P420504162316498' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333919'
                WHERE ordernumber = 'P180504162450654' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388320'
                WHERE ordernumber = 'P420504162727893' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388321'
                WHERE ordernumber = 'P790504162735943' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388322'
                WHERE ordernumber = 'P180504162753789' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388323'
                WHERE ordernumber = 'P180504162903553' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388324'
                WHERE ordernumber = 'P420504162941453' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233416'
                WHERE ordernumber = 'P190504162953232' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388325'
                WHERE ordernumber = 'P630504163048142' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388326'
                WHERE ordernumber = 'P420504163059956' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388327'
                WHERE ordernumber = 'P180504163153785' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388329'
                WHERE ordernumber = 'P180504163507702' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248311'
                WHERE ordernumber = 'P200504163823934' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244286'
                WHERE ordernumber = 'P200504163940575' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338215'
                WHERE ordernumber = 'P180504164132202' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381714'
                WHERE ordernumber = 'P180504164557589' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217612'
                WHERE ordernumber = 'P190504164636586' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388331'
                WHERE ordernumber = 'P200504165400690' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386570'
                WHERE ordernumber = 'P200504170124773' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351044'
                WHERE ordernumber = 'P200504170214479' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93632'
                WHERE ordernumber = 'P200504170618278' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101028'
                WHERE ordernumber = 'P180504170728376' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '45455'
                WHERE ordernumber = 'P420504170832971' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388333'
                WHERE ordernumber = 'P190504170839502' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382308'
                WHERE ordernumber = 'P420504171142410' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287213'
                WHERE ordernumber = 'P180504171441586' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388334'
                WHERE ordernumber = 'P420504171503615' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388336'
                WHERE ordernumber = 'P180504171741677' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388337'
                WHERE ordernumber = 'P200504171805758' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388339'
                WHERE ordernumber = 'P180504171926763' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312702'
                WHERE ordernumber = 'P190504172013350' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388336'
                WHERE ordernumber = 'P180504172044213' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166285'
                WHERE ordernumber = 'P190504172110582' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350070'
                WHERE ordernumber = 'P180504172234236' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388338'
                WHERE ordernumber = 'P200504172253431' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360115'
                WHERE ordernumber = 'P180504172712343' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238978'
                WHERE ordernumber = 'P180504172951797' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388340'
                WHERE ordernumber = 'P630504173741617' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287807'
                WHERE ordernumber = 'P420504174422716' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388342'
                WHERE ordernumber = 'P420504174607475' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388341'
                WHERE ordernumber = 'P630504174725744' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388345'
                WHERE ordernumber = 'P630504174908496' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388346'
                WHERE ordernumber = 'P790504174937825' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388347'
                WHERE ordernumber = 'P180504175050401' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307297'
                WHERE ordernumber = 'P200504175243445' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388348'
                WHERE ordernumber = 'P630504175314175' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385903'
                WHERE ordernumber = 'P630504175353738' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384566'
                WHERE ordernumber = 'P420504175402764' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '21900'
                WHERE ordernumber = 'P200504175429717' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388332'
                WHERE ordernumber = 'P200504175723564' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315321'
                WHERE ordernumber = 'P420504175930628' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388350'
                WHERE ordernumber = 'P790504180345508' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274684'
                WHERE ordernumber = 'P200504180537729' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216155'
                WHERE ordernumber = 'P420504180554119' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284599'
                WHERE ordernumber = 'P200504180837618' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388352'
                WHERE ordernumber = 'P420504180922666' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368169'
                WHERE ordernumber = 'P180504180931972' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388353'
                WHERE ordernumber = 'P180504181107153' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388354'
                WHERE ordernumber = 'P420504181336201' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388355'
                WHERE ordernumber = 'P180504181916475' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '184980'
                WHERE ordernumber = 'P180504182236130' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388356'
                WHERE ordernumber = 'P190504182305632' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92651'
                WHERE ordernumber = 'P180504182456581' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388357'
                WHERE ordernumber = 'P200504182618223' 
            
2024-05-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388358'
                WHERE ordernumber = 'P630504182653833' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388361'
                WHERE ordernumber = 'P200504182736941' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388359'
                WHERE ordernumber = 'P790504182853540' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388363'
                WHERE ordernumber = 'P190504183317265' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384980'
                WHERE ordernumber = 'P200504183443362' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387533'
                WHERE ordernumber = 'P200504183622909' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P630504183644172' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366344'
                WHERE ordernumber = 'P200504183900198' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388365'
                WHERE ordernumber = 'P200504184044640' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '142203'
                WHERE ordernumber = 'P200504184230756' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348116'
                WHERE ordernumber = 'P190504184249741' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284155'
                WHERE ordernumber = 'P200504184317910' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388366'
                WHERE ordernumber = 'P630504184439795' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '114707'
                WHERE ordernumber = 'P190504184439402' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388367'
                WHERE ordernumber = 'P190504184603754' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388368'
                WHERE ordernumber = 'P190504184801613' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388369'
                WHERE ordernumber = 'P190504185009955' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388370'
                WHERE ordernumber = 'P190504185118495' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388372'
                WHERE ordernumber = 'P200504190304837' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388371'
                WHERE ordernumber = 'P420504190356570' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387955'
                WHERE ordernumber = 'P790504190602441' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386340'
                WHERE ordernumber = 'P590504190756225' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388373'
                WHERE ordernumber = 'P200504190945179' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388374'
                WHERE ordernumber = 'P630504191623463' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343709'
                WHERE ordernumber = 'P190504192949739' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360094'
                WHERE ordernumber = 'P190504193815269' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388375'
                WHERE ordernumber = 'P790504194121250' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '26076'
                WHERE ordernumber = 'P630504194156236' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388376'
                WHERE ordernumber = 'P190504194434227' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388378'
                WHERE ordernumber = 'P200504195508827' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95975'
                WHERE ordernumber = 'P200504200015483' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388380'
                WHERE ordernumber = 'P630504200833685' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388381'
                WHERE ordernumber = 'P630504202210550' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388382'
                WHERE ordernumber = 'P630504203225922' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388388'
                WHERE ordernumber = 'P630504212203249' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388389'
                WHERE ordernumber = 'P630504212843299' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388390'
                WHERE ordernumber = 'P790504214251813' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388390'
                WHERE ordernumber = 'P790504214502363' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388390'
                WHERE ordernumber = 'P790504214713377' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388391'
                WHERE ordernumber = 'P790504214919125' 
            
2024-05-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388391'
                WHERE ordernumber = 'P790504215612776'