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

Arouca

Entrenador: Daniel Sousa

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 31 89 29 81
2 Benfica Benfica 31 71 25 76
3 Porto Porto 31 57 26 63
4 Sporting Braga Sporting 31 64 44 62
5 Vitória Guimarães Vitória 31 46 32 60
6 Moreirense Moreirense 31 32 34 46
7 Arouca Arouca 31 53 42 45
8 Famalicão Famalicão 31 33 39 36
9 Casa Pia AC Casa Pia AC 31 33 44 35
10 Farense Farense 31 42 44 34
11 Estoril Estoril 31 46 52 33
12 Rio Ave Rio Ave 31 33 39 32
13 Gil Vicente Gil Vicente 31 39 50 32
14 Boavista Boavista 31 35 57 30
15 Estrela da Amadora Estrela 31 32 49 29
16 Portimonense Portimonense 31 34 66 28
17 Chaves Chaves 31 31 65 23
18 Vizela Vizela 31 30 63 22
TEMPORADA 2022/2023
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 82 20 87
2 Porto Porto 34 73 22 85
3 Sporting Braga Sporting 34 75 30 78
4 Sporting CP Sporting CP 34 71 32 74
5 Arouca Arouca 34 36 37 54
6 Vitória Guimarães Vitória 34 34 39 53
7 Chaves Chaves 34 35 40 46
8 Famalicão Famalicão 34 39 47 44
9 Boavista Boavista 34 43 54 44
10 Casa Pia AC Casa Pia AC 34 31 40 41
11 Vizela Vizela 34 34 38 40
12 Rio Ave Rio Ave 34 36 43 40
13 Gil Vicente Gil Vicente 34 32 41 37
14 Estoril Estoril 34 33 49 35
15 Portimonense Portimonense 34 25 48 34
16 Marítimo Marítimo 34 32 63 26
17 Paços de Ferreira Paços 34 26 62 23
18 CD Santa Clara Santa Clara 34 26 58 22
TEMPORADA 2021/2022
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Porto Porto 34 86 22 91
2 Sporting CP Sporting CP 34 73 23 85
3 Benfica Benfica 34 78 30 74
4 Sporting Braga Sporting 34 52 31 65
5 Gil Vicente Gil Vicente 34 47 42 51
6 Vitória Guimarães Vitória 34 50 41 48
7 CD Santa Clara Santa Clara 34 38 54 40
8 Famalicão Famalicão 34 45 51 39
9 Estoril Estoril 34 36 43 39
10 Marítimo Marítimo 34 39 44 38
11 Paços de Ferreira Paços 34 29 44 38
12 Boavista Boavista 34 39 52 38
13 Portimonense Portimonense 34 31 45 38
14 Vizela Vizela 34 37 58 33
15 Arouca Arouca 34 30 54 31
16 Moreirense Moreirense 34 33 51 29
17 Tondela Tondela 34 41 67 28
18 Belenenses SAD Belenenses 34 23 55 26
TEMPORADA 2020/2021
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Estoril Estoril 34 55 26 70
2 Vizela Vizela 34 59 35 66
3 Arouca Arouca 34 45 25 65
4 Académica Académica 34 46 30 62
5 Feirense Feirense 34 48 33 58
6 Chaves Chaves 34 46 36 57
7 Penafiel Penafiel 34 42 42 46
8 Benfica II Benfica II 34 52 43 44
9 Casa Pia AC Casa Pia AC 34 41 46 43
10 Leixões Leixões 34 35 43 40
11 Cova Piedade Cova Piedade 34 39 48 37
12 Mafra Mafra 34 35 48 37
13 SC Covilha SC Covilha 34 36 42 37
14 Academico Viseu Academico 34 32 45 36
15 Varzim Varzim 34 26 44 33
16 Porto II Porto II 34 45 52 32
17 Vilafranquense Vilafranquen 34 34 54 31
18 UD Oliveirense Oliveirense 34 25 49 31
TEMPORADA 2019/2020
CAMPEONATO DE PORTUGAL GRUPO 2
Equipo PJ GF GC Puntos
1 Arouca Arouca 25 49 19 58
2 Lusitania FC Lusitania 25 43 18 50
3 Espinho Espinho 25 44 17 48
4 Leça FC Leça FC 25 41 27 46
5 Castro Daire Castro Daire 25 32 22 44
6 AD Sanjoanense Sanjoanense 25 36 30 42
7 Felgueiras 1932 Felgueiras 25 51 37 41
8 USC Paredes USC Paredes 25 26 19 34
9 Canelas 2010 Canelas 2010 25 23 19 33
10 Amarante Amarante 25 31 29 33
11 Trofense Trofense 25 24 30 30
12 Coimbrões Coimbrões 25 29 41 30
13 Pedras Rubras Pedras 25 28 32 28
14 Gondomar Gondomar 25 28 33 27
15 Lusitano FCV Lusitano 25 29 36 25
16 Valadares Gaia Valadares 25 28 47 25
17 Vila Real Vila Real 25 20 47 15
18 Ginásio Figueirense Ginásio 25 11 70 9
TEMPORADA 2018/2019
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Paços de Ferreira Paços 34 50 21 74
2 Famalicão Famalicão 34 57 34 69
3 Estoril Estoril 34 49 42 54
4 Benfica II Benfica II 34 47 42 52
5 Académica Académica 34 36 37 51
6 SC Covilha SC Covilha 34 42 37 49
7 Penafiel Penafiel 34 49 48 45
8 Leixões Leixões 34 35 36 45
9 Porto II Porto II 34 41 42 44
10 Farense Farense 34 39 35 43
11 Academico Viseu Academico 34 49 54 43
12 UD Oliveirense Oliveirense 34 44 49 43
13 Cova Piedade Cova Piedade 34 25 42 42
14 Mafra Mafra 34 40 44 41
15 Varzim Varzim 34 25 37 41
16 Arouca Arouca 34 40 45 40
17 Sporting Braga II Sporting 34 38 45 37
18 Vitória SC B Vitória 34 41 57 31
TEMPORADA 2017/2018
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Nacional Nacional 38 72 45 71
2 CD Santa Clara Santa Clara 38 55 40 66
3 Academico Viseu Academico 38 50 40 64
4 Académica Académica 38 59 40 63
5 Penafiel Penafiel 38 55 43 62
6 Arouca Arouca 38 42 37 59
7 Porto II Porto II 38 50 55 58
8 Leixões Leixões 38 50 43 56
9 Cova Piedade Cova Piedade 38 42 45 51
10 Varzim Varzim 38 41 41 50
11 Vitória SC B Vitória 38 44 49 50
12 UD Oliveirense Oliveirense 38 45 47 49
13 Benfica II Benfica II 38 54 60 49
14 Famalicão Famalicão 38 46 49 48
15 SC Covilha SC Covilha 38 32 41 47
16 Sporting Braga II Sporting 38 44 48 44
17 União Madeira União 38 44 53 44
18 Sporting CP II Sporting 38 46 65 42
19 Gil Vicente Gil Vicente 38 29 45 36
20 Real Sport Clube Real Sport. 38 47 61 32
TEMPORADA 2016/2017
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 72 18 82
2 Porto Porto 34 71 19 76
3 Sporting CP Sporting CP 34 68 36 70
4 Vitória Guimarães Vitória 34 50 39 62
5 Sporting Braga Sporting 34 51 36 54
6 Marítimo Marítimo 34 34 32 50
7 Rio Ave Rio Ave 34 41 39 49
8 Feirense Feirense 34 31 45 48
9 Boavista Boavista 34 33 36 43
10 Estoril Estoril 34 36 42 38
11 Chaves Chaves 34 35 42 38
12 Vitória Setúbal Vitória 34 30 39 38
13 Paços de Ferreira Paços 34 32 45 36
14 Os Belenenses Belenenses 34 27 45 36
15 Moreirense Moreirense 34 33 48 33
16 Tondela Tondela 34 29 52 32
17 Arouca Arouca 34 33 57 32
18 Nacional Nacional 34 22 58 21
TEMPORADA 2015/2016
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 88 22 88
2 Sporting CP Sporting CP 34 79 21 86
3 Porto Porto 34 67 30 73
4 Sporting Braga Sporting 34 54 35 58
5 Arouca Arouca 34 47 38 54
6 Rio Ave Rio Ave 34 44 44 50
7 Paços de Ferreira Paços 34 43 42 49
8 Estoril Estoril 34 40 41 47
9 Os Belenenses Belenenses 34 44 66 41
10 Vitória Guimarães Vitória 34 45 53 40
11 Nacional Nacional 34 40 56 38
12 Moreirense Moreirense 34 38 54 36
13 Marítimo Marítimo 34 45 63 35
14 Boavista Boavista 34 24 41 33
15 Tondela Tondela 34 34 54 30
16 Vitória Setúbal Vitória 34 40 61 30
17 União Madeira União 34 27 50 29
18 Académica Académica 34 32 60 25
TEMPORADA 2014/2015
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 86 16 85
2 Porto Porto 34 74 13 82
3 Sporting CP Sporting CP 34 67 29 76
4 Sporting Braga Sporting 34 55 28 58
5 Vitória Guimarães Vitória 34 50 35 55
6 Os Belenenses Belenenses 34 34 35 48
7 Nacional Nacional 34 45 46 47
8 Paços de Ferreira Paços 34 40 45 47
9 Marítimo Marítimo 34 46 45 44
10 Rio Ave Rio Ave 34 38 42 43
11 Moreirense Moreirense 34 33 42 43
12 Estoril Estoril 34 38 56 40
13 Boavista Boavista 34 27 50 34
14 Académica Académica 34 26 46 29
15 Vitória Setúbal Vitória 34 24 56 29
16 Arouca Arouca 34 26 50 28
17 Gil Vicente Gil Vicente 34 25 60 23
18 Penafiel Penafiel 34 29 69 22
TEMPORADA 2013/2014
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 30 58 18 74
2 Sporting CP Sporting CP 30 54 20 67
3 Porto Porto 30 57 25 61
4 Estoril Estoril 30 42 26 54
5 Nacional Nacional 30 43 33 45
6 Marítimo Marítimo 30 40 44 41
7 Vitória Setúbal Vitória 30 41 41 39
8 Sporting Braga Sporting 30 39 37 37
9 Académica Académica 30 25 35 37
10 Vitória Guimarães Vitória 30 30 35 35
11 Rio Ave Rio Ave 30 21 35 32
12 Arouca Arouca 30 28 42 31
13 Gil Vicente Gil Vicente 30 23 37 31
14 Os Belenenses Belenenses 30 19 33 28
15 Olhanense Olhanense 30 21 49 24
16 Paços de Ferreira Paços 30 28 59 24
TEMPORADA 2012/2013
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Os Belenenses Belenenses 42 75 41 94
2 Arouca Arouca 42 65 48 73
3 Leixões Leixões 42 49 36 68
4 Sporting CP II Sporting 42 62 47 66
5 Desportivo Aves Desportivo 42 47 42 65
6 Portimonense Portimonense 42 61 50 64
7 Benfica II Benfica II 42 71 54 62
8 Penafiel Penafiel 42 48 44 60
9 UD Oliveirense Oliveirense 42 52 49 60
10 CD Santa Clara Santa Clara 42 55 48 59
11 Tondela Tondela 42 55 60 59
12 Naval Naval 42 51 50 57
13 Feirense Feirense 42 61 59 56
14 União Madeira União 42 47 46 56
15 Porto II Porto II 42 49 49 54
16 Marítimo II Marítimo 42 40 46 49
17 Sporting Braga II Sporting 42 39 51 49
18 Atlético CP Atlético 42 45 63 44
19 Trofense Trofense 42 41 60 40
20 SC Covilha SC Covilha 42 37 52 38
21 Vitória SC B Vitória 42 30 56 36
22 SC Freamunde Freamunde 42 46 75 33
TEMPORADA 2011/2012
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Estoril Estoril 30 40 20 57
2 Moreirense Moreirense 30 47 32 52
3 Desportivo Aves Desportivo 30 38 23 50
4 Naval Naval 30 40 33 46
5 Os Belenenses Belenenses 30 34 32 41
6 Leixões Leixões 30 32 34 40
7 UD Oliveirense Oliveirense 30 39 38 39
8 Trofense Trofense 30 36 45 39
9 Penafiel Penafiel 30 33 36 38
10 União Madeira União 30 35 40 37
11 Atlético CP Atlético 30 27 36 37
12 Arouca Arouca 30 32 36 34
13 SC Freamunde Freamunde 30 35 40 34
14 CD Santa Clara Santa Clara 30 29 38 34
15 Portimonense Portimonense 30 35 42 32
16 SC Covilha SC Covilha 30 22 29 32
TEMPORADA 2010/2011
SEGUNDA LIGA
Equipo PJ GF GC Puntos
1 Feirense Feirense 30 41 31 55
2 Trofense Trofense 30 41 27 54
3 Gil Vicente Gil Vicente 30 51 37 53
4 UD Oliveirense Oliveirense 30 36 35 45
5 Arouca Arouca 30 47 41 43
6 Leixões Leixões 30 35 27 42
7 Desportivo Aves Desportivo 30 35 31 40
8 Moreirense Moreirense 30 36 41 40
9 Estoril Estoril 30 36 31 38
10 CD Santa Clara Santa Clara 30 26 28 38
11 SC Freamunde Freamunde 30 37 39 37
12 Penafiel Penafiel 30 36 44 36
13 Os Belenenses Belenenses 30 33 36 35
14 Varzim Varzim 30 37 44 32
15 SC Covilha SC Covilha 30 32 48 32
16 Fatima Fatima 30 29 48 23

  USO DE MEMORIA  
7,729,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1354
Total Execution Time  0.1366
  CADENA URL  
/historico/Arouca
  GET DATOS  
$_GET['/historico/Arouca']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0031  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 = 'Arouca' 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.0019  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=4641 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=4641 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=4641 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=4641 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=4641 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=4641 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=4641 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 74074
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 = 71432
0.0030  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 = '4641' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '4641' 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,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 = 72102 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 74074 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=4641 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 (74074,73560,72505,72102,72053,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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 72053 AND teamId = 4641
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 73560 AND teamId = 4641
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 72505 AND teamId = 4641
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 74074 AND teamId = 4641
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72102 AND teamId = 4641
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4641
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 events2024 e ON e.player_id = p.id AND e.league_id = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 4641 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 = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 4641 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 4641 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 4641 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 67687 AND t.round = 34 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 `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 = 62752 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 58600 AND t.round = 34 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 `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 = 50951 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.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 `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 = 43587 AND t.round = 34 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 `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 = 38673 AND t.round = 38 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 = 31005 AND t.round = 34 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 `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 = 3797 AND t.round = 34 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 `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 = 2503 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 `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 = 1932 AND t.round = 42 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 `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 = 1617 AND t.round = 30 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 `tables2011` 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 = 1111 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC