2024-12-31 01:00:02 -- 將會員中心id寫入data-lake 2024-12-31 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 '2024-12-30%'; 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '441031' WHERE ordernumber = 'P2412300000016' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '441436' WHERE ordernumber = 'P2412300000017' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '213938' WHERE ordernumber = 'P2412300000018' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '213938' WHERE ordernumber = 'P2412300000019' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '170887' WHERE ordernumber = 'P2412300000020' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '413035' WHERE ordernumber = 'P2412300000022' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '441440' WHERE ordernumber = 'P2412300000023' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '393600' WHERE ordernumber = 'P2412300000024' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '441442' WHERE ordernumber = 'P2412300000028' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '390443' WHERE ordernumber = 'P2412300000029' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '355451' WHERE ordernumber = 'P2412300000031' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '340908' WHERE ordernumber = 'P2412300000033' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '441447' WHERE ordernumber = 'P2412300000034' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '441448' WHERE ordernumber = 'P2412300000035' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '441451' WHERE ordernumber = 'P2412300000038' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '237406' WHERE ordernumber = 'P2412300000039' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '441439' WHERE ordernumber = 'P2412300000040' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '182906' WHERE ordernumber = 'P2412300000041' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '238188' WHERE ordernumber = 'P2412300000044' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '245808' WHERE ordernumber = 'P2412300000048' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '441452' WHERE ordernumber = 'P2412300000049' 2024-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '394860' WHERE ordernumber = 'P2412300000051' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '381367' WHERE ordernumber = 'P2412300000052' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '369227' WHERE ordernumber = 'P2412300000056' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '430275' WHERE ordernumber = 'P2412300000058' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441458' WHERE ordernumber = 'P2412300000059' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441459' WHERE ordernumber = 'P2412300000060' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441460' WHERE ordernumber = 'P2412300000062' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '436547' WHERE ordernumber = 'P2412300000065' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '436547' WHERE ordernumber = 'P2412300000066' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441466' WHERE ordernumber = 'P2412300000068' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '119193' WHERE ordernumber = 'P2412300000069' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '102922' WHERE ordernumber = 'P2412300000074' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '426863' WHERE ordernumber = 'P2412300000078' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '271573' WHERE ordernumber = 'P2412300000079' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441470' WHERE ordernumber = 'P2412300000082' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441471' WHERE ordernumber = 'P2412300000085' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '140799' WHERE ordernumber = 'P2412300000087' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441472' WHERE ordernumber = 'P2412300000088' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '116938' WHERE ordernumber = 'P2412300000089' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '431561' WHERE ordernumber = 'P2412300000090' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441473' WHERE ordernumber = 'P2412300000092' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441475' WHERE ordernumber = 'P2412300000093' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441474' WHERE ordernumber = 'P2412300000094' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441477' WHERE ordernumber = 'P2412300000095' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441480' WHERE ordernumber = 'P2412300000097' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441481' WHERE ordernumber = 'P2412300000100' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441482' WHERE ordernumber = 'P2412300000101' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '244844' WHERE ordernumber = 'P2412300000105' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '133133' WHERE ordernumber = 'P2412300000112' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '306476' WHERE ordernumber = 'P2412300000114' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '361492' WHERE ordernumber = 'P2412300000121' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '90879' WHERE ordernumber = 'P2412300000124' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P2412300000131' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '341032' WHERE ordernumber = 'P2412300000132' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '389551' WHERE ordernumber = 'P2412300000144' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441498' WHERE ordernumber = 'P2412300000145' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441496' WHERE ordernumber = 'P2412300000147' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '439584' WHERE ordernumber = 'P2412300000149' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '249481' WHERE ordernumber = 'P2412300000150' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441502' WHERE ordernumber = 'P2412300000151' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441495' WHERE ordernumber = 'P2412300000153' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '411487' WHERE ordernumber = 'P2412300000160' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '354172' WHERE ordernumber = 'P2412300000163' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '96382' WHERE ordernumber = 'P2412300000164' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '439584' WHERE ordernumber = 'P2412300000168' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '99126' WHERE ordernumber = 'P2412300000173' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441506' WHERE ordernumber = 'P2412300000174' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '437166' WHERE ordernumber = 'P2412300000175' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '291632' WHERE ordernumber = 'P2412300000181' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '389085' WHERE ordernumber = 'P2412300000182' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '337001' WHERE ordernumber = 'P2412300000185' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '390391' WHERE ordernumber = 'P2412300000188' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441512' WHERE ordernumber = 'P2412300000191' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441513' WHERE ordernumber = 'P2412300000192' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441515' WHERE ordernumber = 'P2412300000195' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441517' WHERE ordernumber = 'P2412300000197' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '162043' WHERE ordernumber = 'P2412300000198' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '349042' WHERE ordernumber = 'P2412300000202' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '438900' WHERE ordernumber = 'P2412300000203' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441520' WHERE ordernumber = 'P2412300000205' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441522' WHERE ordernumber = 'P2412300000207' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '229415' WHERE ordernumber = 'P2412300000208' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441219' WHERE ordernumber = 'P2412300000209' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '188928' WHERE ordernumber = 'P2412300000214' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441526' WHERE ordernumber = 'P2412300000215' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441525' WHERE ordernumber = 'P2412300000217' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441528' WHERE ordernumber = 'P2412300000219' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '365200' WHERE ordernumber = 'P2412300000221' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441509' WHERE ordernumber = 'P2412300000224' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '434477' WHERE ordernumber = 'P2412300000225' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '439531' WHERE ordernumber = 'P2412300000228' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '347847' WHERE ordernumber = 'P2412300000237' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '436649' WHERE ordernumber = 'P2412300000239' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441390' WHERE ordernumber = 'P2412300000240' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '167806' WHERE ordernumber = 'P2412300000244' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441534' WHERE ordernumber = 'P2412300000246' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441535' WHERE ordernumber = 'P2412300000247' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441538' WHERE ordernumber = 'P2412300000250' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441532' WHERE ordernumber = 'P2412300000253' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '254914' WHERE ordernumber = 'P2412300000257' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441541' WHERE ordernumber = 'P2412300000259' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441542' WHERE ordernumber = 'P2412300000263' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441543' WHERE ordernumber = 'P2412300000265' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '434018' WHERE ordernumber = 'P2412300000273' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '408715' WHERE ordernumber = 'P2412300000275' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '401734' WHERE ordernumber = 'P2412300000278' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '105984' WHERE ordernumber = 'P2412300000279' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441536' WHERE ordernumber = 'P2412300000281' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441399' WHERE ordernumber = 'P2412300000283' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441547' WHERE ordernumber = 'P2412300000287' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '106009' WHERE ordernumber = 'P2412300000290' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441549' WHERE ordernumber = 'P2412300000291' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441548' WHERE ordernumber = 'P2412300000293' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441545' WHERE ordernumber = 'P2412300000295' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441552' WHERE ordernumber = 'P2412300000299' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441544' WHERE ordernumber = 'P2412300000306' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441556' WHERE ordernumber = 'P2412300000308' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '298853' WHERE ordernumber = 'P2412300000310' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441557' WHERE ordernumber = 'P2412300000313' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '98729' WHERE ordernumber = 'P2412300000315' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441558' WHERE ordernumber = 'P2412300000318' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '441317' WHERE ordernumber = 'P2412300000322' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '433569' WHERE ordernumber = 'P2412300000327' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '344831' WHERE ordernumber = 'P2412300000329' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '286022' WHERE ordernumber = 'P2412300000333' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '440409' WHERE ordernumber = 'P2412300000337' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '100968' WHERE ordernumber = 'P2412300000339' 2024-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '335792' WHERE ordernumber = 'P2412300000342' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '235961' WHERE ordernumber = 'P2412300000345' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441566' WHERE ordernumber = 'P2412300000350' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '126384' WHERE ordernumber = 'P2412300000353' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '47294' WHERE ordernumber = 'P2412300000362' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441569' WHERE ordernumber = 'P2412300000363' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441571' WHERE ordernumber = 'P2412300000364' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '306845' WHERE ordernumber = 'P2412300000365' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '411277' WHERE ordernumber = 'P2412300000371' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441574' WHERE ordernumber = 'P2412300000376' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441577' WHERE ordernumber = 'P2412300000380' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '282895' WHERE ordernumber = 'P2412300000384' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '136756' WHERE ordernumber = 'P2412300000392' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '439920' WHERE ordernumber = 'P2412300000394' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '439920' WHERE ordernumber = 'P2412300000399' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441579' WHERE ordernumber = 'P2412300000401' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '41029' WHERE ordernumber = 'P2412300000403' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '436547' WHERE ordernumber = 'P2412300000405' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '436547' WHERE ordernumber = 'P2412300000410' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441582' WHERE ordernumber = 'P2412300000411' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '436547' WHERE ordernumber = 'P2412300000412' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '436547' WHERE ordernumber = 'P2412300000413' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '436612' WHERE ordernumber = 'P2412300000415' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '76000' WHERE ordernumber = 'P2412300000418' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '436612' WHERE ordernumber = 'P2412300000419' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441585' WHERE ordernumber = 'P2412300000423' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '252044' WHERE ordernumber = 'P2412300000425' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '390936' WHERE ordernumber = 'P2412300000428' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '242415' WHERE ordernumber = 'P2412300000430' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '364117' WHERE ordernumber = 'P2412300000434' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '254880' WHERE ordernumber = 'P2412300000438' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '251464' WHERE ordernumber = 'P2412300000442' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '358283' WHERE ordernumber = 'P2412300000443' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441590' WHERE ordernumber = 'P2412300000457' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '412222' WHERE ordernumber = 'P2412300000461' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '298853' WHERE ordernumber = 'P2412300000464' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '273752' WHERE ordernumber = 'P2412300000465' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '415793' WHERE ordernumber = 'P2412300000466' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '440817' WHERE ordernumber = 'P2412300000468' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '439130' WHERE ordernumber = 'P2412300000470' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441592' WHERE ordernumber = 'P2412300000479' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441596' WHERE ordernumber = 'P2412300000483' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '99786' WHERE ordernumber = 'P2412300000485' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '435848' WHERE ordernumber = 'P2412300000489' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '435848' WHERE ordernumber = 'P2412300000492' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441599' WHERE ordernumber = 'P2412300000494' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '110093' WHERE ordernumber = 'P2412300000496' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '325136' WHERE ordernumber = 'P2412300000504' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441603' WHERE ordernumber = 'P2412300000505' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441604' WHERE ordernumber = 'P2412300000507' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441599' WHERE ordernumber = 'P2412300000509' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441605' WHERE ordernumber = 'P2412300000510' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441606' WHERE ordernumber = 'P2412300000511' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441607' WHERE ordernumber = 'P2412300000512' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441608' WHERE ordernumber = 'P2412300000514' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '435042' WHERE ordernumber = 'P2412300000515' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441609' WHERE ordernumber = 'P2412300000516' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441598' WHERE ordernumber = 'P2412300000518' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441612' WHERE ordernumber = 'P2412300000527' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441614' WHERE ordernumber = 'P2412300000528' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '382997' WHERE ordernumber = 'P2412300000531' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441617' WHERE ordernumber = 'P2412300000532' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441622' WHERE ordernumber = 'P2412300000543' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441623' WHERE ordernumber = 'P2412300000545' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '439335' WHERE ordernumber = 'P2412300000552' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441624' WHERE ordernumber = 'P2412300000554' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441628' WHERE ordernumber = 'P2412300000556' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441629' WHERE ordernumber = 'P2412300000559' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441630' WHERE ordernumber = 'P2412300000562' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441631' WHERE ordernumber = 'P2412300000563' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '147682' WHERE ordernumber = 'P2412300000564' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '437952' WHERE ordernumber = 'P2412300000565' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '439335' WHERE ordernumber = 'P2412300000567' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '63616' WHERE ordernumber = 'P2412300000568' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441634' WHERE ordernumber = 'P2412300000572' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '223777' WHERE ordernumber = 'P2412300000573' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '229628' WHERE ordernumber = 'P2412300000577' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441638' WHERE ordernumber = 'P2412300000581' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '245310' WHERE ordernumber = 'P2412300000582' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441640' WHERE ordernumber = 'P2412300000585' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441642' WHERE ordernumber = 'P2412300000588' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441645' WHERE ordernumber = 'P2412300000591' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441646' WHERE ordernumber = 'P2412300000594' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '423707' WHERE ordernumber = 'P2412300000595' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '422698' WHERE ordernumber = 'P2412300000596' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '153983' WHERE ordernumber = 'P2412300000598' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '434904' WHERE ordernumber = 'P2412300000600' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '286188' WHERE ordernumber = 'P2412300000601' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441652' WHERE ordernumber = 'P2412300000603' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441651' WHERE ordernumber = 'P2412300000604' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '377132' WHERE ordernumber = 'P2412300000609' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441655' WHERE ordernumber = 'P2412300000610' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '215628' WHERE ordernumber = 'P2412300000613' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441657' WHERE ordernumber = 'P2412300000618' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '342097' WHERE ordernumber = 'P2412300000623' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '439122' WHERE ordernumber = 'P2412300000624' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '282484' WHERE ordernumber = 'P2412300000630' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '73683' WHERE ordernumber = 'P2412300000634' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '268773' WHERE ordernumber = 'P2412300000636' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '260549' WHERE ordernumber = 'P2412300000640' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '348538' WHERE ordernumber = 'P2412300000644' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441669' WHERE ordernumber = 'P2412300000649' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441673' WHERE ordernumber = 'P2412300000653' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441674' WHERE ordernumber = 'P2412300000654' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '116975' WHERE ordernumber = 'P2412300000658' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '333368' WHERE ordernumber = 'P2412300000660' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441678' WHERE ordernumber = 'P2412300000661' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '298627' WHERE ordernumber = 'P2412300000662' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441019' WHERE ordernumber = 'P2412300000663' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '273226' WHERE ordernumber = 'P2412300000668' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441682' WHERE ordernumber = 'P2412300000676' 2024-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '441683' WHERE ordernumber = 'P2412300000677' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '399715' WHERE ordernumber = 'P2412300000679' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '216153' WHERE ordernumber = 'P2412300000680' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441686' WHERE ordernumber = 'P2412300000682' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441687' WHERE ordernumber = 'P2412300000683' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441688' WHERE ordernumber = 'P2412300000686' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '412721' WHERE ordernumber = 'P2412300000689' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '440057' WHERE ordernumber = 'P2412300000691' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '345490' WHERE ordernumber = 'P2412300000693' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441691' WHERE ordernumber = 'P2412300000698' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '211103' WHERE ordernumber = 'P2412300000702' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '209646' WHERE ordernumber = 'P2412300000705' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '403428' WHERE ordernumber = 'P2412300000709' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '161483' WHERE ordernumber = 'P2412300000710' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '209646' WHERE ordernumber = 'P2412300000716' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '227161' WHERE ordernumber = 'P2412300000718' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441696' WHERE ordernumber = 'P2412300000725' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '421519' WHERE ordernumber = 'P2412300000726' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '387229' WHERE ordernumber = 'P2412300000729' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '286464' WHERE ordernumber = 'P2412300000730' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '421519' WHERE ordernumber = 'P2412300000733' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '370353' WHERE ordernumber = 'P2412300000737' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441702' WHERE ordernumber = 'P2412300000739' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '387229' WHERE ordernumber = 'P2412300000740' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441697' WHERE ordernumber = 'P2412300000743' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441703' WHERE ordernumber = 'P2412300000744' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441684' WHERE ordernumber = 'P2412300000748' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '383903' WHERE ordernumber = 'P2412300000749' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441704' WHERE ordernumber = 'P2412300000751' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441705' WHERE ordernumber = 'P2412300000753' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441706' WHERE ordernumber = 'P2412300000754' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441709' WHERE ordernumber = 'P2412300000755' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '360180' WHERE ordernumber = 'P2412300000756' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '86113' WHERE ordernumber = 'P2412300000759' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '368588' WHERE ordernumber = 'P2412300000760' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441713' WHERE ordernumber = 'P2412300000763' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '434349' WHERE ordernumber = 'P2412300000766' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441699' WHERE ordernumber = 'P2412300000767' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441489' WHERE ordernumber = 'P2412300000768' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441714' WHERE ordernumber = 'P2412300000771' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '428475' WHERE ordernumber = 'P2412300000776' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '360180' WHERE ordernumber = 'P2412300000777' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441699' WHERE ordernumber = 'P2412300000781' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '428340' WHERE ordernumber = 'P2412300000785' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '360180' WHERE ordernumber = 'P2412300000794' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '439363' WHERE ordernumber = 'P2412300000796' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '319309' WHERE ordernumber = 'P2412300000797' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '64226' WHERE ordernumber = 'P2412300000801' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '396711' WHERE ordernumber = 'P2412300000804' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '85019' WHERE ordernumber = 'P2412300000805' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '303132' WHERE ordernumber = 'P2412300000807' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '94254' WHERE ordernumber = 'P2412300000808' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '242381' WHERE ordernumber = 'P2412300000809' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '411697' WHERE ordernumber = 'P2412300000810' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '298350' WHERE ordernumber = 'P2412300000811' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '291960' WHERE ordernumber = 'P2412300000813' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '374877' WHERE ordernumber = 'P2412300000816' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441723' WHERE ordernumber = 'P2412300000817' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '158272' WHERE ordernumber = 'P2412300000820' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '423292' WHERE ordernumber = 'P2412300000821' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '291960' WHERE ordernumber = 'P2412300000822' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441724' WHERE ordernumber = 'P2412300000823' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '343571' WHERE ordernumber = 'P2412300000824' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '162112' WHERE ordernumber = 'P2412300000828' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '252065' WHERE ordernumber = 'P2412300000831' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441731' WHERE ordernumber = 'P2412300000833' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441737' WHERE ordernumber = 'P2412300000839' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '361358' WHERE ordernumber = 'P2412300000841' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '407669' WHERE ordernumber = 'P2412300000842' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441738' WHERE ordernumber = 'P2412300000844' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441740' WHERE ordernumber = 'P2412300000846' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '285644' WHERE ordernumber = 'P2412300000849' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441746' WHERE ordernumber = 'P2412300000850' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '276960' WHERE ordernumber = 'P2412300000857' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '246088' WHERE ordernumber = 'P2412300000860' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441742' WHERE ordernumber = 'P2412300000863' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441753' WHERE ordernumber = 'P2412300000865' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441754' WHERE ordernumber = 'P2412300000867' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441757' WHERE ordernumber = 'P2412300000874' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '247872' WHERE ordernumber = 'P2412300000880' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441759' WHERE ordernumber = 'P2412300000882' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441749' WHERE ordernumber = 'P2412300000884' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '282226' WHERE ordernumber = 'P2412300000885' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '429642' WHERE ordernumber = 'P2412300000887' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441761' WHERE ordernumber = 'P2412300000889' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441762' WHERE ordernumber = 'P2412300000891' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '281876' WHERE ordernumber = 'P2412300000893' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '414529' WHERE ordernumber = 'P2412300000898' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441766' WHERE ordernumber = 'P2412300000903' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '441476' WHERE ordernumber = 'P2412300000904' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '48849' WHERE ordernumber = 'P2412300000905' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '48849' WHERE ordernumber = 'P2412300000906' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '385362' WHERE ordernumber = 'P2412300000907' 2024-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '319894' WHERE ordernumber = 'P2412300000912'