4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Libertad De Charata Libertad 7 12 7 13
2 Fontana Fontana 6 12 7 11
3 Avenida De Villa Ángela Avenida 7 9 15 9
4 Sportivo Pampa Sportivo 6 6 6 7
5 Juventud Unida Charata Juventud 6 4 8 5
6 Resistencia Central Resistencia 7 17 11 16
7 Atletico Falucho Atletico 6 9 7 8
8 Deportivo Municipal Leonesa Deportivo 6 10 11 8
9 Villa Alvear Villa Alvear 7 14 15 7
10 Ex Alumnos 185 Alumnos 6 10 16 5
11 Deportivo victoria De Curuz Deportivo 4 8 3 9
12 Sportivo Santa Lucía Sportivo 4 4 2 9
13 Barrio Norte Barrio Norte 4 3 10 0
14 Ferroviario Corrientes Ferroviario 4 9 6 9
15 Cambá Cuá Cambá Cuá 4 7 6 6
16 Defensores De San Roque Defensores 4 6 10 3
17 Puente Seco Puente Seco 4 6 4 8
18 Apinta Apinta 4 4 3 7
19 Genaro Beron De Astrada Genaro Beron 4 2 5 1
20 Atlético Posadas Atlético 3 5 3 6
21 Santo Pipo Santo Pipo 4 6 7 6
22 La Picada La Picada 3 3 4 3
23 Guaraní A. Franco Guaraní 4 6 1 8
24 Deportivo Nacional Deportivo 4 3 4 4
25 Timbó Timbó 4 3 7 4
26 8 De Diciembre Diciembre 4 7 3 8
27 Juventud Clorinda Juventud 4 6 5 5
28 Rolando Hertelendy Rolando 4 1 6 2
29 Sol de América Formosa América 4 12 1 8
30 Primero de Mayo Primero Mayo 4 8 1 8
31 Sargento Cabral Sargento 4 0 18 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Guaraní A. Franco Guaraní 8 24 6 19
2 Santo Pipo Santo Pipo 8 17 6 18
3 Deportivo Nacional Deportivo 8 12 16 11
4 Atletico Barcelona Atletico 8 7 15 5
5 Deportivo Jardin America Deportivo 8 6 23 2
6 Huracán Goya Huracán 8 16 9 15
7 Deportivo Madariaga Deportivo 8 16 10 14
8 Comunicaciones Comunicacion 8 10 10 13
9 Central Goya Central Goya 8 14 17 10
10 Victoria Corrientes Victoria 8 8 18 3
11 Deportivo Curupay Deportivo 8 12 6 16
12 Ferroviario Corrientes Ferroviario 8 15 15 13
13 Cambá Cuá Cambá Cuá 8 8 5 12
14 Defensores Pt. Vilelas Defensores 8 13 13 9
15 CD Mandiyú CD Mandiyú 8 13 22 4
16 Sol de América Formosa América 6 21 4 16
17 Libertad Formosa Libertad 6 13 14 10
18 Juventud Formosa Juventud 6 12 15 7
19 9 de Julio Clorinda Julio 6 5 18 1
20 Sportivo Pampa Sportivo 6 14 10 13
21 Cooperativa Textil Cooperativa 6 13 9 12
22 Juventud Puerto Tirol Juventud 6 16 12 10
23 Sportivo Español Sportivo 6 8 20 0
24 Resistencia Central Resistencia 6 10 9 8
25 Estudiantes Resistencia Estudiantes 6 5 6 7
26 Don Orione Don Orione 6 8 8 6
27 Villa Alvear Villa Alvear 6 5 5 6
28 Fontana Fontana 6 14 7 13
29 Atletico Falucho Atletico 6 7 5 9
30 Pabellon Argentino Pabellon 6 12 14 9
31 Recreativo Toba Recreativo 6 9 16 2
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Deportivo Achirense Deportivo 18 35 13 35
2 Belgrano Paraná Belgrano 18 20 18 31
3 Libertad Concordia Libertad 18 20 14 29
4 Santa María de Oro Santa María 18 23 26 29
5 Atlético Uruguay Atlético 18 25 20 28
6 Arsenal Viale Arsenal 18 17 19 24
7 Atlético Villa Elisa Atlético 18 27 23 23
8 Cosmos Cosmos 18 17 23 16
9 Viale FC María Grande Viale María 18 12 22 16
10 Colegiales Concordia Colegiales 18 15 33 14
11 Atlético San Jorge Atlético 18 27 16 36
12 Rivadavia Venado Tuerto Rivadavia 18 30 16 33
13 Coronel Aguirre Coronel 18 32 29 29
14 9 de Julio Rafaela Julio 18 28 21 27
15 PSM Futbol PSM Futbol 18 25 18 27
16 Ben Hur Ben Hur 18 24 17 26
17 Unión Totoras Unión 18 11 22 19
18 Tiro Federal Rosario Tiro Federal 18 12 24 18
19 ADIUR ADIUR 18 15 28 15
20 Juventud Pueyrredón Juventud 18 25 38 11
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Rivadavia Lincoln Rivadavia 8 11 2 16
2 Independiente Chivilcoy Independient 8 9 10 13
3 Defensores de Salto Defensores 8 7 7 10
4 Belgrano San Nicolás Belgrano 8 2 8 8
5 Camioneros Bs As Camioneros 8 7 9 6
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 La Emilia La Emilia 20 35 24 34
2 Rivadavia Venado Tuerto Rivadavia 20 36 28 33
3 Belgrano San Nicolás Belgrano 20 19 12 32
4 Defensores de Salto Defensores 20 27 21 31
5 Coronel Aguirre Coronel 20 23 18 30
6 Baradero Baradero 20 24 18 27
7 PSM Futbol PSM Futbol 20 20 18 26
8 Sports Salto Sports Salto 20 25 28 25
9 General Rojo UD General Rojo 20 30 35 25
10 Obrero Obrero 20 20 21 24
11 Aprendices Casildenses Aprendices 20 9 45 6
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Atlético Uruguay Atlético 2 4 2 3
2 Alianza Cutral Có Alianza 2 4 4 3
3 CD Coreano CD Coreano 2 4 4 3
4 Candelaria Candelaria 2 2 2 3
5 Gimnasia y Tiro Gimnasia 2 2 2 3
6 AD Centenario Centenario 2 2 4 3

  USO DE MEMORIA  
6,143,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.4847
Total Execution Time  0.4882
  CADENA URL  
/torneo_federal_b2020/grupo4/historico
  GET DATOS  
$_GET['/torneo_federal_b2020/grupo4/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0144  SELECT type FROM routes WHERE alias = 'torneo_federal_b2020'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_federal_b' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1814 AND type_rel = 3
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1814 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0151  SELECT /*53 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 (972114,959057,847992,847587,838566) ORDER BY n.cover_points DESC, update_date DESC
0.0147  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1814 ORDER BY order_id ASC
0.0151  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 53816 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1814 AND group_code = 4 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0154  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 `tables2020` 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 = 53816 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 49516 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 39148 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 20289 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 15585 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 `tables2007` 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 = 27946 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 16:40:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 16:40:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 16:40:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 16:40:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_federal_b' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 53816 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53816 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 53816 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53816 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 53816 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53816 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0161  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 53816 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC