2024-12-21 01:00:01 -- 將會員中心id寫入data-lake
2024-12-21 01:00:01 -- 
            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-12-20%';
        
2024-12-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '391915'
                WHERE ordernumber = 'P2412200000012' 
            
2024-12-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '436513'
                WHERE ordernumber = 'P2412200000013' 
            
2024-12-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '246327'
                WHERE ordernumber = 'P2412200000015' 
            
2024-12-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '208646'
                WHERE ordernumber = 'P2412200000019' 
            
2024-12-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '399685'
                WHERE ordernumber = 'P2412200000020' 
            
2024-12-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '263922'
                WHERE ordernumber = 'P2412200000022' 
            
2024-12-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '437402'
                WHERE ordernumber = 'P2412200000024' 
            
2024-12-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '164997'
                WHERE ordernumber = 'P2412200000025' 
            
2024-12-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '434230'
                WHERE ordernumber = 'P2412200000026' 
            
2024-12-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '342512'
                WHERE ordernumber = 'P2412200000030' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435103'
                WHERE ordernumber = 'P2412200000032' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273956'
                WHERE ordernumber = 'P2412200000037' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284924'
                WHERE ordernumber = 'P2412200000039' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388812'
                WHERE ordernumber = 'P2412200000043' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437407'
                WHERE ordernumber = 'P2412200000047' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209287'
                WHERE ordernumber = 'P2412200000049' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437408'
                WHERE ordernumber = 'P2412200000053' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426099'
                WHERE ordernumber = 'P2412200000055' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '122995'
                WHERE ordernumber = 'P2412200000058' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342305'
                WHERE ordernumber = 'P2412200000059' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437409'
                WHERE ordernumber = 'P2412200000063' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105553'
                WHERE ordernumber = 'P2412200000065' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118999'
                WHERE ordernumber = 'P2412200000067' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '54776'
                WHERE ordernumber = 'P2412200000069' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96664'
                WHERE ordernumber = 'P2412200000071' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '149224'
                WHERE ordernumber = 'P2412200000072' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225202'
                WHERE ordernumber = 'P2412200000082' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275682'
                WHERE ordernumber = 'P2412200000086' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422856'
                WHERE ordernumber = 'P2412200000091' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426132'
                WHERE ordernumber = 'P2412200000092' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280178'
                WHERE ordernumber = 'P2412200000094' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437414'
                WHERE ordernumber = 'P2412200000096' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208583'
                WHERE ordernumber = 'P2412200000099' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437417'
                WHERE ordernumber = 'P2412200000100' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127514'
                WHERE ordernumber = 'P2412200000102' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137380'
                WHERE ordernumber = 'P2412200000107' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93879'
                WHERE ordernumber = 'P2412200000108' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437420'
                WHERE ordernumber = 'P2412200000110' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437421'
                WHERE ordernumber = 'P2412200000115' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379210'
                WHERE ordernumber = 'P2412200000119' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437422'
                WHERE ordernumber = 'P2412200000123' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241465'
                WHERE ordernumber = 'P2412200000125' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436958'
                WHERE ordernumber = 'P2412200000131' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '48124'
                WHERE ordernumber = 'P2412200000137' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '233524'
                WHERE ordernumber = 'P2412200000141' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338630'
                WHERE ordernumber = 'P2412200000142' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273032'
                WHERE ordernumber = 'P2412200000148' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324718'
                WHERE ordernumber = 'P2412200000153' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P2412200000155' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437429'
                WHERE ordernumber = 'P2412200000156' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206912'
                WHERE ordernumber = 'P2412200000157' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162902'
                WHERE ordernumber = 'P2412200000163' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276094'
                WHERE ordernumber = 'P2412200000166' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437432'
                WHERE ordernumber = 'P2412200000168' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '221282'
                WHERE ordernumber = 'P2412200000171' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437434'
                WHERE ordernumber = 'P2412200000173' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217639'
                WHERE ordernumber = 'P2412200000176' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437441'
                WHERE ordernumber = 'P2412200000180' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238934'
                WHERE ordernumber = 'P2412200000181' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314759'
                WHERE ordernumber = 'P2412200000182' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390739'
                WHERE ordernumber = 'P2412200000187' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437446'
                WHERE ordernumber = 'P2412200000190' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429870'
                WHERE ordernumber = 'P2412200000191' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251911'
                WHERE ordernumber = 'P2412200000192' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437447'
                WHERE ordernumber = 'P2412200000200' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378456'
                WHERE ordernumber = 'P2412200000203' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437213'
                WHERE ordernumber = 'P2412200000208' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437213'
                WHERE ordernumber = 'P2412200000209' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437213'
                WHERE ordernumber = 'P2412200000211' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436694'
                WHERE ordernumber = 'P2412200000220' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437451'
                WHERE ordernumber = 'P2412200000223' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436780'
                WHERE ordernumber = 'P2412200000225' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433983'
                WHERE ordernumber = 'P2412200000227' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409626'
                WHERE ordernumber = 'P2412200000229' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437456'
                WHERE ordernumber = 'P2412200000231' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385317'
                WHERE ordernumber = 'P2412200000235' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437458'
                WHERE ordernumber = 'P2412200000236' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '44681'
                WHERE ordernumber = 'P2412200000237' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354279'
                WHERE ordernumber = 'P2412200000243' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437461'
                WHERE ordernumber = 'P2412200000244' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '83903'
                WHERE ordernumber = 'P2412200000245' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437459'
                WHERE ordernumber = 'P2412200000252' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437466'
                WHERE ordernumber = 'P2412200000254' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437465'
                WHERE ordernumber = 'P2412200000255' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '168309'
                WHERE ordernumber = 'P2412200000257' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206994'
                WHERE ordernumber = 'P2412200000258' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437468'
                WHERE ordernumber = 'P2412200000261' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380328'
                WHERE ordernumber = 'P2412200000263' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99783'
                WHERE ordernumber = 'P2412200000264' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380328'
                WHERE ordernumber = 'P2412200000265' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263084'
                WHERE ordernumber = 'P2412200000266' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437470'
                WHERE ordernumber = 'P2412200000267' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263084'
                WHERE ordernumber = 'P2412200000270' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342305'
                WHERE ordernumber = 'P2412200000277' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433328'
                WHERE ordernumber = 'P2412200000282' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282566'
                WHERE ordernumber = 'P2412200000284' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437471'
                WHERE ordernumber = 'P2412200000286' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437474'
                WHERE ordernumber = 'P2412200000292' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319754'
                WHERE ordernumber = 'P2412200000293' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209646'
                WHERE ordernumber = 'P2412200000295' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252711'
                WHERE ordernumber = 'P2412200000305' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437477'
                WHERE ordernumber = 'P2412200000308' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316660'
                WHERE ordernumber = 'P2412200000309' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307946'
                WHERE ordernumber = 'P2412200000313' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431862'
                WHERE ordernumber = 'P2412200000320' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391338'
                WHERE ordernumber = 'P2412200000322' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348296'
                WHERE ordernumber = 'P2412200000324' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365153'
                WHERE ordernumber = 'P2412200000325' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437484'
                WHERE ordernumber = 'P2412200000327' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402568'
                WHERE ordernumber = 'P2412200000330' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437484'
                WHERE ordernumber = 'P2412200000331' 
            
2024-12-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273160'
                WHERE ordernumber = 'P2412200000334' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431742'
                WHERE ordernumber = 'P2412200000335' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437487'
                WHERE ordernumber = 'P2412200000338' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279134'
                WHERE ordernumber = 'P2412200000340' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437492'
                WHERE ordernumber = 'P2412200000344' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437494'
                WHERE ordernumber = 'P2412200000350' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301080'
                WHERE ordernumber = 'P2412200000359' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380535'
                WHERE ordernumber = 'P2412200000361' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437498'
                WHERE ordernumber = 'P2412200000364' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437499'
                WHERE ordernumber = 'P2412200000365' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251223'
                WHERE ordernumber = 'P2412200000366' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290339'
                WHERE ordernumber = 'P2412200000367' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277592'
                WHERE ordernumber = 'P2412200000371' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437502'
                WHERE ordernumber = 'P2412200000373' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437500'
                WHERE ordernumber = 'P2412200000377' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350730'
                WHERE ordernumber = 'P2412200000380' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65371'
                WHERE ordernumber = 'P2412200000385' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437506'
                WHERE ordernumber = 'P2412200000390' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345808'
                WHERE ordernumber = 'P2412200000392' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293545'
                WHERE ordernumber = 'P2412200000397' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166285'
                WHERE ordernumber = 'P2412200000398' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437508'
                WHERE ordernumber = 'P2412200000399' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435128'
                WHERE ordernumber = 'P2412200000400' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388791'
                WHERE ordernumber = 'P2412200000406' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437512'
                WHERE ordernumber = 'P2412200000409' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113784'
                WHERE ordernumber = 'P2412200000411' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437514'
                WHERE ordernumber = 'P2412200000413' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220446'
                WHERE ordernumber = 'P2412200000414' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427922'
                WHERE ordernumber = 'P2412200000415' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142556'
                WHERE ordernumber = 'P2412200000416' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331478'
                WHERE ordernumber = 'P2412200000420' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102241'
                WHERE ordernumber = 'P2412200000430' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371131'
                WHERE ordernumber = 'P2412200000432' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381351'
                WHERE ordernumber = 'P2412200000436' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369717'
                WHERE ordernumber = 'P2412200000439' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437518'
                WHERE ordernumber = 'P2412200000442' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364669'
                WHERE ordernumber = 'P2412200000444' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88447'
                WHERE ordernumber = 'P2412200000446' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365710'
                WHERE ordernumber = 'P2412200000450' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278204'
                WHERE ordernumber = 'P2412200000454' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223258'
                WHERE ordernumber = 'P2412200000456' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437528'
                WHERE ordernumber = 'P2412200000466' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88985'
                WHERE ordernumber = 'P2412200000468' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437529'
                WHERE ordernumber = 'P2412200000469' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437530'
                WHERE ordernumber = 'P2412200000471' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437533'
                WHERE ordernumber = 'P2412200000472' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388985'
                WHERE ordernumber = 'P2412200000475' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388985'
                WHERE ordernumber = 'P2412200000477' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243586'
                WHERE ordernumber = 'P2412200000479' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437537'
                WHERE ordernumber = 'P2412200000480' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388985'
                WHERE ordernumber = 'P2412200000481' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437534'
                WHERE ordernumber = 'P2412200000482' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237840'
                WHERE ordernumber = 'P2412200000483' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437538'
                WHERE ordernumber = 'P2412200000487' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437540'
                WHERE ordernumber = 'P2412200000490' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437543'
                WHERE ordernumber = 'P2412200000499' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437536'
                WHERE ordernumber = 'P2412200000503' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416386'
                WHERE ordernumber = 'P2412200000507' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160964'
                WHERE ordernumber = 'P2412200000510' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217480'
                WHERE ordernumber = 'P2412200000511' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P2412200000516' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437545'
                WHERE ordernumber = 'P2412200000517' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385996'
                WHERE ordernumber = 'P2412200000520' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437549'
                WHERE ordernumber = 'P2412200000523' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399525'
                WHERE ordernumber = 'P2412200000524' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434606'
                WHERE ordernumber = 'P2412200000528' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437548'
                WHERE ordernumber = 'P2412200000529' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398262'
                WHERE ordernumber = 'P2412200000530' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425399'
                WHERE ordernumber = 'P2412200000531' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422164'
                WHERE ordernumber = 'P2412200000535' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436179'
                WHERE ordernumber = 'P2412200000541' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437557'
                WHERE ordernumber = 'P2412200000544' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237250'
                WHERE ordernumber = 'P2412200000547' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224548'
                WHERE ordernumber = 'P2412200000553' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437558'
                WHERE ordernumber = 'P2412200000554' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432231'
                WHERE ordernumber = 'P2412200000556' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437558'
                WHERE ordernumber = 'P2412200000557' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434078'
                WHERE ordernumber = 'P2412200000560' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437560'
                WHERE ordernumber = 'P2412200000561' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430747'
                WHERE ordernumber = 'P2412200000564' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437562'
                WHERE ordernumber = 'P2412200000566' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306624'
                WHERE ordernumber = 'P2412200000567' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437563'
                WHERE ordernumber = 'P2412200000569' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360233'
                WHERE ordernumber = 'P2412200000583' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437565'
                WHERE ordernumber = 'P2412200000584' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437569'
                WHERE ordernumber = 'P2412200000595' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278639'
                WHERE ordernumber = 'P2412200000599' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437572'
                WHERE ordernumber = 'P2412200000600' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415741'
                WHERE ordernumber = 'P2412200000602' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157370'
                WHERE ordernumber = 'P2412200000607' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437575'
                WHERE ordernumber = 'P2412200000610' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238609'
                WHERE ordernumber = 'P2412200000611' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437575'
                WHERE ordernumber = 'P2412200000615' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240510'
                WHERE ordernumber = 'P2412200000616' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437576'
                WHERE ordernumber = 'P2412200000622' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437578'
                WHERE ordernumber = 'P2412200000627' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247612'
                WHERE ordernumber = 'P2412200000637' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145397'
                WHERE ordernumber = 'P2412200000646' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280451'
                WHERE ordernumber = 'P2412200000647' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421198'
                WHERE ordernumber = 'P2412200000648' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437583'
                WHERE ordernumber = 'P2412200000657' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241126'
                WHERE ordernumber = 'P2412200000659' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365269'
                WHERE ordernumber = 'P2412200000660' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141429'
                WHERE ordernumber = 'P2412200000663' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250011'
                WHERE ordernumber = 'P2412200000667' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437586'
                WHERE ordernumber = 'P2412200000669' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206906'
                WHERE ordernumber = 'P2412200000672' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131367'
                WHERE ordernumber = 'P2412200000673' 
            
2024-12-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437587'
                WHERE ordernumber = 'P2412200000676' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437584'
                WHERE ordernumber = 'P2412200000680' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227451'
                WHERE ordernumber = 'P2412200000688' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428959'
                WHERE ordernumber = 'P2412200000691' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350922'
                WHERE ordernumber = 'P2412200000692' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130138'
                WHERE ordernumber = 'P2412200000695' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311545'
                WHERE ordernumber = 'P2412200000696' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237378'
                WHERE ordernumber = 'P2412200000702' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437546'
                WHERE ordernumber = 'P2412200000703' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237378'
                WHERE ordernumber = 'P2412200000706' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437591'
                WHERE ordernumber = 'P2412200000710' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421338'
                WHERE ordernumber = 'P2412200000715' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437594'
                WHERE ordernumber = 'P2412200000728' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437554'
                WHERE ordernumber = 'P2412200000732' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437598'
                WHERE ordernumber = 'P2412200000733' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437596'
                WHERE ordernumber = 'P2412200000734' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437599'
                WHERE ordernumber = 'P2412200000735' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215477'
                WHERE ordernumber = 'P2412200000738' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437602'
                WHERE ordernumber = 'P2412200000741' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347352'
                WHERE ordernumber = 'P2412200000743' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94179'
                WHERE ordernumber = 'P2412200000748' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142108'
                WHERE ordernumber = 'P2412200000750' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414844'
                WHERE ordernumber = 'P2412200000751' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98720'
                WHERE ordernumber = 'P2412200000754' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347352'
                WHERE ordernumber = 'P2412200000755' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289795'
                WHERE ordernumber = 'P2412200000759' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437606'
                WHERE ordernumber = 'P2412200000763' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437612'
                WHERE ordernumber = 'P2412200000782' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437613'
                WHERE ordernumber = 'P2412200000784' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434365'
                WHERE ordernumber = 'P2412200000785' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382469'
                WHERE ordernumber = 'P2412200000787' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437616'
                WHERE ordernumber = 'P2412200000788' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293296'
                WHERE ordernumber = 'P2412200000791' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141799'
                WHERE ordernumber = 'P2412200000793' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348824'
                WHERE ordernumber = 'P2412200000799' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304183'
                WHERE ordernumber = 'P2412200000803' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396824'
                WHERE ordernumber = 'P2412200000804' 
            
2024-12-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106438'
                WHERE ordernumber = 'P2412200000814'