4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Resistencia
TEMPORADA 2018/2019
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 Guaireña Guaireña 30 49 25 57
2 12 de Octubre Octubre 30 39 28 56
3 2 de Mayo 2 de Mayo 30 48 24 55
4 Atyrá Atyrá 30 46 40 49
5 Resistencia Resistencia 30 49 42 45
6 Fernando de la Mora Fernando 30 43 37 43
7 Independiente FBC Independient 30 37 36 41
8 General Caballero JLM General 30 41 42 41
9 Sportivo Trinidense Sportivo 30 37 36 40
10 3 de Febrero Febrero 30 36 40 39
11 Sportivo Iteño Sportivo 30 35 42 36
12 Rubio Ñu Rubio Ñu 30 32 39 35
13 RI 3 Corrales Corrales 30 32 33 32
14 Ovetense Ovetense 30 29 46 29
15 Fulgencio Yegros Fulgencio 30 25 45 24
16 Deportivo Caaguazú Deportivo 30 23 46 23
TEMPORADA 2017/2018
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 Club River Plate Club River. 30 41 26 55
2 Sportivo San Lorenzo Sportivo 30 47 30 51
3 Fernando de la Mora Fernando 30 41 28 51
4 Guaireña Guaireña 30 38 23 50
5 2 de Mayo 2 de Mayo 30 48 41 46
6 Rubio Ñu Rubio Ñu 30 40 38 44
7 Fulgencio Yegros Fulgencio 30 33 39 41
8 Resistencia Resistencia 30 32 33 40
9 CD Liberación Liberación 30 36 44 39
10 Sportivo Trinidense Sportivo 30 34 30 38
11 RI 3 Corrales Corrales 30 39 44 37
12 Ovetense Ovetense 30 29 35 36
13 General Caballero SC General 30 39 46 35
14 Sportivo Iteño Sportivo 30 35 41 34
15 Deportivo Caaguazú Deportivo 30 34 44 33
16 Martín Ledesma Martín 30 25 49 21
TEMPORADA 2016/2017
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 3 de Febrero Febrero 30 47 28 56
2 Deportivo Santaní Deportivo 30 45 27 55
3 Fulgencio Yegros Fulgencio 30 43 32 49
4 Resistencia Resistencia 30 52 46 47
5 CD Liberación Liberación 30 41 47 43
6 Ovetense Ovetense 30 42 39 42
7 Martín Ledesma Martín 30 49 45 41
8 Deportivo Caaguazú Deportivo 30 40 41 41
9 Guaireña Guaireña 30 37 34 40
10 Sportivo Iteño Sportivo 30 31 33 39
11 Club River Plate Club River. 30 42 37 38
12 General Caballero SC General 30 37 36 38
13 22 de Setiembre Setiembre 30 36 34 37
14 Fernando de la Mora Fernando 30 38 46 35
15 Caacupé Caacupé 30 30 44 28
16 Olimpia Itá Olimpia Itá 30 33 74 15
TEMPORADA 2015/2016
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 Independiente FBC Independient 30 59 31 62
2 Sportivo Trinidense Sportivo 30 44 36 52
3 Resistencia Resistencia 30 34 34 48
4 Deportivo Santaní Deportivo 30 42 34 45
5 Deportivo Caaguazú Deportivo 30 41 39 43
6 Sportivo Iteño Sportivo 30 35 42 42
7 3 de Febrero Febrero 30 41 35 41
8 Fernando de la Mora Fernando 30 39 37 41
9 Caacupé Caacupé 30 44 42 40
10 Fulgencio Yegros Fulgencio 30 50 50 40
11 Olimpia Itá Olimpia Itá 30 30 35 40
12 Ovetense Ovetense 30 47 45 38
13 Sportivo San Lorenzo Sportivo 30 38 35 36
14 Cristóbal Colón Cristóbal 30 40 47 34
15 CD Liberación Liberación 30 37 51 28
16 Sport Colombia Sport 30 29 57 27
TEMPORADA 2014/2015
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 Club River Plate Club River. 30 41 29 54
2 Fernando de la Mora Fernando 30 45 25 53
3 General Caballero SC General 30 45 33 52
4 CD Liberación Liberación 30 40 31 50
5 Deportivo Caaguazú Deportivo 30 33 26 46
6 Resistencia Resistencia 30 29 23 45
7 Sportivo Iteño Sportivo 30 33 32 43
8 Caacupé Caacupé 30 45 39 42
9 Cristóbal Colón Cristóbal 30 45 48 42
10 3 de Febrero Febrero 30 27 18 40
11 Independiente FBC Independient 30 39 44 34
12 Sportivo Trinidense Sportivo 30 34 43 29
13 Sport Colombia Sport 30 27 42 29
14 Tacuary Tacuary 30 22 30 27
15 Sportivo Carapeguá Sportivo 30 32 50 26
16 12 de Octubre Octubre 30 28 52 23
TEMPORADA 2013/2014
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 Sportivo San Lorenzo Sportivo 30 40 20 57
2 Deportivo Santaní Deportivo 30 36 22 57
3 Resistencia Resistencia 30 34 25 47
4 Sportivo Iteño Sportivo 30 35 29 47
5 Independiente FBC Independient 30 33 32 44
6 Sportivo Trinidense Sportivo 30 39 34 43
7 Deportivo Caaguazú Deportivo 30 36 27 42
8 Club River Plate Club River. 30 37 37 42
9 Sport Colombia Sport 30 34 29 39
10 Caacupé Caacupé 30 32 35 39
11 Sportivo Carapeguá Sportivo 30 30 31 36
12 Tacuary Tacuary 30 36 39 36
13 General Caballero SC General 30 34 36 34
14 Paranaense FC Paranaense 30 26 46 30
15 Olimpia Itá Olimpia Itá 30 33 51 27
16 PF Cerro Por. Cerro Por. 30 23 45 26
TEMPORADA 2012/2013
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 3 de Febrero Febrero 30 42 28 52
2 12 de Octubre Octubre 30 45 28 51
3 Sportivo Trinidense Sportivo 30 30 21 49
4 Tacuary Tacuary 30 37 23 48
5 Sport Colombia Sport 30 35 28 47
6 Independiente FBC Independient 30 34 32 47
7 Paranaense FC Paranaense 30 34 38 40
8 General Caballero SC General 30 30 31 39
9 Caacupé Caacupé 30 29 32 38
10 Fernando de la Mora Fernando 30 31 33 36
11 Resistencia Resistencia 30 37 37 35
12 Deportivo Santaní Deportivo 30 39 40 34
13 Club River Plate Club River. 30 30 39 33
14 Sportivo San Lorenzo Sportivo 30 29 35 30
15 Martín Ledesma Martín 30 31 53 30
16 2 de Mayo 2 de Mayo 30 24 39 26
TEMPORADA 2011/2012
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 General Díaz General 30 48 22 60
2 Dep. Capiatá Dep. 30 61 37 58
3 Deportivo Santaní Deportivo 30 46 27 54
4 Sportivo San Lorenzo Sportivo 30 40 35 48
5 Sportivo Trinidense Sportivo 30 34 33 46
6 Sport Colombia Sport 30 48 33 44
7 3 de Febrero Febrero 30 48 41 42
8 General Caballero SC General 30 31 33 42
9 Club River Plate Club River. 30 38 45 41
10 2 de Mayo 2 de Mayo 30 36 37 40
11 Resistencia Resistencia 30 43 45 40
12 Fernando de la Mora Fernando 30 31 40 36
13 Paranaense FC Paranaense 30 31 39 34
14 CA Colegiales Colegiales 30 22 29 33
15 Sportivo Iteño Sportivo 30 35 60 23
16 29 de Setiembre Setiembre 30 28 64 17

  USO DE MEMORIA  
5,950,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5598
Total Execution Time  0.5611
  CADENA URL  
/historico/Resistencia/2019
  GET DATOS  
$_GET['/historico/Resistencia/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0172  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 = 'Resistencia' AND l.year = 2019 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.0131  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=6527 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=6527 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=6527 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 48876
0.0131  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 = 49749
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6527 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6527 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0130  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 (269924,540488,623620,1053484,1105167) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = '6527' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '6527' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = 49749 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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 = 48876 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138  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=6527 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (53794,49749) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 53794 AND teamId = 6527
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 49749 AND teamId = 6527
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2019` 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 = 48876 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '6527' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6527' and rp.type = 4
0.0135  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 = '6527' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0193  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 events2019 e ON e.player_id = p.id AND e.league_id = 48876 WHERE rp.league_id = 48876 AND rp.teamId = 6527 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.0156  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 events2019 e ON e.player_id = p.id AND e.league_id = 48876 WHERE rp.league_id = 48876 AND rp.teamId = 6527 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 events2019 e ON e.player_id = p.id AND e.league_id = 48876 WHERE rp.league_id = 48876 AND rp.teamId = 6527 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 6527 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0139  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 48876 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 42469 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 37858 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 20478 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 10890 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 3677 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 2416 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` 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 = 1642 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC