4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fafe

Fafe

Entrenador: Luís Pinto

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA 3 GRUPO 4
Equipo PJ GF GC Puntos
1 Fafe Fafe 10 20 11 26
2 Trofense Trofense 10 16 11 20
3 AD Sanjoanense Sanjoanense 10 13 11 18
4 Anadia Anadia 10 6 10 15
5 Canelas 2010 Canelas 2010 10 8 15 13
6 Vianense Vianense 10 6 11 10
7 Sporting CP II Sporting 10 19 5 26
8 Caldas Caldas 10 14 13 22
9 Oliveira Hospital Oliveira 10 14 12 18
10 1º Dezembro Dezembro 10 10 9 17
11 Amora FC Amora FC 10 11 17 16
12 Pêro Pinheiro Pêro 10 8 20 8
TEMPORADA 2022/2023
LIGA 3 GRUPO 4
Equipo PJ GF GC Puntos
1 Varzim Varzim 6 6 6 16
2 Fafe Fafe 6 9 6 15
3 São João Ver São João 6 6 6 14
4 Montalegre Montalegre 6 5 8 8
5 Canelas 2010 Canelas 2010 6 11 6 21
6 Anadia Anadia 6 10 10 11
7 USC Paredes USC Paredes 6 6 7 11
8 Vitória SC B Vitória 6 4 8 4
9 Sporting CP II Sporting 6 8 8 16
10 Vitória Setúbal Vitória 6 7 6 15
11 Oliveira Hospital Oliveira 6 8 8 15
12 Real Sport Clube Real Sport. 6 6 7 8
13 Académica Académica 6 8 3 18
14 Caldas Caldas 6 9 8 14
15 Fontinhas Fontinhas 6 6 8 11
16 Moncarapachense Moncarapache 6 3 7 6
TEMPORADA 2021/2022
LIGA 3 GRUPO 3
Equipo PJ GF GC Puntos
1 Fafe Fafe 6 8 5 13
2 Anadia Anadia 6 7 4 13
3 Canelas 2010 Canelas 2010 6 3 7 13
4 Lusitania FC Lusitania 6 2 4 12
5 AD Sanjoanense Sanjoanense 6 11 5 18
6 São João Ver São João 6 8 7 15
7 Montalegre Montalegre 6 11 14 9
8 Pevidém Pevidém 6 7 11 6
9 Amora FC Amora FC 6 7 7 15
10 Cova Piedade Cova Piedade 6 7 5 13
11 Caldas Caldas 6 8 10 12
12 União Santarém União 6 9 9 11
13 Oliveira Hospital Oliveira 6 7 3 17
14 Real Sport Clube Real Sport. 6 4 3 16
15 Sporting CP II Sporting 6 6 8 10
16 Oriental Dragon Oriental 6 4 7 4
TEMPORADA 2020/2021
CAMPEONATO DE PORTUGAL GRUPO 10
Equipo PJ GF GC Puntos
1 Montalegre Montalegre 6 6 5 10
2 Felgueiras 1932 Felgueiras 6 6 5 9
3 Merelinense Merelinense 6 5 5 7
4 AR São Martinho São 6 6 8 7
5 Vitória SC B Vitória 6 13 6 13
6 Fafe Fafe 6 6 5 9
7 Maria da Fonte Maria Fonte 6 6 9 7
8 Mirandela Mirandela 6 5 10 4
9 São João Ver São João 6 4 2 10
10 Leça FC Leça FC 6 6 4 9
11 AD Sanjoanense Sanjoanense 6 4 6 7
12 Gondomar Gondomar 6 4 6 5
13 Canelas 2010 Canelas 2010 6 10 7 11
14 Lusitania FC Lusitania 6 5 2 10
15 Marítimo II Marítimo 6 7 10 6
16 Amarante Amarante 6 4 7 5
17 Oliveira Hospital Oliveira 6 7 6 8
18 Caldas Caldas 6 7 7 8
19 Loures Loures 6 4 4 7
20 Benfica Castelo Branco Benfica 6 7 8 6
21 FC Alverca FC Alverca 6 12 4 12
22 União Santarém União 6 8 6 9
23 Condeixa Condeixa 6 7 9 5
24 Marinhense Marinhense 6 4 12 5
25 Sporting CP II Sporting 6 10 7 11
26 Oriental Dragon Oriental 6 7 4 11
27 Louletano Louletano 6 7 8 6
28 Moncarapachense Moncarapache 6 4 9 5
29 Amora FC Amora FC 6 11 6 12
30 Real Sport Clube Real Sport. 6 6 7 8
31 Olhanense Olhanense 6 2 4 7
32 Praiense Praiense 6 4 6 5
TEMPORADA 2019/2020
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Vizela Vizela 25 64 20 60
2 Fafe Fafe 25 34 18 52
3 Vitória SC B Vitória 25 52 28 48
4 Sporting Braga II Sporting 25 48 25 46
5 AR São Martinho São 24 43 25 43
6 Merelinense Merelinense 25 42 31 43
7 Maria da Fonte Maria Fonte 25 45 29 40
8 Marítimo II Marítimo 25 46 37 39
9 Montalegre Montalegre 25 39 32 37
10 Chaves II Chaves II 25 44 39 31
11 Mirandela Mirandela 25 26 33 30
12 União Madeira União 25 35 52 30
13 Berco Berco 23 34 35 29
14 Pedras Salgadas Pedras 25 25 43 26
15 Cerveira Cerveira 24 24 56 20
16 Braganca Braganca 25 24 36 17
17 Oliveirense Oliveirense 25 21 43 16
18 Câmara de Lobos Câmara 25 15 79 8
TEMPORADA 2018/2019
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Vizela Vizela 34 73 14 76
2 Fafe Fafe 34 62 27 73
3 AR São Martinho São 34 56 24 72
4 Gil Vicente Gil Vicente 34 65 30 70
5 Trofense Trofense 34 64 29 70
6 Felgueiras 1932 Felgueiras 34 57 35 67
7 Mirandela Mirandela 34 51 43 52
8 Chaves II Chaves II 34 57 48 48
9 Merelinense Merelinense 34 38 38 44
10 Montalegre Montalegre 34 41 54 43
11 Maria da Fonte Maria Fonte 34 45 54 40
12 Pedras Salgadas Pedras 34 43 58 39
13 Oliveirense Oliveirense 34 40 58 37
14 Os Limianos Os Limianos 34 31 52 37
15 Torcatense Torcatense 34 30 63 29
16 Desportivo Mirandês Desportivo 34 26 58 21
17 Caçadores das Taipas Caçadores 34 28 67 21
18 Länk Vilaverdense Länk 34 30 85 15
TEMPORADA 2017/2018
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Vizela Vizela 30 53 11 73
2 Länk Vilaverdense Länk 30 65 29 64
3 Fafe Fafe 30 42 19 60
4 Mirandela Mirandela 30 42 26 57
5 Merelinense Merelinense 30 60 29 53
6 AR São Martinho São 30 46 31 49
7 Oliveirense Oliveirense 30 41 27 44
8 Montalegre Montalegre 30 39 38 38
9 Pedras Salgadas Pedras 30 32 35 38
10 Torcatense Torcatense 30 28 36 38
11 Braganca Braganca 30 31 43 33
12 Câmara de Lobos Câmara 30 27 54 30
13 Atlético Arcos Atlético 30 28 55 26
14 Arões Arões 30 25 41 24
15 Mondinense Mondinense 30 27 68 23
16 Minas de Argozelo Minas 30 24 68 11
TEMPORADA 2016/2017
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Portimonense Portimonense 42 70 39 83
2 Desportivo Aves Desportivo 42 62 38 81
3 União Madeira União 42 52 43 64
4 Benfica II Benfica II 42 56 58 63
5 Penafiel Penafiel 42 56 55 63
6 Académica Académica 42 42 35 62
7 Sporting Braga II Sporting 42 64 50 62
8 SC Covilha SC Covilha 42 51 41 62
9 Varzim Varzim 42 45 48 61
10 CD Santa Clara Santa Clara 42 44 42 60
11 Vitória SC B Vitória 42 54 50 60
12 Porto II Porto II 42 52 49 60
13 Gil Vicente Gil Vicente 42 47 49 56
14 Sporting CP II Sporting 42 64 62 55
15 Famalicão Famalicão 42 47 50 53
16 Cova Piedade Cova Piedade 42 45 59 53
17 Academico Viseu Academico 42 49 54 52
18 Leixões Leixões 42 44 48 46
19 Vizela Vizela 42 39 49 46
20 Fafe Fafe 42 52 65 45
21 SC Freamunde Freamunde 42 39 52 40
22 Olhanense Olhanense 42 45 83 28
TEMPORADA 2015/2016
CAMPEONATO DE PORTUGAL GRUPO 2
Equipo PJ GF GC Puntos
1 Fafe Fafe 18 35 15 38
2 Vizela Vizela 18 24 13 35
3 Oliveirense Oliveirense 18 25 15 31
4 Trofense Trofense 18 24 22 26
5 Felgueiras 1932 Felgueiras 18 15 18 25
6 AR São Martinho São 18 22 19 23
7 Torcatense Torcatense 18 17 28 20
8 Arões Arões 18 16 23 18
9 Mondinense Mondinense 18 22 32 17
10 Varzim B Varzim B 18 20 35 14
TEMPORADA 2014/2015
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Fafe Fafe 18 28 10 37
2 Mirandela Mirandela 18 23 12 35
3 Länk Vilaverdense Länk 18 17 15 29
4 Pedras Salgadas Pedras 18 22 14 25
5 Braganca Braganca 18 19 17 25
6 Cerveira Cerveira 18 20 27 23
7 Vianense Vianense 18 24 27 21
8 Santa Maria Santa Maria 18 17 19 19
9 Os Limianos Os Limianos 18 12 24 14
10 Vieira Sport Clube Vieira Sport 18 10 27 10
TEMPORADA 2013/2014
CAMPEONATO DE PORTUGAL GRUPO 1
Equipo PJ GF GC Puntos
1 Os Limianos Os Limianos 18 27 16 34
2 Fafe Fafe 18 21 9 33
3 Braganca Braganca 18 24 17 33
4 Mirandela Mirandela 18 21 13 29
5 Vianense Vianense 18 15 12 26
6 Santa Maria Santa Maria 18 17 21 22
7 Länk Vilaverdense Länk 18 12 15 21
8 SC Valenciano Valenciano 18 16 22 21
9 Pedras Salgadas Pedras 18 17 27 15
10 Ninense Ninense 18 11 29 8
TEMPORADA 2012/2013
CAMPEONATO DE PORTUGAL GRUPO 2
Equipo PJ GF GC Puntos
1 Chaves Chaves 30 43 21 58
2 Ribeirão Ribeirão 30 43 24 55
3 Mirandela Mirandela 30 41 29 53
4 Vizela Vizela 30 41 29 51
5 Tirsense Tirsense 30 35 32 45
6 Os Limianos Os Limianos 30 33 30 45
7 Famalicão Famalicão 30 42 35 43
8 Varzim Varzim 30 31 26 40
9 Fafe Fafe 30 37 33 40
10 Boavista Boavista 30 44 40 38
11 Gondomar Gondomar 30 25 27 33
12 Amarante Amarante 30 30 33 33
13 Länk Vilaverdense Länk 30 22 36 33
14 Joane Joane 30 27 48 28
15 Infesta Infesta 30 30 51 25
16 Padroense Padroense 30 23 53 21
TEMPORADA 2011/2012
CAMPEONATO DE PORTUGAL GRUPO 2
Equipo PJ GF GC Puntos
1 Varzim Varzim 30 48 12 68
2 Fafe Fafe 30 46 29 54
3 Chaves Chaves 30 41 26 54
4 Mirandela Mirandela 30 55 32 52
5 Tirsense Tirsense 30 39 29 44
6 Os Limianos Os Limianos 30 34 25 44
7 Ribeirão Ribeirão 30 39 31 44
8 Ribeira Brava Ribeira 30 33 37 42
9 Famalicão Famalicão 30 29 32 39
10 Macedo Cavaleiros Macedo 30 43 48 39
11 Vizela Vizela 30 40 42 38
12 Marítimo II Marítimo 30 41 45 38
13 Camacha Camacha 30 29 36 34
14 Lousada Lousada 30 30 45 32
15 Merelinense Merelinense 30 33 68 16
16 Oliveirense Oliveirense 30 14 57 10
TEMPORADA 1988/1989
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 38 60 15 63
2 Porto Porto 38 52 17 56
3 Boavista Boavista 38 56 29 49
4 Sporting CP Sporting CP 38 50 33 45
5 Vitória Setúbal Vitória 38 44 37 42
6 Os Belenenses Belenenses 38 44 35 40
7 Sporting Braga Sporting 38 42 37 40
8 Estrela Amadora Estrela 38 33 41 39
9 Vitória Guimarães Vitória 38 39 33 38
10 Nacional Nacional 38 43 49 36
11 Portimonense Portimonense 38 33 37 35
12 Marítimo Marítimo 38 40 41 35
13 Chaves Chaves 38 37 41 34
14 Penafiel Penafiel 38 32 39 33
15 Beira Mar SC Beira 38 29 36 33
16 Fafe Fafe 38 29 47 32
17 Espinho Espinho 38 45 57 32
18 Farense Farense 38 34 51 31
19 Leixões Leixões 38 29 46 28
20 Academico Viseu Academico 38 20 70 19

  USO DE MEMORIA  
6,925,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1528
Total Execution Time  0.1540
  CADENA URL  
/historico/Fafe
  GET DATOS  
$_GET['/historico/Fafe']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0033  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 = 'Fafe' 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.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=7011 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=7011 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=7011 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=7011 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=7011 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 75232
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7011 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7011 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (92102,238473,238688) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '7011' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '7011' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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=7011 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (75232,73560,71432) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 75232 AND teamId = 7011
0.0043  SELECT count(id) as num_players from rel_players WHERE league_id = 73560 AND teamId = 7011
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7011
0.0024  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 = '7011' 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 = '7011' 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 = '7011' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  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 = 72839 WHERE rp.league_id = 72839 AND rp.teamId = 7011 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.0037  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 = 72839 WHERE rp.league_id = 72839 AND rp.teamId = 7011 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 72839 WHERE rp.league_id = 72839 AND rp.teamId = 7011 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 7011 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72839 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.0029  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 = 75232 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 68264 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.0026  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 = 71411 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.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 `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 = 63379 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.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 = 66939 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.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 `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 = 58699 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.0029  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 = 62231 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 `tables2020` 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 = 50950 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2019` 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 = 44596 AND t.round = 34 ORDER BY team.conference 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 `tables2018` 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 = 39611 AND t.round = 30 ORDER BY team.conference 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 `tables2017` 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 = 31022 AND t.round = 42 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 `tables2016` 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 = 16753 AND t.round = 18 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 `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 = 4337 AND t.round = 18 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 `tables2014` 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 = 2757 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 2171 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2012` 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 = 1701 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables1989` 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 = 5756 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC