4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Sporting Cambre - Relámpago S.D.
Jornada 31
FINALIZADO
40
20
15 Pts. Elo
15º

15 Pts. Elo
12º

3-0
Domingo, 28 Abril 2024, 20:07
M. Loureiro 4'
1 - 0
A. Garcia 60'
2 - 0
Pablo Garaboa 67'
3 - 0

Eventos del partido

Goles

M. LoureiroGol de
M. Loureiro
minuto 4'
A. GarciaGol de
A. Garcia
minuto 60'
Pablo GaraboaGol de
Pablo Garaboa
minuto 67'

Tarjetas

minuto 8'M. PeñaT. Amarilla M. Peña
J. LagoT. Amarilla
J. Lago
minuto 20'
minuto 56'R. BlancoT. Amarilla R. Blanco
C. PerezT. Amarilla
C. Perez
minuto 57'
L. OteroT. Amarilla
L. Otero
minuto 65'
J. FernandezT. Amarilla
J. Fernandez
minuto 68'

Cambios

M. IglesiasSale del partido
M. Iglesias
minuto 46'
J. FernandezEntra en el partido
J. Fernandez
minuto 46'
minuto 63'M. PeñaSale del partido M. Peña
minuto 63'Gonzalo TruanEntra en el partido Gonzalo Truan
minuto 63'R. BlancoSale del partido R. Blanco
minuto 63'G. ChapetónEntra en el partido G. Chapetón
B. ValenciaEntra en el partido
B. Valencia
minuto 68'
A. GarciaSale del partido
A. Garcia
minuto 68'
Pablo GaraboaSale del partido
Pablo Garaboa
minuto 76'
D. GonzalezEntra en el partido
D. Gonzalez
minuto 76'
D. CornideEntra en el partido
D. Cornide
minuto 76'
J. LagoSale del partido
J. Lago
minuto 76'
C. PerezSale del partido
C. Perez
minuto 81'
J. MolinaEntra en el partido
J. Molina
minuto 81'

Alineaciones

Sporting Cambre

Sporting Cambre

4-4-2
Alineación Inicial
Suplentes
Relámpago S.D.

Relámpago S.D.

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,798,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Match / Index )  1.1147
Total Execution Time  1.1162
  CADENA URL  
/partido/Sporting-Cambre/Relampago/2024
  GET DATOS  
$_GET['/partido/Sporting-Cambre/Relampago/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0255  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73633
0.0124  SELECT data1 FROM stats2024 t WHERE league_id = 73633 AND teamId = 6605809 and type = 33
0.0124  SELECT data1 FROM stats2024 t WHERE league_id = 73633 AND teamId = 6605812 and type = 33
0.0128  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '512988' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 512988 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 512988 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='512988' AND `active` = 1 AND year = 2024
0.0141  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='73633' AND relp.team_id=6605809 WHERE relp.in_squad=1 and mp.`match_id` = '512988' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0134  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='73633' AND relp.team_id=6605812 WHERE relp.in_squad=1 and mp.`match_id` = '512988' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=512988 AND extraId = 73633 AND type_rel = 4
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=694 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 694 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (912025,141904,92516) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT rating1, rating2 FROM calendars_elo WHERE id=512988 AND league_id=73633 AND year=2024
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 512988 AND league_id = 73633 AND year = 2024