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 Millonarios Millonarios 20 23 11 42
2 Deportes Tolima Deportes 20 29 14 40
3 At. Nacional Nacional 20 26 15 36
4 Independiente Medellín Independient 20 25 19 34
5 Junior Junior 20 30 21 32
6 Envigado Envigado 20 22 21 31
7 La Equidad La Equidad 20 21 16 30
8 Atlético Bucaramanga Atlético 20 27 25 29
9 Alianza FC Alianza FC 20 22 20 29
10 Santa Fe Santa Fe 20 29 26 27
11 Jaguares FC Jaguares FC 20 26 29 27
12 Once Caldas Once Caldas 20 18 18 26
13 Águilas Doradas Águilas 20 17 26 25
14 Deportivo Pereira Deportivo 20 21 26 23
15 América de Cali América 20 20 25 23
16 Deportivo Pasto Deportivo 20 16 20 22
17 Patriotas Boyacá Patriotas 20 19 23 21
18 Internacional de Palmira Internaciona 20 21 27 20
19 Deportivo Cali Deportivo 20 14 24 18
20 Unión Magdalena Unión 20 8 28 11
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 18 37 15 34
2 Santa Fe Santa Fe 18 25 14 33
3 Millonarios Millonarios 18 25 18 33
4 Deportivo Cali Deportivo 18 19 14 31
5 Deportes Tolima Deportes 18 22 14 30
6 La Equidad La Equidad 18 21 18 30
7 Junior Junior 18 21 13 29
8 América de Cali América 18 19 12 29
9 Independiente Medellín Independient 18 17 15 26
10 Jaguares FC Jaguares FC 18 21 21 25
11 Atlético Bucaramanga Atlético 18 20 16 24
12 Deportivo Pasto Deportivo 18 19 20 23
13 Boyacá Chicó Boyacá 18 17 20 19
14 Deportivo Pereira Deportivo 18 16 24 18
15 Once Caldas Once Caldas 18 20 23 17
16 Envigado Envigado 18 15 23 17
17 Patriotas Boyacá Patriotas 18 17 31 17
18 Águilas Doradas Águilas 18 13 24 14
19 Alianza FC Alianza FC 18 10 39 6
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Santa Fe Santa Fe 20 34 17 40
2 Deportes Tolima Deportes 20 30 16 37
3 At. Nacional Nacional 20 39 31 35
4 Deportivo Cali Deportivo 20 32 23 34
5 Deportivo Pasto Deportivo 20 27 19 34
6 América de Cali América 20 31 22 33
7 Junior Junior 20 27 17 33
8 La Equidad La Equidad 20 30 23 32
9 Águilas Doradas Águilas 20 27 21 31
10 Millonarios Millonarios 20 29 21 30
11 Once Caldas Once Caldas 20 23 20 29
12 Envigado Envigado 20 22 25 23
13 Atlético Bucaramanga Atlético 20 16 26 21
14 Independiente Medellín Independient 20 22 28 20
15 Alianza FC Alianza FC 20 22 35 19
16 Deportivo Pereira Deportivo 20 17 24 18
17 Jaguares FC Jaguares FC 20 21 30 17
18 Patriotas Boyacá Patriotas 20 10 21 17
19 Boyacá Chicó Boyacá 20 13 33 15
20 Cúcuta Deportivo Cúcuta 20 18 38 14
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Millonarios Millonarios 20 30 15 39
2 Deportivo Cali Deportivo 20 22 17 33
3 Deportes Tolima Deportes 20 27 16 32
4 América de Cali América 20 26 20 32
5 At. Nacional Nacional 20 24 19 31
6 Deportivo Pasto Deportivo 20 19 14 31
7 Junior Junior 20 24 18 30
8 Unión Magdalena Unión 20 24 24 30
9 Independiente Medellín Independient 20 30 24 28
10 Once Caldas Once Caldas 20 20 16 28
11 Cúcuta Deportivo Cúcuta 20 25 27 27
12 Patriotas Boyacá Patriotas 20 20 31 27
13 Envigado Envigado 20 22 20 24
14 Alianza FC Alianza FC 20 17 19 23
15 Jaguares FC Jaguares FC 20 20 27 23
16 La Equidad La Equidad 20 21 22 22
17 Atlético Bucaramanga Atlético 20 17 26 21
18 Atlético Huila Atlético 20 19 32 19
19 Águilas Doradas Águilas 20 17 30 16
20 Santa Fe Santa Fe 20 17 24 14
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 19 23 10 41
2 Independiente Medellín Independient 19 32 23 35
3 Deportes Tolima Deportes 19 22 14 33
4 Atlético Huila Atlético 19 20 12 30
5 Junior Junior 19 19 16 30
6 Deportivo Cali Deportivo 19 26 17 29
7 Patriotas Boyacá Patriotas 19 17 18 29
8 Once Caldas Once Caldas 19 26 26 27
9 Millonarios Millonarios 19 19 18 26
10 Envigado Envigado 19 19 19 26
11 La Equidad La Equidad 19 18 15 25
12 Santa Fe Santa Fe 19 20 19 25
13 Águilas Doradas Águilas 19 18 22 25
14 Jaguares FC Jaguares FC 19 16 23 25
15 Alianza FC Alianza FC 19 24 26 23
16 Atlético Bucaramanga Atlético 19 22 24 23
17 América de Cali América 19 22 31 22
18 Deportivo Pasto Deportivo 19 15 19 20
19 Boyacá Chicó Boyacá 19 16 32 16
20 Leones Leones 19 13 23 13
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 20 33 9 49
2 Independiente Medellín Independient 20 35 23 42
3 Deportivo Pasto Deportivo 20 31 20 35
4 Millonarios Millonarios 20 29 17 33
5 Jaguares FC Jaguares FC 20 18 16 31
6 Deportivo Cali Deportivo 20 27 20 30
7 América de Cali América 20 26 21 29
8 Atlético Bucaramanga Atlético 20 16 17 29
9 Santa Fe Santa Fe 20 16 20 28
10 Alianza FC Alianza FC 20 24 24 27
11 Patriotas Boyacá Patriotas 20 17 18 24
12 Junior Junior 20 25 26 23
13 La Equidad La Equidad 20 15 18 23
14 Águilas Doradas Águilas 20 14 21 21
15 Atlético Huila Atlético 20 16 25 21
16 Once Caldas Once Caldas 20 18 29 21
17 Deportes Tolima Deportes 20 24 28 20
18 Tigres FC Tigres FC 20 11 23 19
19 Envigado Envigado 20 18 26 18
20 Internacional de Palmira Internaciona 20 19 31 18
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Independiente Medellín Independient 20 33 17 40
2 At. Nacional Nacional 20 42 20 39
3 Millonarios Millonarios 20 30 17 37
4 Santa Fe Santa Fe 20 28 18 37
5 Junior Junior 20 28 20 37
6 Águilas Doradas Águilas 20 30 23 34
7 Deportivo Cali Deportivo 20 35 28 32
8 Internacional de Palmira Internaciona 20 29 23 31
9 Patriotas Boyacá Patriotas 20 22 23 29
10 Once Caldas Once Caldas 20 26 22 26
11 Deportivo Pasto Deportivo 20 19 23 24
12 Deportes Tolima Deportes 20 25 32 24
13 Atlético Bucaramanga Atlético 20 21 27 23
14 Jaguares FC Jaguares FC 20 16 29 23
15 Envigado Envigado 20 21 22 19
16 Atlético Huila Atlético 20 18 26 19
17 La Equidad La Equidad 20 20 30 19
18 Boyacá Chicó Boyacá 20 17 28 17
19 Alianza FC Alianza FC 20 24 38 17
20 Fortaleza Fortaleza 20 16 34 15
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Atlético Huila Atlético 20 33 22 41
2 Envigado Envigado 20 21 13 36
3 Deportivo Cali Deportivo 20 36 24 35
4 Independiente Medellín Independient 20 31 22 35
5 Millonarios Millonarios 20 36 23 34
6 At. Nacional Nacional 20 33 24 34
7 Deportes Tolima Deportes 20 29 16 33
8 Junior Junior 20 27 16 33
9 Santa Fe Santa Fe 20 29 19 31
10 Águilas Doradas Águilas 20 23 16 30
11 Patriotas Boyacá Patriotas 20 17 18 27
12 La Equidad La Equidad 20 21 21 26
13 Once Caldas Once Caldas 20 29 32 23
14 Internacional de Palmira Internaciona 20 22 25 21
15 Jaguares FC Jaguares FC 20 21 32 21
16 Alianza FC Alianza FC 20 17 22 20
17 Boyacá Chicó Boyacá 20 16 29 17
18 Cúcuta Deportivo Cúcuta 20 16 33 15
19 Uniautónoma Uniautónoma 20 13 30 15
20 Deportivo Pasto Deportivo 20 11 44 9
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 18 35 22 34
2 Millonarios Millonarios 18 27 15 33
3 Junior Junior 18 20 17 33
4 Santa Fe Santa Fe 18 24 16 30
5 Once Caldas Once Caldas 18 27 17 29
6 Envigado Envigado 18 27 24 28
7 Águilas Doradas Águilas 18 21 23 28
8 La Equidad La Equidad 18 17 17 27
9 Alianza FC Alianza FC 18 23 28 27
10 Boyacá Chicó Boyacá 18 19 16 25
11 Independiente Medellín Independient 18 26 30 21
12 Deportivo Pasto Deportivo 18 28 26 20
13 Atlético Huila Atlético 18 23 26 19
14 Deportivo Cali Deportivo 18 16 22 19
15 Patriotas Boyacá Patriotas 18 20 30 19
16 Fortaleza Fortaleza 18 22 26 17
17 Uniautónoma Uniautónoma 18 20 30 17
18 Deportes Tolima Deportes 18 18 28 17
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Santa Fe Santa Fe 18 32 25 33
2 At. Nacional Nacional 18 29 22 32
3 Águilas Doradas Águilas 18 27 17 31
4 Deportivo Cali Deportivo 18 31 21 30
5 Deportes Tolima Deportes 18 31 23 29
6 Millonarios Millonarios 18 26 18 28
7 Once Caldas Once Caldas 18 23 17 28
8 Deportivo Pasto Deportivo 18 21 25 26
9 Cúcuta Deportivo Cúcuta 18 23 20 23
10 Independiente Medellín Independient 18 18 18 23
11 La Equidad La Equidad 18 16 15 22
12 Junior Junior 18 24 25 22
13 Atlético Huila Atlético 18 19 23 20
14 Alianza FC Alianza FC 18 19 28 20
15 Boyacá Chicó Boyacá 18 27 31 19
16 Envigado Envigado 18 15 25 17
17 Deportes Quindío Deportes 18 8 24 13
18 Patriotas Boyacá Patriotas 18 14 26 11
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Deportes Tolima Deportes 18 28 16 36
2 Santa Fe Santa Fe 18 29 19 29
3 Águilas Doradas Águilas 18 25 18 29
4 Atlético Huila Atlético 18 23 17 29
5 La Equidad La Equidad 18 19 16 28
6 Deportivo Pasto Deportivo 18 24 18 27
7 Boyacá Chicó Boyacá 18 26 22 27
8 Deportivo Cali Deportivo 18 19 18 27
9 Patriotas Boyacá Patriotas 18 13 17 27
10 Junior Junior 18 28 24 25
11 Envigado Envigado 18 23 24 23
12 At. Nacional Nacional 18 25 20 22
13 Millonarios Millonarios 18 22 23 20
14 Real Cartagena Real 18 22 31 20
15 Deportes Quindío Deportes 18 20 29 18
16 Independiente Medellín Independient 18 17 24 17
17 Once Caldas Once Caldas 18 22 26 14
18 Cúcuta Deportivo Cúcuta 18 12 35 11
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Once Caldas Once Caldas 18 33 16 39
2 Deportes Tolima Deportes 18 35 21 34
3 At. Nacional Nacional 18 34 25 34
4 Envigado Envigado 18 30 21 32
5 La Equidad La Equidad 18 23 14 29
6 Millonarios Millonarios 18 31 23 28
7 Deportivo Cali Deportivo 18 21 22 27
8 Cúcuta Deportivo Cúcuta 18 22 19 26
9 Boyacá Chicó Boyacá 18 25 24 25
10 Deportes Quindío Deportes 18 22 29 25
11 Águilas Doradas Águilas 18 24 23 24
12 América de Cali América 18 21 25 24
13 Real Cartagena Real 18 22 26 21
14 Santa Fe Santa Fe 18 18 22 21
15 Junior Junior 18 19 28 19
16 Atlético Huila Atlético 18 25 36 17
17 Independiente Medellín Independient 18 19 30 15
18 Deportivo Pereira Deportivo 18 15 35 5
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Deportes Tolima Deportes 18 36 22 34
2 Independiente Medellín Independient 18 29 17 33
3 Junior Junior 18 28 17 32
4 La Equidad La Equidad 18 29 25 31
5 Deportivo Cali Deportivo 18 28 20 30
6 Santa Fe Santa Fe 18 25 23 30
7 Boyacá Chicó Boyacá 18 25 24 29
8 At. Nacional Nacional 18 28 24 28
9 Real Cartagena Real 18 24 26 28
10 Once Caldas Once Caldas 18 32 28 25
11 Atlético Huila Atlético 18 30 26 24
12 Envigado Envigado 18 23 30 23
13 Cúcuta Deportivo Cúcuta 18 14 21 20
14 Millonarios Millonarios 18 22 29 19
15 Deportivo Pereira Deportivo 18 23 28 18
16 América de Cali América 18 18 28 16
17 Internacional de Palmira Internaciona 18 19 32 15
18 Deportes Quindío Deportes 18 9 22 14
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 La Equidad La Equidad 18 23 17 32
2 Deportes Tolima Deportes 18 21 16 32
3 Junior Junior 18 30 18 31
4 Cúcuta Deportivo Cúcuta 18 16 14 31
5 Boyacá Chicó Boyacá 18 24 22 30
6 Envigado Envigado 18 22 24 29
7 Once Caldas Once Caldas 18 23 14 28
8 Deportivo Cali Deportivo 18 22 20 26
9 Deportes Quindío Deportes 18 23 23 25
10 Real Cartagena Real 18 23 24 25
11 América de Cali América 18 24 21 24
12 Deportivo Pereira Deportivo 18 26 25 24
13 Atlético Huila Atlético 18 21 26 24
14 Santa Fe Santa Fe 18 20 25 21
15 Millonarios Millonarios 18 16 20 17
16 Deportivo Pasto Deportivo 18 12 17 17
17 At. Nacional Nacional 18 16 25 16
18 Independiente Medellín Independient 18 18 29 11
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 La Equidad La Equidad 18 25 13 35
2 Boyacá Chicó Boyacá 18 30 19 32
3 Santa Fe Santa Fe 18 25 18 31
4 Independiente Medellín Independient 18 26 14 29
5 Envigado Envigado 18 20 20 28
6 Deportivo Cali Deportivo 18 19 21 27
7 América de Cali América 18 34 28 26
8 Deportes Quindío Deportes 18 25 22 25
9 Cúcuta Deportivo Cúcuta 18 20 17 25
10 Atlético Bucaramanga Atlético 18 20 24 25
11 Millonarios Millonarios 18 23 23 24
12 Junior Junior 18 21 23 24
13 Atlético Huila Atlético 18 25 25 23
14 At. Nacional Nacional 18 16 19 22
15 Once Caldas Once Caldas 18 20 28 19
16 Deportivo Pasto Deportivo 18 15 24 19
17 Deportivo Pereira Deportivo 18 21 33 19
18 Deportes Tolima Deportes 18 21 35 15
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Deportivo Cali Deportivo 17 30 17 33
2 Cúcuta Deportivo Cúcuta 17 28 16 33
3 Millonarios Millonarios 18 26 17 30
4 Boyacá Chicó Boyacá 18 20 16 30
5 At. Nacional Nacional 17 30 20 29
6 Santa Fe Santa Fe 18 23 21 29
7 Independiente Medellín Independient 17 30 28 28
8 Atlético Huila Atlético 18 24 23 28
9 Atlético Bucaramanga Atlético 18 23 21 27
10 Deportivo Pasto Deportivo 18 19 21 23
11 Junior Junior 18 22 26 23
12 Deportes Tolima Deportes 18 26 28 20
13 América de Cali América 18 24 35 19
14 Once Caldas Once Caldas 18 18 25 18
15 Deportes Quindío Deportes 18 14 22 18
16 Deportivo Pereira Deportivo 17 14 19 15
17 Real Cartagena Real 17 13 22 14
18 La Equidad La Equidad 18 21 28 13
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Cúcuta Deportivo Cúcuta 18 29 14 37
2 Once Caldas Once Caldas 17 29 13 36
3 Deportes Tolima Deportes 18 36 19 32
4 At. Nacional Nacional 18 27 19 30
5 Deportivo Pereira Deportivo 18 20 15 29
6 Millonarios Millonarios 18 27 23 28
7 Deportivo Cali Deportivo 18 20 17 28
8 Deportivo Pasto Deportivo 18 27 21 27
9 Deportes Quindío Deportes 18 17 15 27
10 América de Cali América 18 20 25 27
11 Envigado Envigado 18 20 22 22
12 Atlético Bucaramanga Atlético 18 16 23 21
13 Santa Fe Santa Fe 18 24 32 20
14 Atlético Huila Atlético 18 17 32 20
15 Boyacá Chicó Boyacá 17 17 21 17
16 Junior Junior 17 22 29 16
17 Independiente Medellín Independient 17 14 26 14
18 Real Cartagena Real 18 14 30 7
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 América de Cali América 0 0 0 0
2 At. Nacional Nacional 0 0 0 0
3 Atlético Bucaramanga Atlético 0 0 0 0
4 Atlético Huila Atlético 0 0 0 0
5 Boyacá Chicó Boyacá 0 0 0 0
6 Deportes Quindío Deportes 0 0 0 0
7 Deportes Tolima Deportes 0 0 0 0
8 Deportivo Cali Deportivo 0 0 0 0
9 Deportivo Pasto Deportivo 0 0 0 0
10 Deportivo Pereira Deportivo 0 0 0 0
11 Envigado Envigado 0 0 0 0
12 Independiente Medellín Independient 0 0 0 0
13 Junior Junior 0 0 0 0
14 Millonarios Millonarios 0 0 0 0
15 Once Caldas Once Caldas 0 0 0 0
16 Real Cartagena Real 0 0 0 0
17 Santa Fe Santa Fe 0 0 0 0
18 Unión Magdalena Unión 0 0 0 0
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 América de Cali América 18 30 17 37
2 Deportivo Cali Deportivo 18 23 15 34
3 At. Nacional Nacional 18 30 23 33
4 Once Caldas Once Caldas 18 23 14 31
5 Independiente Medellín Independient 18 20 19 29
6 Junior Junior 17 23 15 27
7 Boyacá Chicó Boyacá 18 25 24 27
8 Deportivo Pasto Deportivo 18 18 19 27
9 Deportivo Pereira Deportivo 18 21 18 26
10 Deportes Tolima Deportes 18 20 17 26
11 Millonarios Millonarios 17 22 22 23
12 Atlético Bucaramanga Atlético 18 22 25 21
13 Atlético Huila Atlético 17 20 24 19
14 Internacional de Palmira Internaciona 18 27 32 19
15 Santa Fe Santa Fe 18 16 24 17
16 Deportes Quindío Deportes 18 11 23 15
17 Envigado Envigado 18 19 26 14
18 Unión Magdalena Unión 17 15 28 10
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Once Caldas Once Caldas 18 24 14 33
2 América de Cali América 17 30 20 31
3 Millonarios Millonarios 18 23 14 31
4 Centauros Centauros 18 24 21 29
5 Deportivo Cali Deportivo 18 27 22 28
6 Junior Junior 18 19 18 27
7 Atlético Huila Atlético 18 22 22 26
8 Independiente Medellín Independient 18 29 23 25
9 Unión Magdalena Unión 17 22 22 25
10 Deportivo Pereira Deportivo 17 21 24 25
11 Atlético Bucaramanga Atlético 18 19 19 23
12 Envigado Envigado 18 20 23 22
13 At. Nacional Nacional 18 16 18 21
14 Deportes Tolima Deportes 17 22 24 19
15 Deportivo Pasto Deportivo 18 15 18 19
16 Santa Fe Santa Fe 18 15 23 18
17 Internacional de Palmira Internaciona 18 15 24 15
18 Deportes Quindío Deportes 18 12 26 14
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Deportivo Cali Deportivo 22 44 24 39
2 Santa Fe Santa Fe 22 26 13 38
3 At. Nacional Nacional 22 24 18 38
4 Envigado Envigado 22 21 18 36
5 Deportivo Pasto Deportivo 22 29 27 34
6 América de Cali América 22 27 22 33
7 Atlético Bucaramanga Atlético 22 24 22 33
8 Unión Magdalena Unión 22 27 27 33
9 Once Caldas Once Caldas 22 36 29 32
10 Deportivo Pereira Deportivo 22 20 16 32
11 Deportes Quindío Deportes 22 24 30 30
12 Junior Junior 22 19 25 26
13 Millonarios Millonarios 22 17 21 23
14 Atlético Huila Atlético 22 21 32 22
15 Independiente Medellín Independient 22 26 32 21
16 Internacional de Palmira Internaciona 22 16 25 21
17 Real Cartagena Real 22 17 25 20
18 Deportes Tolima Deportes 22 18 30 18

  USO DE MEMORIA  
8,335,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5250
Total Execution Time  0.5269
  CADENA URL  
/apertura_colombia2022/grupo1/historico
  GET DATOS  
$_GET['/apertura_colombia2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0108  SELECT type FROM routes WHERE alias = 'apertura_colombia2022'
0.0226  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_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.0124  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 = 66290 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0122  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 42 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0133  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 = 66290 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 = 60836 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 48381 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 42448 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 = 37731 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 20228 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 = 9440 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121  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 = 3373 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 = 2414 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 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 = 1563 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123  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 = 1296 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 1009 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 1007 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 254 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 12998 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 12993 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 12988 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 12984 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 12981 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 23447 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 12:51:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 12:51:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 12:51:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 12:51:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_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.0235  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 = 66290 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66290 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.0272  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 = 66290 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66290 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0118  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 = 66290 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66290 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  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 = 66290 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC