4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Finlandia Sub 16 - Suiza Sub 16
Jornada 4
FINALIZADO
00
10

4-4
Viernes, 26 Abril 2019, 16:30
  • Asistencia: 150 espectadores
Kasper Paananen 16'
1 - 0
1 - 1
 22' C. Chiappetta
Kai Meriluoto 24'
2 - 1
2 - 2
 30' Momodou Jaiteh
Kalle Wallius 40'
3 - 2
A. Hajdari 47'
4 - 2
4 - 3
 63' Noah Rupp
4 - 4
 80' A. Hajdari

Eventos del partido

Goles

Kasper PaananenGol de
Kasper Paananen
minuto 16'
minuto 22'C. ChiappettaGol de C. Chiappetta
Kai MeriluotoGol de
Kai Meriluoto
minuto 24'
minuto 30'Momodou JaitehGol de Momodou Jaiteh
Kalle WalliusGol de
Kalle Wallius
minuto 40'
A. Hajdari Gol de (p.p)
A. Hajdari
minuto47'
minuto 63'Noah RuppGol de Noah Rupp
minuto 80'A. HajdariGol de A. Hajdari

Tarjetas

minuto 59'T. MühlethalerT. Amarilla T. Mühlethaler

Cambios

Henri SalomaaEntra en el partido
Henri Salomaa
minuto 41'
Maksim StjopinSale del partido
Maksim Stjopin
minuto 41'
O. KoskinenEntra en el partido
O. Koskinen
minuto 58'
Kai MeriluotoSale del partido
Kai Meriluoto
minuto 58'
O. PajulaEntra en el partido
O. Pajula
minuto 58'
Kasper PaananenSale del partido
Kasper Paananen
minuto 58'
minuto 60'F. Van Der WerffSale del partido F. Van Der Werff
minuto 60'Noah RuppEntra en el partido Noah Rupp
minuto 60'Nikolas MuciEntra en el partido Nikolas Muci
minuto 60'K. SekularacSale del partido K. Sekularac
E. PatutEntra en el partido
E. Patut
minuto 66'
D. CukiciSale del partido
D. Cukici
minuto 66'
minuto 71'E. RossierEntra en el partido E. Rossier
minuto 71'Bradley FinkSale del partido Bradley Fink
minuto 71'Joël RibeiroEntra en el partido Joël Ribeiro
minuto 71'C. ChiappettaSale del partido C. Chiappetta
Nikolas TaloSale del partido
Nikolas Talo
minuto 72'
M. KivikkoEntra en el partido
M. Kivikko
minuto 72'
N. KekonenEntra en el partido
N. Kekonen
minuto 73'
N. SaarikiviSale del partido
N. Saarikivi
minuto 73'

Alineaciones

Finlandia Sub 16

Finlandia Sub 16

4-4-2
Alineación Inicial
Suplentes
Suiza Sub 16

Suiza Sub 16

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,009,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.9305
Total Execution Time  0.9315
  CADENA URL  
/partido/Finlandia-Sub-16/Suiza-Sub-16/2019
  GET DATOS  
$_GET['/partido/Finlandia-Sub-16/Suiza-Sub-16/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0321   SELECT c.*, c.stadium as real_stadium, 2019 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2019 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Finlandia-Sub-16' AND dt2.basealias = 'Suiza-Sub-16'
0.0112  SELECT c.*, 2019 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2019 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Finlandia-Sub-16' AND dt2.basealias = 'Suiza-Sub-16'
0.0106   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2019 AS ev WHERE ev.match_id=589378 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0110   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=51436 WHERE dp.id IN (884793,886216,921317,886221,885279,886199,886209,882923,885275,885274,885277,886510,886205,886217,886215,886501,886502,886218,879168,867209,885280,878212,886491,885282) AND (rp.team_id=6308829 OR rp.team_id=6309567)
0.0106   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2019 AS ev WHERE ev.match_id=589378 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0110   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=51436 WHERE dp.id IN (884793,886216,921317,886221,885279,885275,885274,886199,885277,886510,882923,886205,886209,886217,886215,886501,886502,886218,879168,867209,885280,878212,886491,885282) AND (rp.team_id=6308829 OR rp.team_id=6309567)
0.0105  SELECT data1 FROM stats2019 t WHERE league_id = 51436 AND teamId = 6308829 and type = 33
0.0105  SELECT data1 FROM stats2019 t WHERE league_id = 51436 AND teamId = 6309567 and type = 33
0.0105  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 51436 AND id_match = 589378
0.0110  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='51436' AND relp.team_id = drea.team_id WHERE rel.team_number=2939996 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0108  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='51436' AND relp.team_id = drea.team_id WHERE rel.team_number=2939997 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0140  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='51436' AND relp.team_id=6308829 WHERE mp.`match_id` = '589378' AND mp.year='2019' AND p.id NOT IN (857596,885279,885280,861567,861688,872721,886502,884793,885274,885282,921317,886196,886195,886199,855633,886204,886216,882923,886205,886215,886221,879168) ORDER BY mp.`team` ASC, p.`role` ASC
0.0152  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='51436' AND relp.team_id=6309567 WHERE mp.`match_id` = '589378' AND mp.year='2019' AND p.id NOT IN (857596,885279,885280,861567,861688,872721,886502,884793,885274,885282,921317,886196,886195,886199,855633,886204,886216,882923,886205,886215,886221,879168) ORDER BY mp.`team` ASC, p.`role` ASC
0.0107  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '589378' and rp.type = 2019 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '589378' and rp.type = 2019 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0108  SELECT *,rel.id as rel_id FROM `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 51436 AND rel.team1 = 6308829 AND rel.team2 = 6309567 ORDER BY FIELD(m.location,'es','en') DESC
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 589378 AND year = 2019 AND channel = 'Footters' LIMIT 1
0.0110  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 589378 AND year = 2019 AND channel = 'Footters' LIMIT 1
0.0118  SELECT *,rel.id as rel_id FROM `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='11' AND rel.active = 1 AND rel.league_id = 51436 AND rel.team1 = 6308829 AND rel.team2 = 6309567 ORDER BY FIELD(m.location,'es','en') DESC
0.0106  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2019` WHERE league_id = 51436 AND round >= 12 AND round <= 12 AND team = 6308829 ORDER BY round ASC
0.0107  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2019 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2019 and r.role=1 INNER JOIN datareferees dr on dr.id=r.referee_id INNER JOIN rel_calendars_referee as r2 ON c.id = r2.match_id and r2.year=2019 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 6308829 AND c.team2 = 6309567 AND c.league_id = 51436
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='589378' AND `active` = 1 AND year = 2019
0.0105  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='589378' AND `active` = 1 AND year = 2019
0.0147  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='51436' AND relp.team_id=6308829 WHERE relp.in_squad=1 and mp.`match_id` = '589378' AND mp.year='2019' ORDER BY mp.`team` ASC, p.`role` ASC
0.0198  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='51436' AND relp.team_id=6309567 WHERE relp.in_squad=1 and mp.`match_id` = '589378' AND mp.year='2019' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '51436' AND id_match = '589378'
0.0106   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '2939996' ORDER BY rating DESC LIMIT 1
0.0106   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '2939997' ORDER BY rating DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=589378 AND extraId = 51436 AND type_rel = 4
0.0105  SELECT rating1, rating2 FROM calendars_elo WHERE id=589378 AND league_id=51436 AND year=2019
0.0105  SELECT avg_rating FROM elo_teams WHERE id=122255
0.0106  SELECT avg_rating FROM elo_teams WHERE id=111406
0.0105  SELECT position FROM tables2019 WHERE team=6308829 AND league_id=51436 AND round=4
0.0105  SELECT position FROM tables2019 WHERE team=6309567 AND league_id=51436 AND round=4
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 589378 AND league_id = 51436 AND year = 2019