2025-01-10 01:00:02 -- 將會員中心id寫入data-lake 2025-01-10 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 '2025-01-09%'; 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '216961' WHERE ordernumber = 'P2501090000009' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '446656' WHERE ordernumber = 'P2501090000013' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '446657' WHERE ordernumber = 'P2501090000014' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '276379' WHERE ordernumber = 'P2501090000015' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '446659' WHERE ordernumber = 'P2501090000017' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '67184' WHERE ordernumber = 'P2501090000018' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '91733' WHERE ordernumber = 'P2501090000019' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '446663' WHERE ordernumber = 'P2501090000024' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '446664' WHERE ordernumber = 'P2501090000025' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '446665' WHERE ordernumber = 'P2501090000026' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '446648' WHERE ordernumber = 'P2501090000027' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '446666' WHERE ordernumber = 'P2501090000028' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '446665' WHERE ordernumber = 'P2501090000030' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '162977' WHERE ordernumber = 'P2501090000031' 2025-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '162977' WHERE ordernumber = 'P2501090000033' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '162977' WHERE ordernumber = 'P2501090000036' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '428032' WHERE ordernumber = 'P2501090000039' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '284276' WHERE ordernumber = 'P2501090000040' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '249481' WHERE ordernumber = 'P2501090000041' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446671' WHERE ordernumber = 'P2501090000042' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '398475' WHERE ordernumber = 'P2501090000044' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '269278' WHERE ordernumber = 'P2501090000047' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446673' WHERE ordernumber = 'P2501090000048' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '262644' WHERE ordernumber = 'P2501090000051' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446674' WHERE ordernumber = 'P2501090000052' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446675' WHERE ordernumber = 'P2501090000053' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '269112' WHERE ordernumber = 'P2501090000057' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446676' WHERE ordernumber = 'P2501090000058' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446682' WHERE ordernumber = 'P2501090000060' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '160087' WHERE ordernumber = 'P2501090000062' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '417152' WHERE ordernumber = 'P2501090000068' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '203673' WHERE ordernumber = 'P2501090000069' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '268782' WHERE ordernumber = 'P2501090000071' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '225012' WHERE ordernumber = 'P2501090000072' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '99933' WHERE ordernumber = 'P2501090000073' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '443940' WHERE ordernumber = 'P2501090000076' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '307996' WHERE ordernumber = 'P2501090000077' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '86113' WHERE ordernumber = 'P2501090000082' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446687' WHERE ordernumber = 'P2501090000083' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '266795' WHERE ordernumber = 'P2501090000084' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446051' WHERE ordernumber = 'P2501090000085' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446693' WHERE ordernumber = 'P2501090000089' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '397025' WHERE ordernumber = 'P2501090000091' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '114334' WHERE ordernumber = 'P2501090000093' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363874' WHERE ordernumber = 'P2501090000095' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '433017' WHERE ordernumber = 'P2501090000103' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '208567' WHERE ordernumber = 'P2501090000104' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446695' WHERE ordernumber = 'P2501090000106' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '290339' WHERE ordernumber = 'P2501090000111' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446702' WHERE ordernumber = 'P2501090000115' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '429847' WHERE ordernumber = 'P2501090000117' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '442027' WHERE ordernumber = 'P2501090000119' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446704' WHERE ordernumber = 'P2501090000120' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '296861' WHERE ordernumber = 'P2501090000124' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446395' WHERE ordernumber = 'P2501090000130' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '348065' WHERE ordernumber = 'P2501090000131' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446700' WHERE ordernumber = 'P2501090000132' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '268747' WHERE ordernumber = 'P2501090000133' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446699' WHERE ordernumber = 'P2501090000134' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446698' WHERE ordernumber = 'P2501090000136' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '400869' WHERE ordernumber = 'P2501090000137' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446710' WHERE ordernumber = 'P2501090000139' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '106989' WHERE ordernumber = 'P2501090000140' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446708' WHERE ordernumber = 'P2501090000141' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '274867' WHERE ordernumber = 'P2501090000143' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446700' WHERE ordernumber = 'P2501090000147' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '216260' WHERE ordernumber = 'P2501090000148' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446714' WHERE ordernumber = 'P2501090000154' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '444962' WHERE ordernumber = 'P2501090000155' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446717' WHERE ordernumber = 'P2501090000156' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446720' WHERE ordernumber = 'P2501090000171' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '442027' WHERE ordernumber = 'P2501090000172' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '397199' WHERE ordernumber = 'P2501090000175' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '217152' WHERE ordernumber = 'P2501090000176' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '400925' WHERE ordernumber = 'P2501090000180' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446726' WHERE ordernumber = 'P2501090000183' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '358903' WHERE ordernumber = 'P2501090000184' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '316038' WHERE ordernumber = 'P2501090000186' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446729' WHERE ordernumber = 'P2501090000187' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '384374' WHERE ordernumber = 'P2501090000192' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446731' WHERE ordernumber = 'P2501090000193' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '297105' WHERE ordernumber = 'P2501090000199' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '251919' WHERE ordernumber = 'P2501090000206' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '133357' WHERE ordernumber = 'P2501090000207' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '146276' WHERE ordernumber = 'P2501090000210' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446734' WHERE ordernumber = 'P2501090000220' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446741' WHERE ordernumber = 'P2501090000223' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446742' WHERE ordernumber = 'P2501090000224' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '89653' WHERE ordernumber = 'P2501090000228' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446748' WHERE ordernumber = 'P2501090000229' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '370339' WHERE ordernumber = 'P2501090000231' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446750' WHERE ordernumber = 'P2501090000232' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '129234' WHERE ordernumber = 'P2501090000234' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '377422' WHERE ordernumber = 'P2501090000242' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '187890' WHERE ordernumber = 'P2501090000243' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446757' WHERE ordernumber = 'P2501090000244' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446758' WHERE ordernumber = 'P2501090000246' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446755' WHERE ordernumber = 'P2501090000252' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446754' WHERE ordernumber = 'P2501090000254' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '143853' WHERE ordernumber = 'P2501090000257' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '143853' WHERE ordernumber = 'P2501090000258' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '434092' WHERE ordernumber = 'P2501090000259' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446765' WHERE ordernumber = 'P2501090000263' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '398583' WHERE ordernumber = 'P2501090000265' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446768' WHERE ordernumber = 'P2501090000267' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '384952' WHERE ordernumber = 'P2501090000269' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '412721' WHERE ordernumber = 'P2501090000272' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446768' WHERE ordernumber = 'P2501090000274' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '122441' WHERE ordernumber = 'P2501090000275' 2025-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '398583' WHERE ordernumber = 'P2501090000278' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '344546' WHERE ordernumber = 'P2501090000279' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446773' WHERE ordernumber = 'P2501090000280' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '142030' WHERE ordernumber = 'P2501090000281' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '253283' WHERE ordernumber = 'P2501090000282' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446775' WHERE ordernumber = 'P2501090000284' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '49777' WHERE ordernumber = 'P2501090000285' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P2501090000287' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '252638' WHERE ordernumber = 'P2501090000291' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446777' WHERE ordernumber = 'P2501090000295' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '426282' WHERE ordernumber = 'P2501090000298' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '224834' WHERE ordernumber = 'P2501090000299' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '119575' WHERE ordernumber = 'P2501090000300' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '236193' WHERE ordernumber = 'P2501090000305' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446781' WHERE ordernumber = 'P2501090000306' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '266737' WHERE ordernumber = 'P2501090000307' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446783' WHERE ordernumber = 'P2501090000310' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '199750' WHERE ordernumber = 'P2501090000312' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446785' WHERE ordernumber = 'P2501090000315' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '441080' WHERE ordernumber = 'P2501090000317' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '433191' WHERE ordernumber = 'P2501090000324' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446791' WHERE ordernumber = 'P2501090000331' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '432712' WHERE ordernumber = 'P2501090000332' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446767' WHERE ordernumber = 'P2501090000336' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '170757' WHERE ordernumber = 'P2501090000337' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '337285' WHERE ordernumber = 'P2501090000338' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446779' WHERE ordernumber = 'P2501090000339' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446796' WHERE ordernumber = 'P2501090000342' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '440128' WHERE ordernumber = 'P2501090000344' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446331' WHERE ordernumber = 'P2501090000345' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '269426' WHERE ordernumber = 'P2501090000346' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '331477' WHERE ordernumber = 'P2501090000349' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446786' WHERE ordernumber = 'P2501090000350' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446798' WHERE ordernumber = 'P2501090000351' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '426310' WHERE ordernumber = 'P2501090000356' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '445001' WHERE ordernumber = 'P2501090000358' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446801' WHERE ordernumber = 'P2501090000360' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '231268' WHERE ordernumber = 'P2501090000361' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '443952' WHERE ordernumber = 'P2501090000363' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '435391' WHERE ordernumber = 'P2501090000365' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '406903' WHERE ordernumber = 'P2501090000367' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '442918' WHERE ordernumber = 'P2501090000368' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '268799' WHERE ordernumber = 'P2501090000370' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '130773' WHERE ordernumber = 'P2501090000379' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '345453' WHERE ordernumber = 'P2501090000382' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446812' WHERE ordernumber = 'P2501090000384' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '246327' WHERE ordernumber = 'P2501090000386' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '146731' WHERE ordernumber = 'P2501090000390' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446813' WHERE ordernumber = 'P2501090000393' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446818' WHERE ordernumber = 'P2501090000394' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '95250' WHERE ordernumber = 'P2501090000396' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '367183' WHERE ordernumber = 'P2501090000397' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '266092' WHERE ordernumber = 'P2501090000400' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '226896' WHERE ordernumber = 'P2501090000406' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '133286' WHERE ordernumber = 'P2501090000408' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '133286' WHERE ordernumber = 'P2501090000410' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '421492' WHERE ordernumber = 'P2501090000412' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '330251' WHERE ordernumber = 'P2501090000413' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '273391' WHERE ordernumber = 'P2501090000417' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '308636' WHERE ordernumber = 'P2501090000418' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446821' WHERE ordernumber = 'P2501090000421' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '399828' WHERE ordernumber = 'P2501090000422' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446822' WHERE ordernumber = 'P2501090000423' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '282484' WHERE ordernumber = 'P2501090000424' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '65115' WHERE ordernumber = 'P2501090000428' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '339701' WHERE ordernumber = 'P2501090000434' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '65115' WHERE ordernumber = 'P2501090000436' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '443984' WHERE ordernumber = 'P2501090000437' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '98529' WHERE ordernumber = 'P2501090000438' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446824' WHERE ordernumber = 'P2501090000440' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446827' WHERE ordernumber = 'P2501090000443' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '286541' WHERE ordernumber = 'P2501090000444' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '264691' WHERE ordernumber = 'P2501090000454' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '353257' WHERE ordernumber = 'P2501090000457' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446831' WHERE ordernumber = 'P2501090000461' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '309849' WHERE ordernumber = 'P2501090000462' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '438055' WHERE ordernumber = 'P2501090000470' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446832' WHERE ordernumber = 'P2501090000471' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '380457' WHERE ordernumber = 'P2501090000473' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '443466' WHERE ordernumber = 'P2501090000475' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446835' WHERE ordernumber = 'P2501090000476' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446839' WHERE ordernumber = 'P2501090000480' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '326311' WHERE ordernumber = 'P2501090000483' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446836' WHERE ordernumber = 'P2501090000487' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '429687' WHERE ordernumber = 'P2501090000491' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446841' WHERE ordernumber = 'P2501090000497' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446845' WHERE ordernumber = 'P2501090000504' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '223516' WHERE ordernumber = 'P2501090000505' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '326963' WHERE ordernumber = 'P2501090000508' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '360796' WHERE ordernumber = 'P2501090000510' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446849' WHERE ordernumber = 'P2501090000513' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '275266' WHERE ordernumber = 'P2501090000516' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '158812' WHERE ordernumber = 'P2501090000523' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '312829' WHERE ordernumber = 'P2501090000525' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446856' WHERE ordernumber = 'P2501090000529' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '216091' WHERE ordernumber = 'P2501090000531' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '304706' WHERE ordernumber = 'P2501090000533' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '434244' WHERE ordernumber = 'P2501090000539' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '395568' WHERE ordernumber = 'P2501090000543' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '440894' WHERE ordernumber = 'P2501090000551' 2025-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '446863' WHERE ordernumber = 'P2501090000557' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446865' WHERE ordernumber = 'P2501090000562' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '439788' WHERE ordernumber = 'P2501090000564' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '393759' WHERE ordernumber = 'P2501090000565' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '149109' WHERE ordernumber = 'P2501090000566' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '374243' WHERE ordernumber = 'P2501090000568' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '305541' WHERE ordernumber = 'P2501090000570' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '421972' WHERE ordernumber = 'P2501090000571' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '99549' WHERE ordernumber = 'P2501090000581' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '318625' WHERE ordernumber = 'P2501090000584' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '308233' WHERE ordernumber = 'P2501090000587' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446870' WHERE ordernumber = 'P2501090000590' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '161308' WHERE ordernumber = 'P2501090000592' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '283811' WHERE ordernumber = 'P2501090000593' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '326819' WHERE ordernumber = 'P2501090000597' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446871' WHERE ordernumber = 'P2501090000599' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '379342' WHERE ordernumber = 'P2501090000601' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446872' WHERE ordernumber = 'P2501090000604' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '222161' WHERE ordernumber = 'P2501090000606' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446875' WHERE ordernumber = 'P2501090000608' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '97885' WHERE ordernumber = 'P2501090000611' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '145770' WHERE ordernumber = 'P2501090000617' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '137141' WHERE ordernumber = 'P2501090000619' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '344831' WHERE ordernumber = 'P2501090000624' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '369887' WHERE ordernumber = 'P2501090000628' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '304297' WHERE ordernumber = 'P2501090000631' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '318659' WHERE ordernumber = 'P2501090000633' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '164905' WHERE ordernumber = 'P2501090000634' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '100700' WHERE ordernumber = 'P2501090000637' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446883' WHERE ordernumber = 'P2501090000641' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '328319' WHERE ordernumber = 'P2501090000642' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '281876' WHERE ordernumber = 'P2501090000643' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '110087' WHERE ordernumber = 'P2501090000645' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '442288' WHERE ordernumber = 'P2501090000648' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '443365' WHERE ordernumber = 'P2501090000651' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '274699' WHERE ordernumber = 'P2501090000652' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446892' WHERE ordernumber = 'P2501090000659' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '265892' WHERE ordernumber = 'P2501090000660' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446893' WHERE ordernumber = 'P2501090000664' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '444413' WHERE ordernumber = 'P2501090000665' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '420673' WHERE ordernumber = 'P2501090000669' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '420673' WHERE ordernumber = 'P2501090000671' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446895' WHERE ordernumber = 'P2501090000672' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446900' WHERE ordernumber = 'P2501090000673' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '309779' WHERE ordernumber = 'P2501090000676' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '233520' WHERE ordernumber = 'P2501090000682' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '441318' WHERE ordernumber = 'P2501090000686' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '297470' WHERE ordernumber = 'P2501090000691' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '163294' WHERE ordernumber = 'P2501090000702' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446912' WHERE ordernumber = 'P2501090000710' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '441709' WHERE ordernumber = 'P2501090000711' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '372255' WHERE ordernumber = 'P2501090000714' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446913' WHERE ordernumber = 'P2501090000718' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '165847' WHERE ordernumber = 'P2501090000719' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '242496' WHERE ordernumber = 'P2501090000721' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '266705' WHERE ordernumber = 'P2501090000722' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446914' WHERE ordernumber = 'P2501090000725' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '380886' WHERE ordernumber = 'P2501090000728' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '379086' WHERE ordernumber = 'P2501090000730' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '379804' WHERE ordernumber = 'P2501090000732' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '384019' WHERE ordernumber = 'P2501090000733' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '380994' WHERE ordernumber = 'P2501090000736' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '444970' WHERE ordernumber = 'P2501090000738' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446701' WHERE ordernumber = 'P2501090000742' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446701' WHERE ordernumber = 'P2501090000744' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446701' WHERE ordernumber = 'P2501090000749' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '443531' WHERE ordernumber = 'P2501090000750' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '284526' WHERE ordernumber = 'P2501090000751' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '208779' WHERE ordernumber = 'P2501090000753' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446924' WHERE ordernumber = 'P2501090000756' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '405596' WHERE ordernumber = 'P2501090000757' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '435858' WHERE ordernumber = 'P2501090000758' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '271605' WHERE ordernumber = 'P2501090000760' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '130570' WHERE ordernumber = 'P2501090000761' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '128717' WHERE ordernumber = 'P2501090000763' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '271605' WHERE ordernumber = 'P2501090000765' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '164917' WHERE ordernumber = 'P2501090000766' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '423132' WHERE ordernumber = 'P2501090000767' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '350324' WHERE ordernumber = 'P2501090000769' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '114042' WHERE ordernumber = 'P2501090000771' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '332742' WHERE ordernumber = 'P2501090000772' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446929' WHERE ordernumber = 'P2501090000774' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '330251' WHERE ordernumber = 'P2501090000776' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '417962' WHERE ordernumber = 'P2501090000779' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '419623' WHERE ordernumber = 'P2501090000783' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '426359' WHERE ordernumber = 'P2501090000784' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '65135' WHERE ordernumber = 'P2501090000785' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '377386' WHERE ordernumber = 'P2501090000789' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446934' WHERE ordernumber = 'P2501090000791' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446935' WHERE ordernumber = 'P2501090000793' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446939' WHERE ordernumber = 'P2501090000796' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446942' WHERE ordernumber = 'P2501090000801' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '432705' WHERE ordernumber = 'P2501090000804' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '425524' WHERE ordernumber = 'P2501090000806' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446459' WHERE ordernumber = 'P2501090000809' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446459' WHERE ordernumber = 'P2501090000810' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '432705' WHERE ordernumber = 'P2501090000812' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446946' WHERE ordernumber = 'P2501090000815' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446459' WHERE ordernumber = 'P2501090000820' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '291869' WHERE ordernumber = 'P2501090000823' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '405276' WHERE ordernumber = 'P2501090000827' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '283578' WHERE ordernumber = 'P2501090000835' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '390062' WHERE ordernumber = 'P2501090000836' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '121902' WHERE ordernumber = 'P2501090000837' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446953' WHERE ordernumber = 'P2501090000838' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446957' WHERE ordernumber = 'P2501090000847' 2025-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '446960' WHERE ordernumber = 'P2501090000856' 2025-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '298013' WHERE ordernumber = 'P2501090000859' 2025-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '403639' WHERE ordernumber = 'P2501090000862' 2025-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '383688' WHERE ordernumber = 'P2501090000865' 2025-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '446962' WHERE ordernumber = 'P2501090000867' 2025-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '446964' WHERE ordernumber = 'P2501090000869' 2025-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '441257' WHERE ordernumber = 'P2501090000881' 2025-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '446966' WHERE ordernumber = 'P2501090000882' 2025-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '269954' WHERE ordernumber = 'P2501090000884' 2025-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '446968' WHERE ordernumber = 'P2501090000886' 2025-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '431884' WHERE ordernumber = 'P2501090000894' 2025-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '25' WHERE ordernumber = 'P2501090000895'