4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Alondras Sub 19 - Racing Club Villalbés
Jornada 1
FINALIZADO
20
30
11 Pts. Elo
8º

6 Pts. Elo
18º

2-0
Sábado, 18 Septiembre 2021, 12:00
L. Quinteiro 30'
1 - 0
A. Rial 90'
2 - 0

Eventos del partido

Goles

L. QuinteiroGol de
L. Quinteiro
minuto 30'
A. RialGol de
A. Rial
minuto 90'

Tarjetas

minuto 34'H. FragaT. Amarilla H. Fraga
minuto 43'A. DiazT. Amarilla A. Diaz
B. MillánT. Amarilla
B. Millán
minuto 52'
Iván BoubetaT. Amarilla
Iván Boubeta
minuto 57'
minuto 76'N. TeixeiroT. Amarilla N. Teixeiro

Cambios

minuto 46'L. MolinaSale del partido L. Molina
minuto 46'D. LópezEntra en el partido D. López
minuto 46'H. BlancoSale del partido H. Blanco
minuto 46'M. RivasEntra en el partido M. Rivas
minuto 46'J. TembrasEntra en el partido J. Tembras
minuto 46'D. YañezSale del partido D. Yañez
Raúl OrtubeSale del partido
Raúl Ortube
minuto 65'
I. CachedaEntra en el partido
I. Cacheda
minuto 65'
P. PortasEntra en el partido
P. Portas
minuto 65'
B. MillánSale del partido
B. Millán
minuto 65'
minuto 71'G. BlancoSale del partido G. Blanco
minuto 71'J. GuedesEntra en el partido J. Guedes
M. PousadaEntra en el partido
M. Pousada
minuto 78'
A. EstevezSale del partido
A. Estevez
minuto 78'
minuto 82'H. FernandezSale del partido H. Fernandez
minuto 82'D. BujanEntra en el partido D. Bujan
M. BarciaSale del partido
M. Barcia
minuto 85'
L. EstigarribiaEntra en el partido
L. Estigarribia
minuto 85'

Alineaciones

Alondras Sub 19

Alondras Sub 19

4-4-2
Alineación Inicial
Suplentes
Racing Club Villalbés

Racing Club Villalbés

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,900,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Match / Index )  0.4215
Total Execution Time  0.4231
  CADENA URL  
/partido/Alondras-Juvenil/Villalbes-Rc-Juvenil/2021?section=legal
  GET DATOS  
$_GET['/partido/Alondras-Juvenil/Villalbes-Rc-Juvenil/2021']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0109   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 = 'Alondras-Juvenil' AND dt2.basealias = 'Villalbes-Rc-Juvenil'
0.0110   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 = 'Alondras-Juvenil' AND dt2.basealias = 'Villalbes-Rc-Juvenil'
0.0109   SELECT c.*, c.stadium as real_stadium, 2023 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 calendars2023 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 = 'Alondras-Juvenil' AND dt2.basealias = 'Villalbes-Rc-Juvenil'
0.0105  SELECT data1 FROM stats2022 t WHERE league_id = 63614 AND teamId = 6464856 and type = 33
0.0105  SELECT data1 FROM stats2022 t WHERE league_id = 63614 AND teamId = 6464865 and type = 33
0.0106  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '207055' and rp.type = 2022 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 207055 AND year = 2022 AND channel = 'Footters' LIMIT 1
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 207055 AND year = 2022 AND channel = 'Footters' LIMIT 1
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='207055' AND `active` = 1 AND year = 2022
0.0122  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='63614' AND relp.team_id=6464856 WHERE relp.in_squad=1 and mp.`match_id` = '207055' AND mp.year='2022' ORDER BY mp.`team` ASC, p.`role` ASC
0.0113  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='63614' AND relp.team_id=6464865 WHERE relp.in_squad=1 and mp.`match_id` = '207055' AND mp.year='2022' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=207055 AND extraId = 63614 AND type_rel = 4
0.0108  SELECT rating1, rating2 FROM calendars_elo WHERE id=207055 AND league_id=63614 AND year=2022
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 207055 AND league_id = 63614 AND year = 2022