4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Novara Novara 38 75 27 85
2 Sanremese Sanremese 38 69 38 77
3 Casale Casale 38 49 30 64
4 Città di Varese Città 38 53 34 63
5 Derthona Derthona 38 49 44 55
6 AS Bra AS Bra 38 41 43 55
7 Caronnese Caronnese 38 40 34 53
8 Borgosesia Borgosesia 38 47 41 52
9 Chieri Chieri 38 44 40 52
10 Sestri Levante Sestri 38 45 47 52
11 Gozzano Gozzano 38 43 29 51
12 Ligorna Ligorna 38 44 45 48
13 Vado FC Vado FC 38 42 51 48
14 PDHAE PDHAE 38 43 53 48
15 ASD Asti ASD Asti 38 40 41 47
16 Fossano Calcio Fossano 38 38 62 44
17 RG Ticino RG Ticino 38 33 45 44
18 Imperia Imperia 38 37 57 33
19 Lavagnese Lavagnese 38 30 62 30
20 Saluzzo Saluzzo 38 20 59 18
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Gozzano Gozzano 38 62 33 78
2 Castellanzese Castellanzes 38 83 66 71
3 PDHAE PDHAE 38 61 41 70
4 AS Bra AS Bra 38 62 36 69
5 Sanremese Sanremese 38 57 41 65
6 AC Legnano AC Legnano 38 66 55 64
7 Sestri Levante Sestri 38 64 48 60
8 Folgore Caratese Folgore 38 50 43 57
9 Lavagnese Lavagnese 38 62 63 56
10 Caronnese Caronnese 38 52 52 53
11 Imperia Imperia 38 43 49 49
12 Casale Casale 38 42 41 48
13 Derthona Derthona 38 42 49 47
14 Arconatese Arconatese 38 51 61 45
15 Chieri Chieri 38 47 43 44
16 Città di Varese Città 38 40 44 42
17 Saluzzo Saluzzo 38 31 51 37
18 Fossano Calcio Fossano 38 40 69 32
19 Borgosesia Borgosesia 38 47 77 30
20 Vado FC Vado FC 38 36 76 26
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Lucchese Libertas Lucchese 25 32 19 48
2 Prato Prato 25 47 26 47
3 Seravezza Seravezza 25 46 33 43
4 Casale Casale 25 40 28 43
5 Caronnese Caronnese 24 45 29 42
6 Savona Savona 25 33 31 36
7 Real Forte Querceta Real Forte. 25 29 27 36
8 Borgosesia Borgosesia 25 34 31 35
9 Sanremese Sanremese 25 30 27 33
10 Chieri Chieri 25 30 31 33
11 Fossano Calcio Fossano 25 38 38 32
12 Lavagnese Lavagnese 25 25 31 27
13 AS Bra AS Bra 25 32 34 26
14 Ghivizzano Borgo Ghivizzano 25 35 47 26
15 Fezzanese Fezzanese 25 26 39 26
16 Vado FC Vado FC 25 30 43 24
17 Verbania Verbania 24 19 42 23
18 Ligorna Ligorna 25 31 46 22
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Lecco Lecco 34 75 23 86
2 Sanremese Sanremese 34 49 35 59
3 Savona Savona 34 49 33 55
4 Inveruno Inveruno 34 59 45 54
5 Folgore Caratese Folgore 34 55 39 54
6 Casale Casale 34 40 28 54
7 Ligorna Ligorna 34 49 40 54
8 AS Bra AS Bra 34 47 45 48
9 Chieri Chieri 34 53 45 45
10 Lavagnese Lavagnese 34 47 47 42
11 Borgosesia Borgosesia 34 43 50 41
12 Fezzanese Fezzanese 34 40 49 41
13 Bustese Milano City FC Bustese 34 36 51 40
14 Sestri Levante Sestri 34 36 50 38
15 Arconatese Arconatese 34 37 47 36
16 Pro Dronero Pro Dronero 34 37 66 29
17 Stresa Stresa 34 26 49 26
18 Borgaro Nobis Borgaro 34 27 63 26
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Gozzano Gozzano 38 68 25 82
2 Como Como 38 58 27 81
3 Caronnese Caronnese 38 62 30 74
4 Chieri Chieri 38 64 37 71
5 Pro Sesto Pro Sesto 38 69 43 67
6 Folgore Caratese Folgore 38 45 39 56
7 Inveruno Inveruno 38 44 48 52
8 Borgosesia Borgosesia 38 40 39 51
9 Arconatese Arconatese 38 37 46 50
10 AS Bra AS Bra 38 45 51 49
11 Pavia Pavia 38 53 58 47
12 Borgaro Nobis Borgaro 38 35 44 46
13 Olginatese Olginatese 38 37 44 45
14 Seregno Seregno 38 45 54 44
15 OltrepòVoghera OltrepòVogh 38 34 47 43
16 Casale Casale 38 41 48 42
17 Varesina Varesina 38 33 45 41
18 Varese Varese 38 47 49 40
19 Derthona Derthona 38 25 62 26
20 Castellazzo Castellazzo 38 32 78 19
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Cuneo Cuneo 34 49 28 66
2 Varese Varese 34 48 29 63
3 Borgosesia Borgosesia 34 49 22 62
4 Gozzano Gozzano 34 58 37 59
5 Inveruno Inveruno 34 71 51 59
6 Caronnese Caronnese 34 55 38 59
7 Chieri Chieri 34 65 47 55
8 Pro Sesto Pro Sesto 34 42 35 54
9 Casale Casale 34 39 40 48
10 AS Bra AS Bra 34 43 42 41
11 Folgore Caratese Folgore 34 45 47 41
12 Voghera Voghera 34 42 57 38
13 Varesina Varesina 34 39 61 34
14 Bustese Milano City FC Bustese 34 37 54 31
15 AC Legnano AC Legnano 34 34 61 31
16 Verbania Verbania 34 36 56 30
17 Pinerolo Pinerolo 34 38 61 28
18 ASD Pro Settimo Settimo 34 28 52 26
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Bellinzago Bellinzago 38 74 31 86
2 Caronnese Caronnese 38 74 23 82
3 Lavagnese Lavagnese 38 66 30 74
4 Chieri Chieri 38 74 41 72
5 Argentina SSD Argentina 38 48 25 66
6 Sestri Levante Sestri 38 41 23 62
7 Gozzano Gozzano 38 64 38 61
8 Pinerolo Pinerolo 38 50 47 61
9 Rapallo Boglia.. Rapallo 38 51 40 57
10 Voghera Voghera 38 53 44 53
11 Derthona Derthona 38 52 48 52
12 AS Bra AS Bra 38 53 55 51
13 Borgosesia Borgosesia 38 40 46 47
14 ASD Pro Settimo Settimo 38 35 45 43
15 Vado FC Vado FC 38 43 61 40
16 Ligorna Ligorna 38 45 73 40
17 Fezzanese Fezzanese 38 38 74 34
18 Acqui Acqui 38 30 70 28
19 Castellazzo Castellazzo 38 29 73 22
20 Novese Novese 38 26 99 19
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Cuneo Cuneo 38 63 30 79
2 Sestri Levante Sestri 38 47 25 75
3 Chieri Chieri 38 60 36 74
4 Borgosesia Borgosesia 38 72 47 70
5 Caronnese Caronnese 38 60 35 68
6 ASD Pro Settimo Settimo 38 56 41 66
7 AS Bra AS Bra 38 66 51 62
8 Voghera Voghera 38 59 50 61
9 Lavagnese Lavagnese 38 50 43 58
10 Acqui Acqui 38 53 49 54
11 Novese Novese 38 46 47 48
12 Bellinzago Bellinzago 38 55 61 48
13 Argentina SSD Argentina 38 60 68 47
14 Vado Vado 38 54 62 47
15 Asti FC Asti FC 38 41 49 47
16 Rapallo Boglia.. Rapallo 38 46 57 42
17 Sancolombano Sancolombano 38 31 46 36
18 Derthona Derthona 38 29 62 24
19 Vallée dAoste Vallée 38 38 73 24
20 Borgomanero ASD Borgomanero 38 30 84 17
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Giana Erminio Giana 34 68 29 73
2 Rapallo Boglia.. Rapallo 34 60 32 68
3 Borgosesia Borgosesia 34 74 36 67
4 Caronnese Caronnese 34 52 29 62
5 Lavagnese Lavagnese 34 46 28 61
6 Chieri Chieri 34 53 44 60
7 Vado FC Vado FC 34 55 46 51
8 Chiavari Caperana Chiavari 34 35 30 46
9 Asti FC Asti FC 34 46 38 44
10 Novese Novese 34 40 50 44
11 Vallée dAoste Vallée 34 41 42 42
12 Folgore Caratese Folgore 34 33 48 41
13 Derthona Derthona 34 37 44 39
14 Albese Calcio Albese 34 38 52 39
15 Sestri Levante Sestri 34 38 52 35
16 Pro Dronero Pro Dronero 34 51 75 30
17 Santhià Santhià 34 26 69 22
18 Verbania Verbania 34 18 67 13
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 AS Bra AS Bra 34 64 35 72
2 Santhià Santhià 34 69 42 69
3 Lavagnese Lavagnese 34 53 36 62
4 Chieri Chieri 34 47 34 61
5 Borgosesia Borgosesia 34 65 32 56
6 Chiavari Caperana Chiavari 34 53 43 51
7 Folgore Caratese Folgore 34 35 32 50
8 Sestri Levante Sestri 34 51 43 47
9 Derthona Derthona 34 29 33 45
10 Verbania Verbania 34 44 38 44
11 Bogliasco FC Bogliasco 34 47 46 43
12 Gozzano Gozzano 34 40 40 43
13 Verbano Calcio Verbano 34 37 44 40
14 Asti FC Asti FC 34 31 49 39
15 Tortona Villalvernia Tortona 34 32 50 35
16 Novese Novese 34 33 55 33
17 Trezzano Calcio Trezzano 34 27 49 28
18 Imperia Imperia 34 33 89 20
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 S. Christophe Christophe 36 88 44 83
2 Chieri Chieri 36 66 34 82
3 Santhià Santhià 36 69 39 67
4 Novese Novese 36 54 41 60
5 Lavagnese Lavagnese 36 55 35 58
6 Borgosesia Borgosesia 36 55 39 55
7 Villalvernia Villalvernia 36 55 45 55
8 Derthona Derthona 36 52 46 54
9 Folgore Caratese Folgore 36 55 38 52
10 Chiavari Chiavari 36 52 50 51
11 Imperia Imperia 36 46 49 50
12 Bogliasco Bogliasco 36 49 48 48
13 Naviglio Trezzano Naviglio 36 46 45 47
14 Verbano Calcio Verbano 36 50 53 46
15 Acqui Acqui 35 35 48 40
16 Asti FC Asti FC 36 45 55 39
17 Albese Calcio Albese 36 40 62 31
18 Cantù San Paolo Cantù Paolo 35 16 90 8
19 Lascaris Lascaris 36 30 97 7
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Cuneo Cuneo 38 87 44 82
2 Asti FC Asti FC 38 66 43 73
3 Vallée dAoste Vallée 38 63 41 73
4 Aquanera Aquanera 38 65 41 66
5 Seregno Seregno 38 52 35 63
6 Santhià Santhià 38 44 33 59
7 Gallaratese Gallaratese 38 49 38 57
8 Lavagnese Lavagnese 38 49 43 57
9 Borgosesia Borgosesia 38 46 43 57
10 Acqui Acqui 38 37 38 53
11 Sarzanese Sarzanese 38 44 43 52
12 Chiavari Caperana Chiavari 38 54 62 51
13 Chieri Chieri 38 52 52 50
14 Novese Novese 38 48 50 48
15 Derthona Derthona 38 54 51 46
16 ACD Rivoli ACD Rivoli 38 42 63 44
17 Albese Calcio Albese 38 40 52 38
18 Pro Vigevano Suardese Vigevano 38 40 76 29
19 Borgorosso Arenzano Borgorosso 38 25 64 25
20 Settimo Milanese Settimo 38 24 69 17
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Savona Savona 34 84 23 85
2 Virtus Entella Virtus 34 55 20 67
3 Casale Casale 34 53 29 67
4 Albese Calcio Albese 34 51 37 56
5 Sarzanese Sarzanese 34 43 28 54
6 Acqui Acqui 34 39 34 49
7 Lavagnese Lavagnese 34 47 34 48
8 Borgorosso Arenzano Borgorosso 34 55 56 45
9 Settimo Milanese Settimo 34 42 49 45
10 Aquanera Aquanera 34 49 61 44
11 Cuneo Cuneo 34 37 34 42
12 Chieri Chieri 34 47 50 39
13 Pro Vigevano Suardese Vigevano 34 36 49 39
14 ACD Rivoli ACD Rivoli 34 44 59 37
15 ASD Pro Settimo Settimo 34 36 56 33
16 Derthona Derthona 34 34 54 28
17 Sestrese Calcio Sestrese 34 27 59 27
18 Vallée dAoste Vallée 34 27 74 17
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Biellese Biellese 34 67 26 78
2 Spezia Spezia 34 55 25 72
3 Casale Casale 34 57 37 60
4 Sarzanese Sarzanese 34 40 24 59
5 ASD Pro Settimo Settimo 34 46 37 56
6 Albese Calcio Albese 33 44 37 54
7 Derthona Derthona 34 39 40 51
8 Savona Savona 34 42 33 50
9 Virtus Entella Virtus 34 41 33 46
10 Cuneo Cuneo 33 26 24 44
11 Lavagnese Lavagnese 34 33 33 44
12 ACD Rivoli ACD Rivoli 34 37 42 40
13 USD Rivarolese 1906 Rivarolese 34 41 45 39
14 Sestri Levante Sestri 34 33 48 34
15 Vallée dAoste Vallée 35 36 45 33
16 FCD Lottogiaveno Lottogiaveno 34 27 43 29
17 Sestrese Calcio Sestrese 34 34 58 29
18 USD Ciriè Calcio Ciriè 34 28 54 29
19 Novese Novese 35 21 63 26

  USO DE MEMORIA  
7,316,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5434
Total Execution Time  0.5453
  CADENA URL  
/serie_d2022/grupo1/historico
  GET DATOS  
$_GET['/serie_d2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0126  SELECT type FROM routes WHERE alias = 'serie_d2022'
0.0253  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 = 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.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=222 ORDER BY order_id ASC
0.0128  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 = 64275 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 222 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0138  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 = 64275 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.0147  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 = 58826 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.0143  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 = 51156 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.0153  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 = 44796 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 39595 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 33449 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 15649 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 4814 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 24665 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 2087 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 1691 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 24694 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 24709 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 24718 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 21:14:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 21:14:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 21:14:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 21:14:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0242  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 = 64275 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64275 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.0353  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 = 64275 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64275 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0143  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 = 64275 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64275 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 `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 = 64275 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