Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Fortaleza Fortaleza 16 23 11 28
2 Deportes Quindío Deportes 16 24 16 28
3 Atlético Huila Atlético 16 32 22 25
4 Barranquilla Barranquilla 16 23 19 25
5 Llaneros Llaneros 16 18 14 25
6 Tigres FC Tigres FC 16 19 19 25
7 Boyacá Chicó Boyacá 16 16 10 24
8 Real Santander Real 16 18 15 24
9 Bogotá Bogotá 16 21 20 23
10 Atlético Fútbol Club Atlético 16 14 18 23
11 Cúcuta Deportivo Cúcuta 16 19 18 22
12 Leones Leones 16 22 24 19
13 Boca Juniors de Cali Boca Juniors 16 17 20 19
14 Real Cartagena Real 16 18 26 16
15 Real Cundinamarca Real 16 18 27 10
16 Orsomarso SC Orsomarso 16 7 30 7
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Leones Leones 14 25 12 29
2 Bogotá Bogotá 14 18 9 28
3 Boyacá Chicó Boyacá 14 15 6 28
4 Fortaleza Fortaleza 14 24 10 26
5 Unión Magdalena Unión 14 24 17 25
6 Internacional de Palmira Internaciona 14 19 13 25
7 Llaneros Llaneros 14 20 15 23
8 Real Cartagena Real 14 17 14 20
9 Atlético Fútbol Club Atlético 14 17 20 19
10 Barranquilla Barranquilla 14 13 19 15
11 Orsomarso SC Orsomarso 14 14 22 15
12 Real Santander Real 14 15 24 10
13 Real Cundinamarca Real 14 13 23 8
14 Boca Juniors de Cali Boca Juniors 14 8 25 7
15 Tigres FC Tigres FC 14 6 19 6
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Fortaleza Fortaleza 0 0 0 0
2 Atlético Huila Atlético 0 0 0 0
3 Internacional de Palmira Internaciona 0 0 0 0
4 Atlético Fútbol Club Atlético 0 0 0 0
5 Barranquilla Barranquilla 0 0 0 0
6 Real Cundinamarca Real 0 0 0 0
7 Llaneros Llaneros 0 0 0 0
8 Tigres FC Tigres FC 0 0 0 0
9 Unión Magdalena Unión 0 0 0 0
10 Deportes Quindío Deportes 0 0 0 0
11 Orsomarso SC Orsomarso 0 0 0 0
12 Boca Juniors de Cali Boca Juniors 0 0 0 0
13 Real Cartagena Real 0 0 0 0
14 Real Santander Real 0 0 0 0
15 Bogotá Bogotá 0 0 0 0
16 Leones Leones 0 0 0 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Deportes Quindío Deportes 15 21 12 29
2 Boyacá Chicó Boyacá 15 25 19 27
3 Bogotá Bogotá 15 19 14 26
4 Internacional de Palmira Internaciona 15 24 19 25
5 Deportivo Pereira Deportivo 15 13 9 25
6 Real Cartagena Real 15 20 19 24
7 Fortaleza Fortaleza 15 18 15 22
8 Tigres FC Tigres FC 15 17 14 21
9 Leones Leones 15 19 17 21
10 Real Santander Real 15 16 17 20
11 Llaneros Llaneros 15 12 15 19
12 Real Cundinamarca Real 15 14 19 19
13 Atlético Fútbol Club Atlético 15 15 13 18
14 Boca Juniors de Cali Boca Juniors 15 15 25 11
15 Barranquilla Barranquilla 15 10 21 11
16 Orsomarso SC Orsomarso 15 13 23 8
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Barranquilla Barranquilla 16 21 10 33
2 Deportivo Pereira Deportivo 16 23 13 30
3 Deportes Quindío Deportes 16 28 19 30
4 Leones Leones 16 20 15 30
5 Cúcuta Deportivo Cúcuta 16 30 20 27
6 Llaneros Llaneros 16 26 23 25
7 Real Cartagena Real 16 20 20 24
8 Orsomarso SC Orsomarso 16 16 14 23
9 Boyacá Chicó Boyacá 16 16 15 23
10 Unión Magdalena Unión 16 20 22 20
11 Atlético Fútbol Club Atlético 16 13 25 18
12 Bogotá Bogotá 16 10 19 14
13 Real Cundinamarca Real 16 14 28 14
14 Real Santander Real 16 21 25 14
15 Fortaleza Fortaleza 16 14 19 12
16 Universitario Popayán Universitari 16 13 18 12
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Jaguares FC Jaguares FC 18 27 18 34
2 Deportivo Pereira Deportivo 18 28 15 33
3 Deportes Quindío Deportes 18 28 17 33
4 Deportivo Rionegro Deportivo 18 26 15 33
5 Unión Magdalena Unión 18 32 20 32
6 Cúcuta Deportivo Cúcuta 18 21 15 32
7 Atlético Bucaramanga Atlético 18 23 19 31
8 América de Cali América 18 25 17 30
9 Real Cartagena Real 18 20 18 30
10 Internacional de Palmira Internaciona 18 21 19 25
11 Real Cundinamarca Real 18 16 18 25
12 Llaneros Llaneros 18 25 25 22
13 Universitario Popayán Universitari 18 17 29 19
14 Real Santander Real 18 17 24 18
15 Tigres FC Tigres FC 18 11 20 13
16 Atlético Fútbol Club Atlético 18 18 35 13
17 Bogotá Bogotá 18 17 29 11
18 Barranquilla Barranquilla 18 11 30 11
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 América de Cali América 18 21 9 33
2 Deportivo Rionegro Deportivo 18 27 23 32
3 Real Cartagena Real 18 40 29 31
4 Internacional de Palmira Internaciona 18 26 20 29
5 Atlético Bucaramanga Atlético 18 19 15 28
6 Fortaleza Fortaleza 18 22 19 28
7 Uniautónoma Uniautónoma 18 24 25 27
8 Jaguares FC Jaguares FC 18 18 19 26
9 Deportivo Pereira Deportivo 18 20 18 24
10 Real Cundinamarca Real 18 22 20 22
11 Llaneros Llaneros 18 17 19 22
12 Atlético Fútbol Club Atlético 18 26 26 21
13 Real Santander Real 18 22 27 21
14 Bogotá Bogotá 18 15 20 21
15 Unión Magdalena Unión 18 19 24 19
16 Tigres FC Tigres FC 18 16 24 18
17 Universitario Popayán Universitari 18 21 34 18
18 Barranquilla Barranquilla 18 24 28 17
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Deportivo Pereira Deportivo 18 37 14 43
2 Alianza FC Alianza FC 18 35 18 34
3 América de Cali América 18 31 18 34
4 Deportivo Rionegro Deportivo 18 25 19 31
5 Universitario Popayán Universitari 18 20 21 30
6 Internacional de Palmira Internaciona 18 27 25 29
7 Uniautónoma Uniautónoma 18 23 20 27
8 Atlético Bucaramanga Atlético 18 22 24 27
9 Real Cundinamarca Real 18 15 12 25
10 Sucre FC Sucre FC 18 19 22 25
11 Bogotá Bogotá 18 22 30 23
12 Unión Magdalena Unión 18 19 20 21
13 Atlético Fútbol Club Atlético 18 22 25 19
14 Fortaleza Fortaleza 18 14 18 19
15 Tigres FC Tigres FC 18 12 18 16
16 Real Santander Real 18 22 31 16
17 Barranquilla Barranquilla 18 22 37 15
18 Llaneros Llaneros 18 11 26 13
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Deportivo Pasto Deportivo 18 32 15 34
2 Centauros Centauros 18 28 25 31
3 Alianza FC Alianza FC 18 24 16 29
4 Bogotá Bogotá 18 26 21 29
5 Deportivo Rionegro Deportivo 18 33 23 28
6 Uniautónoma Uniautónoma 18 33 24 28
7 Tigres FC Tigres FC 18 21 15 28
8 Academia Academia 18 27 24 28
9 Real Santander Real 18 23 19 27
10 Fortaleza Fortaleza 18 20 18 26
11 Atlético Bucaramanga Atlético 18 16 18 23
12 Real Cundinamarca Real 18 22 27 23
13 Unión Magdalena Unión 18 18 22 20
14 Internacional de Palmira Internaciona 18 22 27 20
15 Patriotas Boyacá Patriotas 18 21 25 18
16 Pacífico Pacífico 18 14 28 15
17 Barranquilla Barranquilla 18 12 28 14
18 Atlético Fútbol Club Atlético 18 15 32 12
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Deportivo Pasto Deportivo 18 21 11 39
2 Águilas Doradas Águilas 18 32 18 38
3 Deportivo Rionegro Deportivo 18 35 21 33
4 Bogotá Bogotá 18 28 14 33
5 Atlético Bucaramanga Atlético 18 29 21 31
6 Unión Magdalena Unión 18 21 15 30
7 Patriotas Boyacá Patriotas 18 34 24 29
8 Academia Academia 18 24 21 29
9 Real Santander Real 18 21 23 26
10 Centauros Centauros 18 24 25 24
11 Pacífico Pacífico 18 18 17 23
12 Real Cundinamarca Real 18 20 23 23
13 Tigres FC Tigres FC 18 19 22 23
14 La Sabana La Sabana 18 13 27 15
15 Fortaleza Fortaleza 18 25 45 15
16 Barranquilla Barranquilla 18 14 26 13
17 Atlético Fútbol Club Atlético 18 16 31 13
18 Alianza FC Alianza FC 18 21 31 11
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Águilas Doradas Águilas 18 28 22 33
2 Atlético Bucaramanga Atlético 18 37 21 32
3 Bogotá Bogotá 18 28 17 28
4 Real Santander Real 18 21 21 26
5 Patriotas Boyacá Patriotas 18 23 24 24
6 Barranquilla Barranquilla 18 20 21 23
7 Real Cundinamarca Real 18 14 28 20
8 Sucre FC Sucre FC 18 17 29 19
9 Atlético Fútbol Club Atlético 18 21 26 17
10 Centauros Centauros 18 27 17 31
11 La Sabana La Sabana 18 30 21 30
12 Unión Magdalena Unión 18 34 19 29
13 Deportivo Rionegro Deportivo 18 22 21 28
14 Fortaleza Fortaleza 18 20 22 27
15 Tigres FC Tigres FC 18 18 16 26
16 Academia Academia 18 27 25 25
17 Internacional de Palmira Internaciona 18 21 22 23
18 Alianza FC Alianza FC 18 7 43 4
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Academia Academia 18 24 16 32
2 Deportivo Rionegro Deportivo 18 23 18 31
3 Unión Magdalena Unión 18 19 14 28
4 Real Cartagena Real 18 19 17 28
5 Tigres FC Tigres FC 18 15 18 27
6 Águilas Doradas Águilas 18 12 11 25
7 Internacional de Palmira Internaciona 18 22 21 21
8 Real Santander Real 18 15 20 19
9 Centauros Centauros 18 13 25 11
10 Atlético Fútbol Club Atlético 18 19 21 28
11 Barranquilla Barranquilla 18 28 21 27
12 Real Cundinamarca Real 18 25 22 26
13 Patriotas Boyacá Patriotas 18 18 19 25
14 Bogotá Bogotá 18 24 23 24
15 Sucre FC Sucre FC 18 24 24 24
16 Fortaleza Fortaleza 18 14 19 22
17 La Sabana La Sabana 18 17 19 21
18 Alianza FC Alianza FC 18 17 20 18
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Deportivo Rionegro Deportivo 18 25 14 35
2 Academia Academia 18 25 16 28
3 Unión Magdalena Unión 18 23 16 28
4 Sucre FC Sucre FC 18 14 14 24
5 Águilas Doradas Águilas 18 21 22 23
6 Internacional de Palmira Internaciona 18 21 25 23
7 La Sabana La Sabana 18 21 23 22
8 Centauros Centauros 18 16 22 20
9 Alianza FC Alianza FC 18 10 25 12
10 Bogotá Bogotá 18 22 14 29
11 Envigado Envigado 18 16 10 29
12 Atlético Fútbol Club Atlético 18 19 17 28
13 Patriotas Boyacá Patriotas 18 27 20 26
14 Tigres FC Tigres FC 18 21 18 25
15 Real Cundinamarca Real 18 19 21 25
16 Barranquilla Barranquilla 18 23 34 21
17 Atlético Bello Atlético 18 18 20 20
18 Real Santander Real 18 14 24 17
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Internacional de Palmira Internaciona 18 31 14 40
2 La Equidad La Equidad 18 30 19 35
3 Centauros Centauros 18 28 17 34
4 Barranquilla Barranquilla 18 39 26 33
5 Deportivo Rionegro Deportivo 18 24 17 29
6 Pumas de Casanare Pumas 18 28 22 29
7 Real Cundinamarca Real 18 23 18 28
8 Academia Academia 18 22 21 25
9 Águilas Doradas Águilas 18 28 25 23
10 Unión Magdalena Unión 18 23 29 23
11 Patriotas Boyacá Patriotas 18 21 21 21
12 Atlético Fútbol Club Atlético 18 17 25 21
13 Bogotá Bogotá 18 22 26 20
14 Alianza FC Alianza FC 18 16 26 19
15 La Sabana La Sabana 18 16 33 19
16 Sucre FC Sucre FC 18 25 25 18
17 Atlético Bello Atlético 18 19 35 13
18 Tigres FC Tigres FC 18 16 29 11
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,920,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.2081
Total Execution Time  0.2100
  CADENA URL  
/clausura_primera_b_colombia2022/grupo1/historico
  GET DATOS  
$_GET['/clausura_primera_b_colombia2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'clausura_primera_b_colombia2022'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_primera_b_colombia' 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=197 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 197 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1078402,1077594,1077298,1076577,1027676) ORDER BY n.cover_points DESC, update_date DESC
0.0022  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=196 ORDER BY l.group_code ASC
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=196 ORDER BY order_id ASC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 197 GROUP BY l.categoryId
0.0019  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=197 GROUP BY l.year ORDER BY l.year DESC
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 = 66315 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 197 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 66315 AND t.round = 16 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 = 63326 AND t.round = 15 ORDER BY team.conference ASC,t.position 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 `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 = 53812 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.0029  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 = 48674 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 38802 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 3209 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 2622 AND t.round = 18 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 `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 = 1662 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 1392 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 9747 AND t.round = 18 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 `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 = 13588 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0352  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 = 13582 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 13576 AND t.round = 18 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 `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 = 13570 AND t.round = 18 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-03-28 18:39:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 18:39:11' 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-03-28 18:39:11' 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-03-28 18:39:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_primera_b_colombia' 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.0180  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 = 66315 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66315 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.0377  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 = 66315 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66315 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0034  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 = 66315 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66315 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  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 = 66315 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC