Teste listagem, MySQL

Teste listagem

-- Dumping structure for table offcrono_offcrono.104Caixas
CREATE TABLE IF NOT EXISTS `104Caixas` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `codigo` int(11) DEFAULT NULL,
  `posicao` int(11) DEFAULT NULL,
  `id_prova` int(11) DEFAULT NULL,
  `nome_prova` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `caixa_classificativa` tinyint(1) DEFAULT '1',
  `deleted` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `104CaixasNome` (
	`id` INT(11) UNSIGNED NOT NULL,
	`nome` VARCHAR(20) NULL COLLATE 'utf8_unicode_ci',
	`codigo` INT(11) NULL,
	`posicao` INT(11) NULL,
	`id_prova` INT(11) NULL,
	`nome_prova` VARCHAR(50) NULL COLLATE 'utf8_unicode_ci',
	`caixa_classificativa` TINYINT(1) NULL,
	`deleted` TINYINT(1) NULL
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `104Checkins` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `caixa` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `chip` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data` date NOT NULL,
  `hora` time NOT NULL,
  `desistiu` tinyint(1) DEFAULT '0',
  `nota` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `104Chegadas` (
  `id_ch` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `caixa_ch` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `chip_ch` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data_ch` date NOT NULL,
  `hora_ch` time NOT NULL,
  `nome_prova_ch` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `posicao_geral_ch` int(10) DEFAULT NULL,
  PRIMARY KEY (`id_ch`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `104Classificacoes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `equipa` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dorsal` int(5) DEFAULT NULL,
  `id_escalao` int(5) NOT NULL DEFAULT '0',
  `nome_prova` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `escalao` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `tempo` time DEFAULT NULL,
  `pos_geral` int(5) DEFAULT NULL,
  `pos_escalao` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=116 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping structure for table offcrono_offcrono.104Escaloes
CREATE TABLE IF NOT EXISTS `104Escaloes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_prova` int(11) DEFAULT NULL,
  `nome_prova` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nome` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sexo` enum('M','F') COLLATE utf8_unicode_ci DEFAULT NULL,
  `idd_min` int(3) DEFAULT NULL,
  `idd_max` int(3) DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `104Tempos` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_origem` int(11) DEFAULT NULL,
  `caixa` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `chip` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data` date NOT NULL,
  `hora` time(2) NOT NULL,
  `nome_prova` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `posicao_geral` int(10) DEFAULT NULL,
  `volta` smallint(3) DEFAULT NULL,
  `motivo` varchar(35) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=112 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `104Inscricoes` (
  `id_inscricao` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nome_completo` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nome_dorsal` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `equipa` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data_nasc` date DEFAULT NULL,
  `sexo` enum('M','F') COLLATE utf8_unicode_ci DEFAULT NULL,
  `telemovel` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `localidade` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `codigo_postal` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nif` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tshirt` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `refeicao` int(11) DEFAULT NULL,
  `pago` tinyint(1) DEFAULT '0',
  `nome_prova_insc` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dh_inscricao` datetime DEFAULT NULL,
  `dorsal` int(11) DEFAULT '0',
  `chip` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dh_par` datetime DEFAULT NULL,
  `comentarios` text COLLATE utf8_unicode_ci,
  `campo1` varchar(35) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id_inscricao`)
) ENGINE=MyISAM AUTO_INCREMENT=120 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `104opcoesInscricao` (
  `id_opcaoinscricao` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `idopcao` int(11) DEFAULT NULL,
  `nome` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `opcao` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `valoropcao` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `idinscricao` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_opcaoinscricao`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `104Provas` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data` date DEFAULT NULL,
  `hora` time DEFAULT NULL,
  `nr_caixas` int(11) DEFAULT NULL,
  `valor_prova` decimal(8,2) DEFAULT NULL,
  `valor_prova_agravado` decimal(8,2) DEFAULT NULL,
  `dorsal_min` int(11) DEFAULT '0',
  `dorsal_max` int(11) DEFAULT '0',
  `deleted` tinyint(1) DEFAULT '0',
  `data_limite_insc` date DEFAULT NULL,
  `data_agrav_insc` date DEFAULT NULL,
  `data_agrav_insc1` date DEFAULT NULL,
  `data_agrav_insc2` date DEFAULT NULL,
  `valor_prova_agravado1` decimal(8,2) DEFAULT NULL,
  `valor_prova_agravad2` decimal(8,2) DEFAULT NULL,
  `nummaxinsc` int(11) DEFAULT '9999',
  `ativa` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT IGNORE INTO `104Caixas` (`id`, `nome`, `codigo`, `posicao`, `id_prova`, `nome_prova`, `caixa_classificativa`, `deleted`) VALUES
	(1, 'Check-In', 1, 1, 1, 'Resistencia', 1, 0),
	(2, 'Meta', 2, 2, 1, 'Resistencia', 1, 0);
    
INSERT IGNORE INTO `104Escaloes` (`id`, `id_prova`, `nome_prova`, `nome`, `sexo`, `idd_min`, `idd_max`, `deleted`) VALUES
	(1, 1, 'Resistencia', 'Juniores M', 'M', 12, 19, 0),
	(2, 1, 'Resistencia', 'Elite M', 'M', 20, 29, 0),
	(3, 1, 'Resistencia', 'Vet A Masc', 'M', 30, 39, 0),
	(4, 1, 'Resistencia', 'Vet B Masc', 'M', 40, 49, 0),
	(5, 1, 'Resistencia', 'Vet C Masc', 'M', 50, 99, 0),
	(6, 1, 'Resistencia', 'Feminino', 'F', 12, 99, 0);

INSERT IGNORE INTO `104Inscricoes` (`id_inscricao`, `nome_completo`, `nome_dorsal`, `equipa`, `data_nasc`, `sexo`, `telemovel`, `email`, `localidade`, `codigo_postal`, `nif`, `tshirt`, `refeicao`, `pago`, `nome_prova_insc`, `dh_inscricao`, `dorsal`, `chip`, `dh_par`, `comentarios`, `campo1`) VALUES
	(95, 'Luis Miguel peixinho crespo', 'Luís Crespo', '', '1981-08-02', 'M', '918401616', 'luiscrespo81@sapo.pt', 'Torres Novas', '2350', '224184130', '', 0, 1, 'Resistencia', '2016-05-16 19:22:11', 85, '2189', NULL, NULL, ''),
	(2, 'Artur Lopes', 'Artur Lopes', 'CCTEAM/100 limites', '1969-08-28', 'M', '917593939', 'ricardocustodio-1984@hotmail.com', 'Covão do Coelho', '2395', '444', '', 0, 1, 'Resistencia', '2016-02-27 23:23:17', 1, '1446', NULL, '', ''),
	(3, 'Leandro Castanheira simoes', 'Lelo ', 'CCTEAM/100 limites', '1998-06-26', 'M', '912623093', 'leandro_simoes_26@hotmail.com', 'Covão do coelho ', '2395-027', '236445707', '', 0, 0, 'Resistencia', '2016-02-28 15:04:58', 0, NULL, NULL, '', ''),
	(4, 'Luis Miguel Pereira Farinha', 'Luis Farinha', 'Farinhabiketeam', '1979-06-26', 'M', '914920288', 'Luisfarinha-bife@hotmail.com', 'Minde', '2395-164', '222624205', '', 0, 1, 'Resistencia', '2016-02-28 22:53:42', 2, '2356', NULL, NULL, ''),
	(5, 'João Manuel da conceição brito', 'João Brito', 'StandTransBrito', '1970-06-07', 'M', '919549464', 'ricardocustodio-1984@hotmail.com', 'Brancas', '2440-097', '195896750', '', 0, 1, 'Resistencia', '2016-02-29 14:29:54', 3, '2106', NULL, NULL, ''),
	(8, 'Fábio Gojrão Carreira', 'Gorjão', '', '1988-06-04', 'M', '938274959', 'fgorjaoc@gmail.com', 'Minde', '2395-146 Minde', '258079932', '', 0, 0, 'Resistencia', '2016-03-03 19:06:44', 0, NULL, NULL, NULL, ''),
	(7, 'Carlos Morgado', 'Pisco', '', '1986-12-06', 'M', '918924916', 'C428morgado@hotmail.com', 'Minde', '2395-121', '242654509', '', 0, 1, 'Resistencia', '2016-03-03 12:54:00', 4, '2107', NULL, NULL, ''),
	(9, 'Bruno Miguel Pereira Farinha', 'Bruno Farinha', 'Farinhabiketeam', '1983-08-17', 'M', '916719148', 'brunofarinha@iol.pt', 'Minde', '2395-164', '235455199', '', 0, 1, 'Resistencia', '2016-03-03 19:33:09', 5, '2108', NULL, NULL, ''),
	(10, 'Sergio Castanheira ', 'Sergio Castanheira', 'CCTEAM/100 limites', '1978-07-20', 'M', '937122156', 'like.com.pt@gmail.com', 'Covão do Coelho', '2395-019', '215969782', '', 0, 1, 'Resistencia', '2016-03-05 00:36:52', 6, '', NULL, NULL, ''),
	(11, 'octávio Miguel Dos santos Ferreira', 'Octávio Ferreira ', 'Uma Qualquer - Portelabike', '1980-04-15', 'M', '919816058', 'octaviomferreira@gmail.com', 'Marinha Grande', '2430-366', '219544611', '', 0, 0, 'Resistencia', '2016-03-05 10:25:26', 0, NULL, NULL, NULL, ''),
	(12, 'Nuno Miuel de Jesus Ceia', 'Nuno Ceia', 'My Team', '1974-03-11', 'M', '934732841', 'nmceia@mail.com', 'mira de Aire', '2485-147', '208629726', '', 0, 1, 'Resistencia', '2016-03-05 20:57:53', 7, '2110', NULL, NULL, ''),
	(13, 'Ricardo Gomes da Silva', 'Ricardo Silva', 'Fátima Btt/Desarfate/Transfor', '1977-07-03', 'M', '919970540', 'Fatimabttclub@hotmail.com', 'Fatima', '2495', '217201113', '', 0, 1, 'Resistencia', '2016-03-11 10:31:48', 8, '2111', NULL, NULL, ''),
	(115, 'Teresa Maria Vieira Carvalho', 'Teresa Carvalho', '', '1970-08-23', 'F', '912589579', 'ricardocustodio-1984@hotmail.com', NULL, NULL, '198741746', NULL, NULL, 2, 'Resistencia', '2016-05-19 23:16:56', 104, '2208', NULL, '', NULL),
	(15, 'Filipe ferreira faria', 'Filipe Faria', 'Delta D\'Aire BTT', '1988-10-02', 'M', '917978265', 'fffaria12@gmail.com', 'Torres Novas', '2350-522', '248320750', '', 0, 1, 'Resistencia', '2016-03-16 22:11:50', 9, '2112', NULL, NULL, ''),
	(16, 'paulo jorge  santos', 'Paulo', 'CCTEAM/100 limites', '1975-09-10', 'M', '917446434', 'pajo75@hotmail.com', 'Vale-Alto', '2395-333', '207490368', '', 0, 1, 'Resistencia', '2016-03-18 16:46:21', 10, '2113', NULL, NULL, ''),
	(17, 'Afonso Miguel Fernandes Major', 'MAJOR', 'ADN BikersTrailFinder', '1998-11-17', 'M', '914348571', 'majorafonso@hotmail.com', 'Covão do Coelho', '2395-013', '255633351', '', 0, 1, 'Resistencia', '2016-03-21 22:58:37', 11, '2114', NULL, NULL, ''),
	(18, 'nelson filipe calado oliveira', 'Nelson Oliveira', '', '1983-12-28', 'M', '918181671', 'andriamatias@iol.pt', 'minde', '2395-147 minde', '237624630', '', 0, 1, 'Resistencia', '2016-03-22 11:08:06', 12, '2115', NULL, NULL, ''),
	(19, 'Sérgio Pereira Costa Santos', 'Sérgio Santos', 'CCTEAM/100 limites', '1977-07-01', 'M', '918340558', 'neira77@gmail.com', 'Vale Alto', '2395-333', '219433577', '', 0, 1, 'Resistencia', '2016-03-23 22:42:07', 13, '2116', NULL, NULL, ''),
	(20, 'Gabriela Ferreira  castanheira ', 'Gabizona', 'CCTEAM/100 limites', '1990-01-02', 'F', '919953878', 'gabrielaferreiracastanheira@gmail.com', 'Covão do coelho ', '2395', '232765421', '', 0, 1, 'Resistencia', '2016-03-27 00:48:18', 14, '2117', NULL, NULL, ''),
	(21, 'Paulo Alexandre Azevedo Damica', 'Paulo Damica', 'MTB - Mirense Trilhos e Bikes', '1982-04-12', 'M', '915478546', 'Paulo.damica@hotmail.com', 'mira de aire', '2485 mira de aire', '225419700', '', 0, 1, 'Resistencia', '2016-04-03 16:15:16', 15, '2118', NULL, NULL, ''),
	(22, 'Roberto Amorin Luis', 'Roberto', 'CCTEAM/1000 limites', '1976-04-07', 'M', '914820826', 'btt100limites@hotmail.com', 'Vale -Alto', '2395-332', '240831101', '', 0, 1, 'Resistencia', '2016-04-03 19:24:14', 16, '2119', NULL, NULL, ''),
	(23, 'Eugenio Santos Gonçalves', 'Eugenio', 'CCTEAM/100 limites', '1980-08-27', 'M', '917032306', 'btt100limites@hotmail.com', 'Vale-Alto', '2395-023', '223163856', '', 0, 1, 'Resistencia', '2016-04-03 19:32:35', 17, '2120', NULL, NULL, ''),
	(24, 'Gil Lopes ', 'Gil Lopes', 'CCTEAM/100 limites', '1976-05-01', 'M', '919557706', 'btt100limites@hotmail.com', 'Vale-Alto', '2395-326', '203744519', '', 0, 1, 'Resistencia', '2016-04-03 19:45:55', 18, '2121', NULL, NULL, ''),
	(25, 'Miguel Martinho', 'Miguel Martinho', 'BTT CRC MALHOUESE', '1996-08-07', 'M', '919051382', 'miguelbikes@gmail.com', 'Malhou', '2380-536', '226470687', '', 0, 1, 'Resistencia', '2016-04-05 09:39:22', 19, '2122', NULL, NULL, ''),
	(26, 'Hugo Alexandre Carvalho Fortunato ', '#SUSANAestética ', 'MTB - Mirense Trilhos e Bikes', '1983-11-22', 'M', '913351630', 'Hugobuzz10@gmail.com', 'Mira de Aire', '2485-011', '230812287', '', 0, 1, 'Resistencia', '2016-04-06 20:41:30', 20, '2123', NULL, NULL, ''),
	(27, 'Horacio Luis Cruz Elias', 'Flecha 76', 'Flecha 76', '1976-01-30', 'M', '914709007', 'sabrinavieira78@hotmail.com', 'Amiais de Baixo', '2025-342 Amiais de Baixo', '203716566', '', 0, 1, 'Resistencia', '2016-04-08 16:45:36', 21, '2124', NULL, NULL, ''),
	(28, 'HENRIQUE MANUEL FORTUNATO CARVALHO', 'HENRIQUE CARVALHO', 'MTB - Mirense Trilhos e Bikes', '1969-03-08', 'M', '919414341', 'HENRIQUE.FORTUNATO.CARVALHO@HOTMAIL.COM', 'MIRA DE AIRE', '2485-012', '177727594', '', 0, 1, 'Resistencia', '2016-04-12 20:54:01', 22, '2125', NULL, NULL, ''),
	(29, 'João Vieira dos Santos Pinto', 'João Pinto', 'MTB - Mirense Trilhos e Bikes', '1986-01-07', 'M', '912774667', 'joao_xc_pinto@hotmail.com', 'Mira de Aire', '2485-215', '248728970', '', 0, 1, 'Resistencia', '2016-04-13 17:43:17', 23, '2126', NULL, NULL, ''),
	(30, 'Liliana dos Santos Branco Couto ', 'Liliana Branco ', 'MTB - Mirense Trilhos e Bikes', '1983-12-24', 'F', '914292574', 'lilianasbranco@gmail.com', 'Mira de Aire', '2485-070', '227513720', '', 0, 1, 'Resistencia', '2016-04-17 19:00:53', 24, '2127', NULL, NULL, ''),
	(31, 'Martinho Manuel Fortunato Ferreira', 'Martinho&Amigos', 'Martinho&Amigos', '1973-11-22', 'M', '917841213', 'fortunato73@sapo.pt', 'Serra de Sto Antonio', '2380-608', '196151350', '', 0, 1, 'Resistencia', '2016-04-17 20:32:26', 25, '2128', NULL, NULL, ''),
	(32, 'FILOMENA FORMIGA NOBRE', 'Filomena Nobre', 'TWENTY ONE', '1983-08-11', 'F', '917848109', 'filomena.f.nobre@gmail.com', 'COVÃO DO COELHO', '2395-001', '232574308', '', 0, 1, 'Resistencia', '2016-04-18 09:02:06', 26, '2129', NULL, NULL, ''),
	(33, 'Rui Coelho', 'Rui Coelho', 'CCTEAM/100 limites', '1979-10-06', 'M', '917354401', 'sabrinavieira78@hotmail.com', 'Covão do Coelho', '2395', '266183077', '', 0, 1, 'Resistencia', '2016-04-18 09:12:46', 108, '2130', NULL, '', ''),
	(34, 'tiago nobre vieira', 'Tiago Vieira', 'TWENTY ONE', '2002-10-26', 'M', '917848109', 'filomena.f.nobre@gmail.com', 'Covão do Coelho', '2395-001', '244249768', '', 0, 1, 'Resistencia', '2016-04-19 15:16:12', 28, '2131', NULL, NULL, ''),
	(35, 'David Nobre Vieira', 'David Vieira', 'TWENTY ONE', '1999-10-06', 'M', '917848109', 'filomena.f.nobre@gmail.com', 'Covão do Coelho', '2395-001', '244368260', '', 0, 1, 'Resistencia', '2016-04-19 15:19:17', 29, '2132', NULL, NULL, ''),
	(36, 'Paulo Magalhães', 'Paulo Magalhães', 'Palco Da Aventura', '1970-10-11', 'M', '917562629', 'sismeirodias@gmail.com', 'LEIRIA', '2410-015', '191245887', '', 0, 1, 'Resistencia', '2016-04-19 18:10:25', 30, '2133', NULL, 'Troca Rui Sismeiro', ''),
	(37, 'Edgar bruno ferreira rosa', 'Edgar rosa', 'CCTEAM/100 limites', '1976-10-22', 'M', '918952415', 'Jaka.cc@hotmail.com', 'Covao do coelho', '2395', '208756876', '', 0, 1, 'Resistencia', '2016-04-19 18:48:55', 0, '2134', NULL, NULL, ''),
	(38, 'Bruno Rodrigues', 'Bruno Rodrigues', 'CCTEAM/100 limites', '1985-09-28', 'M', '912589579', 'ricardocustodio-1984@hotmail.com', 'Covao do Coelho', '2395-034', '44444', '', 0, 1, 'Resistencia', '2016-04-19 20:52:51', 109, '2135', NULL, '', ''),
	(39, 'Nuno Sousa', 'Nuninho', 'portelabike-ktm', '1978-10-23', 'M', '963993040', 'nuno_sousa2000@hotmail.com', 'LEIRIA', '2415-366', '190914173', '', 0, 0, 'Resistencia', '2016-04-20 14:34:48', 0, NULL, NULL, NULL, ''),
	(40, 'Paulo Pereira dos Santos', 'Paulo Santos', 'BTT Vale da Serra', '1984-10-18', 'M', '914826076', 'paulose@sapo.pt', 'Vale da Serra', '2350-249', '234517530', '', 0, 0, 'Resistencia', '2016-04-20 22:26:21', 0, NULL, NULL, NULL, ''),
	(41, 'Hugo Rodrigues', 'Hugo Rodrigues', 'CCTEAM/100 limites', '1979-09-05', 'M', '918273116', 'coutorm@hotmail.com', 'mira de aire', '2485', '4444', '', 0, 1, 'Resistencia', '2016-04-21 00:42:02', 33, '2136', NULL, '', ''),
	(42, 'António Manuel Santos Ribeiro', 'Tó', '', '1980-02-26', 'M', '914020533', 'toribeiro346@gmail.com', 'São Mamede', '2495-032', '206133464', '', 0, 1, 'Resistencia', '2016-04-21 13:23:27', 34, '2137', NULL, NULL, ''),
	(43, 'Gil José Dias Neto', 'Gil Neto', 'Ciclo Turismo NSCG', '1976-07-22', 'M', '915075761', 'gilneto22@gmail.com', 'Pinheiro Grande', '2140-307', '204475538', '', 0, 1, 'Resistencia', '2016-04-21 13:26:43', 35, '2138', NULL, NULL, ''),
	(44, 'Leandro Filipe Neto Verissimo', 'Leandro Verissimo', '', '1997-02-26', 'M', '915075761', 'gilneto22@gmail.com', 'Pinheiro Grande', '2140-307', '231003820', '', 0, 1, 'Resistencia', '2016-04-21 13:31:25', 36, '2139', NULL, NULL, ''),
	(45, 'Pedro Pinheiro', 'Pedro Pinheiro', '', '1986-01-29', 'M', '917354401', 'david_sabrina@msn.com', 'Cardosas', '2630-410', '240416619', '', 0, 1, 'Resistencia', '2016-04-22 10:06:46', 37, '2141', NULL, NULL, ''),
	(46, 'Serafim Marques Ferreira', 'Serafim Ferreira', 'ChamenoINEM', '1961-07-05', 'M', '912529726', 'serafimxferreira@gmail.com', 'Batalha', '2440-132', '121592618', '', 0, 1, 'Resistencia', '2016-04-23 11:34:06', 38, '2142', NULL, NULL, ''),
	(47, 'José Carlos Conceição Oliveira', 'Zé Carlos', 'ChamenoINEM', '1979-12-08', 'M', '919253510', 'geral@josegrosso.pt', 'Batalha', '2440-132', '221303790', '', 0, 1, 'Resistencia', '2016-04-23 12:49:10', 39, '2143', NULL, NULL, ''),
	(48, 'João pedro Roque Oliveira', 'JPR', 'JPR MOTOS', '1983-04-09', 'M', '914798260', 'Martanobrecastanheira@gmail.com', 'FATIMA ', '2495-131', '234458542', '', 0, 1, 'Resistencia', '2016-04-25 20:45:19', 40, '2144', NULL, NULL, ''),
	(49, 'Tiago Reis', 'Tiago Reis', 'Fátima Btt/Desarfate/Transfor', '1990-06-02', 'M', '914485424', 'martanobrecastanheira@gmail.com', 'Vilar dos Prazeres', '2490-742', '4444', '', 0, 1, 'Resistencia', '2016-04-26 17:43:12', 0, '2145', NULL, '', ''),
	(50, 'Jose Vitor Moteiro Henriques', 'Jose Henriques', '', '1973-06-12', 'M', '919002404', 'henriques44@sapo.pt', 'Povoa Sta. Iria', '2625-264', '196004080', '', 0, 1, 'Resistencia', '2016-04-26 19:32:02', 42, '2146', NULL, NULL, ''),
	(51, 'Luís Miguel pinheiro Coelho', 'Luís Coelho', 'StandTransBrito', '1987-05-06', 'M', '916335046', '87lmpc@gmail.com', 'Batalha', '2440-097', '220191123', '', 0, 1, 'Resistencia', '2016-04-28 17:34:49', 43, '2147', NULL, NULL, ''),
	(52, 'Helder Faria', 'Helder Faria ', 'Falcões BTT', '1982-07-12', 'M', '911171551', 'Helder-faria@hotmail.com', 'Ervideiras-Tomar', '2300-172', '241619637', '', 0, 1, 'Resistencia', '2016-04-28 18:05:46', 31, '2206', NULL, NULL, ''),
	(53, 'MIGUEL VIEIRA LAPAS', 'M. LAPAS', '', '2000-07-23', 'M', '917354401', 'david_sabrina@msn.com', 'Covão do Coelho', '2395', '271553596', '', 0, 1, 'Resistencia', '2016-04-28 18:06:38', 44, '2148', NULL, NULL, ''),
	(54, 'Valter serrano vieira', 'Valter Maçã', 'CCTEAM/100 limites', '1983-09-24', 'M', '917347961', 'Valterserranovieira@gmail.com', 'Covão do coelho', '2395', '223051640', '', 0, 1, 'Resistencia', '2016-04-28 21:33:43', 45, '2149', NULL, NULL, ''),
	(55, 'João Alexandre Bastos Novo', 'João Novo', 'StandTransBrito', '1974-01-21', 'M', '919698837', 'jabnovo@hotmail.com', 'Santo Antão', '2440-053', '203236947', '', 0, 1, 'Resistencia', '2016-04-29 11:21:26', 46, '2150', NULL, NULL, ''),
	(56, 'Miguel Almeida Queimado', 'M.Queimado', '', '1999-10-03', 'M', '910242986', 'mqueimado1999@hotmail.com', 'Covão do Coelho', '2395-034', '251581845', '', 0, 1, 'Resistencia', '2016-04-30 15:04:22', 47, '2151', NULL, NULL, ''),
	(57, 'Isidro Pereira da Silva', 'Isidro Silva', 'BatalhaBikers', '1963-07-16', 'M', '918903519', 'isidro1607@gmail.com', 'Barrosa   São Simão de Litem  Pombal', '3100-709', '178069671', '', 0, 1, 'Resistencia', '2016-05-01 19:06:22', 48, '2152', NULL, NULL, ''),
	(58, 'Samuel Formiga Santos', 'S.Formiga', 'X-Extream', '1999-12-16', 'M', '910077548', 'samuelf_santos@hotmail.com', 'Covão do Coelho', '2395-026', '248395793', '', 0, 1, 'Resistencia', '2016-05-02 19:03:42', 49, '2153', NULL, NULL, ''),
	(59, 'Miguel  Angelo Dias Vieira', 'Miguel', 'CCTEAM/100 limites', '1977-12-12', 'M', '912955593', 'ricardocustodio-1984@hotmail.com', 'Minde', '2395', '216681260', '', 0, 1, 'Resistencia', '2016-05-02 19:55:56', 50, '2154', NULL, NULL, ''),
	(60, 'armindo martins dias ', 'Dias', 'CCTEAM/100 limites', '1962-06-10', 'M', '932852281', 'btt100limites@hotmail.com', 'Vale-Alto', '2395', '171634608', '', 0, 1, 'Resistencia', '2016-05-03 16:03:59', 51, '2155', NULL, NULL, ''),
	(61, 'Tiago Gomes', 'Parrelas', 'Joana Taborda Cabeleireiro', '1986-10-08', 'M', '917143867', 'parrelas@hotmail.com', 'Minde', '2485-146', '241951895', '', 0, 1, 'Resistencia', '2016-05-03 21:27:59', 52, '2156', NULL, NULL, ''),
	(63, 'Marisa Ferreira Faria Rosa Vieira', 'Marisa', 'CCTEAM/100 limites', '1984-03-06', 'F', '918508673', 'marisaf920@gmail.com', 'Covão do Coelho', '2395-019', '223382620', '', 0, 1, 'Resistencia', '2016-05-07 14:40:26', 53, '2157', NULL, NULL, ''),
	(64, 'Fernando Amaro', 'Amaro', '#SUSANAestética', '1981-02-25', 'M', '963654133', 'orama.life@gmail.com', 'Minde', '2395-105', '207573166', '', 0, 1, 'Resistencia', '2016-05-07 21:48:00', 54, '2158', NULL, NULL, ''),
	(65, 'Nélson Miguel Gomes Norberto', 'Nélson Norberto', 'StandTransBrito', '1972-03-03', 'M', '917593939', 'martanobrecastanheira@gmail.com', 'Alcobaça', '2461', '189706074', '', 0, 1, 'Resistencia', '2016-05-09 13:18:03', 55, '2159', NULL, NULL, ''),
	(66, 'jorge manuel rodrigues paz', 'jorge paz', 'CCTEAM/100 limites', '1972-10-20', 'M', '966895977', 'jorge.paz@iol.pt', 'minde', '2395-177 minde', '204077567', '', 0, 1, 'Resistencia', '2016-05-10 11:06:32', 56, '2160', NULL, NULL, ''),
	(67, 'DAVID MANUEL FERREIRA VIEIRA', 'Chiquito', 'TWENTY ONE', '1980-12-30', 'M', '917593939', 'davidvieira.80@gmail.com', 'Covão do Coelho', '2395', '202451933', '', 0, 1, 'Resistencia', '2016-05-10 15:50:30', 57, '2161', NULL, NULL, ''),
	(68, 'José Luis dos Santos Augusto', 'Bacano', 'Os Fincadas URD Juncalense', '1974-12-25', 'M', '916748164', 'j.bacano12@gmail.com', 'Juncal', '2480-353', '204729645', '', 0, 1, 'Resistencia', '2016-05-10 21:02:26', 58, '2162', NULL, NULL, ''),
	(69, 'Hugo Grazina', 'Hugo Grazina', 'Transfon/Hugotrans - Covão do Coelho', '1981-11-01', 'M', '912598099', 'hugograzina@actorent.pt', 'Juncal', '2480-079', '233743766', '', 0, 1, 'Resistencia', '2016-05-10 23:44:34', 59, '2163', NULL, NULL, ''),
	(70, 'Tomé Fernando Carvalho Rebelo', 'Tomé Rebelo', 'BTTerriveis S. Mamede', '1983-08-06', 'M', '917096294', 'tomcel1@hotmail.com', 'S. Mamede', '2495-028', '200824449', '', 0, 1, 'Resistencia', '2016-05-10 23:56:55', 60, '2164', NULL, NULL, ''),
	(71, 'Ivan Pinheiro Ferreira', 'I. Ferreira', 'Team Ferreira BTT', '1985-02-23', 'M', '912405576', 'cyber.ferreira@gmail.com', 'Minde', '2395-112', '240212207', '', 0, 1, 'Resistencia', '2016-05-11 00:21:50', 61, '2165', NULL, NULL, ''),
	(72, 'diogo gonçalves bento', 'Diogo', 'CCTEAM/100 limites', '2000-02-19', 'M', '914540881', 'btt100limites@hotmail.com', 'Vale-Alto', '2395', '232514267', '', 0, 1, 'Resistencia', '2016-05-11 17:09:14', 62, '2166', NULL, NULL, ''),
	(73, 'Paulo peralta', 'Peralta', 'Os Fincadas URD Juncalense', '1967-05-18', 'M', '917728802', 'paulo.peralta@hotmail.com', 'Juncal', '2480-390', '180338986', '', 0, 1, 'Resistencia', '2016-05-11 20:58:05', 63, '2167', NULL, NULL, ''),
	(74, 'Marco António carreira  vieira', 'Marco vieira', 'Silva jeans btt team', '1985-08-26', 'M', '916973210', 'marco_vieira1985@live.com.pt', 'Casal vieira', '2495-019', '230441467', '', 0, 1, 'Resistencia', '2016-05-11 22:22:22', 64, '2168', NULL, NULL, ''),
	(75, 'Paulo Jorge Lopes Vieira', 'Paulo Vieira', 'alcabtt', '1976-03-02', 'M', '910286777', 'alcabtt@sapo.pt', 'Alcanena', '2380', '210064285', '', 0, 1, 'Resistencia', '2016-05-12 18:53:08', 65, '2169', NULL, NULL, ''),
	(76, 'Paulo Joaquim Ribeiro Conceição', 'Paulo Conceição', 'Os Fincadas URD Juncalense', '1969-08-14', 'M', '919814792', 'fft.conceicao@sapo.pt', 'Juncal', '2480-353', '185745547', '', 0, 1, 'Resistencia', '2016-05-12 18:53:37', 66, '2170', NULL, NULL, ''),
	(77, 'Agostinho dos Santos Marques', 'O cunhado', 'TOUR BIKE', '1966-12-11', 'M', '926614821', 'martanobrecastanheira@gmail.com', 'Leiria', '2410', '140152067', '', 0, 1, 'Resistencia', '2016-05-12 19:03:48', 67, '2171', NULL, NULL, ''),
	(78, 'Marcos Jorge Barata Fernandes Rei', 'Marcos Rei', 'TOUR BIKE', '1980-04-08', 'M', '926614821', 'martanobrecastanheira@gmail.com', 'Leiria', '2410', '219645086', '', 0, 1, 'Resistencia', '2016-05-12 19:16:11', 68, '2172', NULL, NULL, ''),
	(79, 'Bruno Cesar Gonçalves Lopes', 'Bruno Lopes', 'Liteiros Bike', '1981-03-29', 'M', '914292426', 'brunocesar11slb@gmail.com', 'Liteiros', '2350 Torres Novas', '223340529', '', 0, 1, 'Resistencia', '2016-05-12 21:47:11', 69, '2173', NULL, NULL, ''),
	(80, 'SÍLVIA CORREIA NETO', 'Sílvia', 'Neto', '1979-01-06', 'F', '917415034', 'silvicaneto@hotmail.com', 'covão do coelho', '2395-009', '221342613', '', 0, 1, 'Resistencia', '2016-05-12 22:40:19', 70, '2174', NULL, NULL, ''),
	(81, 'Luís Antonio Carrelo Lopes', 'Luís António Lopes', 'TOUR BIKE', '2002-07-10', 'M', '926614821', 'martanobrecastanheira@gmail.com', 'Leiria ', '2410', '241448280', '', 0, 1, 'Resistencia', '2016-05-13 15:48:42', 71, '2175', NULL, NULL, ''),
	(82, 'Bruno Mendes', 'Bruno M.FalcõesBTT ', 'Falcões BTT', '1983-03-08', 'M', '914681229', 'brunopiedademendes@gmail.com', 'Tomar ', '2300-608', '225568551', '', 0, 1, 'Resistencia', '2016-05-13 17:57:56', 72, '2176', NULL, NULL, ''),
	(83, 'Fernando Santos', 'Fernando Santos', 'Nucleo Cicloturismo Alcanena', '1958-08-01', 'M', '933773738', 'pedrosantos_88@hotmail.com', 'Monsanto', '2380/573', '109584180', '', 0, 1, 'Resistencia', '2016-05-14 00:24:39', 73, '2177', NULL, NULL, ''),
	(84, 'Pedro Santos', 'Pedro Santos', 'Nucleo Cicloturismo Alcanena', '1988-01-01', 'M', '913065298', 'pedrosantos_88@hotmail.com', 'Monsanto', '2380/573', '234292598', '', 0, 1, 'Resistencia', '2016-05-14 00:28:23', 74, '2178', NULL, NULL, ''),
	(85, 'João Miguel Coelho Jorge', 'João Miguel', 'X-Extream', '2000-05-11', 'M', '968829892', 'jonyto16@hotmail.com', 'Covão do Coelho', '2395-013', '265255180', '', 0, 1, 'Resistencia', '2016-05-14 10:43:11', 75, '2179', NULL, NULL, ''),
	(86, 'Hugo Ribeiro', 'Hugo Ribeiro', 'Nucleo Cicloturismo Alcanena', '1985-11-27', 'M', '911157913', 'hugo_rbr07@hotmail.com', 'Alcanena', '2380', '240394380', '', 0, 1, 'Resistencia', '2016-05-14 11:58:04', 76, '2180', NULL, NULL, ''),
	(87, 'Roberto Carlos Marques Ferreira', 'Roberto Ferreira', 'MTB - Mirense Trilhos e Bikes', '1982-12-29', 'M', '918977413', 'mindrico@gmail.com', 'Minde', '2395-202', '233539018', '', 0, 1, 'Resistencia', '2016-05-14 12:05:45', 77, '2181', NULL, NULL, ''),
	(88, 'Ricardo Barros', 'Ricardo Barros', 'CCTEAM/100 limites', '1985-11-10', 'M', '918546555', 'narciso.jf@gmail.com', 'Covão do Coelho', '1750-018', '241968666', '', 0, 1, 'Resistencia', '2016-05-14 12:09:23', 0, '', NULL, '', ''),
	(89, 'Telmo Pereira', 'Telmo P. FalcõesBTT', 'Falcões BTT', '1976-04-07', 'M', '914265397', 'telmomarquespereira@gmail.com', 'Tomar', '2300-153', '210344270', '', 0, 1, 'Resistencia', '2016-05-14 13:01:24', 79, '2183', NULL, NULL, ''),
	(90, 'Diogo Fernando Cardoso Gaspar', 'Diogo Gaspar', 'MTB - Mirense Trilhos e Bikes', '1985-10-02', 'M', '914620725', 'diogo_gaspar86@hotmail.com', 'Mira de Aire', '2485-134', '230724787', '', 0, 1, 'Resistencia', '2016-05-14 17:33:59', 80, '2184', NULL, NULL, ''),
	(91, 'Bruno Manuel Carreira Ferreira', 'Bruno Cebola', 'Joana Taborda Cabeleireiro', '1985-07-24', 'M', '914177804', 'hugobuzz10@gmail.com', 'Mira de Aire ', '2485', '237090414', '', 0, 1, 'Resistencia', '2016-05-14 18:25:03', 81, '2185', NULL, NULL, ''),
	(92, 'José Pereira Marques', 'José Marques', 'BTTEAM-GDC SEIÇA', '1960-01-10', 'M', '914402071', 'jpm.zeca@gmail.com', 'Seiça - Ourém', '2435-633', '108986934', '', 0, 1, 'Resistencia', '2016-05-14 22:11:28', 82, '2186', NULL, NULL, ''),
	(93, 'Paulo Cruz', 'Paulo Cruz', 'Os Fincadas URD Juncalense', '1977-03-03', 'M', '962521993', 'pauloccruz@sapo.pt', 'Juncal', '2480-393', '219419418', '', 0, 1, 'Resistencia', '2016-05-14 23:49:53', 83, '2187', NULL, NULL, ''),
	(94, 'JOANA RODRIGUES DE JESUS TABORDA ', 'JOANA TABORDA ', 'Joana Taborda Cabeleireiro', '1985-10-05', 'F', '917143867', 'parrelas@hotmail.com', 'MINDE ', '2395-153', '241569125', '', 0, 1, 'Resistencia', '2016-05-15 18:19:56', 84, '2188', NULL, NULL, ''),
	(96, 'cláudio francisco vieira soares', 'claudio soares', '', '1978-11-14', 'M', '912122891', 'claudiovieirasoares@sapo.pt', 'alcanena', '2380-086', '219765057', '', 0, 1, 'Resistencia', '2016-05-16 21:26:48', 86, '2190', NULL, NULL, ''),
	(97, 'JOAO NUNO ROSARIO NOVO', 'JOAO NUNO', 'NASA/LEIRIBIKE', '1975-02-05', 'M', '917723434', 'jnovo33@hotmail.com', 'BATALHA', '2440-372', '207278440', '', 0, 1, 'Resistencia', '2016-05-16 22:25:56', 87, '2191', NULL, NULL, ''),
	(98, 'Sérgio Henriques', 'Sérgio Henriques', 'NASA/LEIRIBIKE', '1986-05-28', 'M', '915155553', 'hofs86@gmail.com', 'Batalha', '2440-053 Batalha', '227292316', '', 0, 1, 'Resistencia', '2016-05-16 22:29:57', 88, '2192', NULL, NULL, ''),
	(99, 'tIAGO CLÁUDIO FERREIRA', 'TIAGO FERREIRA', 'RIDERS ON THE STORM', '1983-01-28', 'M', '917521894', 'tiagocf83@gmail.com', 'SERRA DE SANTO ANTÓNIO', '2380-604', '203744500', '', 0, 1, 'Resistencia', '2016-05-16 23:30:07', 89, '2193', NULL, NULL, ''),
	(100, 'Luis Miguel Fialho Vitória', 'M.Bike', 'M.Bike', '1976-08-22', 'M', '917593939', 'm.bike1976@gmail.com', 'São Mamede', '2495-032', '213132028', '', 0, 1, 'Resistencia', '2016-05-17 09:05:27', 90, '2194', NULL, NULL, ''),
	(101, 'Luís Miguel Oliveira Rodrigues', 'Luís Rodrigues', 'Serra Serena BTT', '1970-02-20', 'M', '916368032', 'luis.mrodrigues.70@gmail.com', 'Zambujal', '2480-012', '194748111', '', 0, 1, 'Resistencia', '2016-05-17 10:55:36', 91, '2195', NULL, NULL, ''),
	(102, 'tiago nuno almeida antunes', 'tiago antunes', 'Fátima Btt/Desarfate/Transfor', '1986-05-24', 'M', '912811449', 'tiagonunoaa@gmail.com', 'SÃO MAMEDE', '2495-032', '244951209', '', 0, 1, 'Resistencia', '2016-05-17 10:59:59', 92, '2196', NULL, NULL, ''),
	(103, 'nelson pedro ferreira henriques', 'nelson henriques', 'NASA/LEIRIBIKE', '1978-06-26', 'M', '917723434', 'jnovo33@hotmail.com', 'batalha', '2440 batalha', '219221804', '', 0, 1, 'Resistencia', '2016-05-17 13:10:03', 93, '2197', NULL, NULL, ''),
	(104, 'Tiago Manuel Neves reis ', 'Pato', 'fatima btt club/divireis', '1990-06-02', 'M', '913317103', 'Patobike465@hotmail.com', 'Tomar', '2300-410', '255638272', '', 0, 2, 'Resistencia', '2016-05-17 14:15:16', 103, '2207', NULL, '', ''),
	(105, 'David silva frazão', 'David CHANCE', 'Fátima Btt/Desarfate/Transfor', '1985-09-11', 'M', '924236789', 'Davichance@hotmail.com', 'Demó', '2495-023', '237446626', '', 0, 1, 'Resistencia', '2016-05-17 16:08:24', 94, '2198', NULL, NULL, ''),
	(106, 'Paulo Magalhaes ', 'Paulo Magalhaes ', 'Palco Da Aventura', '1976-06-06', 'M', '912371647', 'paulorsm@sapo.pt', 'Leiria', '2400', '165675578', '', 0, 0, 'Resistencia', '2016-05-17 17:28:00', 0, NULL, NULL, NULL, ''),
	(107, 'Ricardo Miguel da Costa Freire', 'Ricardo Freire ', 'Fátima Btt/Desarfate/Transfor', '1986-09-18', 'M', '912002608', 'ricardo.miguel.freire@gmail.com', 'Freixianda', '2435-260', '221248528', '', 0, 1, 'Resistencia', '2016-05-17 20:10:13', 95, '2199', NULL, NULL, ''),
	(108, 'David Manuel da Graça Pereira', 'DAVID PEREIRA', '', '1973-12-12', 'M', '934507394', 'david_sabrina@msn.com', 'Covão do Coelho', '2395-016', '223212105', '', 0, 1, 'Resistencia', '2016-05-18 18:16:01', 96, '', NULL, NULL, ''),
	(109, 'hugo gonçalo marques ferreira', 'Gorja', 'Falcões BTT', '1983-03-16', 'M', '917454275', 'hugogferreira@sapo.pt', 'tomar', '2300-338', '210116641', '', 0, 1, 'Resistencia', '2016-05-18 19:21:30', 97, '2201', NULL, NULL, ''),
	(110, 'Paulo Fernandes', 'Paulo Fernandes', '', '1966-01-29', 'M', '962684142', 'paulo.f.fernandes@sapo.pt', 'Pousados', '2380/226', '188245790', '', 0, 1, 'Resistencia', '2016-05-18 19:43:38', 98, '2202', NULL, NULL, ''),
	(111, 'Helio Videira', 'Helio Videira', 'M.S.VIDEIRA', '1977-05-18', 'M', '919327418', 'eccvideira@gmail.com', 'batalha', '2440', '217791492', '', 0, 0, 'Resistencia', '2016-05-18 21:54:31', 0, NULL, NULL, NULL, ''),
	(112, 'Gonçalo José Gaspar de Oliveira', 'Gonçalo', '', '1983-01-18', 'M', '961782740', 'martanobrecastanheira@gmail.com', 'Boa Vista', '2410-493', '238291634', '', 0, 1, 'Resistencia', '2016-05-18 22:48:54', 99, '2203', NULL, NULL, ''),
	(113, 'Nelson José Pinto Guimarães', 'Nelson Guimarães', '', '1972-06-28', 'M', '938444422', 'martanobrecastanheira@gmail.com', 'Leiria', '2480', '164415122', '', 0, 1, 'Resistencia', '2016-05-18 22:53:20', 100, '2204', NULL, NULL, ''),
	(114, 'Raul Filipe Santos Domingues Martins', 'Raul Filipe', '', '1986-03-15', 'M', '916741194', 'martanobrecastanheira@gmail.com', 'Leiria', '2400-825', '247452904', '', 0, 1, 'Resistencia', '2016-05-18 22:55:41', 101, '2205', NULL, NULL, ''),
	(116, 'António José Rosario Novo', 'António Novo', 'Ligação Veloz', '1962-11-19', 'M', '', '', NULL, NULL, '115304819', NULL, NULL, 2, 'Resistencia', '2016-05-19 23:19:36', 105, '2200', NULL, '', NULL),
	(117, 'Xico Barros', 'Xico Barros', 'Os Fincadas UJD Juncalense', '1981-04-09', 'M', '', '', NULL, NULL, '224785761', NULL, NULL, 2, 'Resistencia', '2016-05-19 23:32:03', 106, '2182', NULL, '', NULL),
	(118, 'Ricardo Barros', 'Ricardo Barros', 'Os Fincadas URD Juncalense', '1985-04-14', 'M', '', '', '', '', '224785753', NULL, NULL, 2, 'Resistencia', '2016-05-20 08:52:26', 107, '2109', NULL, '', ''),
	(119, 'Rui Coelho', 'Rui Coelho', 'Os Fincadas URD Juncalense', '1979-06-10', 'M', '', '', '', '', '215874277', NULL, NULL, 2, 'Resistencia', '2016-05-20 08:56:52', 0, '2212', NULL, '', '');

INSERT IGNORE INTO `104Provas` (`id`, `nome`, `data`, `hora`, `nr_caixas`, `valor_prova`, `valor_prova_agravado`, `dorsal_min`, `dorsal_max`, `deleted`, `data_limite_insc`, `data_agrav_insc`, `data_agrav_insc1`, `data_agrav_insc2`, `valor_prova_agravado1`, `valor_prova_agravad2`, `nummaxinsc`, `ativa`) VALUES
	(1, 'Resistencia', '2016-05-21', '19:59:20', 2, 10.00, 10.00, 1, 150, 0, '2016-05-19', '2016-05-19', NULL, NULL, 0.00, 0.00, 150, 1);

INSERT IGNORE INTO `104Tempos` (`id`, `id_origem`, `caixa`, `chip`, `data`, `hora`, `nome_prova`, `posicao_geral`, `volta`, `motivo`) VALUES
	(27, NULL, '2', '2112', '2016-05-21', '22:59:32.43', 'Resistencia', NULL, 10, NULL),
	(26, NULL, '2', '2111', '2016-05-21', '23:16:14.24', 'Resistencia', NULL, 13, NULL),
	(25, NULL, '2', '2109', '2016-05-21', '23:11:25.88', 'Resistencia', NULL, 13, NULL),
	(24, NULL, '2', '2107', '2016-05-21', '22:42:26.57', 'Resistencia', NULL, 8, NULL),
	(23, NULL, '2', '2356', '2016-05-21', '20:45:40.65', 'Resistencia', NULL, 3, NULL),
	(22, NULL, '2', '2199', '2016-05-21', '23:11:54.61', 'Resistencia', NULL, 11, NULL),
	(21, NULL, '2', '2186', '2016-05-21', '23:18:40.63', 'Resistencia', NULL, 10, NULL),
	(20, NULL, '2', '2184', '2016-05-21', '23:00:34.77', 'Resistencia', NULL, 12, NULL),
	(19, NULL, '2', '2173', '2016-05-21', '22:18:52.43', 'Resistencia', NULL, 7, NULL),
	(18, NULL, '2', '2145', '2016-05-21', '21:08:44.71', 'Resistencia', NULL, 3, NULL),
	(17, NULL, '2', '2123', '2016-05-21', '23:10:39.96', 'Resistencia', NULL, 13, NULL),
	(28, NULL, '2', '2115', '2016-05-21', '22:16:36.39', 'Resistencia', NULL, 7, NULL),
	(29, NULL, '2', '2118', '2016-05-21', '23:09:22.02', 'Resistencia', NULL, 10, NULL),
	(30, NULL, '2', '2126', '2016-05-21', '23:22:05.24', 'Resistencia', NULL, 11, NULL),
	(31, NULL, '2', '2133', '2016-05-21', '23:09:00.59', 'Resistencia', NULL, 11, NULL),
	(32, NULL, '2', '2135', '2016-05-21', '23:22:05.24', 'Resistencia', NULL, 13, NULL),
	(33, NULL, '2', '2141', '2016-05-21', '23:22:05.24', 'Resistencia', NULL, 14, NULL),
	(34, NULL, '2', '2152', '2016-05-21', '23:02:33.87', 'Resistencia', NULL, 8, NULL),
	(35, NULL, '2', '2163', '2016-05-21', '23:01:21.48', 'Resistencia', NULL, 13, NULL),
	(36, NULL, '2', '2178', '2016-05-21', '23:12:19.18', 'Resistencia', NULL, 12, NULL),
	(37, NULL, '2', '2187', '2016-05-21', '23:11:40.07', 'Resistencia', NULL, 11, NULL),
	(38, NULL, '2', '2195', '2016-05-21', '23:17:50.01', 'Resistencia', NULL, 8, NULL),
	(39, NULL, '2', '2196', '2016-05-21', '23:03:04.17', 'Resistencia', NULL, 9, NULL),
	(40, NULL, '2', '2108', '2016-05-21', '22:37:23.97', 'Resistencia', NULL, 6, NULL),
	(41, NULL, '2', '2113', '2016-05-21', '23:17:09.37', 'Resistencia', NULL, 9, NULL),
	(42, NULL, '2', '2116', '2016-05-21', '23:18:29.28', 'Resistencia', NULL, 11, NULL),
	(43, NULL, '2', '2122', '2016-05-21', '23:10:45.68', 'Resistencia', NULL, 11, NULL),
	(44, NULL, '2', '2128', '2016-05-21', '21:40:14.00', 'Resistencia', NULL, 5, NULL),
	(45, NULL, '2', '2130', '2016-05-21', '22:59:32.63', 'Resistencia', NULL, 13, NULL),
	(46, NULL, '2', '2131', '2016-05-21', '22:38:00.42', 'Resistencia', NULL, 7, NULL),
	(47, NULL, '2', '2134', '2016-05-21', '23:12:42.26', 'Resistencia', NULL, 12, NULL),
	(48, NULL, '2', '2146', '2016-05-21', '23:00:42.46', 'Resistencia', NULL, 10, NULL),
	(49, NULL, '2', '2162', '2016-05-21', '23:00:20.05', 'Resistencia', NULL, 9, NULL),
	(50, NULL, '2', '2165', '2016-05-21', '23:18:54.29', 'Resistencia', NULL, 11, NULL),
	(51, NULL, '2', '2166', '2016-05-21', '23:16:45.38', 'Resistencia', NULL, 10, NULL),
	(52, NULL, '2', '2167', '2016-05-21', '23:14:19.90', 'Resistencia', NULL, 12, NULL),
	(53, NULL, '2', '2169', '2016-05-21', '23:07:46.66', 'Resistencia', NULL, 10, NULL),
	(54, NULL, '2', '2170', '2016-05-21', '23:02:48.24', 'Resistencia', NULL, 11, NULL),
	(55, NULL, '2', '2176', '2016-05-21', '23:07:49.45', 'Resistencia', NULL, 9, NULL),
	(56, NULL, '2', '2177', '2016-05-21', '23:00:52.41', 'Resistencia', NULL, 11, NULL),
	(57, NULL, '2', '2180', '2016-05-21', '23:02:14.49', 'Resistencia', NULL, 13, NULL),
	(58, NULL, '2', '2181', '2016-05-21', '23:02:26.17', 'Resistencia', NULL, 10, NULL),
	(59, NULL, '2', '2182', '2016-05-21', '23:06:24.67', 'Resistencia', NULL, 13, NULL),
	(60, NULL, '2', '2183', '2016-05-21', '23:07:43.10', 'Resistencia', NULL, 10, NULL),
	(61, NULL, '2', '2190', '2016-05-21', '23:03:19.76', 'Resistencia', NULL, 8, NULL),
	(62, NULL, '2', '2192', '2016-05-21', '23:00:38.56', 'Resistencia', NULL, 11, NULL),
	(63, NULL, '2', '2193', '2016-05-21', '23:23:44.50', 'Resistencia', NULL, 9, NULL),
	(64, NULL, '2', '2201', '2016-05-21', '22:59:47.28', 'Resistencia', NULL, 5, NULL),
	(65, NULL, '2', '2189', '2016-05-21', '23:25:43.05', 'Resistencia', NULL, 11, NULL),
	(66, NULL, '2', '2106', '2016-05-21', '23:27:03.90', 'Resistencia', NULL, 10, NULL),
	(67, NULL, '2', '2110', '2016-05-21', '23:05:20.73', 'Resistencia', NULL, 9, NULL),
	(68, NULL, '2', '2114', '2016-05-21', '22:53:11.97', 'Resistencia', NULL, 6, NULL),
	(69, NULL, '2', '2117', '2016-05-21', '23:00:23.79', 'Resistencia', NULL, 7, NULL),
	(70, NULL, '2', '2119', '2016-05-21', '22:50:36.53', 'Resistencia', NULL, 6, NULL),
	(71, NULL, '2', '2120', '2016-05-21', '22:13:41.72', 'Resistencia', NULL, 5, NULL),
	(72, NULL, '2', '2121', '2016-05-21', '23:18:31.73', 'Resistencia', NULL, 8, NULL),
	(73, NULL, '2', '2124', '2016-05-21', '23:18:29.49', 'Resistencia', NULL, 8, NULL),
	(74, NULL, '2', '2125', '2016-05-21', '23:12:43.69', 'Resistencia', NULL, 11, NULL),
	(75, NULL, '2', '2127', '2016-05-21', '22:59:28.24', 'Resistencia', NULL, 7, NULL),
	(76, NULL, '2', '2132', '2016-05-21', '21:16:52.56', 'Resistencia', NULL, 2, NULL),
	(77, NULL, '2', '2137', '2016-05-21', '23:15:51.83', 'Resistencia', NULL, 6, NULL),
	(78, NULL, '2', '2138', '2016-05-21', '23:35:45.45', 'Resistencia', NULL, 13, NULL),
	(79, NULL, '2', '2139', '2016-05-21', '23:35:46.91', 'Resistencia', NULL, 11, NULL),
	(80, NULL, '2', '2147', '2016-05-21', '22:22:22.85', 'Resistencia', NULL, 7, NULL),
	(81, NULL, '2', '2148', '2016-05-21', '22:53:14.19', 'Resistencia', NULL, 4, NULL),
	(82, NULL, '2', '2149', '2016-05-21', '23:27:39.81', 'Resistencia', NULL, 9, NULL),
	(83, NULL, '2', '2150', '2016-05-21', '23:09:32.45', 'Resistencia', NULL, 9, NULL),
	(84, NULL, '2', '2151', '2016-05-21', '21:14:38.12', 'Resistencia', NULL, 3, NULL),
	(85, NULL, '2', '2153', '2016-05-21', '21:37:23.15', 'Resistencia', NULL, 4, NULL),
	(86, NULL, '2', '2154', '2016-05-21', '23:08:38.14', 'Resistencia', NULL, 5, NULL),
	(87, NULL, '2', '2155', '2016-05-21', '22:12:27.19', 'Resistencia', NULL, 4, NULL),
	(88, NULL, '2', '2156', '2016-05-21', '23:10:28.64', 'Resistencia', NULL, 11, NULL),
	(89, NULL, '2', '2160', '2016-05-21', '22:50:38.04', 'Resistencia', NULL, 8, NULL),
	(90, NULL, '2', '2164', '2016-05-21', '23:11:29.25', 'Resistencia', NULL, 9, NULL),
	(91, NULL, '2', '2168', '2016-05-21', '23:22:05.24', 'Resistencia', NULL, 11, NULL),
	(92, NULL, '2', '2179', '2016-05-21', '20:24:21.70', 'Resistencia', NULL, 1, NULL),
	(93, NULL, '2', '2191', '2016-05-21', '23:09:34.16', 'Resistencia', NULL, 9, NULL),
	(94, NULL, '2', '2194', '2016-05-21', '21:59:26.12', 'Resistencia', NULL, 4, NULL),
	(95, NULL, '2', '2197', '2016-05-21', '23:03:32.11', 'Resistencia', NULL, 7, NULL),
	(96, NULL, '2', '2198', '2016-05-21', '23:09:56.52', 'Resistencia', NULL, 10, NULL),
	(97, NULL, '2', '2200', '2016-05-21', '23:09:25.80', 'Resistencia', NULL, 10, NULL),
	(98, NULL, '2', '2202', '2016-05-21', '23:03:23.17', 'Resistencia', NULL, 7, NULL),
	(99, NULL, '2', '1446', '2016-05-21', '23:03:35.01', 'Resistencia', NULL, 6, NULL),
	(100, NULL, '2', '2129', '2016-05-21', '23:07:11.18', 'Resistencia', NULL, 6, NULL),
	(101, NULL, '2', '2136', '2016-05-21', '23:03:40.87', 'Resistencia', NULL, 5, NULL),
	(102, NULL, '2', '2157', '2016-05-21', '22:40:24.47', 'Resistencia', NULL, 4, NULL),
	(103, NULL, '2', '2161', '2016-05-21', '23:07:12.73', 'Resistencia', NULL, 6, NULL),
	(104, NULL, '2', '2171', '2016-05-21', '22:25:00.87', 'Resistencia', NULL, 4, NULL),
	(105, NULL, '2', '2172', '2016-05-21', '22:49:56.53', 'Resistencia', NULL, 7, NULL),
	(106, NULL, '2', '2174', '2016-05-21', '22:40:44.85', 'Resistencia', NULL, 4, NULL),
	(107, NULL, '2', '2175', '2016-05-21', '23:11:22.79', 'Resistencia', NULL, 6, NULL),
	(108, NULL, '2', '2185', '2016-05-21', '21:02:18.64', 'Resistencia', NULL, 2, NULL),
	(109, NULL, '2', '2203', '2016-05-21', '21:28:45.63', 'Resistencia', NULL, 3, NULL),
	(110, NULL, '2', '2204', '2016-05-21', '23:14:54.18', 'Resistencia', NULL, 8, NULL),
	(111, NULL, '2', '2205', '2016-05-21', '21:28:48.90', 'Resistencia', NULL, 3, NULL);
	
	
	/* ************************************************************* */
	/* ******************** Variables and stuff ******************** */
	/* ************************************************************* */
	SET @idEscalao = 1;
	SET @idProva = 1;
	SET @nomeProva = 'Resistencia';
	/* ************************************************************* */
	
	
    /* ************************************************************* */
	/* Por escalao - usa as variaveies de teste 					 */
	/* ************************************************************* */
	SET @rownum = 0;
    SELECT 
        base.*, @rownum := @rownum + 1 AS rank 
    FROM     
	(
		SELECT 
			xInsc.dorsal, 
			xInsc.nome_completo, 
			xInsc.equipa, 
			xInsc.nome_prova_insc, 
			TIME_FORMAT(TIMEDIFF( CONCAT (xTime.data ,' ' ,xTime.hora ),CONCAT (xProva.data,' ' ,xProva.hora)), '%H:%i:%s.%f') AS tempo,
            xTime.volta,
			xProva.nome
		FROM 
			104Tempos xTime, 104Provas xProva, 104Inscricoes xInsc, 104Escaloes xEsc
		WHERE
			xTime.caixa=(SELECT MAX(xCaixa.codigo) from 104Caixas xCaixa) AND
			xTime.chip = xInsc.chip AND
			xTime.data != '1111-11-11' AND 
			xTime.hora != '00:00:00' AND 
			TIMESTAMPDIFF(YEAR, xInsc.data_nasc, xProva.data) >= xEsc.idd_min AND 
			TIMESTAMPDIFF(YEAR, xInsc.data_nasc, xPRova.data) <= xEsc.idd_max  AND
			xInsc.sexo COLLATE utf8_unicode_ci = xEsc.sexo COLLATE utf8_unicode_ci AND
			xEsc.id= @idEscalao AND
			xProva.id=@idProva AND 
			xInsc.nome_prova_insc COLLATE utf8_unicode_ci = @nomeProva COLLATE utf8_unicode_ci
		ORDER BY volta DESC, tempo ASC
	) as base;
    /* ************************************************************* */
	
	
	SET @rownum = 0;
    SELECT 
        base.*, @rownum := @rownum + 1 AS rank 
    FROM     
	(
		SELECT 
			xInsc.dorsal, 
			xInsc.nome_completo, 
			xInsc.equipa, 
			xInsc.nome_prova_insc, 
			TIME_FORMAT(TIMEDIFF( CONCAT (xTime.data ,' ' ,xTime.hora ),CONCAT (xProva.data,' ' ,xProva.hora)), '%H:%i:%s.%f') AS tempo,
            xTime.volta,
			xProva.nome
		FROM 
			104Tempos xTime, 104Provas xProva, 104Inscricoes xInsc
		WHERE
			xTime.caixa=(SELECT MAX(xCaixa.codigo) from 104Caixas xCaixa) AND
			xTime.chip = xInsc.chip AND
			xTime.data != '1111-11-11' AND 
			xTime.hora != '00:00:00' AND 
			xProva.id=@idProva AND 
			xInsc.nome_prova_insc COLLATE utf8_unicode_ci = @nomeProva COLLATE utf8_unicode_ci
		ORDER BY volta DESC, tempo ASC
	) as base;


run \| edit \| history \| help	0