/* Baseball */
DELETE FROM schools_officials_associations WHERE activity IN ('BBL');

INSERT INTO schools_officials_associations (school,officials_association,activity) VALUES

/* Blue Mountain Baseball */
(182,77,'BBL'),
(123,77,'BBL'),
(252,77,'BBL'),
(61,77,'BBL'),
(242,77,'BBL'),
(234,77,'BBL'),
(73,77,'BBL'),
(60,77,'BBL'),
(62,77,'BBL'),
(404,77,'BBL'),
(124,77,'BBL'),
(405,77,'BBL'),
(21,77,'BBL'),

/* Central Oregon Baseball */
(46,78,'BBL'),
(48,78,'BBL'),
(260,78,'BBL'),
(522,78,'BBL'),
(368,78,'BBL'),
(100,78,'BBL'),
(186,78,'BBL'),
(135,78,'BBL'),
(47,78,'BBL'),
(106,78,'BBL'),
(25,78,'BBL'),

/* Douglas County Baseball */
(72,79,'BBL'),
(3,79,'BBL'),
(70,79,'BBL'),
(165,79,'BBL'),
(9,79,'BBL'),
(174,79,'BBL'),
(258,79,'BBL'),
(22,79,'BBL'),
(137,79,'BBL'),
(189,79,'BBL'),

/* Klamath County Baseball */
(245,80,'BBL'),
(116,80,'BBL'),
(115,80,'BBL'),
(181,80,'BBL'),
(223,80,'BBL'),
(197,80,'BBL'),
(169,80,'BBL'),

/* Lane County Baseball */
(263,81,'BBL'),
(85,81,'BBL'),
(269,81,'BBL'),
(344,81,'BBL'),
(227,81,'BBL'),
(251,81,'BBL'),
(257,81,'BBL'),
(265,81,'BBL'),
(232,81,'BBL'),
(113,81,'BBL'),
(214,81,'BBL'),
(215,81,'BBL'),
(164,81,'BBL'),
(183,81,'BBL'),
(163,81,'BBL'),
(138,81,'BBL'),
(101,81,'BBL'),
(167,81,'BBL'),
(28,81,'BBL'),
(41,81,'BBL'),
(39,81,'BBL'),

/* Lower Columbia Baseball */
(103,117,'BBL'),
(110,117,'BBL'),

/* Malheur County Baseball */
(66,83,'BBL'),
(136,83,'BBL'),
(190,83,'BBL'),

/* Mid-Columbia Baseball */
(81,84,'BBL'),
(409,84,'BBL'),
(220,84,'BBL'),
(134,84,'BBL'),
(2,84,'BBL'),
(211,84,'BBL'),
(199,84,'BBL'),

/* Mid-Valley Baseball */
(173,85,'BBL'),
(12,85,'BBL'),
(13,85,'BBL'),
(250,85,'BBL'),
(172,85,'BBL'),
(256,85,'BBL'),
(177,85,'BBL'),
(185,85,'BBL'),
(170,85,'BBL'),
(63,85,'BBL'),
(268,85,'BBL'),
(133,85,'BBL'),
(16,85,'BBL'),
(254,85,'BBL'),
(228,85,'BBL'),
(271,85,'BBL'),
(419,85,'BBL'),
(398,85,'BBL'),

/* Northeast Oregon Baseball */
(17,86,'BBL'),
(105,86,'BBL'),
(248,86,'BBL'),
(19,86,'BBL'),
(184,86,'BBL'),
(67,86,'BBL'),
(236,86,'BBL'),
(192,86,'BBL'),
(114,86,'BBL'),
(11,86,'BBL'),

/* Northeast Oregon Satellite Baseball */
(59,87,'BBL'),
(162,87,'BBL'),

/* North Coast Baseball */
(53,88,'BBL'),
(99,88,'BBL'),
(117,88,'BBL'),
(104,88,'BBL'),
(255,88,'BBL'),

/* Portland Baseball */
(92,89,'BBL'),
(30,89,'BBL'),
(95,89,'BBL'),
(145,89,'BBL'),
(126,89,'BBL'),
(226,89,'BBL'),
(279,89,'BBL'),
(6,89,'BBL'),
(144,89,'BBL'),
(233,89,'BBL'),
(98,89,'BBL'),
(153,89,'BBL'),
(239,89,'BBL'),
(152,89,'BBL'),
(29,89,'BBL'),
(337,89,'BBL'),
(247,89,'BBL'),
(37,89,'BBL'),
(38,89,'BBL'),
(150,89,'BBL'),
(151,89,'BBL'),
(4,89,'BBL'),
(68,89,'BBL'),
(52,89,'BBL'),
(149,89,'BBL'),
(125,89,'BBL'),
(326,89,'BBL'),
(93,89,'BBL'),
(27,89,'BBL'),
(205,89,'BBL'),
(111,89,'BBL'),
(94,89,'BBL'),
(146,89,'BBL'),
(246,89,'BBL'),
(249,89,'BBL'),
(387,89,'BBL'),
(7,89,'BBL'),
(89,89,'BBL'),
(8,89,'BBL'),
(55,89,'BBL'),
(156,89,'BBL'),
(210,89,'BBL'),
(209,89,'BBL'),
(231,89,'BBL'),
(26,89,'BBL'),
(238,89,'BBL'),
(79,89,'BBL'),
(188,89,'BBL'),
(270,89,'BBL'),
(225,89,'BBL'),
(417,89,'BBL'),
(212,89,'BBL'),
(75,89,'BBL'),
(321,89,'BBL'),
(191,89,'BBL'),

/* Rogue Valley Baseball */
(224,90,'BBL'),
(51,90,'BBL'),
(50,90,'BBL'),
(222,90,'BBL'),
(204,90,'BBL'),
(154,90,'BBL'),
(34,90,'BBL'),
(33,90,'BBL'),
(178,90,'BBL'),
(78,90,'BBL'),
(35,90,'BBL'),
(118,90,'BBL'),
(349,90,'BBL'),
(240,90,'BBL'),
(208,90,'BBL'),
(77,90,'BBL'),

/* Salem Baseball */
(76,91,'BBL'),
(129,91,'BBL'),
(24,91,'BBL'),
(131,91,'BBL'),
(130,91,'BBL'),
(128,91,'BBL'),
(127,91,'BBL'),
(372,91,'BBL'),
(155,91,'BBL'),
(202,91,'BBL'),
(139,91,'BBL'),
(244,91,'BBL'),
(121,91,'BBL'),
(253,91,'BBL'),
(57,91,'BBL'),
(42,91,'BBL'),
(83,91,'BBL'),
(36,91,'BBL'),
(273,91,'BBL'),
(5,91,'BBL'),
(229,91,'BBL'),
(54,91,'BBL'),
(158,91,'BBL'),
(262,91,'BBL'),
(122,91,'BBL'),
(264,91,'BBL'),
(140,91,'BBL'),
(141,91,'BBL'),
(157,91,'BBL'),
(175,91,'BBL'),
(207,91,'BBL'),
(261,91,'BBL'),
(40,91,'BBL'),
(20,91,'BBL'),
(193,91,'BBL'),
(168,91,'BBL'),
(97,91,'BBL'),

/* Southwest Oregon Baseball */
(159,92,'BBL'),
(65,92,'BBL'),
(132,92,'BBL'),
(31,92,'BBL'),
(44,92,'BBL'),
(230,92,'BBL'),
(18,92,'BBL'),
(176,92,'BBL'),
(221,92,'BBL'),
(49,92,'BBL');


/* 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 ('BBL') AND
	CS.school = S.id AND
	CS.school_year = 2015

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


