4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Maracena B
TEMPORADA 2022/2023
3ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 CD Huetor Tajar Huetor Tajar 29 102 47 66
2 CF Alhendín Balompié B Alhendín 29 105 47 65
3 Español Albolote Español 29 84 41 63
4 Huétor Vega CD Huétor Vega 29 102 51 57
5 Ogijares 89 Ogijares 89 29 86 53 55
6 Club de Futbol Motril Club Futbol 29 67 42 49
7 Zaidin Zaidin 29 74 60 45
8 Maracena B Maracena B 30 61 55 44
9 Otura CF Otura CF 29 84 70 41
10 CF Sierra Nevada-Cenes Sierra 30 83 96 37
11 Arenas de Armilla B Arenas 30 68 78 35
12 Reino De Granada B Reino 30 64 66 34
13 CD UD Illora Illora 29 74 87 33
14 Celtic CF Celtic CF 30 58 99 28
15 CD Cijuela 2008 Cijuela 2008 30 21 105 18
16 U.D. Alfacar U.D. Alfacar 29 38 174 7
TEMPORADA 2021/2022
2ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 CD Santa Fe Sub 19 Santa 33 90 41 73
2 CD Ciudad De Baza Sub 19 Ciudad Baza 34 92 47 70
3 Atletico Monachil Atletico 34 90 48 65
4 Ogijares 89 Ogijares 89 33 81 54 61
5 Atarfe Industrial CF Atarfe 34 62 50 60
6 CD Estrellas Chana Barrio Estrellas 34 80 63 54
7 Reino de Granada Reino 34 79 79 47
8 Guadix CF Guadix CF 34 80 75 45
9 Loja CD Loja CD 34 64 62 45
10 Almuñécar 77 Almuñécar 34 66 74 45
11 Ciudad de Granada Ciudad 34 75 75 43
12 Zaidin Zaidin 34 73 88 43
13 Club de Futbol Motril Club Futbol 34 57 77 43
14 CD Huetor Tajar Huetor Tajar 34 55 74 40
15 Arenas de Armilla B Arenas 34 53 74 37
16 Maracena B Maracena B 34 64 86 34
17 Huétor Vega CD Huétor Vega 34 53 93 33
18 Celtic CF Celtic CF 34 37 91 24
TEMPORADA 2020/2021
2ª ANDALUZA GRANADA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 We FC Sub 19 13 24 11 28
2 Club de Futbol Motril Club Futbol 12 34 18 26
3 Huétor Vega CD Huétor Vega 12 29 15 26
4 Atletico Monachil Atletico 13 24 22 21
5 CD Estrellas Chana Barrio Estrellas 13 23 19 20
6 Zaidin Zaidin 13 30 37 18
7 Arenas de Armilla B Arenas 13 28 33 15
8 Sierra Nevada-Cenes Sierra 13 41 36 13
9 Maracena B Maracena B 12 17 28 13
10 Sporting Vegas del Genil Sporting 10 6 37 0
TEMPORADA 2019/2020
2ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 CF Alhendín Balompié Harley Alhendín 24 85 28 60
2 CD Santa Fe Sub 19 Santa 24 80 33 52
3 Club de Futbol Motril Club Futbol 24 68 39 50
4 Maracena B Maracena B 24 49 28 48
5 CD Huetor Tajar Huetor Tajar 24 50 30 47
6 Atletico Monachil Atletico 24 57 36 42
7 We FC Sub 19 24 43 39 36
8 Loja CD Loja CD 24 55 41 35
9 CD Ciudad De Baza Sub 19 Ciudad Baza 24 55 60 35
10 Guadix CF Guadix CF 24 54 54 32
11 CD Estrellas Chana Barrio Estrellas 24 37 44 30
12 CD Vandalia de Peligros Vandalia 24 50 60 27
13 Celtic CF Celtic CF 24 38 65 26
14 CD Chauchina Chauchina 24 40 64 21
15 Atarfe Industrial CF Atarfe 24 37 66 18
16 CD At. Salobreña Salobreña 24 31 71 17
17 Arenas de Armilla B Arenas 24 45 72 15
18 Sporting Vegas del Genil Sporting 24 33 77 11
TEMPORADA 2018/2019
2ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 Arenas de Armilla Sub 19 Arenas 34 97 44 76
2 Maracena B Maracena B 34 104 45 71
3 CD Santa Fe Sub 19 Santa 34 77 37 69
4 Loja C.D. Loja C.D. 34 81 36 68
5 Alhendín Balompié Sub 19 Alhendín 34 90 49 65
6 Club de Futbol Motril Club Futbol 33 81 63 57
7 We FC Sub 19 34 66 51 57
8 Vandalia de Peligros Vandalia 34 56 50 55
9 Ud Estrellas Chana Estrellas 34 62 51 54
10 Chauchina Chauchina 34 69 64 51
11 Guadix C.F. Guadix C.F. 34 57 64 44
12 Atarfe Industrial B Atarfe 34 60 72 36
13 Calahonda-Carchuna Calahonda-Ca 34 63 97 36
14 Atletico Monachil Atletico 34 54 86 34
15 Huétor Vega CD Huétor Vega 33 56 82 26
16 Juventud Sexitana Juventud 34 43 121 24
17 Otura Otura 34 44 88 21
18 Sierra Nevada-Cenes Sierra 34 48 108 21
TEMPORADA 2017/2018
2ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 Granada C.F. SAD C Granada C.F. 34 112 40 80
2 Maracena B Maracena B 34 92 54 67
3 Celtic Pulianas CF A Celtic 34 84 64 67
4 Club de Futbol Motril Club Futbol 34 93 63 66
5 Ud Estrellas Chana Estrellas 34 81 54 59
6 Loja C.D. Loja C.D. 34 89 73 56
7 Atarfe Industrial B Atarfe 34 85 69 55
8 We FC Sub 19 34 62 57 49
9 Sierra Nevada-Cenes Sierra 34 66 68 47
10 Atletico Monachil Atletico 34 71 60 46
11 Juventud Sexitana Juventud 34 73 99 45
12 CD Santa Fe Sub 19 Santa 34 52 62 39
13 Guadix C.F. Guadix C.F. 34 48 64 39
14 Otura Otura 34 50 54 38
15 Atlético Salobreña Atlético 34 63 79 36
16 C.D. Huetor Tajar A C.D. Huetor 34 63 82 31
17 Arenas de Armilla Sub 19 Arenas 34 59 92 31
18 Ogíjares89 Ogíjares89 34 34 143 6
TEMPORADA 2016/2017
2ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 Granada C.F. SAD C Granada C.F. 32 120 28 84
2 Arenas de Armilla Sub 19 Arenas 32 116 63 73
3 Maracena B Maracena B 32 97 31 68
4 Motril Motril 31 88 35 68
5 Loja C.D. Loja C.D. 32 106 54 65
6 Atarfe Industrial B Atarfe 32 77 58 51
7 C.D. Huetor Tajar A C.D. Huetor 32 63 52 49
8 Santa Fe B Juvenil Santa 32 65 64 47
9 Guadix C.F. Guadix C.F. 31 65 75 46
10 Ogíjares89 Ogíjares89 31 58 76 41
11 Sierra Nevada-Cenes Sierra 32 62 85 34
12 Ud Estrellas Chana Estrellas 32 66 92 32
13 Juventud Sexitana Juventud 32 48 82 29
14 Atlético Salobreña Atlético 31 68 113 28
15 Zaidin Zaidin 31 52 110 21
16 C.D. Albolote Soccer Alda A C.D. 32 49 99 17
17 Club de Futbol Motril Club Futbol 31 49 132 8
TEMPORADA 2015/2016
2ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 Granada C.F. SAD C Granada C.F. 30 90 44 64
2 Huétor Vega CD Huétor Vega 30 76 37 63
3 C.D. Huetor Tajar A C.D. Huetor 30 60 35 59
4 Motril Motril 30 51 42 54
5 Loja C.D. Loja C.D. 30 87 66 52
6 Santa Fe B Juvenil Santa 30 62 54 50
7 Maracena B Maracena B 30 71 66 44
8 C.D. Churriana de la Vega C.D. 30 54 50 41
9 Arenas de Armilla B Arenas 30 66 66 40
10 Guadix C.F. Guadix C.F. 30 62 62 39
11 Ogíjares89 Ogíjares89 30 44 41 36
12 C.D. Albolote Soccer Alda A C.D. 30 52 66 36
13 Atlético Salobreña Atlético 30 46 90 26
14 Atletismo Padul Atletismo 30 55 81 25
15 Club de Futbol Motril Club Futbol 30 42 91 24
16 Celtic C.F. A Celtic C.F. 30 43 70 23
TEMPORADA 2014/2015
3ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 Maracena B Maracena B 30 110 25 80
2 Motril Motril 30 81 26 70
3 Atlético Salobreña Atlético 30 83 50 56
4 Atletismo Padul Atletismo 30 89 64 55
5 Zaidin Zaidin 30 83 52 50
6 Celtic B Celtic B 30 63 47 49
7 Vandalia de Peligros Vandalia 30 60 63 45
8 Estrellas Chana B Estrellas 30 66 77 40
9 Huetor Tajar B Huetor Tajar 30 59 70 37
10 Cp Granada 74 Granada 30 54 74 35
11 Iznalloz Iznalloz 30 39 76 34
12 Medina Lauxa Medina Lauxa 30 44 67 29
13 Barrio La Cruz Barrio Cruz 30 57 71 27
14 Atlético La Zubia A Atlético 30 39 67 25
15 Puerto de Motril Puerto 30 38 88 25
16 Parapanda 2010 Parapanda 30 42 90 23
TEMPORADA 2013/2014
2ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 Arenas de Armilla B Arenas 17 40 13 41
2 Puerto de Motril C.F Puerto 17 44 20 36
3 Celtic Pulianas Celtic 17 43 29 35
4 Estrellas Chana UD Estrellas 17 51 36 33
5 Huétor Vega CD Huétor Vega 17 40 26 33
6 Cp Granada 74 Granada 17 42 22 29
7 Ogíjares89 Ogíjares89 17 29 26 27
8 Santa Fe B Juvenil Santa 17 38 34 25
9 C.D. Baza C.D. Baza 16 35 30 24
10 C.D. Huetor Tajar A C.D. Huetor 17 35 38 22
11 Guadix Cf Guadix Cf 16 29 36 22
12 C.D. Churriana de la Vega C.D. 17 32 39 17
13 Atlético La Zubia A Atlético 17 19 49 14
14 Pinos Puente Pinos Puente 16 28 54 8
15 Atletismo Padul Atletismo 17 26 58 8
16 Maracena B Maracena B 16 22 43 7

  USO DE MEMORIA  
5,826,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1382
Total Execution Time  0.1395
  CADENA URL  
/historico/Maracena-B-Juvenil
  GET DATOS  
$_GET['/historico/Maracena-B-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 = 'Maracena-B-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.0031  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 = 'Maracena-B-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.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=25136 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=25136 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=25136 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=25136 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=25136 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=25136 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=25136 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=25136 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=25136 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=25136 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=25136 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 69713
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25136 AND type_rel = 2
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=753 AND type_rel = 3
0.0024  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 = '25136' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '25136' AND l.year = 2023 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 = '25136' 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 = 69713 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=25136 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 (69713,65912) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69713 AND teamId = 25136
0.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65912 AND teamId = 25136
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 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 = 69713 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '25136' 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 = '25136' and rp.type = 4
0.0023  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 = '25136' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028  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 = 25136 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 = 69713 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.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 `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 = 65912 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 = 59543 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.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 `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 = 53846 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.0030  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 = 45194 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 `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 = 39956 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 `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 = 34582 AND t.round = 34 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 `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 = 17032 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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 = 4855 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0051  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 = 3338 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 69713 ORDER BY nameShow LIMIT 100