/* Football */
DELETE FROM schools_officials_associations WHERE activity = 'FBL';

INSERT INTO schools_officials_associations (school,officials_association,activity) VALUES

/* Blue Mountain Football */
(182,1,'FBL'),
(123,1,'FBL'),
(405,1,'FBL'),
(252,1,'FBL'),
(61,1,'FBL'),
(73,1,'FBL'),
(60,1,'FBL'),
(404,1,'FBL'),
(124,1,'FBL'),
(242,1,'FBL'),
(21,1,'FBL'),
(234,1,'FBL'),
(62,1,'FBL'),
(102,1,'FBL'),
(32,1,'FBL'),
(272,1,'FBL'),

/* Central Oregon Football */
(46,2,'FBL'),
(48,2,'FBL'),
(260,2,'FBL'),
(522,2,'FBL'),
(368,2,'FBL'),
(100,2,'FBL'),
(186,2,'FBL'),
(135,2,'FBL'),
(47,2,'FBL'),
(106,2,'FBL'),
(59,2,'FBL'),
(96,2,'FBL'),
(237,2,'FBL'),
(25,2,'FBL'),
(32,2,'FBL'),

/* Douglas County Football */
(72,3,'FBL'),
(3,3,'FBL'),
(165,3,'FBL'),
(9,3,'FBL'),
(174,3,'FBL'),
(258,3,'FBL'),
(22,3,'FBL'),
(70,3,'FBL'),
(137,3,'FBL'),

/* Klamath Falls Football */
(245,4,'FBL'),
(116,4,'FBL'),
(115,4,'FBL'),
(181,4,'FBL'),
(223,4,'FBL'),
(197,4,'FBL'),
(198,4,'FBL'),
(169,4,'FBL'),
(282,4,'FBL'),

/* Lane County Football */
(263,5,'FBL'),
(85,5,'FBL'),
(269,5,'FBL'),
(344,5,'FBL'),
(227,5,'FBL'),
(251,5,'FBL'),
(257,5,'FBL'),
(265,5,'FBL'),
(232,5,'FBL'),
(113,5,'FBL'),
(214,5,'FBL'),
(31,5,'FBL'),
(215,5,'FBL'),
(164,5,'FBL'),
(183,5,'FBL'),
(163,5,'FBL'),
(101,5,'FBL'),
(167,5,'FBL'),
(28,5,'FBL'),
(41,5,'FBL'),
(44,5,'FBL'),
(64,5,'FBL'),
(39,5,'FBL'),
(138,5,'FBL'),
(91,5,'FBL'),

/* Lower Columbia Football */
(53,6,'FBL'),
(99,6,'FBL'),
(103,6,'FBL'),
(110,6,'FBL'),
(117,6,'FBL'),
(104,6,'FBL'),

/* Malheur County Football */
(66,7,'FBL'),
(136,7,'FBL'),
(190,7,'FBL'),
(347,7,'FBL'),
(179,7,'FBL'),
(243,7,'FBL'),
(171,7,'FBL'),

/* Mid-Columbia County Football */
(409,8,'FBL'),
(81,8,'FBL'),
(211,8,'FBL'),
(199,8,'FBL'),
(220,8,'FBL'),
(2,8,'FBL'),
(134,8,'FBL'),

/* Midwestern Football */
(173,9,'FBL'),
(12,9,'FBL'),
(13,9,'FBL'),
(250,9,'FBL'),
(172,9,'FBL'),
(256,9,'FBL'),
(177,9,'FBL'),
(185,9,'FBL'),
(170,9,'FBL'),
(63,9,'FBL'),
(268,9,'FBL'),
(133,9,'FBL'),
(254,9,'FBL'),
(207,9,'FBL'),
(228,9,'FBL'),
(271,9,'FBL'),
(200,9,'FBL'),
(80,9,'FBL'),
(419,9,'FBL'),

/* Northeast Oregon Football */
(17,11,'FBL'),
(248,11,'FBL'),
(162,11,'FBL'),
(11,11,'FBL'),
(19,11,'FBL'),
(236,11,'FBL'),
(184,11,'FBL'),
(114,11,'FBL'),
(69,11,'FBL'),
(67,11,'FBL'),
(74,11,'FBL'),
(180,11,'FBL'),
(213,11,'FBL'),
(105,11,'FBL'),
(107,11,'FBL'),
(192,11,'FBL'),

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

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

/* Salem Football */
(129,14,'FBL'),
(24,14,'FBL'),
(131,14,'FBL'),
(4,14,'FBL'),
(130,14,'FBL'),
(128,14,'FBL'),
(127,14,'FBL'),
(372,14,'FBL'),
(155,14,'FBL'),
(202,14,'FBL'),
(139,14,'FBL'),
(244,14,'FBL'),
(121,14,'FBL'),
(253,14,'FBL'),
(57,14,'FBL'),
(42,14,'FBL'),
(83,14,'FBL'),
(36,14,'FBL'),
(5,14,'FBL'),
(229,14,'FBL'),
(54,14,'FBL'),
(158,14,'FBL'),
(262,14,'FBL'),
(195,14,'FBL'),
(264,14,'FBL'),
(273,14,'FBL'),
(140,14,'FBL'),
(175,14,'FBL'),
(255,14,'FBL'),
(97,14,'FBL'),
(261,14,'FBL'),
(40,14,'FBL'),
(122,14,'FBL'),
(20,14,'FBL'),
(216,14,'FBL'),

/* Southwest Oregon Football */
(159,15,'FBL'),
(65,15,'FBL'),
(132,15,'FBL'),
(412,15,'FBL'),
(230,15,'FBL'),
(221,15,'FBL'),
(18,15,'FBL'),
(71,15,'FBL'),
(176,15,'FBL'),
(49,15,'FBL'),
(218,15,'FBL');

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

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


