4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Lleida Esportiu - CE Europa
Jornada 33
FINALIZADO
31
30
498 Pts. Elo
3º

435 Pts. Elo
2º

0-1
Domingo, 28 Abril 2024, 12:00
0 - 1
 59' Adrià Gené

Eventos del partido

Goles

minuto 59'Adrià GenéGol de Adrià Gené

Tarjetas

João VigarioT. Amarilla
João Vigario
minuto 29'
minuto 46'BermuT. Amarilla Bermu
minuto 78'A. VilamitjanaT. Amarilla A. Vilamitjana
João Vigario2a Amarilla y Roja
João Vigario
minuto 90'
Jon BakeroT. Amarilla
Jon Bakero
minuto 90'
minuto 90'Alex PlaT. Amarilla Alex Pla

Cambios

MateoSale del partido
Mateo
minuto 60'
J. BecerraEntra en el partido
J. Becerra
minuto 60'
minuto 66'A. VilamitjanaEntra en el partido A. Vilamitjana
minuto 66'BermuSale del partido Bermu
S. MonteroSale del partido
S. Montero
minuto 75'
Óscar RubioSale del partido
Óscar Rubio
minuto 75'
Jon BakeroEntra en el partido
Jon Bakero
minuto 75'
Musa IsahEntra en el partido
Musa Isah
minuto 75'
minuto 79'Manel LozanoEntra en el partido Manel Lozano
minuto 79'AliagaSale del partido Aliaga
minuto 88'Marc ValesEntra en el partido Marc Vales
minuto 88'Adrià GenéSale del partido Adrià Gené

Otros

minuto 59'Javi EslavaAsistencia Javi Eslava

Alineaciones

Lleida Esportiu

Lleida Esportiu

Alineación Inicial
Suplentes
CE Europa

CE Europa

3-5-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,836,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.2752
Total Execution Time  0.2763
  CADENA URL  
/partido/Lleida/Ce-Europa/2024
  GET DATOS  
$_GET['/partido/Lleida/Ce-Europa/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72364 AND teamId = 6587646 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72364 AND teamId = 6587633 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 = '197470' 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 = 197470 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 197470 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='197470' AND `active` = 1 AND year = 2024
0.0058  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='72364' AND relp.team_id=6587646 WHERE relp.in_squad=1 and mp.`match_id` = '197470' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0056  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='72364' AND relp.team_id=6587633 WHERE relp.in_squad=1 and mp.`match_id` = '197470' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=197470 AND extraId = 72364 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2469 AND type_rel = 3
0.0021  SELECT avg_rating FROM elo_teams WHERE id=8760
0.0021  SELECT * FROM futbol.calendars_lineups WHERE id = 197470 AND league_id = 72364 AND year = 2024