¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Atl. Santa Cruz - CD Lumbreras
Jornada 22
FINALIZADO
20
30
42 Pts. Elo
1º

15 Pts. Elo
14º

2-1
Sábado, 15 Febrero 2025, 16:00
Gabri Canovas 55'
1 - 0
E. Rufete 60'
2 - 0
2 - 1
 89' A. Rabih

Eventos del partido

Goles

Gabri CanovasGol de
Gabri Canovas
minuto 55'
E. RufeteGol de
E. Rufete
minuto 60'
minuto 89'A. RabihGol de A. Rabih

Tarjetas

minuto 47'J. ParraT. Amarilla J. Parra
minuto 68'A. ReverteT. Amarilla A. Reverte
A. BrunoT. Amarilla
A. Bruno
minuto 79'
RichardT. Amarilla
Richard
minuto 86'
minuto 88'Miguel OrtuñoT. Amarilla Miguel Ortuño

Cambios

minuto 57'S. SanchezSale del partido S. Sanchez
minuto 57'AsensioSale del partido Asensio
minuto 57'D. SimonEntra en el partido D. Simon
minuto 57'M. SimonEntra en el partido M. Simon
minuto 61'Jesus RosSale del partido Jesus Ros
minuto 61'Miguel OrtuñoEntra en el partido Miguel Ortuño
minuto 66'J. ParraSale del partido J. Parra
minuto 66'J. GarciaSale del partido J. Garcia
minuto 66'J. RoheEntra en el partido J. Rohe
minuto 66'A. LopezEntra en el partido A. Lopez
YakoSale del partido
Yako
minuto 67'
E. AlemanEntra en el partido
E. Aleman
minuto 67'
MarioSale del partido
Mario
minuto 71'
I. FernandezSale del partido
I. Fernandez
minuto 71'
D. TabarezEntra en el partido
D. Tabarez
minuto 71'
A. MartinezEntra en el partido
A. Martinez
minuto 71'
E. RufeteSale del partido
E. Rufete
minuto 81'
Gabri CanovasSale del partido
Gabri Canovas
minuto 81'
RichardEntra en el partido
Richard
minuto 81'
RuloEntra en el partido
Rulo
minuto 81'

Alineaciones

Atl. Santa Cruz

Atl. Santa Cruz

4-4-2
Alineación Inicial
Suplentes
CD Lumbreras

CD Lumbreras

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,907,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.7605
Total Execution Time  0.7614
  CADENA URL  
/partido/Atletico-Santa-Cruz-Senior/Cd-Lumbreras-Senior
  GET DATOS  
$_GET['/partido/Atletico-Santa-Cruz-Senior/Cd-Lumbreras-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0246  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 = 77219
0.0104  SELECT data1 FROM stats2025 t WHERE league_id = 77219 AND teamId = 6659458 and type = 33
0.0104  SELECT data1 FROM stats2025 t WHERE league_id = 77219 AND teamId = 6659469 and type = 33
0.0107  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '124010' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0104  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 124010 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0104  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 124010 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0106  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 77219 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  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 `tables2025` 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 = 77219 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0220  SELECT t.points,t.team,t.round FROM `tables2025` 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 = 77219 AND t.round >= 8 AND t.round <= 23 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC, dt.nameShow ASC
0.0107  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='124010' AND `active` = 1 AND year = 2025
0.0209  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='77219' AND relp.team_id=6659458 WHERE relp.in_squad=1 and mp.`match_id` = '124010' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0195  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='77219' AND relp.team_id=6659469 WHERE relp.in_squad=1 and mp.`match_id` = '124010' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0108  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=124010 AND extraId = 77219 AND type_rel = 4
0.0108  SELECT rating1, rating2 FROM calendars_elo WHERE id=124010 AND league_id=77219 AND year=2025
0.0109  SELECT * FROM futbol.calendars_lineups WHERE id = 124010 AND league_id = 77219 AND year = 2025