4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Náutico

Enviar Datos
Información
Otros Datos
  • Año de Fundación 1901
  • Patrocinador Hospital Português
  • Patrocinador Secundario Turquesa, Canaã, Ambev
  • Marca de Ropa N6
Internet

Información sobre el estadio

  • Nombre del estadio Itaipava Arena Pernambuco
  • Capacidad 46154
  • Dirección Avenida Conselheiro Rosa e Silva 1086, Bairro dos Afiltos 52020-220 Recife, Pernambuco
  • Teléfono +55 (81) 3243 7600
  • Fax +55 (81) 3243 7600
  • Año de construcción 2013
  • Tamaño 105x68
Itaipava Arena Pernambuco

Partidos del Náutico

Ir al LIVESCORE
Copa Brasil Copa Brasil »
16 Jul 15  Finalizado Náutico Náutico
0 - 2
 Flamengo Flamengo 21
28 May 15  Finalizado Flamengo Flamengo
1 - 1
 Náutico Náutico 21
06 May 15  Aplazado Náutico Náutico
-
 Jacuipense Jacuipense 7
01 May 15  Finalizado Jacuipense Tarjeta RojaJacuipense
0 - 2
 Náutico Náutico 12
16 Abr 15  Finalizado Náutico Náutico
2 - 0
 Brasília Brasília 0
03 Abr 15  Finalizado Brasília Brasília
0 - 1
 Náutico Náutico 18
Serie B - Brasil Serie B - Brasil »
28 Nov 15  Finalizado RB Bragantino RB Bragantino
0 - 2
 Náutico Náutico 1
21 Nov 15  Finalizado Náutico Náutico
1 - 0
 Bahía Bahía 1
14 Nov 15  Finalizado Náutico Náutico
1 - 1
 CRB CRB 19
10 Nov 15  Finalizado Macaé Esporte Macaé Esporte
1 - 1
 Náutico Náutico 222
07 Nov 15  Finalizado Náutico Náutico
2 - 0
 Paraná Paraná 0
31 Oct 15  Finalizado Vitória Vitória
2 - 3
 Náutico Náutico 3
24 Oct 15  Finalizado Náutico Náutico
1 - 4
 Botafogo Botafogo 0
17 Oct 15  Finalizado Santa Cruz Santa Cruz
1 - 3
 Náutico Náutico 4
07 Oct 15  Finalizado Náutico Náutico
1 - 0
 Mogi Mirim Mogi Mirim 13
03 Oct 15  Finalizado Oeste Oeste
2 - 0
 Náutico Náutico 0
26 Sep 15  Finalizado Náutico Náutico
3 - 0
 ABC ABCTarjeta Roja 2
19 Sep 15  Finalizado Paysandu Paysandu
0 - 1
 Náutico Náutico 8
16 Sep 15  Finalizado Náutico Náutico
1 - 1
 Atlético GO Atlético GO 25
12 Sep 15  Finalizado América Mineiro América Mineiro
2 - 1
 Náutico Náutico 0
08 Sep 15  Finalizado Ceará Ceará
1 - 0
 Náutico Náutico 86
05 Sep 15  Finalizado Náutico Náutico
1 - 1
 Sampaio Correa Sampaio Correa 6
02 Sep 15  Finalizado Criciúma Criciúma
1 - 0
 Náutico Náutico 37
29 Ago 15  Finalizado Náutico Náutico
1 - 0
 Boa EC Boa ECTarjeta Roja 5
22 Ago 15  Finalizado Luverdense Luverdense
5 - 1
 Náutico Náutico 2
15 Ago 15  Finalizado Náutico Náutico
3 - 1
 RB Bragantino RB Bragantino 0
12 Ago 15  Finalizado Bahía Bahía
1 - 1
 Náutico Náutico 40
08 Ago 15  Finalizado CRB CRB
1 - 0
 Náutico Náutico 1
01 Ago 15  Finalizado Náutico Náutico
1 - 1
 Macaé Esporte Macaé Esporte 5
29 Jul 15  Finalizado Paraná Paraná
2 - 0
 Náutico Náutico 51
25 Jul 15  Finalizado Náutico Tarjeta RojaNáutico
2 - 1
 Vitória VitóriaTarjeta RojaTarjeta Roja 8
18 Jul 15  Finalizado Botafogo Botafogo
1 - 0
 Náutico Náutico 41
11 Jul 15  Finalizado Náutico Tarjeta RojaNáutico
2 - 1
 Santa Cruz Santa Cruz 28
08 Jul 15  Finalizado Mogi Mirim Mogi Mirim
2 - 1
 Náutico NáuticoTarjeta Roja 134
04 Jul 15  Finalizado Náutico Náutico
2 - 1
 Oeste Oeste 27
27 Jun 15  Finalizado ABC ABC
3 - 3
 Náutico Náutico 17
17 Jun 15  Finalizado Náutico Náutico
1 - 1
 Paysandu Paysandu 48
13 Jun 15  Finalizado Atlético GO Atlético GO
2 - 0
 Náutico NáuticoTarjeta Roja 15
06 Jun 15  Finalizado Náutico Náutico
2 - 1
 América Mineiro América Mineiro 83
03 Jun 15  Finalizado Náutico Náutico
2 - 0
 Ceará Ceará 7
30 May 15  Finalizado Sampaio Correa Sampaio Correa
1 - 1
 Náutico Náutico 2
20 May 15  Finalizado Náutico Náutico
2 - 0
 Criciúma Criciúma 9
16 May 15  Finalizado Boa EC Boa EC
0 - 1
 Náutico NáuticoTarjeta Roja 2
09 May 15  Finalizado Náutico Náutico
1 - 0
 Luverdense Luverdense 0
Copa do Nordeste Copa do Nordeste »
19 Mar 15  Finalizado Salgueiro Tarjeta RojaSalgueiro
3 - 1
 Náutico NáuticoTarjeta Roja 0
12 Mar 15  Finalizado Náutico Náutico
1 - 0
 Moto Club MA Moto Club MA 1
06 Mar 15  Finalizado Náutico Náutico
3 - 3
 Piauí Piauí 0
20 Feb 15  Finalizado Piauí Piauí
0 - 2
 Náutico Náutico 0
14 Feb 15  Finalizado Moto Club MA Moto Club MA
3 - 1
 Náutico Náutico 0
05 Feb 15  Finalizado Náutico Náutico
2 - 2
 Salgueiro Salgueiro 0
Pernambucano 1 Pernambucano 1 »
05 Abr 15  Finalizado Salgueiro Tarjeta RojaSalgueiro
4 - 1
 Náutico NáuticoTarjeta Roja 0
22 Mar 15  Finalizado Náutico Tarjeta RojaNáutico
0 - 2
 Sport Recife Sport RecifeTarjeta Roja 0
15 Mar 15  Finalizado Serra Talhada Serra Talhada
0 - 2
 Náutico Náutico 0
08 Mar 15  Finalizado Náutico Náutico
2 - 2
 Central SC Central SC 0
01 Mar 15  Finalizado Santa Cruz Santa Cruz
0 - 0
 Náutico Náutico 0
26 Feb 15  Finalizado Náutico Náutico
1 - 2
 Santa Cruz Santa Cruz 0
22 Feb 15  Finalizado Central SC Central SC
1 - 1
 Náutico Náutico 0
12 Feb 15  Finalizado Náutico Náutico
4 - 0
 Serra Talhada Serra Talhada 0
08 Feb 15  Finalizado Sport Recife Sport Recife
1 - 0
 Náutico Náutico 0
01 Feb 15  Finalizado Náutico Náutico
0 - 0
 Salgueiro Salgueiro 0

Plantilla del Náutico Temporada 2014/2015

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
30 br 197 90 - - -
30 br 189 81 - - -
39 br 186 82 - - 2
42 br 180 - - - -
Defensa
32 br - - - - -
30 br - - - - -
30 br 175 68 - - -
31 br 187 85 2 - -
31 br 181 79 - - -
46 br 183 84 2 - 4
26 br 184 83 - - -
29 br 191 86 - - 1
38 uy 174 71 1 2 14
33 br 176 70 2 - -
28 br 183 79 - - -
27 br 168 67 - - -
29 br 174 71 - - 1
28 br 177 70 - - -
39 br 183 73 4 - 5
34 br 187 79 4 1 5
37 br 194 95 - - -
Centrocampista
35 br - - - - -
29 br 178 - - - -
35 br - - - - -
33 br 180 70 - - 3
30 br 173 70 1 - 1
29 br 173 68 2 - 3
28 br - - - - -
31 br 185 - - - -
32 br 177 70 - - -
38 br 172 60 3 - 4
33 br 174 68 1 - 5
38 br 182 75 2 1 8
30 br 182 79 - - 1
32 br 182 80 3 1 4
36 br 176 76 2 - -
30 br 179 78 - - 1
33 br 177 - 1 - 2
32 br 176 72 - - -
37 br 190 81 1 - 7
Delantero
33 br 181 79 4 - 3
31 br 179 85 1 - 3
- - - 6 - 1
28 br 166 65 - - 1
28 br 175 66 - - -
36 br 183 80 - - -
30 br 187 82 1 - -

Noticias del Náutico

Ver últimas noticias

Givanildo Oliveira regresa al banquillo de Náutico

BeSoccer - Martes, 06 Septiembre 2016
0 85

Givanildo Oliveira regresa a Náutico 14 años después de su anterior etapa en el equipo.

Guaraní se hace con la cesión de Daniel Morais

BeSoccer - Domingo, 04 Septiembre 2016
0 143

El delantero abandona Naútico para contar con más minutos en un equipo de inferior categoría.

Vinícius Goes recala cedido en el Náutico procedente del Atlético Paranaense

BeSoccer - Sábado, 27 Agosto 2016
0 190

El centrocampista Vinícius Goes Barbosa de Souza (25) abandona temporalmente el Atlético Paranaense para incorporarse a préstamo al Náutico.

El Cruzeiro cede a Eurico al Náutico

BeSoccer - Lunes, 16 Mayo 2016
0 212

El centrocampista brasileño sigue dando tumbos. No logra consolidarse en el club de Belo Horizonte.

Rivaldo vuelve a vestirse de corto a los 43

BeSoccer - Miércoles, 08 Julio 2015
0 450

El modesto club Mogi Mirim venció hoy por 2-1 al Náutico en partido por la segunda división del Campeonato Brasileño y que representó, a sus 43 años, el regreso del campeón mundial Rivaldo a las canchas, de las que se había despedido oficialmente en marzo del año pasado.

Ver más noticias del equipo»



  USO DE MEMORIA  
6,562,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2048
Total Execution Time  0.2067
  CADENA URL  
/Nautico-Recife/2015
  GET DATOS  
$_GET['/Nautico-Recife/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0018  SELECT type FROM routes WHERE alias = 'nautico-recife'
0.0036  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Nautico-Recife' AND l.year = 2015 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1780 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1780 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1780 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1780 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1780 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 11072
0.0024  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 9015
0.0026  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 9329
0.0026  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 9509
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1780 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1780 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1918,70979,103790,107299,106449) ORDER BY n.cover_points DESC, update_date DESC
0.0031  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '1780' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0029  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '1780' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 9015 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 9329 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 9509 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 11072 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2015 as c ON c.league_id = l.id WHERE (c.datateam1 = 1780 or c.datateam2 = 1780) AND l.year = 2015 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0037  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2015 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 1780 or c.datateam2 = 1780) AND l.year = 2015 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0035  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2015 as c ON c.league_id = l.id INNER JOIN events2015 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 1780 or c.datateam2 = 1780) AND l.year = 2015)
0.0050  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=1780 AND l.year in (2014,2015,2016) ORDER BY l.id DESC, l.year DESC ;
0.0019  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (23973,20238,20188,13915) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 20238 AND teamId = 1780
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 20188 AND teamId = 1780
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 13915 AND teamId = 1780
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 23973 AND teamId = 1780
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 11072 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1780' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1780' and rp.type = 4
0.0022  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1780' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0057  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2015 e ON e.player_id = p.id AND e.league_id = 11072 WHERE rp.league_id = 11072 AND rp.teamId = 1780 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2015 e ON e.player_id = p.id AND e.league_id = 11072 WHERE rp.league_id = 11072 AND rp.teamId = 1780 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2015 e ON e.player_id = p.id AND e.league_id = 11072 WHERE rp.league_id = 11072 AND rp.teamId = 1780 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1780 AND rp.league_id = 11072 AND l.year= 2015 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0026  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=173839 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0019  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=173839
0.0032  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=173839 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0031  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=173839 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0027  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=173839 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0027   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=173839 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0031  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=173839 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 11072 ORDER BY nameShow LIMIT 100