4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1963/1964
SEGUNDA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 RC Deportivo Deportivo 30 74 31 42
2 Real Sporting Real 30 53 33 39
3 CE Europa CE Europa 30 36 27 37
4 Racing Racing 30 45 32 35
5 Osasuna Osasuna 30 53 44 34
6 Real Sociedad Real 30 48 35 33
7 Burgos Burgos 30 40 38 32
8 CD Ourense CD Ourense 30 34 36 31
9 Celta Celta 30 39 37 29
10 Constància Constància 30 33 45 28
11 Langreo Langreo 30 33 40 27
12 SD Indautxu SD Indautxu 30 34 38 26
13 L´Hospitalet L´Hospitale 30 39 51 26
14 Badalona Badalona 30 39 57 24
15 UD Salamanca Salamanca 30 25 46 21
16 Deportivo Alavés Deportivo 30 36 71 16
TEMPORADA 1962/1963
SEGUNDA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Pontevedra Pontevedra 30 44 31 41
2 Espanyol Espanyol 30 40 24 39
3 Racing Racing 30 53 39 37
4 Real Sociedad Real 30 77 44 35
5 Real Sporting Real 30 50 46 34
6 Celta Celta 30 47 31 32
7 CD Ourense CD Ourense 30 43 37 31
8 Deportivo Alavés Deportivo 30 43 46 30
9 SD Indautxu SD Indautxu 30 46 42 30
10 Burgos Burgos 30 39 47 29
11 UD Salamanca Salamanca 30 40 46 27
12 Constància Constància 30 42 51 26
13 Langreo Langreo 30 33 42 25
14 Atlético Baleares Atlético 30 37 51 23
15 CD Basconia CD Basconia 30 31 65 21
16 CE Sabadell CE Sabadell 30 43 66 20
TEMPORADA 1961/1962
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 30 58 24 43
2 Barcelona Barcelona 30 81 46 40
3 Atlético Atlético 30 50 36 36
4 Real Zaragoza Real 30 70 51 35
5 Athletic Athletic 30 52 38 32
6 Sevilla Sevilla 30 48 45 31
7 Valencia Valencia 30 50 50 31
8 Elche Elche 30 52 52 29
9 Real Betis Real Betis 30 39 51 28
10 Real Oviedo Real Oviedo 30 27 47 27
11 Mallorca Mallorca 30 30 47 27
12 Osasuna Osasuna 30 54 59 27
13 Espanyol Espanyol 30 45 55 26
14 Racing Racing 30 35 54 26
15 Real Sociedad Real 30 37 49 23
16 Tenerife Tenerife 30 33 57 19
TEMPORADA 1960/1961
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 30 89 25 52
2 Atlético Atlético 30 57 35 40
3 Real Zaragoza Real 30 54 53 33
4 Barcelona Barcelona 30 62 47 32
5 Valencia Valencia 30 46 42 32
6 Athletic Athletic 30 42 41 30
7 Real Betis Real Betis 30 42 44 30
8 Real Sociedad Real 30 37 46 30
9 Mallorca Mallorca 30 38 41 28
10 Espanyol Espanyol 30 46 46 27
11 Sevilla Sevilla 30 42 46 27
12 Racing Racing 30 42 47 26
13 Real Oviedo Real Oviedo 30 39 54 26
14 Elche Elche 30 48 75 25
15 Real Valladolid Real 30 39 52 25
16 Granada Granada 30 32 61 17
TEMPORADA 1959/1960
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 30 86 28 46
2 Real Madrid Real Madrid 30 92 36 46
3 Athletic Athletic 30 74 45 39
4 Sevilla Sevilla 30 63 44 36
5 Atlético Atlético 30 59 40 33
6 Real Oviedo Real Oviedo 30 38 51 33
7 Real Betis Real Betis 30 42 53 33
8 Espanyol Espanyol 30 33 29 30
9 Valencia Valencia 30 37 33 28
10 Elche Elche 30 41 64 27
11 Real Zaragoza Real 30 49 58 25
12 Granada Granada 30 38 52 25
13 Real Valladolid Real 30 48 61 25
14 Real Sociedad Real 30 41 61 23
15 Osasuna Osasuna 30 42 75 18
16 Las Palmas Las Palmas 30 24 77 13
TEMPORADA 1958/1959
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 30 96 26 51
2 Real Madrid Real Madrid 30 89 29 47
3 Athletic Athletic 30 72 33 36
4 Valencia Valencia 30 47 41 33
5 Atlético Atlético 30 58 48 32
6 Real Betis Real Betis 30 54 53 32
7 Espanyol Espanyol 30 42 45 29
8 Osasuna Osasuna 30 44 59 28
9 Real Zaragoza Real 30 47 60 28
10 Real Sociedad Real 30 32 33 28
11 Real Oviedo Real Oviedo 30 31 49 27
12 Sevilla Sevilla 30 44 58 26
13 Granada Granada 30 30 43 26
14 Las Palmas Las Palmas 30 43 69 24
15 Real Sporting Real 30 25 70 20
16 Celta Celta 30 21 59 13
TEMPORADA 1957/1958
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 30 71 26 45
2 Atlético Atlético 30 78 43 42
3 Barcelona Barcelona 30 69 38 38
4 Valencia Valencia 30 56 40 36
5 Osasuna Osasuna 30 53 43 35
6 Athletic Athletic 30 56 48 32
7 Celta Celta 30 50 51 32
8 Espanyol Espanyol 30 48 46 28
9 Real Sociedad Real 30 38 44 27
10 Sevilla Sevilla 30 45 55 25
11 Las Palmas Las Palmas 30 34 65 25
12 Real Sporting Real 30 46 57 24
13 Granada Granada 30 35 53 24
14 Real Zaragoza Real 30 39 52 24
15 Real Valladolid Real 30 45 73 23
16 Real Jaén Real Jaén 30 29 58 20
TEMPORADA 1956/1957
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 30 74 35 44
2 Sevilla Sevilla 30 64 49 39
3 Barcelona Barcelona 30 70 37 39
4 Athletic Athletic 30 59 45 37
5 Atlético Atlético 30 65 45 34
6 Osasuna Osasuna 30 40 38 31
7 Espanyol Espanyol 30 39 48 30
8 Real Valladolid Real 30 52 58 28
9 Real Zaragoza Real 30 37 51 28
10 Las Palmas Las Palmas 30 41 58 27
11 Valencia Valencia 30 43 46 27
12 Real Sociedad Real 30 39 47 26
13 Celta Celta 30 39 47 23
14 Real Jaén Real Jaén 30 37 55 23
15 RC Deportivo Deportivo 30 41 61 22
16 Condal CD Condal CD 30 37 57 22
TEMPORADA 1955/1956
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Athletic Athletic 30 79 31 48
2 Barcelona Barcelona 30 67 26 47
3 Real Madrid Real Madrid 30 81 39 38
4 Sevilla Sevilla 30 75 44 36
5 Atlético Atlético 30 75 49 33
6 Valencia Valencia 30 58 50 32
7 Espanyol Espanyol 30 50 56 31
8 Real Sociedad Real 30 48 53 30
9 Real Valladolid Real 30 52 55 30
10 Celta Celta 30 52 75 27
11 Las Palmas Las Palmas 30 49 60 26
12 RC Deportivo Deportivo 30 60 80 26
13 Real Murcia Real Murcia 30 46 66 25
14 Deportivo Alavés Deportivo 30 49 73 24
15 Cultural Leonesa Cultural 30 34 65 14
16 Hércules Hércules 30 33 86 13
TEMPORADA 1954/1955
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 30 80 31 46
2 Barcelona Barcelona 30 75 39 41
3 Athletic Athletic 30 78 39 39
4 Sevilla Sevilla 30 74 58 34
5 Valencia Valencia 30 71 60 33
6 Hércules Hércules 30 46 57 31
7 RC Deportivo Deportivo 30 52 59 30
8 Atlético Atlético 30 59 64 29
9 Real Valladolid Real 30 48 56 27
10 Deportivo Alavés Deportivo 30 51 62 27
11 Celta Celta 30 55 60 27
12 Las Palmas Las Palmas 30 45 69 27
13 Espanyol Espanyol 30 42 46 26
14 Real Sociedad Real 30 48 53 24
15 Racing Racing 30 39 81 20
16 CD Málaga CD Málaga 30 36 65 19
TEMPORADA 1953/1954
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Madrid Real Madrid 30 72 41 40
2 Barcelona Barcelona 30 74 39 36
3 Valencia Valencia 30 69 51 34
4 Espanyol Espanyol 30 50 36 34
5 Sevilla Sevilla 30 57 49 32
6 Athletic Athletic 30 54 44 32
7 RC Deportivo Deportivo 30 41 46 31
8 Racing Racing 30 53 61 31
9 Real Sociedad Real 30 44 58 29
10 Celta Celta 30 47 54 29
11 Atlético Atlético 30 57 47 29
12 Real Valladolid Real 30 50 60 29
13 Osasuna Osasuna 30 46 54 28
14 Real Jaén Real Jaén 30 55 70 28
15 Real Oviedo Real Oviedo 30 31 53 22
16 Real Sporting Real 30 44 81 16
TEMPORADA 1952/1953
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 30 82 43 42
2 Valencia Valencia 30 66 42 40
3 Real Madrid Real Madrid 30 67 49 39
4 Espanyol Espanyol 30 64 40 36
5 Sevilla Sevilla 30 70 57 34
6 Athletic Athletic 30 83 52 32
7 Real Sporting Real 30 39 54 30
8 Atlético Atlético 30 65 70 30
9 Real Oviedo Real Oviedo 30 63 62 29
10 Real Sociedad Real 30 54 61 28
11 Racing Racing 30 46 61 27
12 Real Valladolid Real 30 48 54 25
13 Celta Celta 30 54 69 25
14 RC Deportivo Deportivo 30 49 78 24
15 CD Málaga CD Málaga 30 47 69 22
16 Real Zaragoza Real 30 38 74 17
TEMPORADA 1951/1952
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 30 92 43 43
2 Athletic Athletic 30 78 46 40
3 Real Madrid Real Madrid 30 79 50 38
4 Atlético Atlético 30 80 57 37
5 Valencia Valencia 30 68 51 35
6 Sevilla Sevilla 30 69 57 32
7 Espanyol Espanyol 30 69 62 32
8 Real Valladolid Real 30 47 43 29
9 Celta Celta 30 64 66 27
10 Real Sociedad Real 30 60 59 26
11 RC Deportivo Deportivo 30 46 70 25
12 Real Zaragoza Real 30 54 73 25
13 Real Sporting Real 30 49 75 25
14 Racing Racing 30 45 65 25
15 Las Palmas Las Palmas 30 36 85 22
16 Tetuán Tetuán 30 51 85 19
TEMPORADA 1950/1951
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Atlético Atlético 30 87 50 40
2 Sevilla Sevilla 30 79 46 38
3 Valencia Valencia 30 64 48 37
4 Barcelona Barcelona 30 83 61 35
5 Real Sociedad Real 30 77 56 35
6 Real Valladolid Real 30 51 51 33
7 Athletic Athletic 30 88 56 33
8 Celta Celta 30 62 56 33
9 Real Madrid Real Madrid 30 80 71 31
10 Racing Racing 30 49 60 30
11 Espanyol Espanyol 30 82 72 30
12 RC Deportivo Deportivo 30 64 47 30
13 CD Málaga CD Málaga 30 55 52 29
14 Real Murcia Real Murcia 30 40 86 19
15 Alcoyano Alcoyano 30 36 92 14
16 Lleida Lleida 30 41 134 13
TEMPORADA 1949/1950
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Atlético Atlético 26 71 51 33
2 RC Deportivo Deportivo 26 48 38 32
3 Valencia Valencia 26 71 43 31
4 Real Madrid Real Madrid 26 60 49 31
5 Barcelona Barcelona 26 67 47 29
6 Athletic Athletic 26 72 66 29
7 Celta Celta 26 63 50 28
8 Real Sociedad Real 26 57 43 27
9 Real Valladolid Real 26 49 46 25
10 Sevilla Sevilla 26 60 61 25
11 Espanyol Espanyol 26 42 64 22
12 CD Málaga CD Málaga 26 44 51 21
13 Gimnàstic Tarragona Gimnàstic 26 39 99 16
14 Real Oviedo Real Oviedo 26 30 65 15
TEMPORADA 1948/1949
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Sociedad Real 26 80 41 35
2 CD Málaga CD Málaga 26 73 33 35
3 Granada Granada 26 50 37 35
4 Hércules Hércules 26 64 53 32
5 Barakaldo Barakaldo 26 48 37 29
6 Real Sporting Real 26 56 44 29
7 Real Murcia Real Murcia 26 51 71 26
8 CD Castellón Castellón 26 47 61 24
9 Levante Levante 26 48 53 22
10 Girona Girona 26 45 53 22
11 Racing Racing 26 50 67 21
12 Valencia Mestalla Valencia 26 43 50 20
13 Badalona Badalona 26 40 63 19
14 Racing Ferrol Racing 26 39 71 15
TEMPORADA 1947/1948
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 26 65 31 37
2 Valencia Valencia 26 59 34 34
3 Atlético Atlético 26 73 45 33
4 Celta Celta 26 59 48 31
5 Sevilla Sevilla 26 50 40 29
6 Athletic Athletic 26 56 44 28
7 Gimnàstic Tarragona Gimnàstic 26 49 55 24
8 Espanyol Espanyol 26 39 47 24
9 Real Oviedo Real Oviedo 26 49 57 23
10 Alcoyano Alcoyano 26 40 52 22
11 Real Madrid Real Madrid 26 41 56 21
12 CE Sabadell CE Sabadell 26 41 62 21
13 Real Sociedad Real 26 38 56 19
14 Real Sporting Real 26 37 69 18
TEMPORADA 1946/1947
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Alcoyano Alcoyano 26 65 36 38
2 Gimnàstic Tarragona Gimnàstic 26 67 42 35
3 Real Sociedad Real 26 55 37 32
4 Hércules Hércules 26 48 44 30
5 Mallorca Mallorca 26 47 48 26
6 Levante Levante 26 62 54 26
7 Granada Granada 26 36 51 25
8 RCD Córdoba Córdoba 26 38 41 24
9 CD Málaga CD Málaga 26 38 44 23
10 Racing Ferrol Racing 26 48 62 22
11 Barakaldo Barakaldo 26 58 59 21
12 Racing Racing 26 38 54 21
13 Real Zaragoza Real 26 42 47 21
14 Real Betis Real Betis 26 37 60 20
TEMPORADA 1945/1946
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 CE Sabadell CE Sabadell 26 50 29 35
2 RC Deportivo Deportivo 26 38 28 33
3 Gimnàstic Tarragona Gimnàstic 26 50 46 29
4 Granada Granada 26 49 35 29
5 RCD Córdoba Córdoba 26 36 34 29
6 Real Sociedad Real 26 46 33 27
7 Racing Ferrol Racing 26 39 52 25
8 Mallorca Mallorca 26 37 39 25
9 Racing Racing 26 56 51 24
10 Real Zaragoza Real 26 44 53 24
11 Real Betis Real Betis 26 41 40 24
12 Jerez FC Jerez FC 26 43 59 22
13 UD Salamanca Salamanca 26 41 48 20
14 SD Ceuta SD Ceuta 26 35 58 18
TEMPORADA 1944/1945
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Alcoyano Alcoyano 26 57 35 34
2 Hércules Hércules 26 55 39 33
3 Celta Celta 26 65 40 32
4 Real Sociedad Real 26 56 34 31
5 Jerez FC Jerez FC 26 52 50 29
6 Racing Racing 26 69 57 26
7 Real Betis Real Betis 26 45 47 26
8 Real Zaragoza Real 26 50 53 26
9 SD Ceuta SD Ceuta 26 40 49 24
10 Racing Ferrol Racing 26 44 68 24
11 Mallorca Mallorca 26 44 55 22
12 Constància Constància 26 42 53 22
13 Cultural Leonesa Cultural 26 41 49 22
14 Barakaldo Barakaldo 26 31 62 13

  USO DE MEMORIA  
7,856,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8688
Total Execution Time  0.8700
  CADENA URL  
/historico/Real-Sociedad/1964
  GET DATOS  
$_GET['/historico/Real-Sociedad/1964']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0213  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 = 'Real-Sociedad' AND l.year = 1964 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.0146  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=2120 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2120 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2120 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0291  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 = 22138
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2120 AND type_rel = 2
0.0164  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2120 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  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 (1312778,1312771,1312770,1312764,1312754) ORDER BY n.cover_points DESC, update_date DESC
0.0171  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 = '2120' AND l.year = 1964 ORDER BY l.year DESC,cat.coefficient DESC
0.0182  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 = '2120' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  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 = 22138 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 = 5460 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0160  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=2120 AND l.year in (1963,1964,1965) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (22139,5461) 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.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 5461 AND teamId = 2120
0.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 22139 AND teamId = 2120
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1964` 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 = 5460 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0159  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 = '2120' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2120' and rp.type = 4
0.0220  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 = '2120' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0150  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2120' and rp.type = 4
0.0228  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 events1964 e ON e.player_id = p.id AND e.league_id = 5460 WHERE rp.league_id = 5460 AND rp.teamId = 2120 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.0215  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 events1964 e ON e.player_id = p.id AND e.league_id = 5460 WHERE rp.league_id = 5460 AND rp.teamId = 2120 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0206  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 events1964 e ON e.player_id = p.id AND e.league_id = 5460 WHERE rp.league_id = 5460 AND rp.teamId = 2120 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0225  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 = 2120 AND l.year <= 1964 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0167  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 `tables1964` 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 = 5460 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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 `tables1963` 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 = 5459 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 `tables1962` 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 = 5387 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables1961` 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 = 5386 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables1960` 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 = 5385 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables1959` 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 = 5384 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1958` 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 = 5383 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1957` 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 = 5382 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables1956` 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 = 5381 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables1955` 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 = 5380 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables1954` 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 = 5379 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 `tables1953` 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 = 5378 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 `tables1952` 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 = 5377 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0172  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 `tables1951` 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 = 5376 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables1950` 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 = 5375 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0169  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 `tables1949` 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 = 10376 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables1948` 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 = 5373 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables1946` 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 = 10381 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1945` 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 = 10380 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC