4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 CD Marathón Marathón 14 24 11 26
2 CDyS Vida CDyS Vida 14 25 18 21
3 CD Platense CD Platense 14 18 25 17
4 Real España Real España 14 18 18 16
5 Honduras Progreso Honduras 14 12 37 10
6 CD Olimpia CD Olimpia 14 30 9 34
7 FC Motagua FC Motagua 14 33 10 32
8 Lobos de la UPNFM Lobos UPNFM 14 20 20 18
9 Real de Minas Real Minas 14 18 24 12
10 CD Real Sociedad Real 14 12 38 5
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 CD Olimpia CD Olimpia 18 37 12 44
2 CD Marathón Marathón 18 39 17 40
3 FC Motagua FC Motagua 18 26 21 31
4 Lobos de la UPNFM Lobos UPNFM 18 24 23 26
5 CDyS Vida CDyS Vida 18 24 24 25
6 Real de Minas Real Minas 18 25 29 23
7 Real España Real España 18 26 25 22
8 CD Platense CD Platense 18 28 36 21
9 CD Real Sociedad Real 18 12 30 10
10 Honduras Progreso Honduras 18 12 36 10
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 FC Motagua FC Motagua 18 28 11 37
2 CD Olimpia CD Olimpia 18 25 17 32
3 Lobos de la UPNFM Lobos UPNFM 18 25 20 30
4 CD Marathón Marathón 18 28 22 28
5 Real España Real España 18 31 25 26
6 CD Platense CD Platense 18 21 18 24
7 Honduras Progreso Honduras 18 27 31 22
8 CDyS Vida CDyS Vida 18 21 24 19
9 Juticalpa Juticalpa 18 19 34 15
10 Real de Minas Real Minas 18 15 38 11
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 CD Marathón Marathón 18 27 21 34
2 FC Motagua FC Motagua 18 31 21 33
3 CD Olimpia CD Olimpia 18 27 15 31
4 Real España Real España 18 31 25 29
5 Juticalpa Juticalpa 18 39 30 28
6 Lobos de la UPNFM Lobos UPNFM 18 22 28 24
7 CD Real Sociedad Real 18 22 28 22
8 CDyS Vida CDyS Vida 18 20 23 21
9 CD Platense CD Platense 18 20 37 19
10 Honduras Progreso Honduras 18 26 37 13
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 CD Olimpia CD Olimpia 18 35 21 39
2 CD Platense CD Platense 18 37 26 32
3 Real España Real España 18 31 22 31
4 FC Motagua FC Motagua 18 30 24 28
5 CD Real Sociedad Real 18 23 24 24
6 Honduras Progreso Honduras 18 23 31 24
7 CD Marathón Marathón 18 22 22 24
8 Juticalpa Juticalpa 18 24 26 18
9 CDyS Vida CDyS Vida 18 13 25 15
10 Social Sol Social Sol 18 12 29 9
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Honduras Progreso Honduras 18 31 21 36
2 FC Motagua FC Motagua 18 41 25 32
3 CD Olimpia CD Olimpia 18 32 25 26
4 CDyS Vida CDyS Vida 18 19 24 26
5 CD Marathón Marathón 18 19 20 24
6 CD Real Sociedad Real 18 26 22 23
7 CD Platense CD Platense 18 20 20 22
8 Juticalpa Juticalpa 18 19 22 22
9 CD Victoria CD Victoria 18 20 35 19
10 Real España Real España 18 26 39 15
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Real España Real España 18 30 28 29
2 CD Olimpia CD Olimpia 18 36 22 28
3 FC Motagua FC Motagua 18 30 25 28
4 Honduras Progreso Honduras 18 34 31 28
5 CD Real Sociedad Real 18 25 18 27
6 CD Platense CD Platense 18 27 27 24
7 CD Marathón Marathón 18 20 25 22
8 CDyS Vida CDyS Vida 18 26 30 21
9 Parrillas One Parrillas 18 28 38 18
10 CD Victoria CD Victoria 18 22 34 16
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 CD Real Sociedad Real 18 29 21 30
2 Real España Real España 18 33 26 29
3 CD Olimpia CD Olimpia 18 31 24 28
4 Deportes Savio Deportes 18 25 30 25
5 CD Platense CD Platense 18 24 23 24
6 Parrillas One Parrillas 18 26 27 24
7 CD Victoria CD Victoria 18 25 26 24
8 CDyS Vida CDyS Vida 18 28 32 23
9 FC Motagua FC Motagua 18 25 27 21
10 CD Marathón Marathón 18 20 30 17
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 CD Olimpia CD Olimpia 18 32 10 39
2 CD Victoria CD Victoria 18 22 12 31
3 FC Motagua FC Motagua 18 21 15 26
4 CD Marathón Marathón 18 20 26 23
5 Choloma Choloma 18 29 28 22
6 Real España Real España 18 21 22 21
7 CDyS Vida CDyS Vida 18 24 35 21
8 CD Platense CD Platense 18 15 22 20
9 Deportes Savio Deportes 18 16 23 19
10 CD Real Sociedad Real 18 13 20 17
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Real España Real España 18 25 13 34
2 CD Marathón Marathón 18 32 19 31
3 CD Olimpia CD Olimpia 18 16 11 26
4 CDyS Vida CDyS Vida 18 19 21 26
5 Deportes Savio Deportes 18 22 25 24
6 Club Necaxa Club Necaxa 18 16 20 23
7 FC Motagua FC Motagua 18 20 19 22
8 CD Platense CD Platense 18 14 23 21
9 CD Victoria CD Victoria 18 21 25 19
10 Choloma Choloma 18 18 27 18
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 CD Victoria CD Victoria 18 26 24 32
2 CD Marathón Marathón 18 26 18 31
3 Real España Real España 18 28 22 29
4 CD Olimpia CD Olimpia 18 29 19 28
5 CD Platense CD Platense 18 20 22 26
6 CDyS Vida CDyS Vida 18 26 23 25
7 FC Motagua FC Motagua 18 21 25 21
8 Deportes Savio Deportes 18 22 30 21
9 Club Necaxa Club Necaxa 18 18 19 19
10 Hispano FC Hispano FC 18 17 31 13
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 CD Marathón Marathón 18 32 16 38
2 FC Motagua FC Motagua 18 31 14 35
3 CD Olimpia CD Olimpia 18 29 16 30
4 Real España Real España 18 26 20 30
5 CD Victoria CD Victoria 18 22 27 26
6 CD Platense CD Platense 18 23 25 24
7 CDyS Vida CDyS Vida 18 22 33 18
8 Deportes Savio Deportes 18 13 23 17
9 Hispano FC Hispano FC 18 17 28 15
10 CD Real Juventud Real 18 19 32 13
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Real CD España Real España 18 33 18 36
2 CD Marathón Marathón 18 26 20 32
3 FC Motagua FC Motagua 18 24 21 30
4 Deportes Savio Deportes 18 24 19 29
5 CD Olimpia CD Olimpia 18 19 17 29
6 Hispano FC Hispano FC 18 30 28 25
7 CD Platense CD Platense 18 22 24 23
8 CD Victoria CD Victoria 18 22 27 22
9 CD Real Juventud Real 18 13 24 12
10 CDyS Vida CDyS Vida 18 10 25 9
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 CD Marathón Marathón 18 27 16 35
2 FC Motagua FC Motagua 18 28 19 32
3 CD Victoria CD Victoria 18 22 12 31
4 CD Olimpia CD Olimpia 18 19 13 27
5 Deportes Savio Deportes 18 14 15 22
6 Real CD España Real España 18 22 25 22
7 Hispano FC Hispano FC 18 19 22 21
8 CDyS Vida CDyS Vida 18 18 22 20
9 CD Platense CD Platense 18 17 28 15
10 Atlético Olanchano Atlético 18 15 29 13
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 CD Olimpia CD Olimpia 18 26 14 35
2 FC Motagua FC Motagua 18 27 22 31
3 Hispano FC Hispano FC 18 25 14 30
4 CD Marathón Marathón 18 30 20 30
5 CD Platense CD Platense 18 32 29 29
6 Atlético Olanchano Atlético 18 24 25 23
7 Real CD España Real España 18 18 20 21
8 CD Victoria CD Victoria 18 21 28 19
9 Broncos del Sur Broncos 18 17 26 14
10 CDyS Vida CDyS Vida 18 17 39 11
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 CD Olimpia CD Olimpia 18 38 17 37
2 CD Victoria CD Victoria 18 30 27 30
3 CD Marathón Marathón 18 30 26 29
4 CD Platense CD Platense 18 28 34 27
5 Universidad NAH Universidad 18 19 21 24
6 Real España Real España 18 23 23 23
7 Hispano FC Hispano FC 18 21 21 22
8 Municipal Valencia Municipal 18 15 22 20
9 CDyS Vida CDyS Vida 18 22 25 18
10 FC Motagua FC Motagua 18 16 26 14
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 CD Olimpia CD Olimpia 18 39 17 39
2 CD Marathón Marathón 18 23 17 34
3 Real España Real España 18 23 12 31
4 CD Victoria CD Victoria 18 32 26 31
5 CDyS Vida CDyS Vida 18 20 23 22
6 CD Platense CD Platense 18 21 28 21
7 Atlético Olanchano Atlético 18 23 27 20
8 Municipal Valencia Municipal 18 17 25 19
9 FC Motagua FC Motagua 18 20 25 18
10 Universidad NAH Universidad 18 12 30 10
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 CD Olimpia CD Olimpia 18 40 7 43
2 Real España Real España 18 36 23 35
3 CDyS Vida CDyS Vida 18 24 20 29
4 CD Marathón Marathón 18 21 16 28
5 FC Motagua FC Motagua 18 22 22 24
6 CD Platense CD Platense 18 20 23 22
7 Universidad NAH Universidad 18 14 20 21
8 CD Victoria CD Victoria 18 19 29 16
9 Atlético Olanchano Atlético 18 20 31 15
10 Real Maya Real Maya 18 15 40 10
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 CD Platense CD Platense 18 42 14 41
2 CD Olimpia CD Olimpia 17 24 16 30
3 CD Marathón Marathón 17 21 15 27
4 Real España Real España 18 25 18 26
5 FC Motagua FC Motagua 18 24 23 26
6 Universidad NAH Universidad 17 19 25 19
7 CDyS Vida CDyS Vida 18 19 29 19
8 Honduras Salzburg Honduras 18 19 22 18
9 CD Victoria CD Victoria 18 15 26 12
10 Real Maya Real Maya 17 10 30 9
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 FC Motagua FC Motagua 18 22 13 32
2 CD Marathón Marathón 18 28 22 31
3 CD Platense CD Platense 18 16 14 27
4 CD Olimpia CD Olimpia 18 25 18 25
5 Real España Real España 18 21 15 24
6 CD Victoria CD Victoria 18 28 26 24
7 CDyS Vida CDyS Vida 18 20 23 20
8 Hispano FC Hispano FC 18 22 27 19
9 Universidad NAH Universidad 18 20 31 15
10 Deportes Savio Deportes 18 19 32 12
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 CD Olimpia CD Olimpia 18 44 21 39
2 FC Motagua FC Motagua 18 20 15 29
3 CD Platense CD Platense 18 30 21 28
4 Real España Real España 18 21 24 24
5 Universidad NAH Universidad 18 17 21 24
6 CDyS Vida CDyS Vida 18 22 24 23
7 CD Victoria CD Victoria 18 24 24 21
8 Deportes Savio Deportes 18 24 24 21
9 CD Marathón Marathón 18 20 25 18
10 Broncos del Sur Broncos 18 9 32 15

  USO DE MEMORIA  
6,445,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6056
Total Execution Time  0.6075
  CADENA URL  
/apertura_honduras2021/grupo1/historico
  GET DATOS  
$_GET['/apertura_honduras2021/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0125  SELECT type FROM routes WHERE alias = 'apertura_honduras2021'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_honduras' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 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=67 AND type_rel = 3
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 67 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1267531,1252991,1233580,1224075,1222817) ORDER BY n.cover_points DESC, update_date DESC
0.0126  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 = 58607 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 67 AND group_code = 1 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0127  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 = 58607 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 50706 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 44320 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 38699 AND t.round = 18 ORDER BY team.conference 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 `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 = 33807 AND t.round = 18 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 `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 = 15504 AND t.round = 18 ORDER BY team.conference 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 `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 = 4002 AND t.round = 18 ORDER BY team.conference 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 `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 = 3258 AND t.round = 18 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 `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 = 2237 AND t.round = 18 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 `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 = 1605 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 1132 AND t.round = 18 ORDER BY team.conference 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 `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 = 1010 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 275 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 15658 AND t.round = 18 ORDER BY team.conference 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 `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 = 15659 AND t.round = 18 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 `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 = 20836 AND t.round = 18 ORDER BY team.conference 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 `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 = 20837 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 `tables2004` 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 = 20838 AND t.round = 18 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 `tables2003` 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 = 20839 AND t.round = 18 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 `tables2002` 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 = 20840 AND t.round = 18 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 `tables2001` 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 = 20841 AND t.round = 18 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-27 06:14:53' 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-27 06:14:53' 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=4 AND last_update > '2024-04-27 06:14:53' 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-27 06:14:53' 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 = 'apertura_honduras' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0156  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 events2021 e ON e.player_id = p.id AND e.league_id = 58607 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58607 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.0204  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 events2021 e ON e.player_id = p.id AND e.league_id = 58607 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58607 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0132  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 events2021 e ON e.player_id = p.id AND e.league_id = 58607 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58607 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  SELECT *,(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 = 58607 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC