4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2022
Temporada Siguiente »
Apertura Primera B Colombia 2022
2021/2022

torneo aguila apertura, apertura torneo aguila, primera b apertura, apertura primera b colombia, primera b colombiana apertura, segunda colombia apertura, segunda colombiana apertura,b colombiana

Apertura Primera B Colombia 2022

  • Leones
  • Fortaleza
  • Deportes Quindío
  • Real Cartagena
  • Tigres FC
  • Boyacá Chicó
  • Llaneros
  • Bogotá
  • Real Cundinamarca
  • Orsomarso SC
  • Atlético Fútbol Club
  • Real Santander
  • Barranquilla
  • Atlético Huila
  • Boca Juniors de Cali
  • Primera B
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Leones Leones 14 21 10 27
2 Fortaleza Fortaleza 14 26 17 25
3 Deportes Quindío Deportes 14 17 8 25
4 Real Cartagena Real 14 19 16 25
5 Tigres FC Tigres FC 14 16 12 22
6 Boyacá Chicó Boyacá 14 18 16 22
7 Llaneros Llaneros 14 14 12 22
8 Bogotá Bogotá 14 17 16 22
9 Real Cundinamarca Real 14 15 12 21
10 Orsomarso SC Orsomarso 14 14 20 18
11 Atlético Fútbol Club Atlético 14 10 14 14
12 Real Santander Real 14 13 21 11
13 Barranquilla Barranquilla 14 13 23 10
14 Atlético Huila Atlético 14 7 14 9
15 Boca Juniors de Cali Boca Juniors 14 10 19 8
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Atlético Huila Atlético 15 27 14 30
2 Unión Magdalena Unión 15 20 10 30
3 Deportes Quindío Deportes 15 16 11 25
4 Leones Leones 15 19 15 25
5 Internacional de Palmira Internaciona 15 16 12 23
6 Real Cundinamarca Real 15 25 19 22
7 Fortaleza Fortaleza 15 26 22 22
8 Atlético Fútbol Club Atlético 15 17 14 20
9 Real Cartagena Real 15 21 23 20
10 Orsomarso SC Orsomarso 15 23 24 19
11 Tigres FC Tigres FC 15 10 12 17
12 Llaneros Llaneros 15 11 17 15
13 Boca Juniors de Cali Boca Juniors 15 12 19 15
14 Bogotá Bogotá 15 17 34 15
15 Barranquilla Barranquilla 15 9 17 13
16 Real Santander Real 15 14 20 11
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Internacional de Palmira Internaciona 17 27 14 33
2 Unión Magdalena Unión 17 28 17 32
3 Deportes Quindío Deportes 17 28 13 30
4 Bogotá Bogotá 17 26 20 30
5 Real Cundinamarca Real 17 16 13 30
6 Llaneros Llaneros 17 22 15 28
7 Atlético Huila Atlético 17 20 19 28
8 Leones Leones 17 26 16 27
9 Fortaleza Fortaleza 17 23 21 24
10 Real Santander Real 17 19 24 20
11 Orsomarso SC Orsomarso 17 17 22 20
12 Boca Juniors de Cali Boca Juniors 17 15 21 19
13 Atlético Fútbol Club Atlético 17 12 27 13
14 Tigres FC Tigres FC 17 12 20 12
15 Real Cartagena Real 17 8 22 12
16 Barranquilla Barranquilla 17 9 24 11
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Real Cartagena Real 15 26 15 29
2 Deportes Quindío Deportes 15 23 12 29
3 Deportivo Pereira Deportivo 15 26 10 28
4 Barranquilla Barranquilla 15 20 15 26
5 Boyacá Chicó Boyacá 15 16 10 25
6 Internacional de Palmira Internaciona 15 26 22 24
7 Leones Leones 15 16 12 24
8 Llaneros Llaneros 15 26 24 23
9 Bogotá Bogotá 15 16 19 22
10 Tigres FC Tigres FC 15 20 24 20
11 Fortaleza Fortaleza 15 21 22 19
12 Real Cundinamarca Real 15 13 20 14
13 Universitario Popayán Universitari 15 12 20 12
14 Real Santander Real 15 13 24 10
15 Atlético Fútbol Club Atlético 15 9 25 8
16 Orsomarso SC Orsomarso 15 16 25 7
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Deportivo Pereira Deportivo 16 23 10 35
2 Deportes Quindío Deportes 16 23 11 29
3 Real Santander Real 16 18 10 28
4 Llaneros Llaneros 16 19 15 27
5 Boyacá Chicó Boyacá 16 20 18 27
6 Leones Leones 16 23 16 26
7 Cúcuta Deportivo Cúcuta 16 21 14 26
8 Orsomarso SC Orsomarso 16 17 14 26
9 Barranquilla Barranquilla 16 20 20 23
10 Fortaleza Fortaleza 16 15 16 21
11 Universitario Popayán Universitari 16 15 17 17
12 Real Cundinamarca Real 16 18 24 16
13 Unión Magdalena Unión 16 19 31 14
14 Bogotá Bogotá 16 15 27 14
15 Real Cartagena Real 16 16 25 13
16 Atlético Fútbol Club Atlético 16 13 27 12
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Atlético Bucaramanga Atlético 18 22 12 34
2 Llaneros Llaneros 18 23 15 33
3 América de Cali América 18 24 15 32
4 Jaguares FC Jaguares FC 18 26 20 31
5 Deportes Quindío Deportes 18 23 13 30
6 Cúcuta Deportivo Cúcuta 18 20 18 30
7 Deportivo Rionegro Deportivo 18 30 25 29
8 Unión Magdalena Unión 18 21 22 28
9 Real Cundinamarca Real 18 29 18 27
10 Real Cartagena Real 18 24 17 27
11 Universitario Popayán Universitari 18 25 25 26
12 Barranquilla Barranquilla 18 18 22 22
13 Real Santander Real 18 21 28 22
14 Internacional de Palmira Internaciona 18 21 26 19
15 Bogotá Bogotá 18 15 27 17
16 Tigres FC Tigres FC 18 17 28 14
17 Deportivo Pereira Deportivo 18 18 33 13
18 Atlético Fútbol Club Atlético 18 17 30 12
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 América de Cali América 18 31 8 39
2 Uniautónoma Uniautónoma 18 34 20 32
3 Bogotá Bogotá 18 32 23 30
4 Llaneros Llaneros 18 20 17 30
5 Deportivo Rionegro Deportivo 18 31 28 29
6 Internacional de Palmira Internaciona 18 25 23 29
7 Unión Magdalena Unión 18 22 20 29
8 Real Cundinamarca Real 18 29 13 28
9 Atlético Fútbol Club Atlético 18 20 23 28
10 Atlético Bucaramanga Atlético 18 23 22 26
11 Jaguares FC Jaguares FC 18 21 24 25
12 Real Cartagena Real 18 25 19 24
13 Deportivo Pereira Deportivo 18 28 29 23
14 Tigres FC Tigres FC 18 20 25 22
15 Fortaleza Fortaleza 18 17 25 19
16 Real Santander Real 18 22 35 18
17 Barranquilla Barranquilla 18 14 36 13
18 Universitario Popayán Universitari 18 17 41 10
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 América de Cali América 18 33 15 38
2 Internacional de Palmira Internaciona 18 24 14 33
3 Deportivo Rionegro Deportivo 18 33 19 32
4 Sucre FC Sucre FC 18 22 18 31
5 Uniautónoma Uniautónoma 18 27 19 30
6 Universitario Popayán Universitari 18 25 18 30
7 Unión Magdalena Unión 18 27 21 28
8 Real Santander Real 18 25 23 27
9 Fortaleza Fortaleza 18 25 26 26
10 Real Cundinamarca Real 18 26 28 24
11 Deportivo Pereira Deportivo 18 21 23 23
12 Bogotá Bogotá 18 24 34 20
13 Academia Academia 18 22 22 19
14 Atlético Fútbol Club Atlético 18 23 34 18
15 Alianza FC Alianza FC 18 19 27 17
16 Atlético Bucaramanga Atlético 18 18 27 17
17 Barranquilla Barranquilla 18 18 28 16
18 Tigres FC Tigres FC 18 8 24 13
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Deportivo Pasto Deportivo 18 32 8 39
2 Deportivo Rionegro Deportivo 18 25 20 32
3 Pacífico Pacífico 18 24 19 29
4 Academia Academia 18 18 15 29
5 Patriotas Boyacá Patriotas 18 22 20 29
6 Real Cundinamarca Real 18 16 14 28
7 Uniautónoma Uniautónoma 18 30 22 27
8 Internacional de Palmira Internaciona 18 21 18 27
9 Atlético Bucaramanga Atlético 18 20 25 27
10 Fortaleza Fortaleza 18 20 19 26
11 Bogotá Bogotá 18 20 24 24
12 Tigres FC Tigres FC 18 25 24 22
13 Atlético Fútbol Club Atlético 18 22 28 21
14 Real Santander Real 18 25 26 20
15 Centauros Centauros 18 23 25 18
16 Barranquilla Barranquilla 18 13 19 18
17 Unión Magdalena Unión 18 24 38 16
18 Alianza FC Alianza FC 18 12 28 14
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Águilas Doradas Águilas 18 28 15 33
2 Patriotas Boyacá Patriotas 18 24 13 32
3 Deportivo Rionegro Deportivo 18 24 16 29
4 Deportivo Pasto Deportivo 18 24 17 29
5 Unión Magdalena Unión 18 25 23 29
6 La Sabana La Sabana 18 20 18 29
7 Real Santander Real 18 29 18 27
8 Alianza FC Alianza FC 18 15 20 26
9 Pacífico Pacífico 18 21 19 24
10 Bogotá Bogotá 18 20 16 22
11 Atlético Fútbol Club Atlético 18 27 27 22
12 Tigres FC Tigres FC 18 16 17 22
13 Atlético Bucaramanga Atlético 18 15 18 22
14 Fortaleza Fortaleza 18 18 26 20
15 Barranquilla Barranquilla 18 10 19 20
16 Centauros Centauros 18 22 25 19
17 Academia Academia 18 19 33 14
18 Real Cundinamarca Real 18 11 28 14
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Atlético Bucaramanga Atlético 18 29 17 38
2 Águilas Doradas Águilas 18 27 14 35
3 Deportivo Rionegro Deportivo 18 20 13 35
4 Unión Magdalena Unión 18 23 16 28
5 La Sabana La Sabana 18 18 23 25
6 Real Santander Real 18 20 17 23
7 Real Cundinamarca Real 18 18 19 22
8 Barranquilla Barranquilla 18 16 24 16
9 Alianza FC Alianza FC 18 11 30 5
10 Patriotas Boyacá Patriotas 18 22 18 28
11 Internacional de Palmira Internaciona 18 23 18 27
12 Tigres FC Tigres FC 18 19 17 27
13 Sucre FC Sucre FC 18 18 17 27
14 Bogotá Bogotá 18 14 16 25
15 Academia Academia 18 18 22 24
16 Fortaleza Fortaleza 18 24 22 23
17 Centauros Centauros 18 21 28 19
18 Atlético Fútbol Club Atlético 18 15 25 13
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Unión Magdalena Unión 18 25 12 33
2 Deportivo Rionegro Deportivo 18 31 21 33
3 Real Cundinamarca Real 18 21 18 30
4 La Sabana La Sabana 18 17 19 27
5 Real Cartagena Real 18 24 23 24
6 Real Santander Real 18 17 20 20
7 Barranquilla Barranquilla 18 12 17 20
8 Águilas Doradas Águilas 18 13 21 17
9 Alianza FC Alianza FC 18 17 31 14
10 Bogotá Bogotá 18 31 11 36
11 Atlético Fútbol Club Atlético 18 25 19 29
12 Centauros Centauros 18 24 21 28
13 Fortaleza Fortaleza 18 19 17 28
14 Patriotas Boyacá Patriotas 18 22 27 23
15 Sucre FC Sucre FC 18 24 24 21
16 Tigres FC Tigres FC 18 16 23 20
17 Academia Academia 18 21 25 19
18 Internacional de Palmira Internaciona 18 15 25 11
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Envigado Envigado 18 27 15 31
2 Bogotá Bogotá 18 27 19 30
3 Real Cundinamarca Real 18 23 19 30
4 Academia Academia 18 21 14 29
5 Unión Magdalena Unión 18 17 13 29
6 Patriotas Boyacá Patriotas 18 27 18 28
7 Deportivo Rionegro Deportivo 18 25 25 28
8 Barranquilla Barranquilla 18 24 15 27
9 Atlético Bello Atlético 18 25 16 26
10 Águilas Doradas Águilas 18 26 29 24
11 Atlético Fútbol Club Atlético 18 15 21 24
12 Internacional de Palmira Internaciona 18 15 15 23
13 Real Santander Real 18 17 18 23
14 Centauros Centauros 18 21 25 23
15 La Sabana La Sabana 18 17 18 22
16 Tigres FC Tigres FC 18 20 24 20
17 Sucre FC Sucre FC 18 15 20 20
18 Alianza FC Alianza FC 18 13 51 6
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Unión Magdalena Unión 18 27 9 40
2 La Equidad La Equidad 18 24 15 36
3 Academia Academia 18 29 13 34
4 Atlético Fútbol Club Atlético 18 23 19 30
5 Real Cundinamarca Real 18 17 18 30
6 Patriotas Boyacá Patriotas 18 28 17 29
7 Internacional de Palmira Internaciona 18 26 23 29
8 Águilas Doradas Águilas 18 17 19 27
9 La Sabana La Sabana 18 19 22 23
10 Alianza FC Alianza FC 18 19 17 22
11 Tigres FC Tigres FC 18 18 19 22
12 Centauros Centauros 18 12 15 21
13 Deportivo Rionegro Deportivo 18 14 21 19
14 Sucre FC Sucre FC 18 21 28 17
15 Atlético Bello Atlético 18 13 23 16
16 Barranquilla Barranquilla 18 17 21 15
17 Bogotá Bogotá 18 12 26 14
18 Pumas de Casanare Pumas 18 22 33 13

  USO DE MEMORIA  
6,871,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1776
Total Execution Time  0.1796
  CADENA URL  
/apertura_primera_b_colombia2022/grupo1/historico
  GET DATOS  
$_GET['/apertura_primera_b_colombia2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0021  SELECT type FROM routes WHERE alias = 'apertura_primera_b_colombia2022'
0.0050  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_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.0028  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 = 66308 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 196 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0036  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 = 66308 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.0037  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 = 60997 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.0035  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 = 53797 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 48673 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 37761 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0069  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 = 3477 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 2415 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 1569 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0060  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 = 1391 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0045  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 = 9745 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 13585 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0052  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 = 13579 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 13573 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 13568 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 url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-16 08:58:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-16 08:58:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-16 08:58:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-16 08:58:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0031  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_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.0228  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 = 66308 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66308 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.0214  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 = 66308 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66308 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  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 = 66308 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66308 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0049  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 = 66308 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