create table #category (cat_id SMALLINT NOT NULL, category CHAR(20) NOT NULL, type CHAR(6) NOT NULL, risk CHAR(20) NOT NULL) GO INSERT INTO #category (cat_id,category,type,risk) VALUES (1,'control','','') INSERT INTO #category (cat_id,category,type,risk) VALUES (2,'sbpLow','low','sbp') INSERT INTO #category (cat_id,category,type,risk) VALUES (3,'sbpLowest','lowest','sbp') INSERT INTO #category (cat_id,category,type,risk) VALUES (4,'HBA1CLow','low','HBA1C') INSERT INTO #category (cat_id,category,type,risk) VALUES (5,'HBA1CLowest','lowest','HBA1C') INSERT INTO #category (cat_id,category,type,risk) VALUES (6,'LDLLow','low','LDL') INSERT INTO #category (cat_id,category,type,risk) VALUES (7,'LDLHi','hi','LDL') INSERT INTO #category (cat_id,category,type,risk) VALUES (8,'WeightLow','low','Weight') INSERT INTO #category (cat_id,category,type,risk) VALUES (9,'WeightHi','hi','Weight') INSERT INTO #category (cat_id,category,type,risk) VALUES (10,'ACE','','') INSERT INTO #category (cat_id,category,type,risk) VALUES (11,'Aspirin','','') INSERT INTO #category (cat_id,category,type,risk) VALUES (12,'Beta','','') INSERT INTO #category (cat_id,category,type,risk) VALUES (13,'Eye','','') INSERT INTO #category (cat_id,category,type,risk) VALUES (14,'Foot','','') INSERT INTO #category (cat_id,category,type,risk) VALUES (15,'Smoke','','') GO INSERT tblCategory(cat_id, category,type,risk) SELECT cat_id, category, type, risk FROM #category WHERE category NOT IN (SELECT category FROM tblCategory) GO DROP TABLE #category GO DELETE FROM tblOut WHERE job_id = 1482 DELETE FROM tblPPA WHERE job_id = 1482 DELETE FROM tblJob WHERE job_id = 1482 GO INSERT INTO tblJob( job_id, grid_id, age, yearinterval ) VALUES (1482, 1482, 50.00001, 0.999 ) GO INSERT INTO tblPPA( job_id, risk, low, control, hi) VALUES (1482, 'HBA1C', 6.02924611393693, 7.00900826958291, 8.02662000610376 ) GO INSERT INTO tblPPA( job_id, risk, low, control, hi) VALUES (1482, 'LDL', 110.165113733469, 154.840391415056, 198.840394355036 ) GO INSERT INTO tblPPA( job_id, risk, low, control, hi) VALUES (1482, 'SBP', 105.592999038657, 121.197362041709, 136.610519708037 ) GO INSERT INTO tblPPA( job_id, risk, low, control, hi) VALUES (1482, 'weight', 84.1036238769074, 105.533531074262, 126.640237286877 ) GO INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 0, 'diabetes', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 0, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 0, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 0, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 0, 'stroke', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 0, 'reinfarction', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 0, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 0, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 1, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 1, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 1, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 1, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 1, 'stroke', 0.0051466690012919 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 1, 'reinfarction', 0.0124221995061186 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 1, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 1, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 2, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 2, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 2, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 2, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 2, 'stroke', 0.0103471450057497 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 2, 'reinfarction', 0.0398824615797837 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 2, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 2, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 3, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 3, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 3, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 3, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 3, 'stroke', 0.0156252810211356 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 3, 'reinfarction', 0.0548173197735271 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 3, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 3, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 4, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 4, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 4, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 4, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 4, 'stroke', 0.0188264967935842 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 4, 'reinfarction', 0.0732118171146617 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 4, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 4, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 5, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 5, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 5, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 5, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 5, 'stroke', 0.0220916302252816 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 5, 'reinfarction', 0.0930001287019894 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 5, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 5, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 6, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 6, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 6, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 6, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 6, 'stroke', 0.0265115475190775 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 6, 'reinfarction', 0.113006658512606 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 6, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 6, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 7, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 7, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 7, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 7, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 7, 'stroke', 0.0287623868677278 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 7, 'reinfarction', 0.144722008605112 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 7, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 7, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 8, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 8, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 8, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 8, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 8, 'stroke', 0.0356750808067812 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 8, 'reinfarction', 0.170078769734961 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 8, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 8, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 9, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 9, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 9, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 9, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 9, 'stroke', 0.0450487604084583 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 9, 'reinfarction', 0.197170983971023 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 9, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 9, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 10, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 10, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 10, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 10, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 10, 'stroke', 0.0522019196419146 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 10, 'reinfarction', 0.223569519450056 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 10, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 10, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 11, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 11, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 11, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 11, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 11, 'stroke', 0.0558543161937397 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 11, 'reinfarction', 0.241752062199255 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 11, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 11, 'footproblems', 0.0316629228995514 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 12, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 12, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 12, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 12, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 12, 'stroke', 0.0671163570103497 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 12, 'reinfarction', 0.261704788487005 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 12, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 12, 'footproblems', 0.049570887346052 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 13, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 13, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 13, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 13, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 13, 'stroke', 0.0709318267031613 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 13, 'reinfarction', 0.27562253403982 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 13, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 13, 'footproblems', 0.0599015363033027 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 14, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 14, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 14, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 14, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 14, 'stroke', 0.0800980341704433 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 14, 'reinfarction', 0.308572926986194 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 14, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 14, 'footproblems', 0.0731235174153525 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 15, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 15, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 15, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 15, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 15, 'stroke', 0.0854697091732051 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 15, 'reinfarction', 0.329886883370232 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 15, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 15, 'footproblems', 0.0825744698923012 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 16, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 16, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 16, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 16, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 16, 'stroke', 0.0937459446570066 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 16, 'reinfarction', 0.360153667835661 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 16, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 16, 'footproblems', 0.0963700805911579 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 17, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 17, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 17, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 17, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 17, 'stroke', 0.0994366891975246 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 17, 'reinfarction', 0.385574612985805 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 17, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 17, 'footproblems', 0.110489008570979 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 18, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 18, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 18, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 18, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 18, 'stroke', 0.10974555909337 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 18, 'reinfarction', 0.422006393834742 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 18, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 18, 'footproblems', 0.119223906850549 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 19, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 19, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 19, 'esrd', 0.00171969003154493 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 19, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 19, 'stroke', 0.118891927960058 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 19, 'reinfarction', 0.444148981162844 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 19, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 19, 'footproblems', 0.131268519125964 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 20, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 20, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 20, 'esrd', 0.00706283679534025 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 20, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 20, 'stroke', 0.12360792776158 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 20, 'reinfarction', 0.471706051739055 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 20, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 20, 'footproblems', 0.143612629381968 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 21, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 21, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 21, 'esrd', 0.016231166211422 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 21, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 21, 'stroke', 0.136519546213934 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 21, 'reinfarction', 0.495043581225615 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 21, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 21, 'footproblems', 0.151520120220821 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 22, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 22, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 22, 'esrd', 0.02202370389424 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 22, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 22, 'stroke', 0.150011151656751 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 22, 'reinfarction', 0.51584702119689 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 22, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 22, 'footproblems', 0.156516061856628 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 23, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 23, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 23, 'esrd', 0.026031797846743 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 23, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 23, 'stroke', 0.155231128127697 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 23, 'reinfarction', 0.525627553426392 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 23, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 23, 'footproblems', 0.158246284712167 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 24, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 24, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 24, 'esrd', 0.0302664355185781 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 24, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 24, 'stroke', 0.164383463595394 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 24, 'reinfarction', 0.539180116608453 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 24, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 24, 'footproblems', 0.160078174554824 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 25, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 25, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 25, 'esrd', 0.0324529815234649 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 25, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 25, 'stroke', 0.171894572671461 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 25, 'reinfarction', 0.558487778356871 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 25, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 25, 'footproblems', 0.161972022286934 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 26, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 26, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 26, 'esrd', 0.0417117336729008 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 26, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 26, 'stroke', 0.177845005136255 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 26, 'reinfarction', 0.593789146486655 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 26, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 26, 'footproblems', 0.161972022286934 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 27, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 27, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 27, 'esrd', 0.0512706392152605 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 27, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 27, 'stroke', 0.190115745704223 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 27, 'reinfarction', 0.612334289858847 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 27, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 27, 'footproblems', 0.161972022286934 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 28, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 28, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 28, 'esrd', 0.056263940083487 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 28, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 28, 'stroke', 0.204936739429941 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 28, 'reinfarction', 0.649041860150707 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 28, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 28, 'footproblems', 0.161972022286934 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 29, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 29, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 29, 'esrd', 0.0666918561548521 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 29, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 29, 'stroke', 0.215902954164185 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 29, 'reinfarction', 0.654842687971885 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 29, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 29, 'footproblems', 0.161972022286934 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 30, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 30, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 30, 'esrd', 0.077544153440683 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 30, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 30, 'stroke', 0.222750919579203 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 30, 'reinfarction', 0.669265028880913 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 30, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'control') as cat_id, 30, 'footproblems', 0.161972022286934 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 0, 'diabetes', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 0, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 0, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 0, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 0, 'stroke', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 0, 'reinfarction', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 0, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 0, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 1, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 1, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 1, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 1, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 1, 'stroke', 0.00411522051784063 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 1, 'reinfarction', 0.0103411689965826 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 1, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 1, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 2, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 2, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 2, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 2, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 2, 'stroke', 0.00934295010639374 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 2, 'reinfarction', 0.0272399451316181 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 2, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 2, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 3, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 3, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 3, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 3, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 3, 'stroke', 0.0114507302676187 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 3, 'reinfarction', 0.0432301583213116 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 3, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 3, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 4, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 4, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 4, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 4, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 4, 'stroke', 0.0178698587407744 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 4, 'reinfarction', 0.0583481006094535 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 4, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 4, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 5, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 5, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 5, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 5, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 5, 'stroke', 0.0221774401591563 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 5, 'reinfarction', 0.07250801069644 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 5, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 5, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 6, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 6, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 6, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 6, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 6, 'stroke', 0.0243600788944028 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 6, 'reinfarction', 0.0957632923377891 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 6, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 6, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 7, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 7, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 7, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 7, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 7, 'stroke', 0.0276955967377827 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 7, 'reinfarction', 0.109225623054592 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 7, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 7, 'footproblems', 0.00114090118821086 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 8, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 8, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 8, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 8, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 8, 'stroke', 0.0299463003687911 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 8, 'reinfarction', 0.148248015072155 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 8, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 8, 'footproblems', 0.00114090118821086 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 9, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 9, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 9, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 9, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 9, 'stroke', 0.035737648486634 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 9, 'reinfarction', 0.171710752546738 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 9, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 9, 'footproblems', 0.00114090118821086 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 10, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 10, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 10, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 10, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 10, 'stroke', 0.0404644152312478 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 10, 'reinfarction', 0.201696165706482 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 10, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 10, 'footproblems', 0.00114090118821086 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 11, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 11, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 11, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 11, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 11, 'stroke', 0.0476879863925382 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 11, 'reinfarction', 0.218629241676726 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 11, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 11, 'footproblems', 0.0308813732554455 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 12, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 12, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 12, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 12, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 12, 'stroke', 0.0550989372779432 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 12, 'reinfarction', 0.243551201461206 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 12, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 12, 'footproblems', 0.0496258242881712 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 13, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 13, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 13, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 13, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 13, 'stroke', 0.0601451258545287 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 13, 'reinfarction', 0.266433594876413 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 13, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 13, 'footproblems', 0.0584900091991291 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 14, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 14, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 14, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 14, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 14, 'stroke', 0.0718201906079617 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 14, 'reinfarction', 0.283326308633948 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 14, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 14, 'footproblems', 0.0701856341418613 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 15, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 15, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 15, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 15, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 15, 'stroke', 0.0744873721303188 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 15, 'reinfarction', 0.310164822836483 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 15, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 15, 'footproblems', 0.0821487693875002 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 16, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 16, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 16, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 16, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 16, 'stroke', 0.0813684750937446 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 16, 'reinfarction', 0.326491511340022 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 16, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 16, 'footproblems', 0.0957463148438753 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 17, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 17, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 17, 'esrd', 0.00155159006861894 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 17, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 17, 'stroke', 0.0870565777609621 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 17, 'reinfarction', 0.356045027810051 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 17, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 17, 'footproblems', 0.109679067637468 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 18, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 18, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 18, 'esrd', 0.00155159006861894 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 18, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 18, 'stroke', 0.0973555879084465 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 18, 'reinfarction', 0.388987517140353 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 18, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 18, 'footproblems', 0.121148420807133 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 19, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 19, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 19, 'esrd', 0.0049476698158436 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 19, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 19, 'stroke', 0.10501155888136 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 19, 'reinfarction', 0.418499147100927 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 19, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 19, 'footproblems', 0.130085817075937 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 20, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 20, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 20, 'esrd', 0.00671351199651837 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 20, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 20, 'stroke', 0.114498979538901 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 20, 'reinfarction', 0.438312428893289 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 20, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 20, 'footproblems', 0.142359533467683 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 21, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 21, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 21, 'esrd', 0.0139637460237823 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 21, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 21, 'stroke', 0.119351027751659 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 21, 'reinfarction', 0.460092542746977 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 21, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 21, 'footproblems', 0.151732559513502 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 22, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 22, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 22, 'esrd', 0.0215050953856281 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 22, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 22, 'stroke', 0.12776212847306 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 22, 'reinfarction', 0.474320601708289 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 22, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 22, 'footproblems', 0.154982622351814 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 23, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 23, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 23, 'esrd', 0.0274293652534622 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 23, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 23, 'stroke', 0.136545919639312 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 23, 'reinfarction', 0.495573733896749 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 23, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 23, 'footproblems', 0.156691453675138 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 24, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 24, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 24, 'esrd', 0.0336438528895252 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 24, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 24, 'stroke', 0.145721752912521 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 24, 'reinfarction', 0.519031091332529 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 24, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 24, 'footproblems', 0.158491471232894 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 25, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 25, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 25, 'esrd', 0.0379387620133526 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 25, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 25, 'stroke', 0.157061562017945 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 25, 'reinfarction', 0.537890151991675 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 25, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 25, 'footproblems', 0.160363569522795 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 26, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 26, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 26, 'esrd', 0.0469721341850849 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 26, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 26, 'stroke', 0.170863751829514 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 26, 'reinfarction', 0.559379667125502 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 26, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 26, 'footproblems', 0.160363569522795 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 27, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 27, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 27, 'esrd', 0.0469721341850849 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 27, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 27, 'stroke', 0.177137136023799 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 27, 'reinfarction', 0.580133011354798 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 27, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 27, 'footproblems', 0.160363569522795 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 28, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 28, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 28, 'esrd', 0.0519880587116343 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 28, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 28, 'stroke', 0.18577603645438 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 28, 'reinfarction', 0.599301611687187 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 28, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 28, 'footproblems', 0.162576048953636 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 29, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 29, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 29, 'esrd', 0.0598771553620769 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 29, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 29, 'stroke', 0.197037597907578 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 29, 'reinfarction', 0.621500717663895 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 29, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 29, 'footproblems', 0.162576048953636 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 30, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 30, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 30, 'esrd', 0.0652957157917187 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 30, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 30, 'stroke', 0.201665610430924 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 30, 'reinfarction', 0.637954558715644 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 30, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLow') as cat_id, 30, 'footproblems', 0.164992855213272 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 0, 'diabetes', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 0, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 0, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 0, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 0, 'stroke', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 0, 'reinfarction', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 0, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 0, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 1, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 1, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 1, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 1, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 1, 'stroke', 0.00411099111508151 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 1, 'reinfarction', 0.00930225818847608 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 1, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 1, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 2, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 2, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 2, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 2, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 2, 'stroke', 0.00722152166585632 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 2, 'reinfarction', 0.0155724760634012 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 2, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 2, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 3, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 3, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 3, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 3, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 3, 'stroke', 0.0103682020014479 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 3, 'reinfarction', 0.0336543701980913 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 3, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 3, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 4, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 4, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 4, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 4, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 4, 'stroke', 0.0135282795610878 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 4, 'reinfarction', 0.0421683732910143 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 4, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 4, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 5, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 5, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 5, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 5, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 5, 'stroke', 0.0167259160449701 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 5, 'reinfarction', 0.058374948247497 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 5, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 5, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 6, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 6, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 6, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 6, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 6, 'stroke', 0.0220901912142848 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 6, 'reinfarction', 0.071437743782604 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 6, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 6, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 7, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 7, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 7, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 7, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 7, 'stroke', 0.0253444637760861 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 7, 'reinfarction', 0.0791344855509123 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 7, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 7, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 8, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 8, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 8, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 8, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 8, 'stroke', 0.0275520631397692 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 8, 'reinfarction', 0.0970801339500622 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 8, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 8, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 9, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 9, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 9, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 9, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 9, 'stroke', 0.0286847921168732 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 9, 'reinfarction', 0.117704299895969 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 9, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 9, 'footproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 10, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 10, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 10, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 10, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 10, 'stroke', 0.0298431881725544 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 10, 'reinfarction', 0.133999531297178 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 10, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 10, 'footproblems', 0.00119260570232982 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 11, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 11, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 11, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 11, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 11, 'stroke', 0.0369505321787168 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 11, 'reinfarction', 0.15795373532222 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 11, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 11, 'footproblems', 0.0289522074092885 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 12, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 12, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 12, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 12, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 12, 'stroke', 0.0417717960155158 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 12, 'reinfarction', 0.176165986497852 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 12, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 12, 'footproblems', 0.0482518944768241 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 13, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 13, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 13, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 13, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 13, 'stroke', 0.050300153234454 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 13, 'reinfarction', 0.198363745159885 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 13, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 13, 'footproblems', 0.0567225779659949 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 14, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 14, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 14, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 14, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 14, 'stroke', 0.0565605118131888 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 14, 'reinfarction', 0.217343974569127 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 14, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 14, 'footproblems', 0.0703481458040777 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 15, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 15, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 15, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 15, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 15, 'stroke', 0.0617442321876454 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 15, 'reinfarction', 0.232918699689321 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 15, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 15, 'footproblems', 0.0818016163025821 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 16, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 16, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 16, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 16, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 16, 'stroke', 0.070988056235993 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 16, 'reinfarction', 0.251497604125431 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 16, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 16, 'footproblems', 0.0946974475324956 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 17, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 17, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 17, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 17, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 17, 'stroke', 0.070988056235993 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 17, 'reinfarction', 0.270514777568691 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 17, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 17, 'footproblems', 0.107760748105757 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 18, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 18, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 18, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 18, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 18, 'stroke', 0.0765426700945683 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 18, 'reinfarction', 0.290115872116602 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 18, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 18, 'footproblems', 0.122354668030083 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 19, 'diabetes', 1 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 19, 'blind', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 19, 'esrd', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 19, 'foot', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 19, 'stroke', 0.0822606538115245 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 19, 'reinfarction', 0.313059591309613 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 19, 'eyeproblems', 0 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 19, 'footproblems', 0.126433570037267 INSERT INTO tblOut (job_id, cat_id, year_index, outcome, outvalue) SELECT 1482, (SELECT cat_id from tblCategory where category = 'sbpLowest') as cat_id, 20, 'diabetes', 1 INSERT INTO tblOut (job_