¿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
Valencia Sub 19 - Real Betis Sub 19
Cuartos
FINALIZADO
30
20
69 Pts. Elo

71 Pts. Elo

1-3
Miércoles, 10 Mayo 2023, 19:30
  • Estadio: Ciudad Deportiva de Paterna
Joselu 28'
1 - 0
1 - 1
 29' Pablo García
1 - 2
 33' Assane Diao
1 - 3
 57' Assane Diao

Eventos del partido

Goles

JoseluGol de
Joselu
minuto 28'
minuto 29'Pablo GarcíaGol de Pablo García
minuto 33'Assane DiaoGol de penalti Assane Diao
minuto 57'Assane DiaoGol de Assane Diao

Tarjetas

minuto 12'Mateo FloresT. Amarilla Mateo Flores
Ismael SantanaT. Amarilla
Ismael Santana
minuto 20'
Martín TejónT. Amarilla
Martín Tejón
minuto 24'
minuto 49'S. Van Der PuttenT. Amarilla S. Van Der Putten
Javi NavarroT. Amarilla
Javi Navarro
minuto 60'

Cambios

Ismael SantanaSale del partido
Ismael Santana
minuto 58'
A. BuesoSale del partido
A. Bueso
minuto 58'
Alex GurendalEntra en el partido
Alex Gurendal
minuto 58'
Julián MartínezEntra en el partido
Julián Martínez
minuto 58'
minuto 62'Mateo FloresSale del partido Mateo Flores
minuto 62'Ginés SorrocheEntra en el partido Ginés Sorroche
Martín TejónSale del partido
Martín Tejón
minuto 70'
JoseluSale del partido
Joselu
minuto 70'
Hugo De MateoEntra en el partido
Hugo De Mateo
minuto 70'
A. BlázquezEntra en el partido
A. Blázquez
minuto 70'
minuto 75'Ángel OrtizSale del partido Ángel Ortiz
minuto 75'Carlos LeónEntra en el partido Carlos León
minuto 84'Pablo GarcíaSale del partido Pablo García
minuto 84'Carlos ReinaSale del partido Carlos Reina
minuto 84'Rodrigo MarinaEntra en el partido Rodrigo Marina
minuto 84'Mario PeregrinaEntra en el partido Mario Peregrina
Lucas NúñezEntra en el partido
Lucas Núñez
minuto 90'
Azael GarcíaSale del partido
Azael García
minuto 90'

Otros

Azael GarcíaAsistencia
Azael García
minuto 28'

Alineaciones

Valencia Sub 19

Valencia Sub 19

4-4-2
Alineación Inicial
Suplentes
Real Betis Sub 19

Real Betis Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,390,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3170
Total Execution Time  0.3181
  CADENA URL  
/partido/Valencia-Cf-Juvenil/Real-Betis-B-Juvenil/2023?section=legal
  GET DATOS  
$_GET['/partido/Valencia-Cf-Juvenil/Real-Betis-B-Juvenil/2023']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0027   SELECT c.*, c.stadium as real_stadium, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Valencia-Cf-Juvenil' AND dt2.basealias = 'Real-Betis-B-Juvenil'
0.0025   SELECT c.*, c.stadium as real_stadium, 2025 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2025 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Valencia-Cf-Juvenil' AND dt2.basealias = 'Real-Betis-B-Juvenil'
0.0017  SELECT data1 FROM stats2023 t WHERE league_id = 71568 AND teamId = 6575765 and type = 33
0.0017  SELECT data1 FROM stats2023 t WHERE league_id = 71568 AND teamId = 6575766 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '827319' and rp.type = 2023 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 = 827319 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 827319 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='827319' AND `active` = 1 AND year = 2023
0.0049  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='71568' AND relp.team_id=6575765 WHERE relp.in_squad=1 and mp.`match_id` = '827319' AND mp.year='2023' 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='71568' AND relp.team_id=6575766 WHERE relp.in_squad=1 and mp.`match_id` = '827319' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0028  SELECT /*115 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' INNER JOIN bs_news_rel rel ON rel.newId = n.id AND rel.type_rel = 4 AND rel.typeId = 827319 AND rel.extraId = 71568 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2023-03-11 18:30:00' AND n.creation_date<'2023-07-09 19:30:00' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=827319 AND league_id=71568 AND year=2023
0.0017  SELECT position FROM tables2023 WHERE team=6575765 AND league_id=71568 AND round=1
0.0017  SELECT position FROM tables2023 WHERE team=6575766 AND league_id=71568 AND round=1
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 827319 AND league_id = 71568 AND year = 2023