2024-06-16 01:00:03 -- 將會員中心id寫入data-lake
2024-06-16 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-06-15%';
        
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273591'
                WHERE ordernumber = 'P200615110217258' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363369'
                WHERE ordernumber = 'P200615110339208' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365962'
                WHERE ordernumber = 'P200615110428947' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396071'
                WHERE ordernumber = 'P180615110446321' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379263'
                WHERE ordernumber = 'P420615110930279' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384673'
                WHERE ordernumber = 'P200615111058169' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376279'
                WHERE ordernumber = 'P180615111128142' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223893'
                WHERE ordernumber = 'P190615111327600' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396072'
                WHERE ordernumber = 'P180615111409656' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387822'
                WHERE ordernumber = 'P420615111432330' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '185989'
                WHERE ordernumber = 'P200615111608221' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396074'
                WHERE ordernumber = 'P420615111848404' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396075'
                WHERE ordernumber = 'P180615111937181' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251706'
                WHERE ordernumber = 'P420615112007798' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380016'
                WHERE ordernumber = 'P200615112109526' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396076'
                WHERE ordernumber = 'P420615112258135' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141480'
                WHERE ordernumber = 'P180615112424609' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252474'
                WHERE ordernumber = 'P190615112518542' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396077'
                WHERE ordernumber = 'P420615112830608' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396079'
                WHERE ordernumber = 'P180615113105199' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396080'
                WHERE ordernumber = 'P190615113732699' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244761'
                WHERE ordernumber = 'P180615113955146' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210683'
                WHERE ordernumber = 'P190615114223733' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396081'
                WHERE ordernumber = 'P180615114228313' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396082'
                WHERE ordernumber = 'P200615115203173' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219813'
                WHERE ordernumber = 'P200615115316288' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396083'
                WHERE ordernumber = 'P180615115330273' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396084'
                WHERE ordernumber = 'P190615115344354' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396085'
                WHERE ordernumber = 'P200615115545337' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366041'
                WHERE ordernumber = 'P420615115806227' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396086'
                WHERE ordernumber = 'P180615115945783' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393290'
                WHERE ordernumber = 'P420615120448935' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103270'
                WHERE ordernumber = 'P200615120642679' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395115'
                WHERE ordernumber = 'P200615120855468' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396088'
                WHERE ordernumber = 'P190615121321922' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394765'
                WHERE ordernumber = 'P200615121325139' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277235'
                WHERE ordernumber = 'P190615121649964' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396089'
                WHERE ordernumber = 'P420615122049828' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180615123741318' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396092'
                WHERE ordernumber = 'P420615124752637' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312240'
                WHERE ordernumber = 'P200615125017895' 
            
2024-06-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396094'
                WHERE ordernumber = 'P420615125401866' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81985'
                WHERE ordernumber = 'P420615125623874' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306875'
                WHERE ordernumber = 'P180615125720889' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394739'
                WHERE ordernumber = 'P420615125828454' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396095'
                WHERE ordernumber = 'P200615125905388' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396096'
                WHERE ordernumber = 'P190615130038281' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359921'
                WHERE ordernumber = 'P180615130059544' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296517'
                WHERE ordernumber = 'P180615130323619' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396097'
                WHERE ordernumber = 'P190615130613818' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113525'
                WHERE ordernumber = 'P420615130947959' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396098'
                WHERE ordernumber = 'P200615131112533' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312970'
                WHERE ordernumber = 'P420615131559541' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396099'
                WHERE ordernumber = 'P200615131828216' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346151'
                WHERE ordernumber = 'P200615131906834' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92895'
                WHERE ordernumber = 'P420615132415366' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92895'
                WHERE ordernumber = 'P420615132734171' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95013'
                WHERE ordernumber = 'P190615132817737' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395127'
                WHERE ordernumber = 'P200615133052842' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396100'
                WHERE ordernumber = 'P190615133155404' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396101'
                WHERE ordernumber = 'P180615134039271' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396102'
                WHERE ordernumber = 'P200615134211737' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233959'
                WHERE ordernumber = 'P200615134422362' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266349'
                WHERE ordernumber = 'P420615134443249' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279068'
                WHERE ordernumber = 'P200615134529708' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '48823'
                WHERE ordernumber = 'P420615134616301' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396103'
                WHERE ordernumber = 'P180615134657669' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396104'
                WHERE ordernumber = 'P200615135113822' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384055'
                WHERE ordernumber = 'P200615135303314' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108131'
                WHERE ordernumber = 'P420615135725698' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117099'
                WHERE ordernumber = 'P180615135759485' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304306'
                WHERE ordernumber = 'P190615140030959' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '6464'
                WHERE ordernumber = 'P200615140119286' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396105'
                WHERE ordernumber = 'P180615140214652' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396106'
                WHERE ordernumber = 'P420615140411917' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396107'
                WHERE ordernumber = 'P180615140456631' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396108'
                WHERE ordernumber = 'P190615140639583' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396109'
                WHERE ordernumber = 'P180615140643298' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396110'
                WHERE ordernumber = 'P180615140906917' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395127'
                WHERE ordernumber = 'P200615141240523' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396111'
                WHERE ordernumber = 'P420615141348279' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396112'
                WHERE ordernumber = 'P420615141643118' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396113'
                WHERE ordernumber = 'P420615142222630' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230555'
                WHERE ordernumber = 'P420615142551914' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396115'
                WHERE ordernumber = 'P200615143043574' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396116'
                WHERE ordernumber = 'P180615143405121' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '54862'
                WHERE ordernumber = 'P420615143537175' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396118'
                WHERE ordernumber = 'P420615143702776' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396119'
                WHERE ordernumber = 'P180615143936117' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P190615144138919' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379174'
                WHERE ordernumber = 'P200615144458682' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395143'
                WHERE ordernumber = 'P180615144459816' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396121'
                WHERE ordernumber = 'P200615144626390' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391150'
                WHERE ordernumber = 'P200615144733452' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396122'
                WHERE ordernumber = 'P180615144816527' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384754'
                WHERE ordernumber = 'P200615145123785' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316282'
                WHERE ordernumber = 'P180615145125281' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384754'
                WHERE ordernumber = 'P200615145213578' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384754'
                WHERE ordernumber = 'P200615145253940' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246001'
                WHERE ordernumber = 'P200615145351723' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396123'
                WHERE ordernumber = 'P200615145451762' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396124'
                WHERE ordernumber = 'P180615145921621' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394302'
                WHERE ordernumber = 'P180615150127696' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396125'
                WHERE ordernumber = 'P180615150307457' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395670'
                WHERE ordernumber = 'P200615150322733' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396126'
                WHERE ordernumber = 'P420615151033195' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396127'
                WHERE ordernumber = 'P180615151248439' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129743'
                WHERE ordernumber = 'P420615151757665' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386619'
                WHERE ordernumber = 'P200615151942805' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396128'
                WHERE ordernumber = 'P420615152016394' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394302'
                WHERE ordernumber = 'P180615152024847' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140663'
                WHERE ordernumber = 'P190615152044278' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94815'
                WHERE ordernumber = 'P200615152245528' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247205'
                WHERE ordernumber = 'P180615152452482' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396129'
                WHERE ordernumber = 'P200615152637591' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379221'
                WHERE ordernumber = 'P200615152756339' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396130'
                WHERE ordernumber = 'P180615152905941' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396131'
                WHERE ordernumber = 'P420615153016525' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396132'
                WHERE ordernumber = 'P190615153121303' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395934'
                WHERE ordernumber = 'P420615153151111' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388691'
                WHERE ordernumber = 'P420615153242196' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305057'
                WHERE ordernumber = 'P180615153320496' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97872'
                WHERE ordernumber = 'P200615153514658' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137599'
                WHERE ordernumber = 'P180615153758381' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396134'
                WHERE ordernumber = 'P200615153923405' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396135'
                WHERE ordernumber = 'P180615153955916' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386761'
                WHERE ordernumber = 'P420615154147439' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396136'
                WHERE ordernumber = 'P780615154502307' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396137'
                WHERE ordernumber = 'P180615154532611' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99149'
                WHERE ordernumber = 'P190615154612576' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366205'
                WHERE ordernumber = 'P590615154913964' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111100'
                WHERE ordernumber = 'P180615154924692' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396138'
                WHERE ordernumber = 'P200615155019344' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396139'
                WHERE ordernumber = 'P200615155223673' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396140'
                WHERE ordernumber = 'P180615155307796' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396141'
                WHERE ordernumber = 'P180615155455964' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P190615155508581' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74761'
                WHERE ordernumber = 'P420615155926576' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396142'
                WHERE ordernumber = 'P420615160033849' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169204'
                WHERE ordernumber = 'P180615160159497' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286628'
                WHERE ordernumber = 'P200615160340663' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396144'
                WHERE ordernumber = 'P420615160343246' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396145'
                WHERE ordernumber = 'P420615160632927' 
            
2024-06-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396146'
                WHERE ordernumber = 'P780615160849679' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396144'
                WHERE ordernumber = 'P420615160904603' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396147'
                WHERE ordernumber = 'P420615161019177' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396148'
                WHERE ordernumber = 'P420615161413874' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396139'
                WHERE ordernumber = 'P590615161813870' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350401'
                WHERE ordernumber = 'P420615162729250' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350405'
                WHERE ordernumber = 'P420615162900214' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276776'
                WHERE ordernumber = 'P190615163145399' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369333'
                WHERE ordernumber = 'P180615163242582' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '253817'
                WHERE ordernumber = 'P630615163339717' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394782'
                WHERE ordernumber = 'P180615163741134' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396149'
                WHERE ordernumber = 'P420615163757871' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357629'
                WHERE ordernumber = 'P200615163823231' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396151'
                WHERE ordernumber = 'P180615164219704' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242008'
                WHERE ordernumber = 'P200615164225685' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350293'
                WHERE ordernumber = 'P190615164434295' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98426'
                WHERE ordernumber = 'P200615164839464' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396152'
                WHERE ordernumber = 'P420615164954919' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369692'
                WHERE ordernumber = 'P420615165059232' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396153'
                WHERE ordernumber = 'P200615165123931' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337238'
                WHERE ordernumber = 'P420615165226929' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396154'
                WHERE ordernumber = 'P200615165350337' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297991'
                WHERE ordernumber = 'P630615165419126' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396155'
                WHERE ordernumber = 'P200615165614203' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221443'
                WHERE ordernumber = 'P200615165823483' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388777'
                WHERE ordernumber = 'P180615165926334' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396157'
                WHERE ordernumber = 'P180615170115427' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396156'
                WHERE ordernumber = 'P200615170132818' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396159'
                WHERE ordernumber = 'P420615170300485' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396118'
                WHERE ordernumber = 'P420615170355610' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396160'
                WHERE ordernumber = 'P200615170432907' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '111386'
                WHERE ordernumber = 'P180615170558291' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396161'
                WHERE ordernumber = 'P200615170748722' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '332647'
                WHERE ordernumber = 'P200615170931816' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396158'
                WHERE ordernumber = 'P180615171043373' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396162'
                WHERE ordernumber = 'P200615171211392' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396163'
                WHERE ordernumber = 'P180615171247978' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396164'
                WHERE ordernumber = 'P200615172040818' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '193585'
                WHERE ordernumber = 'P180615172104869' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396165'
                WHERE ordernumber = 'P420615172517320' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382646'
                WHERE ordernumber = 'P420615173207374' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396168'
                WHERE ordernumber = 'P200615173233394' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396167'
                WHERE ordernumber = 'P200615173404710' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396169'
                WHERE ordernumber = 'P200615173450262' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395613'
                WHERE ordernumber = 'P200615173554130' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242609'
                WHERE ordernumber = 'P200615173628559' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353063'
                WHERE ordernumber = 'P180615173643708' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385024'
                WHERE ordernumber = 'P200615173715554' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270879'
                WHERE ordernumber = 'P200615173744962' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396170'
                WHERE ordernumber = 'P200615173829506' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240450'
                WHERE ordernumber = 'P200615174019378' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396171'
                WHERE ordernumber = 'P180615174155649' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266126'
                WHERE ordernumber = 'P180615174347705' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396172'
                WHERE ordernumber = 'P180615174610922' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396173'
                WHERE ordernumber = 'P190615174850151' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396174'
                WHERE ordernumber = 'P180615175132512' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396175'
                WHERE ordernumber = 'P420615175318257' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307381'
                WHERE ordernumber = 'P190615175612416' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396177'
                WHERE ordernumber = 'P180615175814300' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396179'
                WHERE ordernumber = 'P180615180030402' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396176'
                WHERE ordernumber = 'P180615180144781' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396178'
                WHERE ordernumber = 'P180615180230631' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '356858'
                WHERE ordernumber = 'P420615181021644' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394555'
                WHERE ordernumber = 'P180615181037517' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396180'
                WHERE ordernumber = 'P420615181314413' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396181'
                WHERE ordernumber = 'P420615181814650' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '190894'
                WHERE ordernumber = 'P180615181903522' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396182'
                WHERE ordernumber = 'P780615182011566' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160310'
                WHERE ordernumber = 'P200615182016524' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396183'
                WHERE ordernumber = 'P180615182117208' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346807'
                WHERE ordernumber = 'P200615182252490' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396184'
                WHERE ordernumber = 'P180615182514132' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '181527'
                WHERE ordernumber = 'P200615182602237' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305954'
                WHERE ordernumber = 'P200615182813412' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396185'
                WHERE ordernumber = 'P420615182931585' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395761'
                WHERE ordernumber = 'P190615183244186' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314442'
                WHERE ordernumber = 'P200615183344334' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396186'
                WHERE ordernumber = 'P590615183530792' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396186'
                WHERE ordernumber = 'P590615183604893' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263287'
                WHERE ordernumber = 'P180615183709511' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395535'
                WHERE ordernumber = 'P180615184114620' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380028'
                WHERE ordernumber = 'P200615184119955' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396187'
                WHERE ordernumber = 'P200615184245266' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396189'
                WHERE ordernumber = 'P420615184956339' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104446'
                WHERE ordernumber = 'P180615185408728' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396190'
                WHERE ordernumber = 'P190615185448790' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396191'
                WHERE ordernumber = 'P420615185604424' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '120263'
                WHERE ordernumber = 'P190615185613802' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396192'
                WHERE ordernumber = 'P190615185722872' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396194'
                WHERE ordernumber = 'P190615185823752' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396193'
                WHERE ordernumber = 'P420615185824578' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396195'
                WHERE ordernumber = 'P200615190405450' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101131'
                WHERE ordernumber = 'P200615190518735' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302943'
                WHERE ordernumber = 'P190615190943215' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302943'
                WHERE ordernumber = 'P190615191034578' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396196'
                WHERE ordernumber = 'P200615191149740' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354003'
                WHERE ordernumber = 'P200615191358594' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396198'
                WHERE ordernumber = 'P190615191503471' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306150'
                WHERE ordernumber = 'P190615191917903' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396200'
                WHERE ordernumber = 'P200615191927747' 
            
2024-06-16 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '202673'
                WHERE ordernumber = 'P190615192210244' 
            
2024-06-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '274944'
                WHERE ordernumber = 'P190615192708995' 
            
2024-06-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '356805'
                WHERE ordernumber = 'P590615193434486' 
            
2024-06-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '161327'
                WHERE ordernumber = 'P190615194803572' 
            
2024-06-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '304441'
                WHERE ordernumber = 'P190615194923154' 
            
2024-06-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '396202'
                WHERE ordernumber = 'P190615195121383' 
            
2024-06-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '396203'
                WHERE ordernumber = 'P190615195613183' 
            
2024-06-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '396204'
                WHERE ordernumber = 'P630615201213819' 
            
2024-06-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '396205'
                WHERE ordernumber = 'P780615203301126' 
            
2024-06-16 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '396206'
                WHERE ordernumber = 'P780615210120862'