4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ipswich Town

Ipswich Town

Entrenador: Kieran McKenna

Información
  • Nombre del equipo Ipswich Town
  • Nombre completo Ipswich Town Football C
  • Nombre corto IPS
  • País Inglaterra
  • Ciudad Ipswich
  • Entrenador Kieran McKenna
  • URL del equipo en RF //m.resultados-futbol.com/Ipswich-Town-Fc
Otros Datos
  • Año de Fundación 1878
  • Patrocinador Ed Sheeran
  • Marca de Ropa Umbro
Internet
Información sobre el estadio
  • Nombre del estadio Portman Road Stadium
  • Capacidad 30311
  • Dirección Portman Road
  • Teléfono +44 (1473) 400 500
  • Fax +44 (1473) 400 040
  • Año de construcción 1884
  • Tamaño 102x75
Portman Road Stadium
Histórico de participación
FA Cup
EFL Cup
Championship
Premier League
Partidos Amistosos
11 veces
Europa League
10 veces
EFL Trophy
7 veces
League One Grupo 1
4 veces
Championship - Play Offs Ascenso
2 veces
(2016, 2015)
Community Shield
2 veces
(1979, 1963)
Trofeo Joan Gamper
1 vez
(1982)
Champions League
1 vez
(1963)
Fase Previa Europa League
1 vez
(2003)
Recopa de Europa
1 vez
(1979)
Partidos del Ipswich Town Ir al LIVESCORE
17 Ene 17  Finalizado Lincoln City
1 - 0
Ipswich Town 49
07 Ene 17  Finalizado Ipswich Town
2 - 2
Lincoln City 10
09 Ago 16  Finalizado Ipswich Town
0 - 1
Stevenage 3
07 May 17  Finalizado Nottingham Forest
3 - 0
Ipswich Town 8
29 Abr 17  Finalizado Ipswich Town
0 - 1
Sheffield Wednesday 1
22 Abr 17  Finalizado Rotherham United
1 - 0
Ipswich Town 3
17 Abr 17  Finalizado Ipswich Town
3 - 1
Newcastle 48
14 Abr 17  Finalizado Burton Albion
1 - 2
Ipswich Town 10
08 Abr 17  Finalizado Fulham
3 - 1
Ipswich Town 2
04 Abr 17  Finalizado Ipswich Town
3 - 0
Wigan Athletic 3
01 Abr 17  Finalizado Ipswich Town
1 - 1
Birmingham City 1
18 Mar 17  Finalizado Cardiff City
3 - 1
Ipswich Town 3
11 Mar 17  Finalizado Barnsley
1 - 1
Ipswich Town 2
07 Mar 17  Finalizado Ipswich Town
0 - 0
Wolves 19
04 Mar 17  Finalizado Ipswich Town
1 - 1
Brentford 1
26 Feb 17  Finalizado Norwich City
1 - 1
Ipswich Town 16
18 Feb 17  Finalizado Ipswich Town
1 - 1
Leeds United 14
14 Feb 17  Finalizado Brighton & Hove Albion
1 - 1
Ipswich Town 55
11 Feb 17  Finalizado Aston Villa
0 - 1
Ipswich Town 7
04 Feb 17  Finalizado Ipswich Town
2 - 2
Reading 14
31 Ene 17  Finalizado Ipswich Town
0 - 3
Derby County 5
28 Ene 17  Finalizado Preston North End
1 - 1
Ipswich Town 5
21 Ene 17  Finalizado Huddersfield Town
2 - 0
Ipswich Town 5
14 Ene 17  Finalizado Ipswich Town
3 - 2
Blackburn Rovers 2
02 Ene 17  Finalizado Queens Park Rangers
2 - 1
Ipswich Town 8
30 Dic 16  Finalizado Ipswich Town
2 - 1
Bristol City 48
26 Dic 16  Finalizado Ipswich Town
0 - 2
Fulham 16
17 Dic 16  Finalizado Wigan Athletic
2 - 3
Ipswich Town 4
13 Dic 16  Finalizado Birmingham City
2 - 1
Ipswich Town 9
10 Dic 16  Finalizado Ipswich Town
1 - 1
Cardiff CityTarjeta Roja 1
03 Dic 16  Finalizado Bristol City
2 - 0
Ipswich Town 2
26 Nov 16  Finalizado Ipswich Town
3 - 0
Queens Park Rangers 1
19 Nov 16  Finalizado Ipswich Town
0 - 2
Nottingham Forest 1
05 Nov 16  Finalizado Sheffield Wednesday
1 - 2
Ipswich Town 4
29 Oct 16  Finalizado Ipswich Town
2 - 2
Rotherham United 6
22 Oct 16  Finalizado Newcastle
3 - 0
Ipswich Town 12
18 Oct 16  Finalizado Ipswich Town
2 - 0
Burton Albion 3
15 Oct 16  Finalizado Blackburn Rovers
0 - 0
Ipswich Town 5
01 Oct 16  Finalizado Ipswich Town
0 - 1
Huddersfield Town 4
27 Sep 16  Finalizado Ipswich Town
0 - 0
Brighton & Hove AlbionTarjeta Roja 2
24 Sep 16  Finalizado Leeds United
1 - 0
Ipswich Town 2
17 Sep 16  Finalizado Ipswich Town
0 - 0
Aston Villa 3
13 Sep 16  Finalizado Derby County
0 - 1
Ipswich Town 1
09 Sep 16  Finalizado Reading
2 - 1
Ipswich Town 13
27 Ago 16  Finalizado Ipswich Town
1 - 0
Preston North End 3
21 Ago 16  Finalizado Ipswich Town
1 - 1
Norwich City 6
16 Ago 16  Finalizado Wolves
0 - 0
Ipswich Town 6
13 Ago 16  Finalizado Brentford
2 - 0
Ipswich Town 1
06 Ago 16  Finalizado Ipswich Town
4 - 2
Barnsley 5
30 Jul 16  Finalizado Ipswich Town
1 - 2
Union Saint-Gilloise 2
26 Jul 16  Finalizado Charlton Athletic
0 - 0
Ipswich Town 3
23 Jul 16  Finalizado Cambridge United
1 - 1
Ipswich Town 1
20 Jul 16  Finalizado Colchester United
0 - 1
Ipswich Town 1
13 Jul 16  Finalizado Barnet
1 - 0
Ipswich Town 5
09 Jul 16  Finalizado Shelbourne
1 - 2
Ipswich Town 1

Plantilla del Ipswich Town Temporada 2016/2017

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
33 36 pl 194 86 - - -
1 38 gb 183 76 - - -
35 28 wa 188 75 - - -
Defensa
15 29 gb 190 75 1 - 1
6 39 ss 186 81 2 - 8
18 29 gb 178 73 6 - 2
29 26 gb 180 98 - - 3
3 31 dk 185 72 2 - 7
27 gb 185 73 - - -
12 33 gb 182 76 - - 1
28 gb 180 68 - - -
4 38 gb 185 87 4 - 7
30 27 gb 185 67 - - 2
41 24 gb 183 70 - - -
2 38 gb 188 81 - - -
5 33 nz 187 77 - - -
Centrocampista
26 ie 174 72 - - -
23 24 gb 178 64 - - 2
8 37 gb 185 72 - - 6
44 30 wa 174 78 3 - 1
43 25 gb 178 70 - - -
20 34 gb 170 67 7 - 2
37 gb 183 75 - - -
22 42 ie 180 75 - - 3
40 gb 170 63 - - -
21 30 wa 168 60 - - -
26 zw 178 63 - - -
17 35 mu 183 78 1 - 4
32 gb 178 72 - - -
14 29 gb 193 64 - - -
7 27 gb 178 67 - - 2
37 36 fr 188 72 - - 3
45 24 gb 170 60 - - -
Delantero
45 ie 188 86 - - -
11 36 je 183 69 4 - 4
32 24 gb 175 60 - - -
32 gb 172 72 - - -
28 ie 176 69 - - -
10 36 ie 184 74 5 - 4
28 gb 174 70 - - -
35 32 gb 183 76 - - -
42 29 gb 188 89 2 - 1
29 gb 185 75 - - -
28 31 wa 196 83 - - -
9 37 ie 185 76 - - -
39 gn 184 78 - - -
27 30 wa 175 69 9 - 11
Noticias del Ipswich Town
Ver últimas noticias

Bialkowski renueva con el Ipswich Town

El guardameta polaco ha llegado a un acuerdo con el club inglés para prolongar su contrato, que expiraba a final de temporada.

Pringle, cedido por el Fulham al Ipswich Town

El centrocampista Ben Pringle jugará en calidad de préstamo en el Ipswich Town debido a la falta de continuidad que sufría en el Fulham. El jugador de 27 años no competía con el club que lo tiene en propiedad desde diciembre.

Tommy Oar, último objetivo del Betis para fortalecer la banda izquierda

El jugador, de 24 años, formaba parte hasta ahora del Ipswich Town y el Betis ha preguntado por él para aumentar la competencia de la banda izquierda y tener un extremo más puro de lo que ya tiene en la plantilla.

Varney retorna al Ipswich Town

El atacante ya jugó la pasada temporada allí, cedido por el Blackburn Rovers. Tras recuperarse de una lesión en el talón de aquiles, volverá hasta final de temporada.

El United quiere dejar el listón bien alto en la Capital One Cup ante el Ipswich

El United recibe en Old Trafford al Ipswich Town en la tercera ronda de la Capital One Cup. Los de Van Gaal están dispuestos a dar un golpe sobre la mesa y sacar una importante victoria.



Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,571,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6258
Total Execution Time  0.6276
  CADENA URL  
/Ipswich-Town-Fc/2017
  GET DATOS  
$_GET['/Ipswich-Town-Fc/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0105  SELECT type FROM routes WHERE alias = 'ipswich-town-fc'
0.0125  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 = 'Ipswich-Town-Fc' AND l.year = 2017 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.0105  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=1387 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1387 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1387 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1387 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1387 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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 = 30627
0.0110  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 = 33348
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1387 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1387 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0110  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 (13421,29565,36820,41778,43438) ORDER BY n.cover_points DESC, update_date DESC
0.0116  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 = '1387' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0116  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 = '1387' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 30627 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  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 = 33348 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 33979 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  (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 calendars2017 as c ON c.league_id = l.id WHERE (c.datateam1 = 1387 or c.datateam2 = 1387) AND l.year = 2017 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0120  (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 calendars2017 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 = 1387 or c.datateam2 = 1387) AND l.year = 2017 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0110  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2017 as c ON c.league_id = l.id INNER JOIN events2017 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 = 1387 or c.datateam2 = 1387) AND l.year = 2017)
0.0116  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=1387 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (38989,38752,38634,38427,28003) 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.0117  SELECT count(id) as num_players from rel_players WHERE league_id = 38634 AND teamId = 1387
0.0114  SELECT count(id) as num_players from rel_players WHERE league_id = 38989 AND teamId = 1387
0.0119  SELECT count(id) as num_players from rel_players WHERE league_id = 38752 AND teamId = 1387
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 28003 AND teamId = 1387
0.0196  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 1387
0.0112  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2017` 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 = 30627 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '1387' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1387' and rp.type = 4
0.0106  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 = '1387' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125  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 events2017 e ON e.player_id = p.id AND e.league_id = 30627 WHERE rp.league_id = 30627 AND rp.teamId = 1387 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.0125  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 events2017 e ON e.player_id = p.id AND e.league_id = 30627 WHERE rp.league_id = 30627 AND rp.teamId = 1387 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120  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 events2017 e ON e.player_id = p.id AND e.league_id = 30627 WHERE rp.league_id = 30627 AND rp.teamId = 1387 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113  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 = 1387 AND rp.league_id = 30627 AND l.year= 2017 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0114  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=704301 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0106  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=704301
0.0120  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 events2017 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=704301 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.0114  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 events2017 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=704301 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0112  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 events2017 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=704301 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0111   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 events2017 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=704301 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0114  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 events2017 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=704301 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0106  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 = 30627 ORDER BY nameShow LIMIT 100