SELECT

DC.DIM_DATE.DATE_ID,
DC.DC_E_SOEM_TN_RADIO_LINK_RAW.DATE_ID,
cast ((sum(DC.DC_E_SOEM_TN_RADIO_LINK_RAW.ES)/(sum(DC.DC_E_SOEM_TN_RADIO_LINK_
RAW.AT)+sum(DC.DC_E_SOEM_TN_RADIO_LINK_RAW.UAS)))as decimal (10,2))*100 as Error
,
cast ((1-(sum(DC.DC_E_SOEM_TN_RADIO_LINK_RAW.UAS)/(sum(DC.DC_E_SOEM_TN_RADIO_L
INK_RAW.AT)+sum(DC.DC_E_SOEM_TN_RADIO_LINK_RAW.UAS))))as decimal (10,2))*100 as
AVAILABILITY,
SELECT
DC.DIM_DATE.DATE_ID,
DC.DC_E_SOEM_TN_RADIO_LINK_RAW.DATE_ID,
DC.DC_E_SOEM_TN_RADIO_LINK_RAW.NODE_NAME,
cast ((sum(DC.DC_E_SOEM_TN_RADIO_LINK_RAW.ES)/(sum(DC.DC_E_SOEM_TN_RADIO_LINK_
RAW.AT)+sum(DC.DC_E_SOEM_TN_RADIO_LINK_RAW.UAS)))as decimal (10,2))*100 as Error
,
cast ((1-(sum(DC.DC_E_SOEM_TN_RADIO_LINK_RAW.UAS)/(sum(DC.DC_E_SOEM_TN_RADIO_L
INK_RAW.AT)+sum(DC.DC_E_SOEM_TN_RADIO_LINK_RAW.UAS))))as decimal (10,2))*100 as
AVAILABILITY,
DC.DC_E_SOEM_TN_RADIO_LINK_RAW.NE_ID
FROM
DC.DIM_DATE,
DC.DC_E_SOEM_TN_RADIO_LINK_RAW,
DC.DIM_ROWSTATUS
WHERE
( DC.DC_E_SOEM_TN_RADIO_LINK_RAW.ROWSTATUS=DC.DIM_ROWSTATUS.ROWSTATUS )
AND ( DC.DC_E_SOEM_TN_RADIO_LINK_RAW.DATE_ID=DC.DIM_DATE.DATE_ID )
AND
(
( ( DC.DIM_ROWSTATUS.ROWSTATUS ) NOT IN ('DUPLICATE','SUSPECTED') )
AND
( ( DC.DIM_DATE.DATE_ID ) BETWEEN {ts '2015-12-1'} AND {ts '2016-2-10'} )
AND
DC.DC_E_SOEM_TN_RADIO_LINK_RAW.NE_ID IN ('6854' , '5686' , '6513' , '6974' ,
'6376' , '5310' , '5174' , '5661' , '5677' , '6083' , '7167' , '6639' , '7165'
, '7284' , '5080' , '5621' , '7156' , '6200' , '5166' , '6488' , '6062' , '6578'
, '6153' , '6287' , '5485' , '5666' , '5731' , '5258' , '6755' , '5422' , '5471
' , '6906' , '5916' , '6420' , '5529' , '5799' , '6625' , '5964' , '6887' , '583
3' , '7199' , '5909' , '5803' , '5248' , '6460' , '5287' , '5845' , '6204' , '52
90' , '5345' , '6956' , '6791' , '6740' , '5288' , '6399' , '5953' , '6620' , '6
860' , '6133' , '6537' , '5487' , '6626' , '5517' , '6531' , '5862' , '5236' , '
6265' , '6766' , '5522' , '5925' , '6455' , '5904' , '6255' , '6221' , '6565' ,
'6600' , '5100' , '5597' , '6283' , '5503' , '6832' , '6708' , '7307' , '5088' ,
'6732' , '6032' , '6918' , '6051' , '5543' , '6838' , '5311' , '5590' , '6314'
, '6505' , '5107' , '5824' , '6385' , '6009' , '6567' , '5476' , '6095' , '5505'
, '6324' , '5937' , '6112' , '5244' , '6613' , '6129' , '6484' , '5161' , '5546
' , '5594' , '5284' , '5636' , '5716' , '5978' , '6238' , '5506' , '7170' , '536
0' , '5982' , '6989' , '6197' , '5567' , '5498' , '6947' , '5252' , '6335' , '54
72' , '5972' , '6004' , '6608' , '6054' , '6683' , '5081' , '5061' , '6256' , '6
047' , '5328' , '6883' , '5357' , '6996' , '6821' , '6198' , '6591' , '5814' , '
6462' , '5574' , '5843' , '6977' , '6731' , '5055' , '5332' , '6770' , '7007' ,
'5738' , '6911' , '6011' , '5362' , '5986' , '5696' , '5560' , '6891' , '5635' ,
'6584' , '5155' , '6610' , '7185' , '6081' , '5793' , '6940' , '6331' , '6322'
, '6627' , '6358' , '6520' , '6727' , '6744' , '6952' , '7287' , '6638' , '5537'
, '6609' , '5265' , '5856' , '5870' , '5116' , '7164' , '5760' , '6712' , '5771
' , '6059' , '6226' , '6857' , '5539' , '5134' , '6173' , '7214' , '5349' , '674
8' , '7148' , '6290' , '7166' , '5453' , '5721' , '5842' , '6585' , '5658' , '67
49' , '6644' , '5132' , '5468' , '6178' , '6241' , '6397' , '5050' , '5829' , '6
879' , '5323' , '6216' , '5228' , '5559' , '5497' , '5263' , '5593' , '5384' , '
6257' , '6633' , '5734' , '6224' , '6533' , '6804' , '6898' , '6817' , '6802' ,

'6087' , '5240' , '6315' , '6366' , '6247' , '6967' , '7259' , '6868' , '5733' ,

'6269' , '6664' , '6698' , '6380' , '5325' , '5622' , '5907' , '5407' , '5572'
, '6068' , '5815' , '6511' , '5913' , '5662' , '6444' , '6434' , '6932' , '5691'
, '6187' , '6721' , '6752' , '5273' , '6875' , '6430' , '7183' , '5779' , '5389
' , '6717' , '5817' , '6604' , '6893' , '6056' , '5836' , '6684' , '5212' , '636
0' , '6843' , '6175' , '5835' , '5859' , '6199' , '7088' , '6955' , '5501' , '58
18' , '5974' , '5772' , '5901' , '5796' , '6598' , '7172' , '5915' , '5093' , '5
811' , '6336' , '6413' , '5720' , '5408' , '5359' , '6036' , '6043' , '6282' , '
6931' , '5598' , '6179' , '5825' , '6527' , '5424' , '5502' , '6344' , '5851' ,
'5376' , '5641' , '6722' , '6475' , '5623' , '6370' , '6003' , '6926' , '5730' ,
'6075' , '6572' , '6122' , '5805' , '5664' , '7202' , '7221' , '5286' , '6876'
, '6289' , '5728' , '5103' , '7280' , '6236' , '6419' , '6274' , '6120' , '7168'
, '6086' , '5786' , '6142' , '5524' , '5589' , '6464' , '5257' , '6466' , '6873
' , '5891' , '5513' , '6372' , '6276' , '7289' , '6777' , '7205' , '6689' , '726
5' , '6089' , '5961' , '6258' , '5337' , '5889' , '5959' , '6298' , '6819' , '54
42' , '7140' , '5474' , '5629' , '6517' , '6039' , '6038' , '5724' , '6942' , '6
506' , '6353' , '5976' , '5211' , '6555' , '5576' , '7161' , '7210' , '5533' , '
5173' , '5790' , '6393' , '6522' , '6172' , '6424' , '6049' , '6106' , '6223' ,
'7235' , '5198' , '5927' , '6699' , '5719' , '5336' , '5820' , '5531' , '5613' ,
'6508' , '6554' , '5139' , '5119' , '5551' , '5334' , '6140' , '5878' , '6803'
, '5380' , '6568' , '5285' , '6212' , '6220' , '6454' , '6904' , '6093' , '5222'
, '6562' , '5432' , '5795' , '5216' , '5939' , '5834' , '6561' , '5355' , '7087
' , '6603' , '6778' , '5591' , '6880' , '5065' , '7239' , '5831' , '5802' , '513
6' , '7296' , '6379' , '5053' , '5106' , '5867' , '6836' , '5072' , '5274' , '58
23' , '5698' , '6192' , '5374' , '5254' , '6115' , '5680' , '6067' , '5206' , '6
920' , '5170' , '6675' , '6605' , '6458' , '5809' , '5644' , '6939' , '5447' , '
5192' , '5078' , '6478' , '6211' , '6481' , '6499' , '6214' , '6616' , '6472' ,
'6764' , '5700' , '5097' , '5739' , '6688' , '6189' , '6496' , '6467' , '6356' ,
'5091' , '6080' , '7021' , '6264' , '7299' , '5563' , '6186' , '6092' , '6114'
, '5341' , '6960' , '7220' , '6045' , '5416' , '5967' , '5553' , '6901' , '5127'
, '6588' , '5521' , '5160' , '6787' , '6634' , '5260' , '6922' , '6447' , '6401
' , '6599' , '7181' , '6662' , '5962' , '5630' , '6118' , '5930' , '6827' , '609
9' , '5847' , '5822' , '6134' , '6759' , '6448' , '5329' , '5299' , '5565' , '73
01' , '6839' , '6225' , '6422' , '5898' , '6369' , '6889' , '5203' , '5475' , '5
607' , '6473' , '5592' , '5280' , '5508' , '6707' , '6959' , '6829' , '5352' , '
6941' , '6998' , '6674' , '5712' , '6831' , '6590' , '5255' , '5555' , '6510' ,
'6818' , '6954' , '6117' , '6837' , '5583' , '7094' , '5353' , '7303' , '5858' ,
'6753' , '6507' , '6048' , '5388' , '5767' , '5069' , '5197' , '5423' , '5226'
, '6773' , '7283' , '6660' , '5461' , '5484' , '6986' , '5695' , '6396' , '6311'
, '6719' , '6145' , '6858' , '6130' , '6441' , '5333' , '5253' , '5871' , '6896
' , '5150' , '6096' , '6190' , '5456' , '6194' , '5482' , '5813' , '6349' , '543
9' , '5479' , '5413' , '6085' , '5378' , '5647' , '5781' , '5608' , '6594' , '62
18' , '7217' , '5525' , '6445' , '6368' , '5931' , '6180' , '6576' , '6569' , '6
641' , '5455' , '6917' , '5892' , '6061' , '6575' , '6493' , '6181' , '5294' , '
6800' , '6300' , '6525' , '5057' , '6781' , '6796' , '5850' , '6607' , '6429' ,
'6790' , '5371' , '6808' , '6589' , '7005' , '5495' , '5697' , '6029' , '6345' ,
'6991' , '5703' , '5872' , '5554' , '6391' , '5963' , '5478' , '6881' , '5879'
, '6501' , '5076' , '5612' , '6033' , '5511' , '5950' , '7159' , '7281' , '5707'
, '5751' , '5300' , '5075' , '5162' , '6452' , '6697' , '6592' , '5932' , '6681
' , '5124' , '6332' , '7009' , '7272' , '5426' , '5639' , '6427' , '6272' , '561
8' , '6168' , '6394' , '6905' , '5047' , '6795' , '6301' , '6415' , '5444' , '59
48' , '6451' , '6979' , '6121' , '6456' , '6750' , '5324' , '5787' , '6611' , '5
926' , '5884' , '5881' , '6541' , '6583' , '5989' , '6281' , '5970' , '6284' , '
5418' , '5208' , '7082' , '5864' , '5175' , '6239' , '6275' , '6149' , '6779' ,
'5740' , '6523' , '6783' , '6582' , '6846' , '5660' , '5657' , '6774' , '5928' ,
'5705' , '6337' , '5804' , '5837' , '5888' , '5454' , '6811' , '5452' , '6450'
, '7190' , '6855' , '6919' , '6980' , '6961' , '6263' , '6065' , '5298' , '5643'
, '5415' , '5694' , '5114' , '6548' , '5403' , '6668' , '5991' , '6797' , '5807
' , '5983' , '6643' , '5919' , '5757' , '5393' , '6072' , '5723' , '5118' , '678
9' , '5633' , '5544' , '7044' , '6792' , '5616' , '7222' , '5356' , '6595' , '64

53' , '5821' , '6850' , '5965' , '6577' , '7152' , '6516' , '6138' , '6407' , '5
615' , '6388' , '5138' , '6573' , '6673' , '6686' , '7182' , '7223' , '5648' , '
6443' , '5602' , '6330' , '5532' , '5875' , '5745' , '6502' , '5358' , '5547' ,
'6480' , '6176' , '6745' , '5954' , '6671' , '5400' , '5682' , '6593' , '5603' ,
'6492' , '5762' , '5722' , '5883' , '5153' , '5764' , '6034' , '7230' , '7197'
, '6524' , '5727' , '6706' , '7216' , '6550' , '5637' , '5868' , '6052' , '5221'
, '6409' , '5229' , '6477' , '6007' , '6489' , '6050' , '5754' , '5819' , '5230
' , '5314' , '6702' , '5278' , '6521' , '6097' , '5137' , '5704' , '5750' , '571
8' , '6704' , '5319' , '6261' , '5343' , '5429' , '7018' , '6195' , '5557' , '61
44' , '6623' , '6279' , '7316' , '5064' , '5640' , '6400' , '5223' , '5678' , '5
180' , '5438' , '5213' , '5237' , '5808' , '5109' , '5933' , '6630' , '7211' , '
5761' , '5668' , '5957' , '6553' , '5649' , '5190' , '6022' , '5609' , '6470' ,
'5227' , '5626' , '6161' , '5421' , '5610' , '5765' , '6217' , '5390' , '5518' ,
'6302' , '5313' , '6352' , '6100' , '6030' , '5073' , '5620' , '5404' , '5306'
, '7141' , '6019' , '5650' , '6564' , '6933' , '6416' , '6657' , '5994' , '6203'
, '5262' , '6529' , '6606' , '6695' , '6110' , '5189' , '5128' , '5368' , '6063
' , '6897' , '6143' , '6983' , '5196' , '5259' , '5897' , '5402' , '5101' , '621
0' , '7163' , '5481' , '6711' , '6471' , '6847' , '6949' , '6859' , '6266' , '65
28' , '6361' , '6485' , '6842' , '5520' , '5914' , '6556' , '5737' , '6964' , '6
640' , '5993' , '5684' , '5191' , '5282' , '5681' , '7298' , '6440' , '5611' , '
6899' , '5800' , '5717' , '6408' , '5317' , '6739' , '6295' , '5351' , '5297' ,
'6150' , '6347' , '5462' , '5448' , '5326' , '6109' , '6222' , '5663' , '6119' ,
'7160' , '6108' , '6028' , '6690' , '6057' , '6025' , '6987' , '6185' , '5846'
, '5435' , '6647' , '6497' , '5912' , '6685' , '6132' , '7208' , '6869' , '6313'
, '5301' , '5156' , '5784' , '6558' , '6433' , '6532' , '5852' , '6864' , '5200
' , '6461' , '6710' , '5347' , '6267' , '5860' , '5515' , '6165' , '5111' , '553
5' , '5493' , '6908' , '6812' , '5224' , '5628' , '5516' , '5702' , '5848' , '71
53' , '5969' , '6158' , '6538' , '6463' , '5375' , '5135' , '5414' , '7244' , '5
601' , '6188' , '6091' , '6439' , '5775' , '6938' , '6769' , '6487' , '5267' , '
6490' , '6542' , '6297' , '6377' , '5985' , '6546' , '5789' , '5087' , '7285' ,
'5920' , '6098' , '6944' , '6417' , '5466' , '5060' , '6307' , '6754' , '5895' ,
'6807' , '5158' , '5725' , '6126' , '6715' , '6438' , '5112' , '5945' , '6826'
, '6339' , '5104' , '6191' , '5467' , '5209' , '6310' , '5936' , '6402' , '5002'
, '5392' , '6617' , '5742' , '6878' , '6937' , '5395' , '7309' , '6703' , '7188
' , '6196' , '6700' , '5148' , '5743' , '5732' , '5366' , '6888' , '5689' , '720
0' , '5542' , '6526' , '6776' , '6041' , '6387' , '6410' , '5473' , '6296' , '58
96' , '6867' , '5960' , '6259' , '6705' , '5569' , '5713' , '5440' , '6306' , '6
498' , '5340' , '6016' , '6946' , '5595' , '5417' , '5853' , '6632' , '5082' , '
5464' , '6509' , '6798' , '6978' , '6678' , '5067' , '6435' , '6423' , '6557' ,
'5250' , '6437' , '5199' , '6248' , '6957' , '5348' , '5140' , '5210' , '5492' ,
'7086' , '7258' , '5164' , '6552' , '6411' , '6793' , '6305' , '6127' , '7319'
, '6547' , '6229' , '7282' , '6788' , '5264' , '5735' , '6927' , '5917' , '6013'
, '6735' , '6026' , '5113' , '5749' , '5711' , '6945' , '6615' , '5746' , '5956
' , '5165' , '6830' , '6503' , '6760' , '6329' , '5828' , '5968' , '6882' , '625
3' , '5434' , '5671' , '5676' , '5152' , '6833' , '5500' , '5999' , '6596' , '62
77' , '5514' , '5133' , '5383' , '6670' , '6002' , '5315' , '6206' , '6665' , '6
969' , '6784' , '7226' , '5726' , '5810' , '5534' , '6729' , '7158' , '6364' , '
5588' , '7142' , '7144' , '5369' , '6835' , '6870' , '5276' , '6574' , '6780' ,
'5857' , '5115' , '5573' , '6962' , '6215' , '6077' , '6993' , '6125' , '7092' ,
'6348' , '6304' , '7204' , '6884' , '6519' , '5296' , '5938' , '6231' , '5973'
, '7189' , '5331' , '5617' , '6159' , '5489' , '6027' , '5094' , '6648' , '6621'
, '5631' , '5874' , '5587' , '6111' , '6661' , '5122' , '5654' , '6813' , '6566
' , '6491' , '6994' , '6737' , '6751' , '5245' , '5744' , '5381' , '5412' , '553
6' , '5652' , '7157' , '5243' , '6628' , '6107' , '5185' , '6966' , '6976' , '69
48' , '6164' , '5578' , '6642' , '6359' , '6861' , '6037' , '5708' , '5596' , '5
167' , '5382' , '6677' , '5120' , '6951' , '7295' , '7224' , '6865' , '6116' , '
6981' , '5688' , '5387' , '7149' , '6551' , '6136' , '6950' , '6672' , '5674' ,
'6156' , '6184' , '5141' , '6403' , '6871' , '6767' , '5561' , '6746' , '6655' ,
'6319' , '5377' , '5690' , '6851' , '7260' , '6174' , '6148' , '5205' , '6622'
, '7369' , '7290' , '5363' , '6965' , '5902' , '6658' , '5780' , '6631' , '6679'

, '6646' , '5903' , '6953' , '6102' , '7212' , '5943' , '5232' , '6914' , '5679

' , '5283' , '5386' , '6213' , '5778' , '6031' , '5899' , '6512' , '6182' , '580
1' , '5214' , '5289' , '5577' , '5638' , '7000' , '5496' , '6872' , '5335' , '62
85' , '6559' , '6436' , '7291' , '6910' , '5151' , '6733' , '6373' , '5710' , '6
064' , '6367' , '5510' , '6619' , '5753' , '6581' , '6540' , '6375' , '6040' , '
5184' , '6147' , '6046' , '6459' , '5854' , '5570' , '5321' , '5292' , '5186' ,
'6299' , '6326' , '6044' , '6023' , '6663' , '6154' , '6970' , '6975' , '7175' ,
'5451' , '6666' , '6757' , '6653' , '5619' , '5584' , '6012' , '5251' , '5193'
, '6104' , '6656' , '6816' , '6756' , '6405' , '5320' , '5527' , '6381' , '6291'
, '6730' , '6874' , '6900' , '6316' , '6227' , '6743' , '6412' , '5980' , '6457
' , '5759' , '5806' , '6321' , '6249' , '5364' , '5477' , '5670' , '6260' , '584
9' , '5419' , '6113' , '6809' , '5238' , '6761' , '5995' , '5379' , '5411' , '57
94' , '6152' , '6728' , '6469' , '5687' , '5302' , '5788' , '6614' , '6303' , '5
866' , '5457' , '6355' , '6771' , '5748' , '5944' , '7184' , '5624' , '6074' , '
5922' , '6579' , '5530' , '6008' , '5564' , '5951' , '5316' , '6763' , '6328' ,
'6916' , '6866' , '5605' , '5239' , '5409' , '5545' , '5121' , '7297' , '6805' ,
'5391' , '5685' , '7225' , '5052' , '7179' , '6741' , '6659' , '5798' , '7180'
, '5154' , '6724' , '5579' , '5890' , '5886' , '6346' , '6000' , '5830' , '6342'
, '7003' , '5977' , '5885' , '5673' , '5225' , '5693' , '6018' , '5465' , '5770
' , '5548' , '6738' , '5449' , '6534' , '5204' , '6001' , '6446' , '6406' , '623
0' , '6325' , '6725' , '5266' , '6504' , '5736' , '7227' , '5538' , '5171' , '64
94' , '6171' , '5614' , '5066' , '6601' , '6014' , '6384' , '6327' , '6270' , '6
362' , '7171' , '6651' , '6814' , '6586' , '6720' , '5235' , '6357' , '7312' , '
6193' , '5338' , '6691' , '7206' , '6824' , '5987' , '5188' , '5427' , '5099' ,
'5249' , '5918' , '6536' , '5653' , '5085' , '6141' , '6799' , '6060' , '5949' ,
'6094' , '6155' , '7237' , '5861' , '6925' , '6318' , '5063' , '6718' , '7288'
, '5519' , '6135' , '5410' , '5887' , '5632' , '6885' , '5844' , '5604' , '5997'
, '6479' , '6090' , '6084' , '6343' , '5797' , '5370' , '5906' , '6103' , '5526
' , '5675' , '6624' , '6017' , '5651' , '6999' , '6849' , '5123' , '5291' , '527
7' , '5295' , '6726' , '5406' , '5873' , '5425' , '6183' , '5098' , '6676' , '72
51' , '6073' , '6201' , '7232' , '5792' , '5108' , '6465' , '5181' , '7177' , '7
146' , '6323' , '5405' , '5220' , '5420' , '7207' , '5179' , '6294' , '5270' , '
5755' , '5769' , '6515' , '6251' , '5929' , '7317' , '5437' , '6654' , '5941' ,
'7219' , '5921' , '5645' , '6637' , '5157' , '6801' , '5480' , '6985' , '5491' ,
'5758' , '6848' , '6549' , '5988' , '6992' , '6635' , '5855' , '7154' , '6317'
, '5966' , '6341' , '7294' , '5996' , '5486' , '5488' , '6841' , '6432' , '6392'
, '5129' , '6844' , '5911' , '6169' , '5599' , '6863' , '6794' , '6395' , '5585
' , '6431' , '5470' , '5304' , '6852' , '5385' , '6736' , '7321' , '6845' , '622
8' , '6024' , '6428' , '5130' , '5998' , '5102' , '5709' , '6312' , '5373' , '73
18' , '6271' , '5839' , '6246' , '6902' , '6758' , '6995' , '5241' , '5741' , '6
982' , '6714' , '6262' , '5971' , '5494' , '6570' , '6005' , '6069' , '7213' , '
6734' , '6545' , '5275' , '5552' , '6365' , '6389' , '5504' , '6823' , '6680' ,
'6912' , '5869' , '7010' , '5975' , '5218' , '6390' , '6618' , '5606' , '6693' ,
'5715' , '6006' , '7270' , '5339' , '6580' , '5816' , '6308' , '5714' , '6202'
, '5581' , '6890' , '5541' , '6825' , '5528' , '5086' , '6082' , '6242' , '6649'
, '6020' , '6404' , '6123' , '6495' , '6207' , '6701' , '6921' , '6208' , '7196
' , '5549' , '5463' , '6806' , '5550' , '6785' , '5634' , '5269' , '6694' , '647
4' , '7215' , '7279' , '5669' , '5924' , '6292' , '6669' , '7147' , '5396' , '60
53' , '6205' , '5910' , '6723' , '5460' , '6386' , '5105' , '6652' , '5233' , '5
293' , '5947' , '7229' , '6682' , '6252' , '5683' , '6892' , '6042' , '5665' , '
6924' , '6333' , '6713' , '5783' , '6571' , '6650' , '5344' , '5625' , '5242' ,
'5131' , '6895' , '6105' , '5990' , '5394' , '5149' , '6449' , '6984' , '5217' ,
'5436' , '5540' , '6234' , '6928' , '6716' , '6151' , '6162' , '5401' , '5446'
, '7242' , '5049' , '6667' , '5342' , '7308' , '5469' , '5307' , '5159' , '6930'
, '6544' , '5958' , '5655' , '5785' , '6128' , '6772' , '6602' , '6913' , '5773
' , '5766' , '5071' , '6414' , '5117' , '5490' , '6167' , '5905' , '5330' , '616
3' , '5566' , '5182' , '5092' , '7186' , '6101' , '6070' , '6973' , '5863' , '50
79' , '6742' , '6936' , '5367' , '6058' , '5350' , '5201' , '5450' , '6909' , '6
943' , '6645' , '6166' , '6747' , '6288' , '6612' , '5952' , '6245' , '7209' , '
6968' , '6383' , '7286' , '5600' , '6244' , '5219' , '5942' , '5433' , '6539' ,

'6958' , '6775' , '6426' , '5900' , '7201' , '5431' , '5354' , '5146' , '5305' ,

'5946' , '6597' , '6442' , '5361' , '5832' , '6157' , '6079' , '5877' , '6278'
, '5923' , '5812' , '5752' , '5827' , '6421' , '5346' , '6762' , '5840' , '6035'
, '6160' , '6382' , '7151' , '6587' , '5981' , '6923' , '6483' , '5706' , '6055
' , '5168' , '5984' , '7261' , '5144' , '5095' , '6468' , '5894' , '5791' , '717
6' , '5169' , '5459' , '7234' , '5507' , '6840' , '6929' , '6514' , '5126' , '68
34' , '5125' , '6820' , '5195' , '7243' , '5145' , '6131' , '5672' , '5445' , '6
137' , '7162' , '6293' , '5556' , '6518' , '5934' , '6709' , '5646' , '7198' , '
7040' , '6334' , '5509' , '5729' , '5774' , '5841' , '5261' , '6810' , '5077' ,
'5187' , '6021' , '6209' , '6088' , '5322' , '6486' , '5699' , '6374' , '5308' ,
'6934' , '5582' , '6015' , '6853' , '6254' , '7273' , '7178' , '5365' , '6822'
, '7292' , '6139' , '7218' , '5183' , '7293' , '5776' , '5747' , '5935' , '5398'
, '5656' , '6815' , '6535' , '5172' , '6338' , '5271' , '5281' , '6146' , '6482
' , '5048' , '6240' , '6232' , '5523' , '5955' , '5194' , '6782' , '5372' , '509
6' , '6907' , '6418' , '5051' , '5143' , '6177' , '5586' , '5908' , '6963' , '63
71' , '5979' , '7228' , '6563' , '5054' , '6629' , '6273' , '6280' , '6170' , '6
250' , '5215' , '5272' , '5940' , '6363' , '5777' , '5178' , '5083')
AND
--DC.DC_E_SOEM_TN_RADIO_LINK_RAW.NODE_NAME IN ('DAR166-JAMHURI','DAR079-ZAN
AKI','DAR013-MAGOMENITN2','DAR022-NIC','MSH093-SHANTYTOWN','DAR445-SWISSTOWER','
ZAN005-MASINGINI','PBA009-CHANJAMJAWARI','MWZ041 - KIRUMBA','ZAN036-MATEMWEE','D
AR040-MBAGALA','DAR032-KURASINI','ZAN014-FUONI','DAR006-MTSOMTONCHANGOMBE','MWZ0
10 - MKASESERO','DAR056-KIJICHI','ZAN952-FUONIZANTEL','ZAN046-KOMBENI','DAR163KIGOGOMBUYUNI','MSH036-KWASADALA-20P','DAR131-RAHATOWERS','DAR208-BIASHARA','ZAN
002-KIWENGWA','ZAN042-JANGOMBE','DAR133-SOKOTA','DAR087-MBAGALAKUU','DAR252-MOGO
GONI','MSH069-MAJENGO','DAR045-VATICAN','DAR019-CITYCENTRE02','ARU043-SANAWARI-J
UU','DAR016-IFM','DAR282-MCHIKICHINI','MWZ002 - KAWEKAMO','MSH079-RUNDUGAI','DAR
071-MTONITN01','ZAN031-MKOKOTONI','DAR010-GHANA','DAR086-MBURAHATI','MSH071-USWA
A-MWERA','DAR351-BARUTI770','ZAN039-TEMONDO','DAR006-MTSO-MAGOMENI','DAR184-SALE
NDERBRIDGE','DAR169-KIZUIANI','DAR343-MALANGA','MSH022-KIBOROLONI','DAR029-NYANG
ORO','DAR397-NKURUMAH1','MSH095-MIEMBENI','DARTX3-LUMUMBA-TX','3.1','MWZ040-BWIR
U','MSH024-BOMAMBUZI','DAR071-MTONITN02','ZAN045-DOLE','ZANTX1-KILINDI','DAR128HANANASIFU','DAR129-AGHAKHAN','DAR013-MAGOMENITN1-20PB','MSH038-PETERSHOFF','DAR
018-KINONDONI','DAR108-OCEANRD','DAR901-JMALL','MSH007-TPC','DAR113-KONGO','MSH5
03-NDUNGUTOWN','DAR157-MIVINJENI','PBA006-KICHUNJUU','DAR027-LIVINGSTONE','DAR09
3-MAVUNO','MSH073-RAU','ZAN016-TUNGUU','ARU060-KISONGOBSCTN01','ZAN020-CHWAKA','
MSH096-KIUSA','DAR037-MUHIMBILI','ZAN038-KIBWENI','DAR396-KARIAKOO','MSH058-HIGH
LANDSCH','DAR031-CHANGOMBE-20PB','ARU002-ESAMI-20P','ZAN013-BUBUBU','DAR398-KIDO
NGOCHEKUNDU','MSH052-MOSHITOWN','ZAN001-STONETOWN','DAR077-KAUNDA','ZAN049-SEBUL
ENI','MWZ093-MWANZABSC_TN01','DAR319-MKUNGUNI','DAR219-TEC-KURASINI','ZAN037-MFE
NESINI','DAR394-KARUME-STADIUM','ZAN050-MAILINNE','ZAN006-HAMAMNI','DAR023-LINDI
','ZAN030-DUNGA','MSH065-BISHOP','MSH054-MABOGINI','DAR195-MOGOGONI-L/STONE','MS
H020-MAMSERA','ZAN004-MAZIZINI','DAR007-MKWEPU','ZAN034-BWEJUU','DAR395-AGGREY',
'DAR303-SALASALA-MSC-TN-01','ZAN047-DARAJABOVU','ZAN028-MICHAMVI','MSH057-WERUWE
RU','ZAN032-KITOGANI','DAR066-SEAVIEW','ZAN044-KISIMAMAJONGO','DAR015-MSIMBAZI',
'ARU041-SINONI','ZAN051-KIJANGWANI','MSH018-KIBOSHO','DAR129-AGAKHAN','DAR031-CH
ANGOMBE-TN02','MOR511-BIGWA','DAR021-TABATA','ZAN024-KINYASINI','BGO095-MLANDIZI
JANGA','LND007-MBAWALA-TN01','MOR508-MADIZINI','DAR262-MSASANI','TNG049-MASHEWA'
,'MBY007-CHUNYA','DAR223-LUMO','BKB012-BIHARAMULO','DAR352-INTERCHICK','BKB869-T
ANICA','DOD016-MINGELI','SNG025-SELOUS','MSH072-KAHE','MBY064-LUPATINGATINGA','D
OD009-IHUMWA','SHY003-MWADUI','BKB019-KAYANGA','BKB002-KAMACHUMU','IRI080-SAWALA
','IRI027-LUPEMBE','DOD174-KISESE','DOD161-NTOMOKO','DAR308-KIGOGO_KATI','DAR523
-KWABIESTA','SGD021-KITITIMO','MWZ022-ISAMILO','BGO034-ZINGA','DAR316-YOMBOKIWAL
ANI','DAR314-MAVURUNZA','TAB927-USOKE','DOD127-BUNGENI','MWZ053-GINE B','BGO115SAADANI','MBY021-ILEJE','MBY065-MATUNDASI','MOR068-IGOTA','DARXXX-SELCOM','BGO01
5-MOHORO','DAR544-UBUNGOKIBO','MSM364-NYEGINA','MOR001-MOROGOROBSCTN02','DAR039UBUNGO','MTR708-MIKANGAULA','MWZ020-BUZURUGA','MBY005-TUNDUMA','MTR034-MASASI_TO
WN','DAR155-KWEMBE','SHY029-KILULU','AIRTELBSC','DAR552-MWALITANI','MWZ139-KASEN
I','DAR399-SOMALISWAHILI','MSH014-KWAMDUNGO','TNG075-GOMBERO','DAR531-MSISIRI-A'
,'ZAN003-UROA','TNG004-SEGERA-TNO2','TNG012-MKATA','MBY033-BUS-STAND','ARU039-AR

USHATOWN','LND270 MTANDA ATL','MSH527-LONGOI-VODACOM','DOD050-NGOMAI','DAR368-RA

DIOMARIA','DAR035-TANDALE','DAR240-MAKOKA','TAB016-IPULIQQ','MSM032-KISORYA','DA
R386-WAZO-CONTAINER','SHY408-NGAYA','TNG077-MKUZIMUHEZA','BKB816-KAAGYA','DOD087
-CHIPOGORO','DAR284-TEMEKECCM','DAR008-KIBAHA','MBY040-NDAGA','BGO008-MISUGUSUGU
','RUK618-TAMASENGA','LND269-MCHINGA','DAR176-MWANA-KISIWANI','DAR257-TEMEKESAND
ALI','DAR514-TABATA-BIMA','DAR017-MWENGETN02','TNG013-LUSHOTO','SHY020-KOLANDOTO
','BKB882-NYAKAHURA','SHY722-SONGWA','TNG004-SEGERA-TN01','MOR096-VIBANDANI','MW
Z024-MAGU','DAR468-KIMARADARAJANI','SNG024-MSAMALA','MOR510-GENDA','DAR026-MIKOC
HENI','BKB014-KAGERA-SUGAR','DAR296-MLALAKUWAJKT','DAR537-UKOMBOZICCM','MBY015-K
IGOWE','MOR011-SIGNALHILL','SNG027-MATOGOROMISSION','DAR117-TEGETA-TN01','TNG056
-LUSHOTOTOWN','MSH066-LYAMUNGO','TNG067-PANDE','DAR234-URAFIKI','SNG001-SONGEA',
'DAR222-MAKANGARAWE','DAR126-KUNDUCHIBEACH','ARU025-LENGIJAVE','DAR248-MTAMBANI'
,'DOD123-PAMPUKA','LND010-NACHINGWEA','BKB893-MUKUNYU','IRI059-MATEMBWE','ARU004
-KILANYI','DAR161-KIBAMBA','TNG118-TEULE','MWZ243-LWENZELA','ZAN022-KIZIMKAZI','
INFINITY-CUSTOMER-CARE','MOR029-DAKAWA','TNG354-UKOMBOZI','MSM009-BUTIAMA','BKB8
60-KATEMWA','MBY495-CHUNYATOWN','SHY002-KAHAMA','DAR148-MAILIMOJA','DAR360-TMK-A
NGLICAN','KIG014-MANYOVU','BGO026-KWAMATIAS','TNG002-TANGACEMENT','TNG129-MKINGA
','MWZ039-CAPRI-POINT','TNG101-KWAKIFUA-20PB','DAR232-KWATEMBA','MSM019 -BUHEMBA
MINES-TN01','LND001-MAKONDE-TN01','DAR173-SINZAKIJIWENI','TAB013-BUKENE1','MWZ14
4-NSSF-BUILDING','DAR146-MABIBO','MSM308-KISUMWA-HILL','MSH512-MWEMBE','MTR666-N
ANGANGA','DOD101-UDOMSOCIAL','IRI020-LUDEWA','DAR220-KAWADUCE','DAR241-MTONIMTON
GANI','MTR665-SABASABASHULE','MBY488-MAANGA','BKB892-KAMAGAMBO','IRI033-MALANGAL
I','DAR542-MWONGOZO-PS','MSH011-SANYAJUU','TAB017-NGAMBO','SHY008-MASWA','ZAN015
-MAHONDA','DAR090-PUGUKAJIUNGENI','DAR852-KISOTAITV','DAR377-MBEZIMADUKANI','BKB
007-NGARAK9','DAR057-LUGURUNI','TNG346-MILUNGUI','MWZ007-UKEREWE1','ARU100-KIKWA
KWARU','LND268-NANGURUKURU','BKB029 - KISANDA','MOR517-LUKOBE','DAR125-GEZAULOLE
','IRI003-NJOMBE','MSM356-BUNARE','MSH513-KISIWANI','DAR558TEMBONI-MSIGWA','MWZ0
89-BUSWELU','DAR211-MINAZIMIREFU','DAR080-BANDARI','DOD080-MILEMBE','MBY051-IGAM
BA','DOD051-MPWAPWATOWN','MTR651-NDANDATOWN','TAB014-TABORATOWN','TNG117-MWANGOM
BE','MBY047-KATUMBASONGEWE','DOD112-MLALI','BKB899-NYAMBOGO','BGO164-MAILIMOJAVO
DA','SHY000-SHINYANGATTCL','TAB919-KALIUA','MBY008-KYELA','DAR312-SEGERAMAKUKA',
'MWZ012-NASA','MBY023-ILOMBA','DAR145-MIKOROSHINI','DAR089-MATEMBELE','MSH045-BW
AMBO','DAR315-UKONGAKM','MWZ206-LUMALA','DAR375-CLOUDS','DAR181-ILALABUNGONI','M
OR015-GAIROTOWN','MWZ104-LWAMGASA','MBY041-ISYESYE','MBY013-CHIMALA','DAR006-MTS
O-TEMEKE','DAR116-JANGWANI','DAR238-KINONDONIB','ARU001-AICC-20PB','BGO092-NIANJ
EMA','BKB868-KATORO','ZAN012-TUMEKUJA','MWZ009-SENGEREMA','DAR580-MABWEPANDE','B
KB886-RUSHWA','MWZ104 - KASAMWA','MWZ118-NYEHUNGE','TNG072-MAGOMASONGEA','LND016
-CHIOLA','MWZ025-MISASI','LND020-MKWITIJUU','ARU005-UNGALIMITED','ARU034-TANAPA'
,'MBY017-KANDETE','SHY701-MWANDAMA','MYR013-GALANGALA','DAR286-BONYOKWA','IRI009
-KIFANYA','IRI026-BULONGWA','DAR349-KIBANDACHAMKAA','MTR004-NEWALA','DAR060-VITU
KA','MWZ093-MWANZABSC-TN03','MBY053-IHANDA','MTR000-MTWARATTCL','DAR239-KIMARAMA
TANGINI','TNG131-MAZINDE','MSM003-TARIME','BKB027-BUKOBATOWN','DAR187UBUNGOMAZIW
A','DOD100-UDOMMEDICINE','DAR422-KIMANGA-NHC','PBA001-WETE','DAR521-DIT','DAR402
-NYEBURU','TNG346-KWANJEKA','SHY004-ISAKA','DAR304-KILONGAWIMA','DOD118-MATUMBUR
U','IRI017-MTWANGO','MWZ008-MKUYUNI','DAR711-GOBA-KUNGURU','DAR031-CHANGOMBE-TN0
1','RUK000-NDISO-VODA','MWZ098-MURITI','MYR011-DONGOBESH','DOD021-MSALATO','DAR6
57-IPTL','SNG029-KITAI','DAR121-MAWENI','DAR263-BUGURUNI-MALAPA','BGO065-BUNGU_T
OWN','MBY900-MSONGWA','BGO059-MAJICOAST','IRI306-MLANGALI','SNG023-LISABONI','DO
D079-UDOM','SONGEAVODA','ZAN018-MACHUI','DAR579-GOROKA','MOR100-NANENANE','DAR47
2-MAKUTIBONDE','DOD044-DODOMABSCTN01','MOR043-COLA','TNG036-MUHEZA','ARU097-KALO
LENI','SHY409-NDOLELEJI','MBY020-MBOZI','DAR192-BANANARELINI','TNG010-GOMBA','MB
Y066-MKWAJUNI','LND002-KILWA','BGO086-ZEGERENI','MSM370-IRAMBA','MBY059-RUIWA','
MBY002-METATN02','BKB022-RULENGE','DAR594-KIBAGA','BKB008-KEMONDO','MOR007-FORES
T','MOR504-UHURU','LND006-KITOMANGA-20P','MYR622-MATUI','ZAN007-NUNGWI','MBY010RUNGWE','DAR068-MLALAKUWA','MBY025-MWANJELWA','MSH017-TARAKEA','DAR165-MAJOHE','
SHY011-BARIADI','BGO030-KIWANGWA','DAR025-TEMBONI','MSM373-BOLEGA','DAR207-KUMBU
KUMBU','DAR400-KIPUNGUNI','ARU101-MWANAMA','MYR005-HANANG','DAR370-TEMBONISALANG
A','SNG046-BOMBAMBILI','DOD012-MARAMBAU','SHY001-SHINYANGA-TN2-20B','MOR519-KIWA
NJANDEGEE','MBY012-IGAWA','MOR065-MGETAMCHOMBE','MSH005-MABUNGO','MWZ065-MECCO',
'MOR008-KILOMBERO','TNG045-DONGE','BGO001-CHALINZE','MOR001-MOROGOROBSCTN01','DA

R955-IPSHOUSE','DAR053-BAHARIBEACH','DAR666-TANDIKASOKONI','DAR374-MBEZIMAKONDE'
,'DAR095-KIMBIJI','TNG044-RASKAZONE','MBY073-KADEGE','SHY735-ZANZUI','ARU103-OSU
NYAI','DAR235-UKONGAMIKOROSHINI','MWZ248-IBANDA','DAR255-PILIKAPILIKA','MWZ235-S
ANGIRA','MTR014-MSANGAMKUU','ARU105-NGARENARO','BKB861-MABIRA','MTR725-MNAZIBAY'
,'SNG047-MFARANYAKI','DOD115-KIKOMBO','DAR324-KWEMBEMPAKANI','TNG382-KWEDIBOMA',
'BGO035-KIGONGONIYOMBO','ARU007-IMPALA','DAR036-REGENT','MBY485-MBALIZI-TOWN','M
SM365-KASUGUTI','SHY021-MALAMPAKA','MTR675-KITANGARI','SHY407-NYAMITEGERA','TNG1
21-KOROGWE-TTC','MSM011-MUSOMA2','MSH006-ROMBO','DAR309-MOMBASA','SHY009-MALYA',
'SHY017 - USHIROMBO','ARU020-GEIKRUM','MOR099-MBUYUNI','RUK000-SUMBAWANGA-VODA',
'SHY486-KAKOLA','MOR093-FFU','DOD133-BEREKO','TNG069-MWAKIZARO','BKB898-MURONGOB
ORDER','TNG116-MSAMBWENI','SHY724-SAS-KAHAMA','MSH056-ROMBO-MASHATI','DOD107-VIW
ANDANI','BGO064-KIMANZICHANA','MBY501-TETE','MSM357-BUKAMA','DAR034-TABATARELINI
','DAR221-YOMBOMALAWI','DAR052-KIMARA','MOR567-SANJE','MWZ018-GEITA_MINES','BKB0
11 - MUTUKULA','DAR362-KEKOPOLISI','MOR506-KILAKALA','DAR550-GOBAMATOSA','MOR013
-KWAMBE','TNG065-LWENGERA','BKB013-CHATO','SHY497-KAHAMA-NYASUBI','DAR122-UBUNGO
RUBADA','DAR151-MUHONDA','TAB933-LOYA','DAR228-MAGENGENI','IRI025-MILO','MOR061KIBEREGE','LND011-KILWAMASOKO','TNG060-MKANYAGENI','TNG066-BOHELOI','DAR512-TABA
TAMANDELA','MOR551-CHAKWALE','DAR112-MAPIPA','MSH524-MTII','TNG094-KILULUDUGA','
TNG018-HOROHORO','TNG007-MOMBO','DAR547-KINZUDI','MWZ126-LUCHELELE','DAR268-KIJI
TO-MPAKANI','MWZ011-NYANGUGETN01','MTR679-JIDAH','MOR005-PANGAWE','DOD027-MSALAT
OMISSION','BKB003-KASHAI','DOD167-MRIJO','DAR378-KIMARASOUTH','MSM004-BUNDA','TN
G371-KWANKONJE','MWZ051-NYAMATONGO','MWZ033-NYAKATO','MSH525-PUMWANI','SHY496-KA
HAMASHUNU','MWZ056 - NYAMIZEZE','TNG043-PANGANIFALLS','DAR300-KIBANGUNOVO','DAR4
06-MAJOHEPUGU','MBY045-KYIMO','TAB922-MWAMALA','MBY016-KARUWEHILL','TNG027-KIBIR
ASHI','DAR408-ULONGONI','MOR002-CHANGARAWE','TNG114-CHUMBAGENI','ZAN033-UNGUJA-T
N02','BKB021-NGARATOWN','DAR659-BUNJU-BEACH','MOR060-MAZIMBU','MBY006-TUKUYU','M
TR050-MTOPWA','IRI046-MGOLOLOTX','NYALAJA-TAB926','DAR067-MAWENZI','MBY077-UBARU
KU','MWZ097 - MALIMBE','DOD052-BUMBUTA','MSH511-KALIMANI','DOD117-ITOLWA','SHY05
2-USHIRIKA','RUK005-WIPANGA','MOR051-SUA','BGO098-KUDIEMBE','MBY076-MWAKIBETE','
DOD077-UHINDINI','DAR311-TABATASIGARA','DAR599-SUKAUPENDO','DAR126-KUNDUCHIBEACH
-TN2','MOR001-MOROGOROBSCTN03','MTR678-HIARI','SGD013-KIOMBOI','ARU111-NDURUMA',
'TNG063-MAFURIKO','MOR559-MODEKO-A','MTR009-CHUNGU','DAR359-NDENDEULE','ARU058-M
OIVO-B','SHY729-MKULA','DAR139-KIJITONYAMA','DAR469-SINZA-A','MOR067-IDETE','DAR
303-SALASALA-MSC-TN-03','BKB832-BIHARAMULO-TOWN','MTR006-LUKULEDI','LND021-CHIGU
GU','SONGEA-TTCL','SNG028-TUKUZI','DAR089-HORSECLUB','BKB833-NYAMILEMBE','MSM374
-BINAGI','MWZ015-LAMADI','DAR073-FRIENDS-CORNER','MSH026-NDUNGU','DOD007-KONGWA'
,'TNG040-SONI','DOD046-HAZINA','ARU060-KISONGOBSCTN02','IRI030-KIPENGERE','LND00
1-MAKONDE-TN02','MSM001-MUSOMA','MSM007-MUGANZA','TNG365-MASATU','DAR002-UNIVERS
ITY','DAR310-MIGOMBANI','RUK000-LYAMBA-LYA-MFIPA-VD','SGD864-OLD-KIOMBOI','SGD02
0-MIKUMBI','BKB017-BUSERESERE','DAR303-SALASALA-MSC-TN-02','MBY067-KIMANI-MBUYUN
I','MWZ042 - KIGONGOFERRY','DAR048-KIGOGONEW','MWZ036-KISEKE','MOR085-WAMISOKOIN
E','MWZ124-NYAMAYUKI','DOD024-NAMHOTEL','ZANTX01-KILINDI','TNG087-MTIMBWANI','TN
G023-MKUZI','SGD853_ILONGERO','BKB896-MUGANA','SHY015-TINDE','MTR038-MTWARA-TTC'
,'DAR143-MTONISABASABA','MOR049-MLIMBA_TX','DOD049-KONGWARUNCH','MSH000-MOSHI-TT
CL-TN01','DAR565-KIBAMBAMPYA','IRI329-WANGINGOMBE-AIRTEL','MSM037-NYABANGEMISSIO
N','RUK003-NAMANYERE','DAR109-BUZA','IRI331-IGANDO','LND013-MNAZIMMOJA','MSH015KAVAMBUNGHU','DOD054-DODOMA MAKULU','MWZ246-NYAKASUNGWA','DOD110-WAJENZI','DAR13
6-KEKOMWANGA','DAR129-TEC-KURASINI','MOR035-KIBUNGO','MTR037-MABATINI','DOD104-M
AKOLE','SHY710-NKOLOLO','MSM376-KIRIBA','IRI029-ILEMBULA','MOR069-MSOWERO','TNG3
61-KWAMKASHI','MOR053-MSAMVU','DAR059-YOMBODOVYA','DAR344-VITUKA_MACHIMBO','LND2
60-MNERO','DAR217-KEKOMWANGA B','RUK000-SUMBAWANGA-AIRETL','IRI317-MTAMBUKA','TA
B015-MWISI','DAR160-MBAGALAKINGUGI','LND012-KIBATUKA','DAR492-TEMEKEBSC-TN01','M
OR003-KIHONDA','DAR517-MWEMBEMADAFU','SGD000_TTCL-SINGIDA','MBY496-TAZARA-JUU','
BKB857-GOMA','MSM375-KIABAKARI','SHY045-NYASUBI','LND022-LECHELEGWA','SNG010-PER
AMIHO','DAR214-MATOSA','MOR530-CHAZURU','SHY712-IPILILO','SHY482-KAGONGWA','MWZ1
17-KAMENA','MBY074-IYUNGA','RUK608-KANOGE','DAR001-TBL','MSM044-IKIZU','DOD004_C
HAMWINO','DAR167-MBUTU','DAR132-TABATAKISUKULU','MSH025-KIHURIO','DAR313-MTONIKI
NDANDE','DAR259-MAPIPA_TAKADIR','BKB894-IBWERA','MTR007-MIKINDANI','DAR337-K.I.U
','SHY708-NYAKABINDI','MYR019-MAGUGU','SGD050-MISUNA','MWZ000-VODACOMMGW','TNG08
6-MISOZWE','DOD001-OLDDODOMA-TN01','MYR001-MBULU','MBY046-MASOKO','MBY014-IGURUS

I','IRI312-KIDUGALA','DAR055-EXTERNAL','MOR036-DUMILLA','MYR632-SUNYA','MTR012-M
TWARA','MOR538-MAGOLE','DAR566-YOMBO','DAR321-ILALA SOKONI','BKB887-RUBALE','DOD
015-LIBULI','DAR388-MSEWE','LND007-MBAWALA-TN02','MOR553-KWALEMA','MBY058-INYALA
','TNG101-KWAKIFUA','MWZ093-MWANZABSC-TN02','MSM351-BUNDA1','DAR414-SIDOVICTORIA
2','BKB877-KAGONDO','BGO091-IKWIRIRI-VODA','MTR002-LILUNGU','MBY048-LWANGWA','TA
B923-ILALWANSIMBA','BKB872-NYAISHOZI','ARU102-SOKON-ONE','BGO088-MZIMUNI-KIBAHA'
,'BGO060-MLANDIZIKATI','MTR039-NANGWALA','BKB841-KIJUMBURA','MWZ239-LUSHAMBA-KAN
YALA','MSM031-NYAMATALE','DAR649-SINZAMUGABE','DAR582-TRAVSEC','LND238-NANGANDO'
,'MWZ002-KAWEKAMO','SHY412-BUSANGI','SHY490-DIDIA','MBY071-NONDE','DAR403-BEACHP
EMBA','IRI307-KIBENANJOMBE','BKB005 KAGERA-SUGAR1','DAR574-MTAVA-QC','BGO006-MSA
TA','DOD081-KWA-MATOVOLWA','DOD005-MVUMI','DAR193-WAZO-KKKT','ARU060-KISONGOBSCT
N03','TNG123-MAREMBWE','MBY534-IGAWA-TOWN','BGO106-MZENGA','TNG357-JUWATA','LND0
15-LINDITOWN','MWZ064-GEITHATOWN','MYR623-ENDASAKI','DAR625-MAVURUNZA-G5','LND22
5-KILWAKISAGI','MWZ132-NZERA','DAR188-PUGUMPAKANI','IRI081-MDANDU','DOD044-DODOM
ABSCTN02','BKB865-ISHOZI','DOD090-KIBAIGWATOWN','DAR480-TEGETAKUNDUCHI','MSM022MUGUMU','MOR027-MTIBWA','DAR527-SINZA-MORI','DAR033-KIWALANI','DAR047-KAWE','TAB
010-SIKONGE','MSH010-MWANGA','MWZ061-GHANA','DAR940-UHURUHEIGHTS','DAR535-MIDLAN
D','MBY009-KASUMULU','RUK004-MPANDA','MBY004-MBALIZI','DOD113-CHAMKOROMA','DAR50
8-NYANTILA','RUK001-SUMBAWANGA','MBY487-UTUKUYU','MBY063-CHALANGWA','TNG127-MAUA
INN','MSM360-MUGANGO','DAR641-WAZO-KISANGA','DOD003-KONDOA','DAR405-MAJOHEMPYA',
'MBY490-MATEMA','IRI073-ILLUNGU','DAR144-STAKISHARI','KIG012-HERUJUU','TNG021-OL
DKOROGWE','MWZ167-MALIGISU','DAR156-KIMARAKOROGWE','SGD023-CHIKUYU','DAR096-MSAK
UZI','MSM018-LORIA','BGO105-LUGOBA','MOR097-MZUMBEUNIVERSITY','LND226-LIWALETOWN
','MOR095-MASIKA','MWZ133-BUNDAMHELWA','DAR242-BUNJUCCM','TNG088 -MHINDURO','BGO
031-VIGWAZA','SHY001-SHINYANGA-TN1-20B','MOR022-DOMA','DAR653-KIMARAMATETE','DAR
567-MADUKAMAWILI','SHY016-OLDSHINYANGA','IRI028-MIGORI','ARU019-NGURUDOTO','MWZ0
01-BUGANDO','ARU104-MABANZINI','BKB871-KABOYA','DAR507-KITUNDAKATI','MBY486-SIND
E','MWZ063-BWIRUB','MSH514-CHOME','DAR215-MAGOGONI','DAR363-MWEMBEUMBEA','DAR117
-TEGETA-TN02','BGO024-VIKINDU','TAB003-URAMBO','BGO102-KIBAHA-TRA','MWZ050-MABAT
INI','DAR532-CHAKENGE','MSH526-NGARONYI','MSH098-HOLILI','DAR051-MWANANYAMALA','
DAR049-UKONGA','DAR347-MWEMBE_CHAI','MWZ038-ISAMO','RUK610-MALONJE','MWZ060-NANS
IO-RC','TAB007-YELAYELA','MBY024-MBARALI','MWZ140-SUMVE','DAR373-KAWEBEACH','DAR
201-BARAFU','DOD121-MORISHENI','RUK620-MPANDA-TOWN','BKB880-BWERA','BGO013-IKWIR
IRI','BGO014-SOMANGA','MSM005-NYAMONGO','MSH055-KIDIA','DOD109-CHANGOMBE_JUU','D
AR197-TANDIKAMANGO','DAR236-UKONGAKICHANGANI','MSH039-USERI','SGD014-SINGIDA2','
DAR322-KIVULEMAKORE','DAR100-JAMANA','DAR028-KIGAMBONI','MOR094-UJENZI','TNG353
-MAKORORA_KATI','MOR525-GAIROCENTER','TNG352-NEWRASKAZINE','DAR519-TABATA-DARWES
T','DAR529-KAMBANGWA','BGO020-MGOMBAKATI','SHY494-LUGUNGA','LND023-NACHINGWEA_ST
AND','MWZ035 - USAGARA','BKB010-NYAMASORO','MOR014-GAIROHILL','TNG068-MWAHAKO','
MOR528-KIBAONI','MSH552-MROKORA','DAR129-AGAKHAN-TN01','TNG016-HALE','MSM349-BUK
IMA','BGO017-UTETE','DAR348-MTONICHAUREMBO','DAR323-TASAF','DAR061-MJIMWEMA','DA
R518-SEGERESHULE','DAR624-BUZAKIPERA','DAR454-YOMBOKILAKALA','DAR063-VINGUNGUTIT
N','DAR568-TAZARAFLATS','SGD005-IKUNGI','DAR930-PALMSRESIDANCE','SHY480-LUHENDE'
,'DAR548-NDUGUMBI','SHY737-LUHOMBO','ARU098-SANAWARICHINI','DAR307-KIGOGOJUNCTIO
N','TNG026-KILINDI','ZAN019-MKWAJUNI','MWZ003-NYEGEZI-TN02','BGO151-KIBAHAMACHIN
JION','BKB020-MARUKU','MOR006-MIKESE','MBY054-HEZYA','BKB883-KABANGA-BORDER','TN
G364-PANGAMLIMA','DAR295-KWAMWALIMU','DAR341-TIPTOP','BGO010-KIBITI','DOD026-KIS
ASA','MSM353-NATTA','DAR876-MBWENI-VODA','DAR334-MAJOHESHULE','IRI011-MGOLOLO','
BGO066-JARIBU','TNG048-KIBAONIHILL','TNG073-VUGIRI','SHY073-NYANIGA','SHY012-BUL
YANHULU','TAB925-ITOBO','ARU040-MATEJOO','MOR509-MALINYI','MSM016-NANSIMO','DAR3
40-AZIMIO','TNG000-TANGATTCL','DAR135-KWAAZIZALLY','DAR076-MAKUTI','RUK617-CHALA
','MBY079-IPINDA','DAR329-KIMANGA_SUNSET','BGO101-BAGAMOYOVODA','LND009-NDANDA',
'BKB873-RUBYA','MSM034-BUNDATOWN','DOD138-CHINANGALIVODA','TNG126-TAMTA','MWZ023
-NYAMBITI','SHY489-KIZUMBI','MSM354-BUBOMBI','MSM369-KAMKENGA','MSM002-SIRARI','
MTR674-MSIMBATI','MYR009-NJORO','MWZ093-MWANZABSC-TN01','DAR573-KURASINI-POLISI'
,'ARU052-SEKEI','ZAN027-MALINDI','MBY489-VETAMBEYA','MOR512-FUNGAFUNGA','MSH046BOMBO','DAR256-MABIBO_LOYOLA','DAR204-MBEZI JUU','BGO087-MKUZA','SHY487-DUTWA','
RUK000-MASHETE-VODACOM','MOR054-KWAMCHUMA','RUK005-KALULUNGA','LND004-LIWALE','M
SM017-SHIRATI','DAR578-KISOTA','MSM377-NYAKATENDE','ARU006-MERERANI','TNG422-KWA
MKOMBA','MOR083-DIHOMBO','MSM006-NYAMWAGA','DAR502-AVONHOTEL','ARU138-DOSIDOSI',

'ARU081-MILITARYACADEMY','DAR158-BIMA','DAR244-KITUNDARELINI','MBY003-UYOLE','DA
R478-ZIMBILI','DAR389-MAKANYADSM','DAR572-BONGOLOLO','DAR092-TANDIKA','DAR191-BO
NANZA','TNG119-MASUGURU','MWZ136-KATUNGURU','MSM368-MAKUTANO','SNG007-MASANGU','
DAR054-BENSON','BGO094-KWAKOMBA','DAR281-KIMARASTOPOVER','SGD012-MANYONI','MTR00
8-NANYAMBA','IRI328-MDANDU2','BKB881-BENAKO','MBY001_MBEYA','MBY000-TUNDUMA-TTCL
','DAR216-KIGAMBONIFERRY','DAR249-SUKITA','MBY031-KIWIRACOALMINE','BKB867-KAISHO
','DAR492-TEMEKEBSC-TN02','DAR326-VETENARY','MOR550-SUA-UNIVERSITY','MWZ128-KILA
BELA','MOR044-MAFIGA','MWZ207-MABUKI','TNG014-PANGANI','MWZ129-SIMA','DAR291-TAB
ATAKISIWANI','ARU035-MAJI-YA-CHAI-20P','MWZ019-ILEMELA','TAB006-MAYOMBO','BKB015
-KANYIGO','SNG015-MADABA','DAR479-KWAKOPA','DAR600-BAHARI','MWZ122-NYAMIKOMA','M
TR015-MADABA-MTWARA','ARU022-LOSIMINGURI')
( DC.DC_E_SOEM_TN_RADIO_LINK_RAW.NODE_NAME like '%MWZ%')
)
GROUP BY
DC.DIM_DATE.DATE_ID,
DC.DC_E_SOEM_TN_RADIO_LINK_RAW.DATE_ID,
DC.DC_E_SOEM_TN_RADIO_LINK_RAW.NE_ID,
DC.DC_E_SOEM_TN_RADIO_LINK_RAW.NODE_NAME