/* Wrestling */
DELETE FROM schools_officials_associations WHERE activity IN ('WRE');

INSERT INTO schools_officials_associations (school,officials_association,activity) VALUES

/* Albany Wrestling */
(173,63,'WRE'),
(12,63,'WRE'),
(13,63,'WRE'),
(250,63,'WRE'),
(172,63,'WRE'),
(256,63,'WRE'),
(177,63,'WRE'),
(185,63,'WRE'),
(164,63,'WRE'),
(63,63,'WRE'),
(268,63,'WRE'),
(133,63,'WRE'),
(254,63,'WRE'),
(419,63,'WRE'),
(228,63,'WRE'),
(271,63,'WRE'),

/* Blue Mountain Wrestling */
(182,64,'WRE'),
(123,64,'WRE'),
(252,64,'WRE'),
(21,64,'WRE'),
(61,64,'WRE'),
(60,64,'WRE'),
(404,64,'WRE'),

/* Central Oregon Wrestling */
(46,65,'WRE'),
(48,65,'WRE'),
(260,65,'WRE'),
(522,65,'WRE'),
(368,65,'WRE'),
(100,65,'WRE'),
(186,65,'WRE'),
(135,65,'WRE'),
(59,65,'WRE'),
(47,65,'WRE'),
(96,65,'WRE'),
(106,65,'WRE'),
(237,65,'WRE'),
(25,65,'WRE'),
(107,65,'WRE'),

/* Douglas County Wrestling */
(72,66,'WRE'),
(3,66,'WRE'),
(165,66,'WRE'),
(9,66,'WRE'),
(174,66,'WRE'),
(240,66,'WRE'),
(22,66,'WRE'),
(258,66,'WRE'),

/* Klamath County Wrestling */
(245,67,'WRE'),
(116,67,'WRE'),
(115,67,'WRE'),
(181,67,'WRE'),
(223,67,'WRE'),
(198,67,'WRE'),
(169,67,'WRE'),

/* Lane County Wrestling */
(263,68,'WRE'),
(85,68,'WRE'),
(269,68,'WRE'),
(344,68,'WRE'),
(227,68,'WRE'),
(251,68,'WRE'),
(257,68,'WRE'),
(265,68,'WRE'),
(232,68,'WRE'),
(113,68,'WRE'),
(214,68,'WRE'),
(31,68,'WRE'),
(215,68,'WRE'),
(183,68,'WRE'),
(163,68,'WRE'),
(41,68,'WRE'),
(64,68,'WRE'),
(39,68,'WRE'),
(138,68,'WRE'),
(167,68,'WRE'),
(101,68,'WRE'),
(91,68,'WRE'),

/* Malheur County Wrestling */
(66,69,'WRE'),
(136,69,'WRE'),
(190,69,'WRE'),
(347,69,'WRE'),

/* Metro West Wrestling */
(92,70,'WRE'),
(95,70,'WRE'),
(76,70,'WRE'),
(279,70,'WRE'),
(98,70,'WRE'),
(239,70,'WRE'),
(125,70,'WRE'),
(326,70,'WRE'),
(93,70,'WRE'),
(27,70,'WRE'),
(205,70,'WRE'),
(94,70,'WRE'),
(210,70,'WRE'),
(246,70,'WRE'),
(387,70,'WRE'),
(53,70,'WRE'),
(209,70,'WRE'),
(79,70,'WRE'),
(99,70,'WRE'),
(188,70,'WRE'),
(103,70,'WRE'),
(110,70,'WRE'),
(117,70,'WRE'),
(104,70,'WRE'),
(255,70,'WRE'),
(191,70,'WRE'),

/* Northeast Oregon Wrestling */
(17,72,'WRE'),
(248,72,'WRE'),
(19,72,'WRE'),
(236,72,'WRE'),
(162,72,'WRE'),
(184,72,'WRE'),
(67,72,'WRE'),
(213,72,'WRE'),
(114,72,'WRE'),
(11,72,'WRE'),
(192,72,'WRE'),

/* Portland Wrestling */
(30,73,'WRE'),
(145,73,'WRE'),
(126,73,'WRE'),
(6,73,'WRE'),
(144,73,'WRE'),
(233,73,'WRE'),
(153,73,'WRE'),
(152,73,'WRE'),
(29,73,'WRE'),
(337,73,'WRE'),
(37,73,'WRE'),
(38,73,'WRE'),
(150,73,'WRE'),
(151,73,'WRE'),
(68,73,'WRE'),
(52,73,'WRE'),
(149,73,'WRE'),
(111,73,'WRE'),
(146,73,'WRE'),
(81,73,'WRE'),
(7,73,'WRE'),
(89,73,'WRE'),
(8,73,'WRE'),
(55,73,'WRE'),
(156,73,'WRE'),
(409,73,'WRE'),
(231,73,'WRE'),
(26,73,'WRE'),
(238,73,'WRE'),
(370,73,'WRE'),

/* Rogue Valley Wrestling */
(224,74,'WRE'),
(51,74,'WRE'),
(50,74,'WRE'),
(222,74,'WRE'),
(204,74,'WRE'),
(154,74,'WRE'),
(34,74,'WRE'),
(33,74,'WRE'),
(178,74,'WRE'),
(78,74,'WRE'),
(35,74,'WRE'),
(118,74,'WRE'),

/* Salem Wrestling */
(129,75,'WRE'),
(24,75,'WRE'),
(131,75,'WRE'),
(4,75,'WRE'),
(130,75,'WRE'),
(128,75,'WRE'),
(127,75,'WRE'),
(372,75,'WRE'),
(155,75,'WRE'),
(202,75,'WRE'),
(139,75,'WRE'),
(244,75,'WRE'),
(121,75,'WRE'),
(253,75,'WRE'),
(57,75,'WRE'),
(42,75,'WRE'),
(83,75,'WRE'),
(36,75,'WRE'),
(5,75,'WRE'),
(229,75,'WRE'),
(54,75,'WRE'),
(158,75,'WRE'),
(170,75,'WRE'),
(122,75,'WRE'),
(264,75,'WRE'),
(140,75,'WRE'),
(207,75,'WRE'),
(97,75,'WRE'),
(40,75,'WRE'),

/* Southwest Oregon Wrestling */
(159,76,'WRE'),
(65,76,'WRE'),
(132,76,'WRE'),
(412,76,'WRE'),
(230,76,'WRE'),
(18,76,'WRE'),
(176,76,'WRE'),
(221,76,'WRE'),
(49,76,'WRE');


/* Get confirmation of the entries */
SELECT 
	DISTINCT(S.short_name),
	CS.classification,
	OA.short_name

FROM
	schools AS S,
	officials_associations AS OA,
	schools_officials_associations AS SOA,
	classification_schools AS CS

WHERE
	SOA.school = S.id AND
	SOA.officials_association = OA.id AND
	SOA.activity IN ('WRE') AND
	CS.school = S.id AND
	CS.school_year = 2015

ORDER BY
	OA.short_name,
	CS.classification DESC,
	S.short_name


