4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Conmebol Sudamericana 2016
2015/2016

Conmebol Sudamericana 2016

 
10 Ago 16
02:15 Finalizado
Fénix Fénix 1-0 Cerro Porteño Cerro Porteño más información Jugadas destacadas 54
3' M. Cantera M. Cantera 1-0
64' C. Domínguez C. Domínguez
18 Ago 16
02:00 Finalizado
Cerro Porteño Cerro Porteño 2-0 Fénix Fénix más información Jugadas destacadas 38
5' Á. Pereira Á. Pereira 1-0
80' M. González M. González
80' S. Torales S. Torales
90' P. Velázquez P. Velázquez 2-0
Global
Fénix 1 - 2 Cerro
10 Ago 16
00:15 Finalizado
Sportivo Luqueño Sportivo Luqueño 0-0 Peñarol Peñarol más información 57
17 Ago 16
01:30 Finalizado
Peñarol Peñarol 1-1 Sportivo Luqueño Sportivo Luqueño más información Jugadas destacadas 126
90' Bressan Bressan 1-0
1-1 90' D. Mendieta D. Mendieta
Global
Sportivo 1 - 1 Peñarol
11 Ago 16
00:00 Finalizado
Univ. Concepción Univ. Concepción 2-0 Bolívar Bolívar más información Jugadas destacadas 67
50' J. Meneses J. Meneses 1-0
60' J. Meneses J. Meneses 2-0
90' J. Arce J. Arce
16 Ago 16
23:00 Finalizado
Bolívar Bolívar 3-0 Univ. Concepción Univ. Concepción más información Jugadas destacadas 106
4' E. Fierro E. Fierro 1-0
10' G. Cellerino G. Cellerino 2-0
86' E. Fierro E. Fierro 3-0
Global
Univ. 2 - 3 Bolívar
11 Ago 16
02:00 Finalizado
Sol de América Sol de América 1-1 Jorge Wilstermann Jorge Wilstermann más información Jugadas destacadas 60
0-1 52' G. Álvarez G. Álvarez
81' E. Álvarez E. Álvarez 1-1
18 Ago 16
23:30 Finalizado
Jorge Wilstermann Jorge Wilstermann (4) 1-1 (5) Sol de América Sol de América más información Jugadas destacadas 212
47' Thomaz Thomaz 1-0
1-1 55' Isaac Díaz Isaac Díaz
66' E. Álvarez E. Álvarez
Global Pen. (5-4) Pr.
América 2 - 2 Jorge
12 Ago 16
01:00 Finalizado
Blooming Blooming 1-0 Plaza Colonia Plaza Colonia más información Jugadas destacadas 50
19' J. Paulo J. Paulo 1-0
17 Ago 16
23:30 Finalizado
Plaza Colonia Plaza Colonia (1) 1-0 (4) Blooming Blooming más información Jugadas destacadas 46
51' J. Corvalán J. Corvalán 1-0
61' R. Duarte R. Duarte
75' K. Farell K. Farell
Global Pen. (4-1)
Blooming 1 - 1 Plaza
10 Ago 16
02:30 Finalizado
Real Potosí Real Potosí 3-1 U. Católica U. Católica más información Jugadas destacadas 76
8' R. De La Cuesta R. De La Cuesta 1-0
48' Rodrigo Borda Rodrigo Borda 2-0
50' E. Alpire E. Alpire 3-0
3-1 73' F. Cordero F. Cordero
81' C. Centurión C. Centurión
 
18 Ago 16
02:00 Finalizado
U. Católica U. Católica 1-1 Real Potosí Real Potosí más información Jugadas destacadas 125
31' R. Noir R. Noir 1-0
62' D. Llanos D. Llanos
1-1 80' A. Rojano A. Rojano
Global
Real Potosí 4 - 2 Católica
11 Ago 16
02:00 Finalizado
Montevideo Wanderers Montevideo Wanderers 0-0 O'Higgins O'Higgins más información Jugadas destacadas 29
90' S. Blanco S. Blanco
 
17 Ago 16
01:30 Finalizado
O'Higgins O'Higgins (4) 0-0 (5) Montevideo Wanderers Montevideo Wanderers más información 37
Global Pen. (5-4)
Montevideo 0 - 0 O'Higgins
12 Ago 16
01:45 Finalizado
Palestino Palestino 1-0 Libertad Libertad más información Jugadas destacadas 110
26' L. Benegas L. Benegas 1-0
19 Ago 16
02:30 Finalizado
Libertad Libertad 0-3 Palestino Palestino más información Jugadas destacadas 100
46' A. Martinez A. Martinez
1-1 76' Leo Valencia Leo Valencia
1-2 80' D. Torres D. Torres
Global
Palestino 4 - 0 Libertad
10 Ago 16
04:30 Finalizado
Universitario de Deportes Universitario Deportes 0-3 CS Emelec CS Emelec más información Jugadas destacadas 86
0-1 53' G. Achilier G. Achilier
0-2 63' D. Stracqualursi D. Stracqualursi
0-3 81' D. Stracqualursi D. Stracqualursi
17 Ago 16
04:00 Finalizado
CS Emelec CS Emelec 3-1 Universitario de Deportes Universitario Deportes más información Jugadas destacadas 89
22' F. Gimenez F. Gimenez 1-0
1-1 32' H. Rengifo H. Rengifo
37' D. Stracqualursi D. Stracqualursi 2-1
68' Ángel Mena Ángel Mena 3-1
Global
Universitari 1 - 6 CS Emelec
11 Ago 16
23:30 Finalizado
Aucas Aucas 2-1 Cusco FC Cusco FC más información Jugadas destacadas 54
0-1 19' W. Cosme W. Cosme
35' J. Villacres J. Villacres 1-1
37' J. Rojas J. Rojas 2-1
18 Ago 16
04:15 Finalizado
Cusco FC Cusco FC 1-0 Aucas Aucas más información Jugadas destacadas 18
29' M. Valverde M. Valverde 1-0
Global
Aucas 2 - 2 Cusco FC
 
10 Ago 16
00:00 Finalizado
Deportivo Lara Deportivo Lara 1-3 Junior Junior más información Jugadas destacadas 127
0-1 1' R. Ovelar R. Ovelar
2' J. Hernández J. Hernández 1-1
1-2 77' J. Sanchez J. Sanchez
1-3 85' R. Ovelar R. Ovelar
 
17 Ago 16
04:00 Finalizado
Junior Junior 2-1 Deportivo Lara Deportivo Lara más información Jugadas destacadas 99
44' E. Toloza E. Toloza 1-0
51' S. Viera S. Viera 2-0
2-1 62' C. González C. González
67' F. Noguera F. Noguera
Global
Deportivo 2 - 5 Junior
12 Ago 16
03:15 Finalizado
Deportes Tolima Deportes Tolima 0-0 La Guaira La Guaira más información 77
17 Ago 16
23:30 Finalizado
La Guaira La Guaira 1-0 Deportes Tolima Deportes Tolima más información Jugadas destacadas 69
2' F. Arrieta F. Arrieta 1-0
Global
Deportes 0 - 1 La Guaira
11 Ago 16
04:15 Finalizado
Barcelona SC Barcelona SC 1-1 Zamora FC Zamora FC más información Jugadas destacadas 158
54' W. Vera W. Vera 1-0
1-1 82' Y. Soteldo Y. Soteldo
19 Ago 16
00:00 Finalizado
Zamora FC Zamora FC (3) 1-1 (0) Barcelona SC Barcelona SC más información Jugadas destacadas 259
0-1 18' M. Caicedo M. Caicedo
59' E. Peraza E. Peraza
86' R. Blanco R. Blanco 1-1
90' T. Valencia T. Valencia
Global Pen. (0-3) Pr.
Barcelona 2 - 2 Zamora FC
11 Ago 16
04:30 Finalizado
Independiente Medellín Independiente Medellín 1-1 Universidad Católica Universidad Católica más información Jugadas destacadas 37
21' L. Castro L. Castro 1-0
1-1 78' Jhonathan Lucas Jhonathan Lucas
17 Ago 16
23:30 Finalizado
Universidad Católica Universidad Católica 0-1 Independiente Medellín Independiente Medellín más información Jugadas destacadas 40
36' H. Galíndez H. Galíndez
0-1 41' L. Arias L. Arias
Global
Independient 2 - 1 Universidad
11 Ago 16
23:30 Finalizado
Dep. Anzoátegui Dep. Anzoátegui 2-1 Sport Huancayo Sport Huancayo más información Jugadas destacadas 63
5' V. Peña V. Peña
0-1 9' G. Martinez G. Martinez
36' D. Centeno D. Centeno 1-1
84' Y. Cumana Y. Cumana 2-1
18 Ago 16
22:00 Finalizado
Sport Huancayo Sport Huancayo 1-0 Dep. Anzoátegui Dep. Anzoátegui más información Jugadas destacadas 35
58' M. Corrales M. Corrales 1-0
Global
Dep. 2 - 2 Sport
12 Ago 16
04:00 Finalizado
Deportivo Municipal Deportivo Municipal 0-5 At. Nacional At. Nacional más información Jugadas destacadas 212
0-1 30' Mateus Uribe Mateus Uribe
0-2 59' D. Arias D. Arias
0-3 66' O. Berrío O. Berrío
0-4 77' A. Bernal A. Bernal
0-5 89' R. Miller R. Miller
18 Ago 16
04:15 Finalizado
At. Nacional At. Nacional 1-0 Deportivo Municipal Deportivo Municipal más información Jugadas destacadas 105
42' A. Bernal A. Bernal 1-0
Global
Deportivo 0 - 6 Nacional
Chapecoense Campeón de la Copa Sudamericana 2016.

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  
6,597,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7590
Total Execution Time  0.7609
  CADENA URL  
/copa_sudamericana2016/grupo0/jornada1
  GET DATOS  
$_GET['/copa_sudamericana2016/grupo0/jornada1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0105  SELECT type FROM routes WHERE alias = 'copa_sudamericana2016'
0.0214  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 = 2016 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=304 AND type_rel = 3
0.0208  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 304 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0111  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 (1314421,1312650,1312479,1312173,1310613) ORDER BY n.cover_points DESC, update_date DESC
0.0113  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 = 33863 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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='2016' WHERE c.parentId=304 GROUP BY c.id ORDER BY c.order_id ASC
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 09:51:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 09:51:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 09:51:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 09:51:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 304 AND l.year = 2016
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events2016 e WHERE e.league_id IN (33863) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0113  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (33863) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (133874,219031,74593,72024,195974,21435,48553,54494,71822,72044,95321,120238,211038,330477,21818,64507,64709,93629,104681,135684) ORDER BY rp.in_squad = 1 DESC
0.0107  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 304 AND l.year = 2016
0.0113  SELECT e.action, count(e.action) as total, e.player_id FROM events2016 e WHERE e.league_id IN (33863) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0112  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (33863) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (101474,176446,210433,211016,21818,27864,104681,120748,121787,131089,134559,208173,208606,213076,215178,217874,219031,44043,63479,64709) ORDER BY rp.in_squad = 1 DESC
0.0110  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 304 AND l.year = 2016
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events2016 e WHERE e.league_id IN (33863) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0110  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (33863) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (22867,27467,41396,64786,72017,72539,75106,81562,92847,103061,103305,104681,106686,112012,114656,114948,121260,121787,131089,133515) ORDER BY rp.in_squad = 1 DESC
0.0108  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 304 AND l.year = 2016
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events2016 e WHERE e.league_id IN (33863) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0113  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (33863) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (17071,31629,114815,219043,249368) ORDER BY rp.in_squad = 1 DESC
0.1191  SELECT SUM(rp.lineup) 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 304 AND rp.year = 2016 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.1142  SELECT SUM(rp.events) 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,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 304 AND rp.year = 2016 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0111  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=33863 AND rel.round=1
0.0106  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 = 33863 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0110  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 = 33863 AND esl.points > 0
0.0105  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-08" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 33863 ORDER BY creation_date DESC LIMIT 0, 10
0.0118  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-08" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 33863
0.0147  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 `calendars2016` 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` = 33863 AND c.`round` = 1 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0133  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 events2016 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2016 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 33863 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 (416787,416799,416793,416806,416794,416798,416792,416811,416783,416807,416791,416809,416796,416805,416790,416804,416795,416800,416781,416801,416789,416802,416786,416803,416782,416812,416813,416814,416784,416808,416785,416797) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0109  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 `events2016` e INNER JOIN calendars2016 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 = 1 AND e.real_date IS NOT NULL AND e.league_id = 33863 ORDER BY total DESC LIMIT 40
0.0108  SELECT distinct(shedule), round FROM `calendars2016` as c WHERE c.`league_id` = 33863 AND shedule >= '2016/08/01' AND shedule < '2016/09/01' ORDER BY shedule ASC
0.0105  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-08 00:00:00' AND c.`shedule` < '2024-05-12 23:59:59' AND l.id = 33863 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0107  SELECT data1, data2 FROM services_tags WHERE categoryId=304
0.0107  SELECT group_code, extraName from `leagues` WHERE categoryId=304 AND year=2016