Escudo del Noia

Noia

Entrenador: Iván Carril

Temporada 2023/2024

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Noia

Enviar Datos
Información
  • Nombre del equipo Noia
  • Nombre completo Noia Club de Fútbol
  • Nombre corto NOI
  • País España
  • Ciudad Noia
  • Entrenador Iván Carril
  • URL del equipo en RF testing.resultados-futbol.com/Noia
Otros Datos
  • Año de Fundación 1928
  • Patrocinador Gruas Elgasa
  • Patrocinador Secundario Big Mat
  • Marca de Ropa Givova
  • Lugar de entrenamiento San Lázaro de Noia
Internet

Información sobre el estadio

  • Nombre del estadio San Lázaro de Noia
  • Capacidad 1000
  • Dirección Rúa Curros Enríquez, 33, 15200 Noia (A Coruña)
  • Teléfono 686158054-697758081
  • Fax 981822609
San Lázaro de Noia

Partidos del Noia

Ir al LIVESCORE
Preferente Galicia Preferente Galicia »
19 May 24  en 29 días Noia
17:00
 Victoria CF 0
12 May 24  en 22 días AD Miño
17:00
 Noia 0
05 May 24  en 15 días Noia
17:00
 San Tirso SD 0
28 Abr 24  en 8 días Dubra
17:00
 Noia 0
21 Abr 24  en 1 día Noia
17:30
 Club Lemos 0
14 Abr 24  Finalizado Tarjeta RojaTarjeta RojaSDC Residencia
1 - 1
 Noia 0
07 Abr 24  Finalizado Noia
2 - 4
 CD Lalín 0
24 Mar 24  Finalizado Tarjeta RojaCD Castro
1 - 1
 Noia 0
17 Mar 24  Finalizado Noia
3 - 0
 BoiroTarjeta Roja 0
10 Mar 24  Finalizado Eume Deportivo
2 - 3
 NoiaTarjeta Roja 0
03 Mar 24  Finalizado Noia
4 - 1
 Ribadeo FC 0
25 Feb 24  Finalizado Tarjeta RojaSigueiro CF
3 - 3
 Noia 0
18 Feb 24  Finalizado Noia
2 - 1
 Galicia Mugardos 0
04 Feb 24  Finalizado SD Sofán
0 - 1
 Noia 0
28 Ene 24  Finalizado Noia
2 - 0
 Cidade de Ribeira CF 0
21 Ene 24  Finalizado As Pontes
1 - 1
 Noia 0
14 Ene 24  Finalizado Noia
1 - 1
 At. Coruña Montañeros 0
07 Ene 24  Finalizado Victoria CF
1 - 3
 Noia 0

Plantilla del Noia Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
13 28 es 186 77 - - -
25 37 es - - - - 3
Defensa
3 25 py - - - - 5
4 24 es - - 2 - 12
2 34 es - - 1 - 5
5 30 es - - 1 - 6
22 22 es - - - - 3
15 25 es - - 4 1 6
Centrocampista
20 22 es - - - - -
14 20 es - - - - 5
7 25 es - - - - 7
11 30 es - - 5 - 6
20 26 es - - - - -
19 20 es - - 7 - 4
17 38 es - - 1 - 2
23 19 es - - - - -
8 36 es 170 74 2 1 8
Delantero
16 - es - - 2 - -
18 36 es - - 4 - 3
21 20 es - - 13 - 3
9 24 es - - 11 - 3
10 33 es 185 70 2 - -
13 - es - - - - -
23 - es - - - - -
20 - es - - - - -

Noticias del Noia

Ver últimas noticias

Así quedaron los 18 grupos de Tercera División

BeSoccer - Domingo, 13 Mayo 2018
18 19.128

Concluidas todas las jornadas de la temporada 17-18 en Tercera División, así han quedado los 18 grupos de la categoría.

Ver más noticias del equipo»



  USO DE MEMORIA  
5,181,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.3056
Total Execution Time  0.3079
  CADENA URL  
/Noia/
  GET DATOS  
$_GET['/Noia/']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0108  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '1819' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=1819 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73534) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 73534 AND teamId = 1819
0.0156  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 1819 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 1819 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0178  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 1819 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1819 AND rp.league_id = 73534 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0148  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6603878 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0107  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6603878
0.0120  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6603878 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0118  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6603878 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0115  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6603878 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0114   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6603878 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0127  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6603878 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC