4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1983/1984
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Burgos Burgos 38 111 21 62
2 Cultural Leonesa Cultural 38 71 27 56
3 Atl. Astorga Atl. Astorga 38 70 39 53
4 Atl. Bembibre Atl. 38 61 33 50
5 Ponferradina Ponferradina 38 61 37 50
6 Real Valladolid Promesas Real 38 78 30 47
7 Salamanca UDS Salamanca 38 56 35 46
8 Toreno Toreno 38 40 39 40
9 Polideportivo Salas Polideportiv 38 63 73 36
10 Gimnástica Arandina Gimnástica 38 46 49 35
11 Palencia Palencia 38 43 66 35
12 Cd Universidad Valladolid Universidad 38 53 61 33
13 Toresana Toresana 38 38 65 31
14 La Bañeza La Bañeza 38 41 54 30
15 Coyanza Coyanza 38 45 67 28
16 Gimnástica Medinense Gimnástica 38 36 75 27
17 Venta De Baños Venta Baños 38 38 63 26
18 Cacabelense Cacabelense 38 34 74 26
19 CD Guardo CD Guardo 38 43 74 26
20 Poli Ejido Poli Ejido 38 32 78 23
TEMPORADA 1982/1983
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Bilbao Ath. Bilbao Ath. 38 91 35 59
2 Tenerife Tenerife 38 75 36 52
3 Burgos Burgos 38 61 31 47
4 Sestao Sport Club Sestao Sport 38 56 38 46
5 Gimnàstic Tarragona Gimnàstic 38 39 30 42
6 Real Sociedad B Real 38 37 35 41
7 CD Logroñés Logroñés 38 44 35 40
8 FC Andorra FC Andorra 38 43 47 39
9 Racing Ferrol Racing 38 45 48 39
10 Lleida Lleida 38 46 47 39
11 SD Compostela Compostela 38 30 39 39
12 Huesca Huesca 38 42 45 37
13 Osasuna Promesas Osasuna 38 35 42 34
14 Barakaldo Barakaldo 38 37 53 34
15 Andorra Andorra 38 49 66 33
16 Sporting Atlético Sporting 38 47 53 32
17 SD Erandio SD Erandio 38 28 42 31
18 CD Binéfar CD Binéfar 38 40 57 31
19 Cultural Leonesa Cultural 38 34 52 28
20 Reus Deportiu Reus 38 28 76 17
TEMPORADA 1981/1982
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Celta Celta 38 79 40 53
2 UD Salamanca Salamanca 38 70 33 51
3 CD Málaga CD Málaga 38 70 35 50
4 Elche Elche 38 55 31 50
5 Real Murcia Real Murcia 38 54 38 46
6 Mallorca Mallorca 38 55 46 42
7 Rayo Vallecano Rayo 38 45 44 41
8 RM Castilla RM Castilla 38 48 48 40
9 Burgos Burgos 38 46 41 40
10 Atlético B Atlético B 38 44 44 38
11 CE Sabadell CE Sabadell 38 59 63 38
12 RC Deportivo Deportivo 38 40 48 37
13 Córdoba CF Córdoba CF 38 45 49 36
14 Recreativo Recreativo 38 39 40 35
15 Linares CF Linares CF 38 42 57 34
16 Real Oviedo Real Oviedo 38 34 53 31
17 AD Almería AD Almería 38 27 43 30
18 Deportivo Alavés Deportivo 38 38 52 29
19 Levante Levante 38 26 74 20
20 Getafe Deportivo Getafe 38 39 76 19
TEMPORADA 1980/1981
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 CD Castellón Castellón 38 45 33 45
2 Cádiz Cádiz 38 55 37 45
3 Racing Racing 38 48 40 45
4 Elche Elche 38 55 44 45
5 Rayo Vallecano Rayo 38 37 23 45
6 CD Málaga CD Málaga 38 47 45 42
7 CE Sabadell CE Sabadell 38 45 44 42
8 Deportivo Alavés Deportivo 38 49 35 39
9 Levante Levante 38 36 37 38
10 Real Oviedo Real Oviedo 38 37 39 37
11 RM Castilla RM Castilla 38 50 44 36
12 Linares CF Linares CF 38 36 42 36
13 Getafe Deportivo Getafe 38 41 50 35
14 Atlético B Atlético B 38 44 55 35
15 Burgos Burgos 38 47 52 35
16 Recreativo Recreativo 38 33 37 35
17 Granada Granada 38 33 45 33
18 Palencia Palencia 38 30 37 32
19 Barakaldo Barakaldo 38 34 46 31
20 AgD Ceuta AgD Ceuta 38 33 50 29
TEMPORADA 1979/1980
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 34 70 33 53
2 Real Sociedad Real 34 54 20 52
3 Real Sporting Real 34 47 34 39
4 Barcelona Barcelona 34 42 33 38
5 Real Betis Real Betis 34 42 40 36
6 Valencia Valencia 34 50 42 36
7 Athletic Athletic 34 52 44 35
8 Sevilla Sevilla 34 50 47 34
9 UD Salamanca Salamanca 34 37 37 34
10 AD Almería AD Almería 34 42 50 33
11 Real Zaragoza Real 34 43 40 33
12 Las Palmas Las Palmas 34 36 49 32
13 Atlético Atlético 34 38 44 31
14 Espanyol Espanyol 34 28 37 30
15 Hércules Hércules 34 36 39 28
16 Rayo Vallecano Rayo 34 46 61 26
17 Burgos Burgos 34 29 61 20
18 CD Málaga CD Málaga 34 28 59 19
TEMPORADA 1978/1979
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 34 61 36 47
2 Real Sporting Real 34 50 35 43
3 Atlético Atlético 34 55 37 41
4 Real Sociedad Real 34 53 36 41
5 Barcelona Barcelona 34 69 37 38
6 Las Palmas Las Palmas 34 49 43 37
7 Valencia Valencia 34 44 39 35
8 Espanyol Espanyol 34 37 46 35
9 Athletic Athletic 34 56 46 34
10 UD Salamanca Salamanca 34 36 40 34
11 Sevilla Sevilla 34 47 48 33
12 Hércules Hércules 34 32 38 32
13 Burgos Burgos 34 38 47 32
14 Real Zaragoza Real 34 56 59 30
15 Rayo Vallecano Rayo 34 31 54 29
16 Celta Celta 34 35 55 28
17 Racing Racing 34 37 63 22
18 Recreativo Recreativo 34 39 66 21
TEMPORADA 1977/1978
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 34 77 40 47
2 Barcelona Barcelona 34 49 29 41
3 Athletic Athletic 34 62 36 40
4 Valencia Valencia 34 54 33 39
5 Real Sporting Real 34 53 43 39
6 Atlético Atlético 34 61 52 36
7 Las Palmas Las Palmas 34 43 41 35
8 Sevilla Sevilla 34 38 45 34
9 UD Salamanca Salamanca 34 37 40 34
10 Rayo Vallecano Rayo 34 50 59 33
11 Real Sociedad Real 34 52 46 33
12 Burgos Burgos 34 33 47 31
13 Racing Racing 34 29 45 31
14 Espanyol Espanyol 34 48 60 30
15 Hércules Hércules 34 32 40 30
16 Real Betis Real Betis 34 51 52 30
17 Elche Elche 34 44 66 27
18 Cádiz Cádiz 34 30 69 22
TEMPORADA 1976/1977
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Atlético Atlético 34 62 33 46
2 Barcelona Barcelona 34 69 34 45
3 Athletic Athletic 34 55 45 38
4 Las Palmas Las Palmas 34 56 51 36
5 Real Betis Real Betis 34 42 42 36
6 Espanyol Espanyol 34 61 59 36
7 Valencia Valencia 34 53 47 36
8 Real Sociedad Real 34 54 41 34
9 Real Madrid Real Madrid 34 57 53 34
10 Sevilla Sevilla 34 32 39 34
11 Elche Elche 34 45 47 33
12 UD Salamanca Salamanca 34 30 34 32
13 Hércules Hércules 34 35 41 32
14 Burgos Burgos 34 46 50 32
15 Racing Racing 34 41 62 31
16 Real Zaragoza Real 34 42 51 30
17 Celta Celta 34 22 40 29
18 CD Málaga CD Málaga 34 27 60 18
TEMPORADA 1975/1976
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Burgos Burgos 38 54 31 51
2 Celta Celta 38 42 22 49
3 CD Málaga CD Málaga 38 75 39 47
4 Real Valladolid Real 38 44 27 43
5 RC Deportivo Deportivo 38 47 36 42
6 Barça Atlètic Barça 38 46 47 41
7 Tenerife Tenerife 38 50 44 40
8 Córdoba CF Córdoba CF 38 48 48 38
9 Rayo Vallecano Rayo 38 48 49 36
10 Recreativo Recreativo 38 35 42 36
11 Puertollano Puertollano 38 42 51 36
12 CD Castellón Castellón 38 45 47 36
13 Cádiz Cádiz 38 46 43 35
14 UE Sant Andreu Sant Andreu 38 38 45 35
15 Deportivo Alavés Deportivo 38 33 46 34
16 Terrassa FC Terrassa FC 38 35 45 34
17 Real Murcia Real Murcia 38 46 61 33
18 Ensidesa Ensidesa 38 31 46 33
19 Osasuna Osasuna 38 47 58 33
20 Gimnàstic Tarragona Gimnàstic 38 29 54 28
TEMPORADA 1974/1975
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Oviedo Real Oviedo 38 52 29 52
2 Racing Racing 38 49 34 52
3 Sevilla Sevilla 38 58 27 51
4 Córdoba CF Córdoba CF 38 59 34 46
5 Cádiz Cádiz 38 54 43 43
6 CD Castellón Castellón 38 48 39 42
7 UE Sant Andreu Sant Andreu 38 35 31 39
8 Rayo Vallecano Rayo 38 47 47 38
9 Burgos Burgos 38 54 46 38
10 Barça Atlètic Barça 38 46 52 38
11 Real Valladolid Real 38 48 45 36
12 Tenerife Tenerife 38 50 56 36
13 Gimnàstic Tarragona Gimnàstic 38 34 36 35
14 Recreativo Recreativo 38 39 43 35
15 Barakaldo Barakaldo 38 33 54 33
16 Deportivo Alavés Deportivo 38 35 45 33
17 Mallorca Mallorca 38 42 56 33
18 CD Ourense CD Ourense 38 30 44 32
19 CE Sabadell CE Sabadell 38 54 69 26
20 Cultural Leonesa Cultural 38 31 68 22
TEMPORADA 1973/1974
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Betis Real Betis 38 69 31 51
2 Hércules Hércules 38 51 34 49
3 UD Salamanca Salamanca 38 53 39 48
4 Tenerife Tenerife 38 57 41 46
5 Cádiz Cádiz 38 52 37 46
6 Gimnàstic Tarragona Gimnàstic 38 46 40 41
7 Real Valladolid Real 38 61 50 41
8 UE Sant Andreu Sant Andreu 38 47 38 39
9 Sevilla Sevilla 38 48 40 39
10 Barakaldo Barakaldo 38 49 52 39
11 Mallorca Mallorca 38 36 32 39
12 CD Ourense CD Ourense 38 43 45 38
13 Córdoba CF Córdoba CF 38 58 58 38
14 Rayo Vallecano Rayo 38 39 51 33
15 CE Sabadell CE Sabadell 38 35 52 33
16 Burgos Burgos 38 34 44 32
17 Osasuna Osasuna 38 36 63 28
18 RC Deportivo Deportivo 38 30 56 28
19 Levante Levante 38 37 48 27
20 Linares CF Linares CF 38 29 59 25
TEMPORADA 1972/1973
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Atlético Atlético 34 49 29 48
2 Barcelona Barcelona 34 41 21 46
3 Espanyol Espanyol 34 48 27 45
4 Real Madrid Real Madrid 34 45 29 43
5 CD Castellón Castellón 34 44 38 35
6 Valencia Valencia 34 37 33 34
7 Real Sociedad Real 34 37 39 34
8 Real Zaragoza Real 34 36 36 34
9 Athletic Athletic 34 41 38 33
10 CD Málaga CD Málaga 34 33 29 33
11 Las Palmas Las Palmas 34 38 44 31
12 Real Oviedo Real Oviedo 34 33 44 30
13 Granada Granada 34 25 32 29
14 Real Sporting Real 34 32 37 29
15 Celta Celta 34 30 37 29
16 Real Betis Real Betis 34 29 36 28
17 RC Deportivo Deportivo 34 22 44 27
18 Burgos Burgos 34 36 63 24
TEMPORADA 1971/1972
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 34 51 27 47
2 Valencia Valencia 34 53 30 45
3 Barcelona Barcelona 34 40 26 43
4 Atlético Atlético 34 45 28 39
5 Las Palmas Las Palmas 34 40 36 38
6 Granada Granada 34 40 34 36
7 CD Málaga CD Málaga 34 27 31 35
8 Real Sociedad Real 34 38 36 34
9 Athletic Athletic 34 39 32 34
10 Celta Celta 34 37 42 33
11 Real Sporting Real 34 41 37 32
12 Espanyol Espanyol 34 43 43 32
13 Real Betis Real Betis 34 25 45 30
14 RC Deportivo Deportivo 34 28 38 30
15 Burgos Burgos 34 34 42 29
16 Sevilla Sevilla 34 35 45 27
17 Córdoba CF Córdoba CF 34 32 51 25
18 CE Sabadell CE Sabadell 34 27 52 23
TEMPORADA 1970/1971
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Betis Real Betis 38 54 28 53
2 Burgos Burgos 38 46 30 45
3 RC Deportivo Deportivo 38 44 32 45
4 Córdoba CF Córdoba CF 38 50 30 45
5 Rayo Vallecano Rayo 38 51 29 45
6 CD Castellón Castellón 38 40 31 43
7 UE Sant Andreu Sant Andreu 38 34 36 40
8 Racing Ferrol Racing 38 39 43 40
9 Mallorca Mallorca 38 43 35 40
10 Pontevedra Pontevedra 38 44 41 40
11 Hércules Hércules 38 39 48 37
12 Cádiz Cádiz 38 32 40 37
13 Racing Racing 38 48 50 36
14 Real Oviedo Real Oviedo 38 41 37 34
15 CD Logroñés Logroñés 38 35 38 33
16 Villarreal Villarreal 38 37 55 32
17 Langreo Langreo 38 24 42 32
18 Ontinyent CF Ontinyent 38 30 47 31
19 Puertollano Puertollano 38 38 48 29
20 CD Colonia Moscardó Colonia 38 22 51 23
TEMPORADA 1969/1970
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Sporting Real 38 77 32 54
2 CD Málaga CD Málaga 38 56 33 49
3 Espanyol Espanyol 38 64 35 49
4 Real Betis Real Betis 38 44 34 47
5 Córdoba CF Córdoba CF 38 40 40 43
6 Rayo Vallecano Rayo 38 41 32 41
7 Real Oviedo Real Oviedo 38 39 32 40
8 UE Sant Andreu Sant Andreu 38 32 34 37
9 Ontinyent CF Ontinyent 38 34 33 36
10 Racing Ferrol Racing 38 37 50 36
11 CD Castellón Castellón 38 36 43 35
12 Puertollano Puertollano 38 37 43 35
13 Bilbao Ath. Bilbao Ath. 38 33 39 35
14 Burgos Burgos 38 46 54 35
15 Osasuna Osasuna 38 52 57 33
16 Ilicitano Ilicitano 38 46 59 32
17 Real Valladolid Real 38 45 59 32
18 Real Murcia Real Murcia 38 34 46 31
19 UD Salamanca Salamanca 38 35 54 30
20 CD Ourense CD Ourense 38 36 55 30
TEMPORADA 1968/1969
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Sevilla Sevilla 38 56 30 53
2 Celta Celta 38 63 28 52
3 Mallorca Mallorca 38 62 37 50
4 Racing Ferrol Racing 38 55 39 47
5 Real Sporting Real 38 60 46 42
6 Puertollano Puertollano 38 47 41 42
7 Real Betis Real Betis 38 69 51 41
8 Real Murcia Real Murcia 38 52 48 40
9 Rayo Vallecano Rayo 38 51 44 40
10 Real Valladolid Real 38 61 48 39
11 Real Oviedo Real Oviedo 38 45 45 38
12 Burgos Burgos 38 47 53 38
13 Alcoyano Alcoyano 38 51 55 35
14 Deportivo Alavés Deportivo 38 47 62 35
15 Ontinyent CF Ontinyent 38 47 54 34
16 Ilicitano Ilicitano 38 50 58 32
17 Valencia Mestalla Valencia 38 53 62 30
18 Cádiz Cádiz 38 44 65 30
19 SD Indautxu SD Indautxu 38 40 79 24
20 Jerez Industrial CF Jerez 38 36 91 18
TEMPORADA 1967/1968
SEGUNDA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 RC Deportivo Deportivo 30 53 29 43
2 Real Valladolid Real 30 48 27 41
3 Celta Celta 30 57 33 36
4 Rayo Vallecano Rayo 30 44 39 36
5 Real Sporting Real 30 47 38 34
6 Real Oviedo Real Oviedo 30 43 29 32
7 Racing Ferrol Racing 30 42 37 32
8 Burgos Burgos 30 34 35 32
9 Badalona Badalona 30 44 30 30
10 Langreo Langreo 30 32 37 28
11 Racing Racing 30 39 38 27
12 Lleida Lleida 30 25 51 24
13 CD Badajoz CD Badajoz 30 31 52 22
14 CE Europa CE Europa 30 32 56 21
15 Osasuna Osasuna 30 31 48 21
16 Gimnástica Torrelavega Gimnástica 30 25 48 21
TEMPORADA 1966/1967
SEGUNDA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Sociedad Real 30 46 22 46
2 Real Sporting Real 30 55 22 45
3 Celta Celta 30 43 25 36
4 Osasuna Osasuna 30 52 39 35
5 Real Oviedo Real Oviedo 30 57 38 35
6 Rayo Vallecano Rayo 30 45 31 30
7 Racing Ferrol Racing 30 41 30 30
8 Puertollano Puertollano 30 38 38 30
9 Real Valladolid Real 30 38 43 29
10 Gimnástica Torrelavega Gimnástica 30 33 53 28
11 Tenerife Tenerife 30 40 47 28
12 Racing Racing 30 42 53 26
13 Langreo Langreo 30 32 42 25
14 Burgos Burgos 30 40 49 23
15 CD Logroñés Logroñés 30 16 47 18
16 SD Indautxu SD Indautxu 30 17 56 16
TEMPORADA 1965/1966
SEGUNDA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 RC Deportivo Deportivo 30 53 19 43
2 Celta Celta 30 54 28 39
3 Real Sporting Real 30 67 50 36
4 Real Oviedo Real Oviedo 30 38 22 34
5 Burgos Burgos 30 42 41 32
6 SD Indautxu SD Indautxu 30 47 47 32
7 Condal CD Condal CD 30 55 46 32
8 Racing Racing 30 38 40 31
9 Osasuna Osasuna 30 39 41 31
10 Real Sociedad Real 30 50 48 31
11 Lleida Lleida 30 37 31 30
12 Badalona Badalona 30 32 41 30
13 Langreo Langreo 30 37 58 23
14 CE Europa CE Europa 30 33 49 23
15 L´Hospitalet L´Hospitale 30 37 63 19
16 Barakaldo Barakaldo 30 24 59 14
TEMPORADA 1964/1965
SEGUNDA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Pontevedra Pontevedra 30 48 17 45
2 CE Sabadell CE Sabadell 30 46 28 39
3 Real Sporting Real 30 61 32 38
4 Real Sociedad Real 30 60 44 32
5 Celta Celta 30 35 34 30
6 Burgos Burgos 30 47 46 29
7 Racing Racing 30 52 51 29
8 SD Indautxu SD Indautxu 30 47 44 29
9 Barakaldo Barakaldo 30 41 44 28
10 Osasuna Osasuna 30 30 35 28
11 L´Hospitalet L´Hospitale 30 48 56 27
12 Langreo Langreo 30 40 51 27
13 CE Europa CE Europa 30 30 43 27
14 Badalona Badalona 30 31 43 25
15 CD Ourense CD Ourense 30 33 50 25
16 Real Unión Club Real Unión 30 24 55 22

  USO DE MEMORIA  
8,298,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1777
Total Execution Time  0.1789
  CADENA URL  
/historico/Burgos-Cf/1984
  GET DATOS  
$_GET['/historico/Burgos-Cf/1984']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0035  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 = 'Burgos-Cf' AND l.year = 1984 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.0019  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=565 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=565 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0033  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=565 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 21721
0.0026  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 = 21075
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=565 AND type_rel = 2
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 565 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (1312832,1193652,2598,2826,5092) ORDER BY n.cover_points DESC, update_date DESC
0.0030  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 = '565' AND l.year = 1984 ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '565' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 21721 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=565 AND l.year in (1983,1984,1985) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74472,21919,21736,21076,21064) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 21064 AND teamId = 565
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 21736 AND teamId = 565
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 21919 AND teamId = 565
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 74472 AND teamId = 565
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 21076 AND teamId = 565
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1984` 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 = 21721 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '565' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '565' and rp.type = 4
0.0023  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 = '565' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '565' and rp.type = 4
0.0019  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 events1984 e ON e.player_id = p.id AND e.league_id = 21721 WHERE rp.league_id = 21721 AND rp.teamId = 565 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.0019  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 events1984 e ON e.player_id = p.id AND e.league_id = 21721 WHERE rp.league_id = 21721 AND rp.teamId = 565 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events1984 e ON e.player_id = p.id AND e.league_id = 21721 WHERE rp.league_id = 21721 AND rp.teamId = 565 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 565 AND l.year <= 1984 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1984` 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 = 21721 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1983` 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 = 21064 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1982` 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 = 5478 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1981` 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 = 5477 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1980` 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 = 5405 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1979` 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 = 5404 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1978` 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 = 5403 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1976` 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 = 5472 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1975` 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 = 5471 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1974` 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 = 5470 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1973` 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 = 5398 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1972` 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 = 5397 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0069  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1971` 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 = 5467 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1970` 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 = 5466 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1969` 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 = 5465 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1968` 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 = 5464 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1967` 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 = 5463 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1966` 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 = 5462 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1965` 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 = 5461 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 21721 ORDER BY nameShow LIMIT 100