/* Softball */
DELETE FROM schools_officials_associations WHERE activity IN ('SBL');

INSERT INTO schools_officials_associations (school,officials_association,activity) VALUES

/* Blue Mountain Softball */
(182,93,'SBL'),
(123,93,'SBL'),
(252,93,'SBL'),
(61,93,'SBL'),
(242,93,'SBL'),
(234,93,'SBL'),
(73,93,'SBL'),
(21,93,'SBL'),
(241,93,'SBL'),
(60,93,'SBL'),
(62,93,'SBL'),
(404,93,'SBL'),
(124,93,'SBL'),
(405,93,'SBL'),

/* Central Oregon Softball */
(46,94,'SBL'),
(48,94,'SBL'),
(260,94,'SBL'),
(522,94,'SBL'),
(368,94,'SBL'),
(100,94,'SBL'),
(186,94,'SBL'),
(135,94,'SBL'),
(47,94,'SBL'),
(106,94,'SBL'),

/* Douglas County Softball */
(72,95,'SBL'),
(3,95,'SBL'),
(70,95,'SBL'),
(165,95,'SBL'),
(9,95,'SBL'),
(174,95,'SBL'),
(258,95,'SBL'),
(22,95,'SBL'),
(137,95,'SBL'),
(189,95,'SBL'),

/* Klamath County Softball */
(245,96,'SBL'),
(115,96,'SBL'),
(181,96,'SBL'),
(223,96,'SBL'),
(197,96,'SBL'),
(198,96,'SBL'),

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

/* Lower Columbia Softball */
(103,118,'SBL'),
(110,118,'SBL'),

/* Malheur County Softball */
(66,99,'SBL'),
(136,99,'SBL'),
(190,99,'SBL'),
(347,99,'SBL'),

/* Mid-Columbia Softball */
(81,100,'SBL'),
(409,100,'SBL'),
(220,100,'SBL'),

/* Mid-Valley Softball */
(173,101,'SBL'),
(12,101,'SBL'),
(13,101,'SBL'),
(250,101,'SBL'),
(172,101,'SBL'),
(256,101,'SBL'),
(177,101,'SBL'),
(185,101,'SBL'),
(170,101,'SBL'),
(63,101,'SBL'),
(268,101,'SBL'),
(133,101,'SBL'),
(254,101,'SBL'),
(228,101,'SBL'),
(271,101,'SBL'),
(398,101,'SBL'),

/* Northeast Oregon Softball */
(17,102,'SBL'),
(105,102,'SBL'),
(248,102,'SBL'),
(59,102,'SBL'),
(19,102,'SBL'),
(184,102,'SBL'),
(236,102,'SBL'),
(67,102,'SBL'),
(162,102,'SBL'),
(114,102,'SBL'),
(11,102,'SBL'),
(213,102,'SBL'),
(192,102,'SBL'),

/* North Coast Softball */
(53,103,'SBL'),
(99,103,'SBL'),
(117,103,'SBL'),
(104,103,'SBL'),
(255,103,'SBL'),

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

/* Rogue Valley Softball */
(51,105,'SBL'),
(50,105,'SBL'),
(222,105,'SBL'),
(204,105,'SBL'),
(154,105,'SBL'),
(178,105,'SBL'),
(78,105,'SBL'),
(77,105,'SBL'),
(208,105,'SBL'),

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

/* Southwest Oregon Softball */
(159,107,'SBL'),
(65,107,'SBL'),
(132,107,'SBL'),
(31,107,'SBL'),
(44,107,'SBL'),
(230,107,'SBL'),
(18,107,'SBL'),
(71,107,'SBL'),
(176,107,'SBL'),
(49,107,'SBL'),
(221,107,'SBL'),

/* Three Rivers Softball */
(224,108,'SBL'),
(34,108,'SBL'),
(33,108,'SBL'),
(35,108,'SBL'),
(118,108,'SBL'),
(240,108,'SBL');


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

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


