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 Chacarita Juniors Atlanta Tigre Quilmes Belgrano Instituto CA Estudiantes Gimnasia Jujuy San Martín Tucumán Almagro 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 Almirante Brown Gimnasia Mendoza Brown Adrogue Dep. Maipú Tristán Suárez Dep. Riestra Alvarado Dep. Santamarina San Telmo Villa Dálmine Guillermo Brown Argentino Agropecuario Atlético Mitre SdE Club Atlético Güemes
Ferro Carril Oeste Ferro Carril Oeste
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
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
Almirante Brown Almirante Brown
Gimnasia Mendoza Gimnasia Mendoza
Brown Adrogue Brown Adrogue
Dep. Maipú Dep. Maipú
Tristán Suárez Tristán Suárez
Dep. Riestra Dep. Riestra
Alvarado Alvarado
Dep. Santamarina Dep. Santamarina
San Telmo San Telmo
Villa Dálmine Villa Dálmine
Guillermo Brown Guillermo Brown
Argentino Agropecuario Argentino Agropecuario
Atlético Mitre SdE Atlético Mitre SdE
Club Atlético Güemes Club Atlético Güemes

  USO DE MEMORIA  
9,266,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.2905
Total Execution Time  0.2923
  CADENA URL  
/primera_b_nacional2021/grupo1/cruces
  GET DATOS  
$_GET['/primera_b_nacional2021/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0018  SELECT type FROM routes WHERE alias = 'primera_b_nacional2021'
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 = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  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 = 60153 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0052  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2021 AS c WHERE c.league_id='60153' ORDER BY c.id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 19:03:54' 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-30 19:03:54' 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-30 19:03:54' 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=3 AND last_update > '2024-04-30 19:03:54' 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 = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0540  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 events2021 e ON e.player_id = p.id AND e.league_id = 60153 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60153 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.0974  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 events2021 e ON e.player_id = p.id AND e.league_id = 60153 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60153 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0052  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 events2021 e ON e.player_id = p.id AND e.league_id = 60153 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60153 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0069  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 60153 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC