codice:
--
-- Dump dei dati per la tabella `partita`
--
INSERT INTO `partita` (`ID_partita`, `data_partita`, `sq_casa`, `sq_fuori`, `goal_c`, `goal_f`) VALUES
(347, '2011-02-06', 22, 6, NULL, NULL),
(346, '2010-10-24', 6, 22, NULL, NULL),
(345, '2011-01-30', 17, 27, NULL, NULL),
(344, '2010-10-17', 27, 17, NULL, NULL),
(343, '2011-01-30', 23, 26, NULL, NULL),
(342, '2010-10-17', 26, 23, NULL, NULL),
(341, '2011-01-30', 3, 18, NULL, NULL),
(340, '2010-10-17', 18, 3, NULL, NULL),
(339, '2011-01-30', 21, 25, NULL, NULL),
(338, '2010-10-17', 25, 21, NULL, NULL),
(337, '2011-01-30', 6, 24, NULL, NULL),
(336, '2010-10-17', 24, 6, NULL, NULL),
(335, '2011-01-30', 19, 20, NULL, NULL),
(334, '2010-10-17', 20, 19, NULL, NULL),
(333, '2011-01-30', 1, 22, NULL, NULL),
(332, '2010-10-17', 22, 1, NULL, NULL),
(331, '2011-01-23', 18, 23, NULL, NULL),
(330, '2010-10-10', 23, 18, NULL, NULL),
(329, '2011-01-23', 27, 19, NULL, NULL),
(328, '2010-10-10', 19, 27, NULL, NULL),
(327, '2011-01-23', 26, 21, NULL, NULL),
(326, '2010-10-10', 21, 26, NULL, NULL),
(325, '2011-01-23', 22, 3, NULL, NULL),
(324, '2010-10-10', 3, 22, NULL, NULL),
(323, '2011-01-23', 24, 1, NULL, NULL),
(322, '2010-10-10', 1, 24, NULL, NULL),
(321, '2011-01-23', 20, 6, NULL, NULL),
(320, '2010-10-10', 6, 20, NULL, NULL),
(319, '2011-01-23', 25, 17, NULL, NULL),
(318, '2010-10-10', 17, 25, NULL, NULL),
(317, '2011-01-16', 25, 27, NULL, NULL),
(316, '2010-10-03', 27, 25, NULL, NULL),
(315, '2011-01-16', 17, 26, NULL, NULL),
(314, '2010-10-03', 26, 17, NULL, NULL),
(313, '2011-01-16', 21, 18, NULL, NULL),
(312, '2010-10-03', 18, 21, NULL, NULL),
(311, '2011-01-16', 3, 24, NULL, NULL),
(310, '2010-10-03', 24, 3, NULL, NULL),
(309, '2011-01-16', 1, 20, NULL, NULL),
(308, '2010-10-03', 20, 1, NULL, NULL),
(307, '2011-01-16', 23, 22, NULL, NULL),
(306, '2010-10-03', 22, 23, NULL, NULL),
(305, '2011-01-16', 6, 19, NULL, NULL),
(304, '2010-10-03', 19, 6, NULL, NULL),
(303, '2011-01-09', 26, 25, NULL, NULL),
(302, '2010-09-26', 25, 26, NULL, NULL),
(301, '2011-01-09', 24, 23, NULL, NULL),
(300, '2010-09-26', 23, 24, NULL, NULL),
(299, '2011-01-09', 22, 21, NULL, NULL),
(298, '2010-09-26', 21, 22, NULL, NULL),
(297, '2011-01-09', 20, 3, NULL, NULL),
(296, '2010-09-26', 3, 20, NULL, NULL),
(295, '2011-01-09', 19, 1, NULL, NULL),
(294, '2010-09-26', 1, 19, NULL, NULL),
(293, '2011-01-09', 27, 6, NULL, NULL),
(292, '2010-09-26', 6, 27, NULL, NULL),
(291, '2011-01-09', 18, 17, NULL, NULL),
(290, '2010-09-26', 17, 18, NULL, NULL),
(184, '2010-05-02', 5, 8, 2, 2),
(183, '2010-05-02', 7, 14, 3, 1),
(182, '2010-05-02', 9, 3, 3, 3),
(181, '2010-05-02', 13, 10, 0, 2),
(180, '2010-05-02', 4, 1, 1, 6),
(179, '2010-05-02', 2, 12, 3, 0),
(178, '2010-05-02', 11, 6, 0, 1),
(177, '2010-04-25', 9, 13, 3, 2),
(176, '2010-04-25', 8, 11, 0, 2),
(175, '2010-04-25', 12, 4, 3, 0),
(174, '2010-04-25', 6, 2, 3, 2),
(173, '2010-04-25', 10, 7, 3, 1),
(172, '2010-04-25', 14, 5, 2, 2),
(171, '2010-04-25', 3, 1, 0, 1),
(170, '2010-04-18', 2, 8, 2, 0),
(169, '2010-04-18', 7, 9, 2, 1),
(168, '2010-04-18', 11, 14, 5, 0),
(167, '2010-04-18', 13, 3, 2, 5),
(166, '2010-04-18', 5, 10, 2, 1),
(165, '2010-04-18', 1, 12, 4, 0),
(164, '2010-04-18', 4, 6, 1, 4),
(163, '2010-04-11', 10, 11, 0, 1),
(162, '2010-04-11', 8, 4, 5, 2),
(161, '2010-04-11', 14, 2, 0, 1),
(160, '2010-04-11', 13, 7, 1, 5),
(159, '2010-04-11', 9, 5, 1, 0),
(158, '2010-04-11', 6, 1, 0, 1),
(157, '2010-04-11', 3, 12, 4, 1),
(156, '2010-03-28', 1, 8, 6, 0),
(155, '2010-03-28', 5, 13, 3, 1),
(154, '2010-03-28', 11, 9, 4, 1),
(153, '2010-03-28', 4, 14, 3, 0),
(152, '2010-03-28', 7, 3, 1, 2),
(151, '2010-03-28', 2, 10, 3, 1),
(150, '2010-03-28', 12, 6, 0, 2),
(149, '2010-03-21', 13, 11, 0, 2),
(148, '2010-03-21', 10, 4, 3, 1),
(147, '2010-03-21', 9, 2, 1, 2),
(146, '2010-03-21', 7, 5, 1, 1),
(145, '2010-03-21', 14, 1, 1, 3),
(144, '2010-03-21', 8, 12, 1, 2),
(143, '2010-03-21', 3, 6, 3, 0),
(142, '2010-03-14', 6, 8, 2, 0),
(141, '2010-03-14', 2, 13, 7, 1),
(140, '2010-03-14', 4, 9, 2, 1),
(139, '2010-03-14', 12, 14, 4, 0),
(138, '2010-03-14', 11, 7, 3, 1),
(137, '2010-03-14', 5, 3, 1, 3),
(136, '2010-03-14', 1, 10, 4, 0),
(135, '2010-03-07', 3, 8, 5, 0),
(134, '2010-03-07', 5, 11, 2, 0),
(133, '2010-03-07', 13, 4, 3, 2),
(132, '2010-03-07', 7, 2, 0, 2),
(131, '2010-03-07', 9, 1, 1, 3),
(130, '2010-03-07', 10, 12, 2, 2),
(129, '2010-03-07', 14, 6, 0, 2),
(128, '2010-02-28', 1, 13, 7, 1),
(127, '2010-02-28', 12, 9, 3, 2),
(126, '2010-02-28', 8, 14, 0, 3),
(125, '2010-02-28', 4, 7, 0, 1),
(124, '2010-02-28', 2, 5, 2, 1),
(123, '2010-02-28', 11, 3, 3, 2),
(122, '2010-02-28', 6, 10, 4, 0),
(121, '2010-02-21', 10, 8, 0, 0),
(120, '2010-02-21', 5, 4, 0, 0),
(119, '2010-02-21', 3, 14, 3, 1),
(118, '2010-02-21', 11, 2, 3, 3),
(117, '2010-02-21', 7, 1, 1, 1),
(116, '2010-02-21', 13, 12, 0, 4),
(115, '2010-02-21', 9, 6, 0, 2),
(114, '2010-02-14', 6, 13, 6, 0),
(113, '2010-02-14', 4, 11, 2, 8),
(112, '2010-02-14', 8, 9, 1, 3),
(111, '2010-02-14', 12, 7, 1, 1),
(110, '2010-02-14', 1, 5, 1, 1),
(109, '2010-02-14', 2, 3, 1, 1),
(108, '2010-02-14', 14, 10, 1, 3),
(107, '2010-02-07', 13, 8, 1, 2),
(106, '2010-02-07', 2, 4, 2, 0),
(105, '2010-02-07', 9, 14, 3, 1),
(104, '2010-02-07', 3, 10, 2, 3),
(103, '2010-02-07', 11, 1, 0, 1),
(102, '2010-02-07', 5, 12, 1, 3),
(101, '2010-02-07', 7, 6, 4, 4),
(100, '2010-01-31', 14, 13, 2, 0),
(99, '2010-01-31', 12, 11, 0, 3),
(98, '2010-01-31', 10, 9, 2, 1),
(97, '2010-01-31', 1, 2, 2, 1),
(96, '2010-01-31', 8, 7, 0, 5),
(95, '2010-01-31', 6, 5, 2, 2),
(94, '2010-01-31', 4, 3, 2, 4),
(93, '2010-01-17', 8, 5, 2, 3),
(92, '2010-01-17', 14, 7, 0, 2),
(91, '2010-01-17', 3, 9, 2, 0),
(90, '2010-01-17', 10, 13, 0, 0),
(89, '2010-01-17', 1, 4, 4, 0),
(88, '2010-01-17', 12, 2, 3, 2),
(87, '2010-01-17', 6, 11, 3, 2),
(86, '2010-01-10', 13, 9, 2, 3),
(85, '2010-01-10', 11, 8, 5, 2),
(84, '2010-01-10', 4, 12, 0, 6),
(83, '2010-01-10', 2, 6, 2, 2),
(82, '2010-01-10', 7, 10, 2, 1),
(81, '2010-01-10', 5, 14, 4, 1),
(80, '2010-01-10', 1, 3, 1, 0),
(79, '2009-12-20', 8, 2, 2, 4),
(78, '2009-12-20', 9, 7, 1, 4),
(77, '2009-12-20', 14, 11, 1, 3),
(76, '2009-12-20', 3, 13, 4, 0),
(75, '2009-12-20', 10, 5, 4, 1),
(74, '2009-12-20', 12, 1, 2, 2),
(73, '2009-12-20', 6, 4, 1, 0),
(72, '2009-12-13', 11, 10, 4, 2),
(71, '2009-12-13', 4, 8, 3, 2),
(70, '2009-12-13', 2, 14, 1, 0),
(69, '2009-12-13', 7, 13, 5, 0),
(68, '2009-12-13', 5, 9, 4, 2),
(67, '2009-12-13', 1, 6, 1, 3),
(66, '2009-12-13', 12, 3, 1, 0),
(65, '2009-12-06', 8, 1, 1, 1),
(64, '2009-12-06', 13, 5, 1, 1),
(63, '2009-12-06', 9, 11, 0, 3),
(62, '2009-12-06', 14, 4, 0, 3),
(61, '2009-12-06', 3, 7, 2, 1),
(60, '2009-12-06', 10, 2, 1, 4),
(59, '2009-12-06', 6, 12, 1, 0),
(58, '2009-11-29', 11, 13, 0, 0),
(57, '2009-11-29', 4, 10, 3, 2),
(56, '2009-11-29', 2, 9, 2, 1),
(55, '2009-11-29', 5, 7, 0, 4),
(54, '2009-11-29', 1, 14, 4, 0),
(53, '2009-11-29', 12, 8, 1, 0),
(52, '2009-11-29', 6, 3, 3, 0),
(51, '2009-11-22', 8, 6, 0, 3),
(50, '2009-11-22', 13, 2, 2, 4),
(49, '2009-11-22', 9, 4, 2, 1),
(48, '2009-11-22', 14, 12, 0, 3),
(47, '2009-11-22', 7, 11, 2, 0),
(46, '2009-11-22', 3, 5, 2, 1),
(45, '2009-11-22', 10, 1, 0, 4),
(44, '2009-11-15', 8, 3, 0, 2),
(43, '2009-11-15', 4, 13, 1, 2),
(42, '2009-11-15', 11, 5, 3, 1),
(41, '2009-11-15', 2, 7, 1, 0),
(40, '2009-11-15', 1, 9, 1, 0),
(39, '2009-11-15', 12, 10, 5, 1),
(38, '2009-11-15', 6, 14, 2, 1),
(37, '2009-11-08', 13, 1, 2, 2),
(36, '2009-11-08', 9, 12, 1, 4),
(35, '2009-11-08', 14, 8, 0, 1),
(34, '2009-11-08', 7, 4, 6, 0),
(33, '2009-11-08', 5, 2, 2, 3),
(32, '2009-11-08', 3, 11, 0, 0),
(31, '2009-11-08', 10, 6, 0, 2),
(30, '2009-11-01', 8, 10, 2, 2),
(29, '2009-11-01', 4, 5, 2, 4),
(28, '2009-11-01', 14, 3, 0, 1),
(27, '2009-11-01', 2, 11, 0, 0),
(26, '2009-11-01', 1, 7, 3, 2),
(25, '2009-11-01', 12, 13, 2, 1),
(24, '2009-11-01', 6, 9, 1, 0),
(23, '2009-10-25', 13, 6, 0, 5),
(22, '2009-10-25', 11, 4, 3, 0),
(21, '2009-10-25', 9, 8, 2, 4),
(20, '2009-10-25', 7, 12, 2, 0),
(19, '2009-10-25', 5, 1, 1, 1),
(18, '2009-10-25', 3, 2, 5, 0),
(17, '2009-10-25', 10, 14, 3, 1),
(16, '2009-10-18', 8, 13, 1, 3),
(15, '2009-10-18', 4, 2, 3, 3),
(14, '2009-10-18', 14, 9, 3, 1),
(13, '2009-10-18', 10, 3, 4, 5),
(12, '2009-10-18', 1, 11, 2, 1),
(11, '2009-10-18', 12, 5, 2, 1),
(10, '2009-10-18', 6, 7, 1, 1),
(9, '2009-10-11', 13, 14, 1, 1),
(8, '2009-10-11', 11, 12, 2, 2),
(7, '2009-10-11', 2, 1, 0, 1),
(6, '2009-10-11', 9, 10, 1, 1),
(5, '2009-10-11', 7, 8, 4, 0),
(3, '2009-10-11', 3, 4, 4, 0),
(4, '2009-10-11', 5, 6, 1, 2),
(375, '2011-02-20', 26, 6, NULL, NULL),
(374, '2010-11-07', 6, 26, NULL, NULL),
(373, '2011-02-13', 21, 27, NULL, NULL),
(372, '2010-10-31', 27, 21, NULL, NULL),
(371, '2011-02-13', 1, 26, NULL, NULL),
(370, '2010-10-31', 26, 1, NULL, NULL),
(369, '2011-02-13', 6, 18, NULL, NULL),
(368, '2010-10-31', 18, 6, NULL, NULL),
(367, '2011-02-13', 3, 25, NULL, NULL),
(366, '2010-10-31', 25, 3, NULL, NULL),
(365, '2011-02-13', 20, 24, NULL, NULL),
(364, '2010-10-31', 24, 20, NULL, NULL),
(363, '2011-02-13', 19, 22, NULL, NULL),
(362, '2010-10-31', 22, 19, NULL, NULL),
(361, '2011-02-13', 23, 17, NULL, NULL),
(360, '2010-10-31', 17, 23, NULL, NULL),
(359, '2011-02-06', 25, 23, NULL, NULL),
(358, '2010-10-24', 23, 25, NULL, NULL),
(357, '2011-02-06', 27, 20, NULL, NULL),
(356, '2010-10-24', 20, 27, NULL, NULL),
(355, '2011-02-06', 24, 19, NULL, NULL),
(354, '2010-10-24', 19, 24, NULL, NULL),
(353, '2011-02-06', 17, 21, NULL, NULL),
(352, '2010-10-24', 21, 17, NULL, NULL),
(351, '2011-02-06', 26, 3, NULL, NULL),
(350, '2010-10-24', 3, 26, NULL, NULL),
(381, '2011-02-20', 18, 19, 2, 3),
(380, '2010-11-07', 19, 18, NULL, NULL),
(379, '2011-02-20', 17, 3, NULL, NULL),
(378, '2010-11-07', 3, 17, NULL, NULL),
(377, '2011-02-20', 25, 1, NULL, NULL),
(376, '2010-11-07', 1, 25, NULL, NULL),
(349, '2011-02-06', 18, 1, NULL, NULL),
(348, '2010-10-24', 1, 18, NULL, NULL),
(382, '2010-11-07', 20, 22, NULL, NULL),
(383, '2011-02-20', 22, 20, NULL, NULL),
(384, '2010-11-07', 24, 27, NULL, NULL),
(385, '2011-02-20', 27, 24, NULL, NULL),
(386, '2010-11-07', 23, 21, NULL, NULL),
(387, '2011-02-20', 21, 23, NULL, NULL),
(388, '2010-11-14', 17, 1, NULL, NULL),
(389, '2011-02-27', 1, 17, NULL, NULL),
(390, '2010-11-14', 21, 3, NULL, NULL),
(391, '2011-02-27', 3, 21, NULL, NULL),
(392, '2010-11-14', 22, 24, NULL, NULL),
(393, '2011-02-27', 24, 22, NULL, NULL),
(394, '2010-11-14', 25, 6, NULL, NULL),
(395, '2011-02-27', 6, 25, NULL, NULL),
(396, '2010-11-14', 18, 20, NULL, NULL),
(397, '2011-02-27', 20, 18, NULL, NULL),
(398, '2010-11-14', 26, 19, NULL, NULL),
(399, '2011-02-27', 19, 26, NULL, NULL),
(400, '2010-11-14', 27, 23, NULL, NULL),
(401, '2011-02-27', 23, 27, NULL, NULL),
(402, '2010-11-21', 6, 17, NULL, NULL),
(403, '2011-03-06', 17, 6, NULL, NULL),
(404, '2010-11-21', 1, 21, NULL, NULL),
(405, '2011-03-06', 21, 1, NULL, NULL),
(406, '2010-11-21', 3, 23, NULL, NULL),
(407, '2011-03-06', 23, 3, NULL, NULL),
(408, '2010-11-21', 19, 25, NULL, NULL),
(409, '2011-03-06', 25, 19, NULL, NULL),
(410, '2010-11-21', 22, 27, NULL, NULL),
(411, '2011-03-06', 27, 22, NULL, NULL),
(412, '2010-11-21', 20, 26, NULL, NULL),
(413, '2011-03-06', 26, 20, NULL, NULL),
(414, '2010-11-21', 24, 18, NULL, NULL),
(415, '2011-03-06', 18, 24, NULL, NULL),
(416, '2010-11-28', 17, 19, NULL, NULL),
(417, '2011-03-13', 19, 17, NULL, NULL),
(418, '2010-11-28', 21, 6, NULL, NULL),
(419, '2011-03-13', 6, 21, NULL, NULL),
(420, '2010-11-28', 23, 1, NULL, NULL),
(421, '2011-03-13', 1, 23, NULL, NULL),
(422, '2010-11-28', 25, 20, NULL, NULL),
(423, '2011-03-13', 20, 25, NULL, NULL),
(424, '2010-11-28', 18, 22, NULL, NULL),
(425, '2011-03-13', 22, 18, NULL, NULL),
(426, '2010-11-28', 26, 24, NULL, NULL),
(427, '2011-03-13', 24, 26, NULL, NULL),
(428, '2010-11-28', 27, 3, NULL, NULL),
(429, '2011-03-13', 3, 27, NULL, NULL),
(430, '2010-12-05', 6, 23, NULL, NULL),
(431, '2011-03-20', 23, 6, NULL, NULL),
(432, '2010-12-05', 1, 3, NULL, NULL),
(433, '2011-03-20', 3, 1, NULL, NULL),
(434, '2010-12-05', 19, 21, NULL, NULL),
(435, '2011-03-20', 21, 19, NULL, NULL),
(436, '2010-12-05', 22, 26, NULL, NULL),
(437, '2011-03-20', 26, 22, NULL, NULL),