2024-02-22 01:00:02 -- 將會員中心id寫入data-lake
2024-02-22 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-02-21%';
        
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297300'
                WHERE ordernumber = 'P420221110157948' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378290'
                WHERE ordernumber = 'P180221110352865' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378291'
                WHERE ordernumber = 'P420221110439312' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149134'
                WHERE ordernumber = 'P180221110452605' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343868'
                WHERE ordernumber = 'P420221110552484' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378292'
                WHERE ordernumber = 'P180221110624460' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378293'
                WHERE ordernumber = 'P420221110751374' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251203'
                WHERE ordernumber = 'P180221110810483' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316926'
                WHERE ordernumber = 'P200221110903991' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378294'
                WHERE ordernumber = 'P180221111014948' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222070'
                WHERE ordernumber = 'P420221111024900' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378295'
                WHERE ordernumber = 'P180221111714373' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378296'
                WHERE ordernumber = 'P180221111859299' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200221112236860' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345634'
                WHERE ordernumber = 'P180221112323847' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378298'
                WHERE ordernumber = 'P420221113232747' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378300'
                WHERE ordernumber = 'P420221113912908' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377868'
                WHERE ordernumber = 'P190221114051806' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378301'
                WHERE ordernumber = 'P420221114257916' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378303'
                WHERE ordernumber = 'P180221115210885' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378304'
                WHERE ordernumber = 'P200221115648236' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378306'
                WHERE ordernumber = 'P180221115844290' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138496'
                WHERE ordernumber = 'P420221120227402' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378307'
                WHERE ordernumber = 'P180221120450411' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221222'
                WHERE ordernumber = 'P180221120736400' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311532'
                WHERE ordernumber = 'P180221121328993' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258479'
                WHERE ordernumber = 'P200221122211120' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378310'
                WHERE ordernumber = 'P420221122318684' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108274'
                WHERE ordernumber = 'P180221123131362' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232257'
                WHERE ordernumber = 'P200221123655415' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378311'
                WHERE ordernumber = 'P180221123854348' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297814'
                WHERE ordernumber = 'P420221123933540' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378312'
                WHERE ordernumber = 'P200221124314146' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378313'
                WHERE ordernumber = 'P200221124633723' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378314'
                WHERE ordernumber = 'P180221124644908' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223879'
                WHERE ordernumber = 'P420221125144323' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112587'
                WHERE ordernumber = 'P180221125149606' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81624'
                WHERE ordernumber = 'P200221125634521' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367208'
                WHERE ordernumber = 'P420221125813139' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305437'
                WHERE ordernumber = 'P200221125956163' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378317'
                WHERE ordernumber = 'P180221130500962' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300812'
                WHERE ordernumber = 'P200221130744379' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105863'
                WHERE ordernumber = 'P200221132016402' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378320'
                WHERE ordernumber = 'P180221132019949' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309750'
                WHERE ordernumber = 'P180221132109507' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378322'
                WHERE ordernumber = 'P420221132602562' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378323'
                WHERE ordernumber = 'P200221132719387' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139545'
                WHERE ordernumber = 'P200221132835145' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347603'
                WHERE ordernumber = 'P200221132919779' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282503'
                WHERE ordernumber = 'P200221133105158' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378324'
                WHERE ordernumber = 'P200221133353610' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378325'
                WHERE ordernumber = 'P180221133943754' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299101'
                WHERE ordernumber = 'P180221134245406' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299101'
                WHERE ordernumber = 'P180221134645693' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378326'
                WHERE ordernumber = 'P180221134756481' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378327'
                WHERE ordernumber = 'P180221134933497' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378330'
                WHERE ordernumber = 'P420221135518229' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278924'
                WHERE ordernumber = 'P200221135808275' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '37371'
                WHERE ordernumber = 'P200221135935172' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299335'
                WHERE ordernumber = 'P180221140235410' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283483'
                WHERE ordernumber = 'P180221140447193' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378332'
                WHERE ordernumber = 'P200221140619776' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378333'
                WHERE ordernumber = 'P180221140804717' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377755'
                WHERE ordernumber = 'P180221141141134' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378336'
                WHERE ordernumber = 'P420221141532884' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224338'
                WHERE ordernumber = 'P180221141703718' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219769'
                WHERE ordernumber = 'P180221141827311' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352417'
                WHERE ordernumber = 'P180221141948579' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378337'
                WHERE ordernumber = 'P200221141956817' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378337'
                WHERE ordernumber = 'P200221142039748' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180221142355785' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378339'
                WHERE ordernumber = 'P200221142822867' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296200'
                WHERE ordernumber = 'P420221143357878' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '182079'
                WHERE ordernumber = 'P200221143501180' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378341'
                WHERE ordernumber = 'P420221143800892' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378343'
                WHERE ordernumber = 'P200221143916530' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378309'
                WHERE ordernumber = 'P180221144151306' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378346'
                WHERE ordernumber = 'P200221144732971' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378347'
                WHERE ordernumber = 'P420221144845725' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378348'
                WHERE ordernumber = 'P200221145221628' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270926'
                WHERE ordernumber = 'P200221145304487' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378276'
                WHERE ordernumber = 'P180221145629619' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378349'
                WHERE ordernumber = 'P200221150029512' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377599'
                WHERE ordernumber = 'P200221150157869' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227797'
                WHERE ordernumber = 'P180221150731490' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377330'
                WHERE ordernumber = 'P200221150800750' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270147'
                WHERE ordernumber = 'P200221150939365' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378350'
                WHERE ordernumber = 'P200221151113636' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378351'
                WHERE ordernumber = 'P200221151646856' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299210'
                WHERE ordernumber = 'P420221151759639' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378299'
                WHERE ordernumber = 'P180221151822916' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371752'
                WHERE ordernumber = 'P180221152129119' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346352'
                WHERE ordernumber = 'P200221152207204' 
            
2024-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378354'
                WHERE ordernumber = 'P180221152255666' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378353'
                WHERE ordernumber = 'P180221152511297' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378353'
                WHERE ordernumber = 'P180221152543826' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378355'
                WHERE ordernumber = 'P200221152604511' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378356'
                WHERE ordernumber = 'P420221153040740' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378357'
                WHERE ordernumber = 'P420221153306523' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213420'
                WHERE ordernumber = 'P180221153457526' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378358'
                WHERE ordernumber = 'P420221154142146' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378359'
                WHERE ordernumber = 'P200221154649644' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376544'
                WHERE ordernumber = 'P180221154939881' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120756'
                WHERE ordernumber = 'P180221155407934' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103465'
                WHERE ordernumber = 'P200221160104729' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378361'
                WHERE ordernumber = 'P180221160114982' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378362'
                WHERE ordernumber = 'P420221160440706' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284478'
                WHERE ordernumber = 'P200221160645814' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378363'
                WHERE ordernumber = 'P200221160706782' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261941'
                WHERE ordernumber = 'P180221160721988' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378365'
                WHERE ordernumber = 'P420221160726913' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378363'
                WHERE ordernumber = 'P200221160815955' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378365'
                WHERE ordernumber = 'P420221160841212' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378366'
                WHERE ordernumber = 'P420221161135711' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378369'
                WHERE ordernumber = 'P200221162714380' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378370'
                WHERE ordernumber = 'P180221163012812' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135710'
                WHERE ordernumber = 'P200221164014678' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286337'
                WHERE ordernumber = 'P200221164410281' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98005'
                WHERE ordernumber = 'P180221164415428' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271182'
                WHERE ordernumber = 'P180221164725161' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378372'
                WHERE ordernumber = 'P190221165543653' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378374'
                WHERE ordernumber = 'P200221170343682' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378375'
                WHERE ordernumber = 'P420221171329227' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378376'
                WHERE ordernumber = 'P420221171723317' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348946'
                WHERE ordernumber = 'P200221171752112' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378377'
                WHERE ordernumber = 'P420221171847127' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378379'
                WHERE ordernumber = 'P200221172117458' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378378'
                WHERE ordernumber = 'P420221172138238' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378380'
                WHERE ordernumber = 'P420221172453364' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206421'
                WHERE ordernumber = 'P180221173003205' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378381'
                WHERE ordernumber = 'P180221173148707' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358489'
                WHERE ordernumber = 'P180221173243300' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225525'
                WHERE ordernumber = 'P200221173417687' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352678'
                WHERE ordernumber = 'P180221173858504' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222161'
                WHERE ordernumber = 'P200221174322717' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378384'
                WHERE ordernumber = 'P420221174337180' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378385'
                WHERE ordernumber = 'P200221174819545' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378386'
                WHERE ordernumber = 'P200221174857593' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217327'
                WHERE ordernumber = 'P180221174930594' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378387'
                WHERE ordernumber = 'P190221174958485' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368927'
                WHERE ordernumber = 'P420221175203739' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378352'
                WHERE ordernumber = 'P180221175323390' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378390'
                WHERE ordernumber = 'P190221175431631' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378391'
                WHERE ordernumber = 'P200221175514916' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80513'
                WHERE ordernumber = 'P200221175645200' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378388'
                WHERE ordernumber = 'P180221175658464' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378388'
                WHERE ordernumber = 'P180221175731119' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378393'
                WHERE ordernumber = 'P180221180034520' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378395'
                WHERE ordernumber = 'P180221181035856' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278615'
                WHERE ordernumber = 'P180221181645333' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363647'
                WHERE ordernumber = 'P180221181741576' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378396'
                WHERE ordernumber = 'P420221181834123' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378398'
                WHERE ordernumber = 'P200221181950941' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278615'
                WHERE ordernumber = 'P180221182108933' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265354'
                WHERE ordernumber = 'P420221182231803' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378399'
                WHERE ordernumber = 'P200221182255719' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259538'
                WHERE ordernumber = 'P420221182306131' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367741'
                WHERE ordernumber = 'P180221182337776' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269141'
                WHERE ordernumber = 'P200221182509272' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269141'
                WHERE ordernumber = 'P200221182543543' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369192'
                WHERE ordernumber = 'P200221182832154' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378400'
                WHERE ordernumber = 'P180221183101551' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378401'
                WHERE ordernumber = 'P200221183258906' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334992'
                WHERE ordernumber = 'P180221183300956' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378402'
                WHERE ordernumber = 'P180221183337981' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378403'
                WHERE ordernumber = 'P180221183541858' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233454'
                WHERE ordernumber = 'P200221183606144' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117187'
                WHERE ordernumber = 'P200221183638500' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283871'
                WHERE ordernumber = 'P180221184031809' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378404'
                WHERE ordernumber = 'P200221184135836' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378405'
                WHERE ordernumber = 'P420221184211879' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378406'
                WHERE ordernumber = 'P200221184532953' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '10174'
                WHERE ordernumber = 'P190221184917259' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378410'
                WHERE ordernumber = 'P420221185755570' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378411'
                WHERE ordernumber = 'P200221185800599' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P420221190122402' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377628'
                WHERE ordernumber = 'P420221190534999' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235646'
                WHERE ordernumber = 'P200221190841827' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378412'
                WHERE ordernumber = 'P200221191053725' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76651'
                WHERE ordernumber = 'P200221191209513' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '83959'
                WHERE ordernumber = 'P190221191616671' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378413'
                WHERE ordernumber = 'P200221191733912' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248048'
                WHERE ordernumber = 'P190221191825151' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158224'
                WHERE ordernumber = 'P190221191911475' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378414'
                WHERE ordernumber = 'P200221191947222' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378416'
                WHERE ordernumber = 'P190221192415481' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378417'
                WHERE ordernumber = 'P200221192445268' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369142'
                WHERE ordernumber = 'P190221192530733' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377262'
                WHERE ordernumber = 'P420221193346880' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163747'
                WHERE ordernumber = 'P190221193711414' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376947'
                WHERE ordernumber = 'P190221194034631' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169'
                WHERE ordernumber = 'P190221194404472' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294925'
                WHERE ordernumber = 'P200221194413738' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200221195445525' 
            
2024-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378281'
                WHERE ordernumber = 'P200221195949603'