2024-07-21 01:00:03 -- 將會員中心id寫入data-lake
2024-07-21 01:00:03 -- 
            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-07-20%';
        
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400030'
                WHERE ordernumber = 'P180720110224710' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363165'
                WHERE ordernumber = 'P420720110233171' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395164'
                WHERE ordernumber = 'P420720110359300' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399279'
                WHERE ordernumber = 'P420720110602228' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402156'
                WHERE ordernumber = 'P200720110630981' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401060'
                WHERE ordernumber = 'P180720111059392' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299936'
                WHERE ordernumber = 'P190720111147994' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392331'
                WHERE ordernumber = 'P180720111215701' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402159'
                WHERE ordernumber = 'P200720111621757' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402161'
                WHERE ordernumber = 'P180720111947138' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402162'
                WHERE ordernumber = 'P180720112137184' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95016'
                WHERE ordernumber = 'P180720112353693' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332133'
                WHERE ordernumber = 'P200720112409477' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400089'
                WHERE ordernumber = 'P180720112538856' 
            
2024-07-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275706'
                WHERE ordernumber = 'P180720112946501' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348964'
                WHERE ordernumber = 'P180720113137254' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380575'
                WHERE ordernumber = 'P200720113455786' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402165'
                WHERE ordernumber = 'P420720113533148' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348261'
                WHERE ordernumber = 'P180720113533817' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402167'
                WHERE ordernumber = 'P180720114201443' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402166'
                WHERE ordernumber = 'P200720114410828' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402168'
                WHERE ordernumber = 'P180720114433121' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402169'
                WHERE ordernumber = 'P420720114521692' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402148'
                WHERE ordernumber = 'P200720114542830' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402148'
                WHERE ordernumber = 'P200720114616939' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402170'
                WHERE ordernumber = 'P420720114635851' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348046'
                WHERE ordernumber = 'P180720114649664' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402171'
                WHERE ordernumber = 'P190720114739437' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167240'
                WHERE ordernumber = 'P190720115313143' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384721'
                WHERE ordernumber = 'P180720115450700' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402173'
                WHERE ordernumber = 'P200720115650855' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220173'
                WHERE ordernumber = 'P190720115710566' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393929'
                WHERE ordernumber = 'P200720121010396' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384241'
                WHERE ordernumber = 'P180720121522834' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402176'
                WHERE ordernumber = 'P420720122133503' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249896'
                WHERE ordernumber = 'P180720122433458' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235053'
                WHERE ordernumber = 'P190720122501240' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272136'
                WHERE ordernumber = 'P420720122510433' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348677'
                WHERE ordernumber = 'P180720123510958' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402174'
                WHERE ordernumber = 'P180720123539379' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402174'
                WHERE ordernumber = 'P180720123622739' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108125'
                WHERE ordernumber = 'P180720123741372' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402179'
                WHERE ordernumber = 'P200720124049908' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402180'
                WHERE ordernumber = 'P420720124241745' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '191090'
                WHERE ordernumber = 'P200720124333707' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402181'
                WHERE ordernumber = 'P190720124949558' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402183'
                WHERE ordernumber = 'P200720125040803' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402184'
                WHERE ordernumber = 'P200720125445505' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402185'
                WHERE ordernumber = 'P200720125550163' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226754'
                WHERE ordernumber = 'P180720125756899' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400656'
                WHERE ordernumber = 'P200720130055857' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402186'
                WHERE ordernumber = 'P180720130110395' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395582'
                WHERE ordernumber = 'P420720130311566' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389478'
                WHERE ordernumber = 'P200720130414960' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375539'
                WHERE ordernumber = 'P420720130756922' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402188'
                WHERE ordernumber = 'P180720131219691' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402189'
                WHERE ordernumber = 'P180720131534432' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402190'
                WHERE ordernumber = 'P190720131750582' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126351'
                WHERE ordernumber = 'P180720131751599' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402187'
                WHERE ordernumber = 'P180720131815703' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402191'
                WHERE ordernumber = 'P420720132101552' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '84253'
                WHERE ordernumber = 'P180720132101583' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '84253'
                WHERE ordernumber = 'P180720132611692' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121744'
                WHERE ordernumber = 'P180720133149446' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363317'
                WHERE ordernumber = 'P200720133406445' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '65865'
                WHERE ordernumber = 'P190720133525180' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402193'
                WHERE ordernumber = 'P180720133648165' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402194'
                WHERE ordernumber = 'P200720133658927' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387819'
                WHERE ordernumber = 'P200720133748919' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402195'
                WHERE ordernumber = 'P180720133812927' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402196'
                WHERE ordernumber = 'P200720133943363' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402197'
                WHERE ordernumber = 'P190720134143135' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397430'
                WHERE ordernumber = 'P420720134212688' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401277'
                WHERE ordernumber = 'P180720134439982' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402198'
                WHERE ordernumber = 'P190720134835637' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402199'
                WHERE ordernumber = 'P180720135151254' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401657'
                WHERE ordernumber = 'P190720135233375' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402200'
                WHERE ordernumber = 'P180720135702657' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312525'
                WHERE ordernumber = 'P200720140136157' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '13235'
                WHERE ordernumber = 'P200720140240124' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402201'
                WHERE ordernumber = 'P420720140326500' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402202'
                WHERE ordernumber = 'P200720140401712' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402114'
                WHERE ordernumber = 'P200720140802496' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402202'
                WHERE ordernumber = 'P200720141024869' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402204'
                WHERE ordernumber = 'P180720141557382' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120508'
                WHERE ordernumber = 'P200720141703623' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384453'
                WHERE ordernumber = 'P180720141804787' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180720141933604' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359823'
                WHERE ordernumber = 'P200720141939474' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402205'
                WHERE ordernumber = 'P200720142317610' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402206'
                WHERE ordernumber = 'P420720142449409' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402207'
                WHERE ordernumber = 'P200720142537858' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402208'
                WHERE ordernumber = 'P420720143223979' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364448'
                WHERE ordernumber = 'P420720143802262' 
            
2024-07-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402210'
                WHERE ordernumber = 'P180720144000910' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394713'
                WHERE ordernumber = 'P420720144434220' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389490'
                WHERE ordernumber = 'P200720144642898' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401958'
                WHERE ordernumber = 'P180720144935655' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402211'
                WHERE ordernumber = 'P180720144956647' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402215'
                WHERE ordernumber = 'P420720150239936' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402214'
                WHERE ordernumber = 'P180720150244832' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402213'
                WHERE ordernumber = 'P200720150256208' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402215'
                WHERE ordernumber = 'P420720150336281' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402217'
                WHERE ordernumber = 'P180720150430387' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402218'
                WHERE ordernumber = 'P180720150950145' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '324062'
                WHERE ordernumber = 'P190720151132599' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402220'
                WHERE ordernumber = 'P420720151254962' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402221'
                WHERE ordernumber = 'P180720151358295' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402222'
                WHERE ordernumber = 'P420720151536900' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339950'
                WHERE ordernumber = 'P420720152142259' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396134'
                WHERE ordernumber = 'P200720152513693' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391904'
                WHERE ordernumber = 'P190720152634580' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402225'
                WHERE ordernumber = 'P420720152657555' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '151323'
                WHERE ordernumber = 'P180720152725656' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402225'
                WHERE ordernumber = 'P420720152735220' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399498'
                WHERE ordernumber = 'P190720152803235' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '328917'
                WHERE ordernumber = 'P420720152902710' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '260310'
                WHERE ordernumber = 'P200720152917465' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402227'
                WHERE ordernumber = 'P190720153006409' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401780'
                WHERE ordernumber = 'P200720153128754' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102862'
                WHERE ordernumber = 'P180720153250256' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392501'
                WHERE ordernumber = 'P200720153310942' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402228'
                WHERE ordernumber = 'P420720153621940' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '376353'
                WHERE ordernumber = 'P180720153802811' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402229'
                WHERE ordernumber = 'P190720153852954' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402230'
                WHERE ordernumber = 'P420720153945345' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402231'
                WHERE ordernumber = 'P420720154119888' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402232'
                WHERE ordernumber = 'P190720154601715' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357689'
                WHERE ordernumber = 'P200720154723750' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338504'
                WHERE ordernumber = 'P180720155242602' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160711'
                WHERE ordernumber = 'P200720155352510' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379326'
                WHERE ordernumber = 'P420720155429586' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402234'
                WHERE ordernumber = 'P180720155533575' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402235'
                WHERE ordernumber = 'P200720155617233' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402237'
                WHERE ordernumber = 'P180720160400238' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287234'
                WHERE ordernumber = 'P200720160415206' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402238'
                WHERE ordernumber = 'P180720160516825' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402239'
                WHERE ordernumber = 'P180720160818796' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '326943'
                WHERE ordernumber = 'P180720161104165' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254395'
                WHERE ordernumber = 'P190720161255371' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402243'
                WHERE ordernumber = 'P190720161447810' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '189763'
                WHERE ordernumber = 'P180720161610725' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402244'
                WHERE ordernumber = 'P420720161724115' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394913'
                WHERE ordernumber = 'P200720161840740' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402246'
                WHERE ordernumber = 'P420720161928863' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387945'
                WHERE ordernumber = 'P420720162019567' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402247'
                WHERE ordernumber = 'P200720162031639' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402248'
                WHERE ordernumber = 'P180720162610457' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '142727'
                WHERE ordernumber = 'P190720162633711' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273977'
                WHERE ordernumber = 'P180720163138330' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '256489'
                WHERE ordernumber = 'P200720163159758' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402250'
                WHERE ordernumber = 'P420720163206794' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398435'
                WHERE ordernumber = 'P200720163417644' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '136062'
                WHERE ordernumber = 'P190720163854633' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402253'
                WHERE ordernumber = 'P180720163904400' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '153282'
                WHERE ordernumber = 'P190720164049120' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402252'
                WHERE ordernumber = 'P180720164120558' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400543'
                WHERE ordernumber = 'P190720164343319' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402254'
                WHERE ordernumber = 'P180720164718494' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303945'
                WHERE ordernumber = 'P200720164757270' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402255'
                WHERE ordernumber = 'P180720164859880' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397556'
                WHERE ordernumber = 'P190720164909136' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402254'
                WHERE ordernumber = 'P180720164953540' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402256'
                WHERE ordernumber = 'P180720165401796' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402258'
                WHERE ordernumber = 'P200720170127726' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387045'
                WHERE ordernumber = 'P180720170226119' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402258'
                WHERE ordernumber = 'P200720170346753' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402259'
                WHERE ordernumber = 'P180720170508704' 
            
2024-07-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228511'
                WHERE ordernumber = 'P180720170823124' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402162'
                WHERE ordernumber = 'P190720170932216' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '303900'
                WHERE ordernumber = 'P180720170946435' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402261'
                WHERE ordernumber = 'P200720170954404' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402260'
                WHERE ordernumber = 'P190720171113388' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '380901'
                WHERE ordernumber = 'P420720171339213' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '374695'
                WHERE ordernumber = 'P190720171450915' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402263'
                WHERE ordernumber = 'P190720171644217' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402262'
                WHERE ordernumber = 'P180720171717838' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '231451'
                WHERE ordernumber = 'P180720171834618' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '359823'
                WHERE ordernumber = 'P200720172201399' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402265'
                WHERE ordernumber = 'P180720172307293' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402266'
                WHERE ordernumber = 'P180720172608472' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '111805'
                WHERE ordernumber = 'P190720172650854' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402267'
                WHERE ordernumber = 'P180720172819482' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '207207'
                WHERE ordernumber = 'P190720172945913' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '254476'
                WHERE ordernumber = 'P200720173015180' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '207207'
                WHERE ordernumber = 'P190720173217523' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '375751'
                WHERE ordernumber = 'P180720173305813' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402270'
                WHERE ordernumber = 'P200720173436724' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '220125'
                WHERE ordernumber = 'P180720173503930' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402269'
                WHERE ordernumber = 'P180720173555663' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '285282'
                WHERE ordernumber = 'P190720173815457' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402271'
                WHERE ordernumber = 'P180720174044337' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '214193'
                WHERE ordernumber = 'P180720174236844' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402272'
                WHERE ordernumber = 'P180720174454763' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402273'
                WHERE ordernumber = 'P420720174751691' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402274'
                WHERE ordernumber = 'P190720175132707' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '393892'
                WHERE ordernumber = 'P420720175313809' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '270378'
                WHERE ordernumber = 'P200720175331562' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402275'
                WHERE ordernumber = 'P180720175416236' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402276'
                WHERE ordernumber = 'P180720175602380' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '317784'
                WHERE ordernumber = 'P420720175602370' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402277'
                WHERE ordernumber = 'P420720175737135' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402278'
                WHERE ordernumber = 'P420720175833351' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402279'
                WHERE ordernumber = 'P420720180006928' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '126828'
                WHERE ordernumber = 'P180720180432358' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '362075'
                WHERE ordernumber = 'P420720180452665' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402280'
                WHERE ordernumber = 'P190720180538661' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '277987'
                WHERE ordernumber = 'P190720180655684' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402281'
                WHERE ordernumber = 'P180720180751604' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '261033'
                WHERE ordernumber = 'P200720180759484' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '364063'
                WHERE ordernumber = 'P200720181020733' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402282'
                WHERE ordernumber = 'P420720181045376' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399775'
                WHERE ordernumber = 'P200720181621989' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402285'
                WHERE ordernumber = 'P420720182521146' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358902'
                WHERE ordernumber = 'P630720183000853' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402287'
                WHERE ordernumber = 'P180720183021485' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401888'
                WHERE ordernumber = 'P420720183212715' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '297030'
                WHERE ordernumber = 'P420720183419965' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '96007'
                WHERE ordernumber = 'P180720184123616' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '96007'
                WHERE ordernumber = 'P180720184158879' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402288'
                WHERE ordernumber = 'P200720184358559' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '388816'
                WHERE ordernumber = 'P420720184550943' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '94980'
                WHERE ordernumber = 'P190720184847498' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '311545'
                WHERE ordernumber = 'P190720185100296' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '133037'
                WHERE ordernumber = 'P200720185107340' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399593'
                WHERE ordernumber = 'P200720185531997' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '367218'
                WHERE ordernumber = 'P190720190754730' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402293'
                WHERE ordernumber = 'P190720191313165' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402294'
                WHERE ordernumber = 'P190720191500847' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402295'
                WHERE ordernumber = 'P190720191551238' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402296'
                WHERE ordernumber = 'P190720191652561' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402298'
                WHERE ordernumber = 'P190720192242181' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '360338'
                WHERE ordernumber = 'P190720192450488' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402299'
                WHERE ordernumber = 'P190720192641650' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '302915'
                WHERE ordernumber = 'P190720192804293' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '99043'
                WHERE ordernumber = 'P190720193119580' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '27793'
                WHERE ordernumber = 'P190720193341858' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402301'
                WHERE ordernumber = 'P200720193449515' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402302'
                WHERE ordernumber = 'P200720193632538' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '395031'
                WHERE ordernumber = 'P190720193657499' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402303'
                WHERE ordernumber = 'P190720193944861' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '212551'
                WHERE ordernumber = 'P190720194528170' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '321118'
                WHERE ordernumber = 'P190720194950210' 
            
2024-07-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '332698'
                WHERE ordernumber = 'P190720195437583' 
            
2024-07-21 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '350157'
                WHERE ordernumber = 'P190720195551952' 
            
2024-07-21 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '334136'
                WHERE ordernumber = 'P200720195733773'