4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bergantiños Sub 19
TEMPORADA 2023/2024
LIGA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 RC Deportivo Sub 19 B Deportivo 31 115 20 81
2 RC Celta Sub 19 B Celta 31 91 24 75
3 Coruña Montañeros Sub 19 Coruña 31 65 38 64
4 Racing Ferrol Sub 19 Racing 31 61 39 53
5 Pontevedra Sub 19 Pontevedra 31 54 40 52
6 CD Conxo Sub 19 Conxo 31 64 47 51
7 Ural CF Sub 19 Ural 31 57 51 51
8 Coruxo B Sub 19 Coruxo 31 54 66 40
9 AJ Lerez Sub 19 Lerez 31 43 56 39
10 Lugo Sub 19 B Lugo 31 43 54 36
11 Alondras Sub 19 Alondras 31 36 38 35
12 UD Ourense Sub 19 Ourense 31 45 68 35
13 Victoria CF Sub 19 Victoria 31 55 69 35
14 Pabellón Ourense Sub 19 B Pabellón 31 35 45 34
15 Porriño Industrial Sub 19 Porriño 31 41 64 33
16 Bergantiños Sub 19 Bergantiños 31 40 67 27
17 Valladares Sub 19 Valladares 31 37 69 22
18 CD Boiro Sub 19 Boiro 31 24 105 15
TEMPORADA 2022/2023
LIGA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 RC Deportivo Sub 19 B Deportivo 34 94 27 78
2 RC Celta Sub 19 B Celta 34 77 29 76
3 ED Val Miñor Sub 19 Miñor 34 66 32 70
4 Choco Sub 19 Choco 34 79 44 69
5 Pontevedra Sub 19 Pontevedra 34 73 43 68
6 Pabellón Ourense Sub 19 B Pabellón 34 70 52 58
7 Valladares Sub 19 Valladares 34 60 49 51
8 Coruña Montañeros Sub 19 Coruña 34 49 41 49
9 UD Ourense Sub 19 Ourense 34 42 47 44
10 Bergantiños Sub 19 Bergantiños 34 41 57 44
11 Lugo Sub 19 B Lugo 34 37 55 43
12 Racing Ferrol Sub 19 Racing 34 50 62 41
13 Alondras Sub 19 Alondras 34 42 72 40
14 CD Conxo Sub 19 Conxo 34 36 65 36
15 Porriño Industrial Sub 19 Porriño 34 44 50 35
16 Xuventude Oroso Xuventude 34 42 64 30
17 Ural Español CF B Ural 34 36 72 25
18 CD Calasanz CD Calasanz 34 27 104 9
TEMPORADA 2021/2022
LIGA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 RC Celta Sub 19 B Celta 34 112 30 86
2 RC Deportivo Sub 19 B Deportivo 34 85 38 79
3 Coruxo FC Sub 19 Coruxo 34 74 56 67
4 Lugo Sub 19 B Lugo 34 77 48 66
5 Arosa SC Sub 19 Arosa 34 77 38 64
6 CD Conxo Sub 19 Conxo 34 65 34 64
7 CD Calasanz CD Calasanz 34 43 55 49
8 Choco Sub 19 Choco 34 65 58 47
9 Bergantiños Sub 19 Bergantiños 34 58 59 44
10 Alondras Sub 19 Alondras 34 47 69 42
11 Racing Ferrol Sub 19 Racing 34 48 63 41
12 Pabellón Ourense Sub 19 B Pabellón 34 60 83 39
13 Porriño Industrial Sub 19 Porriño 34 50 60 38
14 Ural Español CF B Ural 34 45 69 32
15 CD Areosa CD Areosa 34 40 63 29
16 ED Val Miñor Nigrán B Miñor 34 51 78 28
17 Colegio Hogar Sub 19 Colegio 34 59 101 28
18 Racing Club Villalbés Racing Club 34 28 82 18
TEMPORADA 2018/2019
LIGA GALLEGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Lalín EF Sub 19 Lalín 34 101 42 79
2 SD O Val Sub 19 34 85 38 74
3 Bergantiños Sub 19 Bergantiños 34 81 30 72
4 Coruña Montañeros Sub 19 Coruña 34 69 32 66
5 Viveiro A Viveiro A 34 76 52 62
6 SD Compostela Sub 19 Compostela 34 60 46 61
7 Ural B Ural B 34 68 45 56
8 CD Boiro Sub 19 Boiro 34 65 55 54
9 Dumbria CF Dumbria CF 34 54 55 51
10 Escola Estrada Fútbol Base Escola 34 50 61 51
11 Victoria B Victoria B 34 55 59 43
12 CD Conxo Santiago B Conxo 34 65 66 42
13 Galicia de Caranza Galicia 34 66 67 40
14 Residencia A Residencia 34 58 71 39
15 Cd As Pontes Pontes 34 44 61 29
16 At. de Riveira Riveira 34 52 124 20
17 Atletico Arteixo Atletico 34 33 104 11
18 Betanzos CF Betanzos CF 34 26 100 11
TEMPORADA 2017/2018
LIGA GALLEGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CD Calasanz CD Calasanz 34 86 34 75
2 Orillamar SD Orillamar 34 94 46 71
3 Lalín EF Sub 19 Lalín 34 81 48 69
4 Escola Estrada Fútbol Base Escola 34 73 39 63
5 Galicia de Caranza Galicia 34 60 34 61
6 Dumbria CF Dumbria CF 34 57 37 61
7 Bergantiños Sub 19 Bergantiños 34 69 48 57
8 Santiago Compostela B Santiago 34 83 62 51
9 Coruña Montañeros Sub 19 Coruña 34 51 40 50
10 Viveiro CF Viveiro CF 34 81 63 48
11 Ural B Ural B 34 64 58 45
12 SD O Val Sub 19 34 52 62 44
13 Cerceda CCD Cerceda CCD 34 48 58 42
14 Victoria B Victoria B 34 58 72 42
15 Betanzos CF Betanzos CF 34 59 56 40
16 Racing Club Villalbes B Racing Club 34 34 68 36
17 Conxo B Conxo B 34 39 119 12
18 CD Union CD Union 34 26 171 2
TEMPORADA 2016/2017
LIGA GALLEGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CD Boiro Sub 19 Boiro 34 77 41 74
2 Ural CF Sub 19 Ural 34 85 36 71
3 Coruña Montañeros Sub 19 Coruña 34 76 46 66
4 Bergantiños Sub 19 Bergantiños 34 71 46 62
5 Galicia de Caranza Galicia 34 79 55 59
6 Orillamar SD Orillamar 34 62 63 54
7 SD O Val Sub 19 34 67 63 51
8 Betanzos CF Betanzos CF 34 52 46 50
9 Viveiro CF Viveiro CF 34 60 52 47
10 Dumbria CF Dumbria CF 34 57 57 47
11 Santiago Compostela B Santiago 34 50 51 45
12 Victoria B Victoria B 34 59 72 44
13 Lalín EF Sub 19 Lalín 34 43 51 39
14 Cerceda CCD Cerceda CCD 34 54 71 37
15 CD Union CD Union 34 45 66 37
16 Bertamirans FC Bertamirans 34 49 88 29
17 Atletico Arteixo Atletico 34 46 78 27
18 Xuventude Oroso Xuventude 34 34 84 27
TEMPORADA 2015/2016
LIGA GALLEGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Conxo Conxo 34 71 26 76
2 Racing Club Villalbés Racing Club 34 78 40 71
3 Dumbria CF Dumbria CF 34 75 47 60
4 CD Boiro Sub 19 Boiro 34 83 63 59
5 Montañeros BG Montañeros 34 69 50 59
6 Victoria B Victoria B 34 66 51 55
7 Orillamar SD Orillamar 34 53 48 52
8 Viveiro CF Viveiro CF 34 82 65 51
9 SD O Val Sub 19 34 61 59 50
10 Lalín EF Sub 19 Lalín 33 51 44 49
11 Xuventude Osoro Xuventude 34 59 71 47
12 Bergantiños Sub 19 Bergantiños 34 57 50 45
13 CD Union CD Union 34 52 71 42
14 Cerceda CCD Cerceda CCD 34 61 56 41
15 SD Residencia Residencia 34 52 70 35
16 Estrada SP Estrada SP 34 42 75 27
17 Imperator OAR Imperator 33 59 121 21
18 Órdenes Sd Órdenes Sd 34 32 96 15
TEMPORADA 2014/2015
LIGA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 Victoria CF Sub 19 Victoria 34 70 27 83
2 RC Celta Sub 19 B Celta 34 106 37 79
3 RC Deportivo Sub 19 B Deportivo 34 75 39 64
4 Ourense CF Sub 19 Ourense 34 42 30 61
5 SD Compostela Sub 19 Compostela 34 69 36 60
6 Choco Sub 19 Choco 34 42 41 50
7 Racing Ferrol Sub 19 Racing 34 59 67 47
8 CD Areosa CD Areosa 34 48 57 46
9 Pabellón Ourense Sub 19 B Pabellón 34 45 55 45
10 CD Calasanz CD Calasanz 34 47 61 43
11 Santiago de Compostela Santiago 34 44 51 41
12 Arosa SC Sub 19 Arosa 34 51 52 41
13 Galicia de Caranza Galicia 34 57 81 41
14 Coruxo FC Sub 19 Coruxo 34 59 69 40
15 Sárdoma Cf Sárdoma Cf 34 47 60 39
16 SD Residencia Residencia 34 49 64 31
17 Rápido De Bouzas A Rápido 34 49 90 21
18 Bergantiños Sub 19 Bergantiños 34 31 73 20
TEMPORADA 2011/2012
LIGA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 RC Celta Sub 19 B Celta 32 122 26 89
2 Montañeros Cf Juvenil Montañeros 32 71 19 72
3 RC Deportivo Sub 19 B Deportivo 32 65 36 63
4 SD Compostela Sub 19 Compostela 32 73 46 61
5 CD Areosa CD Areosa 32 72 36 60
6 Victoria CF Sub 19 Victoria 32 53 46 57
7 Sárdoma Cf Sárdoma Cf 32 46 38 53
8 CD Calasanz CD Calasanz 32 53 55 42
9 CP Calasancio Calasancio 32 45 67 40
10 Arosa SC Sub 19 Arosa 32 43 52 40
11 Cd Lérez Cd Lérez 32 38 54 36
12 Ural CF Sub 19 Ural 32 39 54 35
13 ED Val Miñor Sub 19 Miñor 32 41 51 35
14 Bergantiños Sub 19 Bergantiños 32 42 65 30
15 Ch San Roque Roque 32 42 79 26
16 Sd Negreira Sd Negreira 32 29 85 23
17 Cd Lalín Cd Lalín 32 17 82 8
TEMPORADA 2010/2011
LIGA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 RC Celta Sub 19 B Celta 34 102 40 86
2 CD Lugo Sub 19 Lugo 34 96 29 82
3 Pabellón Ourense Sub 19 Pabellón 34 79 31 70
4 Victoria CF Sub 19 Victoria 34 77 44 67
5 Sárdoma Cf Sárdoma Cf 34 70 37 66
6 Arosa SC Sub 19 Arosa 34 57 46 52
7 RC Deportivo Sub 19 B Deportivo 34 62 48 51
8 ED Val Miñor Sub 19 Miñor 34 74 58 50
9 CD Calasanz CD Calasanz 34 60 57 46
10 Ural CF Sub 19 Ural 34 47 41 45
11 Cd Lalín Cd Lalín 34 53 52 42
12 Bergantiños Sub 19 Bergantiños 34 45 69 35
13 Colegio Hogar SR Colegio 34 45 63 35
14 Montañeros B Montañeros 34 53 69 33
15 Cd As Pontes Pontes 34 40 84 30
16 Sd Chantada Sd Chantada 34 43 70 26
17 Cultural Areas Juvenil Cultural 34 35 107 22
18 Alerta Traviesas Alerta 34 45 138 22
TEMPORADA 2009/2010
LIGA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 RC Deportivo Sub 19 B Deportivo 32 87 31 74
2 RC Celta Sub 19 B Celta 34 91 47 74
3 Conxo Conxo 34 72 43 68
4 CP Calasancio Calasancio 34 59 49 64
5 Sárdoma Cf Sárdoma Cf 34 57 42 58
6 Val Miñor Val Miñor 33 69 43 57
7 Cd Lalín Cd Lalín 34 53 49 53
8 Pabellón Ourense Sub 19 Pabellón 31 67 57 47
9 Bergantiños Sub 19 Bergantiños 34 49 52 44
10 Colegio Hogar Sub 19 Colegio 34 54 63 44
11 Cd As Pontes Pontes 34 61 76 42
12 Calasanz Calasanz 34 69 81 39
13 Cultural Areas Juvenil Cultural 32 42 65 38
14 Montañeros B Montañeros 34 56 65 36
15 Arosa SC Sub 19 Arosa 34 46 58 34
16 Areosa Areosa 34 43 67 34
17 Xuventu Aguiño SD Xuventu 34 52 104 25
18 Choco Sub 19 Choco 34 42 77 24

  USO DE MEMORIA  
6,380,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1192
Total Execution Time  0.1211
  CADENA URL  
/historico/Bergantinos-Cf-Juvenil
  GET DATOS  
$_GET['/historico/Bergantinos-Cf-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0027  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 = 'Bergantinos-Cf-Juvenil' 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.0018  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=4936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=4936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4936 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=112 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 112 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1243526,1233227,1223087,1219000,1197928) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = '4936' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '4936' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '4936' 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 = 73378 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=4936 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73378) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73378 AND teamId = 4936
0.0041  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 = 73378 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '4936' 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 = '4936' and rp.type = 4
0.0021  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 = '4936' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 73378 WHERE rp.league_id = 73378 AND rp.teamId = 4936 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.0031  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 = 73378 WHERE rp.league_id = 73378 AND rp.teamId = 4936 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 73378 WHERE rp.league_id = 73378 AND rp.teamId = 4936 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 4936 AND l.year <= 2024 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 `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 = 68406 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.0028  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 = 63614 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.0029  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_base` 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 = 45655 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 `tables2018_base` 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 = 39874 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 `tables2017_base` 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 = 34662 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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_base` 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 = 17012 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 `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 = 4204 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 `tables2011_base` 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 = 1178 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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_base` 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 = 903 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 = 73378 ORDER BY nameShow LIMIT 100