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

¿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 Independiente FC

Enviar Datos
Información
Otros Datos
  • Año de Fundación 1946
  • Patrocinador Alcaldía de San Vicente
  • Marca de Ropa Milan
Internet

Información sobre el estadio

  • Nombre del estadio Estadio Jiboa
  • Capacidad 8000
Estadio Jiboa

Partidos del Independiente FC

Ir al LIVESCORE
Clausura Primera División El Salvador Clausura Primera División El Salvador »
28 Abr 18  Finalizado FAS
4 - 1
 Independiente FC 1
22 Abr 18  Finalizado Tarjeta RojaIndependiente FC
2 - 1
 L.A. Firpo 5
18 Abr 18  Finalizado Tarjeta RojaIndependiente FC
3 - 1
 CD Águila 1
15 Abr 18  Finalizado Tarjeta RojaSonsonate FC
2 - 2
 Independiente FC 2
08 Abr 18  Finalizado Independiente FC
2 - 0
 Isidro MetapánTarjeta Roja 1
04 Abr 18  Finalizado Municipal Limeño
2 - 0
 Independiente FC 6
29 Mar 18  Finalizado Independiente FC
2 - 1
 Alianza 43
25 Mar 18  Finalizado CD Dragon
1 - 2
 Independiente FC 0
22 Mar 18  Finalizado Independiente FC
0 - 3
 Santa Tecla 8
18 Mar 18  Finalizado Chalatenango
3 - 0
 Independiente FC 0
11 Mar 18  Finalizado Independiente FC
2 - 1
 Pasaquina FC 0
07 Mar 18  Finalizado Independiente FC
2 - 3
 FAS 3
25 Feb 18  Finalizado Tarjeta RojaL.A. Firpo
1 - 0
 Independiente FC 5
21 Feb 18  Finalizado Tarjeta RojaCD Águila
1 - 1
 Independiente FC 0
18 Feb 18  Finalizado Independiente FC
1 - 2
 Sonsonate FCTarjeta Roja 4
11 Feb 18  Finalizado Isidro Metapán
1 - 2
 Independiente FC 4
07 Feb 18  Finalizado Independiente FC
2 - 2
 Municipal LimeñoTarjeta Roja 0
04 Feb 18  Finalizado Alianza
2 - 0
 Independiente FC 3
28 Ene 18  Finalizado Tarjeta RojaIndependiente FC
1 - 1
 CD Dragon 2
26 Ene 18  Finalizado Santa Tecla
4 - 0
 Independiente FCTarjeta RojaTarjeta Roja 5
21 Ene 18  Finalizado Independiente FC
0 - 0
 Chalatenango 1
13 Ene 18  Finalizado Pasaquina FC
3 - 0
 Independiente FC 5
El Salvador Play Offs Clausura El Salvador Play Offs Clausura »
14 May 18  Finalizado Santa Tecla
4 - 0
 Independiente FC 6
10 May 18  Finalizado Independiente FC
1 - 2
 Santa Tecla 11
06 May 18  Finalizado FAS
2 - 3
 Independiente FC 6
01 May 18  Finalizado Independiente FC
1 - 1
 FAS 2
Apertura Primera División El Salvador Apertura Primera División El Salvador »
25 Nov 17  Finalizado Independiente FC
1 - 2
 Chalatenango 4
19 Nov 17  Finalizado Sonsonate FC
3 - 2
 Independiente FC 4
16 Nov 17  Finalizado Independiente FC
2 - 2
 CD ÁguilaTarjeta Roja 15
12 Nov 17  Finalizado Municipal Limeño
4 - 0
 Independiente FC 5
05 Nov 17  Finalizado Independiente FC
2 - 3
 Alianza 7
29 Oct 17  Finalizado Independiente FC
4 - 3
 Isidro Metapán 3
23 Oct 17  Finalizado Santa Tecla
3 - 2
 Independiente FC 7
19 Oct 17  Finalizado Tarjeta RojaIndependiente FC
1 - 0
 CD Dragon 0
15 Oct 17  Finalizado FAS
2 - 1
 Independiente FC 3
12 Oct 17  Finalizado L.A. Firpo
1 - 1
 Independiente FC 0
08 Oct 17  Finalizado Tarjeta RojaIndependiente FC
2 - 2
 Pasaquina FC 1
24 Sep 17  Finalizado Chalatenango
0 - 0
 Independiente FCTarjeta Roja 1
17 Sep 17  Finalizado Independiente FC
3 - 2
 Sonsonate FC 1
13 Sep 17  Finalizado Tarjeta RojaTarjeta RojaCD Águila
1 - 0
 Independiente FCTarjeta Roja 2
10 Sep 17  Finalizado Independiente FC
0 - 2
 Municipal Limeño 5
03 Sep 17  Finalizado Alianza
4 - 1
 Independiente FC 3
30 Ago 17  Finalizado CD Dragon
1 - 2
 Independiente FC 8
27 Ago 17  Finalizado Isidro Metapán
2 - 0
 Independiente FC 1
20 Ago 17  Finalizado Independiente FC
2 - 1
 Santa Tecla 7
13 Ago 17  Finalizado Independiente FC
1 - 0
 FAS 8
05 Ago 17  Finalizado Pasaquina FC
2 - 1
 Independiente FCTarjeta Roja 4
30 Jul 17  Finalizado Independiente FC
0 - 0
 L.A. Firpo 7
Copa El Salvador Copa El Salvador »
01 May 19  Finalizado Santa Tecla
1 - 0
 Independiente FC 4
28 Mar 19  Finalizado Independiente FC
1 - 0
 Jocoro 7
26 Mar 19  Finalizado Jocoro
1 - 2
 Independiente FC 0
22 Mar 19  Finalizado Independiente FC
1 - 2
 L.A. Firpo 0
21 Mar 19  Finalizado L.A. Firpo
0 - 3
 Independiente FC 0
06 Mar 19  Finalizado Independiente FC
0 - 1
 Vendaval 0
06 Feb 19  Finalizado Vendaval
0 - 1
 Independiente FC 0
31 Ene 19  Finalizado Independiente FC
1 - 1
 CD Platense 0
14 Nov 18  Finalizado CD Platense
0 - 0
 Independiente FC 0

Plantilla del Independiente FC Temporada 2017/2018

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
29 sv 176 73 - - -
29 sv 178 77 - - -
Defensa
38 sv - - 1 - -
34 sv 172 69 - - -
25 sv 173 71 2 - 4
42 sv 180 75 - - -
42 sv - - - - 3
36 hn 170 - 2 1 1
30 sv 168 73 2 - 3
38 sv 185 75 - 1 2
35 co 178 96 1 - 3
Centrocampista
31 sv 172 73 1 - 6
38 ar 176 75 2 - 1
40 sv - - - 1 8
26 sv 168 66 - - -
31 sv 167 70 - - 3
32 sv 174 76 3 - 1
25 sv 173 75 - - -
- sv - - - - -
41 sv 178 76 - 1 8
24 sv - - 1 - -
32 sv 175 72 - 1 -
33 sv - - - - 1
Delantero
28 sv 174 71 - - -
39 co 176 65 6 - -
36 sv 173 76 - - 1
34 sv 178 70 - - 4
30 sv 174 71 4 - 2

Noticias del Independiente FC

Ver últimas noticias

Debut a lo 'Loco': Abreu gana la Copa con polémica y bajo un diluvio

BeSoccer - Miércoles, 01 Mayo 2019
0 2.513

Santa Tecla se proclamó campeón de la Copa de El Salvador en el debut de Sebastián el 'Loco' Abreu al frente del banquillo del que fuese uno de sus muchos ex equipos.

Un 'hat trick' de Díaz impulsó a Alianza al liderato

BeSoccer - Lunes, 08 Abril 2019
0 317

Alianza goleó con contundencia a Audaz gracias a una gran actuación de Díaz. El futbolista 'cafetero' anotó un 'hat trick' para redondear el 6-2. Tres puntos muy importantes para los de Jorge Humberto Rodríguez que siguen en lo más alto de la clasificación.

Al todo o nada sin Acosta

BeSoccer - Viernes, 30 Noviembre 2018
0 1.001

Águila se enfrentará a Audaz en el partido de vuelta de los cuartos de final del torneo Apertura de El Salvador, con la ausencia del delantero uruguayo Waldemar Acosta, su máximo goleador, quien sufrió una fractura de tibia que lo deja fuera de las canchas al menos 3 meses.

Resumen de la penúltima jornada en El Salvador

BeSoccer - Viernes, 23 Noviembre 2018
0 258

Alianza, Santa Tecla, Águila , Futbolistas Asociados Santanecos (FAS), Metapán y Audaz son los primeros equipos clasificados a la liguilla (cuartos de final) del torneo Apertura de El Salvador, tras finalizar la penúltima jornada del certamen que el pasado domingo quedó en pausa y continuó este jueves.

Alianza afianza su liderato a costa de Audaz

BeSoccer - Lunes, 05 Febrero 2018
1 267

Alianza doblegó hoy por 2-0 al cuadro benjamín del fútbol salvadoreño, el Audaz, para afianzar el liderato del Clausura 2018 y sumar 32 partidos sin conocer la derrota.

Ver más noticias del equipo»



  USO DE MEMORIA  
5,987,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2189
Total Execution Time  0.2209
  CADENA URL  
/Cd-Audaz/2018
  GET DATOS  
$_GET['/Cd-Audaz/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0019  SELECT type FROM routes WHERE alias = 'cd-audaz'
0.0033  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 = 'Cd-Audaz' AND l.year = 2018 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.0018  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=101733 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=101733 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=101733 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=101733 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=101733 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 42066
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 = 38706
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 = 43349
0.0027  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 = 47412
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=101733 AND type_rel = 2
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 101733 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0028  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 (373227,542140,546628,613382,625832) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '101733' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '101733' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0037  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 = '101733' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 43349 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 38706 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 42066 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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 = 47412 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  (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 calendars2018 as c ON c.league_id = l.id WHERE (c.datateam1 = 101733 or c.datateam2 = 101733) AND l.year = 2018 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0094  (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 calendars2018 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 = 101733 or c.datateam2 = 101733) AND l.year = 2018 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0049  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2018 as c ON c.league_id = l.id INNER JOIN events2018 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 = 101733 or c.datateam2 = 101733) AND l.year = 2018)
0.0031  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=101733 AND l.year in (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0025  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 (48626,48283,47412,44244,43349) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 48626 AND teamId = 101733
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 44244 AND teamId = 101733
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 48283 AND teamId = 101733
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 43349 AND teamId = 101733
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 47412 AND teamId = 101733
0.0030  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2018` 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 = 42066 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025  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 = '101733' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '101733' and rp.type = 4
0.0020  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 = '101733' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044  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 events2018 e ON e.player_id = p.id AND e.league_id = 42066 WHERE rp.league_id = 42066 AND rp.teamId = 101733 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.0034  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 events2018 e ON e.player_id = p.id AND e.league_id = 42066 WHERE rp.league_id = 42066 AND rp.teamId = 101733 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 events2018 e ON e.player_id = p.id AND e.league_id = 42066 WHERE rp.league_id = 42066 AND rp.teamId = 101733 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 101733 AND rp.league_id = 42066 AND l.year= 2018 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0023  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=854418 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=854418
0.0025  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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=854418 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.0029  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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=854418 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0024  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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=854418 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0022   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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=854418 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0024  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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=854418 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 = 42066 ORDER BY nameShow LIMIT 100
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 216 AND l.year = 2018 ORDER BY l.group_code ASC