4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Cebrereña - SC Uxama
Jornada 20
FINALIZADO
20
00
54 Pts. Elo
11º

43 Pts. Elo
10º

1-0
Domingo, 25 Febrero 2024, 16:30
Super 37'
1 - 0

Eventos del partido

Goles

SuperGol de
Super
minuto 37'

Tarjetas

Adri SugusT. Amarilla
Adri Sugus
minuto 48'
A. MuñozT. Amarilla
A. Muñoz
minuto 63'

Cambios

minuto 46'A. SoriaSale del partido A. Soria
minuto 46'S. IzquierdoEntra en el partido S. Izquierdo
minuto 62'A. GarciaSale del partido A. Garcia
minuto 62'D. AgueraEntra en el partido D. Aguera
Diego PérezSale del partido
Diego Pérez
minuto 65'
JuancarEntra en el partido
Juancar
minuto 65'
minuto 67'JavierEntra en el partido Javier
minuto 67'V. BodganSale del partido V. Bodgan
minuto 75'J. RubioEntra en el partido J. Rubio
minuto 75'DavidSale del partido David
minuto 75'O. GarciaEntra en el partido O. Garcia
minuto 75'D. ArranzSale del partido D. Arranz
D. SastreEntra en el partido
D. Sastre
minuto 78'
JuliSale del partido
Juli
minuto 78'
I. VázquezEntra en el partido
I. Vázquez
minuto 80'
M. JimenezSale del partido
M. Jimenez
minuto 80'

Alineaciones

Cebrereña

Cebrereña

4-4-2
Alineación Inicial
Suplentes
SC Uxama

SC Uxama

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,618,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.2828
Total Execution Time  0.2837
  CADENA URL  
/partido/Cultural-Cebrerena/Sporting-Uxama
  GET DATOS  
$_GET['/partido/Cultural-Cebrerena/Sporting-Uxama']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 73528 AND teamId = 6603795 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 73528 AND teamId = 6603803 and type = 33
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '492779' 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 = 492779 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 492779 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='492779' AND `active` = 1 AND year = 2024
0.0036  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='73528' AND relp.team_id=6603795 WHERE relp.in_squad=1 and mp.`match_id` = '492779' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0034  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='73528' AND relp.team_id=6603803 WHERE relp.in_squad=1 and mp.`match_id` = '492779' 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=492779 AND extraId = 73528 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=77 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 77 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1051167,1016306,807251,569516,556996) ORDER BY n.cover_points DESC, update_date DESC
0.0017  SELECT rating1, rating2 FROM calendars_elo WHERE id=492779 AND league_id=73528 AND year=2024
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 492779 AND league_id = 73528 AND year = 2024