2025-01-16 01:00:02 -- 將會員中心id寫入data-lake 2025-01-16 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-15%'; 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '327708' WHERE ordernumber = 'P2501150000012' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '449988' WHERE ordernumber = 'P2501150000014' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '90959' WHERE ordernumber = 'P2501150000016' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '139543' WHERE ordernumber = 'P2501150000019' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '96489' WHERE ordernumber = 'P2501150000020' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '421735' WHERE ordernumber = 'P2501150000026' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '449964' WHERE ordernumber = 'P2501150000027' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '277858' WHERE ordernumber = 'P2501150000028' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '449991' WHERE ordernumber = 'P2501150000030' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '125897' WHERE ordernumber = 'P2501150000031' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '449407' WHERE ordernumber = 'P2501150000036' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '295216' WHERE ordernumber = 'P2501150000038' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '360674' WHERE ordernumber = 'P2501150000039' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '360674' WHERE ordernumber = 'P2501150000042' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '449992' WHERE ordernumber = 'P2501150000045' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '449993' WHERE ordernumber = 'P2501150000046' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '201629' WHERE ordernumber = 'P2501150000047' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '449407' WHERE ordernumber = 'P2501150000049' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '436916' WHERE ordernumber = 'P2501150000052' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '297128' WHERE ordernumber = 'P2501150000053' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '449997' WHERE ordernumber = 'P2501150000056' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '236420' WHERE ordernumber = 'P2501150000058' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '436916' WHERE ordernumber = 'P2501150000060' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '208650' WHERE ordernumber = 'P2501150000061' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '409234' WHERE ordernumber = 'P2501150000062' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '370803' WHERE ordernumber = 'P2501150000063' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '448632' WHERE ordernumber = 'P2501150000066' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '406029' WHERE ordernumber = 'P2501150000068' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '450002' WHERE ordernumber = 'P2501150000071' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '449803' WHERE ordernumber = 'P2501150000074' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '266242' WHERE ordernumber = 'P2501150000078' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '266242' WHERE ordernumber = 'P2501150000080' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '450006' WHERE ordernumber = 'P2501150000082' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '449996' WHERE ordernumber = 'P2501150000091' 2025-01-16 01:00:02 -- UPDATE `omo_order_list` SET userId = '437137' WHERE ordernumber = 'P2501150000095' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '163307' WHERE ordernumber = 'P2501150000096' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '447112' WHERE ordernumber = 'P2501150000099' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '297772' WHERE ordernumber = 'P2501150000100' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450010' WHERE ordernumber = 'P2501150000102' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '445129' WHERE ordernumber = 'P2501150000107' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450011' WHERE ordernumber = 'P2501150000108' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450013' WHERE ordernumber = 'P2501150000114' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '430872' WHERE ordernumber = 'P2501150000117' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '430872' WHERE ordernumber = 'P2501150000119' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '81394' WHERE ordernumber = 'P2501150000120' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '242607' WHERE ordernumber = 'P2501150000124' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '430037' WHERE ordernumber = 'P2501150000126' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '381201' WHERE ordernumber = 'P2501150000127' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '367171' WHERE ordernumber = 'P2501150000130' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '420874' WHERE ordernumber = 'P2501150000132' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '314990' WHERE ordernumber = 'P2501150000134' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '437137' WHERE ordernumber = 'P2501150000135' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '389445' WHERE ordernumber = 'P2501150000138' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '334955' WHERE ordernumber = 'P2501150000151' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '368090' WHERE ordernumber = 'P2501150000153' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '448762' WHERE ordernumber = 'P2501150000154' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450018' WHERE ordernumber = 'P2501150000155' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450022' WHERE ordernumber = 'P2501150000157' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '446675' WHERE ordernumber = 'P2501150000159' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450023' WHERE ordernumber = 'P2501150000162' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '446675' WHERE ordernumber = 'P2501150000163' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '423699' WHERE ordernumber = 'P2501150000166' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450026' WHERE ordernumber = 'P2501150000167' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '142569' WHERE ordernumber = 'P2501150000170' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '142569' WHERE ordernumber = 'P2501150000173' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '110087' WHERE ordernumber = 'P2501150000176' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '116319' WHERE ordernumber = 'P2501150000178' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450031' WHERE ordernumber = 'P2501150000182' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450033' WHERE ordernumber = 'P2501150000189' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450036' WHERE ordernumber = 'P2501150000194' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '449899' WHERE ordernumber = 'P2501150000197' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '387761' WHERE ordernumber = 'P2501150000199' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '143159' WHERE ordernumber = 'P2501150000200' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '240484' WHERE ordernumber = 'P2501150000202' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '370320' WHERE ordernumber = 'P2501150000204' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450036' WHERE ordernumber = 'P2501150000205' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '435040' WHERE ordernumber = 'P2501150000213' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450042' WHERE ordernumber = 'P2501150000221' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '90055' WHERE ordernumber = 'P2501150000224' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450028' WHERE ordernumber = 'P2501150000225' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450046' WHERE ordernumber = 'P2501150000230' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '137273' WHERE ordernumber = 'P2501150000236' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '269501' WHERE ordernumber = 'P2501150000238' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '417016' WHERE ordernumber = 'P2501150000240' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '449802' WHERE ordernumber = 'P2501150000241' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '388638' WHERE ordernumber = 'P2501150000244' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '284083' WHERE ordernumber = 'P2501150000246' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '284083' WHERE ordernumber = 'P2501150000247' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '247927' WHERE ordernumber = 'P2501150000249' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '416947' WHERE ordernumber = 'P2501150000251' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '290002' WHERE ordernumber = 'P2501150000255' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450054' WHERE ordernumber = 'P2501150000258' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450059' WHERE ordernumber = 'P2501150000259' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '73653' WHERE ordernumber = 'P2501150000265' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '73653' WHERE ordernumber = 'P2501150000266' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450063' WHERE ordernumber = 'P2501150000274' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '132013' WHERE ordernumber = 'P2501150000276' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '393184' WHERE ordernumber = 'P2501150000279' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '270895' WHERE ordernumber = 'P2501150000283' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '248308' WHERE ordernumber = 'P2501150000290' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450068' WHERE ordernumber = 'P2501150000292' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '305466' WHERE ordernumber = 'P2501150000295' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '444999' WHERE ordernumber = 'P2501150000297' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '342330' WHERE ordernumber = 'P2501150000300' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '208288' WHERE ordernumber = 'P2501150000306' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '443006' WHERE ordernumber = 'P2501150000307' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '401915' WHERE ordernumber = 'P2501150000309' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '353938' WHERE ordernumber = 'P2501150000312' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '326819' WHERE ordernumber = 'P2501150000318' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '305466' WHERE ordernumber = 'P2501150000320' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450074' WHERE ordernumber = 'P2501150000321' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '445089' WHERE ordernumber = 'P2501150000324' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450070' WHERE ordernumber = 'P2501150000325' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '450075' WHERE ordernumber = 'P2501150000328' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '431873' WHERE ordernumber = 'P2501150000330' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '353938' WHERE ordernumber = 'P2501150000333' 2025-01-16 01:00:03 -- UPDATE `omo_order_list` SET userId = '449385' WHERE ordernumber = 'P2501150000340' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '449385' WHERE ordernumber = 'P2501150000341' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '377582' WHERE ordernumber = 'P2501150000345' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450081' WHERE ordernumber = 'P2501150000348' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '436978' WHERE ordernumber = 'P2501150000351' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '262148' WHERE ordernumber = 'P2501150000354' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '336969' WHERE ordernumber = 'P2501150000358' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '187123' WHERE ordernumber = 'P2501150000359' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450085' WHERE ordernumber = 'P2501150000361' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '329843' WHERE ordernumber = 'P2501150000363' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '111293' WHERE ordernumber = 'P2501150000368' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450088' WHERE ordernumber = 'P2501150000371' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '420652' WHERE ordernumber = 'P2501150000372' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450091' WHERE ordernumber = 'P2501150000377' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '338266' WHERE ordernumber = 'P2501150000378' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '363804' WHERE ordernumber = 'P2501150000383' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450096' WHERE ordernumber = 'P2501150000384' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450095' WHERE ordernumber = 'P2501150000385' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '447170' WHERE ordernumber = 'P2501150000388' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '96012' WHERE ordernumber = 'P2501150000395' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '183779' WHERE ordernumber = 'P2501150000397' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '105863' WHERE ordernumber = 'P2501150000399' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '447260' WHERE ordernumber = 'P2501150000402' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450103' WHERE ordernumber = 'P2501150000406' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '287985' WHERE ordernumber = 'P2501150000409' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '374930' WHERE ordernumber = 'P2501150000411' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '367679' WHERE ordernumber = 'P2501150000413' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '420577' WHERE ordernumber = 'P2501150000416' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '374930' WHERE ordernumber = 'P2501150000417' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450106' WHERE ordernumber = 'P2501150000418' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '221676' WHERE ordernumber = 'P2501150000422' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450106' WHERE ordernumber = 'P2501150000423' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450110' WHERE ordernumber = 'P2501150000428' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '297533' WHERE ordernumber = 'P2501150000429' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450111' WHERE ordernumber = 'P2501150000431' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450112' WHERE ordernumber = 'P2501150000432' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '297533' WHERE ordernumber = 'P2501150000433' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450113' WHERE ordernumber = 'P2501150000435' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450116' WHERE ordernumber = 'P2501150000436' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '94592' WHERE ordernumber = 'P2501150000437' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '297533' WHERE ordernumber = 'P2501150000438' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450117' WHERE ordernumber = 'P2501150000440' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450118' WHERE ordernumber = 'P2501150000441' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450120' WHERE ordernumber = 'P2501150000445' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450122' WHERE ordernumber = 'P2501150000447' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450124' WHERE ordernumber = 'P2501150000449' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '38020' WHERE ordernumber = 'P2501150000450' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '274916' WHERE ordernumber = 'P2501150000452' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450122' WHERE ordernumber = 'P2501150000453' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450127' WHERE ordernumber = 'P2501150000454' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '124039' WHERE ordernumber = 'P2501150000455' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450130' WHERE ordernumber = 'P2501150000472' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '388265' WHERE ordernumber = 'P2501150000473' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '86632' WHERE ordernumber = 'P2501150000476' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450134' WHERE ordernumber = 'P2501150000480' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '305503' WHERE ordernumber = 'P2501150000485' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '377132' WHERE ordernumber = 'P2501150000486' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '443502' WHERE ordernumber = 'P2501150000488' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450137' WHERE ordernumber = 'P2501150000493' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '222561' WHERE ordernumber = 'P2501150000494' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '372491' WHERE ordernumber = 'P2501150000499' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '439331' WHERE ordernumber = 'P2501150000509' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '222561' WHERE ordernumber = 'P2501150000511' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '294525' WHERE ordernumber = 'P2501150000513' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '421804' WHERE ordernumber = 'P2501150000515' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '209365' WHERE ordernumber = 'P2501150000518' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '270493' WHERE ordernumber = 'P2501150000523' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '334030' WHERE ordernumber = 'P2501150000527' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '414217' WHERE ordernumber = 'P2501150000533' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '285235' WHERE ordernumber = 'P2501150000534' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450143' WHERE ordernumber = 'P2501150000540' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450144' WHERE ordernumber = 'P2501150000543' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '91537' WHERE ordernumber = 'P2501150000563' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '219860' WHERE ordernumber = 'P2501150000564' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '414544' WHERE ordernumber = 'P2501150000568' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '383588' WHERE ordernumber = 'P2501150000570' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '388537' WHERE ordernumber = 'P2501150000582' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '448001' WHERE ordernumber = 'P2501150000585' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450154' WHERE ordernumber = 'P2501150000586' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '40753' WHERE ordernumber = 'P2501150000590' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '269495' WHERE ordernumber = 'P2501150000591' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450157' WHERE ordernumber = 'P2501150000595' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450158' WHERE ordernumber = 'P2501150000600' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '450159' WHERE ordernumber = 'P2501150000605' 2025-01-16 01:00:04 -- UPDATE `omo_order_list` SET userId = '258030' WHERE ordernumber = 'P2501150000608' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '367443' WHERE ordernumber = 'P2501150000613' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450163' WHERE ordernumber = 'P2501150000625' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450165' WHERE ordernumber = 'P2501150000641' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '447010' WHERE ordernumber = 'P2501150000650' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '223982' WHERE ordernumber = 'P2501150000656' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450169' WHERE ordernumber = 'P2501150000658' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '297523' WHERE ordernumber = 'P2501150000663' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '371608' WHERE ordernumber = 'P2501150000669' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '349026' WHERE ordernumber = 'P2501150000672' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '366123' WHERE ordernumber = 'P2501150000673' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450172' WHERE ordernumber = 'P2501150000677' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '348450' WHERE ordernumber = 'P2501150000687' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '223674' WHERE ordernumber = 'P2501150000689' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450174' WHERE ordernumber = 'P2501150000690' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '438471' WHERE ordernumber = 'P2501150000692' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '448863' WHERE ordernumber = 'P2501150000696' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450179' WHERE ordernumber = 'P2501150000707' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450178' WHERE ordernumber = 'P2501150000708' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450180' WHERE ordernumber = 'P2501150000714' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450180' WHERE ordernumber = 'P2501150000718' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '368655' WHERE ordernumber = 'P2501150000725' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '372070' WHERE ordernumber = 'P2501150000728' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '368655' WHERE ordernumber = 'P2501150000730' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450186' WHERE ordernumber = 'P2501150000731' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '426496' WHERE ordernumber = 'P2501150000733' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '441692' WHERE ordernumber = 'P2501150000735' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '441692' WHERE ordernumber = 'P2501150000738' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '104725' WHERE ordernumber = 'P2501150000741' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '374877' WHERE ordernumber = 'P2501150000742' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '374877' WHERE ordernumber = 'P2501150000748' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '341013' WHERE ordernumber = 'P2501150000750' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450190' WHERE ordernumber = 'P2501150000751' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450191' WHERE ordernumber = 'P2501150000757' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450192' WHERE ordernumber = 'P2501150000761' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '94815' WHERE ordernumber = 'P2501150000762' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '97359' WHERE ordernumber = 'P2501150000764' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '94815' WHERE ordernumber = 'P2501150000766' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '276021' WHERE ordernumber = 'P2501150000770' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '449508' WHERE ordernumber = 'P2501150000782' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '403467' WHERE ordernumber = 'P2501150000783' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450197' WHERE ordernumber = 'P2501150000786' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '438521' WHERE ordernumber = 'P2501150000790' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '346832' WHERE ordernumber = 'P2501150000794' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '393676' WHERE ordernumber = 'P2501150000798' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '444384' WHERE ordernumber = 'P2501150000799' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '276251' WHERE ordernumber = 'P2501150000803' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '270505' WHERE ordernumber = 'P2501150000812' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '434904' WHERE ordernumber = 'P2501150000813' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '313500' WHERE ordernumber = 'P2501150000817' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '127285' WHERE ordernumber = 'P2501150000822' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '444962' WHERE ordernumber = 'P2501150000825' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '211267' WHERE ordernumber = 'P2501150000833' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '441390' WHERE ordernumber = 'P2501150000836' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '236963' WHERE ordernumber = 'P2501150000837' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '183779' WHERE ordernumber = 'P2501150000841' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450210' WHERE ordernumber = 'P2501150000845' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '367349' WHERE ordernumber = 'P2501150000849' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '411501' WHERE ordernumber = 'P2501150000851' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '328828' WHERE ordernumber = 'P2501150000855' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '155543' WHERE ordernumber = 'P2501150000864' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450215' WHERE ordernumber = 'P2501150000865' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '436266' WHERE ordernumber = 'P2501150000868' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '449242' WHERE ordernumber = 'P2501150000869' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '377844' WHERE ordernumber = 'P2501150000878' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '369351' WHERE ordernumber = 'P2501150000881' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '447999' WHERE ordernumber = 'P2501150000882' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450223' WHERE ordernumber = 'P2501150000885' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450224' WHERE ordernumber = 'P2501150000890' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '377844' WHERE ordernumber = 'P2501150000891' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450226' WHERE ordernumber = 'P2501150000893' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '389005' WHERE ordernumber = 'P2501150000894' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '279863' WHERE ordernumber = 'P2501150000897' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '52558' WHERE ordernumber = 'P2501150000904' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '166887' WHERE ordernumber = 'P2501150000909' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '442143' WHERE ordernumber = 'P2501150000912' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450232' WHERE ordernumber = 'P2501150000920' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '404125' WHERE ordernumber = 'P2501150000921' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450234' WHERE ordernumber = 'P2501150000924' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '396773' WHERE ordernumber = 'P2501150000926' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '256945' WHERE ordernumber = 'P2501150000928' 2025-01-16 01:00:05 -- UPDATE `omo_order_list` SET userId = '450236' WHERE ordernumber = 'P2501150000931' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450238' WHERE ordernumber = 'P2501150000932' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '41940' WHERE ordernumber = 'P2501150000936' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '444404' WHERE ordernumber = 'P2501150000938' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '271551' WHERE ordernumber = 'P2501150000941' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '242026' WHERE ordernumber = 'P2501150000943' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '432655' WHERE ordernumber = 'P2501150000946' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450241' WHERE ordernumber = 'P2501150000947' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '165847' WHERE ordernumber = 'P2501150000948' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '352678' WHERE ordernumber = 'P2501150000952' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '439827' WHERE ordernumber = 'P2501150000954' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '242582' WHERE ordernumber = 'P2501150000955' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '427413' WHERE ordernumber = 'P2501150000956' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '327120' WHERE ordernumber = 'P2501150000966' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '261694' WHERE ordernumber = 'P2501150000973' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450246' WHERE ordernumber = 'P2501150000974' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '238267' WHERE ordernumber = 'P2501150000976' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '171084' WHERE ordernumber = 'P2501150000986' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '445878' WHERE ordernumber = 'P2501150000987' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450252' WHERE ordernumber = 'P2501150000991' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '379615' WHERE ordernumber = 'P2501150000992' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '433234' WHERE ordernumber = 'P2501150000994' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450254' WHERE ordernumber = 'P2501150000996' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '400921' WHERE ordernumber = 'P2501150000997' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '377386' WHERE ordernumber = 'P2501150001003' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '164213' WHERE ordernumber = 'P2501150001007' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450260' WHERE ordernumber = 'P2501150001009' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '297585' WHERE ordernumber = 'P2501150001011' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '279886' WHERE ordernumber = 'P2501150001012' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '206883' WHERE ordernumber = 'P2501150001014' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450262' WHERE ordernumber = 'P2501150001016' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '232968' WHERE ordernumber = 'P2501150001018' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450263' WHERE ordernumber = 'P2501150001019' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450266' WHERE ordernumber = 'P2501150001024' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450269' WHERE ordernumber = 'P2501150001027' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '319110' WHERE ordernumber = 'P2501150001029' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '102280' WHERE ordernumber = 'P2501150001033' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '128489' WHERE ordernumber = 'P2501150001031' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450271' WHERE ordernumber = 'P2501150001036' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '98228' WHERE ordernumber = 'P2501150001038' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '164298' WHERE ordernumber = 'P2501150001045' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '372331' WHERE ordernumber = 'P2501150001046' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '410720' WHERE ordernumber = 'P2501150001049' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '442293' WHERE ordernumber = 'P2501150001052' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450275' WHERE ordernumber = 'P2501150001054' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450276' WHERE ordernumber = 'P2501150001060' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '284664' WHERE ordernumber = 'P2501150001064' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450277' WHERE ordernumber = 'P2501150001065' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '271548' WHERE ordernumber = 'P2501150001071' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '113148' WHERE ordernumber = 'P2501150001073' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '166831' WHERE ordernumber = 'P2501150001088' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '308402' WHERE ordernumber = 'P2501150001091' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '100831' WHERE ordernumber = 'P2501150001092' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450287' WHERE ordernumber = 'P2501150001095' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450288' WHERE ordernumber = 'P2501150001096' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450289' WHERE ordernumber = 'P2501150001097' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '287464' WHERE ordernumber = 'P2501150001098' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '156903' WHERE ordernumber = 'P2501150001105' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '450289' WHERE ordernumber = 'P2501150001106' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '273330' WHERE ordernumber = 'P2501150001126' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '446820' WHERE ordernumber = 'P2501150001129' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '244863' WHERE ordernumber = 'P2501150001131' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '437493' WHERE ordernumber = 'P2501150001132' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '437493' WHERE ordernumber = 'P2501150001133' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '442242' WHERE ordernumber = 'P2501150001146' 2025-01-16 01:00:06 -- UPDATE `omo_order_list` SET userId = '448021' WHERE ordernumber = 'P2501150001160'