2025-03-09 01:00:01 -- 將會員中心id寫入data-lake 2025-03-09 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 '2025-03-08%'; 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '458631' WHERE ordernumber = 'P2503080000022' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '288128' WHERE ordernumber = 'P2503080000025' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '443593' WHERE ordernumber = 'P2503080000027' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '446134' WHERE ordernumber = 'P2503080000028' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '284049' WHERE ordernumber = 'P2503080000030' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '390242' WHERE ordernumber = 'P2503080000032' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '418858' WHERE ordernumber = 'P2503080000033' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '418858' WHERE ordernumber = 'P2503080000034' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459928' WHERE ordernumber = 'P2503080000035' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459930' WHERE ordernumber = 'P2503080000037' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459929' WHERE ordernumber = 'P2503080000039' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459931' WHERE ordernumber = 'P2503080000042' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459932' WHERE ordernumber = 'P2503080000047' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '424318' WHERE ordernumber = 'P2503080000049' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '429756' WHERE ordernumber = 'P2503080000050' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '329571' WHERE ordernumber = 'P2503080000051' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459933' WHERE ordernumber = 'P2503080000054' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459934' WHERE ordernumber = 'P2503080000056' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459935' WHERE ordernumber = 'P2503080000057' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '186695' WHERE ordernumber = 'P2503080000067' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459937' WHERE ordernumber = 'P2503080000069' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '458684' WHERE ordernumber = 'P2503080000071' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '123357' WHERE ordernumber = 'P2503080000074' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '353995' WHERE ordernumber = 'P2503080000075' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '387231' WHERE ordernumber = 'P2503080000077' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459938' WHERE ordernumber = 'P2503080000085' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459607' WHERE ordernumber = 'P2503080000086' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '241198' WHERE ordernumber = 'P2503080000087' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '377610' WHERE ordernumber = 'P2503080000088' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '203511' WHERE ordernumber = 'P2503080000090' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459370' WHERE ordernumber = 'P2503080000100' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '252127' WHERE ordernumber = 'P2503080000101' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '456698' WHERE ordernumber = 'P2503080000106' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '307594' WHERE ordernumber = 'P2503080000108' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459939' WHERE ordernumber = 'P2503080000109' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '346850' WHERE ordernumber = 'P2503080000112' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '422999' WHERE ordernumber = 'P2503080000113' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '210658' WHERE ordernumber = 'P2503080000114' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '282636' WHERE ordernumber = 'P2503080000118' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '380155' WHERE ordernumber = 'P2503080000121' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '432322' WHERE ordernumber = 'P2503080000123' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '78001' WHERE ordernumber = 'P2503080000125' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '398332' WHERE ordernumber = 'P2503080000127' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '78001' WHERE ordernumber = 'P2503080000128' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459941' WHERE ordernumber = 'P2503080000131' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '459942' WHERE ordernumber = 'P2503080000133' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '158673' WHERE ordernumber = 'P2503080000138' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '420550' WHERE ordernumber = 'P2503080000140' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '242753' WHERE ordernumber = 'P2503080000144' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '247587' WHERE ordernumber = 'P2503080000149' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '453928' WHERE ordernumber = 'P2503080000152' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '292426' WHERE ordernumber = 'P2503080000155' 2025-03-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '289061' WHERE ordernumber = 'P2503080000163' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459943' WHERE ordernumber = 'P2503080000165' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459944' WHERE ordernumber = 'P2503080000166' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '208641' WHERE ordernumber = 'P2503080000168' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459945' WHERE ordernumber = 'P2503080000169' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '99468' WHERE ordernumber = 'P2503080000170' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459944' WHERE ordernumber = 'P2503080000171' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459947' WHERE ordernumber = 'P2503080000173' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459952' WHERE ordernumber = 'P2503080000175' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459949' WHERE ordernumber = 'P2503080000179' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '342992' WHERE ordernumber = 'P2503080000182' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459948' WHERE ordernumber = 'P2503080000184' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '273902' WHERE ordernumber = 'P2503080000185' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '65358' WHERE ordernumber = 'P2503080000186' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '263628' WHERE ordernumber = 'P2503080000187' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459953' WHERE ordernumber = 'P2503080000189' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459954' WHERE ordernumber = 'P2503080000194' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459955' WHERE ordernumber = 'P2503080000198' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '447662' WHERE ordernumber = 'P2503080000200' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '444011' WHERE ordernumber = 'P2503080000204' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '162011' WHERE ordernumber = 'P2503080000209' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459956' WHERE ordernumber = 'P2503080000210' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459958' WHERE ordernumber = 'P2503080000215' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459959' WHERE ordernumber = 'P2503080000219' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '432814' WHERE ordernumber = 'P2503080000221' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '397129' WHERE ordernumber = 'P2503080000224' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '349225' WHERE ordernumber = 'P2503080000226' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459961' WHERE ordernumber = 'P2503080000228' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '302951' WHERE ordernumber = 'P2503080000232' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '116779' WHERE ordernumber = 'P2503080000235' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459962' WHERE ordernumber = 'P2503080000238' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459962' WHERE ordernumber = 'P2503080000239' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459962' WHERE ordernumber = 'P2503080000240' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459960' WHERE ordernumber = 'P2503080000242' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '178925' WHERE ordernumber = 'P2503080000247' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '379508' WHERE ordernumber = 'P2503080000248' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '261162' WHERE ordernumber = 'P2503080000250' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459964' WHERE ordernumber = 'P2503080000252' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459965' WHERE ordernumber = 'P2503080000254' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459966' WHERE ordernumber = 'P2503080000255' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '338997' WHERE ordernumber = 'P2503080000256' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459968' WHERE ordernumber = 'P2503080000257' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459967' WHERE ordernumber = 'P2503080000258' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459969' WHERE ordernumber = 'P2503080000259' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459970' WHERE ordernumber = 'P2503080000262' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459971' WHERE ordernumber = 'P2503080000263' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '277442' WHERE ordernumber = 'P2503080000267' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459972' WHERE ordernumber = 'P2503080000270' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '455708' WHERE ordernumber = 'P2503080000271' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '319847' WHERE ordernumber = 'P2503080000276' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '313332' WHERE ordernumber = 'P2503080000283' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459973' WHERE ordernumber = 'P2503080000284' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459974' WHERE ordernumber = 'P2503080000288' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '280371' WHERE ordernumber = 'P2503080000291' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459975' WHERE ordernumber = 'P2503080000292' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459976' WHERE ordernumber = 'P2503080000294' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459963' WHERE ordernumber = 'P2503080000295' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459973' WHERE ordernumber = 'P2503080000296' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459977' WHERE ordernumber = 'P2503080000297' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459978' WHERE ordernumber = 'P2503080000299' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '137965' WHERE ordernumber = 'P2503080000300' 2025-03-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '459963' WHERE ordernumber = 'P2503080000302' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459980' WHERE ordernumber = 'P2503080000304' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459979' WHERE ordernumber = 'P2503080000306' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459981' WHERE ordernumber = 'P2503080000308' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '224874' WHERE ordernumber = 'P2503080000309' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '94659' WHERE ordernumber = 'P2503080000310' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '106438' WHERE ordernumber = 'P2503080000313' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459983' WHERE ordernumber = 'P2503080000314' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '341482' WHERE ordernumber = 'P2503080000318' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '349805' WHERE ordernumber = 'P2503080000321' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459984' WHERE ordernumber = 'P2503080000323' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459987' WHERE ordernumber = 'P2503080000326' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459990' WHERE ordernumber = 'P2503080000331' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '94659' WHERE ordernumber = 'P2503080000332' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '283250' WHERE ordernumber = 'P2503080000336' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459982' WHERE ordernumber = 'P2503080000340' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '389128' WHERE ordernumber = 'P2503080000343' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459986' WHERE ordernumber = 'P2503080000344' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459985' WHERE ordernumber = 'P2503080000347' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '373242' WHERE ordernumber = 'P2503080000348' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459990' WHERE ordernumber = 'P2503080000350' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '167330' WHERE ordernumber = 'P2503080000353' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459988' WHERE ordernumber = 'P2503080000358' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459776' WHERE ordernumber = 'P2503080000359' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459991' WHERE ordernumber = 'P2503080000363' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459775' WHERE ordernumber = 'P2503080000366' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459992' WHERE ordernumber = 'P2503080000367' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '137106' WHERE ordernumber = 'P2503080000369' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '282020' WHERE ordernumber = 'P2503080000370' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459993' WHERE ordernumber = 'P2503080000373' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '41969' WHERE ordernumber = 'P2503080000377' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459994' WHERE ordernumber = 'P2503080000382' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459995' WHERE ordernumber = 'P2503080000383' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '416454' WHERE ordernumber = 'P2503080000384' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459996' WHERE ordernumber = 'P2503080000386' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '416509' WHERE ordernumber = 'P2503080000392' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459999' WHERE ordernumber = 'P2503080000395' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '397716' WHERE ordernumber = 'P2503080000399' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '380608' WHERE ordernumber = 'P2503080000402' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '452254' WHERE ordernumber = 'P2503080000404' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '239205' WHERE ordernumber = 'P2503080000406' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '459998' WHERE ordernumber = 'P2503080000409' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '421282' WHERE ordernumber = 'P2503080000411' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460000' WHERE ordernumber = 'P2503080000417' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460001' WHERE ordernumber = 'P2503080000420' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460002' WHERE ordernumber = 'P2503080000422' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460004' WHERE ordernumber = 'P2503080000425' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460003' WHERE ordernumber = 'P2503080000427' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460005' WHERE ordernumber = 'P2503080000434' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460007' WHERE ordernumber = 'P2503080000439' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '199266' WHERE ordernumber = 'P2503080000440' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460006' WHERE ordernumber = 'P2503080000441' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460008' WHERE ordernumber = 'P2503080000442' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '199266' WHERE ordernumber = 'P2503080000444' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460010' WHERE ordernumber = 'P2503080000451' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460011' WHERE ordernumber = 'P2503080000454' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460009' WHERE ordernumber = 'P2503080000455' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460012' WHERE ordernumber = 'P2503080000462' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '460013' WHERE ordernumber = 'P2503080000466' 2025-03-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '336699' WHERE ordernumber = 'P2503080000468' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '458634' WHERE ordernumber = 'P2503080000469' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460014' WHERE ordernumber = 'P2503080000470' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '94648' WHERE ordernumber = 'P2503080000472' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460013' WHERE ordernumber = 'P2503080000474' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '377535' WHERE ordernumber = 'P2503080000476' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '458418' WHERE ordernumber = 'P2503080000481' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '344815' WHERE ordernumber = 'P2503080000483' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '367904' WHERE ordernumber = 'P2503080000494' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '380902' WHERE ordernumber = 'P2503080000499' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '399970' WHERE ordernumber = 'P2503080000500' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460015' WHERE ordernumber = 'P2503080000502' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460017' WHERE ordernumber = 'P2503080000505' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '436777' WHERE ordernumber = 'P2503080000506' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '400207' WHERE ordernumber = 'P2503080000507' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460018' WHERE ordernumber = 'P2503080000509' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '287162' WHERE ordernumber = 'P2503080000510' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '412466' WHERE ordernumber = 'P2503080000520' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460019' WHERE ordernumber = 'P2503080000521' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '94945' WHERE ordernumber = 'P2503080000526' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460020' WHERE ordernumber = 'P2503080000527' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460022' WHERE ordernumber = 'P2503080000531' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '169204' WHERE ordernumber = 'P2503080000533' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '169204' WHERE ordernumber = 'P2503080000534' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460021' WHERE ordernumber = 'P2503080000537' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '354406' WHERE ordernumber = 'P2503080000538' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460023' WHERE ordernumber = 'P2503080000540' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '454166' WHERE ordernumber = 'P2503080000541' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '169204' WHERE ordernumber = 'P2503080000543' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460024' WHERE ordernumber = 'P2503080000544' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '432162' WHERE ordernumber = 'P2503080000547' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460025' WHERE ordernumber = 'P2503080000548' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '279436' WHERE ordernumber = 'P2503080000550' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '281362' WHERE ordernumber = 'P2503080000551' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '293407' WHERE ordernumber = 'P2503080000553' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460026' WHERE ordernumber = 'P2503080000554' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460027' WHERE ordernumber = 'P2503080000556' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '141664' WHERE ordernumber = 'P2503080000563' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460028' WHERE ordernumber = 'P2503080000565' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '235269' WHERE ordernumber = 'P2503080000567' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460031' WHERE ordernumber = 'P2503080000575' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '353081' WHERE ordernumber = 'P2503080000576' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460035' WHERE ordernumber = 'P2503080000577' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460034' WHERE ordernumber = 'P2503080000578' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '458927' WHERE ordernumber = 'P2503080000585' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '458927' WHERE ordernumber = 'P2503080000586' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '380796' WHERE ordernumber = 'P2503080000591' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '429884' WHERE ordernumber = 'P2503080000592' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460033' WHERE ordernumber = 'P2503080000594' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460029' WHERE ordernumber = 'P2503080000596' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '437268' WHERE ordernumber = 'P2503080000603' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460037' WHERE ordernumber = 'P2503080000606' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '454250' WHERE ordernumber = 'P2503080000608' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460041' WHERE ordernumber = 'P2503080000610' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '381846' WHERE ordernumber = 'P2503080000611' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460042' WHERE ordernumber = 'P2503080000622' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460036' WHERE ordernumber = 'P2503080000623' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460044' WHERE ordernumber = 'P2503080000624' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '303066' WHERE ordernumber = 'P2503080000626' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460032' WHERE ordernumber = 'P2503080000628' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '432682' WHERE ordernumber = 'P2503080000630' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '356107' WHERE ordernumber = 'P2503080000631' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460045' WHERE ordernumber = 'P2503080000635' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460046' WHERE ordernumber = 'P2503080000638' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '460047' WHERE ordernumber = 'P2503080000639' 2025-03-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '80996' WHERE ordernumber = 'P2503080000640' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '418423' WHERE ordernumber = 'P2503080000642' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '346125' WHERE ordernumber = 'P2503080000644' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '160321' WHERE ordernumber = 'P2503080000650' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460049' WHERE ordernumber = 'P2503080000654' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460051' WHERE ordernumber = 'P2503080000656' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460050' WHERE ordernumber = 'P2503080000657' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460052' WHERE ordernumber = 'P2503080000658' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '459753' WHERE ordernumber = 'P2503080000659' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '459753' WHERE ordernumber = 'P2503080000662' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '4815' WHERE ordernumber = 'P2503080000663' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '458934' WHERE ordernumber = 'P2503080000665' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460054' WHERE ordernumber = 'P2503080000667' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460056' WHERE ordernumber = 'P2503080000671' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460055' WHERE ordernumber = 'P2503080000672' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460058' WHERE ordernumber = 'P2503080000674' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460059' WHERE ordernumber = 'P2503080000678' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460060' WHERE ordernumber = 'P2503080000681' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '245021' WHERE ordernumber = 'P2503080000685' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460061' WHERE ordernumber = 'P2503080000689' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '412987' WHERE ordernumber = 'P2503080000692' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '269132' WHERE ordernumber = 'P2503080000700' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460067' WHERE ordernumber = 'P2503080000702' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460062' WHERE ordernumber = 'P2503080000704' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460064' WHERE ordernumber = 'P2503080000706' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460065' WHERE ordernumber = 'P2503080000708' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460065' WHERE ordernumber = 'P2503080000709' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '427639' WHERE ordernumber = 'P2503080000711' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460063' WHERE ordernumber = 'P2503080000712' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460066' WHERE ordernumber = 'P2503080000714' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460068' WHERE ordernumber = 'P2503080000716' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '387856' WHERE ordernumber = 'P2503080000717' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460069' WHERE ordernumber = 'P2503080000719' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '458235' WHERE ordernumber = 'P2503080000721' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460070' WHERE ordernumber = 'P2503080000722' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460071' WHERE ordernumber = 'P2503080000725' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460072' WHERE ordernumber = 'P2503080000727' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460073' WHERE ordernumber = 'P2503080000728' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460074' WHERE ordernumber = 'P2503080000729' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460074' WHERE ordernumber = 'P2503080000730' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '414655' WHERE ordernumber = 'P2503080000731' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '453049' WHERE ordernumber = 'P2503080000732' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460075' WHERE ordernumber = 'P2503080000733' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460076' WHERE ordernumber = 'P2503080000738' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460077' WHERE ordernumber = 'P2503080000741' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '286149' WHERE ordernumber = 'P2503080000743' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '172612' WHERE ordernumber = 'P2503080000746' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460078' WHERE ordernumber = 'P2503080000747' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460078' WHERE ordernumber = 'P2503080000749' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '25068' WHERE ordernumber = 'P2503080000750' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '263101' WHERE ordernumber = 'P2503080000751' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '98135' WHERE ordernumber = 'P2503080000763' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '300059' WHERE ordernumber = 'P2503080000765' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460082' WHERE ordernumber = 'P2503080000767' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460085' WHERE ordernumber = 'P2503080000768' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460080' WHERE ordernumber = 'P2503080000769' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460084' WHERE ordernumber = 'P2503080000770' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460083' WHERE ordernumber = 'P2503080000772' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460087' WHERE ordernumber = 'P2503080000776' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460084' WHERE ordernumber = 'P2503080000780' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460088' WHERE ordernumber = 'P2503080000782' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460081' WHERE ordernumber = 'P2503080000784' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '384033' WHERE ordernumber = 'P2503080000787' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460079' WHERE ordernumber = 'P2503080000791' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460079' WHERE ordernumber = 'P2503080000793' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460079' WHERE ordernumber = 'P2503080000795' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460090' WHERE ordernumber = 'P2503080000796' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460093' WHERE ordernumber = 'P2503080000808' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '460094' WHERE ordernumber = 'P2503080000811' 2025-03-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '212547' WHERE ordernumber = 'P2503080000812' 2025-03-09 01:00:07 -- UPDATE `omo_order_list` SET userId = '460095' WHERE ordernumber = 'P2503080000817' 2025-03-09 01:00:07 -- UPDATE `omo_order_list` SET userId = '460089' WHERE ordernumber = 'P2503080000818' 2025-03-09 01:00:07 -- UPDATE `omo_order_list` SET userId = '96480' WHERE ordernumber = 'P2503080000819' 2025-03-09 01:00:07 -- UPDATE `omo_order_list` SET userId = '280076' WHERE ordernumber = 'P2503080000826' 2025-03-09 01:00:07 -- UPDATE `omo_order_list` SET userId = '460096' WHERE ordernumber = 'P2503080000831' 2025-03-09 01:00:07 -- UPDATE `omo_order_list` SET userId = '460097' WHERE ordernumber = 'P2503080000832' 2025-03-09 01:00:07 -- UPDATE `omo_order_list` SET userId = '460098' WHERE ordernumber = 'P2503080000833' 2025-03-09 01:00:07 -- UPDATE `omo_order_list` SET userId = '379470' WHERE ordernumber = 'P2503080000835' 2025-03-09 01:00:07 -- UPDATE `omo_order_list` SET userId = '460099' WHERE ordernumber = 'P2503080000838' 2025-03-09 01:00:07 -- UPDATE `omo_order_list` SET userId = '460099' WHERE ordernumber = 'P2503080000839' 2025-03-09 01:00:07 -- UPDATE `omo_order_list` SET userId = '305726' WHERE ordernumber = 'P2503080000843' 2025-03-09 01:00:07 -- UPDATE `omo_order_list` SET userId = '457146' WHERE ordernumber = 'P2503080000844'