4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bordj Bou Arreridj
TEMPORADA 2021/2022
SEGUNDA ARGELIA GRUPO 1
Equipo PJ GF GC Puntos
1 USM Khenchela Khenchela 30 60 22 67
2 JS Bordj Ménaïel Bordj 30 53 20 64
3 Teleghma Teleghma 30 50 34 49
4 CA Batna CA Batna 30 35 33 46
5 USM Annaba USM Annaba 30 30 34 42
6 RB Ouargla RB Ouargla 30 42 38 41
7 MO Constantine Constantine 30 33 31 40
8 Aïn M'lila Aïn M'lila 30 30 36 40
9 Skikda Skikda 30 28 34 40
10 Hamra Annaba Hamra Annaba 30 28 29 39
11 US Chaouia US Chaouia 30 35 37 39
12 MO Béjaïa MO Béjaïa 30 39 31 38
13 El Eulma El Eulma 30 34 36 38
14 JSM Béjaïa Béjaïa 30 36 38 36
15 Bordj Bou Arreridj Bordj 30 35 64 23
16 Lakhdaria Lakhdaria 30 18 69 11
TEMPORADA 2020/2021
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 CR Belouizdad Belouizdad 38 71 27 79
2 ES Setif ES Setif 38 71 32 71
3 JS Saoura JS Saoura 38 62 30 69
4 USM Alger USM Alger 38 62 39 65
5 JS Kabylie JS Kabylie 38 44 33 61
6 MC Oran MC Oran 38 51 37 60
7 MC Alger MC Alger 38 59 43 57
8 CS Constantine Constantine 38 43 31 57
9 NC Magra NC Magra 38 38 44 52
10 Olympique Médéa Olympique 38 40 43 51
11 Paradou Paradou 38 53 53 50
12 NA Hussein Dey Hussein 38 46 45 47
13 RC Relizane RC Relizane 38 39 51 47
14 Biskra Biskra 38 32 46 46
15 Chlef Chlef 38 40 53 45
16 Tlemcen Tlemcen 38 40 46 45
17 Aïn M'lila Aïn M'lila 38 37 55 44
18 USM Bel Abbès Abbès 38 32 58 38
19 Bordj Bou Arreridj Bordj 38 29 67 22
20 Skikda Skikda 38 17 73 18
TEMPORADA 2019/2020
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 CR Belouizdad Belouizdad 21 30 16 40
2 ES Setif ES Setif 22 34 19 37
3 MC Alger MC Alger 21 31 25 37
4 JS Kabylie JS Kabylie 22 27 18 36
5 CS Constantine Constantine 22 32 23 34
6 JS Saoura JS Saoura 22 19 18 33
7 Aïn M'lila Aïn M'lila 22 26 25 32
8 MC Oran MC Oran 22 28 24 30
9 USM Alger USM Alger 22 25 25 29
10 Paradou Paradou 20 20 18 26
11 USM Bel Abbès Abbès 21 22 31 26
12 Chlef Chlef 21 15 17 25
13 Bordj Bou Arreridj Bordj 22 22 29 25
14 Biskra Biskra 22 17 33 21
15 NA Hussein Dey Hussein 22 14 27 19
16 NC Magra NC Magra 22 16 30 19
TEMPORADA 2018/2019
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 USM Alger USM Alger 30 49 29 53
2 JS Kabylie JS Kabylie 30 38 25 52
3 Paradou Paradou 30 38 24 48
4 JS Saoura JS Saoura 30 33 22 47
5 ES Setif ES Setif 30 34 24 45
6 MC Alger MC Alger 30 35 36 43
7 CS Constantine Constantine 30 30 24 40
8 CR Belouizdad Belouizdad 30 28 27 38
9 Bordj Bou Arreridj Bordj 30 22 24 37
10 MC Oran MC Oran 30 33 38 36
11 NA Hussein Dey Hussein 30 22 29 36
12 Aïn M'lila Aïn M'lila 30 20 30 36
13 USM Bel Abbès Abbès 30 24 39 35
14 MO Béjaïa MO Béjaïa 30 23 36 33
15 Olympique Médéa Olympique 30 21 31 31
16 DRB Tadjenant Tadjenant 30 26 38 31
TEMPORADA 2017/2018
SEGUNDA ARGELIA
Equipo PJ GF GC Puntos
1 MO Béjaïa MO Béjaïa 30 39 17 60
2 Aïn M'lila Aïn M'lila 30 44 34 54
3 Bordj Bou Arreridj Bordj 30 40 27 53
4 JSM Béjaïa Béjaïa 30 39 30 53
5 Chlef Chlef 30 30 22 46
6 Skikda Skikda 30 31 33 41
7 ASM Oran ASM Oran 30 31 34 41
8 MC Saida MC Saida 30 24 28 40
9 RC Relizane RC Relizane 30 30 33 39
10 Amal Bou Saâda Amal Saâda 30 26 31 38
11 RC Kouba RC Kouba 30 31 39 38
12 Tlemcen Tlemcen 30 26 27 37
13 El Eulma El Eulma 30 33 38 37
14 GC Mascara GC Mascara 30 32 37 34
15 CA Batna CA Batna 30 27 35 31
16 Aïn Fakroun Aïn Fakroun 30 27 45 23
TEMPORADA 2016/2017
SEGUNDA ARGELIA
Equipo PJ GF GC Puntos
1 Paradou Paradou 30 43 27 59
2 USM Blida USM Blida 30 31 19 51
3 Biskra Biskra 30 36 26 51
4 JSM Béjaïa Béjaïa 30 33 30 46
5 Skikda Skikda 30 33 24 43
6 Amal Bou Saâda Amal Saâda 30 32 31 40
7 Chlef Chlef 30 31 31 40
8 MC Saida MC Saida 30 28 30 40
9 Bordj Bou Arreridj Bordj 30 30 31 39
10 El Eulma El Eulma 30 27 28 36
11 ASM Oran ASM Oran 30 30 32 36
12 Aïn Fakroun Aïn Fakroun 30 26 33 36
13 GC Mascara GC Mascara 30 26 32 35
14 WA Boufarik WA Boufarik 30 22 31 32
15 RC Arba RC Arba 30 26 29 28
16 Khroub Khroub 30 23 43 25
TEMPORADA 2015/2016
SEGUNDA ARGELIA
Equipo PJ GF GC Puntos
1 Olympique Médéa Olympique 30 32 22 54
2 CA Batna CA Batna 30 27 17 50
3 USM Bel Abbès Abbès 30 27 18 49
4 Paradou Paradou 30 40 26 46
5 El Eulma El Eulma 30 28 25 40
6 Skikda Skikda 30 35 33 40
7 Amal Bou Saâda Amal Saâda 30 29 31 40
8 Bordj Bou Arreridj Bordj 30 31 29 39
9 Aïn Fakroun Aïn Fakroun 30 22 21 39
10 Khroub Khroub 30 34 36 39
11 MC Saida MC Saida 30 29 32 39
12 Chlef Chlef 30 30 31 38
13 JSM Béjaïa Béjaïa 30 25 29 38
14 US Chaouia US Chaouia 30 26 29 37
15 Arzew Arzew 30 28 41 37
16 USMM Hadjout USMM Hadjout 30 22 45 19
TEMPORADA 2014/2015
SEGUNDA ARGELIA
Equipo PJ GF GC Puntos
1 USM Blida USM Blida 29 34 21 52
2 RC Relizane RC Relizane 30 36 30 48
3 DRB Tadjenant Tadjenant 29 26 21 48
4 Bordj Bou Arreridj Bordj 30 33 29 45
5 Olympique Médéa Olympique 30 30 21 44
6 MC Saida MC Saida 30 24 19 43
7 CA Batna CA Batna 30 21 19 41
8 Khroub Khroub 30 29 36 40
9 JSM Béjaïa Béjaïa 30 39 37 39
10 Amal Bou Saâda Amal Saâda 29 25 33 39
11 Aïn Fakroun Aïn Fakroun 30 24 25 38
12 US Chaouia US Chaouia 29 26 29 37
13 USMM Hadjout USMM Hadjout 29 29 35 34
14 Tlemcen Tlemcen 29 20 23 33
15 ESM Kolea ESM Kolea 29 25 30 31
16 AB Merouana AB Merouana 29 18 31 27
TEMPORADA 2013/2014
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 USM Alger USM Alger 30 49 21 68
2 JS Kabylie JS Kabylie 30 39 21 54
3 ES Setif ES Setif 30 40 26 53
4 El Eulma El Eulma 30 38 29 48
5 USM El Harrach Harrach 30 34 27 47
6 MC Alger MC Alger 30 26 25 45
7 RC Arba RC Arba 30 33 32 44
8 Chlef Chlef 30 29 20 43
9 JS Saoura JS Saoura 30 39 36 43
10 CS Constantine Constantine 30 29 32 41
11 MO Béjaïa MO Béjaïa 30 29 35 36
12 MC Oran MC Oran 30 33 40 35
13 CR Belouizdad Belouizdad 30 26 33 32
14 JSM Béjaïa Béjaïa 30 24 44 28
15 Bordj Bou Arreridj Bordj 30 23 47 21
16 Aïn Fakroun Aïn Fakroun 30 16 39 20
TEMPORADA 2012/2013
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 ES Setif ES Setif 30 55 27 59
2 USM El Harrach Harrach 30 40 22 57
3 CS Constantine Constantine 30 37 20 52
4 USM Alger USM Alger 30 32 15 51
5 MC Alger MC Alger 30 33 26 50
6 CR Belouizdad Belouizdad 30 32 26 44
7 JS Kabylie JS Kabylie 30 32 31 41
8 El Eulma El Eulma 30 29 27 40
9 JS Saoura JS Saoura 30 28 26 38
10 Chlef Chlef 30 26 29 38
11 JSM Béjaïa Béjaïa 30 28 32 38
12 MC Oran MC Oran 30 33 41 34
13 Bordj Bou Arreridj Bordj 30 20 26 33
14 CA Batna CA Batna 30 20 46 26
15 Tlemcen Tlemcen 30 19 43 24
16 USM Bel Abbès Abbès 30 18 45 22
TEMPORADA 2011/2012
SEGUNDA ARGELIA
Equipo PJ GF GC Puntos
1 Bordj Bou Arreridj Bordj 30 36 21 57
2 JS Saoura JS Saoura 30 48 26 56
3 USM Bel Abbès Abbès 30 34 24 50
4 MO Béjaïa MO Béjaïa 30 43 30 49
5 USM Blida USM Blida 30 40 36 45
6 ES Mostaganem Mostaganem 30 38 32 44
7 ASM Oran ASM Oran 30 34 36 41
8 USM Annaba USM Annaba 30 31 34 40
9 MSP Batna MSP Batna 30 24 27 40
10 AB Merouana AB Merouana 30 24 29 39
11 MO Constantine Constantine 30 36 40 38
12 Olympique Médéa Olympique 30 24 29 38
13 Mohammadia Mohammadia 30 30 48 36
14 Paradou Paradou 30 34 34 35
15 RC Kouba RC Kouba 30 29 39 32
16 Biskra Biskra 30 26 46 21
TEMPORADA 2010/2011
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 Chlef Chlef 30 51 20 63
2 JSM Béjaïa Béjaïa 30 47 32 50
3 ES Setif ES Setif 30 43 31 47
4 USM El Harrach Harrach 30 36 31 46
5 CR Belouizdad Belouizdad 30 33 26 45
6 MC Saida MC Saida 30 33 35 42
7 MC Oran MC Oran 30 26 27 41
8 Khroub Khroub 30 30 36 39
9 USM Alger USM Alger 30 32 28 38
10 MC Alger MC Alger 30 30 28 37
11 Tlemcen Tlemcen 30 35 36 37
12 JS Kabylie JS Kabylie 30 26 37 37
13 El Eulma El Eulma 30 32 40 36
14 USM Annaba USM Annaba 30 23 34 36
15 USM Blida USM Blida 30 16 30 29
16 Bordj Bou Arreridj Bordj 30 21 43 29
TEMPORADA 2009/2010
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 MC Alger MC Alger 34 50 23 66
2 ES Setif ES Setif 34 51 32 63
3 JS Kabylie JS Kabylie 34 39 27 54
4 USM Alger USM Alger 34 47 33 53
5 USM El Harrach Harrach 34 46 33 52
6 JSM Béjaïa Béjaïa 34 47 35 52
7 USM Annaba USM Annaba 34 40 35 49
8 Tlemcen Tlemcen 34 43 43 46
9 CR Belouizdad Belouizdad 34 37 38 46
10 Bordj Bou Arreridj Bordj 34 41 45 46
11 Khroub Khroub 34 37 45 45
12 Chlef Chlef 34 38 41 43
13 El Eulma El Eulma 34 33 36 43
14 USM Blida USM Blida 34 30 33 43
15 MC Oran MC Oran 34 33 42 41
16 CA Batna CA Batna 34 27 40 37
17 MSP Batna MSP Batna 34 23 54 24
18 NA Hussein Dey Hussein 34 22 49 19
TEMPORADA 2008/2009
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 ES Setif ES Setif 32 52 25 62
2 JS Kabylie JS Kabylie 32 38 19 59
3 JSM Béjaïa Béjaïa 32 33 20 53
4 CR Belouizdad Belouizdad 32 33 27 50
5 MC Alger MC Alger 32 40 38 49
6 USM Alger USM Alger 32 38 31 48
7 Bordj Bou Arreridj Bordj 32 34 33 48
8 El Eulma El Eulma 32 37 35 46
9 Chlef Chlef 32 40 43 44
10 USM Annaba USM Annaba 32 31 34 41
11 USM El Harrach Harrach 32 36 40 40
12 Khroub Khroub 32 30 37 39
13 NA Hussein Dey Hussein 32 28 35 39
14 MSP Batna MSP Batna 32 26 35 38
15 USM Blida USM Blida 32 23 31 33
16 MC Saida MC Saida 32 25 40 29
17 RC Kouba RC Kouba 32 23 44 23
TEMPORADA 2007/2008
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 JS Kabylie JS Kabylie 30 46 24 59
2 Chlef Chlef 30 29 22 49
3 ES Setif ES Setif 30 32 27 43
4 USM Alger USM Alger 30 32 27 42
5 USM Annaba USM Annaba 30 36 37 42
6 MC Saida MC Saida 30 32 38 42
7 MC Alger MC Alger 30 26 25 39
8 JSM Béjaïa Béjaïa 30 38 40 39
9 Khroub Khroub 30 26 28 39
10 CR Belouizdad Belouizdad 30 21 21 38
11 NA Hussein Dey Hussein 30 35 38 38
12 Bordj Bou Arreridj Bordj 30 25 28 38
13 USM Blida USM Blida 30 33 34 37
14 MC Oran MC Oran 30 28 34 37
15 El Annasser El Annasser 30 25 30 36
16 Tlemcen Tlemcen 30 28 39 30
TEMPORADA 2006/2007
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 ES Setif ES Setif 30 32 19 54
2 JS Kabylie JS Kabylie 30 33 20 52
3 JSM Béjaïa Béjaïa 30 30 19 49
4 USM Alger USM Alger 30 32 25 47
5 Chlef Chlef 30 29 22 46
6 MC Oran MC Oran 30 28 25 42
7 NA Hussein Dey Hussein 30 27 33 41
8 Bordj Bou Arreridj Bordj 30 24 38 40
9 USM Blida USM Blida 30 33 28 39
10 CR Belouizdad Belouizdad 30 34 37 39
11 MC Alger MC Alger 30 34 30 38
12 Tlemcen Tlemcen 30 24 32 38
13 El Annasser El Annasser 30 33 35 36
14 Paradou Paradou 30 31 32 34
15 ASM Oran ASM Oran 30 28 38 27
16 CA Batna CA Batna 30 28 47 27
TEMPORADA 2005/2006
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 JS Kabylie JS Kabylie 30 47 21 58
2 USM Alger USM Alger 30 49 30 57
3 Chlef Chlef 30 45 25 52
4 ES Setif ES Setif 30 30 26 47
5 Bordj Bou Arreridj Bordj 30 22 23 46
6 MC Alger MC Alger 30 42 35 44
7 CR Belouizdad Belouizdad 30 30 31 40
8 Paradou Paradou 30 36 38 40
9 CA Batna CA Batna 30 32 35 38
10 USM Blida USM Blida 30 25 30 38
11 NA Hussein Dey Hussein 30 27 35 38
12 MC Oran MC Oran 30 35 41 37
13 Tlemcen Tlemcen 30 25 33 37
14 CS Constantine Constantine 30 27 35 36
15 USM Annaba USM Annaba 30 32 40 35
16 Biskra Biskra 30 13 39 20
TEMPORADA 2004/2005
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 USM Alger USM Alger 30 54 26 67
2 JS Kabylie JS Kabylie 30 43 20 54
3 MC Alger MC Alger 30 38 43 49
4 NA Hussein Dey Hussein 30 28 18 43
5 USM Blida USM Blida 30 36 29 42
6 Bordj Bou Arreridj Bordj 30 31 25 42
7 Chlef Chlef 30 30 32 41
8 CS Constantine Constantine 30 33 42 40
9 MC Oran MC Oran 30 35 36 39
10 ES Setif ES Setif 30 37 36 38
11 USM Annaba USM Annaba 30 30 36 37
12 Tlemcen Tlemcen 30 32 27 36
13 CR Belouizdad Belouizdad 30 24 34 36
14 El Annasser El Annasser 30 31 34 35
15 GC Mascara GC Mascara 30 33 47 32
16 US Chaouia US Chaouia 30 17 47 23
TEMPORADA 2003/2004
LIGA ARGELIA
Equipo PJ GF GC Puntos
1 JS Kabylie JS Kabylie 30 40 21 61
2 USM Alger USM Alger 30 49 23 58
3 NA Hussein Dey Hussein 30 31 19 49
4 ES Setif ES Setif 30 41 31 47
5 MC Alger MC Alger 30 35 34 47
6 MC Oran MC Oran 30 34 33 44
7 USM Blida USM Blida 30 34 29 41
8 Chlef Chlef 30 19 22 40
9 Chabab Ahly Chabab Ahly 30 32 28 38
10 Tlemcen Tlemcen 30 22 25 38
11 US Chaouia US Chaouia 30 24 37 38
12 USM Annaba USM Annaba 30 40 37 37
13 CR Belouizdad Belouizdad 30 38 32 36
14 CA Batna CA Batna 30 27 36 33
15 RC Kouba RC Kouba 30 23 39 29
16 JSM Béjaïa Béjaïa 30 17 60 17

  USO DE MEMORIA  
7,246,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  1.0827
Total Execution Time  1.0839
  CADENA URL  
/historico/Bordj-Bou-Arreridj
  GET DATOS  
$_GET['/historico/Bordj-Bou-Arreridj']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (75)  
0.0131  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 = 'Bordj-Bou-Arreridj' 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.0273  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 = 'Bordj-Bou-Arreridj' 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 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=11514 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=11514 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=11514 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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 = 65390
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11514 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=400 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 400 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1083754,961158,245286,244317,87628) ORDER BY n.cover_points DESC, update_date DESC
0.0129  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 = '11514' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '11514' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 65390 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=11514 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (65390,62220,60191) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 60191 AND teamId = 11514
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 65390 AND teamId = 11514
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 62220 AND teamId = 11514
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 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 = 65390 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '11514' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11514' and rp.type = 4
0.0127  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 = '11514' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 events2022 e ON e.player_id = p.id AND e.league_id = 65390 WHERE rp.league_id = 65390 AND rp.teamId = 11514 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.0126  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 events2022 e ON e.player_id = p.id AND e.league_id = 65390 WHERE rp.league_id = 65390 AND rp.teamId = 11514 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 events2022 e ON e.player_id = p.id AND e.league_id = 65390 WHERE rp.league_id = 65390 AND rp.teamId = 11514 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 11514 AND l.year <= 2022 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 `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 = 65390 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 60191 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `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 = 49905 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 43669 AND t.round = 30 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 `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 = 39165 AND t.round = 30 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 `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 = 34048 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15491 AND t.round = 30 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 = 3888 AND t.round = 30 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 = 2426 AND t.round = 30 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 `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 = 2262 AND t.round = 30 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 `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 = 8904 AND t.round = 30 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 `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 = 8613 AND t.round = 30 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 `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 = 8614 AND t.round = 34 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 `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 = 8615 AND t.round = 34 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 `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 = 8616 AND t.round = 30 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 `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 = 8617 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 8618 AND t.round = 30 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 `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 = 8619 AND t.round = 30 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 `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 = 27451 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 65390 ORDER BY nameShow LIMIT 100