4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dep. Anzoátegui

Dep. Anzoátegui

Entrenador: Charles Lopéz

Temporada 2016/2017
TEMPORADA 2016/2017
APERTURA VENEZUELA
Equipo PJ GF GC Puntos
1 Carabobo Carabobo 17 36 12 35
2 Deportivo Táchira Deportivo 17 27 17 33
3 Zamora FC Zamora FC 17 26 14 30
4 Dep. Anzoátegui Dep. 17 23 13 28
5 Caracas Caracas 17 27 19 28
6 Monagas Monagas 17 27 19 26
7 Zulia FC Zulia FC 17 30 32 26
8 Aragua FC Aragua FC 17 22 18 25
9 Mineros de Guayana Mineros 17 32 32 25
10 La Guaira La Guaira 17 23 17 23
11 At. Venezuela Venezuela 17 21 28 21
12 Deportivo Lara Deportivo 17 22 24 19
13 Trujillanos Trujillanos 17 17 21 19
14 Estudiantes de Mérida Estudiantes 17 16 21 18
15 Metropolitanos Metropolitan 17 14 32 15
16 Deportivo JBL del Zulia Deportivo 17 17 31 14
17 Atlético Socopó Atlético 17 15 27 13
18 Portuguesa FC Portuguesa 17 10 28 13
TEMPORADA 2015/2016
APERTURA VENEZUELA
Equipo PJ GF GC Puntos
1 Zamora FC Zamora FC 19 39 18 40
2 Deportivo Táchira Deportivo 19 27 13 38
3 Dep. Anzoátegui Dep. 19 25 23 32
4 Mineros de Guayana Mineros 19 38 27 30
5 Caracas Caracas 19 23 15 30
6 La Guaira La Guaira 19 28 22 30
7 Aragua FC Aragua FC 19 27 22 29
8 Trujillanos Trujillanos 19 22 17 29
9 Zulia FC Zulia FC 19 25 21 28
10 Carabobo Carabobo 19 27 22 27
11 Deportivo Lara Deportivo 19 25 22 26
12 Deportivo JBL del Zulia Deportivo 19 23 20 26
13 Ureña Ureña 19 20 25 23
14 Estudiantes de Mérida Estudiantes 19 20 35 22
15 Portuguesa FC Portuguesa 19 17 21 19
16 At. Venezuela Venezuela 19 22 28 19
17 Monagas Monagas 19 15 31 17
18 Llaneros de Guanare Llaneros 19 12 25 16
19 Deportivo Miranda Deportivo 19 11 24 15
20 Estudiantes de Caracas Estudiantes 19 19 34 13
TEMPORADA 2014/2015
PRIMERA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 La Guaira La Guaira 19 35 13 42
2 Zamora FC Zamora FC 19 43 22 40
3 Deportivo Táchira Deportivo 19 37 17 33
4 Zulia FC Zulia FC 19 32 16 33
5 Aragua FC Aragua FC 19 25 20 32
6 Mineros de Guayana Mineros 19 33 20 31
7 Caracas Caracas 19 23 10 31
8 Deportivo Lara Deportivo 19 26 22 31
9 Trujillanos Trujillanos 19 25 22 30
10 Dep. Anzoátegui Dep. 19 24 26 24
11 Estudiantes de Caracas Estudiantes 19 18 27 24
12 Carabobo Carabobo 19 16 16 23
13 Llaneros de Guanare Llaneros 19 20 21 22
14 Portuguesa FC Portuguesa 19 22 27 20
15 Estudiantes de Mérida Estudiantes 19 16 25 19
16 At. Venezuela Venezuela 19 17 28 16
17 Ureña Ureña 19 18 40 16
18 Deportivo Miranda Deportivo 19 11 32 15
19 Metropolitanos Metropolitan 19 14 30 14
20 Tucanes FC Tucanes FC 19 12 33 14
TEMPORADA 2013/2014
APERTURA VENEZUELA
Equipo PJ GF GC Puntos
1 Mineros de Guayana Mineros 17 28 15 38
2 Caracas Caracas 17 30 15 35
3 Zamora FC Zamora FC 17 22 11 33
4 Dep. Anzoátegui Dep. 17 27 21 33
5 Carabobo Carabobo 17 30 20 30
6 Deportivo Táchira Deportivo 17 31 18 29
7 At. Venezuela Venezuela 17 18 19 25
8 Estudiantes de Mérida Estudiantes 17 21 28 22
9 Trujillanos Trujillanos 17 24 19 21
10 Aragua FC Aragua FC 17 26 25 20
11 Llaneros de Guanare Llaneros 17 21 25 19
12 Zulia FC Zulia FC 17 18 22 19
13 Deportivo Miranda Deportivo 17 14 19 18
14 Tucanes FC Tucanes FC 17 23 28 17
15 Deportivo Lara Deportivo 17 13 23 15
16 Atlético El Vigía FC Atlético 17 23 35 15
17 La Guaira La Guaira 17 12 20 14
18 Yaracuyanos Yaracuyanos 17 15 33 6
TEMPORADA 2012/2013
APERTURA VENEZUELA
Equipo PJ GF GC Puntos
1 Dep. Anzoátegui Dep. 17 31 18 39
2 Caracas Caracas 17 25 10 38
3 Zamora FC Zamora FC 17 26 15 31
4 Deportivo Lara Deportivo 17 24 17 31
5 Mineros de Guayana Mineros 17 22 23 29
6 Trujillanos Trujillanos 17 28 21 27
7 Llaneros de Guanare Llaneros 17 29 26 25
8 Deportivo Miranda Deportivo 17 24 23 24
9 Aragua FC Aragua FC 17 24 24 23
10 At. Venezuela Venezuela 17 21 19 21
11 Deportivo Táchira Deportivo 17 25 26 21
12 Zulia FC Zulia FC 17 20 24 21
13 Portuguesa FC Portuguesa 17 17 21 21
14 Atlético El Vigía FC Atlético 17 18 25 18
15 Yaracuyanos Yaracuyanos 17 11 18 18
16 La Guaira La Guaira 17 19 28 17
17 Monagas Monagas 17 18 31 15
18 Estudiantes de Mérida Estudiantes 17 11 24 8
TEMPORADA 2011/2012
APERTURA VENEZUELA
Equipo PJ GF GC Puntos
1 Deportivo Lara Deportivo 17 39 12 41
2 Caracas Caracas 17 27 13 36
3 Deportivo Miranda Deportivo 17 28 15 35
4 Dep. Anzoátegui Dep. 17 16 11 30
5 Mineros de Guayana Mineros 17 21 22 28
6 Zulia FC Zulia FC 17 28 20 27
7 Yaracuyanos Yaracuyanos 17 24 17 24
8 Zamora FC Zamora FC 17 23 19 23
9 Aragua FC Aragua FC 17 15 19 23
10 Monagas Monagas 17 20 23 21
11 Trujillanos Trujillanos 17 22 21 20
12 La Guaira La Guaira 17 18 23 20
13 Deportivo Táchira Deportivo 17 14 21 20
14 Atlético El Vigía FC Atlético 17 17 25 17
15 Tucanes FC Tucanes FC 17 21 30 13
16 Llaneros de Guanare Llaneros 17 18 28 13
17 Estudiantes de Mérida Estudiantes 17 15 37 11
18 Carabobo Carabobo 17 17 27 8
TEMPORADA 2010/2011
APERTURA VENEZUELA
Equipo PJ GF GC Puntos
1 Deportivo Táchira Deportivo 17 31 11 36
2 La Guaira La Guaira 17 30 11 36
3 Caracas Caracas 17 24 15 35
4 Deportivo Miranda Deportivo 17 25 17 33
5 Trujillanos Trujillanos 17 22 15 27
6 Aragua FC Aragua FC 17 22 20 27
7 Dep. Anzoátegui Dep. 17 35 30 26
8 Yaracuyanos Yaracuyanos 17 20 17 26
9 Estudiantes de Mérida Estudiantes 17 18 22 22
10 Zulia FC Zulia FC 17 25 27 21
11 Mineros de Guayana Mineros 17 20 20 20
12 Monagas Monagas 17 25 25 17
13 Zamora FC Zamora FC 17 20 27 17
14 Deportivo Lara Deportivo 17 23 28 16
15 Carabobo Carabobo 17 15 21 16
16 At. Venezuela Venezuela 17 22 33 16
17 Atlético El Vigía FC Atlético 17 18 25 14
18 Caroní FC Caroní FC 17 7 38 8
TEMPORADA 2009/2010
APERTURA VENEZUELA
Equipo PJ GF GC Puntos
1 Deportivo Táchira Deportivo 17 25 7 37
2 Deportivo Miranda Deportivo 17 26 14 36
3 Caracas Caracas 17 35 14 35
4 Deportivo Lara Deportivo 17 23 13 30
5 Trujillanos Trujillanos 17 31 21 28
6 Dep. Anzoátegui Dep. 17 22 19 26
7 Mineros de Guayana Mineros 17 22 21 25
8 Zulia FC Zulia FC 17 27 29 24
9 Estudiantes de Mérida Estudiantes 17 21 15 23
10 Atlético El Vigía FC Atlético 17 26 31 23
11 Zamora FC Zamora FC 17 19 27 22
12 Monagas Monagas 17 32 32 21
13 Yaracuyanos Yaracuyanos 17 20 29 21
14 Aragua FC Aragua FC 17 11 18 19
15 La Guaira La Guaira 17 12 21 17
16 SD Centro Ítalo Centro 17 19 26 14
17 Carabobo Carabobo 17 16 29 13
18 Llaneros de Guanare Llaneros 17 18 39 7
TEMPORADA 2008/2009
APERTURA VENEZUELA
Equipo PJ GF GC Puntos
1 Deportivo Miranda Deportivo 17 22 11 36
2 Monagas Monagas 17 23 16 31
3 Caracas Caracas 17 29 20 30
4 Zulia FC Zulia FC 17 27 21 30
5 Dep. Anzoátegui Dep. 17 23 15 29
6 Deportivo Táchira Deportivo 17 35 18 28
7 Zamora FC Zamora FC 17 22 17 27
8 Llaneros de Guanare Llaneros 17 15 18 25
9 Aragua FC Aragua FC 17 22 21 24
10 AC Minervén Minervén 17 24 24 23
11 Atlético El Vigía FC Atlético 17 21 21 22
12 Mineros de Guayana Mineros 17 18 24 21
13 UA Maracaibo Maracaibo 17 22 25 20
14 Carabobo Carabobo 17 19 24 20
15 Estudiantes de Mérida Estudiantes 17 22 28 19
16 Estrella Roja Estrella 17 15 23 15
17 Portuguesa FC Portuguesa 17 15 36 12
18 Guaros de Lara FC Guaros Lara 17 13 25 10
TEMPORADA 2007/2008
APERTURA VENEZUELA
Equipo PJ GF GC Puntos
1 Caracas Caracas 17 31 11 37
2 Dep. Anzoátegui Dep. 17 31 12 34
3 Deportivo Táchira Deportivo 17 22 10 28
4 UA Maracaibo Maracaibo 17 26 20 28
5 Zamora FC Zamora FC 17 19 12 24
6 Portuguesa FC Portuguesa 17 15 18 24
7 Llaneros de Guanare Llaneros 17 25 23 23
8 Aragua FC Aragua FC 17 30 30 23
9 Mineros de Guayana Mineros 17 28 28 23
10 Deportivo Lara Deportivo 17 28 33 23
11 Trujillanos Trujillanos 17 22 27 23
12 Monagas Monagas 17 30 26 22
13 Deportivo Miranda Deportivo 17 17 14 22
14 Estudiantes de Mérida Estudiantes 17 21 28 20
15 Atlético El Vigía FC Atlético 17 18 26 19
16 Carabobo Carabobo 17 13 25 15
17 CD San Antonio Antonio 17 25 32 14
18 Estrella Roja Estrella 17 19 45 13
TEMPORADA 2006/2007
APERTURA SEGUNDA DIVISIÓN VENEZUELA
Equipo PJ GF GC Puntos
1 Dep. Anzoátegui Dep. 16 35 17 34
2 CD San Antonio Antonio 16 27 13 33
3 Llaneros de Guanare Llaneros 16 28 17 33
4 UA Maracaibo B Maracaibo 16 27 15 27
5 Caracas II Caracas II 16 28 20 27
6 Estrella Roja Estrella 16 20 21 24
7 Atlético El Vigía FC Atlético 16 22 16 23
8 Deportivo Lara Deportivo 16 25 24 23
9 Deportivo Miranda Deportivo 16 16 13 21
10 Iberoamericano Iberoamerica 16 21 22 21
11 Estudiantes de Mérida Estudiantes 16 27 35 20
12 Zulia FC Zulia FC 16 21 23 18
13 Turen Turen 16 19 24 18
14 UCLA FC UCLA FC 16 20 27 12
15 Deportivo Galicia Deportivo 16 12 28 9
16 América FC América FC 16 9 42 8

  USO DE MEMORIA  
6,966,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  1.4447
Total Execution Time  1.4464
  CADENA URL  
/historico/Deportivo-Anzoategui-Sc
  GET DATOS  
$_GET['/historico/Deportivo-Anzoategui-Sc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (95)  
0.0135  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Deportivo-Anzoategui-Sc' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0435  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Deportivo-Anzoategui-Sc' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3594 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0134  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 37834
0.0162  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 38534
0.0131  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3594 AND type_rel = 2
0.0137  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3594 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0144  SELECT /*35 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 (6110,7339,38669,46668,48735) ORDER BY n.cover_points DESC, update_date DESC
0.0159  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '3594' ORDER BY l.year DESC,cat.coefficient DESC
0.0506  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '3594' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0136  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '3594' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '3594' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 38786 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 38534 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 39323 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0142  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=3594 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0134  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (44652,43645,42553,37834,30386,16264) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 42553 AND teamId = 3594
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 37834 AND teamId = 3594
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 43645 AND teamId = 3594
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 44652 AND teamId = 3594
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 16264 AND teamId = 3594
0.0161  SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 3594
0.0136  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '3594' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3594' and rp.type = 4
0.0129  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '3594' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 37834 WHERE rp.league_id = 37834 AND rp.teamId = 3594 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 37834 WHERE rp.league_id = 37834 AND rp.teamId = 3594 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 37834 WHERE rp.league_id = 37834 AND rp.teamId = 3594 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 3594 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 37746 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 20177 AND t.round = 19 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 `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 = 3902 AND t.round = 17 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 `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 = 15464 AND t.round = 19 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 `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 = 3282 AND t.round = 17 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 `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 = 2242 AND t.round = 17 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 `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 = 1380 AND t.round = 17 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 `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 = 1209 AND t.round = 17 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 `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 = 8443 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 764 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 14634 AND t.round = 17 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 `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 = 14640 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 14641 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC