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 25
Jornada Siguiente »
 
29 Mar 20
Aplazado 		CSYD Sol de Mayo CSYD Sol de Mayo Apl Sportivo Peñarol Sportivo Peñarol más información ...
 
29 Mar 20
Aplazado 		Sportivo Desamparados Sportivo Desamparados Apl Ferro General Pico Ferro General Pico más información ...
 
29 Mar 20
Aplazado 		Juventud Universitario Juventud Universitario Apl Cipolletti Cipolletti más información ...
 
29 Mar 20
Aplazado 		Circulo Deportivo Circulo Deportivo Apl Dep. Maipú Dep. Maipú más información ...
 
29 Mar 20
Aplazado 		Camioneros Bs As Camioneros Bs As Apl Villa Mitre Bahia Blanca Villa Mitre Bahia Blanca más información ...
 
08 Abr 20
Aplazado 		Huracán Las Heras Huracán Las Heras Apl Deportivo Madryn Deportivo Madryn más información ...
 
08 Abr 20
Aplazado 		Sansinena Sansinena Apl Sportivo Estudiantes Sportivo Estudiantes más información ...
Clasificación
« Jornada Anterior
Jornada 25
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,733,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1227
Total Execution Time  0.1246
  CADENA URL  
/torneo_federal_a_transicion2020/grupo2/jornada25
  GET DATOS  
$_GET['/torneo_federal_a_transicion2020/grupo2/jornada25']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0020  SELECT type FROM routes WHERE alias = 'torneo_federal_a_transicion2020'
0.0047  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_federal_a_transicion' AND (l.group_code = 2 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=2 DESC LIMIT 1
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1724 AND type_rel = 3
0.0028  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.0029  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.0030  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.0025  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2020' WHERE c.parentId=1724 GROUP BY c.id ORDER BY c.order_id ASC
0.0020  SELECT type,rule FROM rules WHERE categoryId = 1724 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 11:28:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-06 11:28:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-06 11:28:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-06 11:28:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0029  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_federal_a_transicion' 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.0026  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1724 GROUP BY l.categoryId
0.0027  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1724 GROUP BY l.year ORDER BY l.year DESC
0.0027  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=25
0.0025  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 51043 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0022  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 51043 AND esl.points > 0
0.0020  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-04-06" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 51043 ORDER BY creation_date DESC LIMIT 0, 10
0.0046  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-04-06" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 51043
0.0029  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` = 25 ORDER BY shedule ASC LIMIT 200
0.0056  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 (168622,168623,168624,168625,168626,168620,168621) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0027  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 = 25 AND e.real_date IS NOT NULL AND e.league_id = 51043 ORDER BY total DESC LIMIT 40
0.0040  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.0061  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 = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT distinct(shedule), round FROM `calendars2020` as c WHERE c.`league_id` = 51043 AND shedule >= '2020/03/01' AND shedule < '2020/04/01' ORDER BY shedule ASC
0.0018  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-05-06 00:00:00' AND c.`shedule` < '2024-05-10 23:59:59' AND l.id = 51043 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0026  SELECT data1, data2 FROM services_tags WHERE categoryId=1724
0.0026  SELECT group_code, extraName from `leagues` WHERE categoryId=1724 AND year=2020