2024-05-12 01:00:02 -- 將會員中心id寫入data-lake
2024-05-12 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-11%';
        
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388885'
                WHERE ordernumber = 'P420511101027131' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389445'
                WHERE ordernumber = 'P630511103346661' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389445'
                WHERE ordernumber = 'P630511103400219' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389446'
                WHERE ordernumber = 'P630511104131317' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389447'
                WHERE ordernumber = 'P630511104515872' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389448'
                WHERE ordernumber = 'P420511105138770' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273681'
                WHERE ordernumber = 'P180511110251201' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345869'
                WHERE ordernumber = 'P180511110452992' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389449'
                WHERE ordernumber = 'P420511110642136' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389443'
                WHERE ordernumber = 'P190511110731116' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275713'
                WHERE ordernumber = 'P190511110830364' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389450'
                WHERE ordernumber = 'P420511110833993' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389451'
                WHERE ordernumber = 'P180511111052940' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100505'
                WHERE ordernumber = 'P200511111209457' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247366'
                WHERE ordernumber = 'P190511111419758' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '157380'
                WHERE ordernumber = 'P190511111730482' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111872'
                WHERE ordernumber = 'P190511112015162' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291484'
                WHERE ordernumber = 'P180511112017919' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389454'
                WHERE ordernumber = 'P180511112106356' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389455'
                WHERE ordernumber = 'P420511112130272' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389453'
                WHERE ordernumber = 'P630511112246697' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '189595'
                WHERE ordernumber = 'P200511112409243' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389456'
                WHERE ordernumber = 'P180511112428177' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '59963'
                WHERE ordernumber = 'P420511112921685' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389457'
                WHERE ordernumber = 'P200511113048208' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389458'
                WHERE ordernumber = 'P200511113455984' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389459'
                WHERE ordernumber = 'P180511113633160' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389461'
                WHERE ordernumber = 'P420511113758430' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355389'
                WHERE ordernumber = 'P190511113911506' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359887'
                WHERE ordernumber = 'P180511114057435' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '145854'
                WHERE ordernumber = 'P200511114229693' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388222'
                WHERE ordernumber = 'P200511114406193' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389462'
                WHERE ordernumber = 'P190511114802936' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107023'
                WHERE ordernumber = 'P200511114812157' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384721'
                WHERE ordernumber = 'P190511114834933' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301528'
                WHERE ordernumber = 'P200511114951539' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355357'
                WHERE ordernumber = 'P180511115116395' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389429'
                WHERE ordernumber = 'P200511115256125' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347214'
                WHERE ordernumber = 'P180511115328526' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209570'
                WHERE ordernumber = 'P190511115429723' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280423'
                WHERE ordernumber = 'P200511115500756' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389464'
                WHERE ordernumber = 'P200511120258221' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389463'
                WHERE ordernumber = 'P180511120342621' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308682'
                WHERE ordernumber = 'P190511120346161' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348934'
                WHERE ordernumber = 'P200511120403466' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389465'
                WHERE ordernumber = 'P200511120547824' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389466'
                WHERE ordernumber = 'P180511120618646' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346928'
                WHERE ordernumber = 'P190511120703285' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308682'
                WHERE ordernumber = 'P180511120811581' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102203'
                WHERE ordernumber = 'P200511120939934' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389469'
                WHERE ordernumber = 'P200511121354734' 
            
2024-05-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389471'
                WHERE ordernumber = 'P630511121723168' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348746'
                WHERE ordernumber = 'P180511121756424' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309158'
                WHERE ordernumber = 'P180511121927392' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389433'
                WHERE ordernumber = 'P420511121939499' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389472'
                WHERE ordernumber = 'P180511122240472' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389472'
                WHERE ordernumber = 'P180511122312375' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388725'
                WHERE ordernumber = 'P180511122556494' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348809'
                WHERE ordernumber = 'P180511122847730' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220080'
                WHERE ordernumber = 'P180511123043676' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389474'
                WHERE ordernumber = 'P180511123703775' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389475'
                WHERE ordernumber = 'P630511124039764' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98509'
                WHERE ordernumber = 'P200511124734288' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389478'
                WHERE ordernumber = 'P200511124922330' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242008'
                WHERE ordernumber = 'P200511125035219' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378763'
                WHERE ordernumber = 'P200511125106351' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344099'
                WHERE ordernumber = 'P420511125204370' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388256'
                WHERE ordernumber = 'P180511125336222' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279640'
                WHERE ordernumber = 'P180511130253456' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389481'
                WHERE ordernumber = 'P200511130412544' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389482'
                WHERE ordernumber = 'P420511130650318' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277274'
                WHERE ordernumber = 'P180511131006920' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306065'
                WHERE ordernumber = 'P180511131122815' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389483'
                WHERE ordernumber = 'P180511132300262' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389484'
                WHERE ordernumber = 'P420511132329611' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389485'
                WHERE ordernumber = 'P200511132805819' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169514'
                WHERE ordernumber = 'P180511132806972' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389487'
                WHERE ordernumber = 'P180511132929580' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389488'
                WHERE ordernumber = 'P630511133005399' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114320'
                WHERE ordernumber = 'P180511133040174' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389490'
                WHERE ordernumber = 'P200511133258566' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298003'
                WHERE ordernumber = 'P180511133436734' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103996'
                WHERE ordernumber = 'P190511133703906' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389113'
                WHERE ordernumber = 'P420511133731417' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379469'
                WHERE ordernumber = 'P200511134029570' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389492'
                WHERE ordernumber = 'P180511134030239' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '195313'
                WHERE ordernumber = 'P180511134522661' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348662'
                WHERE ordernumber = 'P420511135432164' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389494'
                WHERE ordernumber = 'P420511135852500' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383944'
                WHERE ordernumber = 'P420511140126909' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '195313'
                WHERE ordernumber = 'P180511140250276' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389496'
                WHERE ordernumber = 'P180511141126124' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313949'
                WHERE ordernumber = 'P180511141229111' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164340'
                WHERE ordernumber = 'P200511141253541' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '19426'
                WHERE ordernumber = 'P590511141339505' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81932'
                WHERE ordernumber = 'P190511141442226' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389489'
                WHERE ordernumber = 'P630511141500820' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101791'
                WHERE ordernumber = 'P200511141836699' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389499'
                WHERE ordernumber = 'P180511142057609' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389501'
                WHERE ordernumber = 'P420511142446354' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389502'
                WHERE ordernumber = 'P420511142835658' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224008'
                WHERE ordernumber = 'P200511143234241' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389504'
                WHERE ordernumber = 'P180511143316415' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357924'
                WHERE ordernumber = 'P200511143346880' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389505'
                WHERE ordernumber = 'P180511143434903' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389506'
                WHERE ordernumber = 'P200511143520193' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384776'
                WHERE ordernumber = 'P420511143631728' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389507'
                WHERE ordernumber = 'P180511143749250' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62031'
                WHERE ordernumber = 'P590511143854998' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296750'
                WHERE ordernumber = 'P420511144447873' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280175'
                WHERE ordernumber = 'P200511144932156' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235176'
                WHERE ordernumber = 'P180511145209735' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389508'
                WHERE ordernumber = 'P180511145648259' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230861'
                WHERE ordernumber = 'P200511145715794' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278509'
                WHERE ordernumber = 'P420511145805808' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389510'
                WHERE ordernumber = 'P180511145852864' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278509'
                WHERE ordernumber = 'P420511145942744' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229649'
                WHERE ordernumber = 'P180511150048532' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250599'
                WHERE ordernumber = 'P180511150358809' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389511'
                WHERE ordernumber = 'P190511150552139' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249575'
                WHERE ordernumber = 'P190511150645805' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389509'
                WHERE ordernumber = 'P790511150749853' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346778'
                WHERE ordernumber = 'P420511150810650' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '91003'
                WHERE ordernumber = 'P180511150925452' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309033'
                WHERE ordernumber = 'P180511151225869' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249575'
                WHERE ordernumber = 'P190511151242710' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389515'
                WHERE ordernumber = 'P630511151642784' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389513'
                WHERE ordernumber = 'P630511151723784' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389516'
                WHERE ordernumber = 'P420511151804847' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389517'
                WHERE ordernumber = 'P200511152027639' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389518'
                WHERE ordernumber = 'P630511152234931' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389520'
                WHERE ordernumber = 'P200511152434236' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389521'
                WHERE ordernumber = 'P630511152923846' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389522'
                WHERE ordernumber = 'P200511153125929' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389524'
                WHERE ordernumber = 'P420511153354560' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389523'
                WHERE ordernumber = 'P200511153506631' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299664'
                WHERE ordernumber = 'P180511153816364' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389526'
                WHERE ordernumber = 'P180511154112404' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389527'
                WHERE ordernumber = 'P180511154203294' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386445'
                WHERE ordernumber = 'P420511154651346' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389528'
                WHERE ordernumber = 'P180511154720140' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389529'
                WHERE ordernumber = 'P420511155051958' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389530'
                WHERE ordernumber = 'P180511155135583' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389531'
                WHERE ordernumber = 'P180511155327867' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341896'
                WHERE ordernumber = 'P420511155330327' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360175'
                WHERE ordernumber = 'P180511155936175' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '58538'
                WHERE ordernumber = 'P420511160118995' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303566'
                WHERE ordernumber = 'P630511160148543' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287880'
                WHERE ordernumber = 'P190511160237529' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365728'
                WHERE ordernumber = 'P180511160245335' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283926'
                WHERE ordernumber = 'P180511160456915' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314020'
                WHERE ordernumber = 'P200511160547823' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279333'
                WHERE ordernumber = 'P200511160847965' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291075'
                WHERE ordernumber = 'P180511161030714' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277987'
                WHERE ordernumber = 'P190511162042777' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339378'
                WHERE ordernumber = 'P420511162157870' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95975'
                WHERE ordernumber = 'P190511162345429' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389535'
                WHERE ordernumber = 'P420511162349622' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206649'
                WHERE ordernumber = 'P180511162812281' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '91736'
                WHERE ordernumber = 'P200511163205464' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386150'
                WHERE ordernumber = 'P200511163315124' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389537'
                WHERE ordernumber = 'P190511163331877' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389538'
                WHERE ordernumber = 'P420511163357215' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389540'
                WHERE ordernumber = 'P190511163451701' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389539'
                WHERE ordernumber = 'P180511163512775' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389542'
                WHERE ordernumber = 'P190511163545881' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389543'
                WHERE ordernumber = 'P180511163646388' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342528'
                WHERE ordernumber = 'P200511163659230' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296575'
                WHERE ordernumber = 'P180511163905667' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389542'
                WHERE ordernumber = 'P190511163940173' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142367'
                WHERE ordernumber = 'P200511164224829' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389544'
                WHERE ordernumber = 'P420511164305194' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369262'
                WHERE ordernumber = 'P630511164348431' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389545'
                WHERE ordernumber = 'P190511164406685' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344815'
                WHERE ordernumber = 'P200511164433619' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389079'
                WHERE ordernumber = 'P790511164532630' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389546'
                WHERE ordernumber = 'P200511164802843' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389547'
                WHERE ordernumber = 'P420511164817275' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389548'
                WHERE ordernumber = 'P420511165239214' 
            
2024-05-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389549'
                WHERE ordernumber = 'P420511165537757' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363474'
                WHERE ordernumber = 'P420511165654534' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '78830'
                WHERE ordernumber = 'P200511165820864' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315806'
                WHERE ordernumber = 'P180511165832283' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389551'
                WHERE ordernumber = 'P180511170401579' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240882'
                WHERE ordernumber = 'P200511170435622' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118575'
                WHERE ordernumber = 'P180511170635161' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389552'
                WHERE ordernumber = 'P180511171038923' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389131'
                WHERE ordernumber = 'P200511171058219' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230315'
                WHERE ordernumber = 'P180511171451505' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100914'
                WHERE ordernumber = 'P200511171528445' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389553'
                WHERE ordernumber = 'P790511171852577' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389554'
                WHERE ordernumber = 'P630511172018184' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350828'
                WHERE ordernumber = 'P200511172019560' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230315'
                WHERE ordernumber = 'P180511172134374' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389556'
                WHERE ordernumber = 'P200511172350383' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389557'
                WHERE ordernumber = 'P200511172449113' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388580'
                WHERE ordernumber = 'P180511172537294' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389558'
                WHERE ordernumber = 'P790511172908674' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243027'
                WHERE ordernumber = 'P180511173338926' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283096'
                WHERE ordernumber = 'P200511173353335' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389559'
                WHERE ordernumber = 'P420511173430924' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389560'
                WHERE ordernumber = 'P630511173533281' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389559'
                WHERE ordernumber = 'P420511173558923' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389561'
                WHERE ordernumber = 'P200511174135488' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389562'
                WHERE ordernumber = 'P180511174744513' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389563'
                WHERE ordernumber = 'P200511175029735' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343629'
                WHERE ordernumber = 'P200511175115306' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289992'
                WHERE ordernumber = 'P200511175233599' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389565'
                WHERE ordernumber = 'P190511175327686' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389569'
                WHERE ordernumber = 'P190511175441561' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389567'
                WHERE ordernumber = 'P200511175448784' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389568'
                WHERE ordernumber = 'P630511175510308' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389565'
                WHERE ordernumber = 'P190511175519999' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389571'
                WHERE ordernumber = 'P180511175533764' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389572'
                WHERE ordernumber = 'P190511175649749' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389573'
                WHERE ordernumber = 'P180511175708931' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389566'
                WHERE ordernumber = 'P790511175732849' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389574'
                WHERE ordernumber = 'P200511175840164' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389575'
                WHERE ordernumber = 'P420511180154152' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '60663'
                WHERE ordernumber = 'P790511180342294' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389570'
                WHERE ordernumber = 'P420511180351573' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389576'
                WHERE ordernumber = 'P630511180412970' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389577'
                WHERE ordernumber = 'P180511180514251' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389564'
                WHERE ordernumber = 'P190511180528151' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389578'
                WHERE ordernumber = 'P420511180604376' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352298'
                WHERE ordernumber = 'P180511180700934' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389579'
                WHERE ordernumber = 'P420511180728896' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369218'
                WHERE ordernumber = 'P420511180851277' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389580'
                WHERE ordernumber = 'P630511181006909' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389581'
                WHERE ordernumber = 'P420511181353404' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389582'
                WHERE ordernumber = 'P180511181729169' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217923'
                WHERE ordernumber = 'P190511181939874' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325206'
                WHERE ordernumber = 'P630511182032695' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343583'
                WHERE ordernumber = 'P180511182039721' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389584'
                WHERE ordernumber = 'P200511182254994' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389585'
                WHERE ordernumber = 'P180511182431935' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389587'
                WHERE ordernumber = 'P180511184043494' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292049'
                WHERE ordernumber = 'P790511184454620' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389586'
                WHERE ordernumber = 'P200511184622842' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '58538'
                WHERE ordernumber = 'P420511184823566' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384725'
                WHERE ordernumber = 'P190511185003617' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389589'
                WHERE ordernumber = 'P420511185003957' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389590'
                WHERE ordernumber = 'P200511185133325' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389210'
                WHERE ordernumber = 'P200511185208891' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389591'
                WHERE ordernumber = 'P200511185535246' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389592'
                WHERE ordernumber = 'P190511185941937' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '194358'
                WHERE ordernumber = 'P200511190001860' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389593'
                WHERE ordernumber = 'P190511190116710' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389594'
                WHERE ordernumber = 'P420511190438513' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300038'
                WHERE ordernumber = 'P200511190637666' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389595'
                WHERE ordernumber = 'P200511190750166' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389596'
                WHERE ordernumber = 'P420511190832945' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389597'
                WHERE ordernumber = 'P200511191534215' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389598'
                WHERE ordernumber = 'P420511191628257' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219240'
                WHERE ordernumber = 'P200511192002392' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389600'
                WHERE ordernumber = 'P190511192716401' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389601'
                WHERE ordernumber = 'P200511193112129' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284198'
                WHERE ordernumber = 'P190511194112496' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256160'
                WHERE ordernumber = 'P200511194347238' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '16688'
                WHERE ordernumber = 'P630511194451694' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284853'
                WHERE ordernumber = 'P200511194545881' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336902'
                WHERE ordernumber = 'P200511194647200' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389602'
                WHERE ordernumber = 'P200511194738710' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295942'
                WHERE ordernumber = 'P200511194830201' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265506'
                WHERE ordernumber = 'P190511194903514' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264678'
                WHERE ordernumber = 'P790511195419550' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '67950'
                WHERE ordernumber = 'P420511195541685' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241954'
                WHERE ordernumber = 'P190511200035628' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389605'
                WHERE ordernumber = 'P790511203313899' 
            
2024-05-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389606'
                WHERE ordernumber = 'P630511203319234'