4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
15 Mar 20 Sportivo FernándezSportivo 1 - 1 Vélez de San RamónVélez ...
25 Mar 20 Unión SantiagoUnión Apl San Martín De El BañadoMartín ...
15 Mar 20 San Lorenzo De PománLorenzo Apl San Martín De Villa UniónMartín ...
15 Mar 20 San Lorenzo AlemLorenzo Apl AndinoAndino ...
15 Mar 20 Sportivo Colonia TirolesaSportivo 2 - 1 Américo TesorieriAmérico ...
15 Mar 20 Racing CórdobaRacing 1 - 0 General Paz JuniorsGeneral ...
15 Mar 20 Unión De OncativoUnión 2 - 1 Atlético BellAtlético ...
15 Mar 20 Belgrano Vicuña MackennaBelgrano 2 - 4 Argentino PeñarolArgentino ...
Ver jornada
Jornada 2
22 Mar 20 San Martín De El BañadoMartín Apl Sportivo FernándezSportivo ...
22 Mar 20 Vélez de San RamónVélez Apl Unión SantiagoUnión ...
22 Mar 20 AndinoAndino Apl San Lorenzo De PománLorenzo ...
22 Mar 20 San Martín De Villa UniónMartín Apl San Lorenzo AlemLorenzo ...
22 Mar 20 General Paz JuniorsGeneral Apl Sportivo Colonia TirolesaSportivo ...
22 Mar 20 Américo TesorieriAmérico Apl Racing CórdobaRacing ...
22 Mar 20 Argentino PeñarolArgentino Apl Unión De OncativoUnión ...
22 Mar 20 Atlético BellAtlético Apl Belgrano Vicuña MackennaBelgrano ...
Ver jornada
Jornada 3
29 Mar 20 Sportivo FernándezSportivo Apl Unión SantiagoUnión ...
29 Mar 20 San Martín De El BañadoMartín Apl Vélez de San RamónVélez ...
29 Mar 20 San Lorenzo De PománLorenzo Apl San Lorenzo AlemLorenzo ...
29 Mar 20 AndinoAndino Apl San Martín De Villa UniónMartín ...
29 Mar 20 Sportivo Colonia TirolesaSportivo Apl Racing CórdobaRacing ...
29 Mar 20 General Paz JuniorsGeneral Apl Américo TesorieriAmérico ...
29 Mar 20 Unión De OncativoUnión Apl Belgrano Vicuña MackennaBelgrano ...
29 Mar 20 Argentino PeñarolArgentino Apl Atlético BellAtlético ...
Ver jornada
Jornada 4
05 Abr 20 Vélez de San RamónVélez Apl Sportivo FernándezSportivo ...
05 Abr 20 San Martín De El BañadoMartín Apl Unión SantiagoUnión ...
05 Abr 20 San Martín De Villa UniónMartín Apl San Lorenzo De PománLorenzo ...
05 Abr 20 AndinoAndino Apl San Lorenzo AlemLorenzo ...
05 Abr 20 Américo TesorieriAmérico Apl Sportivo Colonia TirolesaSportivo ...
05 Abr 20 General Paz JuniorsGeneral Apl Racing CórdobaRacing ...
05 Abr 20 Atlético BellAtlético Apl Unión De OncativoUnión ...
05 Abr 20 Argentino PeñarolArgentino Apl Belgrano Vicuña MackennaBelgrano ...
Ver jornada
Jornada 5
12 Abr 20 Sportivo FernándezSportivo Apl San Martín De El BañadoMartín ...
12 Abr 20 Unión SantiagoUnión Apl Vélez de San RamónVélez ...
12 Abr 20 San Lorenzo De PománLorenzo Apl AndinoAndino ...
12 Abr 20 San Lorenzo AlemLorenzo Apl San Martín De Villa UniónMartín ...
12 Abr 20 Sportivo Colonia TirolesaSportivo Apl General Paz JuniorsGeneral ...
12 Abr 20 Racing CórdobaRacing Apl Américo TesorieriAmérico ...
12 Abr 20 Unión De OncativoUnión Apl Argentino PeñarolArgentino ...
12 Abr 20 Belgrano Vicuña MackennaBelgrano Apl Atlético BellAtlético ...
Ver jornada
Jornada 6
19 Abr 20 Unión SantiagoUnión Apl Sportivo FernándezSportivo ...
19 Abr 20 Vélez de San RamónVélez Apl San Martín De El BañadoMartín ...
19 Abr 20 San Lorenzo AlemLorenzo Apl San Lorenzo De PománLorenzo ...
19 Abr 20 San Martín De Villa UniónMartín Apl AndinoAndino ...
19 Abr 20 Racing CórdobaRacing Apl Sportivo Colonia TirolesaSportivo ...
19 Abr 20 Américo TesorieriAmérico Apl General Paz JuniorsGeneral ...
19 Abr 20 Belgrano Vicuña MackennaBelgrano Apl Unión De OncativoUnión ...
19 Abr 20 Atlético BellAtlético Apl Argentino PeñarolArgentino ...

Clasificación

Equipo PJ GF GC Puntos
1 Sportivo Fernández Sportivo 1 1 1 1
2 Vélez de San Ramón Vélez 1 1 1 1
3 San Martín De El Bañado Martín 0 0 0 0
4 Unión Santiago Unión 0 0 0 0
5 Andino Andino 0 0 0 0
6 San Lorenzo Alem Lorenzo Alem 0 0 0 0
7 San Lorenzo De Pomán Lorenzo 0 0 0 0
8 San Martín De Villa Unión Martín 0 0 0 0
9 Sportivo Colonia Tirolesa Sportivo 1 2 1 3
10 Racing Córdoba Racing 1 1 0 3
11 Américo Tesorieri Américo 1 1 2 0
12 General Paz Juniors General 1 0 1 0
13 Argentino Peñarol Argentino 1 4 2 3
14 Unión De Oncativo Unión 1 2 1 3
15 Atlético Bell Atlético 1 1 2 0
16 Belgrano Vicuña Mackenna Belgrano 1 2 4 0

  USO DE MEMORIA  
5,087,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3067
Total Execution Time  0.3087
  CADENA URL  
/torneo_federal_b2020/grupo11/calendario
  GET DATOS  
$_GET['/torneo_federal_b2020/grupo11/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0039  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 = 11 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=11 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1814 ORDER BY order_id ASC
0.0023  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 = 55642 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0101  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 55642 ORDER BY round ASC
0.0640  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 07:31:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 07:31:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 07:31:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 07:31:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 55642 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 55642 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.0021  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 = 55642 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 55642 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0026  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 = 55642 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 55642 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0036  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 = 55642 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC