4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rinconeda
TEMPORADA 2023/2024
1ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 CD Ramales CD Ramales 32 68 28 71
2 Minerva Fc Minerva Fc 31 67 31 69
3 Revilla B Revilla B 31 96 47 63
4 Ayrón Club Ayrón Club 31 71 33 61
5 Ampuero FC Ampuero FC 32 57 37 60
6 Cd Montañas Del Pas Montañas 31 49 42 52
7 Polanco CF Polanco CF 31 43 42 45
8 Escobedo B Escobedo B 31 55 52 45
9 Atlético España De Cueto Atlético 31 60 57 43
10 Villaescusa SD Villaescusa 31 50 61 40
11 Santiago Galas Santiago 32 48 54 40
12 CD Calasanz CD Calasanz 31 43 50 39
13 Vimenor B Vimenor B 32 45 41 38
14 Rio Gandara CD Gandara 31 55 68 33
15 Marina de Cudeyo Marina 31 39 53 33
16 Buelna Buelna 31 36 63 30
17 Nueva Montaña Nueva 31 38 78 20
18 Rinconeda Rinconeda 31 31 114 3
TEMPORADA 2022/2023
1ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 Cayón B Cayón B 34 72 41 69
2 FC Miengo FC Miengo 34 73 39 67
3 CD Naval B CD Naval B 33 69 37 65
4 Peña Revilla SD Peña 34 60 29 65
5 SD Solares B Solares 33 78 43 63
6 Santiago Galas Santiago 34 51 44 53
7 Ayrón Club Ayrón Club 34 72 52 52
8 Rio Gandara CD Gandara 34 62 68 51
9 Minerva Fc Minerva Fc 34 62 65 45
10 Escobedo B Escobedo B 33 62 55 44
11 CD Calasanz CD Calasanz 34 45 57 44
12 Marina de Cudeyo Marina 33 50 58 42
13 Atlético España De Cueto Atlético 34 40 47 39
14 Ampuero FC Ampuero FC 34 46 65 39
15 Rinconeda Rinconeda 34 50 70 35
16 Valle Lebaniego Valle 34 46 78 34
17 CD Los Rios CD Los Rios 34 48 83 30
18 Atco. Mineros B Atco. 34 32 87 11
TEMPORADA 2021/2022
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 SD Solares SD Solares 34 69 23 75
2 Revilla Revilla 34 68 30 69
3 SD Gama SD Gama 34 75 42 66
4 Velarde CF Velarde CF 34 72 28 65
5 CD Bezana CD Bezana 34 65 36 62
6 Atlético Mineros Atlético 34 60 48 55
7 CD Ramales CD Ramales 34 59 50 55
8 SD San Martín Arena Martín 34 52 51 52
9 Barquereño Barquereño 34 51 52 51
10 CD Monte CD Monte 34 48 58 47
11 Nueva Montaña Nueva 34 46 52 43
12 Arenas de Frajanas Arenas 34 48 61 39
13 Ribamontán al Mar Ribamontán 34 39 56 39
14 Rinconeda Rinconeda 34 48 67 37
15 FC Miengo FC Miengo 34 44 71 35
16 CD Los Rios CD Los Rios 34 51 86 31
17 Ampuero FC Ampuero FC 34 36 76 18
18 Ayrón Club Ayrón Club 34 31 75 18
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Tropezón Tropezón 20 40 19 43
2 Gimnástica Torrelavega Gimnástica 20 42 20 37
3 UM Escobedo UM Escobedo 20 27 17 37
4 CF Vimenor CF Vimenor 20 29 20 32
5 UC Cartes UC Cartes 20 23 22 29
6 Selaya Selaya 20 24 32 29
7 Castro Castro 20 20 23 27
8 SD Torina SD Torina 20 21 31 20
9 CD Guarnizo CD Guarnizo 20 18 30 19
10 SD Barreda Balompié Barreda 20 18 33 19
11 SD Solares SD Solares 20 9 24 10
12 Cayón Cayón 20 47 14 51
13 Rayo Cantabria Rayo 20 45 16 46
14 Siete Villas Siete Villas 20 30 15 42
15 Sámano Sámano 20 33 20 37
16 SD Textil Escudo Textil 20 27 17 33
17 Atlético Albericia Atlético 20 27 30 20
18 Rinconeda Rinconeda 20 19 37 19
19 Revilla Revilla 20 21 36 17
20 CD Bezana CD Bezana 20 14 40 16
21 Barquereño Barquereño 20 17 33 15
22 Ribamontán al Mar Ribamontán 20 12 34 12
TEMPORADA 2019/2020
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 Revilla Revilla 25 51 17 53
2 Castro Castro 25 48 21 51
3 Rinconeda Rinconeda 25 46 21 51
4 FC Miengo FC Miengo 24 39 26 46
5 Nueva Montaña Nueva 25 55 39 40
6 Atlético Mineros Atlético 24 38 29 39
7 Noja Noja 25 32 30 36
8 CD Colindres Colindres 25 31 25 35
9 Velarde CF Velarde CF 25 39 35 35
10 CD Naval CD Naval 25 34 39 33
11 SD Gama SD Gama 25 28 31 30
12 Villaescusa SD Villaescusa 25 27 38 29
13 Valle Lebaniego Valle 25 33 50 28
14 EMF Meruelo EMF Meruelo 25 31 45 27
15 EMD Santillana Santillana 25 30 34 24
16 Atco. Deva Atco. Deva 25 28 45 22
17 CD Ramales CD Ramales 25 19 58 17
18 CD Los Rios CD Los Rios 25 23 49 15
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 UM Escobedo UM Escobedo 38 80 29 86
2 CD Laredo CD Laredo 38 71 26 80
3 Tropezón Tropezón 38 73 34 76
4 Cayón Cayón 38 66 26 74
5 Rayo Cantabria Rayo 38 62 24 68
6 CD Bezana CD Bezana 38 60 50 65
7 Sámano Sámano 38 54 46 58
8 CF Vimenor CF Vimenor 38 51 56 54
9 SD Torina SD Torina 38 55 60 53
10 SD Textil Escudo Textil 38 49 43 51
11 Ribamontán al Mar Ribamontán 38 36 38 50
12 SD Barreda Balompié Barreda 38 48 59 47
13 Siete Villas Siete Villas 38 41 51 43
14 Atlético Albericia Atlético 38 43 47 42
15 SD Solares SD Solares 38 33 44 42
16 CD Guarnizo CD Guarnizo 38 41 54 40
17 Revilla Revilla 38 48 83 38
18 Velarde CF Velarde CF 38 35 67 36
19 CD Naval CD Naval 38 36 95 23
20 Rinconeda Rinconeda 38 37 87 19
TEMPORADA 2017/2018
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 Revilla Revilla 34 62 27 72
2 SD Torina SD Torina 34 55 27 72
3 Rinconeda Rinconeda 34 61 40 65
4 Ribamontán al Mar Ribamontán 34 49 30 61
5 CD Naval CD Naval 34 51 41 53
6 Valle Lebaniego Valle 34 55 56 45
7 Ayrón Club Ayrón Club 34 46 48 45
8 CD Colindres Colindres 34 42 38 42
9 UC Cartes UC Cartes 34 57 50 42
10 SD Gama SD Gama 34 48 51 41
11 CD Los Rios CD Los Rios 34 56 68 40
12 Cayón B Cayón B 34 53 72 40
13 EMF Meruelo EMF Meruelo 33 42 50 39
14 CD Monte CD Monte 34 42 68 38
15 Nueva Montaña Nueva 34 54 57 37
16 Santoña CF Santoña CF 33 32 52 37
17 Vimenor B Vimenor B 34 28 43 35
18 Internacional FC Santander Internaciona 34 46 61 33
TEMPORADA 2016/2017
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 EMD Santillana Santillana 34 73 22 82
2 Sámano Sámano 34 71 33 77
3 SD Solares SD Solares 34 57 30 67
4 Valle Lebaniego Valle 34 68 52 58
5 CD Naval CD Naval 34 54 42 58
6 Vimenor B Vimenor B 34 52 44 52
7 SD Torina SD Torina 34 58 63 49
8 Nueva Montaña Nueva 34 54 56 48
9 Rinconeda Rinconeda 34 80 69 46
10 CD Los Rios CD Los Rios 34 66 65 43
11 Santoña CF Santoña CF 34 49 56 40
12 SD Gama SD Gama 34 41 56 37
13 Internacional FC Santander Internaciona 34 42 77 35
14 Cayón B Cayón B 34 54 65 34
15 CD Monte CD Monte 34 44 68 34
16 Arenas de Frajanas Arenas 34 47 69 33
17 Noja Noja 34 35 60 31
18 Atlético España De Cueto Atlético 34 47 65 30
TEMPORADA 2015/2016
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 SD Barreda Balompié Barreda 36 76 21 85
2 EMF Meruelo EMF Meruelo 36 66 31 76
3 Velarde CF Velarde CF 36 68 40 68
4 SD Solares SD Solares 36 43 30 63
5 EMD Santillana Santillana 36 66 38 61
6 Nueva Montaña Nueva 36 58 39 57
7 Atlético España De Cueto Atlético 36 59 43 52
8 Noja Noja 36 52 62 50
9 Rinconeda Rinconeda 36 58 49 47
10 Internacional FC Santander Internaciona 35 49 52 44
11 CD Pontejos CD Pontejos 36 49 59 44
12 Arenas de Frajanas Arenas 36 47 64 44
13 Cayón B Cayón B 36 50 71 43
14 Santoña CF Santoña CF 36 48 58 43
15 Minerva Fc Minerva Fc 36 59 67 42
16 CD Los Rios CD Los Rios 35 43 47 42
17 Barquereño Barquereño 36 41 67 35
18 Ribamontán al Mar Ribamontán 36 35 65 29
19 Buelna Buelna 36 25 89 15
TEMPORADA 2014/2015
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 CD Guarnizo CD Guarnizo 34 63 23 85
2 Sámano Sámano 34 69 39 68
3 CD Naval CD Naval 34 49 28 60
4 EMD Santillana Santillana 34 55 39 59
5 Velarde CF Velarde CF 34 61 45 58
6 Barquereño Barquereño 33 64 40 56
7 EMF Meruelo EMF Meruelo 34 50 29 56
8 Reocin Reocin 32 63 47 50
9 Ribamontán al Mar Ribamontán 34 47 53 49
10 Noja Noja 34 40 50 40
11 Rinconeda Rinconeda 33 45 57 38
12 Nueva Montaña Nueva 34 38 61 35
13 SD Solares SD Solares 34 27 36 34
14 CD Los Rios CD Los Rios 34 52 67 34
15 CD Pontejos CD Pontejos 34 29 52 34
16 Minerva Fc Minerva Fc 34 35 67 32
17 SD Torina SD Torina 34 41 65 28
18 SD San Martín Arena Martín 34 36 66 27
TEMPORADA 2013/2014
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 Revilla Revilla 34 61 33 69
2 Arenas de Frajanas Arenas 34 62 38 65
3 SD Textil Escudo Textil 34 60 26 62
4 Velarde CF Velarde CF 34 62 43 62
5 Barquereño Barquereño 34 55 43 59
6 Sámano Sámano 34 60 42 56
7 Nueva Montaña Nueva 34 59 43 54
8 EMF Meruelo EMF Meruelo 34 47 38 52
9 EMD Santillana Santillana 34 48 41 51
10 SD Torina SD Torina 34 52 49 50
11 SD San Martín de la Arena Martín 34 51 57 47
12 Gimnástica B Gimnástica 34 46 44 47
13 Rinconeda Rinconeda 34 41 48 38
14 SD Solares SD Solares 34 45 52 36
15 Minerva Fc Minerva Fc 34 43 69 33
16 Cayón B Cayón B 34 44 71 33
17 UC Cartes UC Cartes 34 34 84 20
18 CD Valdáliga Valdáliga 34 29 78 13
TEMPORADA 2012/2013
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 CD Colindres Colindres 34 64 32 76
2 Selaya Selaya 34 59 24 72
3 Buelna Buelna 34 70 44 68
4 Sámano Sámano 34 72 54 62
5 Gimnástica B Gimnástica 34 56 45 56
6 Revilla Revilla 34 57 45 53
7 SD Torina SD Torina 34 54 50 53
8 Nueva Montaña Nueva 34 45 53 47
9 Velarde CF Velarde CF 34 63 60 46
10 Barquereño Barquereño 34 40 46 45
11 Arenas de Frajanas Arenas 34 63 63 43
12 Cayón B Cayón B 34 49 52 42
13 Rinconeda Rinconeda 34 43 51 41
14 Minerva Fc Minerva Fc 34 49 70 38
15 Ayrón Club Ayrón Club 34 29 53 35
16 CD Comillas CD Comillas 34 46 66 32
17 Sd Reocín Sd Reocín 34 41 62 32
18 Cd Montañas Del Pas Montañas 34 30 60 18
TEMPORADA 2009/2010
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 CD Guarnizo CD Guarnizo 34 55 31 64
2 Santoña CF Santoña CF 34 55 34 64
3 Arenas de Frajanas Arenas 34 53 36 63
4 CD Colindres Colindres 34 55 36 62
5 Ayrón Ayrón 34 46 29 61
6 Barquereño Barquereño 34 47 34 58
7 SD San Martín Arena Martín 34 50 34 56
8 CD Comillas CD Comillas 34 54 51 56
9 EMF Meruelo EMF Meruelo 34 45 48 45
10 SD Gama SD Gama 34 47 56 45
11 Revilla Revilla 34 39 44 44
12 EMD Santillana Santillana 34 37 44 44
13 Union club Union club 34 30 35 43
14 Velarde CF Velarde CF 34 37 48 42
15 Sámano Sámano 34 42 43 40
16 Gimnástica B Gimnástica 34 36 51 29
17 Calasanz Calasanz 34 39 70 25
18 Rinconeda Rinconeda 34 31 74 21
TEMPORADA 2008/2009
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 SD Textil Escudo Textil 34 68 28 73
2 Buelna Buelna 34 61 35 63
3 Selaya Selaya 34 57 35 63
4 CD Pontejos CD Pontejos 34 61 41 62
5 Gimnástica B Gimnástica 34 70 37 59
6 SD Gama SD Gama 34 65 42 59
7 Revilla Revilla 34 46 43 50
8 CD Colindres Colindres 34 45 45 49
9 EMD Santillana Santillana 34 51 56 48
10 Ayrón Ayrón 34 46 48 47
11 Union club Union club 34 36 49 46
12 EMF Meruelo EMF Meruelo 34 39 40 45
13 Sámano Sámano 34 49 51 43
14 CD Comillas CD Comillas 34 37 51 41
15 Rinconeda Rinconeda 34 37 50 37
16 Villaescusa SD Villaescusa 34 29 57 33
17 Reocín B Reocín B 34 27 66 23
18 Atlético España De Cueto Atlético 34 23 73 12

  USO DE MEMORIA  
6,916,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5905
Total Execution Time  0.5918
  CADENA URL  
/historico/Rinconeda
  GET DATOS  
$_GET['/historico/Rinconeda']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0134  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 = 'Rinconeda' 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.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=2162 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=2162 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0257  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 = 73507
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2162 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2162 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (637063,886617) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = '2162' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '2162' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '2162' 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 = 73507 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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=2162 AND l.year in (2023,2024,2025) 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 (73507) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 73507 AND teamId = 2162
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 FROM `tables2024` 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 = 73507 AND t.round = 32 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 = '2162' 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 = '2162' and rp.type = 4
0.0126  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 = '2162' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135  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 events2024 e ON e.player_id = p.id AND e.league_id = 73507 WHERE rp.league_id = 73507 AND rp.teamId = 2162 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.0134  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 events2024 e ON e.player_id = p.id AND e.league_id = 73507 WHERE rp.league_id = 73507 AND rp.teamId = 2162 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 events2024 e ON e.player_id = p.id AND e.league_id = 73507 WHERE rp.league_id = 73507 AND rp.teamId = 2162 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 2162 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 73507 AND t.round = 32 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 `tables2023` 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 = 68996 AND t.round = 34 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 `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 = 63670 AND t.round = 34 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 = 58581 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.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 `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 = 51274 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `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 = 44391 AND t.round = 38 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 `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 = 39193 AND t.round = 34 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 `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 = 33972 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 16698 AND t.round = 38 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 = 4097 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 `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 = 2590 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 `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 = 1979 AND t.round = 34 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 `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 = 848 AND t.round = 34 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 `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 = 288 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC