Ver
TEMPORADA 2021/2022
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
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 34 65 20 85
2 Porto Porto 34 74 29 80
3 Benfica Benfica 34 69 27 76
4 Sporting Braga Sporting 34 53 33 64
5 Paços de Ferreira Paços 34 40 41 53
6 CD Santa Clara Santa Clara 34 44 36 46
7 Vitória Guimarães Vitória 34 37 44 43
8 Moreirense Moreirense 34 37 43 43
9 Famalicão Famalicão 34 40 48 40
10 Belenenses SAD Belenenses 34 25 35 40
11 Gil Vicente Gil Vicente 34 33 42 39
12 Tondela Tondela 34 36 57 36
13 Boavista Boavista 34 39 49 36
14 Portimonense Portimonense 34 34 41 35
15 Marítimo Marítimo 34 27 47 35
16 Rio Ave Rio Ave 34 25 40 34
17 Farense Farense 34 31 48 31
18 Nacional Nacional 34 30 59 25
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Porto Porto 34 74 22 82
2 Benfica Benfica 34 71 26 77
3 Sporting Braga Sporting 34 61 40 60
4 Sporting CP Sporting CP 34 49 34 60
5 Rio Ave Rio Ave 34 48 36 55
6 Famalicão Famalicão 34 53 51 54
7 Vitória Guimarães Vitória 34 53 38 50
8 Moreirense Moreirense 34 42 44 43
9 CD Santa Clara Santa Clara 34 36 41 43
10 Gil Vicente Gil Vicente 34 40 44 43
11 Marítimo Marítimo 34 34 42 39
12 Boavista Boavista 34 28 39 39
13 Paços de Ferreira Paços 34 36 52 39
14 Tondela Tondela 34 30 44 36
15 Belenenses SAD Belenenses 34 27 54 35
16 Vitória Setúbal Vitória 34 27 43 34
17 Portimonense Portimonense 34 30 45 33
18 Desportivo Aves Desportivo 34 24 68 17
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 103 31 87
2 Porto Porto 34 74 20 85
3 Sporting CP Sporting CP 34 72 33 74
4 Sporting Braga Sporting 34 56 37 67
5 Vitória Guimarães Vitória 34 46 34 52
6 Moreirense Moreirense 34 39 44 52
7 Rio Ave Rio Ave 34 50 52 45
8 Boavista Boavista 34 34 40 44
9 Belenenses SAD Belenenses 34 42 51 43
10 CD Santa Clara Santa Clara 34 43 45 42
11 Portimonense Portimonense 34 44 59 39
12 Marítimo Marítimo 34 26 44 39
13 Vitória Setúbal Vitória 34 28 39 36
14 Desportivo Aves Desportivo 34 35 49 36
15 Tondela Tondela 34 40 54 35
16 Chaves Chaves 34 34 57 32
17 Nacional Nacional 34 33 73 28
18 Feirense Feirense 34 27 64 20
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Porto Porto 34 82 18 88
2 Benfica Benfica 34 80 22 81
3 Sporting CP Sporting CP 34 63 24 78
4 Sporting Braga Sporting 34 74 29 75
5 Rio Ave Rio Ave 34 40 42 51
6 Chaves Chaves 34 47 55 47
7 Marítimo Marítimo 34 36 49 47
8 Boavista Boavista 34 35 44 45
9 Vitória Guimarães Vitória 34 45 56 43
10 Portimonense Portimonense 34 52 60 38
11 Tondela Tondela 34 41 50 38
12 Os Belenenses Belenenses 34 33 46 37
13 Desportivo Aves Desportivo 34 36 51 34
14 Moreirense Moreirense 34 29 50 32
15 Vitória Setúbal Vitória 34 39 62 32
16 Feirense Feirense 34 32 48 31
17 Paços de Ferreira Paços 34 33 59 30
18 Estoril Estoril 34 29 61 30
Ver
TEMPORADA 2016/2017
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
Ver
TEMPORADA 2015/2016
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
Ver
TEMPORADA 2014/2015
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
Ver
TEMPORADA 2013/2014
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
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Porto Porto 30 70 14 78
2 Benfica Benfica 30 77 20 77
3 Paços de Ferreira Paços 30 42 29 54
4 Sporting Braga Sporting 30 60 44 52
5 Estoril Estoril 30 47 37 45
6 Rio Ave Rio Ave 30 35 42 42
7 Sporting CP Sporting CP 30 36 36 42
8 Nacional Nacional 30 45 51 40
9 Vitória Guimarães Vitória 30 36 47 40
10 Marítimo Marítimo 30 34 45 38
11 Académica Académica 30 33 45 28
12 Vitória Setúbal Vitória 30 30 55 26
13 Gil Vicente Gil Vicente 30 31 54 25
14 Olhanense Olhanense 30 26 42 25
15 Moreirense Moreirense 30 30 51 24
16 Beira Mar SC Beira 30 35 55 23
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Porto Porto 30 69 19 75
2 Benfica Benfica 30 66 27 69
3 Sporting Braga Sporting 30 59 29 62
4 Sporting CP Sporting CP 30 47 26 59
5 Marítimo Marítimo 30 41 38 50
6 Vitória Guimarães Vitória 30 40 40 45
7 Nacional Nacional 30 48 50 44
8 Olhanense Olhanense 30 36 38 39
9 Gil Vicente Gil Vicente 30 31 42 34
10 Paços de Ferreira Paços 30 35 53 31
11 Vitória Setúbal Vitória 30 24 49 30
12 Beira Mar SC Beira 30 26 38 29
13 Académica Académica 30 27 38 29
14 Rio Ave Rio Ave 30 33 42 28
15 Feirense Feirense 30 27 49 24
16 União de Leiria União 30 25 56 19
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Porto Porto 30 73 16 84
2 Benfica Benfica 30 61 31 63
3 Sporting CP Sporting CP 30 41 31 48
4 Sporting Braga Sporting 30 45 33 46
5 Vitória Guimarães Vitória 30 36 37 43
6 Nacional Nacional 30 28 31 42
7 Paços de Ferreira Paços 30 35 42 41
8 Rio Ave Rio Ave 30 35 33 38
9 Marítimo Marítimo 30 33 32 35
10 União de Leiria União 30 25 38 35
11 Olhanense Olhanense 30 24 34 34
12 Vitória Setúbal Vitória 30 29 42 34
13 Beira Mar SC Beira 30 32 36 33
14 Académica Académica 30 32 48 30
15 Portimonense Portimonense 30 29 49 25
16 Naval Naval 30 26 51 23
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Benfica Benfica 30 78 20 76
2 Sporting Braga Sporting 30 48 20 71
3 Porto Porto 30 70 26 68
4 Sporting CP Sporting CP 30 42 26 48
5 Marítimo Marítimo 30 42 43 41
6 Vitória Guimarães Vitória 30 31 34 41
7 Nacional Nacional 30 36 46 39
8 Naval Naval 30 20 35 36
9 União de Leiria União 30 35 41 35
10 Paços de Ferreira Paços 30 32 37 35
11 Académica Académica 30 37 42 33
12 Rio Ave Rio Ave 30 22 33 31
13 Olhanense Olhanense 30 31 46 29
14 Vitória Setúbal Vitória 30 29 57 25
15 Os Belenenses Belenenses 30 23 44 23
16 Leixões Leixões 30 25 51 21
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Porto Porto 30 61 18 70
2 Sporting CP Sporting CP 30 45 20 66
3 Benfica Benfica 30 54 32 59
4 Nacional Nacional 30 47 32 52
5 Sporting Braga Sporting 30 38 21 50
6 Leixões Leixões 30 30 31 45
7 Académica Académica 30 28 32 39
8 Vitória Guimarães Vitória 30 32 36 38
9 Marítimo Marítimo 30 35 36 37
10 Paços de Ferreira Paços 30 37 42 34
11 Estrela Amadora Estrela 30 26 38 34
12 Rio Ave Rio Ave 30 20 35 30
13 Naval Naval 30 25 39 29
14 Vitória Setúbal Vitória 30 21 46 26
15 Os Belenenses Belenenses 30 28 52 24
16 Trofense Trofense 30 25 42 23
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Porto Porto 30 60 13 69
2 Sporting CP Sporting CP 30 46 28 55
3 Vitória Guimarães Vitória 30 35 31 53
4 Benfica Benfica 30 45 21 52
5 Marítimo Marítimo 30 39 28 46
6 Vitória Setúbal Vitória 30 37 33 45
7 Os Belenenses Belenenses 30 37 31 43
8 Sporting Braga Sporting 30 32 34 41
9 Boavista Boavista 30 32 41 36
10 Nacional Nacional 30 23 28 35
11 Académica Académica 30 31 38 32
12 Estrela Amadora Estrela 30 29 41 31
13 Naval Naval 30 24 47 31
14 Leixões Leixões 30 27 37 26
15 Paços de Ferreira Paços 30 31 49 25
16 União de Leiria União 30 25 53 16
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Porto Porto 30 65 20 69
2 Sporting CP Sporting CP 30 54 15 68
3 Benfica Benfica 30 55 20 67
4 Sporting Braga Sporting 30 35 30 50
5 Os Belenenses Belenenses 30 36 29 49
6 Paços de Ferreira Paços 30 31 36 42
7 União de Leiria União 30 25 27 41
8 Nacional Nacional 30 41 38 39
9 Estrela Amadora Estrela 30 23 36 35
10 Boavista Boavista 30 32 34 35
11 Marítimo Marítimo 30 30 44 32
12 Naval Naval 30 28 37 32
13 Académica Académica 30 28 46 26
14 Vitória Setúbal Vitória 30 21 45 24
15 Beira Mar SC Beira 30 28 55 23
16 Desportivo Aves Desportivo 30 22 42 22
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Porto Porto 34 54 16 79
2 Sporting CP Sporting CP 34 50 24 72
3 Benfica Benfica 34 51 29 67
4 Sporting Braga Sporting 34 38 22 58
5 Nacional Nacional 34 40 32 52
6 Boavista Boavista 34 37 29 50
7 União de Leiria União 34 44 42 47
8 Vitória Setúbal Vitória 34 28 33 46
9 Estrela Amadora Estrela 34 31 33 45
10 Marítimo Marítimo 34 38 37 44
11 Paços de Ferreira Paços 34 38 49 42
12 Gil Vicente Gil Vicente 34 37 42 40
13 Naval Naval 34 35 48 39
14 Académica Académica 34 37 48 39
15 Os Belenenses Belenenses 34 40 42 39
16 Rio Ave Rio Ave 34 34 53 34
17 Vitória Guimarães Vitória 34 28 41 34
18 Penafiel Penafiel 34 21 61 15
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Benfica Benfica 34 51 31 65
2 Porto Porto 34 39 26 62
3 Sporting CP Sporting CP 34 66 36 61
4 Sporting Braga Sporting 34 45 28 58
5 Vitória Guimarães Vitória 34 38 29 54
6 Boavista Boavista 34 39 43 50
7 Marítimo Marítimo 34 39 32 49
8 Rio Ave Rio Ave 34 35 35 47
9 Os Belenenses Belenenses 34 38 34 46
10 Vitória Setúbal Vitória 34 46 45 44
11 Penafiel Penafiel 34 39 53 43
12 Nacional Nacional 34 46 48 41
13 Gil Vicente Gil Vicente 34 34 40 40
14 Académica Académica 34 29 41 38
15 União de Leiria União 34 29 36 38
16 Moreirense Moreirense 34 30 43 34
17 Estoril Estoril 34 38 55 30
18 Beira Mar SC Beira 34 30 56 30
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Porto Porto 34 63 19 82
2 Benfica Benfica 34 62 28 74
3 Sporting CP Sporting CP 34 60 33 73
4 Nacional Nacional 34 56 35 56
5 Sporting Braga Sporting 34 36 38 54
6 Marítimo Marítimo 34 35 33 48
7 Rio Ave Rio Ave 34 42 37 48
8 Boavista Boavista 34 32 31 47
9 Moreirense Moreirense 34 33 33 46
10 União de Leiria União 34 43 45 45
11 Beira Mar SC Beira 34 36 45 41
12 Gil Vicente Gil Vicente 34 43 40 40
13 Académica Académica 34 40 42 38
14 Vitória Guimarães Vitória 34 31 40 37
15 Os Belenenses Belenenses 34 35 54 35
16 FC Alverca FC Alverca 34 33 49 35
17 Paços de Ferreira Paços 34 27 53 28
18 Estrela Amadora Estrela 34 22 74 17
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Porto Porto 34 73 26 86
2 Benfica Benfica 34 74 27 75
3 Sporting CP Sporting CP 34 52 38 59
4 Vitória Guimarães Vitória 34 47 46 50
5 União de Leiria União 34 49 47 49
6 Paços de Ferreira Paços 34 40 47 45
7 Marítimo Marítimo 34 36 48 44
8 Gil Vicente Gil Vicente 34 42 53 44
9 Os Belenenses Belenenses 34 47 48 43
10 Boavista Boavista 34 32 31 43
11 Nacional Nacional 34 40 46 40
12 Moreirense Moreirense 34 42 46 39
13 Beira Mar SC Beira 34 43 50 39
14 Sporting Braga Sporting 34 34 47 38
15 Académica Académica 34 38 48 37
16 Varzim Varzim 34 38 51 36
17 CD Santa Clara Santa Clara 34 39 54 35
18 Vitória Setúbal Vitória 34 40 53 31
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 34 74 25 75
2 Boavista Boavista 34 53 20 70
3 Porto Porto 34 66 34 68
4 Benfica Benfica 34 66 37 63
5 Os Belenenses Belenenses 34 54 44 57
6 Marítimo Marítimo 34 48 35 56
7 União de Leiria União 34 52 35 55
8 Paços de Ferreira Paços 34 41 44 46
9 Vitória Guimarães Vitória 34 35 41 42
10 Sporting Braga Sporting 34 43 43 42
11 Beira Mar SC Beira 34 48 56 39
12 Gil Vicente Gil Vicente 34 42 56 38
13 Vitória Setúbal Vitória 34 40 46 38
14 CD Santa Clara Santa Clara 34 32 46 37
15 Varzim Varzim 34 27 55 32
16 SC Salgueiros Salgueiros 34 29 71 30
17 Farense Farense 34 29 63 28
18 FC Alverca FC Alverca 34 39 67 27
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Boavista Boavista 34 63 22 77
2 Porto Porto 34 73 27 76
3 Sporting CP Sporting CP 34 56 37 62
4 Sporting Braga Sporting 34 58 48 57
5 União de Leiria União 34 46 41 56
6 Benfica Benfica 34 54 44 54
7 Os Belenenses Belenenses 34 43 36 52
8 Beira Mar SC Beira 34 45 49 49
9 Paços de Ferreira Paços 34 47 39 48
10 SC Salgueiros Salgueiros 34 41 55 43
11 Marítimo Marítimo 34 34 37 43
12 FC Alverca FC Alverca 34 45 52 43
13 Farense Farense 34 37 47 39
14 Gil Vicente Gil Vicente 34 34 41 37
15 Vitória Guimarães Vitória 34 41 49 36
16 Campomaiorense Campomaioren 34 29 58 32
17 Desportivo Aves Desportivo 34 31 68 22
18 Estrela Amadora Estrela 34 30 57 19

  USO DE MEMORIA  
8,247,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5367
Total Execution Time  0.5387
  CADENA URL  
/portugal2022/grupo1/historico
  GET DATOS  
$_GET['/portugal2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0105  SELECT type FROM routes WHERE alias = 'portugal2022'
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'portugal' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0107  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 62752 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 19 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0111  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.0110  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 = 57339 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.0111  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 = 49945 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.0111  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 = 43558 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 38648 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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.0110  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 = 15394 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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.0109  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.0109  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 = 1931 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 1349 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 1108 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2010` 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 = 867 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2009` 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 = 152 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2008` 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 = 72 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2007` 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 = 106 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2006` 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 = 107 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables2005` 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 = 108 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2004` 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 = 109 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2003` 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 = 214 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2002` 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 = 215 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2001` 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 = 216 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 11:43:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 11:43:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-18 11:43:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-18 11:43:25' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'portugal' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0215  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 62752 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62752 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0348  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 62752 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62752 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0128  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 62752 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62752 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  SELECT *,(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