4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atletico Libertad
TEMPORADA 2022/2023
3ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 AD San José Sub 19 José 30 99 49 64
2 Umbrete CF Umbrete CF 30 86 38 62
3 UD Loreto UD Loreto 30 67 36 60
4 Atletico Libertad Atletico 30 70 48 54
5 Villaverde Sub 19 Villaverde 30 76 62 54
6 Triana CF Triana CF 30 62 42 49
7 Olivarense Atlético Olivarense 30 82 66 47
8 Rinconada Cantera Rinconada 30 70 60 44
9 Puebla CF Puebla CF 30 52 52 43
10 JD Bormujos JD Bormujos 30 65 57 42
11 UD Tomares B Tomares 30 71 65 40
12 Brenes Balompie Brenes 30 44 75 34
13 Atlético Algabeño Atlético 30 58 85 29
14 Mairena del Aljarafe A Mairena 30 57 75 25
15 CMD San Juan Juvenil Juan Juvenil 30 34 107 11
16 Valencina FC Valencina 30 34 110 11
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 CD Utrera Sub 19 Utrera 34 97 40 72
2 UD Tomares Sub 19 Tomares 34 75 36 72
3 CD Cabecense Sub 19 Cabecense 34 73 37 71
4 CD Los Caminantes Caminantes 34 73 47 64
5 CD Mosquito Sub 19 Mosquito 34 77 58 61
6 San Roque Balompie Sub 19 B Roque 34 60 42 58
7 Castilleja CF B Castilleja 34 79 59 50
8 UD Bellavista Sub 19 Bellavista 34 63 56 50
9 Coria CF B Coria CF B 34 59 52 47
10 Lora CF Lora CF 34 62 61 47
11 Torreblanca CF Sub 19 Torreblanca 34 48 61 42
12 Andalucía Este Andalucía 34 38 55 41
13 CMD San Juan Juvenil Juan Juvenil 34 41 63 38
14 Estrella San Agustín Estrella 34 44 76 36
15 U.D. Moron C.F. U.D. Moron. 34 52 69 34
16 CD Asoc. Dva. Nervion Asoc. Dva.. 34 57 76 33
17 Los Palacios CF Palacios 34 45 86 30
18 Atletico Libertad Atletico 34 31 100 11
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CD Los Caminantes Caminantes 9 18 10 21
2 CD Cabecense Sub 19 Cabecense 9 14 9 18
3 UD Tomares Sub 19 Tomares 8 13 6 16
4 Coria CF B Coria CF B 9 19 19 13
5 Atletico Libertad Atletico 9 16 15 11
6 Los Palacios CF Palacios 8 13 12 11
7 UD Bellavista Sub 19 Bellavista 9 12 13 11
8 CMD San Juan Juvenil Juan Juvenil 9 12 15 10
9 AD Pvo. Sevilla Este Pvo. Sevilla 9 13 21 7
10 CDAtletico Dos Hermanas CF CDAtletico 9 12 22 4
TEMPORADA 2019/2020
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 C Atl. Antoniano Atl. 24 50 35 46
2 Sevilla FC SAD Sevilla 23 68 31 43
3 UD Tomares Sub 19 Tomares 24 51 25 43
4 Atletico Libertad Atletico 24 52 30 42
5 San Roque Balompie Sub 19 Roque 24 53 34 42
6 UD Bellavista Sub 19 Bellavista 24 39 35 42
7 Torreblanca CF Sub 19 Torreblanca 23 39 35 40
8 CD Utrera Sub 19 Utrera 23 51 25 39
9 CD Los Caminantes Caminantes 24 38 35 35
10 Centro Histórico AAVV Centro 23 51 40 34
11 CD Cabecense Sub 19 Cabecense 24 32 47 34
12 CD Mosquito Sub 19 Mosquito 23 44 42 33
13 CMD San Juan Juvenil Juan Juvenil 24 30 46 24
14 Calavera Sub 19 B Calavera 24 41 57 22
15 CD Asoc. Dva. Nervion Asoc. Dva.. 24 29 45 20
16 AD Pvo. Sevilla Este Pvo. Sevilla 23 21 54 10
17 CDAtletico Dos Hermanas CF CDAtletico 23 13 86 7
18 Ecija Balompie SAD Ecija 1 0 0 1
TEMPORADA 2018/2019
4ª ANDALUZA SEVILLA JUVENIL GRUPO 6
Equipo PJ GF GC Puntos
1 UD Tomares Sub 19 Tomares 27 81 25 64
2 Espartinas C.F. Espartinas 27 67 31 62
3 Gelves Gelves 27 73 45 54
4 Villafranco Villafranco 27 75 38 51
5 Juventud Gines Sub 19 Juventud 27 78 42 51
6 Atletico Libertad Atletico 27 67 50 45
7 Camino Viejo B Camino Viejo 27 42 39 40
8 Mairena del Aljarafe A Mairena 28 44 42 39
9 UD Loreto UD Loreto 28 47 42 38
10 Almensilla Almensilla 27 35 50 34
11 Pilas Atletico Pilas 27 57 80 23
12 Betisevilla CD Betisevilla 27 45 79 22
13 RCD Nueva Sevilla Nueva 28 37 108 15
14 San Martin CD Martin 27 41 83 14
15 Academia Ugena Academia 17 15 50 4
16 JD Bormujos A Bormujos 0 0 0 0
TEMPORADA 2017/2018
4ª ANDALUZA SEVILLA JUVENIL GRUPO 6
Equipo PJ GF GC Puntos
1 Benacazon Benacazon 30 104 36 81
2 Camas CF Camas CF 30 119 18 78
3 JD Bormujos JD Bormujos 30 83 37 67
4 Camino Viejo B Camino Viejo 30 58 42 57
5 Almensilla Almensilla 30 64 70 48
6 Villafranco Villafranco 30 80 57 46
7 RCD Nueva Sevilla Nueva 30 56 63 42
8 UD Loreto UD Loreto 30 57 58 41
9 Cdtor del Rey de Pilas Cdtor Pilas 30 56 63 36
10 Academia Ugena Academia 30 56 63 34
11 Huevar Huevar 30 56 70 32
12 Santiponce Santiponce 30 49 76 32
13 Atletico Libertad Atletico 30 64 75 31
14 Gelves Gelves 30 45 71 28
15 Mures Mures 30 37 91 19
16 Mairena del Aljarafe A Mairena 30 34 128 8
TEMPORADA 2016/2017
3ª ANDALUZA SEVILLA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Castilleja CF Sub 19 Castilleja 32 106 32 73
2 Tor del Rey de Pilas Pilas 33 101 35 71
3 CD Montequinto Montequinto 33 105 55 67
4 Olivarense Atlético Olivarense 33 118 61 65
5 CD Alcala CD Alcala 33 81 66 54
6 Ecija Balompie SAD Ecija 33 69 73 45
7 San Roque Balompie Sub 19 Roque 33 82 65 44
8 AD San José Sub 19 José 33 63 77 44
9 Diez Sanlucar Diez 33 65 71 43
10 Diablos Rojos CD Diablos 32 59 52 42
11 Coria CF B Coria CF B 33 55 62 42
12 U.P Viso U.P Viso 33 75 98 40
13 Campana Balompie Campana 33 55 89 40
14 Vistahermosa CF Vistahermosa 33 77 123 40
15 Atletico Libertad Atletico 33 71 75 39
16 Circulo Don Bosco Circulo 33 61 80 34
17 Torreblanca CF Sub 19 Torreblanca 33 40 139 16
18 Ecija CF Ecija CF 15 15 45 7
TEMPORADA 2015/2016
3ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Antoniano Sub 19 Atlético 33 122 58 70
2 Mairena Aljarafe U.D Mairena 33 95 52 69
3 AD Nervión Sub 19 Nervión 33 85 45 68
4 Atletico Dos Hermanas Atletico 34 100 69 65
5 Atletico Libertad Atletico 33 77 60 59
6 CD Demo CD Demo 33 73 56 55
7 Calavera CF B Calavera 34 86 61 55
8 Diez Sanlucar Diez 33 67 58 53
9 Ecija CF Ecija CF 34 71 46 50
10 La Liara Balompié Liara 33 52 45 45
11 Tor del Rey de Pilas Pilas 33 63 65 43
12 Cantely CD Cantely CD 33 49 68 37
13 Bellavista UD Bellavista 33 53 59 36
14 CD Los Caminantes Caminantes 33 43 73 35
15 Lora CF Lora CF 33 47 121 25
16 Cerro del Águila AD Cerro 33 47 90 24
17 Alcolea del Rio FC Alcolea 33 52 126 16
18 Rinconada UD Rinconada 20 28 58 11
TEMPORADA 2014/2015
3ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Calavera CF B Calavera 34 81 27 85
2 San Juan CMD Juan 34 105 27 79
3 Cazalla de la Sierra Cazalla 34 88 48 73
4 Atletico Libertad Atletico 34 80 55 69
5 Portaceli CD Portaceli 34 84 45 62
6 Diez Sanlucar Diez 34 60 53 51
7 Rinconada UD Rinconada 34 53 60 50
8 AD Nervión Sub 19 Nervión 34 61 62 48
9 Bellavista UD Bellavista 34 78 63 45
10 Lora CF Lora CF 34 73 70 45
11 La Oliva AF La Oliva AF 34 68 68 45
12 San Roque Balompie Sub 19 Roque 34 74 79 45
13 Circulo Don Bosco Circulo 34 63 70 39
14 Diablos Rojos CD Diablos 34 45 86 28
15 Triana C.F. Triana C.F. 34 34 78 27
16 Atlético Algabeño Atlético 34 49 100 27
17 La Union-08 CD Union-08 34 48 105 25
18 Umbrete CF Umbrete CF 34 37 85 23
TEMPORADA 2013/2014
3ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 UD Tomares Sub 19 Tomares 32 125 37 75
2 Puebla CF Puebla CF 32 94 44 70
3 Calavera CF B Calavera 32 89 39 67
4 Cazalla de la Sierra Cazalla 32 78 46 61
5 Cantely C.D. Cantely C.D. 32 75 45 56
6 Diez Sanlucar Diez 32 50 37 54
7 UD Bellavista B Bellavista 32 72 62 51
8 UD Rinconada Rinconada 32 64 51 51
9 Atletico Libertad Atletico 32 78 62 51
10 Lora CF Lora CF 32 68 66 50
11 Umbrete CF Umbrete CF 32 45 79 39
12 J.D. Gines J.D. Gines 32 56 68 37
13 Cerro del Águila AD Cerro 32 48 62 33
14 CD Demo CD Demo 33 53 66 33
15 Atlético Algabeño Atlético 32 47 81 32
16 Los Palacios CdF Palacios 32 36 137 11
17 RCD Nueva Sevilla Nueva 32 18 114 10
18 Villanueva Atlético Villanueva 1 0 0 1

  USO DE MEMORIA  
5,849,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1493
Total Execution Time  0.1512
  CADENA URL  
/historico/Atletico-Libertad-Juvenil
  GET DATOS  
$_GET['/historico/Atletico-Libertad-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0032  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 = 'Atletico-Libertad-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.0034  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 = 'Atletico-Libertad-Juvenil' 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.0022  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=19529 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=19529 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=19529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029  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=19529 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=19529 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=19529 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=19529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=19529 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=19529 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=19529 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=19529 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=19529 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=19529 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 69760
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19529 AND type_rel = 2
0.0025  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 = '19529' ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '19529' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '19529' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 69760 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=19529 AND l.year in (2022,2023,2024) 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 (69760,64947) 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.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64947 AND teamId = 19529
0.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69760 AND teamId = 19529
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 69760 AND t.round = 30 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 = '19529' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19529' 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 = '19529' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  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 = 19529 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2023_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 = 69760 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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_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 = 64947 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.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 `tables2021_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 = 59547 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 45804 AND t.round = 34 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 `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 = 45824 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 `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 = 39990 AND t.round = 34 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 `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 = 40036 AND t.round = 30 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 `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 = 34225 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 17035 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 4270 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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_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 = 3038 AND t.round = 34 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 = 69760 ORDER BY nameShow LIMIT 100