4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Felgueiras 1932 - Lusitania FC
Jornada 10
FINALIZADO
10
20
298 Pts. Elo
1º

294 Pts. Elo
2º

2-1
Domingo, 05 Noviembre 2023, 18:00
0 - 1
 8' Mika Borges
Tamble 80'
1 - 1
João Santos 93'
2 - 1

Eventos del partido

Goles

minuto 8'Mika BorgesGol de Mika Borges
TambleGol de
Tamble
minuto 80'
João SantosGol de
João Santos
minuto 93'

Tarjetas

minuto 6'Tiago CerveiraT. Amarilla Tiago Cerveira
João SantosT. Amarilla
João Santos
minuto 93'
minuto 95'Marcos ValenteT. Amarilla Marcos Valente

Cambios

minuto 56'Miguel PereiraSale del partido Miguel Pereira
minuto 56'Jefferson NemSale del partido Jefferson Nem
minuto 56'Cristiano GomesEntra en el partido Cristiano Gomes
minuto 56'Bruno MoraisEntra en el partido Bruno Morais
Miguel PereiraEntra en el partido
Miguel Pereira
minuto 59'
LeoSale del partido
Leo
minuto 59'
LandinhoSale del partido
Landinho
minuto 59'
João SantosEntra en el partido
João Santos
minuto 59'
Márcio PereiraEntra en el partido
Márcio Pereira
minuto 59'
Feliz VazSale del partido
Feliz Vaz
minuto 59'
minuto 68'Mika BorgesSale del partido Mika Borges
minuto 68'K. KalungaEntra en el partido K. Kalunga
minuto 68'IvanildoEntra en el partido Ivanildo
minuto 68'Fábio FortesSale del partido Fábio Fortes
Rui RampaSale del partido
Rui Rampa
minuto 73'
K. TakahashiEntra en el partido
K. Takahashi
minuto 73'
minuto 87'Rúben GonçalvesEntra en el partido Rúben Gonçalves
minuto 87'Diogo RosadoSale del partido Diogo Rosado
KatatauSale del partido
Katatau
minuto 92'
BruninhoEntra en el partido
Bruninho
minuto 92'

Otros

minuto 8'Diogo PereiraAsistencia Diogo Pereira
Miguel PereiraAsistencia
Miguel Pereira
minuto 80'
TambleAsistencia
Tamble
minuto 93'

Alineaciones

Felgueiras 1932

Felgueiras 1932

4-3-3
Alineación Inicial
Suplentes
Lusitania FC

Lusitania FC

3-4-3
Alineación Inicial
Suplentes

Estadísticas del partido

Felgueiras 1932 Felgueiras Lusitania FC Lusitania
2
Goles
 1
0
Tarjetas Amarillas
 3
0
Tarjetas Rojas
 1
2
Asistencias
 1
3
Sustituciones
 3


  USO DE MEMORIA  
6,697,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3560
Total Execution Time  0.3570
  CADENA URL  
/partido_72839/Felgueiras-1932/Lusitania-Fc
  GET DATOS  
$_GET['/partido_72839/Felgueiras-1932/Lusitania-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0060   SELECT c.*, c.stadium as real_stadium, 2024 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 calendars2024 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.league_id = 72839 AND dt1.basealias = 'Felgueiras-1932' AND dt2.basealias = 'Lusitania-Fc'
0.0042  SELECT c.*, 2024 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 calendars2024 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.league_id = 72839 AND dt1.basealias = 'Felgueiras-1932' AND dt2.basealias = 'Lusitania-Fc'
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72839 AND teamId = 6593859 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72839 AND teamId = 6593865 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '179073' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 179073 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 179073 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='179073' AND `active` = 1 AND year = 2024
0.0086  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='72839' AND relp.team_id=6593859 WHERE relp.in_squad=1 and mp.`match_id` = '179073' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0070  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='72839' AND relp.team_id=6593865 WHERE relp.in_squad=1 and mp.`match_id` = '179073' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=179073 AND extraId = 72839 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2489 AND type_rel = 3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 179073 AND league_id = 72839 AND year = 2024