2024-12-30 01:00:01 -- 將會員中心id寫入data-lake 2024-12-30 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-29%'; 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440870' WHERE ordernumber = 'P2412290000022' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '207104' WHERE ordernumber = 'P2412290000023' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '207104' WHERE ordernumber = 'P2412290000026' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '110872' WHERE ordernumber = 'P2412290000028' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440874' WHERE ordernumber = 'P2412290000029' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '209380' WHERE ordernumber = 'P2412290000031' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '353275' WHERE ordernumber = 'P2412290000032' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '269566' WHERE ordernumber = 'P2412290000035' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440877' WHERE ordernumber = 'P2412290000036' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440878' WHERE ordernumber = 'P2412290000037' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '260423' WHERE ordernumber = 'P2412290000038' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '235779' WHERE ordernumber = 'P2412290000039' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '438052' WHERE ordernumber = 'P2412290000040' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '289379' WHERE ordernumber = 'P2412290000042' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '277800' WHERE ordernumber = 'P2412290000045' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '434518' WHERE ordernumber = 'P2412290000046' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '397025' WHERE ordernumber = 'P2412290000047' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '225202' WHERE ordernumber = 'P2412290000048' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440884' WHERE ordernumber = 'P2412290000049' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '269566' WHERE ordernumber = 'P2412290000050' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '351864' WHERE ordernumber = 'P2412290000053' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440885' WHERE ordernumber = 'P2412290000056' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440886' WHERE ordernumber = 'P2412290000058' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '87332' WHERE ordernumber = 'P2412290000059' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440889' WHERE ordernumber = 'P2412290000060' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440890' WHERE ordernumber = 'P2412290000064' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '272162' WHERE ordernumber = 'P2412290000067' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '211251' WHERE ordernumber = 'P2412290000069' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440887' WHERE ordernumber = 'P2412290000070' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '148994' WHERE ordernumber = 'P2412290000081' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '262125' WHERE ordernumber = 'P2412290000084' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440899' WHERE ordernumber = 'P2412290000087' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440897' WHERE ordernumber = 'P2412290000088' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '435137' WHERE ordernumber = 'P2412290000089' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '384480' WHERE ordernumber = 'P2412290000090' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440904' WHERE ordernumber = 'P2412290000091' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '365459' WHERE ordernumber = 'P2412290000093' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440903' WHERE ordernumber = 'P2412290000094' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '435474' WHERE ordernumber = 'P2412290000096' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440906' WHERE ordernumber = 'P2412290000098' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440907' WHERE ordernumber = 'P2412290000104' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '347962' WHERE ordernumber = 'P2412290000105' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440909' WHERE ordernumber = 'P2412290000107' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '436309' WHERE ordernumber = 'P2412290000116' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440911' WHERE ordernumber = 'P2412290000118' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440911' WHERE ordernumber = 'P2412290000122' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440913' WHERE ordernumber = 'P2412290000123' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440914' WHERE ordernumber = 'P2412290000132' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440910' WHERE ordernumber = 'P2412290000135' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440902' WHERE ordernumber = 'P2412290000139' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '255850' WHERE ordernumber = 'P2412290000140' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '339238' WHERE ordernumber = 'P2412290000143' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440918' WHERE ordernumber = 'P2412290000147' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '392972' WHERE ordernumber = 'P2412290000151' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440920' WHERE ordernumber = 'P2412290000153' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440922' WHERE ordernumber = 'P2412290000154' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440923' WHERE ordernumber = 'P2412290000156' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440924' WHERE ordernumber = 'P2412290000160' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440926' WHERE ordernumber = 'P2412290000164' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440491' WHERE ordernumber = 'P2412290000168' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '387858' WHERE ordernumber = 'P2412290000169' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '422958' WHERE ordernumber = 'P2412290000173' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '422958' WHERE ordernumber = 'P2412290000177' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440932' WHERE ordernumber = 'P2412290000178' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440932' WHERE ordernumber = 'P2412290000180' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '438765' WHERE ordernumber = 'P2412290000181' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '363159' WHERE ordernumber = 'P2412290000182' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440935' WHERE ordernumber = 'P2412290000183' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440934' WHERE ordernumber = 'P2412290000185' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '259470' WHERE ordernumber = 'P2412290000187' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440933' WHERE ordernumber = 'P2412290000192' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440933' WHERE ordernumber = 'P2412290000195' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '84647' WHERE ordernumber = 'P2412290000205' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '436377' WHERE ordernumber = 'P2412290000210' 2024-12-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '440942' WHERE ordernumber = 'P2412290000214' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '116997' WHERE ordernumber = 'P2412290000216' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440944' WHERE ordernumber = 'P2412290000217' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '234101' WHERE ordernumber = 'P2412290000218' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '404532' WHERE ordernumber = 'P2412290000221' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440946' WHERE ordernumber = 'P2412290000223' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '430443' WHERE ordernumber = 'P2412290000229' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440950' WHERE ordernumber = 'P2412290000230' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '393466' WHERE ordernumber = 'P2412290000231' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440951' WHERE ordernumber = 'P2412290000233' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440949' WHERE ordernumber = 'P2412290000234' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440948' WHERE ordernumber = 'P2412290000235' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440954' WHERE ordernumber = 'P2412290000240' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440954' WHERE ordernumber = 'P2412290000242' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '439523' WHERE ordernumber = 'P2412290000243' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '422323' WHERE ordernumber = 'P2412290000248' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440955' WHERE ordernumber = 'P2412290000252' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '416617' WHERE ordernumber = 'P2412290000254' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '416617' WHERE ordernumber = 'P2412290000257' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '439476' WHERE ordernumber = 'P2412290000267' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '253937' WHERE ordernumber = 'P2412290000268' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '439476' WHERE ordernumber = 'P2412290000269' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440961' WHERE ordernumber = 'P2412290000274' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440962' WHERE ordernumber = 'P2412290000277' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '438617' WHERE ordernumber = 'P2412290000278' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '438617' WHERE ordernumber = 'P2412290000279' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '112388' WHERE ordernumber = 'P2412290000282' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440967' WHERE ordernumber = 'P2412290000295' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440968' WHERE ordernumber = 'P2412290000297' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '100416' WHERE ordernumber = 'P2412290000298' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '247800' WHERE ordernumber = 'P2412290000309' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440971' WHERE ordernumber = 'P2412290000310' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '316113' WHERE ordernumber = 'P2412290000313' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '209467' WHERE ordernumber = 'P2412290000315' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440973' WHERE ordernumber = 'P2412290000316' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '384251' WHERE ordernumber = 'P2412290000321' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '377279' WHERE ordernumber = 'P2412290000323' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '427669' WHERE ordernumber = 'P2412290000324' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '352621' WHERE ordernumber = 'P2412290000327' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '415169' WHERE ordernumber = 'P2412290000328' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '429741' WHERE ordernumber = 'P2412290000329' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440978' WHERE ordernumber = 'P2412290000331' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '439062' WHERE ordernumber = 'P2412290000335' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '79430' WHERE ordernumber = 'P2412290000341' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '404870' WHERE ordernumber = 'P2412290000342' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440982' WHERE ordernumber = 'P2412290000349' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440983' WHERE ordernumber = 'P2412290000352' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '402374' WHERE ordernumber = 'P2412290000354' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '359824' WHERE ordernumber = 'P2412290000356' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440986' WHERE ordernumber = 'P2412290000361' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440990' WHERE ordernumber = 'P2412290000363' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440986' WHERE ordernumber = 'P2412290000367' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440985' WHERE ordernumber = 'P2412290000366' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440993' WHERE ordernumber = 'P2412290000384' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '354483' WHERE ordernumber = 'P2412290000393' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '143709' WHERE ordernumber = 'P2412290000395' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440985' WHERE ordernumber = 'P2412290000399' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440996' WHERE ordernumber = 'P2412290000403' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '241785' WHERE ordernumber = 'P2412290000408' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440998' WHERE ordernumber = 'P2412290000410' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441001' WHERE ordernumber = 'P2412290000421' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '380378' WHERE ordernumber = 'P2412290000423' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441005' WHERE ordernumber = 'P2412290000427' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441004' WHERE ordernumber = 'P2412290000429' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441006' WHERE ordernumber = 'P2412290000431' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '320972' WHERE ordernumber = 'P2412290000434' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441008' WHERE ordernumber = 'P2412290000439' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441010' WHERE ordernumber = 'P2412290000440' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '395552' WHERE ordernumber = 'P2412290000441' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441012' WHERE ordernumber = 'P2412290000443' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441014' WHERE ordernumber = 'P2412290000445' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '440969' WHERE ordernumber = 'P2412290000447' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441012' WHERE ordernumber = 'P2412290000448' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441015' WHERE ordernumber = 'P2412290000450' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '129975' WHERE ordernumber = 'P2412290000453' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441016' WHERE ordernumber = 'P2412290000455' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '435432' WHERE ordernumber = 'P2412290000461' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '303398' WHERE ordernumber = 'P2412290000463' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '438201' WHERE ordernumber = 'P2412290000464' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441018' WHERE ordernumber = 'P2412290000466' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '306189' WHERE ordernumber = 'P2412290000469' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '286337' WHERE ordernumber = 'P2412290000470' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '437597' WHERE ordernumber = 'P2412290000472' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441021' WHERE ordernumber = 'P2412290000474' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441022' WHERE ordernumber = 'P2412290000477' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441023' WHERE ordernumber = 'P2412290000478' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '357114' WHERE ordernumber = 'P2412290000480' 2024-12-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '441026' WHERE ordernumber = 'P2412290000482' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441028' WHERE ordernumber = 'P2412290000486' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441029' WHERE ordernumber = 'P2412290000487' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '331942' WHERE ordernumber = 'P2412290000488' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441030' WHERE ordernumber = 'P2412290000489' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441028' WHERE ordernumber = 'P2412290000491' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '271523' WHERE ordernumber = 'P2412290000500' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441032' WHERE ordernumber = 'P2412290000504' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441033' WHERE ordernumber = 'P2412290000509' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '44902' WHERE ordernumber = 'P2412290000510' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '239796' WHERE ordernumber = 'P2412290000511' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '377920' WHERE ordernumber = 'P2412290000514' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '279284' WHERE ordernumber = 'P2412290000515' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441034' WHERE ordernumber = 'P2412290000516' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441036' WHERE ordernumber = 'P2412290000519' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441037' WHERE ordernumber = 'P2412290000520' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '405212' WHERE ordernumber = 'P2412290000524' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441038' WHERE ordernumber = 'P2412290000525' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441038' WHERE ordernumber = 'P2412290000531' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '45291' WHERE ordernumber = 'P2412290000535' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '350503' WHERE ordernumber = 'P2412290000539' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441038' WHERE ordernumber = 'P2412290000540' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441042' WHERE ordernumber = 'P2412290000541' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441044' WHERE ordernumber = 'P2412290000544' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '439580' WHERE ordernumber = 'P2412290000545' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441045' WHERE ordernumber = 'P2412290000547' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441046' WHERE ordernumber = 'P2412290000553' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '440092' WHERE ordernumber = 'P2412290000554' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441047' WHERE ordernumber = 'P2412290000557' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '435858' WHERE ordernumber = 'P2412290000558' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '376070' WHERE ordernumber = 'P2412290000560' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441049' WHERE ordernumber = 'P2412290000561' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '409626' WHERE ordernumber = 'P2412290000563' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441050' WHERE ordernumber = 'P2412290000564' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '379867' WHERE ordernumber = 'P2412290000565' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '396349' WHERE ordernumber = 'P2412290000567' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '166025' WHERE ordernumber = 'P2412290000568' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441052' WHERE ordernumber = 'P2412290000569' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '435694' WHERE ordernumber = 'P2412290000572' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441048' WHERE ordernumber = 'P2412290000573' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441053' WHERE ordernumber = 'P2412290000577' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '150647' WHERE ordernumber = 'P2412290000576' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '352827' WHERE ordernumber = 'P2412290000581' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441055' WHERE ordernumber = 'P2412290000584' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '324599' WHERE ordernumber = 'P2412290000587' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441056' WHERE ordernumber = 'P2412290000588' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441057' WHERE ordernumber = 'P2412290000589' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '101523' WHERE ordernumber = 'P2412290000592' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '337773' WHERE ordernumber = 'P2412290000603' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '94582' WHERE ordernumber = 'P2412290000605' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441065' WHERE ordernumber = 'P2412290000614' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441070' WHERE ordernumber = 'P2412290000615' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441069' WHERE ordernumber = 'P2412290000616' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '358828' WHERE ordernumber = 'P2412290000619' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '289308' WHERE ordernumber = 'P2412290000620' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441062' WHERE ordernumber = 'P2412290000624' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '345067' WHERE ordernumber = 'P2412290000628' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441060' WHERE ordernumber = 'P2412290000631' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441074' WHERE ordernumber = 'P2412290000632' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '378919' WHERE ordernumber = 'P2412290000633' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441060' WHERE ordernumber = 'P2412290000634' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441067' WHERE ordernumber = 'P2412290000635' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441067' WHERE ordernumber = 'P2412290000638' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '396349' WHERE ordernumber = 'P2412290000639' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441077' WHERE ordernumber = 'P2412290000640' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441078' WHERE ordernumber = 'P2412290000641' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '423449' WHERE ordernumber = 'P2412290000646' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '99157' WHERE ordernumber = 'P2412290000648' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '334955' WHERE ordernumber = 'P2412290000653' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '382122' WHERE ordernumber = 'P2412290000655' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441079' WHERE ordernumber = 'P2412290000657' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441080' WHERE ordernumber = 'P2412290000661' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441083' WHERE ordernumber = 'P2412290000670' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '63554' WHERE ordernumber = 'P2412290000671' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441084' WHERE ordernumber = 'P2412290000672' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441085' WHERE ordernumber = 'P2412290000673' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '244447' WHERE ordernumber = 'P2412290000677' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '439496' WHERE ordernumber = 'P2412290000679' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441087' WHERE ordernumber = 'P2412290000680' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '437679' WHERE ordernumber = 'P2412290000681' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '439496' WHERE ordernumber = 'P2412290000683' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '439496' WHERE ordernumber = 'P2412290000686' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '396632' WHERE ordernumber = 'P2412290000687' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '439325' WHERE ordernumber = 'P2412290000689' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441091' WHERE ordernumber = 'P2412290000691' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '343874' WHERE ordernumber = 'P2412290000695' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441089' WHERE ordernumber = 'P2412290000697' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441094' WHERE ordernumber = 'P2412290000700' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441095' WHERE ordernumber = 'P2412290000705' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '244447' WHERE ordernumber = 'P2412290000707' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441098' WHERE ordernumber = 'P2412290000708' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441099' WHERE ordernumber = 'P2412290000709' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441100' WHERE ordernumber = 'P2412290000710' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '155895' WHERE ordernumber = 'P2412290000714' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441101' WHERE ordernumber = 'P2412290000718' 2024-12-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '441102' WHERE ordernumber = 'P2412290000719' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '387912' WHERE ordernumber = 'P2412290000721' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441087' WHERE ordernumber = 'P2412290000724' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '211145' WHERE ordernumber = 'P2412290000726' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '103548' WHERE ordernumber = 'P2412290000728' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '363317' WHERE ordernumber = 'P2412290000731' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441104' WHERE ordernumber = 'P2412290000736' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '438875' WHERE ordernumber = 'P2412290000737' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441105' WHERE ordernumber = 'P2412290000739' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '318554' WHERE ordernumber = 'P2412290000741' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441106' WHERE ordernumber = 'P2412290000742' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '436837' WHERE ordernumber = 'P2412290000744' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '432326' WHERE ordernumber = 'P2412290000746' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '440692' WHERE ordernumber = 'P2412290000747' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441107' WHERE ordernumber = 'P2412290000748' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441109' WHERE ordernumber = 'P2412290000751' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441110' WHERE ordernumber = 'P2412290000755' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '436396' WHERE ordernumber = 'P2412290000756' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '347117' WHERE ordernumber = 'P2412290000766' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441111' WHERE ordernumber = 'P2412290000774' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '219550' WHERE ordernumber = 'P2412290000779' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441114' WHERE ordernumber = 'P2412290000785' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441115' WHERE ordernumber = 'P2412290000787' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441117' WHERE ordernumber = 'P2412290000789' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441116' WHERE ordernumber = 'P2412290000790' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441118' WHERE ordernumber = 'P2412290000793' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '438872' WHERE ordernumber = 'P2412290000795' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441119' WHERE ordernumber = 'P2412290000799' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441120' WHERE ordernumber = 'P2412290000810' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '111386' WHERE ordernumber = 'P2412290000812' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441121' WHERE ordernumber = 'P2412290000816' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '376131' WHERE ordernumber = 'P2412290000821' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441124' WHERE ordernumber = 'P2412290000828' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441125' WHERE ordernumber = 'P2412290000834' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '97359' WHERE ordernumber = 'P2412290000837' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '433747' WHERE ordernumber = 'P2412290000842' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441128' WHERE ordernumber = 'P2412290000848' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441130' WHERE ordernumber = 'P2412290000850' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '377708' WHERE ordernumber = 'P2412290000858' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '312787' WHERE ordernumber = 'P2412290000859' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441131' WHERE ordernumber = 'P2412290000860' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441134' WHERE ordernumber = 'P2412290000865' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441135' WHERE ordernumber = 'P2412290000867' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441136' WHERE ordernumber = 'P2412290000868' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '432198' WHERE ordernumber = 'P2412290000874' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '214012' WHERE ordernumber = 'P2412290000880' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441141' WHERE ordernumber = 'P2412290000884' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441140' WHERE ordernumber = 'P2412290000887' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441143' WHERE ordernumber = 'P2412290000890' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441147' WHERE ordernumber = 'P2412290000898' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441146' WHERE ordernumber = 'P2412290000899' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '288179' WHERE ordernumber = 'P2412290000903' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '427727' WHERE ordernumber = 'P2412290000904' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441148' WHERE ordernumber = 'P2412290000907' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441150' WHERE ordernumber = 'P2412290000909' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '294668' WHERE ordernumber = 'P2412290000910' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441151' WHERE ordernumber = 'P2412290000914' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441152' WHERE ordernumber = 'P2412290000917' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441151' WHERE ordernumber = 'P2412290000924' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441145' WHERE ordernumber = 'P2412290000930' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441154' WHERE ordernumber = 'P2412290000935' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441159' WHERE ordernumber = 'P2412290000946' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441158' WHERE ordernumber = 'P2412290000948' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441160' WHERE ordernumber = 'P2412290000949' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441162' WHERE ordernumber = 'P2412290000953' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '426898' WHERE ordernumber = 'P2412290000955' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441164' WHERE ordernumber = 'P2412290000963' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '353968' WHERE ordernumber = 'P2412290000967' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '384577' WHERE ordernumber = 'P2412290000974' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '209365' WHERE ordernumber = 'P2412290000977' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441152' WHERE ordernumber = 'P2412290000980' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441171' WHERE ordernumber = 'P2412290000991' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441170' WHERE ordernumber = 'P2412290000993' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441175' WHERE ordernumber = 'P2412290001001' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '395695' WHERE ordernumber = 'P2412290001006' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441183' WHERE ordernumber = 'P2412290001015' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '381' WHERE ordernumber = 'P2412290001019' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441186' WHERE ordernumber = 'P2412290001020' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '425223' WHERE ordernumber = 'P2412290001022' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441188' WHERE ordernumber = 'P2412290001024' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '329127' WHERE ordernumber = 'P2412290001026' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '441196' WHERE ordernumber = 'P2412290001032' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '317282' WHERE ordernumber = 'P2412290001065' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '374458' WHERE ordernumber = 'P2412290001067' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '439832' WHERE ordernumber = 'P2412290001076' 2024-12-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '396308' WHERE ordernumber = 'P2412290001082'