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 275
Jornada Siguiente »
 
01 Mar 24
Finalizado 		FC Nyva Vinnytsya FC Nyva Vinnytsya 4-2 FC Mariupol FC Mariupol más información ...
 
01 Mar 24
Finalizado 		Hirnyk-Sport Hirnyk-Sport 0-0 Zirka Kirovohrad Zirka Kirovohrad más información ...
 
01 Mar 24
Finalizado 		Auckland City Auckland City 2-0 Manurewa Manurewa más información ...
 
01 Mar 24
Finalizado 		Livyi Bereh Livyi Bereh 1-1 Dinaz Vyshhorod Dinaz Vyshhorod más información ...
 
01 Mar 24
Finalizado 		Inhulets Inhulets 2-1 SC Poltava SC Poltava más información ...
 
01 Mar 24
Finalizado 		Sotra SK Sotra SK 3-2 Loddefjord Loddefjord más información ...
 
01 Mar 24
Finalizado 		Karpaty Lviv Karpaty Lviv 2-1 Nyva Ternopil Nyva Ternopil más información ...
 
01 Mar 24
Finalizado 		Chayka Chayka 2-0 Kudrivka Kudrivka más información ...
 
01 Mar 24
Finalizado 		Druzhba Druzhba 2-3 Nyva Buzova Nyva Buzova más información ...
 
01 Mar 24
09:30 Finalizado 		Legion Makhachkala Legion Makhachkala 1-3 Pobeda Khasavyurt Pobeda Khasavyurt más información 2
 
01 Mar 24
11:00 Finalizado 		Bukovyna Chernivtsi Bukovyna Chernivtsi 2-1 Metalist Kharkiv Metalist Kharkiv más información Jugadas destacadas 6
19' V. Faraseyenko 1-0
1-1 48' P. Lutsiv
56' D. Goncharuk 2-1
 
01 Mar 24
11:00 Finalizado 		Khust City Khust City 2-3 Skala Stryi Skala Stryi más información Jugadas destacadas 1
24' Denys Chervinskyi 1-0
30' B. Pavlych 2-0
2-1 38' M. Fomin
2-2 62' V. Merdeev
2-3 87' Taras Puchkovsyi
 
01 Mar 24
11:00 Finalizado 		Sănătatea Cluj Sănătatea Cluj 3-2 Minerul Ocna Dej Minerul Ocna Dej más información Jugadas destacadas 1
4' D. Olteanu 1-0
1-1 28' J. Godwin
71' Junior 2-1
2-2 83' Stephane Ferhaoui
92' D. Cimpoesu 3-2
 
01 Mar 24
12:45 Finalizado 		Balestier Khalsa Balestier Khalsa 4-1 Tanjong Pagar Tanjong Pagar más información Jugadas destacadas 1
4' K. Tanaka 1-0
16' K. Tanaka 2-0
 
01 Mar 24
12:45 Finalizado 		Young Lions Young Lions 5-2 Geylang International Geylang International más información 1
 
01 Mar 24
13:00 Finalizado 		Prykarpattya Prykarpattya 3-0 Viktoriya Mykolaivka Viktoriya Mykolaivka más información 1
 
01 Mar 24
13:00 Finalizado 		Stabæk Stabæk 2-1 IK Start IK Start más información Jugadas destacadas 2
0-1 8' S. Sjøkvist
47' Rasmus Vinge 1-1
55' S. Hansen
 
01 Mar 24
18:00 Finalizado 		Aalesunds FK Aalesunds FK 3-1 Brattvåg Brattvåg más información Jugadas destacadas 1
70' D. Johannsson 1-0
75' N. Solskjær 2-0
97' N. Solskjær 3-0
 
01 Mar 24
18:00 Finalizado 		SV Tillmitsch SV Tillmitsch 3-0 SVL Flavia Solva SVL Flavia Solva más información 1
 
01 Mar 24
18:00 Finalizado 		SC Fürstenfeld SC Fürstenfeld 2-0 SV Krottendorf SV Krottendorf más información 1
 
01 Mar 24
18:30 Finalizado 		Levanger Levanger 0-1 IL Stjørdals-Blink IL Stjørdals-Blink más información Jugadas destacadas 1
0-1 92' M. Horgoien
 
01 Mar 24
18:30 Finalizado 		SAK 1914 SAK 1914 4-0 St. Johann St. Johann más información 1
 
01 Mar 24
19:00 Finalizado 		Tvååker Tvååker 2-1 Qviding FIF Qviding FIF más información Jugadas destacadas 1
9' O. Ruuska 1-0
61' P. Nyman
67' I. Wiman 2-0
2-1 86' William Brandt
 
01 Mar 24
19:00 Finalizado 		Frøya Frøya 5-1 Fana Fana más información 1
 
01 Mar 24
19:00 Finalizado 		SV Stockerau SV Stockerau 2-2 Zwettl Zwettl más información 1
 
01 Mar 24
19:00 Finalizado 		Fehring Fehring 4-3 TSV Kirchberg TSV Kirchberg más información 1
 
01 Mar 24
19:00 Aplazado 		Gratkorn Gratkorn Apl Union Gamlitz Union Gamlitz más información 1
 
01 Mar 24
19:00 Finalizado 		Trollhattan FC Trollhattan FC 2-0 Stenungsund Stenungsund más información Jugadas destacadas 1
62' Sener 1-0
68' J. Richards 2-0
 
01 Mar 24
19:00 Finalizado 		SV Union Gnas SV Union Gnas 5-1 SV Pachern SV Pachern más información 1
 
01 Mar 24
19:00 Aplazado 		Torns Torns Apl BK Olympic BK Olympic más información 1
 
01 Mar 24
19:00 Finalizado 		Bruck/Mur Bruck/Mur 2-0 Kindberg-Mürzhofen Kindberg-Mürzhofen 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,393,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2803
Total Execution Time  0.2822
  CADENA URL  
/partidos_amistosos/grupo1/jornada275
  GET DATOS  
$_GET['/partidos_amistosos/grupo1/jornada275']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 17:32:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 17:32:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 17:32:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 17:32:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  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=275
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 `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` = 275 ORDER BY shedule ASC LIMIT 200
0.0185  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 (708833,707250,707249,707247,707246,707244,707243,707242,707241,706224,681553,685255,706225,700147,700146,697849,676860,676828,694686,676829,689914,687790,699353,697409,703968,697051,686154,681554,677114,676831,676830) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0133  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 = 275 AND e.real_date IS NOT NULL AND e.league_id = 71432 ORDER BY total DESC LIMIT 40
0.0282  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.0126  SELECT data1, data2 FROM services_tags WHERE categoryId=153
0.0136  SELECT group_code, extraName from `leagues` WHERE categoryId=153 AND year=2024