4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2020
Temporada Siguiente »
Publicidad 600x120.gif
Torneo Federal A Transición 2020
2019/2020

Torneo Federal A Transición 2020

  • Villa Mitre Bahia Blanca
  • Dep. Maipú
  • Huracán Las Heras
  • Deportivo Madryn
  • Ferro General Pico
  • Juventud Universitario
  • Sansinena
  • Olimpo
  • Camioneros Bs As
  • Sportivo Estudiantes
  • Cipolletti
  • Circulo Deportivo
  • Sportivo Desamparados
  • Sportivo Peñarol
  • CSYD Sol de Mayo

Torneo Federal A Transición 2020

La temporada finalizó el Domingo, 03 Mayo 2020.
Resultados
« Jornada Anterior
Jornada 26
Jornada Siguiente »
 
03 Abr 20
Aplazado 		Sportivo Estudiantes Sportivo Estudiantes Apl CSYD Sol de Mayo CSYD Sol de Mayo más información ...
 
03 Abr 20
Aplazado 		Deportivo Madryn Deportivo Madryn Apl Sansinena Sansinena más información ...
 
03 Abr 20
Aplazado 		Olimpo Olimpo Apl Huracán Las Heras Huracán Las Heras más información ...
 
05 Abr 20
Aplazado 		Dep. Maipú Dep. Maipú Apl Camioneros Bs As Camioneros Bs As más información ...
 
05 Abr 20
Aplazado 		Cipolletti Cipolletti Apl Circulo Deportivo Circulo Deportivo más información ...
 
05 Abr 20
Aplazado 		Ferro General Pico Ferro General Pico Apl Juventud Universitario Juventud Universitario más información ...
 
05 Abr 20
Aplazado 		Sportivo Peñarol Sportivo Peñarol Apl Sportivo Desamparados Sportivo Desamparados más información ...
Clasificación
« Jornada Anterior
Jornada 26
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C.
1 Villa Mitre Bahia Blanca Villa Mitre Bah. 39 22 10 9 3 21 9
  • EMPATE
  • Huracán Las Heras 0
  • Villa Mitre Bahia. 0
  • EMPATE
  • Villa Mitre Bahia. 0
  • Sansinena 0
  • VICTORIA
  • CSYD Sol de Mayo 1
  • Villa Mitre Bahia. 3
  • VICTORIA
  • Villa Mitre Bahia. 2
  • Sportivo Desampara. 0
  • EMPATE
  • Juventud Universit. 0
  • Villa Mitre Bahia. 0
2 Dep. Maipú Dep. Maipú 39 22 11 6 5 25 20
  • DERROTA
  • Olimpo 3
  • Dep. Maipú 0
  • EMPATE
  • Dep. Maipú 0
  • Huracán Las Heras 0
  • EMPATE
  • Sansinena 1
  • Dep. Maipú 1
  • VICTORIA
  • Dep. Maipú 3
  • CSYD Sol de Mayo 0
  • EMPATE
  • Sportivo Desampara. 1
  • Dep. Maipú 1
3 Huracán Las Heras Huracán Heras 35 22 8 11 3 17 14
  • EMPATE
  • Huracán Las Heras 0
  • Villa Mitre Bahia. 0
  • EMPATE
  • Dep. Maipú 0
  • Huracán Las Heras 0
  • EMPATE
  • Huracán Las Heras 0
  • Cipolletti 0
  • EMPATE
  • Ferro General Pico 1
  • Huracán Las Heras 1
  • EMPATE
  • Huracán Las Heras 0
  • Sportivo Peñarol 0
4 Deportivo Madryn Deportivo Madryn 32 21 9 5 7 26 14
  • VICTORIA
  • Dep. Maipú 1
  • Deportivo Madryn 4
  • VICTORIA
  • Deportivo Madryn 2
  • Cipolletti 1
  • DERROTA
  • Ferro General Pico 2
  • Deportivo Madryn 1
  • VICTORIA
  • Deportivo Madryn 1
  • Sportivo Peñarol 0
  • DERROTA
  • Sportivo Estudiant. 1
  • Deportivo Madryn 0
5 Ferro General Pico Ferro General P. 31 21 7 10 4 21 19
  • EMPATE
  • Sportivo Estudiant. 2
  • Ferro General Pico 2
  • VICTORIA
  • Ferro General Pico 2
  • Deportivo Madryn 1
  • DERROTA
  • Olimpo 2
  • Ferro General Pico 1
  • EMPATE
  • Ferro General Pico 1
  • Huracán Las Heras 1
  • EMPATE
  • Sansinena 1
  • Ferro General Pico 1
6 Juventud Universitario Juventud 31 21 8 7 6 19 18
  • VICTORIA
  • Juventud Universit. 1
  • CSYD Sol de Mayo 0
  • VICTORIA
  • Sportivo Desampara. 0
  • Juventud Universit. 1
  • VICTORIA
  • Juventud Universit. 1
  • Circulo Deportivo 0
  • VICTORIA
  • Camioneros Bs As 0
  • Juventud Universit. 1
  • EMPATE
  • Juventud Universit. 0
  • Villa Mitre Bahia. 0
7 Sansinena Sansinena 31 22 8 7 7 18 20
  • EMPATE
  • Sansinena 1
  • Camioneros Bs As 1
  • EMPATE
  • Villa Mitre Bahia. 0
  • Sansinena 0
  • EMPATE
  • Sansinena 1
  • Dep. Maipú 1
  • VICTORIA
  • Cipolletti 2
  • Sansinena 3
  • EMPATE
  • Sansinena 1
  • Ferro General Pico 1
8 Olimpo Olimpo 27 22 8 3 11 23 22
  • VICTORIA
  • Olimpo 3
  • Dep. Maipú 0
  • VICTORIA
  • Cipolletti 0
  • Olimpo 5
  • VICTORIA
  • Olimpo 2
  • Ferro General Pico 1
  • DERROTA
  • Sportivo Peñarol 3
  • Olimpo 0
  • VICTORIA
  • Olimpo 2
  • Sportivo Estudiant. 0
9 Camioneros Bs As Camioneros 25 22 5 10 7 18 21
  • EMPATE
  • Sansinena 1
  • Camioneros Bs As 1
  • VICTORIA
  • Camioneros Bs As 3
  • CSYD Sol de Mayo 2
  • DERROTA
  • Sportivo Desampara. 2
  • Camioneros Bs As 1
  • DERROTA
  • Camioneros Bs As 0
  • Juventud Universit. 1
  • DERROTA
  • Circulo Deportivo 2
  • Camioneros Bs As 0
10 Sportivo Estudiantes Sportivo 25 21 7 4 10 19 24
  • DERROTA
  • Cipolletti 2
  • Sportivo Estudiant. 1
  • EMPATE
  • Sportivo Estudiant. 2
  • Ferro General Pico 2
  • VICTORIA
  • Sportivo Peñarol 1
  • Sportivo Estudiant. 3
  • VICTORIA
  • Sportivo Estudiant. 1
  • Deportivo Madryn 0
  • DERROTA
  • Olimpo 2
  • Sportivo Estudiant. 0
11 Cipolletti Cipolletti 25 22 5 10 7 25 31
  • DERROTA
  • Deportivo Madryn 2
  • Cipolletti 1
  • DERROTA
  • Cipolletti 0
  • Olimpo 5
  • EMPATE
  • Huracán Las Heras 0
  • Cipolletti 0
  • DERROTA
  • Cipolletti 2
  • Sansinena 3
  • EMPATE
  • CSYD Sol de Mayo 1
  • Cipolletti 1
12 Circulo Deportivo Circulo 24 21 5 9 7 20 22
  • DERROTA
  • Circulo Deportivo 0
  • Sansinena 1
  • EMPATE
  • CSYD Sol de Mayo 1
  • Circulo Deportivo 1
  • EMPATE
  • Circulo Deportivo 2
  • Sportivo Desampara. 2
  • DERROTA
  • Juventud Universit. 1
  • Circulo Deportivo 0
  • VICTORIA
  • Circulo Deportivo 2
  • Camioneros Bs As 0
13 Sportivo Desamparados Sportivo 24 21 5 9 7 16 21
  • DERROTA
  • Sportivo Desampara. 0
  • Juventud Universit. 1
  • EMPATE
  • Circulo Deportivo 2
  • Sportivo Desampara. 2
  • VICTORIA
  • Sportivo Desampara. 2
  • Camioneros Bs As 1
  • DERROTA
  • Villa Mitre Bahia. 2
  • Sportivo Desampara. 0
  • EMPATE
  • Sportivo Desampara. 1
  • Dep. Maipú 1
14 Sportivo Peñarol Sportivo 22 21 5 7 9 20 20
  • DERROTA
  • Ferro General Pico 1
  • Sportivo Peñarol 0
  • DERROTA
  • Sportivo Peñarol 1
  • Sportivo Estudiant. 3
  • DERROTA
  • Deportivo Madryn 1
  • Sportivo Peñarol 0
  • VICTORIA
  • Sportivo Peñarol 3
  • Olimpo 0
  • EMPATE
  • Huracán Las Heras 0
  • Sportivo Peñarol 0
15 CSYD Sol de Mayo CSYD Mayo 17 21 4 5 12 19 32
  • EMPATE
  • CSYD Sol de Mayo 1
  • Circulo Deportivo 1
  • DERROTA
  • Camioneros Bs As 3
  • CSYD Sol de Mayo 2
  • DERROTA
  • CSYD Sol de Mayo 1
  • Villa Mitre Bahia. 3
  • DERROTA
  • Dep. Maipú 3
  • CSYD Sol de Mayo 0
  • EMPATE
  • CSYD Sol de Mayo 1
  • Cipolletti 1
Siguiente Ronda : Villa Mitre Bah., Dep. Maipú, Huracán Heras, Deportivo Madryn, Ferro General P., Juventud
Playoffs : Sportivo, CSYD Mayo
JUGADORES DESTACADOS


  USO DE MEMORIA  
5,709,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.3926
Total Execution Time  0.3949
  CADENA URL  
/torneo_federal_a_transicion2020/grupo2/jornada26
  GET DATOS  
$_GET['/torneo_federal_a_transicion2020/grupo2/jornada26']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1724 AND type_rel = 3
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1724 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (1062803,1015438,942145,877564,861297) ORDER BY n.cover_points DESC, update_date DESC
0.0147  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 = 51043 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 13:32:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 13:32:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 13:32:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 13:32:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=51043 AND rel.round=26
0.0148  SELECT c.isVideo, c.id,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,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2020` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 51043 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0147  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2020 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2020 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 51043 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (168631,168632,168633,168627,168628,168629,168630) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0155  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2020` e INNER JOIN calendars2020 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 26 AND e.real_date IS NOT NULL AND e.league_id = 51043 ORDER BY total DESC LIMIT 40
0.0146  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2020` e INNER JOIN calendars2020 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 51043 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 51043 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0298  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 = 51043 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT distinct(shedule), round FROM `calendars2020` as c WHERE c.`league_id` = 51043 AND shedule >= '2020/04/01' AND shedule < '2020/05/01' ORDER BY shedule ASC
0.0145  SELECT data1, data2 FROM services_tags WHERE categoryId=1724
0.0153  SELECT group_code, extraName from `leagues` WHERE categoryId=1724 AND year=2020