4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Lantarón
TEMPORADA 2021/2022
DIVISIÓN HONOR PAÍS VASCO GRUPO 7
Equipo PJ GF GC Puntos
1 Ariznabarra Ariznabarra 22 69 26 48
2 San Ignacio B Ignacio 22 37 22 42
3 Alegría Alegría 22 38 20 39
4 Abetxuko Abetxuko 22 49 37 37
5 CD Lakua Arriaga Lakua 22 43 29 36
6 Zaramaga Zaramaga 22 43 30 35
7 CD Lantarón Lantarón 22 32 40 32
8 Mercedarias KE Mercedarias 22 40 35 28
9 Vitoria B Vitoria B 22 30 39 26
10 Aranbizkarra Aranbizkarra 22 22 40 21
11 Rioja Alavesa Luzerna Rioja 22 32 55 20
12 Hauskaitz KK Hauskaitz 22 12 74 4
TEMPORADA 2016/2017
REGIONAL PREFERENTE ÁLAVA
Equipo PJ GF GC Puntos
1 CD Aurrera Vitoria Aurrera 34 96 19 89
2 Ariznabarra Ariznabarra 34 99 33 79
3 SD Iru-Bat Santa Lucía Iru-Bat 34 88 44 72
4 Salvatierra Salvatierra 34 90 41 65
5 Zaramaga Zaramaga 34 69 47 63
6 San Ignacio San Ignacio 34 78 48 57
7 San Prudencio Prudencio 34 65 54 51
8 Urgatzi KK Urgatzi KK 34 52 53 50
9 Laudio Laudio 34 56 49 47
10 CD Lantarón Lantarón 34 67 62 47
11 El Pilar Marianistas Pilar 34 80 73 46
12 Rioja Alavesa Luzerna Rioja 34 52 55 43
13 Nanclares Nanclares 34 54 58 43
14 Zuia de Fútbol Zuia Fútbol 34 54 59 40
15 Vitoria B Vitoria B 34 48 92 37
16 Condado De Treviño Condado 34 46 92 29
17 CDF San Martín Martín 34 34 103 18
18 Abetxuko Abetxuko 34 17 163 4
TEMPORADA 2014/2015
REGIONAL PREFERENTE ÁLAVA
Equipo PJ GF GC Puntos
1 CD Vitoria CD Vitoria 34 74 25 78
2 CD Elgorriaga Elgorriaga 34 81 25 74
3 SD Iru-Bat Santa Lucía Iru-Bat 34 67 30 71
4 CDF San Martín Martín 34 67 44 67
5 Salvatierra Salvatierra 34 66 29 64
6 Laudio Laudio 34 61 23 63
7 San Ignacio San Ignacio 34 61 39 62
8 Ariznabarra Ariznabarra 34 51 41 55
9 Zaramaga Zaramaga 34 38 39 42
10 El Pilar Marianistas Pilar 34 38 42 38
11 Vitoria B Vitoria B 34 50 81 38
12 Abetxuko Abetxuko 34 45 68 37
13 San Prudencio Prudencio 34 32 49 34
14 Zuia de Fútbol Zuia Fútbol 34 32 59 34
15 CD Alipendi CD Alipendi 34 35 74 29
16 Condado De Treviño Condado 34 51 77 27
17 CD Lantarón Lantarón 34 32 84 20
18 Nanclares Nanclares 34 28 80 15
TEMPORADA 2013/2014
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 CD Aurrera Vitoria Aurrera 34 96 25 82
2 Club San Ignacio Club Ignacio 34 90 25 81
3 Salvatierra Salvatierra 34 78 25 77
4 CDF San Martín Martín 34 76 37 73
5 CD Vitoria CD Vitoria 34 69 38 67
6 Ariznabarra Ariznabarra 34 66 40 63
7 Nanclares Nanclares 34 68 59 56
8 SD Iru-Bat Santa Lucía Iru-Bat 34 65 39 52
9 El Pilar Marianistas Pilar 34 65 62 52
10 CD Lantarón Lantarón 34 37 62 37
11 CD Alipendi CD Alipendi 34 44 63 36
12 Zaramaga Zaramaga 34 44 59 34
13 San Prudencio Prudencio 34 47 69 32
14 CD Laudio FSR B Laudio 34 45 63 32
15 Vitoria B Vitoria B 34 41 77 32
16 Abetxuko Abetxuko 34 23 64 29
17 CDF Gasteiz El Retorno Gasteiz 34 36 116 14
18 Rioja Alavesa Luzerna Rioja 34 32 99 12
TEMPORADA 2012/2013
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 Amurrio Amurrio 34 114 37 81
2 Salvatierra Salvatierra 34 88 33 74
3 Club San Ignacio Club Ignacio 34 81 28 73
4 Ariznabarra Ariznabarra 34 69 40 66
5 El Pilar Marianistas Pilar 34 77 45 65
6 CD Vitoria CD Vitoria 34 53 36 64
7 CDF San Martín Martín 34 55 35 63
8 Zaramaga Zaramaga 34 70 48 60
9 CDF Lakua CDF Lakua 34 62 73 48
10 Abetxuko Abetxuko 34 57 63 43
11 Nanclares Nanclares 34 49 59 40
12 SD Iru-Bat Santa Lucía Iru-Bat 34 49 73 38
13 Condado De Treviño Condado 34 37 55 36
14 CD Laudio FSR B Laudio 34 43 62 31
15 San Prudencio Prudencio 34 44 81 29
16 CD Lantarón Lantarón 34 36 62 25
17 Zuia de Fútbol Zuia Fútbol 34 40 78 24
18 Vulcano Vulcano 34 36 152 3
TEMPORADA 2011/2012
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 CD Aurrera Vitoria Aurrera 306 255 117 255
2 Abetxuko Abetxuko 306 255 255 255
3 Amurrio Amurrio 306 255 255 255
4 Ariznabarra Ariznabarra 306 255 255 255
5 CD Lantarón Lantarón 306 255 255 255
6 CD Laudio FSR B Laudio 306 255 255 255
7 CDF Lakua CDF Lakua 306 255 255 255
8 CDF San Martín Martín 306 255 255 255
9 Club San Ignacio Club Ignacio 306 255 255 255
10 Condado De Treviño Condado 306 255 255 255
11 El Pilar Marianistas Pilar 306 255 255 255
12 Salvatierra Salvatierra 306 255 255 255
13 SD Iru-Bat Santa Lucía Iru-Bat 306 255 255 255
14 Zaramaga Zaramaga 306 255 255 255
15 Nanclares Nanclares 306 255 255 239
16 CD Campezo FR Campezo 306 255 255 200
17 CDF Gasteiz El Retorno Gasteiz 306 255 255 169
18 CD Lakua Arriaga Lakua 306 201 255 134
TEMPORADA 2010/2011
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 Deportivo Alavés B Deportivo 34 83 24 83
2 CD Laudio FSR B Laudio 34 63 32 82
3 CD Vitoria CD Vitoria 34 78 20 78
4 Salvatierra Salvatierra 34 60 36 59
5 Club San Ignacio Club Ignacio 34 45 33 55
6 Zaramaga Zaramaga 34 56 42 54
7 El Pilar Marianistas Pilar 34 58 52 53
8 Abetxuko Abetxuko 34 54 54 46
9 Ariznabarra Ariznabarra 34 46 42 44
10 CD Lantarón Lantarón 34 37 48 43
11 Aurrera Vitoria B Aurrera 34 34 46 43
12 Amurrio Club B Amurrio Club 34 38 44 41
13 Nanclares Nanclares 34 35 51 36
14 Condado De Treviño Condado 34 32 53 35
15 CDF Lakua CDF Lakua 34 38 51 34
16 CDF San Martín Martín 34 41 68 34
17 San Prudencio Prudencio 34 26 58 22
18 Alegría Alegría 34 29 99 6
TEMPORADA 2008/2009
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 Salvatierra Salvatierra 34 84 24 81
2 CD Vitoria CD Vitoria 34 103 32 79
3 CD Aurrera Vitoria Aurrera 34 83 36 78
4 CDF Lakua CDF Lakua 34 75 47 60
5 Vulcano Vulcano 34 76 55 57
6 Ariznabarra Ariznabarra 34 56 38 53
7 CDF San Martín Martín 34 64 60 52
8 Alegría Alegría 34 54 58 50
9 San Prudencio Prudencio 34 55 55 49
10 Bruno Villarreal Bruno 34 50 47 48
11 El Pilar Marianistas Pilar 34 62 51 45
12 Zaramaga Zaramaga 34 59 56 43
13 Izarra Gorri Izarra Gorri 34 63 75 42
14 Nanclares Nanclares 34 49 51 41
15 Abetxuko Abetxuko 34 42 83 36
16 SD Iru-Bat Santa Lucía Iru-Bat 34 49 82 33
17 CD Lantarón Lantarón 34 24 114 14
18 Baskonia Baskonia 34 20 104 4

  USO DE MEMORIA  
5,731,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1429
Total Execution Time  0.1445
  CADENA URL  
/historico/Cd-Lantaron-Senior
  GET DATOS  
$_GET['/historico/Cd-Lantaron-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0028  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 = 'Cd-Lantaron-Senior' 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.0037  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 = 'Cd-Lantaron-Senior' 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=9479 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=9479 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=9479 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=9479 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=9479 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=9479 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=9479 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=9479 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=9479 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=9479 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0050  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 = 66306
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9479 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 74 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0026  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 (1179918,760947,544162,543859,380875) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '9479' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0031  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 = '9479' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 66306 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=9479 AND l.year in (2021,2022,2023) 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 (66306) 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.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 66306 AND teamId = 9479
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 = '9479' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9479' and rp.type = 4
0.0020  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 = '9479' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63863 WHERE rp.league_id = 63863 AND rp.teamId = 9479 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.0020  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63863 WHERE rp.league_id = 63863 AND rp.teamId = 9479 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63863 WHERE rp.league_id = 63863 AND rp.teamId = 9479 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 9479 AND l.year <= 2022 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 `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 = 63863 AND t.round = 11 ORDER BY team.conference ASC,t.position 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 `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 = 66306 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.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 `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 = 35872 AND t.round = 34 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 `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 = 4338 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 2736 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0053  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 = 1981 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 `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1457 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0058  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1144 AND t.round = 34 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 `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 = 308 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC