4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ciutat de Palma SA
TEMPORADA 2022/2023
PREFERENTE BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Pla de na Tesa Tesa 33 115 36 76
2 Platges de Calvia B Platges 33 60 34 60
3 Alaro Alaro 34 70 49 59
4 Constancia B Constancia 34 73 55 58
5 Serverense Sub 19 Serverense 34 58 45 57
6 Ciutat de Palma SA Ciutat Palma 34 59 44 55
7 SD La Salle B Salle 33 63 50 54
8 CD Felanitx Sub 19 Felanitx 33 78 64 53
9 Arenal Arenal 34 70 53 52
10 Recreativo Son Caliu Recreativo 34 66 54 51
11 Sporting San Francisco Sporting 33 72 52 50
12 UE Petra UE Petra 34 55 53 49
13 Espanya Espanya 33 60 58 48
14 Binissalem A Binissalem 34 53 57 46
15 Montaura Montaura 33 56 83 36
16 La Unión Sub 19 Unión 33 39 69 28
17 Atlético Rafal B Atlético 34 34 115 9
18 Genova Genova 34 25 135 8
TEMPORADA 2021/2022
PREFERENTE BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Baleares Sub 19 B Atlético 33 125 25 85
2 Poblense Sub 19 Poblense 33 88 33 75
3 Pla de na Tesa Tesa 32 102 37 72
4 Platges de Calvia B Platges 33 67 40 64
5 Ciutat de Palma SA Ciutat Palma 33 82 66 61
6 Binissalem A Binissalem 33 75 40 59
7 CD Ferriolense Sub 19 Ferriolense 33 86 53 58
8 Joventut Mallorca A Joventut 33 70 74 54
9 CE Campos CE Campos 33 64 80 47
10 La Unión Sub 19 Unión 33 75 69 41
11 Rotlet-Molinar Rotlet-Molin 33 74 89 39
12 Arenal Arenal 33 44 48 37
13 Cide B Cide B 33 52 75 35
14 Viva Sports Viva Sports 33 65 100 31
15 Espanya Espanya 32 48 84 26
16 Son Cladera A Cladera 33 39 78 21
17 Porto Cristo A Porto Cristo 33 34 128 16
18 Collerense Collerense 33 40 111 14
TEMPORADA 2020/2021
2ª BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Ciutat de Palma SA Ciutat Palma 13 58 16 32
2 Ferriolense B Ferriolense 12 52 13 30
3 Atlético Marratxí B Atlético 15 39 31 25
4 ES Raval De Sta. C Raval Sta. 14 38 21 24
5 Son Ferrer Del PC Ferrer 12 35 17 22
6 Constancia D Constancia 13 32 14 22
7 Rotlet-Molinar Rotlet-Molin 12 19 22 17
8 Son Cladera At. del SC Cladera 13 21 27 15
9 San Alonso 08 Alonso 13 27 51 9
10 Palmanyola Palmanyola 14 20 72 5
11 San Pedro ATº DCSP Pedro ATº D. 13 6 63 0
TEMPORADA 2019/2020
1ª BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Espanya Espanya 26 65 36 58
2 Andratx Sub 19 Andratx 25 90 36 56
3 Atº Marratxí Atº 26 78 46 51
4 Rtvº La Victoria Rtvº 26 86 50 49
5 Alaro Alaro 26 57 46 48
6 Santa Catalina At. B Santa 26 61 48 46
7 Calvia Atº Del C B Calvia Atº 26 61 46 45
8 CD Arenal B CD Arenal B 26 63 58 44
9 La Union B La Union B 26 56 44 42
10 Escolar Escolar 26 75 56 39
11 Sant Jordi A Sant Jordi 27 61 61 33
12 Ciutat de Palma SA Ciutat Palma 26 56 58 30
13 Penya Arrabal C Penya 26 44 64 30
14 Penya Esp. S'Arenal Penya Esp.. 27 41 56 28
15 Madre Alberta Madre 26 31 62 26
16 Campanet Campanet 26 35 54 24
17 Viva Sports Viva Sports 26 35 73 23
18 Patronato B Patronato B 25 38 61 21
19 San Cayetano Cayetano 26 43 84 19
20 Son Sardina B Sardina 26 43 80 18
TEMPORADA 2018/2019
PREFERENTE BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Cide B Cide B 30 69 32 63
2 Platges de Calvia B Platges 30 62 34 58
3 La Unión Sub 19 Unión 30 43 26 55
4 Manacor C Manacor C 30 47 33 53
5 Ud Poblense Ud Poblense 30 53 39 50
6 UE Alcúdia A Alcúdia 30 55 44 49
7 San Francisco C Francisco 30 57 49 46
8 Binissalem A Binissalem 30 60 43 40
9 CE Esporles CE Esporles 30 56 51 38
10 Arenal Arenal 30 47 61 37
11 S'Horta S'Horta 30 46 56 36
12 Joventut Mallorca A Joventut 30 49 64 36
13 Sant Jordi A Sant Jordi 30 56 59 35
14 Ciutat de Palma SA Ciutat Palma 30 39 48 34
15 Genova Genova 30 43 57 32
16 Ferriolense B Ferriolense 30 32 118 9
TEMPORADA 2017/2018
PREFERENTE BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Rafal Sub 19 Atlético 30 84 30 69
2 La Unión Sub 19 Unión 30 78 31 67
3 Atlético Baleares Sub 19 B Atlético 30 87 33 65
4 Escolar Escolar 30 89 40 62
5 CD Serverense Serverense 30 89 66 56
6 Constancia B Constancia 30 72 44 55
7 Patronato A Patronato A 30 65 56 48
8 Joventut Mallorca A Joventut 30 58 46 42
9 S'Horta S'Horta 30 69 53 40
10 Murense Murense 30 53 56 40
11 Arenal Arenal 30 55 75 39
12 Ciutat de Palma SA Ciutat Palma 30 55 75 33
13 Ferriolense B Ferriolense 30 38 58 30
14 Sineu Sineu 30 57 91 22
15 Llosetense Llosetense 30 29 127 10
16 Alaro Alaro 30 19 116 6
TEMPORADA 2016/2017
PREFERENTE BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 AD Penya Arrabal Sub 19 B Penya 38 140 31 97
2 SD La Salle B Salle 38 105 45 83
3 Platges de Calvia Sub 19 Platges 38 96 26 82
4 Joventut Mallorca A Joventut 38 109 50 81
5 Ferriolense B Ferriolense 37 120 48 80
6 UE Alcúdia A Alcúdia 38 90 48 79
7 La Unión Sub 19 Unión 38 116 51 71
8 San Francisco C Francisco 38 114 106 61
9 Atlético Rafal Sub 19 Atlético 38 105 88 55
10 S'Horta S'Horta 38 82 79 53
11 Calvià Atlético Sub 19 Calvià 38 116 106 52
12 Binissalem A Binissalem 37 66 68 47
13 Ciutat de Palma SA Ciutat Palma 38 54 80 46
14 Cide B Cide B 38 65 83 41
15 CF Sóller A Sóller 38 59 102 41
16 CD Serverense Serverense 38 78 102 39
17 Consell CD Consell CD 36 78 139 34
18 Llosetense Llosetense 38 56 140 23
19 Santa Catalina Atletico A Santa 38 47 165 16
20 Patronato A Patronato A 38 38 177 13
TEMPORADA 2015/2016
PREFERENTE BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Baleares Sub 19 B Atlético 36 109 30 85
2 Alaro Alaro 37 114 42 82
3 SD La Salle B Salle 36 110 49 81
4 Patronato A Patronato A 35 98 46 79
5 AD Penya Arrabal Sub 19 B Penya 37 93 53 65
6 CF Sóller A Sóller 36 85 61 59
7 Binissalem A Binissalem 37 58 56 55
8 UE Alcúdia A Alcúdia 37 91 77 50
9 Llosetense Llosetense 37 67 76 49
10 CD Serverense Serverense 37 73 84 49
11 Santa Catalina Atletico A Santa 37 62 66 47
12 Ciutat de Palma SA Ciutat Palma 37 64 79 47
13 Cide B Cide B 37 70 66 46
14 S'Horta S'Horta 36 64 74 46
15 La Unión Sub 19 Unión 36 80 82 42
16 San Francisco C Francisco 35 69 93 42
17 Poblense B Poblense B 37 65 97 39
18 Campos Campos 37 63 107 30
19 Porto Cristo A Porto Cristo 36 32 161 12
20 Andratx Sub 19 Andratx 13 8 76 3
TEMPORADA 2014/2015
PREFERENTE BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Rafal Sub 19 Atlético 38 113 39 95
2 CD Manacor B Manacor 38 87 41 86
3 Atlético Baleares Sub 19 B Atlético 38 100 58 75
4 La Unión Sub 19 Unión 38 101 58 72
5 Cide B Cide B 38 88 49 71
6 SD La Salle B Salle 38 107 75 61
7 Campos Campos 38 88 76 61
8 Llosetense Llosetense 38 105 74 58
9 Ciutat de Palma SA Ciutat Palma 38 79 89 48
10 Patronato A Patronato A 38 54 83 48
11 AD Penya Arrabal Sub 19 B Penya 38 83 80 47
12 Binissalem A Binissalem 38 86 98 47
13 S'Horta S'Horta 38 84 82 46
14 Porto Cristo A Porto Cristo 38 78 110 46
15 Poblense B Poblense B 38 71 98 44
16 Santa Catalina Atletico A Santa 38 62 78 43
17 Alaro Alaro 38 78 126 39
18 Platges de Calvia Sub 19 Platges 38 64 88 36
19 Son Cladera A Cladera 38 64 91 36
20 Recreativo La Victoria A Recreativo 38 49 148 14

  USO DE MEMORIA  
5,867,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1303
Total Execution Time  0.1324
  CADENA URL  
/historico/Ciutat-De-Palma-Sa-Juvenil
  GET DATOS  
$_GET['/historico/Ciutat-De-Palma-Sa-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0024  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 = 'Ciutat-De-Palma-Sa-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 = 'Ciutat-De-Palma-Sa-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.0020  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=29697 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=29697 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=29697 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=29697 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=29697 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=29697 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=29697 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=29697 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=29697 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0034  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=29697 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=29697 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=29697 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 = 69170
0.0026  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 = 69171
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=29697 AND type_rel = 2
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 = '29697' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '29697' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '29697' 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 = 69171 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=29697 AND l.year in (2022,2023,2024) 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 (69171) 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 = 69171 AND teamId = 29697
0.0018  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 = 69170 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '29697' 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 = '29697' 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 = '29697' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0024  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 = 29697 AND l.year <= 2023 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_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 = 69170 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.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_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 = 69171 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.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 `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 = 63721 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.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 `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 = 59341 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.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 `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 = 59344 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.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 `tables2020_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 = 54117 AND t.round = 38 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 `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 = 44640 AND t.round = 30 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 `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 = 39247 AND t.round = 30 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 `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 = 34281 AND t.round = 38 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 `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 = 17089 AND t.round = 38 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 `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 = 5174 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC