4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Caldiero Terme Caldiero 37 51 30 74
2 Piacenza Piacenza 37 67 33 73
3 Pro Palazzolo Palazzolo 37 45 24 70
4 Desenzano Calvina Desenzano 37 50 26 69
5 Varesina Varesina 37 71 47 67
6 Arconatese Arconatese 37 54 38 65
7 Villa Valle Villa Valle 37 48 40 53
8 Calcio Brusaporto Calcio 37 52 51 53
9 FC Clivense SM Clivense 37 38 43 53
10 Casatese Casatese 37 53 52 51
11 Folgore Caratese Folgore 37 44 45 50
12 Virtus Ciserano Bergamo Virtus 37 48 55 45
13 Club Milano Club Milano 37 41 44 44
14 Caravaggio Caravaggio 37 42 50 43
15 Real Calepina Real 37 35 47 41
16 AC Legnano AC Legnano 37 31 49 39
17 Castellanzese Castellanzes 37 33 48 38
18 Crema Crema 37 24 48 33
19 Tritium Tritium 37 25 53 29
20 US Ponte San Pietro Ponte Pietro 37 31 60 24
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Lumezzane Lumezzane 34 67 20 77
2 Alcione Alcione 34 67 31 71
3 Casatese Casatese 34 38 26 59
4 Arconatese Arconatese 34 54 37 57
5 Desenzano Calvina Desenzano 34 47 41 53
6 Franciacorta Franciacorta 34 44 43 50
7 US Ponte San Pietro Ponte Pietro 34 47 38 49
8 Virtus Ciserano Bergamo Virtus 34 42 40 48
9 Calcio Brusaporto Calcio 34 43 38 47
10 Varesina Varesina 34 47 50 46
11 Villa Valle Villa Valle 34 40 47 41
12 Real Calepina Real 34 30 33 39
13 Folgore Caratese Folgore 34 37 46 39
14 Seregno Seregno 34 42 56 38
15 US Breno US Breno 34 35 50 37
16 Città di Varese Città 34 30 46 33
17 Sona Calcio Sona Calcio 34 28 56 27
18 Caronnese Caronnese 34 24 64 15
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Sangiuliano City Nova Sangiuliano 38 81 39 82
2 AC Legnano AC Legnano 38 49 44 66
3 Casatese Casatese 38 70 44 64
4 Calcio Brusaporto Calcio 38 62 49 64
5 Folgore Caratese Folgore 38 57 46 63
6 Desenzano Calvina Desenzano 38 65 49 63
7 US Breno US Breno 38 56 43 58
8 Virtus Ciserano Bergamo Virtus 38 66 56 58
9 Arconatese Arconatese 38 62 58 57
10 Franciacorta Franciacorta 38 73 80 52
11 Crema Crema 38 44 52 46
12 Castellanzese Castellanzes 38 50 55 46
13 Sona Calcio Sona Calcio 38 43 56 45
14 US Ponte San Pietro Ponte Pietro 38 54 56 44
15 Real Calepina Real 38 38 39 44
16 Villa Valle Villa Valle 38 49 56 39
17 Caravaggio Caravaggio 38 41 62 37
18 Vis Nova Giussano Nova 38 56 77 35
19 Olginatese Olginatese 38 43 60 35
20 AC Leon AC Leon 38 50 88 33
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Seregno Seregno 34 54 36 69
2 Fanfulla Fanfulla 34 60 36 64
3 Casatese Casatese 34 53 41 55
4 Nibionnoggiono Nibionnoggio 34 48 38 55
5 Crema Crema 34 62 51 53
6 Desenzano Calvina Desenzano 34 49 52 52
7 US Breno US Breno 34 44 35 49
8 Calcio Brusaporto Calcio 34 52 53 49
9 Franciacorta Franciacorta 34 47 37 48
10 Sona Calcio Sona Calcio 34 49 52 46
11 Real Calepina Real 34 36 42 43
12 Virtus Ciserano Bergamo Virtus 34 41 42 42
13 US Ponte San Pietro Ponte Pietro 34 37 41 41
14 Vis Nova Giussano Nova 34 43 62 39
15 Villa Valle Villa Valle 34 51 60 38
16 Caravaggio Caravaggio 34 48 61 38
17 Tritium Tritium 34 41 52 35
18 Scanzorosciate Scanzoroscia 34 28 52 26
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Pro Sesto Pro Sesto 27 46 29 56
2 AC Legnano AC Legnano 27 39 25 50
3 Scanzorosciate Scanzoroscia 27 32 21 46
4 Arconatese Arconatese 27 42 36 44
5 Folgore Caratese Folgore 27 31 24 43
6 Nibionnoggiono Nibionnoggio 27 38 25 42
7 Tritium Tritium 27 39 32 42
8 Sondrio Sondrio 27 31 29 41
9 Seregno Seregno 27 32 25 39
10 Calcio Brusaporto Calcio 27 27 24 39
11 Virtus Bergamo Virtus 27 34 35 35
12 Castellanzese Castellanzes 27 39 41 35
13 Virtus Bolzano Virtus 27 35 34 34
14 US Ponte San Pietro Ponte Pietro 27 29 31 33
15 Caravaggio Caravaggio 27 41 43 32
16 Villa Valle Villa Valle 27 33 43 29
17 Levico Levico 27 32 43 27
18 Bustese Milano City FC Bustese 27 21 35 23
19 Dro Calcio Dro Calcio 27 17 37 17
20 Inveruno Inveruno 27 31 57 17
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Como Como 34 68 18 89
2 Mantova Mantova 34 73 27 83
3 Pro Sesto Pro Sesto 34 61 42 69
4 Rezzato Rezzato 34 53 36 65
5 Caronnese Caronnese 34 57 41 59
6 Virtus Bergamo Virtus 34 34 41 45
7 Sondrio Sondrio 34 38 39 44
8 Seregno Seregno 34 37 42 43
9 Villa Valle Villa Valle 34 35 35 41
10 Pontisola Pontisola 34 51 52 40
11 Caravaggio Caravaggio 34 45 53 40
12 Scanzorosciate Scanzoroscia 34 35 37 39
13 Legnago Salus Legnago 34 38 57 38
14 Darfo Boario Darfo Boario 34 26 46 35
15 Ambrosiana Ambrosiana 34 45 62 33
16 Villafranca Villafranca 34 36 44 31
17 Ciserano Ciserano 34 42 68 26
18 Olginatese Olginatese 34 26 60 19
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Pro Patria Pro Patria 36 58 22 79
2 Rezzato Rezzato 36 84 35 78
3 Pontisola Pontisola 36 67 44 70
4 Pergolettese Pergolettese 36 57 37 67
5 Darfo Boario Darfo Boario 36 51 30 62
6 Virtus Bergamo Virtus 36 57 46 58
7 Lecco Lecco 36 46 35 58
8 Crema Crema 36 43 40 48
9 Bustese Milano City FC Bustese 36 44 43 47
10 Caravaggio Caravaggio 36 47 52 47
11 Pol. Ciliverghe Pol. 36 47 46 45
12 Levico Levico 36 45 56 44
13 Scanzorosciate Scanzoroscia 36 41 51 43
14 Trento Trento 36 42 64 43
15 Lumezzane Lumezzane 36 37 51 42
16 Ciserano Ciserano 36 42 58 36
17 Grumellese Grumellese 36 34 55 34
18 Dro Calcio Dro Calcio 36 33 62 31
19 Romanese Romanese 36 30 78 11
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 AC Monza AC Monza 34 70 17 80
2 Pol. Ciliverghe Pol. 34 75 45 73
3 Pergolettese Pergolettese 34 58 38 65
4 Virtus Bergamo Virtus 34 57 34 63
5 Pro Patria Pro Patria 34 50 34 62
6 Pontisola Pontisola 34 59 37 59
7 Darfo Boario Darfo Boario 34 46 38 54
8 Caravaggio Caravaggio 34 45 48 47
9 Seregno Seregno 34 51 49 45
10 Grumellese Grumellese 34 37 51 42
11 Ciserano Ciserano 34 44 54 40
12 Dro Calcio Dro Calcio 34 33 48 36
13 Olginatese Olginatese 34 39 56 36
14 Scanzorosciate Scanzoroscia 34 30 61 34
15 Levico Levico 34 42 53 31
16 Lecco Lecco 34 31 64 31
17 Virtus Bolzano Virtus 34 31 54 29
18 Fanfulla Fanfulla 34 38 55 27
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Piacenza Piacenza 38 85 27 96
2 Lecco Lecco 38 83 41 80
3 Seregno Seregno 38 63 47 64
4 Pontisola Pontisola 38 63 48 61
5 Pol. Ciliverghe Pol. 38 48 49 61
6 Olginatese Olginatese 38 57 50 56
7 Inveruno Inveruno 38 65 57 53
8 Ciserano Ciserano 38 48 55 53
9 Folgore Caratese Folgore 38 52 48 50
10 AC Monza AC Monza 38 52 49 49
11 Grumellese Grumellese 38 49 53 48
12 Pro Sesto Pro Sesto 38 50 51 47
13 Varesina Varesina 38 42 49 47
14 Pergolettese Pergolettese 38 38 42 46
15 Bustese Milano City FC Bustese 38 47 58 45
16 Virtus Bergamo Virtus 38 44 61 45
17 Caravaggio Caravaggio 38 35 56 34
18 Fiorenzuola Fiorenzuola 38 28 51 33
19 MapelloBonate MapelloBonat 38 36 59 31
20 Sondrio Sondrio 38 39 73 27
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Castiglione Castiglione 36 54 26 74
2 Lecco Lecco 36 65 42 66
3 Seregno Seregno 36 64 37 65
4 Ciserano Ciserano 36 53 39 60
5 Virtus Verona Virtus 36 58 34 59
6 Pergolettese Pergolettese 36 46 44 55
7 Olginatese Olginatese 36 44 34 54
8 Pontisola Pontisola 36 50 42 52
9 Pol. Ciliverghe Pol. 36 37 40 51
10 Sondrio Sondrio 36 46 50 51
11 Aurora Seriate Aurora 36 42 43 50
12 Inveruno Inveruno 36 47 48 49
13 Pro Sesto Pro Sesto 36 38 41 47
14 Villafranca Villafranca 36 44 49 47
15 MapelloBonate MapelloBonat 36 36 48 47
16 Caravaggio Caravaggio 36 37 42 41
17 Folgore Caratese Folgore 36 34 40 37
18 AC Castellana Castellana 36 36 61 30
19 AC Montichiari Montichiari 36 26 97 5
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Pro Piacenza Piacenza 34 69 45 66
2 Olginatese Olginatese 34 43 25 57
3 Piacenza Piacenza 34 59 46 57
4 Seregno Seregno 34 54 46 56
5 Inveruno Inveruno 34 65 43 55
6 Pontisola Pontisola 34 44 41 53
7 Pro Sesto Pro Sesto 34 38 32 52
8 Caravaggio Caravaggio 34 54 40 50
9 Lecco Lecco 34 50 43 50
10 Aurora Seriate Aurora 34 35 39 46
11 Legnago Salus Legnago 34 44 50 44
12 AC Castellana Castellana 34 38 45 42
13 MapelloBonate MapelloBonat 34 44 56 39
14 AlzanoCene AlzanoCene 34 32 43 36
15 Borgomanero ASD Borgomanero 34 43 56 36
16 Gozzano Gozzano 34 35 41 34
17 Darfo Boario Darfo Boario 34 40 61 29
18 AC Sambonifacese Sambonifaces 34 34 69 25
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Pergolettese Pergolettese 38 64 27 84
2 Pontisola Pontisola 38 87 45 83
3 Olginatese Olginatese 38 59 32 70
4 Voghera Voghera 38 60 43 68
5 Lecco Lecco 38 66 42 62
6 AC Castellana Castellana 38 50 44 58
7 Caronnese Caronnese 38 50 46 58
8 Caravaggio Caravaggio 38 41 36 56
9 AC Montichiari Montichiari 38 58 53 54
10 Aurora Seriate Aurora 38 55 52 53
11 MapelloBonate MapelloBonat 38 60 56 48
12 Darfo Boario Darfo Boario 38 57 55 48
13 AlzanoCene AlzanoCene 38 62 63 47
14 Seregno Seregno 38 51 53 46
15 Fersina Perginese Fersina 38 52 56 46
16 Pro Sesto Pro Sesto 38 44 50 44
17 AC Mezzocorona Mezzocorona 38 49 76 32
18 Trento Trento 38 45 82 28
19 St. Georgen St. Georgen 38 47 85 27
20 Sant Angelo Sant Angelo 38 31 92 13
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Sterilgarda Castiglione Sterilgarda 38 55 36 76
2 Pontisola Pontisola 38 53 34 69
3 Olginatese Olginatese 38 57 43 65
4 Pergolettese Pergolettese 38 51 36 64
5 MapelloBonate MapelloBonat 38 60 51 61
6 Caronnese Caronnese 38 58 42 57
7 AlzanoCene AlzanoCene 38 55 45 54
8 AC Castellana Castellana 38 54 53 51
9 Fidenza Fidenza 38 35 39 50
10 Voghera Voghera 38 36 34 49
11 Pro Piacenza Piacenza 38 45 44 49
12 Aurora Seriate Aurora 38 44 45 49
13 Rudianese Rudianese 38 39 41 49
14 Gozzano Gozzano 38 43 43 48
15 Darfo Boario Darfo Boario 38 44 47 48
16 Seregno Seregno 38 48 52 43
17 Carpenedolo Carpenedolo 38 48 63 40
18 Colognese Colognese 38 35 55 40
19 Fiorenzuola Fiorenzuola 38 41 64 33
20 Gallaratese Gallaratese 38 22 56 23
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Mantova Mantova 34 53 27 67
2 Voghera Voghera 34 57 47 58
3 Pontisola Pontisola 34 49 39 58
4 Colognese Colognese 34 48 40 56
5 Legnago Salus Legnago 34 61 39 54
6 Olginatese Olginatese 34 53 36 54
7 Caronnese Caronnese 34 48 41 54
8 Darfo Boario Darfo Boario 34 52 36 51
9 Castiglione Castiglione 34 50 34 49
10 Cantù San Paolo Cantù Paolo 34 40 37 47
11 Virtus Verona Virtus 34 35 34 44
12 AlzanoCene AlzanoCene 34 47 53 42
13 AC Castellana Castellana 34 33 43 38
14 Villafranca Villafranca 34 39 59 35
15 Folgore Caratese Folgore 34 44 61 32
16 Trento Trento 34 35 58 32
17 Castelnuovo Sandra Castelnuovo 34 40 66 30
18 Solbiatese Arno Calcio Solbiatese 34 26 60 26
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Tritium Tritium 34 68 24 80
2 AlzanoCene AlzanoCene 34 53 41 55
3 Pontisola Pontisola 34 53 42 54
4 Renate Renate 34 47 41 54
5 Darfo Boario Darfo Boario 34 42 36 54
6 Colognese Colognese 34 47 38 51
7 Caronnese Caronnese 34 53 49 50
8 Voghera Voghera 34 63 50 48
9 Cantù San Paolo Cantù Paolo 34 48 50 48
10 Pergolettese Pergolettese 34 50 49 45
11 Solbiatese Arno Calcio Solbiatese 34 42 44 42
12 Olginatese Olginatese 34 52 59 42
13 US Sestese US Sestese 34 34 43 41
14 Fiorenzuola Fiorenzuola 34 44 49 37
15 Folgore Caratese Folgore 34 26 36 36
16 Borgosesia Borgosesia 34 30 49 33
17 Caravaggio Caravaggio 34 40 60 29
18 Stradellina Stradellina 34 22 54 22
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Pro Belvedere Belvedere 34 46 24 71
2 Renate Renate 34 60 34 64
3 Colognese Colognese 34 50 35 60
4 US Sestese US Sestese 34 52 38 60
5 AlzanoCene AlzanoCene 34 43 30 59
6 Tritium Tritium 34 41 34 53
7 Salus Et Virtus Turate Salus Virtus 34 38 35 49
8 Darfo Boario Darfo Boario 34 52 45 48
9 Voghera Voghera 34 40 41 45
10 Solbiatese Arno Calcio Solbiatese 34 31 38 41
11 Nuova Verolese Nuova 34 36 37 39
12 Olginatese Olginatese 34 39 50 37
13 Folgore Caratese Folgore 33 27 30 36
14 Casteggio 1898 Casteggio 33 34 56 34
15 AC Merate AC Merate 34 39 56 33
16 Caravaggio Caravaggio 33 25 35 31
17 Borgomanero ASD Borgomanero 33 35 52 27
18 Fanfulla Fanfulla 34 24 42 26

  USO DE MEMORIA  
7,599,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5549
Total Execution Time  0.5569
  CADENA URL  
/serie_d2024/grupo2/historico
  GET DATOS  
$_GET['/serie_d2024/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0126  SELECT type FROM routes WHERE alias = 'serie_d2024'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'serie_d' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=222 ORDER BY order_id ASC
0.0130  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 = 73980 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 222 AND group_code = 2 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0132  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 = 73980 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 68748 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.0131  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 = 64276 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 58827 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.0135  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 = 51157 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 44797 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 39596 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 33450 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 15650 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 4815 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 24670 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 2088 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 1692 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 24695 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 24710 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 24720 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 00:55:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 00:55:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 00:55:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 00:55:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'serie_d' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0233  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 events2024 e ON e.player_id = p.id AND e.league_id = 73980 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73980 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.0359  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 events2024 e ON e.player_id = p.id AND e.league_id = 73980 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73980 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0142  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 events2024 e ON e.player_id = p.id AND e.league_id = 73980 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73980 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  SELECT *,(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 = 73980 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC