4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Athletic Club Fuengirola
TEMPORADA 2022/2023
4ª ANDALUZA MÁLAGA CADETE GRUPO 9
Equipo PJ GF GC Puntos
1 Marbella FC Marbella FC 28 120 21 75
2 Futbol Banus Futbol Banus 28 104 30 69
3 Candor CF Candor CF 28 94 22 67
4 Asociación Deportiva Benalm Asociación 28 86 24 60
5 Athletic Club Fuengirola Athletic 28 63 37 53
6 Unión Benahavís Unión 28 86 49 52
7 Vázquez Cultural Vázquez 28 92 49 50
8 Benaojan Benaojan 28 99 80 49
9 Mijas Las Lagunas Mijas 28 94 43 45
10 Benalmádena Atlético B Benalmádena 28 37 79 25
11 Asdva Pablo Picaso Asdva Pablo 28 65 87 23
12 Cortes Cortes 28 69 142 22
13 Union Deportiva Esteponense Union 28 42 126 12
14 Union Manilva Union 28 16 143 6
15 CD Oso CD Oso 28 18 153 4
16 Peña Compadres Peña 0 0 0 0
TEMPORADA 2021/2022
3ª ANDALUZA MÁLAGA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 CD Juventud De Torremolinos Juventud 30 155 29 81
2 Mortadelo B Mortadelo B 30 110 35 79
3 Tiro Pichon Sub 16 Tiro Pichon 29 111 41 72
4 Estepona Fútbol Base B Estepona 30 92 42 59
5 Union Deportiva Alameda Union 30 94 59 58
6 CD Alhaurino Alhaurino 30 78 59 47
7 UD San Pedro Pedro 28 60 56 46
8 Alhaurin de La Torre Alhaurin 30 87 83 39
9 Puerto de La Torre Los Mora Puerto Torre 30 67 95 37
10 Marbella Paraiso Sub 16 Marbella 29 74 76 36
11 Benamiel Atletico Benamiel 30 38 66 26
12 Campillos Campillos 30 53 96 25
13 Mijas Las Lagunas Mijas 29 44 93 23
14 Asdva Pablo Picaso Asdva Pablo 28 39 102 23
15 Athletic Club Fuengirola Athletic 30 36 99 19
16 Peña Compadres Peña 29 22 129 11
17 Costa Unida CF Costa Unida 0 0 0 0
TEMPORADA 2020/2021
3ª ANDALUZA MÁLAGA CADETE GRUPO 4
Equipo PJ GF GC Puntos
1 Fuengirola Boliches Sub 16 Fuengirola 9 31 8 24
2 Tiro Pichon Sub 16 B Tiro Pichon 7 17 10 15
3 Union Deportiva Alameda Union 6 25 10 13
4 Athletic Club Fuengirola Athletic 9 24 15 13
5 Benamiel Atletico Benamiel 9 20 13 13
6 Campillos Campillos 10 20 33 9
7 Mijas Las Lagunas B Mijas 7 7 21 7
8 Peña Los Compadres Peña 7 3 37 0
TEMPORADA 2019/2020
2ª ANDALUZA MÁLAGA CADETE
Equipo PJ GF GC Puntos
1 Marbella FC Marbella FC 24 67 26 57
2 Velez Francisco Castejon EF Velez 24 56 28 50
3 UD San Pedro Pedro 24 65 37 48
4 Estepona Sub 16 Estepona 23 52 25 47
5 Romeral Sub 16 Romeral 24 42 32 43
6 Conejito de Malaga Conejito 24 48 37 37
7 Antequera Antequera 24 51 47 36
8 Tiro Pichon Sub 16 B Tiro Pichon 22 41 33 35
9 CD Rincón CD Rincón 24 46 38 34
10 26 de Febrero Sub 16 Febrero 24 48 46 34
11 Alhaurin de La Torre Alhaurin 23 39 37 34
12 Mortadelo Sub 16 Mortadelo 23 41 45 32
13 D. Hermanas S.Andres Sub 16 Hermanas 24 44 59 28
14 Atletico Benamiel A Atletico 24 33 49 23
15 Puerto de La Torre Los Mora Puerto Torre 24 36 55 23
16 Athletic Club Fuengirola Athletic 23 39 47 22
17 Athletic Puerta Blanca Athletic 24 45 77 14
18 Peña Compadres Peña 24 20 95 4
TEMPORADA 2017/2018
2ª ANDALUZA MÁLAGA CADETE
Equipo PJ GF GC Puntos
1 CD Tiro Pichón Tiro Pichón 34 135 33 87
2 Athletic Club Fuengirola Athletic 34 78 28 74
3 Puerto Malagueño Sub 16 B Puerto 34 98 38 71
4 Antequera Antequera 34 77 54 59
5 Atlético Benamiel Atlético 34 85 59 56
6 UD San Pedro Pedro 34 66 66 50
7 Vazquez Cultural Vazquez 34 72 61 49
8 CD Rincón CD Rincón 34 86 78 49
9 Mortadelo Sub 16 Mortadelo 34 59 56 47
10 Athletic Puerta Blanca Athletic 34 69 70 47
11 UD Fuengirola Los Boliches Fuengirola 34 81 79 43
12 D. Hermanas S.Andres Sub 16 Hermanas 34 68 96 41
13 La Mosca B La Mosca B 34 63 94 41
14 Atletico Estacion Sub 16 Atletico 34 72 91 38
15 La Unidad Nueva Malaga Unidad Nueva 34 45 48 37
16 Fútbol Romeral Fútbol 34 58 72 36
17 Alhaurin de La Torre Alhaurin 34 63 90 35
18 Roma Luz C.F. Roma C.F. 34 24 186 4
TEMPORADA 2016/2017
3ª ANDALUZA MÁLAGA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Atletico Estacion Sub 16 Atletico 30 129 32 77
2 Athletic Club Fuengirola Athletic 30 99 32 69
3 Atletico Benamiel A Atletico 30 75 30 67
4 Marbella FC Marbella FC 30 66 40 61
5 Campanillas Campanillas 30 93 66 53
6 Alhaurino Alhaurino 30 68 53 49
7 Campillos Campillos 30 55 71 38
8 Conejito de Malaga Conejito 30 74 71 37
9 Fuengirola Boliches Sub 16 Fuengirola 30 60 85 36
10 Alhaurín de la Torre Alhaurín 30 55 70 33
11 San Pedro Brupocon Pedro 30 55 80 33
12 Peña Compadres Peña 30 47 74 33
13 Costa Unida Costa Unida 30 52 82 32
14 Estepona Sub 16 Estepona 30 50 53 31
15 Juventud de Torremolinos Juventud 30 32 116 18
16 D. Hermanas S.Andres Sub 16 Hermanas 30 45 100 15
TEMPORADA 2015/2016
4ª ANDALUZA MÁLAGA CADETE GRUPO 5
Equipo PJ GF GC Puntos
1 Juventud de Torremolinos Juventud 19 74 25 45
2 Benamiel Atletico B Benamiel 19 61 19 43
3 Mijas Mijas 18 60 26 40
4 Athletic Club Fuengirola Athletic 20 49 26 35
5 Mijas Las Lagunas B Mijas 20 59 40 33
6 Ronda A Ronda A 20 51 47 29
7 Ronda UD Ronda UD 20 34 44 22
8 Candor Candor 19 41 60 19
9 Peña Compadres B Peña 19 26 70 18
10 Marbelli Atletico Marbelli 19 31 73 13
11 Cala Mijas B Cala Mijas 19 25 81 9
TEMPORADA 2014/2015
4ª ANDALUZA MÁLAGA CADETE GRUPO 4
Equipo PJ GF GC Puntos
1 Cala Mijas Cala Mijas 28 124 32 67
2 Yunquera Atletico Yunquera 28 96 40 64
3 Pizarra Pizarra 28 72 35 61
4 Juventud de Torremolinos Juventud 28 110 50 55
5 Athletic Club Fuengirola Athletic 28 84 58 50
6 Benalmadena Benalmadena 28 72 50 50
7 Cartama Cartama 28 88 56 49
8 Mijas Mijas 28 76 51 48
9 Alora Sub 16 Alora 28 100 65 45
10 Candor Candor 28 56 60 34
11 Benarroyo Benarroyo 28 63 57 32
12 CD Alhaurino Alhaurino 28 31 93 19
13 Benamiel Atletico Benamiel 28 49 124 15
14 Athletic de Coin Sub 16 Athletic 28 40 113 8
15 Ronda B Ronda B 28 20 197 3

  USO DE MEMORIA  
5,602,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7228
Total Execution Time  0.7240
  CADENA URL  
/historico/Atheltic-Club-Fuengirola
  GET DATOS  
$_GET['/historico/Atheltic-Club-Fuengirola']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0140  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 = 'Atheltic-Club-Fuengirola' 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.0220  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 = 'Atheltic-Club-Fuengirola' 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.0130  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=25566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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 = 69869
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25566 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=768 AND type_rel = 3
0.0137  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 = '25566' ORDER BY l.year DESC,cat.coefficient DESC
0.0139  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 = '25566' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0139  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 = '25566' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  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 = 70184 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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 = 69869 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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=25566 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (70184,69869,66044) 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.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66044 AND teamId = 25566
0.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69869 AND teamId = 25566
0.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70184 AND teamId = 25566
0.0126  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 = '25566' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25566' and rp.type = 4
0.0128  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 = '25566' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0129  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 = 25566 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 69869 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.0129  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 = 66044 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.0129  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 = 66114 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.0128  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 = 59161 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.0128  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 = 59511 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.0131  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 = 52470 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.0130  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 = 40280 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 40486 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 35095 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 34347 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 17267 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 17296 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 4889 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC