4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Leça FC
TEMPORADA 1997/1998
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 75 38 77
2 Benfica Benfica 34 62 29 68
3 Vitória Guimarães Vitória 34 42 25 59
4 Sporting CP Sporting CP 34 45 33 56
5 Marítimo Marítimo 34 44 35 56
6 Boavista Boavista 34 54 31 55
7 Estrela Amadora Estrela 34 42 41 50
8 SC Salgueiros Salgueiros 34 48 44 49
9 Rio Ave Rio Ave 34 43 43 46
10 Sporting Braga Sporting 34 48 49 45
11 Campomaiorense Campomaioren 34 53 58 40
12 Leça FC Leça FC 34 29 52 38
13 Vitória Setúbal Vitória 34 38 43 37
14 Farense Farense 34 41 50 37
15 Académica Académica 34 27 41 36
16 Chaves Chaves 34 31 55 35
17 Varzim Varzim 34 26 51 29
18 Os Belenenses Belenenses 34 22 52 24
TEMPORADA 1996/1997
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 80 24 85
2 Sporting CP Sporting CP 34 55 19 72
3 Benfica Benfica 34 49 30 58
4 Sporting Braga Sporting 34 39 40 55
5 Vitória Guimarães Vitória 34 51 46 53
6 SC Salgueiros Salgueiros 34 49 48 52
7 Boavista Boavista 34 62 39 49
8 Marítimo Marítimo 34 39 38 47
9 Estrela Amadora Estrela 34 39 38 47
10 Chaves Chaves 34 39 45 46
11 Farense Farense 34 34 34 42
12 Vitória Setúbal Vitória 34 38 42 40
13 Os Belenenses Belenenses 34 37 50 40
14 Leça FC Leça FC 34 33 42 36
15 Rio Ave Rio Ave 34 35 42 35
16 Espinho Espinho 34 27 56 33
17 União de Leiria União 34 25 53 30
18 Gil Vicente Gil Vicente 34 29 74 19
TEMPORADA 1995/1996
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 84 20 84
2 Benfica Benfica 34 58 27 73
3 Sporting CP Sporting CP 34 69 27 67
4 Boavista Boavista 34 58 28 65
5 Vitória Guimarães Vitória 34 55 39 62
6 Os Belenenses Belenenses 34 53 33 51
7 União de Leiria União 34 38 50 47
8 Sporting Braga Sporting 34 44 47 45
9 Marítimo Marítimo 34 39 53 43
10 SC Salgueiros Salgueiros 34 39 49 36
11 Gil Vicente Gil Vicente 34 31 49 36
12 Farense Farense 34 36 45 36
13 Estrela Amadora Estrela 34 35 50 35
14 Leça FC Leça FC 34 29 55 34
15 Chaves Chaves 34 38 56 34
16 FC Felgueiras Felgueiras 34 29 47 33
17 Campomaiorense Campomaioren 34 32 69 33
18 Tirsense Tirsense 34 30 53 31
TEMPORADA 1941/1942
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 22 74 34 38
2 Sporting CP Sporting CP 22 93 31 34
3 Os Belenenses Belenenses 22 66 32 30
4 Porto Porto 22 77 48 28
5 Académica Académica 22 77 51 26
6 FC Barreirense Barreirense 22 58 55 25
7 Os Unidos CF Unidos 22 53 49 18
8 Olhanense Olhanense 22 42 83 14
9 Carcavelinhos Carcavelinho 22 35 73 14
10 Academico do Porto Academico 22 48 81 13
11 Vitória Guimarães Vitória 22 43 76 13
12 Leça FC Leça FC 22 29 82 11

  USO DE MEMORIA  
5,374,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0822
Total Execution Time  0.0834
  CADENA URL  
/historico/Leca
  GET DATOS  
$_GET['/historico/Leca']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0043  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 = 219
0.0026  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 = 22911
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7059 AND type_rel = 2
0.0027  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 = '7059' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = '7059' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 219 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 22911 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=7059 AND l.year in (1997,1998,1999) 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 (22911,616,220) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 220 AND teamId = 7059
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 616 AND teamId = 7059
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 22911 AND teamId = 7059
0.0022  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 = '7059' 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 = '7059' and rp.type = 4
0.0022  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 = '7059' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0041  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 events1998 e ON e.player_id = p.id AND e.league_id = 219 WHERE rp.league_id = 219 AND rp.teamId = 7059 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.0039  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 events1998 e ON e.player_id = p.id AND e.league_id = 219 WHERE rp.league_id = 219 AND rp.teamId = 7059 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 events1998 e ON e.player_id = p.id AND e.league_id = 219 WHERE rp.league_id = 219 AND rp.teamId = 7059 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 7059 AND l.year <= 1998 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 `tables1998` 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 = 219 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables1997` 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 = 220 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1996` 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 = 221 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC