4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Montellano CD
TEMPORADA 2023/2024
3ª ANDALUZA SEVILLA GRUPO 5
Equipo PJ GF GC Puntos
1 Cuervo Deportivo Cuervo 24 54 22 51
2 Dos Hermanas 1971 CF Hermanas 23 58 20 51
3 CD Coronil CD Coronil 24 57 23 50
4 Atlético Maribáñez Atlético 25 43 24 50
5 Ibarburu CF Ibarburu CF 24 44 30 43
6 Peña Betica Alcalá Peña Betica 24 44 29 41
7 Cabecense B Cabecense B 24 55 31 40
8 Los Palacios CF Palacios 24 47 42 34
9 Atl. Antoniano B Atl. 24 50 61 32
10 Montellano CD Montellano 24 35 46 26
11 CD Cantely CD Cantely 24 45 48 25
12 Mosquito CD Mosquito CD 25 38 48 22
13 CD Marismillas Marismillas 25 32 62 18
14 C.D. Rabesa C.D. Rabesa 24 35 69 14
15 El Trobal UD Trobal 0 0 0 0
16 Pinzon 09 Pinzon 09 20 11 93 0
TEMPORADA 2022/2023
3ª ANDALUZA SEVILLA GRUPO 5
Equipo PJ GF GC Puntos
1 UD Dos Hermanas Hermanas 30 97 26 74
2 El Tinte de Utrera Tinte Utrera 30 89 34 72
3 Fuente del Rey Fuente 30 89 38 64
4 Atlético Maribáñez Atlético 30 62 32 60
5 Atl. Antoniano B Atl. 30 70 50 57
6 Montellano CD Montellano 30 63 39 53
7 Cuervo Deportivo Cuervo 30 55 43 52
8 Ibarburu CF Ibarburu CF 30 49 44 47
9 Cabecense B Cabecense B 30 60 55 41
10 CD Cantely CD Cantely 30 54 54 40
11 Cantera de Utrera Cantera 30 61 72 35
12 UB Lebrijana B Lebrijana 30 44 61 29
13 El Trobal UD Trobal 30 31 84 23
14 Los Palacios CF Palacios 30 33 63 20
15 Union de los Morales Union 30 39 83 6
16 Pinzon 09 Pinzon 09 30 15 133 0
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Demo CD Demo 32 73 23 71
2 Montequinto CD Montequinto 32 75 36 70
3 Arahal Arahal 32 61 33 65
4 Puebla Cazalla CF Puebla 32 64 40 60
5 Andalucia Este CF Andalucia 31 53 46 53
6 Calavera Calavera 32 49 40 50
7 CD Diablos Rojos Diablos 31 42 32 43
8 Marchena Balompié Marchena 32 53 56 43
9 Atletico Viso Atletico 31 42 44 42
10 Pablo VI Pablo VI 32 61 74 42
11 Colegio Claret Colegio 32 59 67 40
12 Montellano CD Montellano 32 33 44 39
13 San Roque Balompié Roque 31 52 60 36
14 Badolatosa CF Badolatosa 31 54 68 36
15 El Tinte de Utrera Tinte Utrera 31 39 62 29
16 Atl. Antoniano B Atl. 31 41 85 18
17 Nervión Nervión 25 23 64 12
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA GRUPO 7
Equipo PJ GF GC Puntos
1 San Pablo Pino Montano Pablo Pino. 28 52 32 50
2 Utrera B Utrera B 26 51 32 49
3 CD Diablos Rojos Diablos 28 48 32 48
4 Andalucia Este CF Andalucia 28 52 41 48
5 El Tinte de Utrera Tinte Utrera 26 44 36 41
6 Montequinto CD Montequinto 28 39 40 40
7 Nervión Nervión 27 44 36 39
8 Montellano CD Montellano 26 16 25 31
9 Puebla Cazalla CF Puebla 26 44 46 29
10 Arahal Arahal 25 30 39 27
TEMPORADA 2019/2020
2ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Club Atl. Central Club Atl. C. 25 59 31 58
2 CD Demo CD Demo 25 64 28 57
3 Nervión Nervión 25 53 27 52
4 CDF Herrera CDF Herrera 25 49 26 45
5 Montequinto CD Montequinto 25 34 32 41
6 Utrera B Utrera B 25 45 34 40
7 Montellano CD Montellano 25 30 33 39
8 Badolatosa CF Badolatosa 25 40 34 38
9 San Pablo Pino Montano Pablo Pino. 25 39 28 37
10 San Roque Balompié Roque 25 43 43 36
11 CD Diablos Rojos Diablos 25 37 36 33
12 Arahal Arahal 25 37 39 33
13 El Tinte de Utrera Tinte Utrera 25 41 62 29
14 CD San Marcos Marcos 25 34 49 23
15 Ecija CF Ecija CF 25 21 44 20
16 El Rubio El Rubio 25 22 45 19
17 Andalucia Este CF Andalucia 25 23 49 17
18 Triana CF Triana CF 25 25 56 17
TEMPORADA 2018/2019
2ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 Ventippo Ventippo 34 72 31 79
2 At. Dos Hermanas Hermanas 34 68 30 72
3 CDF Herrera CDF Herrera 34 77 50 65
4 Utrera B Utrera B 34 59 43 61
5 Nervión Nervión 34 62 40 50
6 Badolatosa CF Badolatosa 34 73 65 50
7 Ecija CF Ecija CF 34 54 47 50
8 El Rubio El Rubio 34 55 55 48
9 Andalucia Este CF Andalucia 34 60 59 45
10 San Pablo Pino Montano Pablo Pino. 34 57 56 45
11 El Tinte de Utrera Tinte Utrera 34 56 67 45
12 Montellano CD Montellano 34 49 46 44
13 CD Diablos Rojos Diablos 34 41 41 44
14 Triana CF Triana CF 34 38 49 41
15 Ciudad Jardin Ciudad 34 42 62 41
16 Marchena Balompié Marchena 34 46 81 29
17 Calavera Calavera 34 39 67 27
18 UD Morón B UD Morón B 34 37 96 25
TEMPORADA 2017/2018
3ª ANDALUZA SEVILLA GRUPO 3
Equipo PJ GF GC Puntos
1 El Tinte de Utrera Tinte Utrera 29 88 46 62
2 Montellano CD Montellano 29 64 22 59
3 Huévar C.F. Huévar C.F. 29 79 44 54
4 Mairena del Aljarafe Mairena 29 74 58 50
5 Montequinto CD Montequinto 28 61 39 49
6 Atlético Maribáñez Atlético 28 46 31 48
7 Santiponce Santiponce 28 48 45 45
8 La Motilla La Motilla 27 51 47 40
9 Pilas Atlético Pilas 27 45 47 36
10 Colegio Claret Colegio 28 39 39 35
11 Gelves C.D Gelves C.D 29 52 64 35
12 UB Lebrijana B Lebrijana 29 49 63 35
13 Palomares Palomares 27 44 72 26
14 C.D. Rabesa C.D. Rabesa 28 42 82 19
15 UD Dos Hermanas Hermanas 29 35 93 16
16 El Palmar Vereda Real Palmar 10 7 32 1
TEMPORADA 2016/2017
2ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Coronil CD Coronil 34 78 36 74
2 UD Morón UD Morón 34 75 35 67
3 Mosqueo Mosqueo 34 78 48 63
4 C.D. Arahelense C.D. 34 72 50 62
5 Espartinas CF Espartinas 34 68 58 62
6 Marchena Balompié Marchena 34 71 54 51
7 Paradas Balompié Paradas 34 90 64 50
8 Atlético Sanlucar Atlético 34 66 68 49
9 Olivarense Olivarense 34 69 63 48
10 Atlético Libertad Atlético 33 65 60 47
11 Benacazón CF Benacazón 34 60 61 46
12 Triana CF Triana CF 34 63 74 41
13 AD. Carmona AD. Carmona 34 47 69 37
14 Camino Viejo Camino Viejo 33 51 75 37
15 Huévar C.F. Huévar C.F. 34 45 82 32
16 Montellano CD Montellano 34 42 68 29
17 Círculo Don Bosco Círculo 34 49 78 29
18 Pilas Atlético Pilas 32 25 71 26
TEMPORADA 2015/2016
3ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 UD Bellavista Bellavista 32 76 33 67
2 C.D. Arahelense C.D. 33 65 39 61
3 Triana CF Triana CF 33 58 38 60
4 CDF Herrera CDF Herrera 33 66 37 59
5 Marchena Balompié Marchena 33 57 37 57
6 CD Antonio Puerta B Antonio 34 80 68 54
7 La Jara La Jara 33 63 57 53
8 El Rubio El Rubio 34 52 41 52
9 San Jeronimo Jeronimo 33 56 45 51
10 Campana Balompié Campana 32 56 46 49
11 Andalucia Este CF Andalucia 31 51 44 43
12 CD Demo CD Demo 34 48 64 40
13 Montellano CD Montellano 32 33 57 34
14 Círculo Don Bosco Círculo 33 36 62 32
15 Atletico Viso Atletico 34 40 59 28
16 An Andalis An Andalis 21 32 47 27
17 Los Corrales Corrales 30 40 74 27
18 Su Eminencia Eminencia 31 27 88 14
TEMPORADA 2014/2015
3ª ANDALUZA SEVILLA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Diablos Rojos Diablos 30 68 26 59
2 Ciudad Jardin Ciudad 30 63 32 59
3 Gilena C.F. Gilena C.F. 30 66 37 58
4 Montellano CD Montellano 30 51 38 55
5 CDF Herrera CDF Herrera 30 57 41 52
6 Andalucia Este CF Andalucia 30 58 37 48
7 La Jara La Jara 30 58 48 47
8 San Jeronimo Jeronimo 30 49 45 46
9 Campana Balompié Campana 30 57 49 44
10 Marchena Balompié Marchena 30 43 39 43
11 Los Corrales Corrales 30 52 48 41
12 Su Eminencia Eminencia 30 43 41 38
13 Círculo Don Bosco Círculo 30 59 64 34
14 Pino Montano Pino Montano 30 34 53 33
15 CD Demo CD Demo 30 37 56 31
16 Calavera Calavera 30 33 63 21
17 Ventippo Ventippo 30 38 86 20
18 Fuente del Rey Fuente 30 21 84 13
TEMPORADA 2013/2014
3ª ANDALUZA SEVILLA GRUPO 1
Equipo PJ GF GC Puntos
1 Marchena Balompié Marchena 30 87 18 73
2 Montellano CD Montellano 30 86 22 71
3 La Jara La Jara 30 76 25 68
4 C.D. Arahelense C.D. 30 81 31 66
5 CD Alcalá B Alcalá 30 69 30 57
6 El Rubio El Rubio 30 63 40 54
7 La Roda La Roda 30 52 30 50
8 Estepa Industrial Estepa 30 60 50 45
9 Lantejuela C.D. Lantejuela 30 56 59 41
10 La Barrera La Barrera 30 45 68 34
11 Villanueva S.Juan Villanueva 30 42 68 28
12 C.D. Rabesa C.D. Rabesa 30 44 80 25
13 Coripe C.F. Coripe C.F. 30 50 119 23
14 UD Morón UD Morón 30 42 78 23
15 Poli Aguadulce Poli 30 38 66 22
16 San Marcos Saucejo Marcos 30 7 114 4
TEMPORADA 2012/2013
3ª ANDALUZA SEVILLA GRUPO 1
Equipo PJ GF GC Puntos
1 Gilena C.F. Gilena C.F. 28 77 35 60
2 Badolatosa CF Badolatosa 28 89 43 59
3 UD Marinaleda Marinaleda 28 61 29 57
4 El Rubio El Rubio 28 71 33 54
5 Aljaraque CD Aljaraque 28 54 35 50
6 La Roda La Roda 28 45 33 47
7 Montellano CD Montellano 28 50 41 46
8 Santa María Santa María 28 59 50 40
9 Atletico Marchena Atletico 28 34 32 40
10 Villanueva S.Juan Villanueva 28 44 60 36
11 Aguadulce C.F. Aguadulce 28 29 55 33
12 C.D. Mosquito C.D. 28 56 55 31
13 Lantejuela C.D. Lantejuela 28 26 50 25
14 Carmonense Carmonense 28 26 101 12
15 Coripe C.F. Coripe C.F. 28 41 110 5

  USO DE MEMORIA  
6,231,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5357
Total Execution Time  0.5370
  CADENA URL  
/historico/Montellano-C-D
  GET DATOS  
$_GET['/historico/Montellano-C-D']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0138  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 = 'Montellano-C-D' 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.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=14141 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=14141 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0274  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 = 73752
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14141 AND type_rel = 2
0.0131  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 = '14141' ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '14141' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0144  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 = '14141' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = 73752 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=14141 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (73752) 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 WHERE league_id = 73752 AND teamId = 14141
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 = '14141' 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 = '14141' and rp.type = 4
0.0136  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 = '14141' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0130  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 = 73752 WHERE rp.league_id = 73752 AND rp.teamId = 14141 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.0129  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 = 73752 WHERE rp.league_id = 73752 AND rp.teamId = 14141 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 73752 WHERE rp.league_id = 73752 AND rp.teamId = 14141 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 14141 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73752 AND t.round = 27 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 `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 = 69281 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.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 `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 = 64460 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` 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 = 59510 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.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 `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 = 61885 AND t.round = 10 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 `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 = 51360 AND t.round = 25 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 `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 = 44924 AND t.round = 34 ORDER BY team.conference 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 `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 = 39835 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 `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 = 34431 AND t.round = 34 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` 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 = 16851 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 4111 AND t.round = 30 ORDER BY team.conference 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 `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 = 3344 AND t.round = 30 ORDER BY team.conference 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 `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 = 3002 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC