4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Las Palmas - Mallorca
Jornada 1
FINALIZADO
30
20
1247 Pts. Elo
69%
9º

1696 Pts. Elo
30%
10º

1-1
Sábado, 12 Agosto 2023, 19:30
  • Estadio: Estadio de Gran Canaria
Jonathan Viera 29'
1 - 0
1 - 1
 70' A. Raíllo
Las Palmas

Las Palmas

4-5-1
Alineación Inicial
Suplentes
Mallorca

Mallorca

5-3-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

Jonathan VieraGol de penalti
Jonathan Viera
minuto 29'
minuto 70'A. RaílloGol de A. Raíllo

Tarjetas

minuto 28'CopeteT. Amarilla Copete
KirianT. Amarilla
Kirian
minuto 39'
minuto 53'Omar MascarellT. Amarilla Omar Mascarell
Álvaro LemosT. Amarilla
Álvaro Lemos
minuto 84'
E. LoiodiceT. Amarilla
E. Loiodice
minuto 84'

Ocasiones

minuto 21'Dani RodríguezTiro al palo Dani Rodríguez
minuto 41'Vedat MuriqiPenalti fallado Vedat Muriqi
minuto 41'Vedat MuriqiTiro al palo Vedat Muriqi
minuto 51'Amath NdiayeGol anulado Amath Ndiaye

Cambios

minuto 46'Sergi DarderEntra en el partido Sergi Darder
minuto 46'G. GonzalezSale del partido G. Gonzalez
minuto 46'CopeteSale del partido Copete
minuto 46'A. RaílloEntra en el partido A. Raíllo
minuto 60'Samú CostaEntra en el partido Samú Costa
minuto 60'Omar MascarellSale del partido Omar Mascarell
minuto 60'Cyle LarinEntra en el partido Cyle Larin
minuto 60'Amath NdiayeSale del partido Amath Ndiaye
Sergi CardonaEntra en el partido
Sergi Cardona
minuto 64'
MunirEntra en el partido
Munir
minuto 64'
Marc CardonaSale del partido
Marc Cardona
minuto 64'
D. SinkgravenSale del partido
D. Sinkgraven
minuto 64'
Nuke MfuluEntra en el partido
Nuke Mfulu
minuto 85'
KirianSale del partido
Kirian
minuto 85'
minuto 85'Manu MorlanesSale del partido Manu Morlanes
minuto 85'Javi LlabrésEntra en el partido Javi Llabrés

Otros

minuto 70'Sergi DarderAsistencia Sergi Darder

Goles

SandroGol concedido
Sandro
minuto 26'

Otros

minuto 28'CopetePenalti cometido Copete
KirianPenalti cometido
Kirian
minuto 39'

Estadísticas del partido

Las Palmas Las Palmas Mallorca Mallorca
69%
Posesión del balón
 30%
1
Goles
 1
2
Tiros a puerta
 2
1
Tiros fuera
 8
5
Total tiros
 12
1
Paradas del portero
 1
3
Saques de esquina
 6
1
Fueras de juego
 6
0
Tarjetas Rojas
 0
0
Asistencias
 1
0
Tiros al palo
 2
3
Sustituciones
 3
11
Faltas
 21
1
Penalti cometido
 1
1 Comentarios
  • FERNANDOportu
    Hace 9 meses FERNANDOportu dice: LA MEJOR HISTORIA DE LA UDLP ESTÁ AÚN POR ESCRIBIRSE

Partido televisado en...
Canal Medio Idioma País
Gol Play TV Castellano
DAZN LaLiga TV Castellano
DAZN TV Castellano
LaLiga TV Bar TV Castellano
SKY Sports TV Latino
SKY Sports TV -
SKY Sports TV -
SKY Sports TV Latino
SKY Sports TV -
SKY Sports TV -
SKY Sports TV -
DGO TV Latino
DSports TV Latino
DGO TV Latino
DSports TV Latino
DGO TV Latino
DSports TV -
DGO TV -
DGO TV -
DGO TV -
SKY Sports TV -

  USO DE MEMORIA  
7,570,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.5184
Total Execution Time  0.5194
  CADENA URL  
/partido/Ud-Palmas/Mallorca
  GET DATOS  
$_GET['/partido/Ud-Palmas/Mallorca']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0007   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '72116' AND c.`match_id` = '29278' AND c.comment_id IN (51939135) GROUP BY c.comment_id
0.0146  SELECT data1 FROM stats2024 t WHERE league_id = 72116 AND teamId = 6583642 and type = 33
0.0147  SELECT data1 FROM stats2024 t WHERE league_id = 72116 AND teamId = 6583643 and type = 33
0.0156  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '29278' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0150  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 29278 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0148  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 29278 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0309  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 = 72116 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.0152   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '51939135' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0145  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='29278' AND `active` = 1 AND year = 2024
0.0222  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='72116' AND relp.team_id=6583642 WHERE relp.in_squad=1 and mp.`match_id` = '29278' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0231  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='72116' AND relp.team_id=6583643 WHERE relp.in_squad=1 and mp.`match_id` = '29278' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0144  SELECT * FROM futbol.calendars_lineups WHERE id = 29278 AND league_id = 72116 AND year = 2024