gistfile1.py

import os
import random

# INSERT INTO `dataset_album` (`pic_id`, `pic_cat_id`) VALUES
dataset_album = [
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(7, 3),
(8, 3),
(9, 3),
(10, 3),
(11, 3),
(21, 3),
(13, 3),
(14, 3),
(15, 3),
(16, 3),
(17, 3),
(22, 3),
(23, 3),
(24, 3),
(25, 3),
(26, 3),
(27, 3),
(28, 3),
(29, 3),
(30, 3),
(31, 3),
(32, 3),
(33, 3),
(34, 3),
(35, 3),
(36, 3),
(37, 3),
(38, 3),
(39, 3),
(40, 3),
(41, 3),
(42, 3),
(43, 3),
(44, 3),
(45, 3),
(46, 3),
(47, 3),
(48, 3),
(49, 3),
(50, 3),
(51, 3),
(52, 3),
(53, 3),
(54, 3),
(55, 3),
(56, 3),
(57, 3),
(58, 3),
(59, 3),
(60, 3),
(61, 3),
(63, 3),
(64, 3),
(65, 3),
(66, 3),
(67, 16),
(68, 16),
(69, 16),
(70, 16),
(71, 11),
(72, 7),
(73, 7),
(74, 7),
(75, 7),
(76, 7),
(77, 7),
(78, 7),
(79, 7),
(80, 7),
(81, 7),
(82, 7),
(83, 7),
(84, 7),
(85, 7),
(86, 7),
(87, 7),
(88, 7),
(89, 7),
(90, 16),
(91, 16),
(93, 29),
(94, 29),
(95, 29),
(99, 29),
(97, 29),
(98, 29),
(100, 29),
(101, 29),
(102, 29),
(103, 29),
(104, 29),
(105, 29),
(106, 29),
(107, 29),
(108, 29),
(109, 29),
(110, 29),
(111, 29),
(112, 29),
(113, 29),
(114, 29),
(115, 29),
(116, 29),
(117, 29),
(118, 29),
(119, 29),
(122, 29),
(123, 29),
(124, 29),
(125, 29),
(126, 29),
(127, 29),
(128, 29),
(129, 29),
(130, 29),
(131, 29),
(132, 29),
(133, 29),
(134, 29),
(135, 29),
(136, 29),
(137, 29),
(138, 16),
(139, 16),
(141, 14),
(142, 14),
(143, 14),
(144, 14),
(145, 16),
(146, 16),
(147, 16),
(148, 16),
(149, 13),
(150, 13),
(151, 13),
(152, 13),
(153, 13),
(154, 13),
(155, 13),
(156, 13),
(157, 13),
(158, 13),
(159, 13),
(160, 13),
(161, 13),
(162, 13),
(163, 13),
(164, 13),
(165, 13),
(166, 13),
(167, 16),
(168, 16),
(169, 16),
(170, 16),
(171, 16),
(190, 13),
(191, 35),
(192, 35),
(193, 35),
(194, 35),
(195, 35),
(196, 35),
(197, 35),
(198, 35),
(199, 35),
(200, 35),
(201, 35),
(202, 35),
(203, 35),
(204, 35),
(205, 35),
(206, 35),
(207, 35),
(208, 35),
(209, 35),
(210, 35),
(211, 35),
(212, 35),
(213, 35),
(214, 35),
(215, 35),
(216, 35),
(217, 35),
(219, 35),
(220, 35),
(221, 35),
(222, 35),
(223, 14),
(224, 14),
(225, 14),
(226, 14),
(227, 14),
(229, 14),
(230, 14),
(231, 14),
(232, 14),
(233, 14),
(234, 14),
(235, 14),
(236, 14),
(237, 36),
(238, 36),
(239, 36),
(240, 36),
(241, 36),
(242, 36),
(243, 36),
(244, 36),
(245, 36),
(246, 36),
(247, 36),
(248, 36),
(249, 36),
(250, 36),
(251, 1),
(252, 1),
(253, 35),
(254, 35),
(255, 35),
(256, 35),
(257, 35),
(258, 14),
(259, 14),
(260, 14),
(261, 14),
(262, 14),
(263, 14),
(264, 15),
(265, 15),
(266, 6),
(268, 6),
(269, 36),
(271, 2),
(272, 2),
(273, 2),
(274, 39),
(275, 39),
(282, 36),
(277, 17),
(278, 17),
(279, 17),
(280, 17),
(281, 17),
(283, 16),
(284, 16),
(285, 21),
(286, 21),
(287, 21),
(288, 21),
(289, 21),
(290, 21),
(291, 21),
(292, 21),
(293, 21),
(294, 21),
(295, 21),
(296, 21),
(297, 36),
(298, 6),
(299, 36),
(300, 36),
(301, 16),
(302, 16),
(303, 14),
(304, 14),
(305, 14),
(306, 14),
(307, 14),
(1886, 88),
(316, 54),
(310, 54),
(311, 54),
(312, 54),
(313, 54),
(314, 54),
(315, 54),
(317, 56),
(318, 56),
(319, 13),
(320, 13),
(321, 13),
(322, 13),
(323, 16),
(324, 32),
(325, 32),
(328, 32),
(327, 32),
(329, 32),
(330, 32),
(331, 32),
(332, 32),
(333, 32),
(334, 32),
(335, 32),
(336, 32),
(337, 32),
(338, 16),
(339, 16),
(340, 16),
(341, 16),
(343, 16),
(344, 16),
(346, 32),
(347, 32),
(348, 32),
(349, 32),
(350, 32),
(351, 32),
(352, 32),
(353, 32),
(354, 32),
(355, 32),
(356, 32),
(357, 32),
(358, 32),
(359, 32),
(360, 32),
(361, 32),
(362, 32),
(363, 32),
(364, 32),
(365, 32),
(366, 32),
(368, 32),
(369, 32),
(370, 32),
(371, 32),
(372, 32),
(373, 32),
(374, 32),
(375, 32),
(376, 32),
(377, 32),
(378, 32),
(379, 32),
(380, 32),
(381, 32),
(382, 32),
(383, 32),
(384, 32),
(385, 32),
(386, 32),
(387, 32),
(388, 32),
(389, 32),
(390, 32),
(391, 32),
(392, 32),
(393, 32),
(394, 32),
(395, 32),
(396, 32),
(397, 32),
(398, 32),
(399, 32),
(400, 32),
(401, 32),
(403, 32),
(404, 32),
(405, 32),
(406, 32),
(407, 32),
(408, 32),
(409, 32),
(410, 32),
(411, 32),
(412, 32),
(413, 32),
(414, 32),
(415, 32),
(429, 32),
(430, 32),
(417, 32),
(418, 32),
(419, 54),
(420, 56),
(421, 56),
(422, 36),
(423, 36),
(424, 36),
(425, 32),
(426, 32),
(427, 32),
(428, 32),
(431, 32),
(432, 32),
(435, 57),
(434, 57),
(436, 1),
(437, 1),
(438, 14),
(439, 14),
(440, 14),
(441, 14),
(442, 14),
(443, 14),
(444, 14),
(445, 14),
(446, 36),
(447, 36),
(448, 36),
(449, 54),
(450, 54),
(451, 62),
(452, 16),
(453, 62),
(454, 62),
(455, 62),
(456, 62),
(457, 62),
(458, 12),
(459, 12),
(460, 12),
(462, 12),
(463, 12),
(464, 12),
(465, 12),
(466, 36),
(467, 36),
(469, 12),
(471, 12),
(472, 12),
(474, 12),
(475, 12),
(477, 36),
(478, 20),
(479, 20),
(480, 16),
(481, 16),
(482, 16),
(483, 16),
(484, 16),
(485, 36),
(486, 43),
(487, 43),
(497, 43),
(498, 43),
(490, 43),
(491, 43),
(492, 43),
(493, 43),
(494, 43),
(495, 43),
(499, 43),
(522, 101),
(513, 101),
(514, 101),
(523, 101),
(503, 6),
(504, 6),
(505, 6),
(507, 1),
(508, 1),
(509, 1),
(510, 1),
(511, 101),
(512, 101),
(517, 101),
(518, 101),
(519, 101),
(521, 101),
(524, 101),
(525, 12),
(526, 12),
(528, 12),
(529, 12),
(530, 12),
(531, 16),
(532, 16),
(533, 36),
(534, 36),
(537, 13),
(536, 13),
(538, 13),
(539, 13),
(540, 13),
(541, 13),
(542, 13),
(543, 13),
(544, 13),
(545, 13),
(546, 13),
(547, 33),
(548, 2),
(549, 2),
(550, 2),
(551, 2),
(552, 2),
(553, 2),
(554, 2),
(555, 53),
(556, 53),
(557, 53),
(558, 53),
(559, 53),
(560, 53),
(561, 53),
(562, 53),
(563, 53),
(564, 53),
(565, 53),
(566, 53),
(567, 53),
(568, 53),
(569, 53),
(570, 53),
(571, 53),
(574, 53),
(573, 53),
(575, 53),
(576, 53),
(578, 53),
(579, 53),
(580, 53),
(581, 53),
(582, 53),
(583, 53),
(584, 53),
(585, 53),
(586, 53),
(588, 53),
(589, 21),
(590, 33),
(591, 53),
(592, 53),
(593, 53),
(594, 53),
(595, 53),
(596, 53),
(597, 53),
(598, 53),
(599, 53),
(600, 53),
(601, 53),
(602, 53),
(603, 53),
(604, 53),
(605, 53),
(606, 53),
(607, 53),
(608, 53),
(609, 53),
(610, 53),
(611, 53),
(612, 53),
(613, 53),
(614, 53),
(615, 53),
(616, 53),
(617, 53),
(618, 53),
(619, 53),
(620, 53),
(621, 53),
(622, 53),
(623, 53),
(624, 53),
(625, 53),
(626, 53),
(627, 53),
(628, 53),
(629, 53),
(630, 53),
(631, 53),
(632, 53),
(633, 53),
(634, 53),
(635, 53),
(636, 53),
(637, 53),
(638, 53),
(639, 53),
(640, 15),
(641, 14),
(642, 14),
(643, 2),
(644, 53),
(645, 53),
(646, 53),
(647, 53),
(648, 53),
(649, 53),
(650, 53),
(651, 53),
(652, 53),
(653, 53),
(654, 53),
(655, 53),
(656, 53),
(657, 53),
(658, 53),
(659, 53),
(660, 53),
(661, 53),
(662, 53),
(663, 53),
(664, 53),
(665, 53),
(666, 53),
(667, 53),
(668, 53),
(669, 53),
(670, 53),
(671, 53),
(672, 53),
(673, 53),
(674, 53),
(675, 53),
(676, 53),
(677, 53),
(678, 53),
(679, 53),
(680, 53),
(681, 53),
(682, 53),
(683, 53),
(684, 36),
(685, 21),
(686, 21),
(687, 21),
(688, 21),
(689, 21),
(690, 21),
(691, 21),
(692, 21),
(693, 21),
(694, 21),
(695, 36),
(696, 71),
(697, 71),
(698, 71),
(699, 71),
(700, 71),
(701, 71),
(702, 71),
(703, 71),
(704, 71),
(705, 71),
(706, 71),
(707, 71),
(708, 71),
(709, 71),
(710, 57),
(711, 57),
(712, 16),
(713, 16),
(714, 16),
(715, 16),
(716, 16),
(717, 16),
(726, 14),
(719, 14),
(720, 14),
(721, 14),
(722, 14),
(724, 14),
(725, 14),
(727, 14),
(728, 14),
(729, 14),
(730, 14),
(731, 14),
(732, 14),
(733, 14),
(734, 14),
(735, 14),
(736, 14),
(737, 14),
(738, 14),
(739, 14),
(740, 14),
(741, 14),
(742, 14),
(743, 14),
(744, 14),
(745, 14),
(746, 14),
(747, 14),
(748, 14),
(749, 14),
(750, 14),
(751, 14),
(752, 14),
(753, 14),
(754, 14),
(755, 14),
(756, 14),
(757, 14),
(759, 69),
(760, 69),
(761, 69),
(762, 69),
(763, 69),
(764, 69),
(765, 69),
(766, 69),
(767, 69),
(768, 69),
(769, 69),
(770, 69),
(771, 69),
(772, 69),
(773, 69),
(774, 69),
(775, 69),
(776, 69),
(777, 69),
(778, 69),
(779, 69),
(780, 69),
(781, 69),
(782, 69),
(783, 69),
(784, 69),
(785, 69),
(786, 69),
(787, 69),
(788, 69),
(789, 69),
(790, 69),
(791, 69),
(792, 69),
(793, 69),
(794, 69),
(795, 69),
(796, 69),
(797, 69),
(798, 69),
(799, 69),
(800, 69),
(801, 69),
(802, 69),
(803, 21),
(804, 21),
(805, 21),
(806, 21),
(807, 21),
(808, 21),
(809, 21),
(810, 21),
(811, 21),
(812, 21),
(813, 21),
(814, 21),
(815, 21),
(816, 21),
(817, 21),
(820, 21),
(822, 21),
(823, 69),
(824, 69),
(825, 69),
(826, 69),
(827, 69),
(828, 69),
(829, 69),
(830, 69),
(831, 69),
(832, 69),
(833, 69),
(834, 69),
(835, 36),
(836, 75),
(837, 75),
(838, 36),
(839, 57),
(840, 80),
(853, 16),
(854, 16),
(855, 86),
(856, 16),
(857, 16),
(858, 16),
(859, 16),
(860, 36),
(861, 36),
(862, 36),
(863, 36),
(865, 36),
(866, 36),
(867, 57),
(868, 62),
(869, 80),
(870, 122),
(871, 36),
(872, 33),
(873, 33),
(874, 33),
(875, 33),
(876, 11),
(877, 11),
(878, 11),
(879, 33),
(880, 127),
(881, 127),
(882, 127),
(883, 127),
(884, 127),
(885, 127),
(886, 127),
(887, 127),
(888, 127),
(889, 127),
(890, 127),
(891, 127),
(892, 127),
(893, 127),
(894, 127),
(895, 127),
(896, 127),
(897, 127),
(898, 127),
(899, 127),
(900, 127),
(901, 127),
(902, 127),
(903, 123),
(904, 126),
(905, 57),
(906, 57),
(907, 18),
(908, 18),
(909, 18),
(910, 18),
(911, 18),
(912, 18),
(1888, 182),
(914, 18),
(915, 18),
(916, 18),
(917, 18),
(918, 18),
(919, 18),
(920, 18),
(921, 18),
(922, 36),
(923, 36),
(924, 36),
(925, 82),
(926, 82),
(927, 82),
(928, 82),
(929, 82),
(930, 82),
(942, 82),
(932, 82),
(933, 82),
(934, 82),
(935, 82),
(936, 82),
(937, 82),
(938, 82),
(939, 82),
(940, 82),
(941, 82),
(943, 82),
(944, 82),
(945, 82),
(946, 82),
(947, 82),
(948, 82),
(949, 82),
(950, 82),
(951, 82),
(952, 82),
(953, 82),
(954, 82),
(955, 82),
(956, 82),
(957, 82),
(958, 82),
(959, 82),
(960, 82),
(961, 82),
(962, 82),
(963, 82),
(964, 82),
(965, 82),
(966, 82),
(967, 82),
(968, 82),
(969, 82),
(970, 82),
(971, 82),
(972, 82),
(973, 82),
(974, 82),
(978, 82),
(979, 82),
(977, 82),
(980, 82),
(981, 82),
(982, 82),
(983, 82),
(984, 82),
(985, 82),
(986, 82),
(987, 82),
(988, 82),
(989, 82),
(990, 82),
(998, 82),
(992, 82),
(993, 82),
(994, 82),
(995, 82),
(996, 82),
(997, 82),
(999, 82),
(1000, 82),
(1001, 82),
(1002, 82),
(1003, 82),
(1004, 82),
(1005, 82),
(1006, 82),
(1007, 82),
(1008, 82),
(1009, 82),
(1010, 82),
(1011, 82),
(1012, 82),
(1013, 82),
(1014, 82),
(1015, 82),
(1016, 82),
(1017, 82),
(1018, 82),
(1019, 82),
(1020, 82),
(1021, 82),
(1022, 82),
(1023, 82),
(1024, 82),
(1025, 82),
(1026, 82),
(1027, 82),
(1028, 82),
(1029, 82),
(1030, 82),
(1031, 82),
(1032, 82),
(1033, 82),
(1034, 82),
(1035, 82),
(1036, 82),
(1037, 82),
(1038, 82),
(1039, 82),
(1040, 82),
(1041, 82),
(1042, 82),
(1043, 82),
(1044, 82),
(1045, 82),
(1046, 82),
(1047, 82),
(1048, 82),
(1049, 82),
(1050, 82),
(1051, 82),
(1052, 82),
(1076, 82),
(1059, 82),
(1060, 82),
(1061, 82),
(1062, 82),
(1063, 82),
(1064, 82),
(1065, 82),
(1066, 82),
(1067, 82),
(1068, 82),
(1069, 82),
(1070, 82),
(1077, 82),
(1078, 82),
(1079, 82),
(1080, 82),
(1081, 82),
(1082, 36),
(1083, 36),
(1084, 36),
(1085, 27),
(1086, 27),
(1087, 27),
(1088, 27),
(1089, 27),
(1090, 27),
(1091, 27),
(1092, 132),
(1093, 36),
(1094, 36),
(1095, 36),
(1096, 36),
(1097, 36),
(1098, 14),
(1099, 14),
(1100, 14),
(1101, 14),
(1102, 14),
(1120, 14),
(1104, 14),
(1105, 14),
(1106, 14),
(1107, 14),
(1108, 14),
(1109, 14),
(1110, 14),
(1111, 14),
(1112, 14),
(1113, 14),
(1114, 14),
(1115, 14),
(1116, 14),
(1117, 14),
(1118, 14),
(1119, 14),
(1121, 36),
(1122, 36),
(1123, 36),
(1124, 36),
(1125, 132),
(1126, 36),
(1127, 36),
(1128, 57),
(1129, 57),
(1130, 57),
(1131, 132),
(1132, 132),
(1135, 132),
(1136, 132),
(1137, 132),
(1138, 132),
(1139, 132),
(1140, 87),
(1141, 87),
(1142, 87),
(1143, 87),
(1144, 87),
(1145, 87),
(1146, 87),
(1147, 85),
(1148, 85),
(1149, 85),
(1150, 85),
(1151, 85),
(1152, 85),
(1153, 85),
(1154, 85),
(1155, 85),
(1156, 87),
(1157, 132),
(1158, 134),
(1159, 36),
(1160, 36),
(1161, 36),
(1162, 132),
(1163, 132),
(1164, 57),
(1165, 134),
(1166, 132),
(1167, 132),
(1168, 134),
(1169, 13),
(1170, 13),
(1171, 13),
(1172, 13),
(1173, 36),
(1174, 134),
(1175, 36),
(1176, 139),
(1177, 40),
(1178, 129),
(1179, 129),
(1180, 129),
(1181, 129),
(1182, 129),
(1183, 129),
(1184, 129),
(1185, 129),
(1186, 129),
(1187, 129),
(1188, 129),
(1189, 129),
(1190, 129),
(1191, 129),
(1192, 129),
(1193, 129),
(1194, 82),
(1195, 82),
(1196, 82),
(1197, 82),
(1198, 82),
(1199, 57),
(1200, 36),
(1201, 129),
(1202, 129),
(1203, 129),
(1204, 129),
(1205, 129),
(1206, 129),
(1207, 129),
(1208, 129),
(1209, 129),
(1210, 129),
(1211, 129),
(1212, 129),
(1217, 132),
(1214, 132),
(1215, 132),
(1216, 132),
(1218, 129),
(1219, 129),
(1220, 129),
(1221, 129),
(1222, 129),
(1223, 129),
(1224, 132),
(1225, 132),
(1226, 132),
(1227, 132),
(1228, 139),
(1229, 120),
(1230, 120),
(1232, 120),
(1234, 120),
(1235, 120),
(1237, 120),
(1239, 120),
(1240, 120),
(1241, 120),
(1242, 120),
(1243, 120),
(1244, 120),
(1245, 120),
(1246, 120),
(1247, 120),
(1248, 120),
(1249, 120),
(1250, 120),
(1251, 120),
(1252, 120),
(1253, 120),
(1254, 120),
(1255, 120),
(1256, 120),
(1257, 132),
(1258, 64),
(1887, 182),
(1262, 132),
(1263, 132),
(1264, 142),
(1265, 1),
(1266, 120),
(1267, 120),
(1268, 120),
(1269, 120),
(1270, 120),
(1271, 146),
(1272, 146),
(1273, 146),
(1274, 146),
(1275, 146),
(1276, 146),
(1277, 136),
(1278, 136),
(1279, 136),
(1280, 136),
(1281, 136),
(1282, 1),
(1283, 1),
(1284, 1),
(1285, 1),
(1286, 1),
(1287, 1),
(1288, 1),
(1289, 1),
(1290, 1),
(1291, 115),
(1292, 115),
(1293, 115),
(1294, 115),
(1295, 115),
(1296, 115),
(1297, 115),
(1298, 115),
(1299, 132),
(1300, 132),
(1301, 132),
(1302, 132),
(1303, 132),
(1304, 120),
(1305, 120),
(1306, 120),
(1307, 120),
(1309, 131),
(1310, 131),
(1311, 131),
(1329, 131),
(1313, 132),
(1314, 132),
(1315, 131),
(1316, 131),
(1317, 131),
(1318, 131),
(1319, 131),
(1320, 131),
(1321, 131),
(1322, 131),
(1323, 131),
(1324, 131),
(1325, 131),
(1326, 131),
(1327, 131),
(1328, 131),
(1330, 131),
(1331, 131),
(1332, 131),
(1333, 131),
(1334, 131),
(1365, 131),
(1338, 131),
(1339, 131),
(1340, 131),
(1341, 131),
(1342, 131),
(1343, 131),
(1344, 131),
(1345, 131),
(1346, 131),
(1347, 131),
(1348, 131),
(1349, 131),
(1350, 131),
(1351, 131),
(1352, 131),
(1353, 131),
(1354, 131),
(1355, 131),
(1356, 131),
(1357, 131),
(1358, 131),
(1359, 131),
(1360, 131),
(1361, 131),
(1362, 131),
(1363, 131),
(1366, 131),
(1367, 131),
(1368, 131),
(1390, 36),
(1391, 36),
(1392, 36),
(1393, 1),
(1394, 1),
(1395, 139),
(1396, 132),
(1397, 152),
(1398, 152),
(1399, 152),
(1400, 152),
(1401, 152),
(1402, 152),
(1403, 152),
(1404, 152),
(1405, 152),
(1406, 152),
(1407, 152),
(1408, 152),
(1409, 152),
(1410, 152),
(1411, 152),
(1412, 152),
(1413, 152),
(1414, 152),
(1415, 152),
(1416, 152),
(1417, 152),
(1418, 152),
(1419, 152),
(1420, 152),
(1421, 152),
(1422, 152),
(1423, 152),
(1424, 152),
(1425, 152),
(1426, 152),
(1427, 152),
(1428, 152),
(1429, 152),
(1430, 152),
(1431, 152),
(1432, 131),
(1433, 131),
(1434, 131),
(1435, 131),
(1436, 131),
(1437, 131),
(1438, 131),
(1439, 131),
(1440, 131),
(1441, 131),
(1442, 131),
(1443, 131),
(1444, 131),
(1445, 131),
(1446, 131),
(1447, 131),
(1448, 131),
(1449, 131),
(1450, 131),
(1451, 131),
(1452, 131),
(1453, 131),
(1454, 131),
(1455, 131),
(1456, 131),
(1457, 152),
(1458, 152),
(1459, 152),
(1460, 152),
(1461, 152),
(1462, 152),
(1463, 152),
(1464, 152),
(1465, 152),
(1466, 152),
(1467, 152),
(1468, 132),
(1480, 153),
(1481, 153),
(1472, 133),
(1473, 132),
(1479, 153),
(1482, 153),
(1483, 153),
(1484, 153),
(1485, 153),
(1486, 153),
(1487, 153),
(1491, 132),
(1490, 132),
(1492, 132),
(1493, 152),
(1494, 152),
(1495, 152),
(1496, 152),
(1497, 152),
(1498, 152),
(1499, 152),
(1500, 152),
(1501, 152),
(1502, 152),
(1503, 152),
(1504, 152),
(1505, 152),
(1506, 152),
(1508, 152),
(1509, 152),
(1510, 152),
(1511, 152),
(1512, 152),
(1513, 152),
(1514, 152),
(1515, 152),
(1516, 152),
(1517, 146),
(1518, 146),
(1519, 120),
(1520, 121),
(1521, 132),
(1522, 132),
(1523, 132),
(1524, 132),
(1525, 132),
(1526, 15),
(1527, 15),
(1528, 15),
(1529, 15),
(1530, 15),
(1531, 15),
(1532, 15),
(1533, 15),
(1534, 15),
(1535, 15),
(1536, 15),
(1537, 15),
(1538, 15),
(1539, 15),
(1540, 15),
(1541, 15),
(1542, 15),
(1543, 15),
(1544, 15),
(1545, 15),
(1546, 15),
(1547, 15),
(1548, 15),
(1549, 15),
(1550, 15),
(1551, 15),
(1552, 15),
(1553, 15),
(1554, 15),
(1555, 15),
(1556, 15),
(1557, 15),
(1558, 15),
(1559, 151),
(1560, 132),
(1561, 132),
(1564, 13),
(1565, 13),
(1563, 13),
(1566, 15),
(1567, 40),
(1568, 153),
(1569, 153),
(1570, 153),
(1571, 153),
(1572, 153),
(1573, 153),
(1575, 153),
(1576, 153),
(1577, 153),
(1578, 153),
(1579, 153),
(1580, 153),
(1581, 153),
(1582, 153),
(1583, 153),
(1584, 153),
(1585, 153),
(1586, 153),
(1587, 153),
(1588, 153),
(1589, 153),
(1590, 153),
(1591, 153),
(1592, 153),
(1593, 153),
(1594, 153),
(1595, 153),
(1596, 153),
(1597, 153),
(1598, 153),
(1599, 153),
(1600, 153),
(1601, 153),
(1602, 153),
(1603, 153),
(1604, 153),
(1605, 153),
(1606, 153),
(1607, 153),
(1608, 153),
(1609, 153),
(1610, 153),
(1611, 153),
(1612, 153),
(1623, 153),
(1613, 153),
(1614, 153),
(1615, 153),
(1616, 153),
(1617, 153),
(1618, 153),
(1619, 153),
(1620, 153),
(1621, 153),
(1622, 153),
(1624, 153),
(1625, 153),
(1626, 153),
(1627, 153),
(1628, 153),
(1629, 153),
(1630, 153),
(1631, 153),
(1632, 153),
(1633, 153),
(1634, 153),
(1635, 153),
(1636, 153),
(1637, 153),
(1638, 153),
(1639, 153),
(1640, 153),
(1641, 153),
(1642, 153),
(1643, 153),
(1644, 153),
(1645, 153),
(1646, 153),
(1647, 153),
(1648, 153),
(1649, 153),
(1650, 153),
(1651, 153),
(1652, 153),
(1653, 153),
(1654, 153),
(1655, 153),
(1656, 153),
(1657, 153),
(1658, 153),
(1659, 153),
(1660, 153),
(1661, 153),
(1662, 153),
(1663, 153),
(1664, 153),
(1665, 153),
(1666, 153),
(1667, 153),
(1668, 153),
(1669, 153),
(1670, 153),
(1671, 153),
(1672, 153),
(1673, 153),
(1674, 153),
(1675, 153),
(1676, 153),
(1677, 153),
(1680, 153),
(1681, 153),
(1728, 153),
(1731, 153),
(1686, 153),
(1687, 153),
(1688, 153),
(1689, 153),
(1691, 153),
(1732, 153),
(1733, 153),
(1693, 153),
(1694, 153),
(1695, 153),
(1696, 153),
(1697, 153),
(1698, 153),
(1699, 153),
(1700, 153),
(1701, 153),
(1702, 153),
(1703, 153),
(1704, 153),
(1707, 153),
(1708, 153),
(1709, 153),
(1710, 153),
(1711, 153),
(1712, 153),
(1713, 153),
(1714, 153),
(1716, 153),
(1717, 153),
(1718, 153),
(1719, 153),
(1720, 153),
(1724, 153),
(1725, 153),
(1729, 153),
(1730, 153),
(1734, 132),
(1735, 2),
(1736, 2),
(1737, 2),
(1738, 2),
(1739, 2),
(1740, 1),
(1741, 1),
(1742, 1),
(1743, 1),
(1744, 1),
(1745, 1),
(1746, 1),
(1747, 1),
(1748, 153),
(1749, 153),
(1750, 153),
(1751, 153),
(1752, 153),
(1753, 153),
(1754, 153),
(1755, 153),
(1767, 126),
(1764, 126),
(1765, 126),
(1766, 126),
(1769, 126),
(1768, 126),
(1770, 126),
(1771, 126),
(1773, 126),
(1774, 126),
(1775, 126),
(1776, 126),
(1777, 126),
(1779, 126),
(1780, 126),
(1781, 126),
(1782, 126),
(1783, 126),
(1784, 126),
(1785, 126),
(1786, 126),
(1787, 126),
(1788, 126),
(1789, 126),
(1790, 126),
(1791, 126),
(1792, 126),
(1793, 153),
(1794, 153),
(1795, 153),
(1796, 153),
(1797, 153),
(1798, 122),
(1799, 96),
(1800, 96),
(1801, 62),
(1802, 78),
(1803, 39),
(1804, 40),
(2284, 138),
(1806, 173),
(1807, 173),
(1808, 161),
(1809, 161),
(1810, 151),
(1811, 151),
(1812, 151),
(1813, 151),
(1814, 80),
(1815, 173),
(1816, 80),
(1817, 16),
(1818, 16),
(1819, 80),
(1827, 21),
(1824, 21),
(1825, 21),
(1826, 21),
(1828, 95),
(1829, 95),
(1830, 95),
(1831, 80),
(1832, 80),
(1833, 178),
(1834, 178),
(1835, 178),
(1836, 178),
(1837, 178),
(1838, 178),
(1839, 178),
(1840, 178),
(1841, 178),
(1842, 178),
(1843, 178),
(1844, 178),
(1845, 178),
(1846, 178),
(1847, 178),
(1848, 178),
(1849, 178),
(1850, 178),
(1851, 178),
(1852, 178),
(1853, 178),
(1854, 178),
(1855, 178),
(1856, 178),
(1857, 178),
(1858, 178),
(1859, 178),
(1860, 178),
(1861, 178),
(1862, 178),
(1863, 178),
(1864, 178),
(1865, 119),
(1866, 173),
(1867, 167),
(1868, 167),
(1869, 167),
(1870, 167),
(1871, 121),
(1872, 80),
(1873, 162),
(1874, 120),
(1875, 120),
(1876, 120),
(1877, 120),
(1878, 120),
(1879, 120),
(1880, 120),
(1881, 120),
(1882, 120),
(1883, 36),
(1884, 36),
(1885, 161),
(1889, 182),
(1890, 182),
(1891, 182),
(1892, 182),
(1893, 182),
(1894, 182),
(1895, 114),
(1896, 114),
(1897, 114),
(1898, 114),
(1899, 114),
(1900, 161),
(1904, 13),
(1902, 33),
(1905, 15),
(1907, 132),
(1908, 132),
(1909, 132),
(1910, 132),
(1911, 132),
(1912, 208),
(1913, 208),
(1914, 208),
(1915, 208),
(1916, 208),
(1917, 208),
(1918, 208),
(1919, 208),
(1920, 208),
(1921, 208),
(1922, 208),
(1923, 208),
(1924, 208),
(1925, 208),
(1926, 208),
(1927, 208),
(1928, 208),
(1929, 208),
(1930, 208),
(1931, 208),
(1932, 208),
(1933, 208),
(1934, 208),
(1935, 208),
(1936, 208),
(1937, 208),
(1938, 208),
(1939, 208),
(1940, 208),
(1941, 208),
(1942, 208),
(1943, 208),
(1944, 208),
(1945, 208),
(1946, 208),
(1947, 208),
(1948, 208),
(1949, 208),
(1950, 208),
(1951, 208),
(1952, 208),
(1953, 208),
(1954, 208),
(1955, 208),
(1956, 208),
(1957, 208),
(1958, 208),
(1959, 208),
(1960, 208),
(1961, 208),
(1962, 208),
(1963, 208),
(1964, 208),
(1965, 208),
(1966, 208),
(1967, 208),
(1968, 208),
(1969, 208),
(1970, 208),
(1971, 208),
(1972, 208),
(1973, 208),
(1974, 208),
(1975, 161),
(1976, 161),
(1977, 196),
(1978, 196),
(1979, 196),
(1980, 196),
(1981, 196),
(1982, 196),
(1984, 211),
(1985, 211),
(1986, 211),
(1987, 211),
(1988, 211),
(1989, 211),
(1990, 211),
(1991, 211),
(1992, 211),
(1993, 161),
(1994, 146),
(1995, 146),
(1996, 161),
(1997, 161),
(1998, 161),
(1999, 93),
(2000, 36),
(2001, 36),
(2002, 36),
(2003, 36),
(2004, 36),
(2005, 36),
(2006, 161),
(2008, 132),
(2009, 132),
(2010, 132),
(2011, 132),
(2012, 121),
(2013, 16),
(2014, 16),
(2015, 16),
(2016, 16),
(2017, 16),
(2018, 16),
(2019, 16),
(2020, 16),
(2021, 16),
(2022, 16),
(2023, 16),
(2024, 16),
(2025, 16),
(2026, 16),
(2027, 16),
(2028, 16),
(2029, 16),
(2030, 16),
(2031, 16),
(2032, 16),
(2033, 16),
(2034, 16),
(2035, 16),
(2036, 16),
(2079, 191),
(2038, 16),
(2039, 16),
(2040, 16),
(2041, 16),
(2042, 16),
(2043, 16),
(2044, 16),
(2045, 16),
(2046, 16),
(2047, 16),
(2048, 161),
(2049, 161),
(2050, 161),
(2051, 161),
(2052, 161),
(2053, 161),
(2054, 161),
(2055, 161),
(2056, 161),
(2057, 16),
(2058, 57),
(2073, 36),
(2072, 138),
(2061, 161),
(2062, 161),
(2063, 161),
(2064, 161),
(2065, 161),
(2067, 161),
(2068, 161),
(2069, 161),
(2070, 161),
(2074, 173),
(2075, 173),
(2076, 173),
(2077, 173),
(2078, 39),
(2080, 191),
(2081, 191),
(2082, 191),
(2083, 191),
(2084, 36),
(2085, 36),
(2086, 36),
(2087, 36),
(2088, 15),
(2089, 15),
(2090, 15),
(2091, 15),
(2092, 15),
(2093, 15),
(2094, 39),
(2095, 62),
(2096, 62),
(2097, 226),
(2098, 226),
(2099, 226),
(2100, 226),
(2101, 132),
(2102, 132),
(2104, 132),
(2105, 132),
(2106, 132),
(2135, 146),
(2132, 194),
(2107, 15),
(2108, 15),
(2109, 15),
(2110, 15),
(2111, 15),
(2112, 15),
(2113, 15),
(2114, 15),
(2116, 194),
(2118, 194),
(2119, 194),
(2120, 194),
(2121, 194),
(2122, 194),
(2123, 194),
(2124, 194),
(2125, 194),
(2133, 194),
(2131, 145),
(2134, 146),
(2136, 146),
(2137, 146),
(2138, 146),
(2139, 146),
(2140, 235),
(2141, 150),
(2142, 236),
(2143, 130),
(2144, 130),
(2145, 130),
(2146, 68),
(2147, 212),
(2148, 219),
(2149, 118),
(2150, 251),
(2151, 132),
(2152, 251),
(2153, 256),
(2154, 256),
(2155, 256),
(2156, 256),
(2157, 256),
(2165, 257),
(2166, 257),
(2164, 257),
(2163, 257),
(2167, 257),
(2168, 257),
(2169, 257),
(2170, 257),
(2171, 257),
(2172, 257),
(2173, 257),
(2174, 257),
(2175, 145),
(2176, 145),
(2177, 145),
(2178, 132),
(2190, 254),
(2191, 254),
(2192, 254),
(2193, 254),
(2194, 254),
(2195, 254),
(2196, 254),
(2197, 254),
(2198, 254),
(2189, 254),
(2199, 254),
(2200, 254),
(2201, 254),
(2202, 254),
(2203, 254),
(2204, 254),
(2205, 254),
(2206, 254),
(2207, 254),
(2208, 254),
(2209, 254),
(2210, 120),
(2211, 120),
(2212, 120),
(2215, 254),
(2214, 254),
(2216, 254),
(2217, 254),
(2221, 16),
(2222, 16),
(2223, 16),
(2224, 16),
(2225, 16),
(2226, 16),
(2227, 16),
(2228, 16),
(2230, 264),
(2232, 38),
(2233, 145),
(2234, 265),
(2235, 236),
(2238, 67),
(2237, 67),
(2239, 67),
(2245, 234),
(2242, 236),
(2243, 234),
(2269, 234),
(2268, 234),
(2267, 234),
(2266, 234),
(2265, 234),
(2264, 234),
(2263, 234),
(2262, 234),
(2254, 234),
(2255, 234),
(2256, 234),
(2257, 234),
(2258, 234),
(2259, 234),
(2260, 234),
(2261, 234),
(2270, 234),
(2277, 255),
(2275, 128),
(2276, 128),
(2274, 128),
(2278, 255),
(2279, 255),
(2280, 255),
(2282, 120),
(2283, 236),
(2285, 120),
(2286, 120),
(2287, 120),
(2288, 120),
(2289, 185),
(2290, 185),
(2291, 185),
(2292, 185),
(2294, 36),
(2295, 36),
(2296, 36),
(2297, 36),
(2298, 36),
(2299, 36),
(2300, 36),
(2301, 36),
(2302, 36),
(2303, 36),
(2304, 36),
(2305, 36),
(2306, 36),
(2307, 36),
(2308, 36),
(2309, 36),
(2310, 36),
(2311, 36),
(2312, 36),
(2313, 36),
(2314, 36),
(2315, 36),
(2316, 36),
(2317, 36),
(2318, 36),
(2319, 36),
(2320, 36),
(2321, 36),
(2322, 36),
(2323, 36),
(2324, 36),
(2325, 36),
(2326, 36),
(2327, 36),
(2328, 236),
(2332, 264),
(2333, 264),
(2334, 264),
(2335, 30),
(2336, 30),
(2337, 236),
(2338, 212),
(2339, 212),
(2340, 212),
(2341, 212),
(2342, 212),
(2343, 212),
(2344, 212),
(2345, 220),
(2346, 158),
(2347, 36),
(2353, 158),
(2352, 23),
(2354, 9),
(2355, 185),
(2356, 185),
(2357, 185),
(2358, 219),
(2359, 163),
(2360, 163),
(2361, 163),
(2362, 163),
(2363, 163),
(2364, 163),
(2365, 163),
(2366, 163),
(2367, 163),
(2368, 117),
(2369, 117),
(2370, 234),
(2371, 234),
(2372, 234),
(2373, 132),
(2374, 146),
(2375, 146),
(2378, 236),
(2377, 265),
(2379, 223),
(2380, 36),
(2381, 36),
(2382, 36),
(2383, 36),
(2384, 36),
(2385, 36),
(2386, 36),
(2387, 36),
(2388, 36),
(2389, 36),
(2390, 36),
(2391, 36),
(2392, 36),
(2393, 36),
(2394, 36),
(2395, 36),
(2396, 36),
(2397, 36),
(2398, 36),
(2399, 36),
(2400, 36),
(2401, 185),
(2402, 185),
(2407, 6)]

# INSERT INTO `dataset_cats` (`cat_id`, `cat_title`, `cat_parent`) VALUES
dataset_cats = [
(1, 'Bicester Achievers', 14),
(2, 'Spa Speakers', 68),
(3, 'Autumn Conference 2005', 83),
(4, 'Warwick Speakers', 68),
(5, 'Guildford Speakers', 99),
(6, 'District 71', 0),
(7, 'Spring Conference 2006', 83),
(8, 'Tunbridge Wells Speakers Club', 22),
(9, 'Woking Speakers Club', 99),
(10, 'Bardwell Speakers', 14),
(11, 'Manchester Orators', 195),
(12, 'Eastbourne Speakers', 22),
(13, 'Division E', 6),
(14, 'Area 7', 206),
(15, 'Area 30', 281),
(16, 'PM-CityGate Toastmasters', 80),
(17, 'Division B', 6),
(18, 'Division C', 6),
(19, 'Division D', 6),
(20, 'Division F', 6),
(21, 'Division G', 6),
(22, 'Division H', 6),
(23, 'Glasgow', 281),
(24, 'Area 20', 21),
(25, 'Canary Wharf Communicators', 106),
(26, 'Norwich Speakers Club', 98),
(27, 'Hertfordshire', 24),
(28, 'Nenagh', 20),
(29, 'District 71 - Washington Convention 2006', 83),
(30, 'Camberley Communicators & Leaders', 99),
(31, 'Mullingar', 20),
(32, 'The Victory Conference - Spring 2007', 83),
(33, 'Hallmark Speakers', 93),
(34, 'Oxford Speakers', 14),
(35, 'District 71 - Nenagh Conference', 83),
(36, 'Powdermills', 161),
(37, 'Reading Speakers Club', 213),
(38, 'Capital Communicators', 15),
(39, 'Carrigaline', 57),
(40, 'Southside Speakers', 281),
(43, 'Brighton and Hove', 22),
(44, 'Maidenhead', 100),
(45, 'Area 15', 13),
(46, 'Leeds City', 45),
(47, 'Chiltern', 100),
(49, 'The Toasted Sandwich', 103),
(50, 'Wessex', 213),
(51, 'Worthing', 101),
(53, 'Toastie and Ghosties', 83),
(54, 'Macroom Toastmasters', 57),
(55, 'Harrogate', 13),
(56, 'GCC', 57),
(57, 'Area 23', 16),
(59, 'Isis Speakers', 14),
(60, 'Aberdeen', 94),
(61, 'London Olympians', 104),
(62, 'Area 11', 16),
(64, 'Meridian', 242),
(65, 'Marlow Orators', 100),
(66, 'Citi Criers', 242),
(67, 'East Midlands Speakers', 68),
(68, 'Area 39', 13),
(69, 'Killarney Lakes Conference', 83),
(70, 'Dundee Toastmasters', 94),
(71, 'Area 22', 206),
(72, 'Vodafone Speakers Club', 71),
(73, 'Engineers', 91),
(74, 'The Universities Club', 101),
(75, 'Beara', 62),
(76, 'Dominion Speakers', 195),
(77, 'Casterbridge Martyrs', 93),
(78, 'Linlithgow', 15),
(79, 'Canterbury Communicators', 103),
(80, 'Area 3', 16),
(81, 'Ipswich Electrifiers', 95),
(82, 'Three Castles Conference', 83),
(83, 'Conferences', 6),
(84, 'Forres Toastmasters', 94),
(85, 'Articulate', 98),
(86, 'Bantry', 62),
(87, 'Brandon', 98),
(88, 'Speak Easy @ Martlesham', 95),
(91, 'Area 18', 241),
(93, 'Area 42', 206),
(94, 'Area 43', 281),
(95, 'Area 1', 21),
(96, 'Area 4', 206),
(97, 'Area 41', 21),
(98, 'Area 25', 21),
(99, 'Area 14', 22),
(100, 'Area 21', 22),
(101, 'Area 32', 22),
(102, 'Area 35', 242),
(103, 'Area 37', 22),
(104, 'Area 6', 17),
(105, 'Area 29', 17),
(106, 'Area 31', 242),
(107, 'Area 34', 240),
(108, 'Area 33', 240),
(109, 'South West Speakers', 206),
(123, 'Bandon', 62),
(113, 'Watford Speakers', 240),
(114, 'West Herts', 24),
(115, 'Bedford Speakers & Leaders', 21),
(116, 'Eldergate', 21),
(117, 'North Bucks', 21),
(118, 'Aylesbury', 96),
(119, 'Berkhamsted Speakers Club', 96),
(120, 'Solent', 101),
(121, 'West Limerick', 122),
(122, 'Area 36', 16),
(124, 'Crusaders', 57),
(125, 'Cheltenham Speakers ', 71),
(126, 'Kinsale', 62),
(127, 'District 71 - International Convention 2008', 83),
(128, 'Berkeley Square Speakers', 260),
(129, 'Cotswold Conference - Spring 2009', 83),
(130, 'Early Bird Speakers', 169),
(131, 'Greystones', 287),
(132, 'Bishopstown', 161),
(133, 'Grosvenor Square Speakers', 260),
(134, 'ICT Committee', 80),
(135, 'Newbury', 71),
(136, 'Hamwic Speakers - Southampton', 213),
(137, 'Didsbury Speakers', 195),
(138, 'Waverley Speakers', 15),
(139, 'A Team', 161),
(140, 'Chesterfield', 195),
(141, 'London Corinthians', 104),
(142, 'Polish your Polish', 260),
(143, 'Speakers Corner', 242),
(144, 'Northavon', 206),
(145, 'Thamesdown', 71),
(146, 'Douglas Sláinte', 57),
(147, 'Tara', 270),
(148, 'Fáilte', 16),
(149, 'Sheffield Speakers', 13),
(150, 'Bloomsbury Speakers', 107),
(151, 'A1 Speakers', 13),
(152, 'The White RoseConference - Autumn 2009', 83),
(153, 'The Sligo Conference - Spring 2010', 83),
(154, 'Lawspeak Toastmasters club', 107),
(155, 'Meadow Speakers', 21),
(156, 'Loch Ness Toastmonsters', 94),
(157, 'Thistle Speakers', 15),
(158, 'Covent Garden Speakers', 169),
(159, 'Shropshire Speakers', 68),
(160, 'Apple-Cork', 161),
(161, 'Area 49', 16),
(162, 'Lewisham Speakers Club', 242),
(163, 'Excalibur', 169),
(164, 'ACCAmembers Breakfast Club', 108),
(165, 'Viking Voices', 18),
(166, 'WIBF Speakers-City Club', 249),
(167, 'Doncaster', 45),
(168, 'Kingston Communicators', 45),
(169, 'Area 45', 17),
(170, 'HOD', 240),
(171, 'Cambridge Speakers Club', 97),
(172, 'London Business School', 204),
(173, 'Cork Leeside Toastmasters', 161),
(174, 'Dublin', 18),
(175, 'Epsom', 261),
(176, 'Advanced Orators', 195),
(177, 'The London Conference', 83),
(178, 'Dublin Inspire Conference', 83),
(179, 'Cogito', 270),
(180, 'Arun', 101),
(181, 'Warrington Speakers', 195),
(182, 'Athlone', 20),
(183, 'Cranfield  Speakers', 21),
(184, 'LBM Speakers', 261),
(185, 'Falkirk Orators', 281),
(186, 'EbOrators', 13),
(187, 'Active Speakers of Purley', 102),
(188, 'Merlin''s Mound Toastmasters Club', 71),
(189, 'Ferndown Speakers', 93),
(190, 'Croydon Communicators', 102),
(191, 'Glasgow Conference', 83),
(192, 'Salford Speakers', 195),
(193, 'White Rose Speakers', 45),
(194, 'Dublin South Toastmasters', 270),
(195, 'Area 48', 13),
(196, 'Wicklow', 287),
(197, 'Killarney', 122),
(198, 'Tralee', 122),
(199, 'Naas', 19),
(200, 'Phoenix Speakers', 104),
(201, 'Fingal', 18),
(202, 'Phoenix-Tara', 18),
(203, 'Speakers 25 in the City', 249),
(204, 'Area 47', 240),
(205, 'Rathfarnham', 286),
(206, 'Division J', 6),
(207, 'Dun Laoghaire', 287),
(208, 'Template Club', 0),
(267, 'Portal Practice', 6),
(210, 'Clondalkin', 18),
(211, 'Castleknock', 18),
(212, 'Armada Speakers', 206),
(213, 'Area 46', 206),
(214, 'Dundalk', 18),
(215, 'Midleton', 80),
(216, 'Bullring Speakers', 106),
(217, 'Women In Banking & Finance', 106),
(218, '1st London Toastmasters', 242),
(219, 'Holborn Speakers', 107),
(220, 'Perth Toastmasters', 94),
(221, 'Swan Speakers', 96),
(222, 'Chelmsford Speakers Club', 95),
(223, 'Voice of Wales', 206),
(224, 'Imperial College Speakers', 260),
(225, 'Cardiff Toastmasters', 206),
(226, 'Russian English Speakers', 106),
(227, 'Speakers of Croydon', 102),
(228, 'Society Speakers', 107),
(229, 'Bromley Speakers', 102),
(230, 'NZICA Bank', 249),
(231, 'Lucan', 286),
(232, 'Chaseside', 14),
(233, 'Cardiff Saudi Toastmasters', 206),
(234, 'Haymarket Toastmasters', 15),
(235, 'St Patricks/Marymount Toastmasters', 161),
(236, 'EMC Ireland', 161),
(237, 'Farnham Speakers Club', 99),
(238, 'Uncensored Speakers', 270),
(239, 'Vale Speakers', 96),
(240, 'Division L', 6),
(241, 'Division M', 6),
(242, 'Division K', 6),
(243, 'BlackRock Speaks', 249),
(244, 'Riverbank Speakers', 249),
(245, 'London Athenians', 105),
(252, 'Lakenheath Speakers', 98),
(247, 'Croxley Communicators', 240),
(248, 'CharisMedIc Communicators', 97),
(249, 'Area 56', 240),
(250, 'Experience French', 108),
(251, 'Cummins Toastmaster Club', 45),
(253, 'Elavon Cherrywood', 213),
(254, 'West London Speakers', 105),
(255, 'Spinnaker Speakers', 101),
(256, 'Dungarvan', 19),
(257, 'Newry Speakers', 18),
(258, 'London Cardinals', 104),
(259, 'Heart Of England', 68),
(260, 'Area 52', 17),
(261, 'Area 53', 17),
(262, 'Kings Speakers', 260),
(263, 'London Trojans', 105),
(264, 'Malvern Speakers', 71),
(265, 'West Cork Toastmasters', 62),
(266, 'BofAML London Toastmasters', 108),
(268, 'BBH London', 249),
(269, 'Clerkenwell Speakers', 107),
(270, 'Area 54', 241),
(271, 'Chaseside', 93),
(272, 'EI Toastmasters', 18),
(274, 'Speaking Actuaries', 106),
(275, 'Belfast', 18),
(276, 'Fairfield Speakers', 102),
(277, 'Cornerstone', 24),
(278, 'Clondalkin Toastmasters', 286),
(279, 'Blarney', 80),
(280, 'Area 38', 20),
(281, 'Division S', 6),
(283, 'Donegal', 280),
(284, 'Guardian', 80),
(285, 'University of Birmingham', 68),
(286, 'Area 26', 241),
(287, 'Area 5', 241),
(288, 'Cork', 0),
(289, 'St Andrews Toastmasters', 0),
(290, 'T&O Toastmasters Club', 0),
(291, 'Basingstoke Speakers', 0),
(292, 'London UK Pros Club', 0),
(293, 'IE Templebar Toastmasters', 0),
(294, 'Area 51', 0),
(295, 'PWC', 0),
(296, 'Tech Support', 0),
(297, 'Brentwood Speakers Club', 0),
(298, 'Glasnevin', 0),
(299, 'State Street Edinburgh', 0),
(300, 'Lewes Speakers', 0),
(301, 'Kildare', 0),
(302, 'Glanmire', 0),
(303, 'Plain Speakers', 0),
(304, 'Area 62', 0)]

# INSERT INTO `dataset_club` (`club_id`, `club_name`, `club_type`, `cat_id`) VALUES
dataset_club = [
(3, 'Bicester Speakers Club', 1, 1),
(4, 'Spa Speakers', 1, 2),
(7, 'District 71', 11, 6),
(8, 'Warwick Speakers', -1, 4),
(9, 'Guildford Speakers Club', 1, 5),
(10, 'Tunbridge Wells Speakers Club', 1, 8),
(11, 'Woking Speakers Club', 1, 9),
(12, 'Bardwell Speakers', 1, 10),
(13, 'Manchester Orators', 1, 11),
(14, 'Eastbourne Speakers', 1, 12),
(15, 'Division E', 12, 13),
(16, 'Area 7', 13, 14),
(17, 'Area 30', 13, 15),
(18, 'Division A', 12, 16),
(19, 'Division B', 12, 17),
(20, 'Division C', 12, 18),
(21, 'Division D', 12, 19),
(22, 'Division F', 12, 20),
(24, 'Division H', 12, 22),
(23, 'Division G', 12, 21),
(25, 'Oxford Speakers', 1, 34),
(26, 'Ridgeway', 1, 0),
(27, 'Anglia Communicators', 1, 0),
(28, 'Cambridge Speakers Club', 1, 171),
(29, 'Camulodunum', 1, 0),
(30, 'Ipswich Electrifiers', 1, 81),
(31, 'Speak Easy @ Martlesham', 1, 88),
(32, 'Aylesbury Speakers', 1, 118),
(33, 'Eldergate Toastmasters Club', 1, 116),
(34, 'North Bucks', 1, 117),
(35, 'Bedford Speakers', 1, 115),
(36, 'Thame Speakers Club', 1, 0),
(37, 'Vale Speakers', 1, 239),
(38, 'Area 3', 13, 80),
(39, 'Area 11', 13, 62),
(40, 'Area 17', 13, 0),
(41, 'Area 23', 13, 57),
(42, 'Area 36', 13, 122),
(43, 'Area 6', 13, 104),
(44, 'Area 29', 13, 105),
(45, 'Area 31', 13, 106),
(46, 'Area 33', 13, 108),
(47, 'Area 34', 13, 107),
(48, 'Area 2', 13, 0),
(49, 'Area 5', 13, 287),
(50, 'Area 10', 13, 0),
(51, 'Area 16', 13, 0),
(52, 'Area 18', 13, 91),
(53, 'Area 19', 13, 0),
(54, 'Area 26', 13, 286),
(55, 'Area 8', 13, 0),
(56, 'Area 27', 13, 0),
(57, 'Area 28', 13, 0),
(58, 'Area 15', 13, 45),
(59, 'Area 22', 13, 71),
(60, 'Area 9', 13, 0),
(61, 'Area 12', 13, 0),
(63, 'Area 24', 13, 0),
(62, 'Area 13', 13, 0),
(64, 'Area 38', 13, 280),
(65, 'Area 1', 13, 95),
(66, 'Area 4', 13, 96),
(67, 'Area 20', 13, 24),
(68, 'Area 25', 13, 98),
(69, 'Area 14', 13, 99),
(70, 'Area 21', 13, 100),
(71, 'Area 32', 13, 101),
(72, 'Area 35', 13, 102),
(73, 'Area 37', 13, 103),
(74, 'Chaseside', 1, 271),
(75, 'Hallmark Speakers', 1, 33),
(76, 'Newbury Speakers Club', 1, 135),
(77, 'Northavon', 1, 144),
(78, 'Thamesdown', 1, 145),
(79, 'Aberdeen Toastmasters', 1, 60),
(80, 'Capital Communicators', 1, 38),
(81, 'Glasgow Toastmasters', 1, 23),
(82, 'Hadrian\\''s Orators', 10, 0),
(83, 'Linlithgow Speakers', 1, 78),
(84, 'Proclaimers@Sun', 1, 0),
(85, 'Southside Speakers', 1, 40),
(86, 'Harrovians', 1, 0),
(87, 'Hertfordshire', 1, 27),
(88, 'HOD', 1, 170),
(89, 'West Herts', 1, 114),
(90, 'Dereham Articulate Speakers Club', 1, 85),
(91, 'North Norfolk', 1, 0),
(92, 'Norwich Speakers Club', 1, 26),
(93, 'Brandon Speakers Club', 1, 87),
(94, 'Solent Speakers', 1, 120),
(95, 'Wessex Speakers', 1, 50),
(96, 'Bromley Speakers', 1, 229),
(97, 'Croydon Communicators', 1, 190),
(98, 'Gravesend', 10, 0),
(99, 'Meridian Speakers', 1, 64),
(100, 'Speakers of Croydon', 1, 227),
(101, 'Kent', 1, 0),
(102, 'Canterbury Communicators', 1, 79),
(103, 'The Toasted Sandwich', 1, 49),
(104, 'Epsom', 1, 175),
(105, 'Mole Valley', 1, 0),
(106, 'Talkability@Sun', 1, 0),
(107, 'Chiltern', 1, 47),
(108, 'Maidenhead', 1, 44),
(109, 'Reading Speakers Club', 1, 37),
(110, 'Windsor', 1, 0),
(111, 'Arun', 1, 180),
(112, 'Brighton and Hove Speakers Club', 1, 43),
(113, 'London Athenians', 1, 245),
(114, 'London Business School', 1, 172),
(115, 'London Trojans', 1, 263),
(116, 'Riverside Communicators', 1, 0),
(117, 'Canary Wharf Communicators', 1, 25),
(118, 'Citi Criers', 1, 66),
(119, 'City Of London', 1, 264),
(120, 'Speakeasy@Credit_Suisse', 1, 0),
(121, 'WIBF Speakers (CW)', 1, 217),
(231, 'South West Speakers', 1, 109),
(123, 'London Communicators', 1, 0),
(124, 'MLP London Bridge Speakers', 1, 0),
(125, 'Northern Lights', 1, 0),
(126, 'Broadgate Speakers', 1, 0),
(127, 'St Paul\\''s Speakers', 1, 0),
(128, 'Berkeley Square Speakers', 1, 128),
(129, 'Grosvenor Square Speakers', 1, 133),
(130, 'Holborn Speakers', 1, 219),
(131, 'Tube Talk', 1, 0),
(132, 'Blitz Babblers', 10, 0),
(133, 'Excalibur', 1, 163),
(134, 'London Cardinals', 1, 258),
(135, 'London Corinthians', 1, 141),
(136, 'London Olympians', 1, 61),
(138, 'Doncaster Speakers', 1, 167),
(139, 'York EbOrators', 1, 186),
(140, 'Heart Of England', 1, 259),
(141, 'Leeds City', 1, 46),
(142, 'Bullring Speakers', 1, 216),
(143, 'Bantry', 1, 86),
(144, 'Macroom', 1, 54),
(145, 'Fermoy', 1, 0),
(146, 'ICT Committee', 1, 134),
(147, 'The Galtees', 1, 0),
(148, 'Fáilte', 1, 148),
(149, 'Speakeasy', 1, 0),
(150, 'Cork', 1, 0),
(151, 'Douglas Sláinte Toastmasters', 1, 146),
(152, 'Powdermills Toastmasters', 1, 36),
(153, 'Carrigaline Toastmasters', 1, 39),
(154, 'Crusaders Toastmasters Wilton', 1, 124),
(155, 'Clonakilty', 1, 0),
(156, 'Glanmire', 1, 302),
(157, 'Talking Heads', 1, 0),
(158, 'Blarney', 1, 279),
(159, 'Midleton', 1, 215),
(160, 'Bandon', 1, 123),
(161, 'Killarney', 1, 197),
(162, 'West Limerick', 1, 121),
(163, 'Tralee', 1, 198),
(164, 'Swords', 1, 0),
(165, 'Malahide', 1, 0),
(166, 'Fingal Toastmasters', 1, 201),
(167, 'Viking Voices', 1, 165),
(168, 'East Coast', 1, 0),
(169, 'Lucan Toastmasters', 1, 231),
(170, 'Clondalkin Toastmasters', 1, 278),
(171, 'Glasnevin', 1, 298),
(172, 'Castleknock Toastmasters', 1, 211),
(378, 'State Street London Speakers', 2, 216),
(173, 'Tara', 1, 147),
(174, 'Engineers', 2, 73),
(175, 'Power Talk', 2, 0),
(176, 'Rathfarnham', 1, 205),
(177, 'Hillsborough', 1, 0),
(178, 'Cookstown Speakers Club', 1, 0),
(179, 'Drogheda', 1, 0),
(180, 'Dundalk', 1, 214),
(181, 'Navan', 1, 0),
(182, 'Dublin', 1, 174),
(183, 'Hellfire', 1, 0),
(184, 'IE Templebar Toastmasters', 1, 0),
(185, 'Vox Populi Toastmasters ', 2, 0),
(186, 'Eblana', 1, 0),
(187, 'AIB Bank', 2, 0),
(188, 'Griffith College', 1, 0),
(189, 'St James\\''s', 1, 0),
(190, 'Society', 2, 0),
(191, 'Dun Laoghaire Toastmasters', 1, 207),
(192, 'Bray', 1, 0),
(193, 'Wicklow Toastmasters', 1, 196),
(194, 'Greystones Toastmasters ', 1, 131),
(195, 'Thurles', 1, 0),
(196, 'Clonmel', 1, 0),
(197, 'Kilkenny', 1, 0),
(198, 'Cashel', 1, 0),
(199, 'Naas', 1, 199),
(200, 'Kildare', 1, 301),
(201, 'Carlow', 1, 0),
(202, 'Athy Toastmasters', 1, 0),
(203, 'Portlaoise', 1, 0),
(204, 'Dungarvan', 1, 256),
(205, 'Waterford', 1, 0),
(206, 'Enniscorthy', 1, 0),
(207, 'DLS Communicators', 1, 0),
(208, 'Tramore', 1, 0),
(209, 'Westport', 1, 0),
(210, 'Corrib', 1, 0),
(211, 'Ballina', 1, 0),
(212, 'Galway', 1, 0),
(213, 'Shannon', 1, 0),
(214, 'Ennis Toastmasters Club', 1, 0),
(215, 'Kilrush and District', 1, 0),
(216, 'Raheen', 1, 0),
(217, 'Limerick Toastmasters', 1, 0),
(218, 'Nenagh', 1, 28),
(219, 'Killaloe-Ballina', 1, 0),
(220, 'Thomond', 1, 0),
(221, 'Sligo', 1, 0),
(222, 'Carrick on Shannon', 1, 0),
(223, 'Tullamore', 1, 0),
(224, 'Longford', 1, 0),
(225, 'Athlone', 1, 182),
(226, 'Mullingar', 1, 31),
(227, 'Innisfree', 1, 0),
(228, 'Gorey Toastmasters Club', 1, 0),
(229, 'WIBF Speakers-City Club', 1, 166),
(1, 'Demonstration Club', 1, 0),
(232, 'Camberley Speakers', 1, 30),
(233, 'West London Speakers', 1, 254),
(234, 'The London Conference', 14, 177),
(235, 'Maynooth', 1, 0),
(236, 'Forres Toastmasters', 1, 84),
(237, 'Worthing', 1, 51),
(238, 'Glasgow Conference', 14, 191),
(239, 'Strictly Speaking Harrogate', 1, 55),
(240, 'GCC', 6, 56),
(241, 'Isis Speakers', 1, 59),
(242, 'East Midlands Speakers', 1, 67),
(243, 'Cromwellian Speakers', 1, 0),
(245, 'Chelmsford Speakers Club', 1, 222),
(246, 'Enniskillen', 1, 0),
(248, 'Newry Speakers', 1, 257),
(250, 'Area 39', 13, 68),
(251, 'Area 40', 13, 0),
(252, 'Berkhamsted Speakers Club', 1, 119),
(253, 'Early Bird Speakers', 1, 130),
(254, 'Tipptalkers', 1, 0),
(255, 'Roscrea', 1, 0),
(256, 'Voice of Wales', 1, 223),
(257, 'Phoenix-Tara', 1, 202),
(258, 'Marlow Orators', 8, 65),
(259, 'Dundee Toastmasters', 1, 70),
(260, 'Vodafone Speakers Club', 1, 72),
(261, 'The Universities Club', 6, 74),
(262, 'Watford Speakers', 1, 113),
(263, 'Beara ', 1, 75),
(264, 'MWH Speakers', 1, 76),
(265, 'Casterbridge Speakers', 1, 77),
(266, 'Area 42', 13, 93),
(267, 'Area 41', 13, 97),
(268, 'Area 43', 13, 94),
(270, 'Speak Easy', 10, 0),
(271, 'Guardian', 1, 284),
(272, 'Polish Your Polish', 1, 142),
(273, 'Bank Street (Lehman Bros)', 1, 0),
(275, 'NZICA Bank', 1, 230),
(276, 'PWC', 1, 295),
(277, 'Emerald', 1, 0),
(278, 'Cheltenham Speakers ', 1, 125),
(279, 'Fylde Coast', 1, 0),
(280, 'Tuam', 1, 0),
(281, 'Huntingdonshire', 1, 0),
(282, 'Ambassadors Speakers Margate', 1, 0),
(283, 'Thomson Reuters', 1, 0),
(284, 'Chesterfield Speakers', 1, 140),
(285, 'Kinsale & District Toastmasters', 1, 126),
(286, 'Cambridge City Communicators', 1, 0),
(287, 'Talk Club @ Letterkenny', 1, 0),
(288, 'Battle Speakers', 1, 0),
(289, 'CASS Toastmasters', 2, 0),
(290, 'Bishopstown Toastmasters', 1, 132),
(291, 'Hamwic Speakers - Southampton', 1, 136),
(292, 'Fluor Toastmasters UK', 2, 0),
(293, 'Didsbury Speakers', 1, 137),
(294, 'The Speakers Network', 1, 0),
(295, 'Waverley Communicators', 1, 138),
(296, 'A Team', 8, 139),
(297, 'Area 44', 13, 0),
(298, 'Area 45', 13, 169),
(299, 'Area 47', 13, 204),
(300, 'Area 46', 13, 213),
(301, 'Area 48', 13, 195),
(302, 'Hull Speakers', 1, 168),
(303, 'Shropshire Speakers', 1, 159),
(304, 'A1 Speakers', 1, 151),
(305, 'Speakers Corner', 2, 143),
(306, 'Toastmasters@Microsoft UK', 2, 0),
(307, 'Lewisham Speakers Club', 1, 162),
(308, 'Armada Speakers', 1, 212),
(309, 'LBM Speakers', 1, 184),
(310, 'SpeakEasy Roscommon', 1, 0),
(312, 'Whitehall Speakers', 10, 0),
(313, 'Ware Speakers Club', 1, 0),
(314, 'Lincoln Speakers Club', 10, 0),
(315, 'Sheffield Speakers', 1, 0),
(316, 'Bloomsbury Speakers', 1, 150),
(317, 'Lawspeak Toastmasters club', 6, 154),
(318, 'Angel Speakers', 1, 155),
(319, 'Meadow Speakers', 10, 155),
(320, 'Toastmasters Inverness', 1, 156),
(321, 'Thistle Speakers', 10, 157),
(322, 'Covent Garden Speakers', 1, 158),
(464, 'Lewes Speakers', 1, 300),
(323, 'Aegon Toastmasters', 10, 0),
(324, 'Elvet Speakers', 1, 0),
(325, 'Apple-Cork', 2, 160),
(326, 'Area 49', 13, 161),
(455, 'T&O Toastmasters Club', 10, 290),
(327, 'Area 50', 13, 0),
(328, 'TATA Norwich Toastmasters', 1, 0),
(329, 'ACCAmembers Breakfast Club', 1, 164),
(330, 'Cornerstone', 1, 277),
(332, '1st London Toastmasters', 1, 218),
(334, 'Cogito', 1, 179),
(335, 'Belfast', 1, 275),
(337, 'Wexford Toastmasters', 1, 0),
(338, 'State Street Ireland', 2, 0),
(341, 'County Communicators', 2, 0),
(343, 'Cork Leeside Toastmasters', 10, 173),
(344, 'Woodford Green Speakers', 1, 0),
(345, 'Swan Speakers', 2, 221),
(346, 'Advanced Orators', 1, 176),
(347, 'Warrington Toastmasters', 1, 181),
(348, 'Dublin South Toastmasters ', 1, 194),
(377, 'FM Global Communicators', 2, 0),
(376, 'Braintree MAD Toasties', 10, 0),
(353, 'Purley Speakers', 1, 187),
(350, 'Cranfield Speakers', 1, 183),
(349, 'Cupla Focal', 1, 0),
(351, 'Falkirk Orators', 1, 185),
(352, 'PM-CityGate Toastmasters', 2, 16),
(354, 'Division J', 12, 206),
(355, 'Merlin\\''s Mound Toastmasters Club', 10, 188),
(356, 'Ferndown Speakers', 1, 189),
(357, 'Cavan Toastmasters', 1, 0),
(358, 'Salford Speakers', 1, 192),
(359, 'White Rose Speakers', 1, 193),
(360, 'Riverbank Speakers', 2, 244),
(371, 'Pick Everard Present And Speak (PEPS)', 1, 0),
(361, 'State Street Ireland Toastmasters-SJRQ', 2, 0),
(362, 'Elavon Cherrywood', 2, 0),
(363, 'Talk On The Wilde Side', 2, 0),
(364, 'Farnham Speakers Club', 1, 237),
(365, 'Cathedral View Toastmasters', 6, 0),
(366, 'Elavon Arklow', 2, 0),
(367, 'Lakenheath Speakers', 4, 252),
(369, 'Phoenix Speakers', 1, 200),
(372, 'London Public Speakers', 1, 203),
(373, 'Template Club - Do not edit or delete', 1, 208),
(439, 'Portal Practice', 1, 267),
(375, 'Brentwood Speakers Club', 1, 297),
(379, 'Cummins Toastmaster Club', 1, 251),
(380, 'Perth Toastmasters', 1, 220),
(381, 'Knutmasters', 10, 0),
(382, 'Imperial College Speakers', 1, 224),
(396, 'St Mel\\''s College Communications', 6, 0),
(383, 'Cardiff Toastmasters', 1, 225),
(384, 'Russian English Speakers', 1, 226),
(385, 'Society Speakers', 1, 228),
(386, 'Talking Shop', 10, 0),
(388, 'Haymarket Toastmasters', 1, 234),
(387, 'Cardiff Saudi Toastmasters', 10, 233),
(417, 'CharisMedIc Communicators', 2, 248),
(416, 'Croxley Communicators', 2, 247),
(394, 'Area 51', 13, 294),
(395, 'Aberdeen City Speakers', 1, 0),
(397, 'St Patricks/Marymount Toastmasters', 10, 235),
(398, 'EMC Ireland Toastmasters Forum', 2, 236),
(414, 'BlackRock Speaks', 2, 243),
(399, 'Division L', 12, 240),
(400, 'Division K', 12, 242),
(401, 'Division M', 12, 241),
(402, 'Area 52', 13, 260),
(403, 'Area 53', 13, 261),
(404, 'Area 54', 13, 270),
(405, 'Area 55', 13, 0),
(406, 'Area 56', 13, 249),
(407, 'Area 57', 13, 0),
(408, 'Area 58', 13, 0),
(409, 'Area 59', 13, 0),
(413, 'ExxonMobil Leatherhead Toastmasters Club', 2, 0),
(410, 'Uncensored Speakers', 1, 238),
(411, 'Kings Speakers', 1, 262),
(412, 'London Trustmasters', 1, 0),
(418, 'Toastmaster-san', 10, 0),
(419, 'Experience French', 1, 250),
(420, 'Spinnaker Speakers', 1, 255),
(421, 'Donegal', 10, 283),
(422, 'CITI Dublin Speak and Lead', 1, 0),
(425, 'Malvern Speakers', 1, 264),
(423, 'Livingston Speakers', 10, 0),
(424, 'Barclaycard_on_Toast', 10, 0),
(426, 'Citadel Speakers', 10, 0),
(427, 'Hungerford Speakers Club', 10, 0),
(428, 'Caledonian Toastmasters', 1, 0),
(429, 'West Cork Toastmasters', 10, 265),
(-22, 'Area 1', 13, 0),
(-21, 'Division A', 12, 0),
(-20, 'District 99', 11, 0),
(-12, 'Template-Table Topics, Speeches, Evaluation', 1, 0),
(-11, 'Template- Speeches, Evaluation, Table Topics', 1, 0),
(-10, 'Template- Speeches,Table Topics, Evaluation', 1, 0),
(430, 'BofAML London Toastmasters', 2, 266),
(431, 'Division S', 12, 281),
(432, 'Nottingham Robin Hood Speakers Club', 1, 0),
(433, 'Area 60', 13, 0),
(434, 'Area 61', 13, 0),
(435, 'Area 62', 13, 304),
(436, 'Surbiton Speakers Club', 10, 0),
(440, 'BBH London', 1, 268),
(441, 'Clerkenwell Speakers', 1, 269),
(442, 'EI Toastmasters', 1, 272),
(446, 'Speaking Actuaries', 10, 274),
(447, 'Fairfield Speakers', 10, 276),
(448, 'Intel Shannon', 2, 0),
(449, 'RAF Mildenhall', 1, 0),
(450, 'Wokingham Speakers', 1, 0),
(452, 'University of Birmingham', 10, 285),
(454, 'St Andrews Toastmasters', 10, 289),
(456, 'Basingstoke Speakers', 10, 291),
(457, 'London UK Pros Club', 10, 292),
(458, '', 1, 0),
(459, '', 1, 0),
(460, '', 1, 0),
(461, '', 1, 0),
(462, 'Division X', 12, 0),
(463, 'State Street Edinburgh', 10, 299),
(465, 'Plain Speakers', 10, 303),
(467, 'District 18', 11, 0)]

# for id, name, type, cat in dataset_club:
#     print("INSERT INTO `phpbb_tm_club` (`club_name`, `club_status`, `club_number`, `club_type`, `club_open`, `club_sponsor`, `district`, `division`, `area`, `club_contact`, `meeting_day`, `week_1`, `week_2`, `week_3`, `week_4`, `week_5`, `week_l`, `week_a`, `semi_annual`, `club_timezone`, `club_founded`, `club_website`, `club_facebook`, `club_linkedin`, `club_twitter`, `club_youtube`, `club_meetup`, `subdomain`, `club_gplus`, `club_comment`, `club_logo`, `club_members_forum`, `club_members_group`, `club_administer_group`, `cat_id`, `default_time`, `default_location`, `tme_schedules_roles`, `tme_schedules_evaluators`, `ce_schedules_evaluators`, `mm_schedules_speakers`, `allow_users_bb`, `allow_officers_bb`, `allow_users_im`, `allow_users_email`, `allow_users_pm`, `mentors_view_development`, `display_no_shows`, `meeting_auto_visible`, `confirm_attendance`, `users_fill_roles`, `last_changes`, `newest_user`, `club_admin_email`, `club_agenda_email`, `unsubscribe_agenda_email`, `club_dateformat`, `club_dateformat_long`, `club_timeformat`, `new_user_status`, `club_language`, `display_club_stats`, `display_member_stats`, `print_next_meeting`, `next_meeting`, `agenda_format`, `agenda_message`, `use_theme`, `meeting_numbers`, `start_stats_date`, `club_stats_months`, `user_stats_months`, `print_district`, `print_meetings`, `display_task`, `look_ahead`, `refuse_count`, `start_campaign_date`, `use_campaign`, `cl_evaluator`, `use_visitor`, `visitor_status`, `first_speech`, `min_meet_s`, `min_meet_l`, `min_repeat_same`, `min_repeat_l`, `print_attendance`, `alloc_trail`, `sort_speeches`, `top_page`, `org_level`, `map_choice`, `club_closed`, `went_live`, `redirect_id`, `distance`, `local_miles`, `default_page`, `club_css`, `sort_name2`, `show_location`, `show_photo`, `public_charts`, `public_list`, `tme_is_mm`, `mm_edit_agenda`, `users_fill_roles_2`, `users_volunteer_limit`, `valid_email`, `valid_phone`, `valid_officers`, `valid_name`, `valid_incoming`, `new_district`, `new_division`, `new_area`, `club_short_name`, `speech_detail_eval`, `speech_detail_mentor`, `speech_obj_print`, `print_excused`, `meeting_days`, `print_awards`, `public_album`, `signup_sheet`, `last_donated`, `mm_auto_allocate`, `show_awards`, `use_survey`, `use_otm`, `mm_edit_completed`, `use_wotd`, `display_logo`, `advise_speeches`, `club_timezone_name`, `dcp0`, `dcp1`, `dcp2`, `dcp3`, `dcp4`, `dcp5`, `dcp6`, `dcp7`, `dcp8`, `dcp9`, `dcp10`, `dcp_on_agenda`, `paper_size`, `online_meeting_root`, `meta_name`, `meta_content`, `club_GA_property_ID`)",
#           "VALUES ('" + name + "', 0, '0', " + str(type) + ", '', '', 99, '', 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '', '', '', '', '', '', 'district_99', '', 'easy-Speak Toastmasters Automation - testing environment', '', 20, 107, 108, " + str(cat) +", 0, 9, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 608400, 435600, 608400, 0, 0, '[email protected]', '[email protected]', 0, 'd M y', 'l jS F Y', 'H:i', '5', 'english', 0, 0, 0, '3', 'agenda_body_0', '', 0, 0, 39600, 12, 6, 0, 0, 0, 2, 2, 0, 0, 0, 0, '5', 2, 1, 5, 4, 4, 1, 1, 0, 2, 11, 0, '', 1212235200, 0, 1, 60, 28, 1, 0, 1, 1, 0, 1, 0, 2, 0, 0, 7, 0, 7, 7, 0, 99, '', 0, 'District 99', 2, 2, 3, 0, '', 0, 1, 0, 0, 1, 1, 0, 0, 1, 1, 1, 1, '', '', '', '', '', '', '', '', '', '', '', '', 2, NULL, '', '', '', '');")


# INSERT INTO `dataset_cats` (`cat_id`, `cat_title`, `cat_parent`) VALUES
# for id, title, parent in dataset_cats:
#     print("INSERT INTO `phpbb_album_cat` (`cat_id`, `cat_title`, `cat_desc`, `cat_order`, `cat_parent`, `cat_view_level`, `cat_upload_level`, `cat_rate_level`, `cat_comment_level`, `cat_edit_level`, `cat_delete_level`, `cat_view_groups`, `cat_upload_groups`, `cat_rate_groups`, `cat_comment_groups`, `cat_edit_groups`, `cat_delete_groups`, `cat_moderator_groups`, `cat_approval`, `notify_status`, `notify_user`, `notify_once`, `is_tm_cat`) ",
#     "VALUES(" + str(id) + ", '" + title + "', '" + title + "', 10, " + str(parent) + ", -1, 0, 1, 3, 2, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 0, 82, 1, 7);")

# INSERT INTO `dataset_album` (`pic_id`, `pic_cat_id`) VALUES

images = os.listdir(os.path.expanduser('~/easy-speak/website/album_mod/upload/cache'))

for id, cat_id in dataset_album:
    image = random.choice(images)
    print("INSERT INTO `phpbb_album` (`pic_id`, `pic_filename`, `pic_thumbnail`, `pic_title`, `pic_desc`, `pic_user_id`, `pic_username`, `pic_user_ip`, `pic_time`, `pic_cat_id`, `pic_view_count`, `pic_lock`, `pic_approval`) ",
          "VALUES(" + str(id) + ", '" + image+ "', '" + image+ "', 'Test image', '', 128, 'malw', '52456178', 1253871042, " + str(cat_id)+ ", 22, 1, 1);")