4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UD Mahón
TEMPORADA 2023/2024
PREFERENTE BALEARES GRUPO 3
Equipo PJ GF GC Puntos
1 CD Migjorn CD Migjorn 20 52 15 45
2 Sporting de Mahón Sporting 20 52 18 44
3 CD Menorca CD Menorca 20 48 24 43
4 CE Ferreries Ferreries 20 48 14 42
5 UD Mahón UD Mahón 20 38 22 32
6 Atlético Villacarlos Atlético 20 40 31 31
7 Penya Ciutadella Penya 20 27 21 25
8 CCE Sant Lluís Sant Lluís 20 17 38 17
9 CF Norteño CF Norteño 20 18 53 16
10 UE Sami UE Sami 20 25 54 11
11 Atlètic De Ciutadella Atlètic 20 9 84 3
TEMPORADA 2022/2023
PREFERENTE BALEARES GRUPO 3
Equipo PJ GF GC Puntos
1 CE Alaior CE Alaior 20 54 11 48
2 CE Ferreries Ferreries 20 45 23 46
3 CD Migjorn CD Migjorn 20 40 13 40
4 Atlético Villacarlos Atlético 20 43 24 38
5 UD Mahón UD Mahón 20 48 25 35
6 UE Sami UE Sami 20 41 32 32
7 CD Menorca CD Menorca 20 44 39 28
8 Sporting de Mahón Sporting 20 36 42 20
9 CCE Sant Lluís Sant Lluís 20 30 53 13
10 CF Norteño CF Norteño 20 19 82 8
11 Atlètic De Ciutadella Atlètic 20 6 62 5
TEMPORADA 2021/2022
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 CD Menorca CD Menorca 20 56 20 46
2 CE Alaior CE Alaior 20 47 17 44
3 UD Mahón UD Mahón 20 52 20 42
4 CD Migjorn CD Migjorn 20 46 21 39
5 CE Ferreries Ferreries 20 34 23 36
6 CCE Sant Lluís Sant Lluís 20 31 44 26
7 Penya Ciutadella Penya 20 28 31 23
8 Atlètic De Ciutadella Atlètic 20 24 42 21
9 UE Sami UE Sami 20 16 34 13
10 Sporting de Mahón Sporting 20 18 54 8
11 Atlético Villacarlos Atlético 20 15 61 8
TEMPORADA 2020/2021
PREFERENTE BALEARES GRUPO 3
Equipo PJ GF GC Puntos
1 Mercadal Mercadal 22 78 14 66
2 UD Mahón UD Mahón 22 57 21 44
3 CE Alaior CE Alaior 22 46 26 42
4 CD Menorca CD Menorca 22 47 35 41
5 UE Sami UE Sami 22 41 32 39
6 CD Migjorn CD Migjorn 22 39 27 36
7 Sporting de Mahón Sporting 22 35 48 25
8 CCE Sant Lluís Sant Lluís 22 30 47 25
9 CE Ferreries Ferreries 22 26 40 25
10 Penya Ciutadella Penya 22 36 52 23
11 Atlético Villacarlos Atlético 22 22 74 7
12 Atlètic De Ciutadella Atlètic 22 14 55 6
TEMPORADA 2019/2020
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Mercadal Mercadal 12 36 4 34
2 CE Alaior CE Alaior 13 26 20 25
3 CCE Sant Lluís Sant Lluís 13 22 16 23
4 UD Mahón UD Mahón 12 27 15 19
5 UE Sami UE Sami 13 14 16 17
6 Sporting de Mahón Sporting 13 19 15 16
7 CD Menorca CD Menorca 13 20 20 16
8 CE Ferreries Ferreries 13 22 28 15
9 CD Migjorn CD Migjorn 13 18 22 14
10 Penya Ciutadella Penya 12 16 37 7
11 Atlètic De Ciutadella Atlètic 13 8 35 6
TEMPORADA 2018/2019
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 UD Mahón UD Mahón 16 51 12 39
2 Sporting de Mahón Sporting 16 37 11 35
3 CE Ferreries Ferreries 16 29 18 27
4 CD Migjorn CD Migjorn 16 30 24 24
5 CE Alaior CE Alaior 16 29 35 23
6 UE Sami UE Sami 16 23 26 21
7 Penya Ciutadella Penya 16 15 25 18
8 CCE Sant Lluís Sant Lluís 16 23 33 13
9 Atlètic De Ciutadella Atlètic 16 11 64 1
TEMPORADA 2017/2018
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Sporting de Mahón Sporting 16 26 8 34
2 UD Mahón UD Mahón 16 44 17 33
3 CE Ferreries Ferreries 16 35 19 30
4 UE Sami UE Sami 16 23 20 26
5 Penya Ciutadella Penya 16 25 21 24
6 CCE Sant Lluís Sant Lluís 16 26 22 21
7 CE Alaior CE Alaior 16 22 33 15
8 Atlètic De Ciutadella Atlètic 16 8 30 10
9 CD Migjorn CD Migjorn 16 7 46 6
TEMPORADA 2016/2017
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 UD Mahón UD Mahón 16 35 16 37
2 UE Sami UE Sami 16 32 13 36
3 CCE Sant Lluís Sant Lluís 16 32 26 23
4 CE Ferreries Ferreries 16 18 19 22
5 CE Alaior CE Alaior 16 21 23 21
6 Atlètic De Ciutadella Atlètic 16 19 30 20
7 Sporting de Mahón Sporting 16 11 14 16
8 CD Migjorn CD Migjorn 16 18 31 14
9 CD Menorca CD Menorca 16 19 33 11
TEMPORADA 2015/2016
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 CE Alaior CE Alaior 16 32 11 38
2 Sporting de Mahón Sporting 16 26 11 34
3 UD Mahón UD Mahón 16 27 12 30
4 UE Sami UE Sami 15 29 22 28
5 CD Menorca CD Menorca 15 20 18 23
6 CE Ferreries Ferreries 16 21 26 18
7 Atlètic De Ciutadella Atlètic 16 22 37 13
8 CD Migjorn CD Migjorn 16 16 36 10
9 CCE Sant Lluís Sant Lluís 16 9 29 10
TEMPORADA 2014/2015
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 CE Ferreries Ferreries 18 46 14 43
2 CE Alaior CE Alaior 18 40 21 40
3 UE Sami UE Sami 17 35 16 32
4 Sporting de Mahón Sporting 18 38 24 32
5 UD Mahón UD Mahón 17 21 20 28
6 CCE Sant Lluís Sant Lluís 18 23 31 22
7 CF Norteño CF Norteño 18 19 30 18
8 CD Menorca CD Menorca 17 16 22 16
9 Atlètic De Ciutadella Atlètic 17 15 36 11
10 CD Migjorn CD Migjorn 18 12 51 5
TEMPORADA 2013/2014
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 CE Ferreries Ferreries 18 35 15 39
2 CD Migjorn CD Migjorn 18 30 17 39
3 CE Alaior CE Alaior 18 36 20 36
4 Atlètic De Ciutadella Atlètic 18 29 23 27
5 CD Menorca CD Menorca 18 22 22 25
6 UE Sami UE Sami 18 24 35 20
7 UD Mahón UD Mahón 18 21 25 19
8 CCE Sant Lluís Sant Lluís 18 22 28 17
9 Sporting de Mahón Sporting 18 15 30 15
10 CF Norteño CF Norteño 18 21 40 14
TEMPORADA 2012/2013
PREFERENTE BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 CD Migjorn CD Migjorn 18 34 17 37
2 Ce Ferreries Ferreries 18 32 17 35
3 CD Menorca CD Menorca 18 25 15 31
4 CE Alaior CE Alaior 18 28 28 31
5 UE Sami UE Sami 18 27 26 28
6 Atlètic De Ciutadella Atlètic 18 25 24 26
7 Atlético Villacarlos Atlético 18 23 31 20
8 UD Mahón UD Mahón 18 23 33 20
9 CCE Sant Lluís Sant Lluís 18 24 24 19
10 CF Norteño CF Norteño 18 16 42 5
TEMPORADA 1973/1974
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Barça Atlètic Barça 38 62 32 52
2 Valencia Mestalla Valencia 38 41 35 47
3 Girona Girona 38 56 35 43
4 SD Ibiza SD Ibiza 38 45 35 42
5 Terrassa FC Terrassa FC 38 56 36 42
6 Olimpic Xátiva Olimpic 38 38 34 42
7 Vinaròs Vinaròs 38 40 31 42
8 Ontinyent CF Ontinyent 38 43 34 42
9 Tortosa Tortosa 38 51 44 41
10 Atlètic De Ciutadella Atlètic 38 57 43 40
11 Lleida Lleida 38 47 49 39
12 Villarreal Villarreal 38 38 35 39
13 Calella Calella 38 37 39 36
14 UD Alzira UD Alzira 38 42 54 36
15 CD Menorca CD Menorca 38 36 50 35
16 Alcoyano Alcoyano 38 38 35 35
17 CF Gandia CF Gandia 38 32 39 33
18 CE Europa CE Europa 38 35 55 28
19 UD Mahón UD Mahón 38 24 57 24
20 Manacor Manacor 38 30 76 22
TEMPORADA 1968/1969
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 CD Castellón Castellón 38 84 22 59
2 Gimnàstic Tarragona Gimnàstic 38 83 33 57
3 Levante Levante 38 78 34 52
4 CD Acero CD Acero 38 70 35 51
5 Atlético Baleares Atlético 38 56 27 51
6 Tortosa Tortosa 38 68 43 41
7 Onda Onda 38 55 51 37
8 Villarreal Villarreal 38 53 50 37
9 Torrent Torrent 38 44 50 36
10 UD Mahón UD Mahón 38 50 55 36
11 Benicarló Benicarló 38 51 62 35
12 SD Ibiza SD Ibiza 38 45 55 34
13 Manacor Manacor 38 44 67 33
14 Reus Deportiu Reus 38 47 71 32
15 At. Levante At. Levante 38 47 57 32
16 CD Menorca CD Menorca 38 36 56 31
17 Poblense Poblense 38 43 69 29
18 Constància Constància 38 50 90 28
19 Soledad Soledad 38 33 63 28
20 Santa Catalina Atlético Santa 38 40 87 21
TEMPORADA 1966/1967
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 UD Mahón UD Mahón 22 59 19 40
2 SD Ibiza SD Ibiza 22 58 27 34
3 Atlético Baleares Atlético 22 41 16 30
4 Soledad Soledad 22 31 23 25
5 CD Menorca CD Menorca 22 46 27 24
6 CF Palma CF Palma 22 39 37 24
7 Manacor Manacor 22 31 37 21
8 Atlètic De Ciutadella Atlètic 22 19 30 16
9 CE Alaior CE Alaior 22 28 52 14
10 Binissalem Binissalem 22 15 40 14
11 Santa Catalina Atlético Santa 22 32 53 13
12 Poblense Poblense 22 15 53 9
TEMPORADA 1965/1966
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 UD Mahón UD Mahón 18 45 5 31
2 Atlético Baleares Atlético 18 41 12 26
3 CD Menorca CD Menorca 18 31 15 23
4 CF Palma CF Palma 18 28 18 22
5 Soledad Soledad 18 25 28 17
6 SD Ibiza SD Ibiza 18 19 30 16
7 Manacor Manacor 18 24 40 14
8 Atlètic De Ciutadella Atlètic 18 11 23 13
9 CE Alaior CE Alaior 18 13 34 11
10 Poblense Poblense 18 15 47 7
TEMPORADA 1964/1965
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Atlético Baleares Atlético 16 36 8 25
2 CD Menorca CD Menorca 16 35 8 25
3 Soledad Soledad 16 30 19 19
4 Atlètic De Ciutadella Atlètic 16 26 25 15
5 UD Mahón UD Mahón 16 32 22 15
6 SD Ibiza SD Ibiza 16 15 30 13
7 Manacor Manacor 16 13 25 13
8 Poblense Poblense 16 12 29 10
9 CE Alaior CE Alaior 16 6 39 9
TEMPORADA 1963/1964
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 CD Menorca CD Menorca 14 25 10 20
2 UD Mahón UD Mahón 14 31 16 19
3 Atlético Baleares Atlético 14 20 9 19
4 Manacor Manacor 14 23 14 14
5 Atlètic De Ciutadella Atlètic 14 12 21 14
6 Soledad Soledad 14 11 17 11
7 CE Alaior CE Alaior 14 10 32 8
8 SD Ibiza SD Ibiza 14 17 30 7
TEMPORADA 1962/1963
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 UD Mahón UD Mahón 15 37 11 23
2 Atlètic De Ciutadella Atlètic 16 32 17 22
3 SD Ibiza SD Ibiza 16 39 22 22
4 CD Menorca CD Menorca 16 29 25 15
5 Manacor Manacor 15 24 18 13
6 CE Alaior CE Alaior 16 16 29 11
7 Juventud Sallista Juventud 16 16 29 11
8 Felanitx Felanitx 16 20 49 11
9 Soledad Soledad 16 21 34 11
TEMPORADA 1961/1962
TERCERA DIVISIÓN GRUPO 9
Equipo PJ GF GC Puntos
1 CD Menorca CD Menorca 12 36 15 18
2 Atlètic De Ciutadella Atlètic 12 21 21 15
3 UD Mahón UD Mahón 12 29 20 14
4 CE Alaior CE Alaior 12 9 39 1

  USO DE MEMORIA  
6,515,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.1461
Total Execution Time  0.1491
  CADENA URL  
/historico/Ud-Mahon-Senior
  GET DATOS  
$_GET['/historico/Ud-Mahon-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0047  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 = 'Ud-Mahon-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.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=11441 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=11441 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=11441 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045  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 = 75857
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11441 AND type_rel = 2
0.0030  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 = '11441' ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '11441' 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 = '11441' 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 = 75857 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=11441 AND l.year in (2023,2024,2025) 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 (75857) 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 WHERE league_id = 75857 AND teamId = 11441
0.0020  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 = '11441' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11441' 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 = '11441' 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 = 73802 WHERE rp.league_id = 73802 AND rp.teamId = 11441 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.0027  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 = 73802 WHERE rp.league_id = 73802 AND rp.teamId = 11441 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 73802 WHERE rp.league_id = 73802 AND rp.teamId = 11441 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 11441 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73802 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.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` 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 = 68765 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.0021  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 = 63861 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.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 `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 = 58996 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.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 `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 = 51181 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 44633 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 39696 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 34176 AND t.round = 18 ORDER BY team.conference 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 `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 = 16707 AND t.round = 18 ORDER BY team.conference 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 `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 = 4320 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 2684 AND t.round = 18 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 `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 = 2054 AND t.round = 18 ORDER BY team.conference 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 `tables1974` 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 = 21637 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 `tables1969` 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 = 21616 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables1967` 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 = 22202 AND t.round = 22 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 `tables1962` 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 = 21540 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC