4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Andratx - UE Sant Andreu
Jornada 34
FINALIZADO
20
10
313 Pts. Elo
12º

463 Pts. Elo
4º

0-3
Domingo, 05 Mayo 2024, 12:00
  • Estadio: Sa Plana
0 - 1
 36' Genís
0 - 2
 64' Juanan
0 - 3
 92' S. Serrano
Andratx

Andratx

4-4-2
Alineación Inicial
Suplentes
UE Sant Andreu

UE Sant Andreu

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

minuto 36'GenísGol de Genís
minuto 64'JuananGol de Juanan
minuto 92'S. SerranoGol de S. Serrano

Tarjetas

minuto 49'Gerard OlivaT. Amarilla Gerard Oliva
J. ManresaT. Amarilla
J. Manresa
minuto 66'
Oscar SánchezT. Amarilla
Oscar Sánchez
minuto 73'

Ocasiones

minuto 22'JosuGol anulado Josu
minuto 74'JuananGol anulado Juanan

Cambios

minuto 46'JuananEntra en el partido Juanan
minuto 46'A. GarcíaSale del partido A. García
Víctor LázaroEntra en el partido
Víctor Lázaro
minuto 61'
Toni PenyafortSale del partido
Toni Penyafort
minuto 61'
GarrySale del partido
Garry
minuto 61'
FlaquéEntra en el partido
Flaqué
minuto 61'
Oscar SánchezEntra en el partido
Oscar Sánchez
minuto 69'
MonirEntra en el partido
Monir
minuto 69'
C. CarossoSale del partido
C. Carosso
minuto 69'
GerardoSale del partido
Gerardo
minuto 69'
minuto 71'PauEntra en el partido Pau
minuto 71'Toni ParedesEntra en el partido Toni Paredes
minuto 71'Òscar RomeroSale del partido Òscar Romero
minuto 71'Gerard OlivaSale del partido Gerard Oliva
minuto 71'GuzmánSale del partido Guzmán
minuto 71'AlbertitoEntra en el partido Albertito
L. RamadaniEntra en el partido
L. Ramadani
minuto 78'
M. JaumeSale del partido
M. Jaume
minuto 78'
minuto 83'S. SerranoEntra en el partido S. Serrano
minuto 83'SergiSale del partido Sergi

Otros

minuto 36'JosuAsistencia Josu
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,947,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.2944
Total Execution Time  0.2954
  CADENA URL  
/partido/Andratx/Sant-Andreu/2024
  GET DATOS  
$_GET['/partido/Andratx/Sant-Andreu/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72364 AND teamId = 6587632 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72364 AND teamId = 6587647 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 = '197485' 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 = 197485 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 197485 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0040  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72364 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='197485' AND `active` = 1 AND year = 2024
0.0064  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=6587632 WHERE relp.in_squad=1 and mp.`match_id` = '197485' 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=6587647 WHERE relp.in_squad=1 and mp.`match_id` = '197485' 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=197485 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.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 197485 AND league_id = 72364 AND year = 2024