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 Sport Recife Sport Recife 9 16 7 21
2 Retro FC Retro FC 9 16 3 20
3 Náutico Náutico 9 12 4 20
4 Santa Cruz Santa Cruz 9 16 7 19
5 Central SC Central SC 9 14 15 12
6 Maguary PE Maguary PE 9 12 10 10
7 Petrolina Petrolina 9 9 10 10
8 Afogados Afogados 9 13 21 10
9 CA Porto CA Porto 9 9 23 3
10 Flamengo Arcoverde Flamengo 9 8 25 1
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Sport Recife Sport Recife 12 29 6 30
2 Retro FC Retro FC 12 24 5 27
3 Náutico Náutico 12 20 8 25
4 Petrolina Petrolina 12 15 12 19
5 Santa Cruz Santa Cruz 12 15 13 18
6 Salgueiro Salgueiro 12 11 11 16
7 CA Porto CA Porto 12 6 5 14
8 Central SC Central SC 12 12 15 14
9 Maguary PE Maguary PE 12 12 14 13
10 Íbis Íbis 12 13 22 12
11 Afogados Afogados 12 13 19 11
12 Belo Jardim FC Belo Jardim 12 9 26 5
13 Caruaru City Caruaru City 12 4 27 2
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Retro FC Retro FC 9 21 7 22
2 Náutico Náutico 9 15 8 17
3 Santa Cruz Santa Cruz 9 19 14 17
4 Sport Recife Sport Recife 9 22 9 16
5 Salgueiro Salgueiro 9 16 11 15
6 Caruaru City Caruaru City 9 14 12 12
7 Afogados Afogados 9 13 18 10
8 Vera Cruz Vera Cruz 9 14 18 6
9 Íbis Íbis 9 4 16 5
10 Sete de Setembro Sete 9 4 29 0
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Náutico Náutico 9 24 11 22
2 Sport Recife Sport Recife 9 16 4 20
3 Salgueiro Salgueiro 9 10 9 14
4 Santa Cruz Santa Cruz 9 12 9 13
5 Afogados Afogados 9 9 7 12
6 Vera Cruz Vera Cruz 9 12 16 11
7 Retro FC Retro FC 9 15 15 10
8 Central SC Central SC 9 8 16 9
9 Sete de Setembro Sete 9 7 12 6
10 Vitória das Tabocas Vitória 9 7 21 5
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Santa Cruz Santa Cruz 9 16 4 25
2 Salgueiro Salgueiro 9 12 9 16
3 Retro FC Retro FC 9 20 10 15
4 Náutico Náutico 9 13 9 15
5 Central SC Central SC 9 10 6 13
6 Afogados Afogados 9 13 13 13
7 Sport Recife Sport Recife 9 10 7 11
8 Petrolina Petrolina 9 6 16 7
9 Decisão Decisão 9 6 24 4
10 Vitória das Tabocas Vitória 9 3 11 2
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Sport Recife Sport Recife 9 21 7 21
2 Náutico Náutico 9 18 8 19
3 Santa Cruz Santa Cruz 9 12 8 17
4 Salgueiro Salgueiro 9 21 15 16
5 Central SC Central SC 9 12 9 16
6 Afogados Afogados 9 13 17 12
7 Vitória das Tabocas Vitória 9 8 14 9
8 Flamengo Arcoverde Flamengo 9 13 19 8
9 Petrolina Petrolina 9 5 13 8
10 América PE América PE 9 3 16 1
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Náutico Náutico 10 17 10 19
2 Central SC Central SC 10 13 6 19
3 Sport Recife Sport Recife 10 13 6 17
4 Salgueiro Salgueiro 10 9 11 14
5 Santa Cruz Santa Cruz 10 9 9 13
6 Vitória das Tabocas Vitória 10 14 17 13
7 América PE América PE 10 15 16 12
8 Afogados Afogados 10 12 13 12
9 Flamengo Arcoverde Flamengo 10 7 8 9
10 Pesqueira Pesqueira 10 5 12 6
11 Belo Jardim FC Belo Jardim 10 9 15 6
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Salgueiro Salgueiro 6 11 3 16
2 Belo Jardim FC Belo Jardim 6 8 4 12
3 Atlético PE Atlético 6 3 7 3
4 Flamengo Arcoverde Flamengo 6 5 4 9
5 Serra Talhada Serra 6 5 8 5
6 América PE América PE 6 4 11 4
7 Central SC Central SC 6 6 1 12
8 Vitória das Tabocas Vitória 6 5 5 8
9 Afogados Afogados 6 2 6 3
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Central SC Central SC 6 8 3 13
2 Atlético PE Atlético 6 4 3 9
3 CA Porto CA Porto 6 5 6 8
4 Belo Jardim FC Belo Jardim 6 3 8 2
5 América PE América PE 6 8 5 12
6 Serra Talhada Serra 6 6 5 9
7 Vitória das Tabocas Vitória 6 6 7 5
8 Pesqueira Pesqueira 6 4 7 5
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Central SC Central SC 14 20 12 25
2 Serra Talhada Serra 14 21 12 23
3 Vera Cruz Vera Cruz 14 12 14 22
4 Atlético PE Atlético 14 19 19 17
5 Pesqueira Pesqueira 14 16 17 17
6 CA Porto CA Porto 14 21 23 17
7 Ypiranga PE Ypiranga PE 14 10 13 14
8 América PE América PE 14 8 17 13
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Salgueiro Salgueiro 16 23 7 36
2 Central SC Central SC 16 29 14 34
3 CA Porto CA Porto 16 16 12 24
4 Serra Talhada Serra 16 18 18 22
5 Vitória das Tabocas Vitória 16 13 15 21
6 Chã Grande Chã Grande 16 15 18 19
7 Pesqueira Pesqueira 16 17 21 16
8 Ypiranga PE Ypiranga PE 16 9 24 14
9 América PE América PE 16 12 23 13
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Náutico Náutico 8 17 8 19
2 Central SC Central SC 8 14 6 19
3 Belo Jardim FC Belo Jardim 8 8 6 14
4 Serra Talhada Serra 8 10 11 13
5 Pesqueira Pesqueira 8 9 7 12
6 Chã Grande Chã Grande 8 6 8 8
7 Ypiranga PE Ypiranga PE 8 5 8 8
8 CA Porto CA Porto 8 1 9 6
9 Petrolina Petrolina 8 3 10 1
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Sport Recife Sport Recife 22 44 22 50
2 Santa Cruz Santa Cruz 22 44 22 44
3 Salgueiro Salgueiro 22 35 19 44
4 Náutico Náutico 22 34 21 38
5 Petrolina Petrolina 22 23 25 32
6 Ypiranga PE Ypiranga PE 22 17 26 29
7 CA Porto CA Porto 22 31 38 27
8 Belo Jardim FC Belo Jardim 22 25 34 27
9 Central SC Central SC 22 25 25 24
10 Serra Talhada Serra 22 25 32 24
11 Araripina FC Araripina 22 24 32 17
12 América PE América PE 22 17 48 11
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Náutico Náutico 22 48 25 47
2 Santa Cruz Santa Cruz 22 37 22 45
3 CA Porto CA Porto 22 39 31 38
4 Sport Recife Sport Recife 22 29 20 37
5 Central SC Central SC 22 34 28 36
6 Salgueiro Salgueiro 22 22 21 30
7 Petrolina Petrolina 22 25 32 27
8 Araripina FC Araripina 22 22 30 24
9 América PE América PE 22 26 35 23
10 Ypiranga PE Ypiranga PE 22 22 30 22
11 AD Cabense AD Cabense 22 20 31 22
12 Vitória das Tabocas Vitória 22 19 38 21
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Sport Recife Sport Recife 22 47 18 51
2 Náutico Náutico 22 43 27 43
3 Santa Cruz Santa Cruz 22 42 29 40
4 Central SC Central SC 22 23 28 34
5 AD Cabense AD Cabense 22 26 27 32
6 CA Porto CA Porto 22 31 40 29
7 Ypiranga PE Ypiranga PE 22 34 30 28
8 Salgueiro Salgueiro 22 32 33 26
9 Araripina FC Araripina 22 28 35 25
10 Vitória das Tabocas Vitória 22 31 42 24
11 Vera Cruz Vera Cruz 22 27 34 20
12 7 de Setembro EC Setembro 22 22 43 16
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Sport Recife Sport Recife 11 26 4 31
2 Santa Cruz Santa Cruz 11 23 14 24
3 Náutico Náutico 11 21 14 22
4 CA Porto CA Porto 11 17 9 16
5 AD Cabense AD Cabense 11 12 10 16
6 Salgueiro Salgueiro 11 13 12 16
7 Central SC Central SC 11 16 14 14
8 7 de Setembro EC Setembro 11 11 11 13
9 Ypiranga PE Ypiranga PE 11 17 27 12
10 Serrano PE Serrano PE 11 9 24 9
11 Petrolina Petrolina 11 15 25 6
12 Vitória das Tabocas Vitória 11 7 23 6
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Sport Recife Sport Recife 6 13 5 14
2 Santa Cruz Santa Cruz 6 10 6 11
3 Serrano PE Serrano PE 6 7 7 11
4 Náutico Náutico 6 11 8 10
5 Central SC Central SC 6 10 8 8
6 Petrolina Petrolina 6 7 6 8
7 Salgueiro Salgueiro 6 5 9 8
8 Ypiranga PE Ypiranga PE 6 10 12 7
9 Centro Limoeirense Centro 6 6 8 7
10 Vera Cruz Vera Cruz 6 7 10 6
11 CA Porto CA Porto 6 4 5 5
12 7 de Setembro EC Setembro 6 4 10 2
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Sport Recife Sport Recife 9 18 3 25
2 CA Porto CA Porto 9 15 13 16
3 Náutico Náutico 9 14 12 15
4 Central SC Central SC 9 10 9 15
5 Ypiranga PE Ypiranga PE 9 10 12 14
6 Vera Cruz Vera Cruz 9 11 11 13
7 Santa Cruz Santa Cruz 9 14 15 11
8 Serrano PE Serrano PE 9 10 12 11
9 AD Cabense AD Cabense 9 7 11 8
10 Belo Jardim FC Belo Jardim 9 7 18 1
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Santa Cruz Santa Cruz 9 15 5 19
2 Ypiranga PE Ypiranga PE 9 15 9 18
3 Sport Recife Sport Recife 9 13 9 17
4 Serrano PE Serrano PE 9 12 12 14
5 Salgueiro Salgueiro 9 10 11 13
6 Central SC Central SC 9 15 13 12
7 Náutico Náutico 9 10 11 10
8 CA Porto CA Porto 9 8 9 9
9 Estudantes SC Estudantes 9 10 12 8
10 Vitória das Tabocas Vitória 9 8 25 4
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Santa Cruz Santa Cruz 9 20 7 20
2 Serrano PE Serrano PE 9 10 5 17
3 Sport Recife Sport Recife 9 11 5 16
4 Vitória das Tabocas Vitória 9 15 11 15
5 Itacuruba SC Itacuruba 9 14 12 14
6 Náutico Náutico 9 21 14 13
7 Ypiranga PE Ypiranga PE 9 12 15 13
8 CA Porto CA Porto 9 11 13 9
9 Petrolina Petrolina 9 6 17 5
10 Manchete FC Manchete FC 9 5 26 1

  USO DE MEMORIA  
6,204,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7970
Total Execution Time  0.7989
  CADENA URL  
/pernambucano_12024/grupo1/historico
  GET DATOS  
$_GET['/pernambucano_12024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0144  SELECT type FROM routes WHERE alias = 'pernambucano_12024'
0.0292  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'pernambucano_1' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=572 AND type_rel = 3
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 572 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0158  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 (1139358,1133222,1118364,972807,867009) ORDER BY n.cover_points DESC, update_date DESC
0.0148  SELECT id,name,alias,stepParent FROM categories WHERE parentId=572 ORDER BY order_id ASC
0.0153  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 = 74862 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0156  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 572 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0158  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 = 74862 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 70751 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 66227 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 61498 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 51982 AND t.round = 9 ORDER BY team.conference ASC,t.position 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 `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 = 48276 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 41764 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 37669 AND t.round = 7 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 `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 = 19977 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 9080 AND t.round = 14 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 `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 = 3534 AND t.round = 18 ORDER BY team.conference 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 `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 = 13737 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0172  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 = 13747 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 13746 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 13745 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 13758 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 13757 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 13756 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 13755 AND t.round = 9 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 `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 = 13754 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-07 07:01:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-07 07:01:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-07 07:01:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-07 07:01:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0153  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'pernambucano_1' 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.0154  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 572 AND l.year = 2024
0.0152  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74862,75484) 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.0158  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 (74862,75484) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (184087,275860,326894,327787,499293,639464,3182415,70455,137842,213059) ORDER BY rp.in_squad = 1 DESC
0.0195  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 572 AND l.year = 2024
0.0183  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74862,75484) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0181  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 (74862,75484) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (589016,474257,638703,906117,3149658,137842,142869,152997,267754,314289) ORDER BY rp.in_squad = 1 DESC
0.0149  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 572 AND l.year = 2024
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74862,75484) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0151  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 (74862,75484) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (137842,212917,272576,275813,361673,1029279,3166881,3271775,3407152) ORDER BY rp.in_squad = 1 DESC
0.0155  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 = 74862 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC