4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Serra FC
Información
Otros Datos
  • Patrocinador Baneste
  • Patrocinador Secundario Los Neto
  • Marca de Ropa Rhumy
Internet

Información sobre el estadio

  • Nombre del estadio Roberto Siqueira Costa (Robertão)
  • Capacidad 3000
Roberto Siqueira Costa (Robertão)

Partidos del Serra FC

Ir al LIVESCORE
20 Jul 24  en 3 meses Audax Rio
-
Serra FC 0
13 Jul 24  en 2 meses Serra FC
-
Nova Iguaçu 0
06 Jul 24  en 2 meses Serra FC
-
Real Noroeste 0
29 Jun 24  en 2 meses Democrata SL
-
Serra FC 0
22 Jun 24  en 2 meses Ipatinga FC
-
Serra FC 0
15 Jun 24  en 1 mes Serra FC
-
Itabuna 0
12 Jun 24  en 1 mes Portuguesa RJ
-
Serra FC 0
08 Jun 24  en 1 mes Serra FC
-
Portuguesa RJ 0
01 Jun 24  en 1 mes Itabuna
-
Serra FC 0
25 May 24  en 1 mes Serra FC
-
Ipatinga FC 0
18 May 24  en 29 días Serra FC
-
Democrata SL 0
11 May 24  en 22 días Real Noroeste
-
Serra FC 0
04 May 24  en 15 días Nova Iguaçu
-
Serra FC 0
28 Abr 24  en 9 días Serra FC
-
Audax Rio 0
02 Mar 24  Finalizado Tarjeta RojaSerra FC
1 - 1
Estrela do Norte 0
21 Feb 24  Finalizado Porto Vitória
2 - 1
Serra FCTarjeta Roja 2
17 Feb 24  Finalizado Tarjeta RojaSerra FC
0 - 1
Rio Branco-VN 1
07 Feb 24  Finalizado Real Noroeste
5 - 1
Serra FC 3
03 Feb 24  Finalizado Serra FC
5 - 0
Jaguaré 11
30 Ene 24  Finalizado Nova Venecia
1 - 1
Serra FC 3
28 Ene 24  Finalizado Tarjeta RojaSerra FC
1 - 2
Rio Branco ES 0
24 Ene 24  Finalizado Vitória ES
3 - 1
Serra FC 11
20 Ene 24  Finalizado Serra FC
0 - 1
Desportiva Ferroviária 6

Noticias del Serra FC

Ver últimas noticias

El golazo de rabona que dio la vuelta al mundo

El tanto que Rael marcó para Serra en la Copa Espírito Santo bien puede valer el premio Puskas. Y es que el jugador mandó el balón al fondo de la red con una rabona desde fuera del área.




  USO DE MEMORIA  
5,461,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.2170
Total Execution Time  0.2188
  CADENA URL  
/Serra-Fc
  GET DATOS  
$_GET['/Serra-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0216  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 = 75630
0.0111  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 = 74835
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63552 AND type_rel = 2
0.0110  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 63552 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0110  SELECT /*35 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' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (688400) ORDER BY n.cover_points DESC, update_date DESC
0.0110  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 = '63552' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0109  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75630 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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 = 63552 AND rp.league_id = 75630 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0107  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 = 63552 AND rp.league_id = 75630 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1