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 Paysandu Paysandu 8 14 6 17
2 Aguia de Maraba Aguia Maraba 8 10 9 12
3 Paragominas Paragominas 8 8 10 7
4 Amazonia Independiente Amazonia 8 4 9 5
5 Tuna Luso Tuna Luso 8 8 10 11
6 Bragantino PA Bragantino 8 11 13 10
7 Tapajós Tapajós 8 6 7 9
8 Itupiranga Itupiranga 8 10 17 8
9 Remo Remo 8 9 4 14
10 Castanhal Castanhal 8 10 5 13
11 SE Caete SE Caete 8 8 9 13
12 Independiente PA Independient 8 9 8 11
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Paysandu Paysandu 8 12 6 19
2 Itupiranga Itupiranga 8 4 5 11
3 Bragantino PA Bragantino 8 15 16 8
4 Gavião Gavião 8 8 21 3
5 Remo Remo 8 18 9 20
6 Tuna Luso Tuna Luso 8 20 13 12
7 Tapajós Tapajós 8 7 9 7
8 Carajas Carajas 8 5 11 5
9 Independente AC Independente 8 10 6 13
10 Castanhal Castanhal 8 11 9 11
11 Aguia de Maraba Aguia Maraba 8 6 7 8
12 Paragominas Paragominas 8 10 14 7
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Remo Remo 10 16 8 23
2 Castanhal Castanhal 10 21 15 20
3 Paragominas Paragominas 10 17 16 16
4 Bragantino PA Bragantino 10 10 10 16
5 Itupiranga Itupiranga 10 10 16 11
6 Paysandu Paysandu 10 25 7 25
7 Aguia de Maraba Aguia Maraba 10 11 16 11
8 Independiente PA Independient 10 10 14 10
9 Tapajós Tapajós 10 11 14 8
10 Carajas Carajas 10 8 23 2
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Remo Remo 10 15 6 19
2 Paragominas Paragominas 10 14 13 16
3 Bragantino PA Bragantino 10 14 11 15
4 Castanhal Castanhal 10 5 7 11
5 São Francisco PA São 10 13 24 6
6 Paysandu Paysandu 10 18 4 22
7 Independiente PA Independient 10 11 10 17
8 Aguia de Maraba Aguia Maraba 10 11 11 13
9 Tapajós Tapajós 10 8 13 8
10 SAO Raimundo EC Raimundo 10 8 18 4
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Paysandu Paysandu 10 17 8 20
2 Bragantino PA Bragantino 10 17 15 19
3 Independiente PA Independient 10 12 14 13
4 Aguia de Maraba Aguia Maraba 10 7 14 11
5 Cametá Cametá 10 10 18 4
6 Remo Remo 10 17 9 22
7 SAO Raimundo EC Raimundo 10 15 12 16
8 Castanhal Castanhal 10 16 17 13
9 Paragominas Paragominas 10 12 12 11
10 Parauapebas Parauapebas 10 9 13 8
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Paysandu Paysandu 10 17 5 20
2 SAO Raimundo EC Raimundo 10 15 9 17
3 Cametá Cametá 10 6 16 9
4 Paragominas Paragominas 10 12 18 8
5 Pinheirense Pinheirense 10 6 18 5
6 Remo Remo 10 18 7 22
7 Independente AC Independente 10 16 11 18
8 Aguia de Maraba Aguia Maraba 10 14 10 15
9 Castanhal Castanhal 10 12 11 15
10 São Francisco PA São 10 6 17 7
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Remo Remo 4 10 6 9
2 Aguia de Maraba Aguia Maraba 4 8 6 7
3 São Francisco PA São 4 5 3 7
4 Cametá Cametá 4 4 7 3
5 Parauapebas Parauapebas 4 3 8 3
6 Paysandu Paysandu 4 13 3 12
7 Independiente PA Independient 4 7 6 7
8 SAO Raimundo EC Raimundo 4 9 11 5
9 Paragominas Paragominas 4 6 10 3
10 Tapajós Tapajós 4 5 10 1
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Independiente PA Independient 4 6 3 9
2 Parauapebas Parauapebas 4 6 3 9
3 São Francisco PA São 4 6 6 5
4 Remo Remo 4 3 4 4
5 Castanhal Castanhal 4 3 8 1
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Paysandu Paysandu 7 16 8 13
2 Remo Remo 7 12 6 13
3 Cametá Cametá 7 7 5 11
4 Paragominas Paragominas 7 9 8 10
5 Independente AC Independente 7 5 6 8
6 São Francisco PA São 7 6 11 8
7 Gavião Gavião 7 6 11 5
8 Santa Cruz PA Santa Cruz 7 7 13 3
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Remo Remo 7 15 8 19
2 Paysandu Paysandu 7 19 10 16
3 São Francisco PA São 7 14 12 11
4 Paragominas Paragominas 7 11 10 11
5 Cametá Cametá 7 6 7 7
6 Santa Cruz PA Santa Cruz 7 6 9 7
7 Aguia de Maraba Aguia Maraba 7 7 12 6
8 Tuna Luso Tuna Luso 7 1 11 1
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Aguia de Maraba Aguia Maraba 7 10 7 13
2 Cametá Cametá 7 8 6 11
3 Tuna Luso Tuna Luso 7 10 9 10
4 Remo Remo 7 6 8 10
5 São Francisco PA São 7 10 10 9
6 Paysandu Paysandu 7 9 9 9
7 SAO Raimundo EC Raimundo 7 8 9 9
8 Independiente PA Independient 7 7 10 5
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Remo Remo 7 12 3 17
2 Paysandu Paysandu 7 21 15 15
3 Independiente PA Independient 7 12 10 9
4 Tuna Luso Tuna Luso 7 7 8 8
5 Cametá Cametá 7 17 19 8
6 Aguia de Maraba Aguia Maraba 7 9 13 6
7 Castanhal Castanhal 7 9 14 6
8 SAO Raimundo EC Raimundo 7 9 14 6
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Remo Remo 7 21 9 17
2 Independiente PA Independient 7 15 11 13
3 Paysandu Paysandu 7 10 9 10
4 SAO Raimundo EC Raimundo 7 8 9 8
5 Santa Rosa EC Santa Rosa 7 5 9 8
6 Cametá Cametá 7 6 7 7
7 Aguia de Maraba Aguia Maraba 7 15 16 6
8 Ananindeua Ananindeua 7 10 20 6
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Paysandu Paysandu 7 18 8 17
2 SAO Raimundo EC Raimundo 7 13 7 13
3 Remo Remo 7 12 13 11
4 Castanhal Castanhal 7 12 11 10
5 Aguia de Maraba Aguia Maraba 7 12 12 10
6 CA Vila Rica Vila Rica 7 9 10 8
7 Ananindeua Ananindeua 7 9 12 5
8 Time Negra Time Negra 7 7 19 4
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Paysandu Paysandu 9 19 7 21
2 Ananindeua Ananindeua 9 14 8 18
3 Castanhal Castanhal 9 14 9 18
4 Aguia de Maraba Aguia Maraba 9 16 7 16
5 CA Vila Rica Vila Rica 9 17 11 16
6 Tiradentes PA Tiradentes 9 12 13 14
7 Remo Remo 9 6 6 11
8 Tuna Luso Tuna Luso 9 8 15 8
9 Pedreira EC Pedreira EC 9 9 23 7
10 SAO Raimundo EC Raimundo 9 9 25 0
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Ananindeua Ananindeua 9 15 10 19
2 Tuna Luso Tuna Luso 9 10 4 18
3 Remo Remo 9 20 6 17
4 Paysandu Paysandu 9 15 11 15
5 Abaeté Abaeté 9 10 9 14
6 Aguia de Maraba Aguia Maraba 9 12 9 13
7 Castanhal Castanhal 9 10 12 12
8 Bragantino PA Bragantino 9 6 14 8
9 Pedreira EC Pedreira EC 9 6 14 5
10 Vênus AC Vênus AC 9 9 24 2
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Paysandu Paysandu 7 17 13 11
2 Abaeté Abaeté 7 14 11 11
3 Castanhal Castanhal 7 13 15 8
4 Aguia de Maraba Aguia Maraba 7 10 17 7
5 Remo Remo 7 18 5 19
6 Ananindeua Ananindeua 7 10 9 9
7 SAO Raimundo EC Raimundo 7 12 15 6
8 Vênus AC Vênus AC 7 7 16 5
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Remo Remo 7 14 12 10
2 SAO Raimundo EC Raimundo 7 10 8 10
3 Castanhal Castanhal 7 9 10 8
4 Pedreira EC Pedreira EC 7 11 16 7
5 Paysandu Paysandu 7 14 8 15
6 Aguia de Maraba Aguia Maraba 7 8 4 14
7 Abaeté Abaeté 7 11 13 9
8 Ananindeua Ananindeua 7 8 14 5

  USO DE MEMORIA  
5,936,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1163
Total Execution Time  0.1183
  CADENA URL  
/paraense2022/grupo1/historico
  GET DATOS  
$_GET['/paraense2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0017  SELECT type FROM routes WHERE alias = 'paraense2022'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'paraense' 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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1517 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1517 ORDER BY order_id ASC
0.0020  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 = 66193 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1517 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 66193 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 60890 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 53522 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.0022  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 = 48603 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 41877 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 37541 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 20283 AND t.round = 5 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 `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 = 9152 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 14247 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 14243 AND t.round = 7 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 `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 = 14239 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 14235 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 14231 AND t.round = 7 ORDER BY team.conference 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 `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 = 14227 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 14223 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 14219 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 14215 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 14211 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 17:42:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-24 17:42:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-24 17:42:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-24 17:42:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'paraense' 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.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1517 AND l.year = 2022
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (66193,67024) 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.0027  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 (66193,67024) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (274873,317457,17870,272711,845613,216991,627143,361171,3149364,3259505) ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1517 AND l.year = 2022
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (66193,67024) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0027  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 (66193,67024) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (978821) ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1517 AND l.year = 2022
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (66193,67024) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0020  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 (66193,67024) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (8338,429365,435803) ORDER BY rp.in_squad = 1 DESC
0.0029  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 = 66193 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC