4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
PE Sant Jordi - Inter Ibiza
Jornada 19
FINALIZADO
20
20
54 Pts. Elo
1º

47 Pts. Elo
3º

2-1
Domingo, 17 Marzo 2024, 19:00
0 - 1
 45' Antonio
Roger 47'
1 - 1
A. Carella 69'
2 - 1

Eventos del partido

Goles

minuto 45'AntonioGol de Antonio
RogerGol de
Roger
minuto 47'
A. CarellaGol de
A. Carella
minuto 69'

Tarjetas

A. CarellaT. Amarilla
A. Carella
minuto 40'
minuto 50'Pau FerrerT. Amarilla Pau Ferrer
E. SiligatoT. Amarilla
E. Siligato
minuto 53'
minuto 71'AntonioT. Amarilla Antonio

Cambios

minuto 63'M. AmilcarEntra en el partido M. Amilcar
minuto 63'G. LucenaEntra en el partido G. Lucena
minuto 63'Pau FerrerSale del partido Pau Ferrer
minuto 63'G. BarreiroSale del partido G. Barreiro
minuto 73'D. TamayoEntra en el partido D. Tamayo
CholoEntra en el partido
Cholo
minuto 73'
E. BertiSale del partido
E. Berti
minuto 73'
minuto 73'T. AguilarSale del partido T. Aguilar
minuto 77'Juan PrefacioSale del partido Juan Prefacio
minuto 77'S. GornoEntra en el partido S. Gorno
E. SiligatoSale del partido
E. Siligato
minuto 84'
LucasEntra en el partido
Lucas
minuto 84'
WalterSale del partido
Walter
minuto 87'
J. AndradeEntra en el partido
J. Andrade
minuto 87'

Alineaciones

PE Sant Jordi

PE Sant Jordi

4-4-2
Alineación Inicial
Suplentes
Inter Ibiza

Inter Ibiza

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,659,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.4654
Total Execution Time  0.4663
  CADENA URL  
/partido/Pe-Sant-Jordi/Inter-Ibiza/2022?section=legal
  GET DATOS  
$_GET['/partido/Pe-Sant-Jordi/Inter-Ibiza/2022']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 73525 AND teamId = 6603749 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 73525 AND teamId = 6603744 and type = 33
0.1066  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '491986' 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 = 491986 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 491986 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0028  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='491986' AND `active` = 1 AND year = 2024
0.0413  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='73525' AND relp.team_id=6603749 WHERE relp.in_squad=1 and mp.`match_id` = '491986' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0404  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='73525' AND relp.team_id=6603744 WHERE relp.in_squad=1 and mp.`match_id` = '491986' 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=491986 AND extraId = 73525 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=79 AND type_rel = 3
0.0064  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 79 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0034  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1105676,1105343,1104898,676494,412502) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=491986 AND league_id=73525 AND year=2024
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 491986 AND league_id = 73525 AND year = 2024