4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Cruce de partidos Primera Nacional - Todos los partidos de la temporada

IdaVuelta
 Ferro Carril Oeste Platense Chacarita Juniors Atlanta Tigre Quilmes Belgrano Instituto CA Estudiantes Gimnasia Jujuy San Martín Tucumán Almagro Sarmiento Temperley Atletico Rafaela San Martín San Juan All Boys Barracas Central Nueva Chicago Deportivo Morón Indep. Rivadavia Def. Belgrano Estudiantes Río Cuarto Gimnasia Mendoza Brown Adrogue Dep. Riestra Alvarado Dep. Santamarina Villa Dálmine Guillermo Brown Argentino Agropecuario Atlético Mitre SdE
Ferro Carril Oeste Ferro Carril Oeste
Platense Platense
Chacarita Juniors Chacarita Juniors
Atlanta Atlanta
Tigre Tigre
Quilmes Quilmes
Belgrano Belgrano
Instituto Instituto
CA Estudiantes CA Estudiantes
Gimnasia Jujuy Gimnasia Jujuy
San Martín Tucumán San Martín Tucumán
Almagro Almagro
Sarmiento Sarmiento
Temperley Temperley
Atletico Rafaela Atletico Rafaela
San Martín San Juan San Martín San Juan
All Boys All Boys
Barracas Central Barracas Central
Nueva Chicago Nueva Chicago
Deportivo Morón Deportivo Morón
Indep. Rivadavia Indep. Rivadavia
Def. Belgrano Def. Belgrano
Estudiantes Río Cuarto Estudiantes Río Cuarto
Gimnasia Mendoza Gimnasia Mendoza
Brown Adrogue Brown Adrogue
Dep. Riestra Dep. Riestra
Alvarado Alvarado
Dep. Santamarina Dep. Santamarina
Villa Dálmine Villa Dálmine
Guillermo Brown Guillermo Brown
Argentino Agropecuario Argentino Agropecuario
Atlético Mitre SdE Atlético Mitre SdE

  USO DE MEMORIA  
8,489,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2107
Total Execution Time  0.2127
  CADENA URL  
/primera_b_nacional2020/grupo1/cruces
  GET DATOS  
$_GET['/primera_b_nacional2020/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0017  SELECT type FROM routes WHERE alias = 'primera_b_nacional2020'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_nacional' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=192 ORDER BY order_id ASC
0.0020  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 = 50509 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0045  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2020 AS c WHERE c.league_id='50509' ORDER BY c.id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 19:22:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 19:22:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 19:22:44' 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 19:22:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_nacional' 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.0170  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 = 50509 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50509 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.0465  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 = 50509 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50509 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0042  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 = 50509 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50509 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0055  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 = 50509 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC