4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rabo Peixe
TEMPORADA 2023/2024
CAMPEONATO DE PORTUGAL GRUPO 3
Equipo PJ GF GC Puntos
1 União Santarém União 26 52 23 55
2 Lusitânia Lusitânia 26 40 22 51
3 Marinhense Marinhense 26 43 26 50
4 Alverca II Alverca II 26 34 19 39
5 União de Coimbra União 26 30 26 38
6 Benfica Castelo Branco Benfica 26 34 29 37
7 Sertanense Sertanense 26 26 25 37
8 Mortágua Mortágua 26 30 36 37
9 Peniche Peniche 26 28 39 37
10 Fontinhas Fontinhas 26 23 32 32
11 Rabo Peixe Rabo Peixe 26 30 34 30
12 Vitoria de Sernache Vitoria 26 17 30 25
13 Gouveia Gouveia 26 35 48 21
14 Uniao Tomar Uniao Tomar 26 20 53 17
TEMPORADA 2022/2023
CAMPEONATO DE PORTUGAL GRUPO 4
Equipo PJ GF GC Puntos
1 Atlético CP Atlético 26 43 22 52
2 Lusitano Évora 1911 Lusitano 26 35 22 51
3 Juventude Évora Juventude 26 37 16 46
4 Rabo Peixe Rabo Peixe 26 33 19 45
5 Imortal DC Imortal DC 26 31 22 39
6 Fabril Barreiro Fabril 26 31 26 39
7 Vasco da Gama Vasco Gama 26 37 33 39
8 Serpa Serpa 26 44 36 36
9 Oriental Dragon Oriental 26 35 36 36
10 Praiense Praiense 26 31 32 34
11 Esperança de Lagos Esperança 26 28 38 31
12 Angrense Angrense 26 17 46 17
13 Olhanense Olhanense 26 18 50 17
14 Ferreiras Ferreiras 26 17 39 16
TEMPORADA 2021/2022
CAMPEONATO DE PORTUGAL GRUPO 8
Equipo PJ GF GC Puntos
1 Vianense Vianense 6 9 4 13
2 Merelinense Merelinense 6 9 9 10
3 Os Limianos Os Limianos 6 7 8 6
4 Forjães Forjães 6 6 10 4
5 Pedras Salgadas Pedras 6 5 2 10
6 Maria da Fonte Maria Fonte 6 5 5 8
7 Mirandela Mirandela 6 2 3 6
8 Macedo Cavaleiros Macedo 6 4 6 6
9 Amarante Amarante 6 15 5 13
10 Tirsense Tirsense 6 7 7 9
11 Vila Real Vila Real 6 5 10 7
12 Berco Berco 6 8 13 4
13 Camacha Camacha 6 10 4 12
14 Vila Meã Vila Meã 6 5 5 7
15 Santa Marta Penaguião Santa Marta 6 4 6 6
16 Câmara de Lobos Câmara 6 7 11 5
17 Valadares Gaia Valadares 6 10 2 16
18 Espinho Espinho 6 5 5 8
19 Gondomar Gondomar 6 7 10 8
20 Santa Cruz de Alvarenga Santa Cruz. 6 6 11 1
21 Castro Daire Castro Daire 6 8 1 11
22 Ferreira de Aves Ferreira 6 7 7 11
23 União de Coimbra União 6 6 4 10
24 Gouveia Gouveia 6 2 11 0
25 Benfica Castelo Branco Benfica 6 14 7 14
26 Oleiros Oleiros 6 7 5 11
27 União Idanhense União 6 4 8 4
28 Condeixa Condeixa 6 6 11 3
29 Marinhense Marinhense 6 6 2 12
30 Coruchense Coruchense 6 8 5 10
31 Vitoria de Sernache Vitoria 6 7 5 8
32 Peniche Peniche 6 2 11 2
33 Sintrense Sintrense 6 10 4 13
34 Loures Loures 6 7 4 13
35 Sacavenense Sacavenense 6 10 8 9
36 O Elvas O Elvas 6 3 14 0
37 Praiense Praiense 6 12 6 12
38 Rabo Peixe Rabo Peixe 6 11 5 9
39 Operário Operário 6 8 7 8
40 Ideal Ideal 6 4 17 3
41 Juventude Évora Juventude 6 10 3 15
42 Serpa Serpa 6 10 6 10
43 FC Barreirense Barreirense 6 7 7 8
44 União Montemor União 6 3 14 1
45 Imortal DC Imortal DC 4 4 3 7
46 Esperança de Lagos Esperança 4 4 7 5
47 Louletano Louletano 4 7 5 4
TEMPORADA 2020/2021
CAMPEONATO DE PORTUGAL GRUPO 7
Equipo PJ GF GC Puntos
1 Estrela da Amadora Estrela 22 34 12 53
2 Sporting CP II Sporting 22 33 7 49
3 Oriental Dragon Oriental 22 30 20 37
4 Real Sport Clube Real Sport. 22 32 23 32
5 Fontinhas Fontinhas 22 30 26 32
6 Praiense Praiense 22 25 23 32
7 Rabo Peixe Rabo Peixe 22 17 25 27
8 Ideal Ideal 22 26 34 23
9 Os Belenenses Belenenses 22 16 26 22
10 Fabril Barreiro Fabril 22 19 31 21
11 Oriental Lisboa Oriental 22 16 27 16
12 Olímpico do Montijo Olímpico 22 19 43 16
TEMPORADA 2014/2015
2ª AF PONTA DELGADA
Equipo PJ GF GC Puntos
1 Rabo Peixe Rabo Peixe 10 22 12 22
2 GDCP Arrifes GDCP Arrifes 10 14 7 21
3 Vitoria Pico Pedra Vitoria Pico 10 16 10 19
4 São Roque (Açores) São Roque (. 10 17 18 11
5 Casa Povo Maia Casa Povo M. 10 14 20 7
6 FCD Santa Barbara Santa 10 3 19 4
TEMPORADA 2012/2013
III DIVISAO PORTUGAL GRUPO 2
Equipo PJ GF GC Puntos
1 Praiense Praiense 18 39 9 50
2 Angrense Angrense 18 49 13 40
3 Ideal Ideal 18 40 22 37
4 Rabo Peixe Rabo Peixe 18 31 19 32
5 Santiago Santiago 18 21 17 30
6 Fabril Barreiro Fabril 18 23 35 20
7 Prainha Prainha 18 23 29 18
8 Vitória do Pico Vitória 18 11 25 11
9 Marítimo Graciosa Marítimo 18 19 41 10
10 Flamengos Flamengos 18 15 61 6

  USO DE MEMORIA  
5,627,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1091
Total Execution Time  0.1103
  CADENA URL  
/historico/Rabo-Peixe
  GET DATOS  
$_GET['/historico/Rabo-Peixe']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0027  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Rabo-Peixe' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=11032 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=11032 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=11032 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 73486
0.0024  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 = 73560
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11032 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 11032 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019  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 (8291) ORDER BY n.cover_points DESC, update_date DESC
0.0026  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '11032' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '11032' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '11032' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73486 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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 = 73560 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=11032 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73560,73486) 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 = 73486 AND teamId = 11032
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 73560 AND teamId = 11032
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73486 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '11032' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11032' and rp.type = 4
0.0020  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 = '11032' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 73486 WHERE rp.league_id = 73486 AND rp.teamId = 11032 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.0033  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 = 73486 WHERE rp.league_id = 73486 AND rp.teamId = 11032 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 73486 WHERE rp.league_id = 73486 AND rp.teamId = 11032 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 11032 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73486 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68780 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63454 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 66953 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 58704 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 5862 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2173 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC