4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
Publicidad 600x120.gif
Partidos Amistosos
2023/2024

Partidos Amistosos

Resultados
« Jornada Anterior
Jornada 289
Jornada Siguiente »
 
15 Mar 24
Finalizado 		Hirnyk-Sport Hirnyk-Sport 0-2 SC Poltava SC Poltava más información ...
 
15 Mar 24
10:00 Aplazado 		Bukovyna Chernivtsi Bukovyna Chernivtsi Apl Druzhba Druzhba más información ...
 
15 Mar 24
11:00 Finalizado 		Sakhalin Yuzhno-Sakhalinsk Sakhalin 3-0 Yenisey II Yenisey II más información Jugadas destacadas ...
31' K. Mogel 1-0
33' V. Alshanskiy 2-0
44' V. Chizhikov 3-0
 
15 Mar 24
11:00 Finalizado 		Nyva Ternopil Nyva Ternopil 4-1 Minai Sub 19 Minai Sub 19 más información Jugadas destacadas ...
66' B. Kozak 1-0
71' O. Khrustavka 2-0
73' A. Zin 3-0
80' Serhii Davydov 4-0
4-1 83' V. Mykhayliv
 
15 Mar 24
11:00 Finalizado 		Metalist Kharkiv Metalist Kharkiv 2-1 Ahrobiznes Volochysk Ahrobiznes Volochysk más información Jugadas destacadas 1
51' Oleksandr Tsvirenko 1-0
1-1 71' Roman Kuzmyn
73' Gennadiy Synchuk 2-1
 
15 Mar 24
12:00 Finalizado 		Khust City Khust City 0-2 PFK Zvyagel PFK Zvyagel más información Jugadas destacadas 1
0-1 55' Bohdan Panchyshyn
0-2 83' A. Fesenko
 
15 Mar 24
13:00 Finalizado 		Hammarby IF Hammarby IF 1-0 Sandvikens IF Sandvikens IF más información Jugadas destacadas ...
48' M. Madjed 1-0
 
15 Mar 24
13:00 Finalizado 		Karpaty Lviv Karpaty Lviv 2-2 Shakhtar Donetsk Shakhtar Donetsk más información Jugadas destacadas 3
1' Y. Kostenko 1-0
1-1 13' L. Traoré
1-2 34' L. Traoré
76' Arielson 2-2
 
15 Mar 24
13:30 Finalizado 		Kristiansund BK Kristiansund BK 1-1 Levanger Levanger más información 1
 
15 Mar 24
14:00 Aplazado 		Aalesunds FK II Aalesunds FK II Apl Brattvåg Brattvåg más información 1
 
15 Mar 24
14:00 Finalizado 		Mjällby AIF Mjällby AIF 1-2 Brommapojkarna Brommapojkarna más información Jugadas destacadas ...
0-1 46' A. Timossi
56' H. Johansson 1-1
1-2 65' Alexander Johansson
 
15 Mar 24
14:00 Finalizado 		Jerv Jerv 3-4 Bryne Bryne más información Jugadas destacadas 7
6' T. Wichne 1-0
26' M. Ugland 2-0
65' F. Schroter 3-0
 
15 Mar 24
14:30 Aplazado 		Umeå Umeå Apl VIFK VIFK más información 1
 
15 Mar 24
14:30 Finalizado 		Umeå Umeå 1-4 VPS Vaasa VPS Vaasa más información Jugadas destacadas 2
0-1 23' Yevgeni Bashkirov
0-2 36' J. Hyvarinen
0-3 56' K. Multanen
0-4 80' Teemu Hytönen
82' W. Hofvander 1-4
 
15 Mar 24
16:00 Finalizado 		Hammarby IF Hammarby IF 1-3 IFK Göteborg IFK Göteborg más información Jugadas destacadas ...
0-1 21' Thomas Santos
0-2 48' A. Salaou
66' V. Djukanovic 1-2
1-3 70' G. Norlin
72' P. Vagic
 
15 Mar 24
16:00 Finalizado 		GIF Sundsvall GIF Sundsvall 2-0 Friska Viljor Friska Viljor más información Jugadas destacadas 1
20' P. Engblom 1-0
61' Marc Manchón 2-0
 
15 Mar 24
18:00 Finalizado 		Aalesunds FK Aalesunds FK 1-1 Hødd Hødd más información Jugadas destacadas 1
0-1 36' A. Scriven
57' D. Johannsson
74' Cláudio Braga 1-1
 
15 Mar 24
19:00 Finalizado 		Torslanda IK Torslanda IK 1-1 Stenungsund Stenungsund más información 1
 
15 Mar 24
19:30 Finalizado 		Gorslev Gorslev 0-0 Greve IF Greve IF más información 1

INFORMACIÓN

Partidos Amistosos entren clubes de todo el mundo.Se realizan antes de comenzar sus respectivas ligas.

Partidos Amistosos


  USO DE MEMORIA  
5,376,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0995
Total Execution Time  0.1015
  CADENA URL  
/partidos_amistosos/grupo1/jornada289
  GET DATOS  
$_GET['/partidos_amistosos/grupo1/jornada289']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0243  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 = 71432 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 07:25:15' 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 07:25:15' 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 07:25:15' 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=3 AND last_update > '2024-04-28 07:25:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  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=71432 AND rel.round=289
0.0026  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 `calendars2024` 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` = 71432 AND c.`round` = 289 ORDER BY shedule ASC LIMIT 200
0.0036  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 events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 71432 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 (715106,712088,707292,714842,698476,685259,712765,714775,691407,694687,712766,676921,707056,709945,712768,676922,676920,676923,712767) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0030  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 `events2024` e INNER JOIN calendars2024 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 = 289 AND e.real_date IS NOT NULL AND e.league_id = 71432 ORDER BY total DESC LIMIT 40
0.0118  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 71432 AND shedule >= '2024/03/01' AND shedule < '2024/04/01' ORDER BY shedule ASC
0.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=153
0.0026  SELECT group_code, extraName from `leagues` WHERE categoryId=153 AND year=2024