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
 San Lorenzo Alem Alumni Villa Maria Sarmiento Leones Unión Santiago Andino General Paz Juniors Atlético Las Palmas Vélez de San Ramón Sarmiento La Banda Villa Cubas Tiro Federal Morteros Américo Tesorieri Comercio Central Unidos Defensores de Boca Barrio Argentino Sportivo Fernández San Martín De El Bañado Deportivo Colón Independiente Fernández Tintina Deportivo Comercio Toro Unión Oncativo Atlético Lambert Atlético Los Dorados Deportivo Municipal AM Instituto Tráfico Rioja Juniors San Martín De Villa Unión 25 de Mayo Termas 9 de Julio Rio Tercero Boulevard Norte Coronel Daza Cultural Alberdi Defensores de la Plata Deportivo Brinkmann Federación Agraria Argentin Lautaro Roncedo Los Andes De Los Sarmiento San Lorenzo Huachaschi Unión Alicia Vélez Oliva Villa Plomo Serrano Almafuerte Varillas Atlético Tapso Belgrano Berrotarán Bernardino Rivadavia Deportivo Malanzán Ensenada Quimili Facundo Villa Unión
San Lorenzo Alem San Lorenzo Alem
Alumni Villa Maria Alumni Villa Maria
Sarmiento Leones Sarmiento Leones
Unión Santiago Unión Santiago
Andino Andino
General Paz Juniors General Paz Juniors
Atlético Las Palmas Atlético Las Palmas
Vélez de San Ramón Vélez de San Ramón
Sarmiento La Banda Sarmiento La Banda
Villa Cubas Villa Cubas
Tiro Federal Morteros Tiro Federal Morteros
Américo Tesorieri Américo Tesorieri
Comercio Central Unidos Comercio Central Unidos
Defensores de Boca Defensores de Boca
Barrio Argentino Barrio Argentino
Sportivo Fernández Sportivo Fernández
San Martín De El Bañado San Martín De El Bañado
Deportivo Colón Deportivo Colón
Independiente Fernández Independiente Fernández
Tintina Tintina
Deportivo Comercio Deportivo Comercio
Toro Toro
Unión Oncativo Unión Oncativo
Atlético Lambert Atlético Lambert
Atlético Los Dorados Atlético Los Dorados
Deportivo Municipal AM Deportivo Municipal AM
Instituto Tráfico Instituto Tráfico
Rioja Juniors Rioja Juniors
San Martín De Villa Unión San Martín De Villa Unión
25 de Mayo Termas 25 de Mayo Termas
9 de Julio Rio Tercero 9 de Julio Rio Tercero
Boulevard Norte Boulevard Norte
Coronel Daza Coronel Daza
Cultural Alberdi Cultural Alberdi
Defensores de la Plata Defensores de la Plata
Deportivo Brinkmann Deportivo Brinkmann
Federación Agraria Argentin Federación Agraria Argentin
Lautaro Roncedo Lautaro Roncedo
Los Andes De Los Sarmiento Los Andes De Los Sarmiento
San Lorenzo Huachaschi San Lorenzo Huachaschi
Unión Alicia Unión Alicia
Vélez Oliva Vélez Oliva
Villa Plomo Serrano Villa Plomo Serrano
Almafuerte Varillas Almafuerte Varillas
Atlético Tapso Atlético Tapso
Belgrano Berrotarán Belgrano Berrotarán
Bernardino Rivadavia Bernardino Rivadavia
Deportivo Malanzán Deportivo Malanzán
Ensenada Quimili Ensenada Quimili
Facundo Villa Unión Facundo Villa Unión

  USO DE MEMORIA  
8,405,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0039
Controller Execution Time ( Home / Category )  0.1313
Total Execution Time  0.1353
  CADENA URL  
/torneo_federal_b2024/grupo1/cruces
  GET DATOS  
$_GET['/torneo_federal_b2024/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT type FROM routes WHERE alias = 'torneo_federal_b2024'
0.0065  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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1814 AND type_rel = 3
0.0021  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.0021  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.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 = 74425 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2024 AS c WHERE c.league_id='74425' 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-28 10:20:12' 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-28 10:20:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0030  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 10:20:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 10:20:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  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 events2024 e ON e.player_id = p.id AND e.league_id = 74425 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74425 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.0036  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 events2024 e ON e.player_id = p.id AND e.league_id = 74425 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74425 AND (e.action = 4 or e.action = 5) 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 events2024 e ON e.player_id = p.id AND e.league_id = 74425 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74425 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0060  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 74425 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC