4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Copa Suecia 2020
2019/2020

Copa Suecia 2020

 
09 Nov 19
14:00 Finalizado
Enskede Enskede 0-7 AIK Solna AIK Solna más información Jugadas destacadas 2
0-1 23' Sebastian Larsson
0-2 30' T. Elyounoussi
0-3 39' T. Elyounoussi
45' S. Stigenberg
45' S. Stigenberg
2-4 60' T. Elyounoussi
83' S. Stigenberg
83' S. Stigenberg
2-5 84' B. Hussein
2-6 89' T. Strannegard
 
21 Ago 19
18:30 Finalizado
IFK Luleå IFK Luleå 1-3 Hammarby IF Hammarby IF más información Jugadas destacadas ...
0-1 9' N. Djurdjic
0-2 12' M. Tankovic
29' W. Olausson 1-2
1-3 68' A. Kacaniklic
 
10 Nov 19
16:00 Finalizado
IFK Varnamo IFK Varnamo 0-2 Malmö FF Malmö FF más información Jugadas destacadas 1
0-1 57' J. Berget
0-2 62' F. Bachirou
 
22 Ago 19
18:00 Finalizado
Astrio Astrio 0-4 IFK Göteborg IFK Göteborg más información Jugadas destacadas ...
0-1 31' S. Abraham
0-2 59' Tobias Sana
0-3 66' L. Vibe
0-4 87' O. Vilhelmsson
 
22 Ago 19
18:30 Finalizado
Dagsbergs Dagsbergs 0-12 IK Brage IK Brage más información Jugadas destacadas 1
0-1 8' J. Lundback
0-2 14' R. Sellin
0-3 27' R. Sellin
0-4 29' J. Lundback
0-5 31' A. Ekblad
0-6 49' A. Lundin
0-7 53' J. Lundback
0-8 62' S. Stenberg
0-9 69' P. Jonsson
0-10 71' A. Zetterstrom
0-11 76' O. Lundin
0-12 89' J. Andersson
 
22 Ago 19
18:30 Finalizado
Akropolis Akropolis 1-2 Djurgårdens IF Djurgårdens IF más información Jugadas destacadas ...
0-1 5' H. Radetinac
0-2 8' Oscar Pettersson
85' N. Lindqvist 1-2
 
21 Ago 19
18:30 Finalizado
IFK Timra IFK Timra 1-6 IFK Norrköping IFK Norrköping más información Jugadas destacadas ...
0-1 33' K. Holmberg
0-2 39' M. Kusu
0-3 45' Í. Jóhannesson
0-4 56' A. Blomqvist
59' O. Nordlund 1-4
1-5 78' K. Álvarez
1-6 90' C. Björk
 
22 Ago 19
18:30 Finalizado
Oskarshamns AIK Oskarshamns AIK 2-1 Helsingborgs IF Helsingborgs IF más información Jugadas destacadas 1
0-1 39' C. Weberg
69' E. Persson 1-1
84' C. Christensson 2-1
 
22 Ago 19
17:45 Finalizado
Vårgårda Vårgårda 0-4 Falkenbergs Falkenbergs más información Jugadas destacadas ...
0-1 15' K. Söderström
0-2 56' N. Peter
0-3 58' N. Peter
0-4 90' E. Sylisufaj
 
21 Ago 19
18:30 Finalizado
Forssa Forssa 2-4 Syrianska FC Syrianska FC más información Jugadas destacadas ...
4' M. Ali 1-0
19' A. Ernström 2-0
31' E. Tjärnberg
3-1 44' S. Rajalakso
3-2 50' M. Genc
3-3 90' D. Rashidi
 
21 Ago 19
18:30 Finalizado
Gute Gute 2-4 Dalkurd FF Dalkurd FF más información Jugadas destacadas ...
0-1 16' M. Moënza
18' V. Dahlstrom 1-1
1-2 27' A. Awad
52' M. Rynell 2-2
2-3 62' A. Awad
2-4 89' E. Berger
 
21 Ago 19
18:30 Finalizado
Eskilsminne Eskilsminne 1-0 Norrby Norrby más información Jugadas destacadas ...
86' N. Christoffersson 1-0
 
21 Ago 19
18:30 Finalizado
Nyköpings BIS Nyköpings BIS 0-1 Orebro SK Orebro SK más información Jugadas destacadas 5
0-1 45' V. Prodell
 
21 Ago 19
18:30 Finalizado
Sandvikens IF Sandvikens IF 2-1 IK Frej IK Frej más información Jugadas destacadas ...
0-1 58' Zé Santos
82' M. Hägg 1-1
84' V. Koidan 2-1
 
21 Ago 19
18:30 Finalizado
Gamla Upsala Gamla Upsala 1-3 Västerås SK Västerås SK más información Jugadas destacadas ...
0-1 25' S. Johansson
0-2 43' R. Tsouka
0-3 63' S. Johansson
90' M. Mellberg 1-3
 
21 Ago 19
18:00 Finalizado
Tvååker Tvååker 2-0 Trelleborgs FF Trelleborgs FF más información Jugadas destacadas 2
13' J. Adolfsson 1-0
61' A. Johansson 2-0
 
14 Ago 19
18:30 Finalizado
Lunds Lunds 0-1 Varbergs BoIS Varbergs BoIS más información Jugadas destacadas 2
0-1 58' T. Carlsson
 
21 Ago 19
18:30 Finalizado
Lidingö Lidingö 1-3 GIF Sundsvall GIF Sundsvall más información Jugadas destacadas ...
0-1 69' Marc Mas
90' Per Boltegard 1-1
1-2 106' Marc Mas
1-3 120' O. Berg
 
21 Ago 19
18:30 Finalizado
Torns Torns 1-2 Jönköpings Södra Jönköpings Södra más información Jugadas destacadas ...
46' P. Östlund 1-0
1-1 65' T. Thelin
1-2 112' T. Thelin
 
21 Ago 19
18:00 Finalizado
Qviding FIF Qviding FIF 1-3 Häcken Häcken más información Jugadas destacadas 4
0-1 35' Paulinho
74' M. Lindberg 1-1
1-2 84' Paulinho
1-3 90' A. Yasin
 
21 Ago 19
18:30 Finalizado
Karlstad BK Karlstad BK (3) 1-1 (5) IK Sirius IK Sirius más información Jugadas destacadas ...
99' D. Henriksson 1-0
1-1 120' T. Björkström
 
21 Ago 19
18:30 Finalizado
Utsiktens BK Utsiktens BK 0-1 Örgryte Örgryte más información Jugadas destacadas ...
0-1 4' F. Johansson Zanjanchi
 
21 Ago 19
18:30 Finalizado
Trollhattan FC Trollhattan FC 1-2 Halmstads Halmstads más información Jugadas destacadas 1
16' Tobias Berntsson 1-0
1-1 59' K. Sadat
87' M. Karlsson
 
21 Ago 19
18:30 Finalizado
Rosengård Rosengård 1-2 Kalmar FF Kalmar FF más información Jugadas destacadas ...
0-1 19' R. York
0-2 34' R. York
79' Z. Sakirovski 1-2
 
21 Ago 19
18:30 Finalizado
Råslätts Råslätts 0-1 GAIS GAIS más información Jugadas destacadas ...
0-1 20' M. Saebbo
 
21 Ago 19
18:30 Finalizado
Sollentuna Sollentuna 4-3 Degerfors IF Degerfors IF más información Jugadas destacadas ...
5' O. Ekroth
1-1 36' G. Granath
1-2 46' A. Carlén
1-3 54' J. Okon
83' B. Pishdari 2-3
86' G. Lagerbielke 3-3
89' B. Pishdari 4-3
 
14 Ago 19
18:30 Finalizado
Carlstad United Carlstad United 2-3 AFC Eskilstuna AFC Eskilstuna más información Jugadas destacadas ...
23' C. Nyman 1-0
38' E. Sachs 2-0
2-1 42' D. Kozica
2-2 62' Adi Nalic
2-3 79' D. Kozica
 
21 Ago 19
18:30 Finalizado
Husqvarna Husqvarna 0-4 Mjällby AIF Mjällby AIF más información Jugadas destacadas ...
0-1 52' E. Parsson
0-2 56' C. Georges
0-3 79' M. Omoh
0-4 90' M. Jeahze
 
22 Ago 19
18:00 Finalizado
Gauthiod Gauthiod 1-3 IF Elfsborg IF Elfsborg más información Jugadas destacadas 7
0-1 44' S. Ishizaki
70' Rikard Nilsson 1-1
1-2 105' J. Karlsson
1-3 119' S. Ishizaki
 
21 Ago 19
17:30 Finalizado
Gottne Gottne 2-4 Brommapojkarna Brommapojkarna más información Jugadas destacadas 1
0-1 44' A. Linnér
50' D. Harmon 1-1
1-2 65' Liliu
80' A. Johnson 2-2
2-3 93' A. Linnér
2-4 116' E. Omondi
 
14 Ago 19
18:30 Finalizado
Stocksund Stocksund 0-1 Östersunds FK Östersunds FK más información Jugadas destacadas 3
0-1 20' Charlie Colkett
 
21 Ago 19
18:30 Finalizado
Karlskrona Karlskrona 2-1 Osters IF Osters IF más información Jugadas destacadas ...
36' S. Hansson 1-0
45' J. Enarsson 2-0
2-1 56' D. Johannesson

Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,471,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1388
Total Execution Time  0.1407
  CADENA URL  
/copa_suecia2020/grupo1/jornada2/clasificacion
  GET DATOS  
$_GET['/copa_suecia2020/grupo1/jornada2/clasificacion']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0071  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_suecia' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0034  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1542 AND type_rel = 3
0.0039  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 = 49745 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 14:02:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 14:02:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 14:02:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 14:02:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0038  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=49745 AND rel.round=2
0.0036  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 = 49745 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0035  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 = 49745 AND esl.points > 0
0.0034  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-02-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 49745 ORDER BY creation_date DESC LIMIT 0, 10
0.0044  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-02-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 49745
0.0091  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` = 49745 AND c.`round` = 2 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0062  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 = 49745 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 (56211,56212,56215,56217,65300,56214,56213,56216,72229,72218,65294,65295,56210,65293,121930,121917,121916,121932,121933,121918,121929,121936,121938,121934,121919,121931,121915,121935,121944,121928,149990,72221) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0035  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 = 2 AND e.real_date IS NOT NULL AND e.league_id = 49745 ORDER BY total DESC LIMIT 40
0.0036  SELECT distinct(shedule), round FROM `calendars2020` as c WHERE c.`league_id` = 49745 AND shedule >= '2019/11/01' AND shedule < '2019/12/01' ORDER BY shedule ASC
0.0034  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-03-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 49745 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0039  SELECT data1, data2 FROM services_tags WHERE categoryId=1542
0.0039  SELECT group_code, extraName from `leagues` WHERE categoryId=1542 AND year=2020