/* Volleyball */
DELETE FROM schools_officials_associations WHERE activity = 'VBL';

INSERT INTO schools_officials_associations (school,officials_association,activity) VALUES

/* Blue Mountain Volleyball */
(182,16,'VBL'),
(123,16,'VBL'),
(405,16,'VBL'),
(252,16,'VBL'),
(61,16,'VBL'),
(73,16,'VBL'),
(60,16,'VBL'),
(404,16,'VBL'),
(124,16,'VBL'),
(242,16,'VBL'),
(21,16,'VBL'),
(234,16,'VBL'),
(62,16,'VBL'),
(102,16,'VBL'),
(241,16,'VBL'),
(330,16,'VBL'),

/* Central Oregon Volleyball */
(46,17,'VBL'),
(48,17,'VBL'),
(260,17,'VBL'),
(522,17,'VBL'),
(368,17,'VBL'),
(100,17,'VBL'),
(186,17,'VBL'),
(135,17,'VBL'),
(47,17,'VBL'),
(106,17,'VBL'),
(142,17,'VBL'),
(237,17,'VBL'),
(32,17,'VBL'),
(25,17,'VBL'),
(432,17,'VBL'),

/* Douglas County Volleyball */
(72,18,'VBL'),
(3,18,'VBL'),
(165,18,'VBL'),
(9,18,'VBL'),
(174,18,'VBL'),
(201,18,'VBL'),
(120,18,'VBL'),
(258,18,'VBL'),
(22,18,'VBL'),
(70,18,'VBL'),
(137,18,'VBL'),
(28,18,'VBL'),
(240,18,'VBL'),
(138,18,'VBL'),
(189,18,'VBL'),

/* Emerald Empire Volleyball */
(263,19,'VBL'),
(85,19,'VBL'),
(269,19,'VBL'),
(344,19,'VBL'),
(227,19,'VBL'),
(251,19,'VBL'),
(257,19,'VBL'),
(265,19,'VBL'),
(232,19,'VBL'),
(113,19,'VBL'),
(214,19,'VBL'),
(31,19,'VBL'),
(215,19,'VBL'),
(164,19,'VBL'),
(183,19,'VBL'),
(163,19,'VBL'),
(254,19,'VBL'),
(101,19,'VBL'),
(338,19,'VBL'),
(41,19,'VBL'),
(44,19,'VBL'),
(64,19,'VBL'),
(39,19,'VBL'),
(91,19,'VBL'),
(167,19,'VBL'),

/* Greater Portland Volleyball */
(92,20,'VBL'),
(30,20,'VBL'),
(95,20,'VBL'),
(145,20,'VBL'),
(76,20,'VBL'),
(126,20,'VBL'),
(226,20,'VBL'),
(279,20,'VBL'),
(6,20,'VBL'),
(144,20,'VBL'),
(233,20,'VBL'),
(98,20,'VBL'),
(153,20,'VBL'),
(239,20,'VBL'),
(152,20,'VBL'),
(29,20,'VBL'),
(337,20,'VBL'),
(247,20,'VBL'),
(37,20,'VBL'),
(38,20,'VBL'),
(150,20,'VBL'),
(151,20,'VBL'),
(24,20,'VBL'),
(4,20,'VBL'),
(68,20,'VBL'),
(52,20,'VBL'),
(149,20,'VBL'),
(125,20,'VBL'),
(326,20,'VBL'),
(266,20,'VBL'),
(93,20,'VBL'),
(27,20,'VBL'),
(205,20,'VBL'),
(111,20,'VBL'),
(94,20,'VBL'),
(146,20,'VBL'),
(246,20,'VBL'),
(249,20,'VBL'),
(387,20,'VBL'),
(7,20,'VBL'),
(89,20,'VBL'),
(8,20,'VBL'),
(55,20,'VBL'),
(156,20,'VBL'),
(210,20,'VBL'),
(209,20,'VBL'),
(26,20,'VBL'),
(238,20,'VBL'),
(231,20,'VBL'),
(57,20,'VBL'),
(79,20,'VBL'),
(188,20,'VBL'),
(270,20,'VBL'),
(225,20,'VBL'),
(54,20,'VBL'),
(370,20,'VBL'),
(417,20,'VBL'),
(108,20,'VBL'),
(119,20,'VBL'),
(212,20,'VBL'),
(277,20,'VBL'),
(194,20,'VBL'),
(23,20,'VBL'),
(321,20,'VBL'),
(157,20,'VBL'),
(338,20,'VBL'),
(191,20,'VBL'),
(75,20,'VBL'),
(112,20,'VBL'),
(90,20,'VBL'),
(366,20,'VBL'),
(356,20,'VBL'),
(339,20,'VBL'),

/* Klamath County Volleyball */
(245,21,'VBL'),
(116,21,'VBL'),
(115,21,'VBL'),
(181,21,'VBL'),
(223,21,'VBL'),
(197,21,'VBL'),
(198,21,'VBL'),
(169,21,'VBL'),
(259,21,'VBL'),
(282,21,'VBL'),

/* Southwest Lower Columbia Volleyball */
(103,29,'VBL'),
(110,29,'VBL'),

/* Malheur County Volleyball */
(66,22,'VBL'),
(136,22,'VBL'),
(190,22,'VBL'),
(59,22,'VBL'),
(347,22,'VBL'),
(179,22,'VBL'),
(243,22,'VBL'),
(171,22,'VBL'),

/* Mid-Columbia County Volleyball */
(81,23,'VBL'),
(409,23,'VBL'),
(211,23,'VBL'),
(199,23,'VBL'),
(220,23,'VBL'),
(196,23,'VBL'),
(2,23,'VBL'),
(134,23,'VBL'),
(272,23,'VBL'),

/* Mid-Valley Volleyball */
(173,24,'VBL'),
(12,24,'VBL'),
(13,24,'VBL'),
(250,24,'VBL'),
(172,24,'VBL'),
(256,24,'VBL'),
(177,24,'VBL'),
(185,24,'VBL'),
(170,24,'VBL'),
(63,24,'VBL'),
(268,24,'VBL'),
(133,24,'VBL'),
(16,24,'VBL'),
(228,24,'VBL'),
(271,24,'VBL'),
(200,24,'VBL'),
(398,24,'VBL'),
(419,24,'VBL'),

/* Northeast Oregon Volleyball */
(17,26,'VBL'),
(248,26,'VBL'),
(11,26,'VBL'),
(19,26,'VBL'),
(236,26,'VBL'),
(184,26,'VBL'),
(114,26,'VBL'),
(67,26,'VBL'),
(213,26,'VBL'),
(105,26,'VBL'),
(192,26,'VBL'),

/* North Coast Volleyball */
(53,25,'VBL'),
(99,25,'VBL'),
(117,25,'VBL'),
(104,25,'VBL'),
(255,25,'VBL'),
(15,25,'VBL'),

/* Salem Volleyball */
(129,27,'VBL'),
(131,27,'VBL'),
(130,27,'VBL'),
(128,27,'VBL'),
(127,27,'VBL'),
(372,27,'VBL'),
(155,27,'VBL'),
(202,27,'VBL'),
(139,27,'VBL'),
(244,27,'VBL'),
(121,27,'VBL'),
(253,27,'VBL'),
(42,27,'VBL'),
(83,27,'VBL'),
(36,27,'VBL'),
(273,27,'VBL'),
(5,27,'VBL'),
(229,27,'VBL'),
(158,27,'VBL'),
(262,27,'VBL'),
(122,27,'VBL'),
(264,27,'VBL'),
(140,27,'VBL'),
(141,27,'VBL'),
(175,27,'VBL'),
(207,27,'VBL'),
(261,27,'VBL'),
(40,27,'VBL'),
(20,27,'VBL'),
(193,27,'VBL'),
(168,27,'VBL'),
(441,27,'VBL'),
(287,27,'VBL'),
(80,27,'VBL'),
(216,27,'VBL'),
(97,27,'VBL'),
(195,27,'VBL'),
(376,27,'VBL'),

/* Southern Oregon Volleyball */
(51,28,'VBL'),
(50,28,'VBL'),
(222,28,'VBL'),
(204,28,'VBL'),
(154,28,'VBL'),
(178,28,'VBL'),
(78,28,'VBL'),
(349,28,'VBL'),
(77,28,'VBL'),
(208,28,'VBL'),
(408,28,'VBL'),

/* Southwest Oregon Volleyball */
(159,30,'VBL'),
(65,30,'VBL'),
(132,30,'VBL'),
(230,30,'VBL'),
(18,30,'VBL'),
(176,30,'VBL'),
(49,30,'VBL'),
(221,30,'VBL'),
(71,30,'VBL'),
(218,30,'VBL'),

/* Three Rivers Volleyball */
(224,31,'VBL'),
(34,31,'VBL'),
(33,31,'VBL'),
(35,31,'VBL'),
(118,31,'VBL'),
(88,31,'VBL'),

/* Tri-County Volleyball */
(162,32,'VBL'),
(69,32,'VBL'),
(96,32,'VBL'),
(180,32,'VBL'),
(109,32,'VBL'),
(74,32,'VBL'),
(107,32,'VBL');


/* Get confirmation of the entries */
SELECT 
	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 = 'VBL' AND
	CS.school = S.id AND
	CS.school_year = 2015

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


