4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fluminense PI
Información
Internet

Histórico de participación

Partidos del Fluminense PI

Ir al LIVESCORE
20 Jul 24  en 2 meses Maranhão
-
Fluminense PI 0
13 Jul 24  en 2 meses Fluminense PI
-
Aguia de Maraba 0
06 Jul 24  en 2 meses Tocantinópolis
-
Fluminense PI 0
29 Jun 24  en 2 meses Ríver
-
Fluminense PI 0
22 Jun 24  en 1 mes Fluminense PI
-
Altos 0
15 Jun 24  en 1 mes Moto Club MA
-
Fluminense PI 0
12 Jun 24  en 1 mes Fluminense PI
-
Cametá 0
09 Jun 24  en 1 mes Cametá
21:00
Fluminense PI 0
02 Jun 24  en 1 mes Fluminense PI
21:00
Moto Club MA 0
25 May 24  en 27 días Altos
21:00
Fluminense PI 0
19 May 24  en 21 días Fluminense PI
21:00
Ríver 0
11 May 24  en 13 días Fluminense PI
21:00
Tocantinópolis 0
07 May 24  en 8 días Aguia de Maraba
01:00
Fluminense PI 0
28 Abr 24  en 10 h Fluminense PI
21:00
Maranhão 0
29 Feb 24  Finalizado Altos
2 - 1
Fluminense PI 0
25 Feb 24  Finalizado Fluminense PI
0 - 3
Altos 0
18 Feb 24  Finalizado Oeirense
1 - 1
Fluminense PI 0
08 Feb 24  Finalizado Fluminense PI
4 - 0
Corí-Sabbá 18
03 Feb 24  Finalizado Fluminense PI
1 - 1
ParnahybaTarjeta Roja 2
28 Ene 24  Finalizado Fluminense PI
0 - 1
Oeirense 0
21 Ene 24  Finalizado Corí-Sabbá
1 - 2
Fluminense PI 1
14 Ene 24  Finalizado Parnahyba
1 - 0
Fluminense PI 0

Plantilla del Fluminense PI Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Defensa
30 br - - - - -
Delantero
32 br 180 72 - - -

Noticias de Serie D - Brasil

Ver últimas noticias

Fallece un futbolista de 4ª Brasileña en un entrenamiento

José Aldean Oliveira de Jesus, popularmente conocido como Deon, ha fallecido a los 36 años en un entrenamiento con su club, Bahía de Feira, de la Série D de Brasil.

8 jugadores suspendidos en Brasil por amaños

El caso de los amaños en Brasil está siendo investigado. El Tribunal Superior de Justicia ha suspendido 30 días a 8 jugadores por estar implicados en esta red. Estos son Eduardo Bauermann (Santos), Moraes (Atlético GO), Gabriel Tota (Ypiranga), Paulo Miranda (Náutico), Igor Carius (Sport Recife), Matheus Phillipe Coutinho Gomes (SergipeJ), Fernando Neto (Sao Bernardo) y Kevin Lomónaco (Bragantino).

Kaua Elias, el 'Vitor Roque 2.0' que ojea el Barça

El Barcelona apunta en su lista de futuro el nombre de Kaua Elias. El delantero brasileño de 17 años cumple un perfil compatible con el de Vitor Roque y, según 'Sport', el conjunto azulgrana le vigila muy de cerca debido a su papel en el Sudamericano Sub 17.

Un hincha de Internacional agredió, con su hija en brazos, a un jugador de Caxias

Un aficionado de Internacional bajó al césped del Beira-Rio, con una niña en brazos, para agredir a un jugador de Caxias. La defensa del agresor testificó que saltó al campo para "proteger a su hija", mientras que el Ministerio Público de Rio Grande do Sul quiere quitarle la custodia al padre para los próximos tres años.

Un club invitó a Neymar, pero... ¡no le garantizó la titularidad!

Paraná Clube, equipo de la Serie D de Brasil, bromeó en las redes sociales e le envió una invitación al futbolista brasileño para que se una a la plantilla en este mercado.




  USO DE MEMORIA  
5,809,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.0863
Total Execution Time  0.0891
  CADENA URL  
/fluminense-esporte-clube
  GET DATOS  
$_GET['/fluminense-esporte-clube']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'fluminense-esporte-clube'
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=149940 AND type_rel = 2
0.0026  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 = '149940' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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=149940 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (75630,75446,75215,70863) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75630 AND teamId = 149940
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 75215 AND teamId = 149940
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 70863 AND teamId = 149940
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75446 AND teamId = 149940
0.0021  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '149940' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '149940' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '149940' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0027  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 = 75630 WHERE rp.league_id = 75630 AND rp.teamId = 149940 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.0021  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 = 75630 WHERE rp.league_id = 75630 AND rp.teamId = 149940 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 75630 WHERE rp.league_id = 75630 AND rp.teamId = 149940 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 149940 AND rp.league_id = 75630 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0020  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=6634917 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6634917
0.0022  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=6634917 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.0021  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=6634917 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0019  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=6634917 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0020   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=6634917 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0021  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=6634917 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC