4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 RB Bragantino Sub 23 Bragantino 10 13 20 6
2 Noroeste Noroeste 10 18 6 21
3 Marília Marília 10 12 13 16
4 Grêmio Prudente Grêmio 10 12 8 15
5 Mirassol Mirassol 10 12 8 15
6 São Bento São Bento 10 4 12 6
7 Comercial Comercial 10 5 16 6
8 XV de Piracicaba Piracicaba 10 10 1 22
9 CA Juventus CA Juventus 10 17 13 19
10 Primavera SP Primavera 10 9 9 14
11 Oeste Oeste 10 11 11 13
12 Ponte Preta Sub 23 Ponte Preta 10 5 11 6
13 Portuguesa Portuguesa 10 14 2 23
14 São José São José 10 16 7 23
15 Portuguesa Santista Portuguesa 10 13 7 21
16 Santo André Santo André 10 7 15 10
17 EC São Bernardo São 10 6 15 6
18 São Caetano São Caetano 10 4 14 4
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Marília Marília 8 16 5 20
2 Botafogo SP II Botafogo 8 10 11 12
3 Noroeste Noroeste 8 13 13 10
4 Sertãozinho Sertãozinho 8 5 11 10
5 Comercial Comercial 8 7 11 5
6 Desportivo Brasil Desportivo 10 19 10 21
7 XV de Piracicaba Piracicaba 10 17 11 17
8 Primavera SP Primavera 10 7 10 12
9 São Bento São Bento 10 10 11 11
10 Rio Claro Rio Claro 10 12 17 9
11 Lemense Lemense 10 8 14 8
12 São Caetano São Caetano 10 11 8 15
13 Água Santa Água Santa 10 12 10 15
14 Portuguesa Portuguesa 10 14 10 14
15 Oeste Oeste 10 13 10 14
16 CA Juventus CA Juventus 10 8 13 11
17 EC São Bernardo São 10 11 18 8
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Botafogo SP II Botafogo 6 6 0 12
2 Votuporanguense Votuporangue 6 9 3 10
3 Comercial Comercial 6 3 3 9
4 Velo Clube Velo Clube 6 0 12 1
5 XV de Piracicaba Piracicaba 6 9 2 13
6 Noroeste Noroeste 6 5 4 10
7 São Bento São Bento 6 2 5 5
8 Rio Claro Rio Claro 6 3 8 5
9 São Bernardo FC São 6 9 4 13
10 EC São Bernardo São 6 7 8 9
11 Primavera SP Primavera 6 8 9 7
12 Santos B Santos B 6 5 8 5
13 Portuguesa Portuguesa 8 12 4 14
14 São Caetano São Caetano 8 11 12 12
15 Atibaia Atibaia 8 12 10 11
16 CA Juventus CA Juventus 8 7 11 9
17 Taubaté Taubaté 8 8 13 5
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Marília Marília 6 15 10 12
2 Botafogo SP II Botafogo 6 13 9 9
3 Novorizontino Novorizontin 6 10 9 8
4 Rio Preto Rio Preto 6 9 19 4
5 Comercial Comercial 6 7 5 9
6 Ferroviária Ferroviária 6 4 3 8
7 Velo Clube Velo Clube 6 5 6 6
8 Atibaia Atibaia 6 2 4 6
9 XV de Piracicaba Piracicaba 6 11 5 15
10 Primavera SP Primavera 6 5 5 8
11 Audax São Paulo Audax São P. 6 7 7 7
12 Inter de Limeira Inter 6 5 11 4
13 São Bernardo FC São 6 12 6 12
14 Portuguesa Santista Portuguesa 6 8 5 11
15 Ponte Preta B Ponte Preta 6 7 7 6
16 CA Juventus CA Juventus 6 3 12 2
17 Portuguesa Portuguesa 6 15 1 16
18 Água Santa Água Santa 6 6 6 8
19 Nacional SP Nacional SP 6 7 13 5
20 Guaraní SP II Guaraní 6 8 16 4
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Ferroviária Ferroviária 10 16 6 25
2 Comercial Comercial 10 12 4 23
3 Linense CA Linense CA 10 8 6 12
4 Mirassol Mirassol 10 13 5 11
5 Votuporanguense Votuporangue 10 9 13 7
6 Batatais Batatais 10 4 28 2
7 XV de Piracicaba Piracicaba 10 15 9 21
8 Rio Claro Rio Claro 10 9 8 15
9 Inter de Limeira Inter 10 10 10 14
10 Atibaia Atibaia 10 9 9 12
11 Velo Clube Velo Clube 10 7 8 11
12 Noroeste Noroeste 10 10 16 7
13 Taubaté Taubaté 10 7 4 18
14 CA Juventus CA Juventus 10 10 8 18
15 Nacional SP Nacional SP 10 9 10 13
16 Desportivo Brasil Desportivo 10 10 9 12
17 Corinthians B Corinthians 10 8 10 11
18 Portuguesa Portuguesa 10 8 11 11
19 São Caetano São Caetano 10 15 6 20
20 Água Santa Água Santa 10 10 6 18
21 EC São Bernardo São 10 14 6 17
22 Santo André Santo André 10 7 10 12
23 Ponte Preta B Ponte Preta 10 7 13 10
24 Grêmio Osasco Grêmio 10 5 17 7
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Mirassol Mirassol 10 13 4 21
2 Olímpia FC Olímpia FC 10 14 7 21
3 Votuporanguense Votuporangue 10 12 7 16
4 Novorizontino Novorizontin 10 11 10 13
5 Penapolense Penapolense 10 5 22 7
6 Batatais Batatais 10 7 12 5
7 Ferroviária Ferroviária 12 15 9 22
8 RB Brasil RB Brasil 12 16 9 19
9 XV de Piracicaba Piracicaba 12 15 14 17
10 Rio Claro Rio Claro 12 7 9 14
11 Inter de Limeira Inter 12 11 13 13
12 Noroeste Noroeste 12 11 16 13
13 Desportivo Brasil Desportivo 12 7 12 11
14 São Caetano São Caetano 12 14 3 26
15 Taubaté Taubaté 12 16 9 24
16 Santo André Santo André 12 12 6 21
17 São Bernardo FC São 12 11 8 18
18 Santos B Santos B 12 16 18 14
19 RB Bragantino B Bragantino 12 13 19 10
20 Água Santa Água Santa 12 6 25 2
21 Ituano Ituano 12 25 14 26
22 Atibaia Atibaia 12 24 17 22
23 CA Juventus CA Juventus 12 16 12 20
24 Audax São Paulo Audax São P. 12 15 13 19
25 Portuguesa Portuguesa 12 11 10 18
26 Nacional SP Nacional SP 12 15 19 13
27 Taboão da Serra Taboão 12 15 36 2
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 XV de Piracicaba Piracicaba 12 20 8 27
2 Ferroviária Ferroviária 12 21 11 25
3 Mirassol Mirassol 12 16 12 17
4 Linense CA Linense CA 12 11 11 15
5 Noroeste Noroeste 12 7 9 15
6 Penapolense Penapolense 12 13 23 10
7 Velo Clube Velo Clube 12 8 22 6
8 Inter de Limeira Inter 12 22 7 27
9 Desportivo Brasil Desportivo 12 13 9 23
10 FC São Paulo B São Paulo 12 14 15 18
11 Taboão da Serra Taboão 12 14 20 13
12 Rio Branco SP Branco 12 11 16 12
13 Grêmio Osasco Grêmio 12 12 13 11
14 Atibaia Atibaia 12 7 13 10
15 São Caetano São Caetano 14 27 15 26
16 Portuguesa Portuguesa 14 18 12 25
17 Água Santa Água Santa 14 19 14 25
18 Santos B Santos B 14 21 15 24
19 Nacional SP Nacional SP 14 18 10 23
20 CA Juventus CA Juventus 14 14 19 14
21 Taubaté Taubaté 14 12 20 10
22 Portuguesa Santista Portuguesa 14 9 33 4
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Penapolense Penapolense 10 16 7 23
2 Votuporanguense Votuporangue 10 13 12 18
3 Mirassol Mirassol 10 11 10 13
4 Catanduvense Catanduvense 10 12 14 10
5 Olímpia FC Olímpia FC 10 11 14 9
6 Marília Marília 10 6 12 8
7 Ferroviária Ferroviária 12 31 2 30
8 Rio Claro Rio Claro 12 22 5 28
9 Comercial Comercial 12 20 9 24
10 São Carlos São Carlos 12 20 17 18
11 Independente SP Independente 12 13 30 10
12 Batatais Batatais 12 9 18 8
13 Matonense Matonense 12 4 38 1
14 RB Brasil RB Brasil 12 16 4 26
15 XV de Piracicaba Piracicaba 12 19 6 24
16 RB Bragantino Bragantino 12 11 9 18
17 São Paulo São Paulo 12 11 13 15
18 Paulista Paulista 12 8 12 14
19 Ituano Ituano 12 12 18 13
20 CA Juventus CA Juventus 12 5 20 6
21 São Caetano São Caetano 10 20 3 25
22 Santos FC Santos FC 10 16 12 18
23 Água Santa Água Santa 10 12 8 18
24 Nacional SP Nacional SP 10 17 14 13
25 CA Joseense CA Joseense 10 13 20 7
26 Flamengo SP Flamengo SP 10 3 24 5
27 Santo André Santo André 0 0 0 0
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Linense CA Linense CA 8 13 5 17
2 Mirassol Mirassol 8 13 5 15
3 Penapolense Penapolense 8 12 9 13
4 Rio Preto Rio Preto 8 6 10 9
5 Catanduvense Catanduvense 8 3 18 1
6 União Barbarense União 6 10 5 11
7 Rio Branco SP Branco 6 9 5 10
8 Independente SP Independente 6 7 10 6
9 XV de Piracicaba Piracicaba 6 3 9 3
10 Capivariano Capivariano 0 0 0 0
11 Ituano Ituano 8 19 7 20
12 Paulista Paulista 8 11 9 13
13 São Bento São Bento 8 11 14 11
14 Primavera SP Primavera 8 7 8 10
15 Grêmio Barueri Grêmio 8 6 16 3
16 Nacional SP Nacional SP 8 15 4 17
17 São Bernardo FC São 8 12 3 16
18 Audax São Paulo Audax São P. 8 6 8 13
19 CA Juventus CA Juventus 8 5 5 9
20 São José São José 8 2 20 1
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Botafogo Botafogo 12 22 7 25
2 Ferroviária Ferroviária 12 19 11 24
3 Comercial Comercial 12 16 13 20
4 Batatais Batatais 12 12 21 15
5 Votuporanguense Votuporangue 12 17 16 13
6 Mirassol Mirassol 12 10 13 12
7 Santacruzense Santacruzens 12 9 24 6
8 RB Brasil RB Brasil 12 22 15 22
9 XV de Piracicaba Piracicaba 12 18 12 21
10 Independente SP Independente 12 13 18 17
11 Inter de Limeira Inter 12 13 12 16
12 Rio Branco SP Branco 12 19 19 15
13 União Barbarense União 12 11 16 15
14 Paulista Paulista 12 12 16 11
15 Santo André Santo André 14 19 13 24
16 São Bento São Bento 14 19 13 24
17 São Bernardo FC São 14 23 10 20
18 Atlético Sorocaba Atlético 14 19 13 20
19 São José São José 14 17 24 19
20 CA Juventus CA Juventus 14 10 9 17
21 Grêmio Osasco Grêmio 14 14 26 17
22 Taubaté Taubaté 14 5 18 6
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Linense CA Linense CA 10 15 10 21
2 Mirassol Mirassol 10 22 10 20
3 Rio Preto Rio Preto 10 11 13 15
4 Monte Azul Monte Azul 10 12 13 12
5 Noroeste Noroeste 10 7 10 9
6 Francana Francana 10 10 21 6
7 Inter de Limeira Inter 12 12 5 21
8 XV de Piracicaba Piracicaba 12 13 8 20
9 Independente SP Independente 12 10 9 19
10 Ferroviária Ferroviária 12 14 13 17
11 São Carlos São Carlos 12 10 13 12
12 Sertãozinho Sertãozinho 12 8 14 11
13 Comercial Comercial 12 8 13 9
14 Ituano Ituano 12 17 7 25
15 São Bento São Bento 12 13 4 23
16 Rio Branco SP Branco 12 13 9 22
17 Grêmio Osasco Grêmio 12 9 9 16
18 Paulista Paulista 12 10 13 10
19 RB Brasil RB Brasil 12 4 11 10
20 União Barbarense União 12 8 21 7
21 CA Juventus CA Juventus 12 16 6 24
22 São Bernardo FC São 12 16 6 24
23 São Caetano São Caetano 12 15 9 22
24 Audax São Paulo Audax São P. 12 13 9 19
25 Santo André Santo André 12 11 11 12
26 Taubaté Taubaté 12 10 12 12
27 CA Joseense CA Joseense 12 3 31 1

  USO DE MEMORIA  
6,698,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5488
Total Execution Time  0.5507
  CADENA URL  
/copa_paulista2023/grupo1/historico
  GET DATOS  
$_GET['/copa_paulista2023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0125  SELECT type FROM routes WHERE alias = 'copa_paulista2023'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_paulista' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1824 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1824 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  SELECT /*53 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 (1268132,573737) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1824 ORDER BY order_id ASC
0.0127  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 = 71629 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1824 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 71629 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.0128  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 = 67670 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.0128  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 = 63661 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.0128  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 = 59705 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.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 `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 = 49616 AND t.round = 10 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 `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 = 43766 AND t.round = 14 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 = 38671 AND t.round = 14 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 `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 = 31265 AND t.round = 14 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 `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 = 16596 AND t.round = 10 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 `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 = 23858 AND t.round = 14 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 `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 = 23874 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 02:44:06' 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=2 AND last_update > '2024-04-30 02:44:06' 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=4 AND last_update > '2024-04-30 02:44:06' 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-04-30 02:44:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1824 AND l.year = 2023
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (71629,73961) 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, e.player_id ASC LIMIT 10
0.0130  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (71629,73961) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (220333,642370,249590,3239108,248770,606750,834741,842925,889489,913332) ORDER BY rp.in_squad = 1 DESC
0.0130  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1824 AND l.year = 2023
0.0135  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (71629,73961) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0133  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (71629,73961) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (21278,136200,212906,320591,628734,633531,912578,3238129,3239108,248943) ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1824 AND l.year = 2023
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (71629,73961) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0138  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (71629,73961) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (21278,70986,136200,248997,272788,276078,320591,347500,363345,468289) ORDER BY rp.in_squad = 1 DESC
0.0174  SELECT *,(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 = 71629 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