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
Conmebol Sudamericana 2020
2019/2020

Conmebol Sudamericana 2020

Resultados
« Jornada Anterior
Final
 
23 Ene 21
21:00 Finalizado 		Lanús Lanús 0-3 Defensa y Justicia Defensa y Justicia más información Jugadas destacadas 78
0-1 34' Adonis Frías
0-2 62' B. Romero
0-3 92' W. Camacho
JUGADORES DESTACADOS

INFORMACIÓN

La Copa Sudamericana, cuyo nombre oficial es Copa Bridgestone Sudamericana por motivos comerciales, es un torneo internacional de fútbol organizado por la Confederación Sudamericana de Fútbol, que reúne a diversos clubes de fútbol de Sudamérica. Se disputa en el segundo semestre de cada año, de acuerdo a rasgos de sus cuatro antecesoras (Supercopa Sudamericana, Copa Conmebol, Copa Mercosur y Copa Merconorte):

  USO DE MEMORIA  
5,180,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.3037
Total Execution Time  0.3068
  CADENA URL  
/copa_sudamericana2020/grupo0/jornada2?section=legal
  GET DATOS  
$_GET['/copa_sudamericana2020/grupo0/jornada2']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0018  SELECT type FROM routes WHERE alias = 'copa_sudamericana2020'
0.0914  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_sudamericana' 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.0292  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=304 GROUP BY c.id ORDER BY c.order_id ASC
0.0082  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 14:18:44' 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 14:18:44' 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-28 14:18:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 14:18:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0435  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 = 53476 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0166  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 = 53476 AND esl.points > 0
0.0020  SELECT distinct(shedule), round FROM `calendars2020` as c WHERE c.`league_id` = 53476 AND shedule >= '2021/01/01' AND shedule < '2021/02/01' ORDER BY shedule ASC
0.0574  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-04-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 53476 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0017  SELECT data1, data2 FROM services_tags WHERE categoryId=304
0.0065  SELECT group_code, extraName from `leagues` WHERE categoryId=304 AND year=2020