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

Cruce de partidos Torneo Regional Federal Amateur - Todos los partidos de la temporada

IdaVuelta
 Central Córdoba Cipolletti Gimnasia y Tiro Patronato Estudiantes Río Cuarto Chaco For Ever Sportivo Belgrano Dep. Maipú Sportivo Las Parejas Alvarado Libertad Sunchales Crucero del Norte Guaraní A. Franco Boca Unidos Sarm. Resistencia Deportivo Madryn Dep. Roca Independiente Neuquén Juventud Alianza Sol de América Formosa Racing Olavarría Huracán de Comodoro JU Gualeguaychu Bella Vista Bahia Blanca Cruz del Sur El Linqueño Atlético Uruguay Concepción FC General Paz Juniors La Emilia Trinidad San Juan Atlético Policial Alianza Cutral Có Racing Trelew 9 de Julio Morteros Textil Mandiyú AD Centenario Guaymallén Sportivo 9 de Julio Ñuñorco Sporting Punta Alta CD Coreano Gimnasia y Esgrima de Santa Cadetes de San Martin Candelaria Grupo Universitario de Tand Independiente La Rioja Villa del Parque
Central Córdoba Central Córdoba
Cipolletti Cipolletti
Gimnasia y Tiro Gimnasia y Tiro
Patronato Patronato
Estudiantes Río Cuarto Estudiantes Río Cuarto
Chaco For Ever Chaco For Ever
Sportivo Belgrano Sportivo Belgrano
Dep. Maipú Dep. Maipú
Sportivo Las Parejas Sportivo Las Parejas
Alvarado Alvarado
Libertad Sunchales Libertad Sunchales
Crucero del Norte Crucero del Norte
Guaraní A. Franco Guaraní A. Franco
Boca Unidos Boca Unidos
Sarm. Resistencia Sarm. Resistencia
Deportivo Madryn Deportivo Madryn
Dep. Roca Dep. Roca
Independiente Neuquén Independiente Neuquén
Juventud Alianza Juventud Alianza
Sol de América Formosa Sol de América Formosa
Racing Olavarría Racing Olavarría
Huracán de Comodoro Huracán de Comodoro
JU Gualeguaychu JU Gualeguaychu
Bella Vista Bahia Blanca Bella Vista Bahia Blanca
Cruz del Sur Cruz del Sur
El Linqueño El Linqueño
Atlético Uruguay Atlético Uruguay
Concepción FC Concepción FC
General Paz Juniors General Paz Juniors
La Emilia La Emilia
Trinidad San Juan Trinidad San Juan
Atlético Policial Atlético Policial
Alianza Cutral Có Alianza Cutral Có
Racing Trelew Racing Trelew
9 de Julio Morteros 9 de Julio Morteros
Textil Mandiyú Textil Mandiyú
AD Centenario AD Centenario
Guaymallén Guaymallén
Sportivo 9 de Julio Sportivo 9 de Julio
Ñuñorco Ñuñorco
Sporting Punta Alta Sporting Punta Alta
CD Coreano CD Coreano
Gimnasia y Esgrima de Santa Gimnasia y Esgrima de Santa
Cadetes de San Martin Cadetes de San Martin
Candelaria Candelaria
Grupo Universitario de Tand Grupo Universitario de Tand
Independiente La Rioja Independiente La Rioja
Villa del Parque Villa del Parque

  USO DE MEMORIA  
8,978,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1143
Total Execution Time  0.1162
  CADENA URL  
/torneo_federal_b2007/grupo2/cruces
  GET DATOS  
$_GET['/torneo_federal_b2007/grupo2/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0017  SELECT type FROM routes WHERE alias = 'torneo_federal_b2007'
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 = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1814 ORDER BY order_id ASC
0.0026  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 = 27944 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2007 AS c WHERE c.league_id='27944' 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-05-10 04:40:59' 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-05-10 04:40:59' 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-05-10 04:40:59' 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-05-10 04:40:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  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 events2007 e ON e.player_id = p.id AND e.league_id = 27944 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27944 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.0019  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 events2007 e ON e.player_id = p.id AND e.league_id = 27944 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27944 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0018  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 events2007 e ON e.player_id = p.id AND e.league_id = 27944 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27944 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0054  SELECT *,(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 = 27944 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC