4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Andalucía Este
TEMPORADA 2022/2023
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 Calavera Sub 19 B Calavera 30 85 27 67
2 SAM-CAM Dos Hermanas Sub 19 SAM-CAM 30 64 28 64
3 Torreblanca CF Sub 19 Torreblanca 30 55 29 61
4 Osuna Bote Sub 19 Osuna Bote 30 65 48 53
5 CD Mosquito Sub 19 Mosquito 30 55 41 52
6 CD Cabecense Sub 19 Cabecense 30 52 40 51
7 San Roque Balompie Sub 19 B Roque 30 55 47 51
8 UD Bellavista Sub 19 Bellavista 30 47 41 50
9 UD Tomares Sub 19 Tomares 30 46 45 42
10 Juventud Gines Sub 19 Juventud 30 42 47 42
11 PD Rociera Sub 19 Rociera 30 50 52 38
12 Andalucía Este Andalucía 30 46 72 30
13 Camas CF Camas CF 30 43 77 26
14 Lora CF Lora CF 30 32 64 20
15 Coria CF B Coria CF B 30 30 55 19
16 Castilleja CF B Castilleja 30 26 80 11
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 CD Utrera Sub 19 Utrera 34 97 40 72
2 UD Tomares Sub 19 Tomares 34 75 36 72
3 CD Cabecense Sub 19 Cabecense 34 73 37 71
4 CD Los Caminantes Caminantes 34 73 47 64
5 CD Mosquito Sub 19 Mosquito 34 77 58 61
6 San Roque Balompie Sub 19 B Roque 34 60 42 58
7 Castilleja CF B Castilleja 34 79 59 50
8 UD Bellavista Sub 19 Bellavista 34 63 56 50
9 Coria CF B Coria CF B 34 59 52 47
10 Lora CF Lora CF 34 62 61 47
11 Torreblanca CF Sub 19 Torreblanca 34 48 61 42
12 Andalucía Este Andalucía 34 38 55 41
13 CMD San Juan Juvenil Juan Juvenil 34 41 63 38
14 Estrella San Agustín Estrella 34 44 76 36
15 U.D. Moron C.F. U.D. Moron. 34 52 69 34
16 CD Asoc. Dva. Nervion Asoc. Dva.. 34 57 76 33
17 Los Palacios CF Palacios 34 45 86 30
18 Atletico Libertad Atletico 34 31 100 11
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 San Roque Balompie Sub 19 Roque 7 12 5 17
2 U.D. Moron C.F. U.D. Moron. 8 23 9 16
3 CD Mosquito Sub 19 Mosquito 7 21 7 16
4 CD Asoc. Dva. Nervion Asoc. Dva.. 8 18 11 16
5 Andalucía Este Andalucía 8 12 15 11
6 Centro Histórico AAVV Centro 8 13 19 10
7 Torreblanca CF Sub 19 Torreblanca 8 8 9 9
8 CD Utrera Sub 19 Utrera 8 15 14 8
9 Calavera Sub 19 B Calavera 8 10 15 7
10 Ecija Balompie SAD Ecija 8 6 34 0
TEMPORADA 2019/2020
4ª ANDALUZA SEVILLA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Sevilla 3000 Sevilla 3000 22 83 22 57
2 Andalucía Este Andalucía 21 77 33 52
3 Vista Hermosa CF Vista 21 70 30 48
4 Portaceli CD Portaceli 22 51 41 40
5 Alcosa Recreativo CD Alcosa 21 56 50 38
6 CD Diablos Rojos Diablos 21 46 37 35
7 Triana A Triana A 21 56 40 33
8 Colspe Colspe 22 53 50 33
9 Polideportivo Alcosa Polideportiv 22 45 35 32
10 Einstein Pino Montano Einstein 22 38 59 23
11 Solea A Solea A 22 42 64 23
12 CD Demo CD Demo 21 31 55 21
13 CD Almena CD Almena 22 24 68 13
14 Colegio El Vedat A Colegio 21 36 72 10
15 San Pablo Pino Montano A Pablo Pino. 21 26 78 2
TEMPORADA 2018/2019
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 Sevilla FC Juvenil C Sevilla 34 118 23 93
2 PD Rociera Sub 19 Rociera 34 92 36 82
3 C.D. Utrera C.D. Utrera 34 81 22 72
4 Ecija Balompie SAD Ecija 34 59 42 56
5 CD Mosquito Sub 19 Mosquito 34 71 70 53
6 CD Los Caminantes Caminantes 34 62 55 50
7 UD Dos Hermanas Juvenil Hermanas 34 48 60 49
8 San Roque Balompie Sub 19 Roque 34 52 56 46
9 UD Tomares Sub 19 Tomares 34 61 63 45
10 Atlético Antoniano Sub 19 Atlético 34 55 56 43
11 Calavera Sub 19 B Calavera 34 50 54 42
12 Centro Histórico AAVV Centro 34 54 63 41
13 AD Nervión Sub 19 Nervión 34 49 62 40
14 CMD San Juan Juvenil Juan Juvenil 34 42 60 36
15 Andalucía Este Andalucía 34 36 63 36
16 Círculo Don Bosco Círculo 34 28 57 31
17 Tor del Rey de Pilas Pilas 34 41 78 29
18 Marchena Balompie Marchena 34 22 101 18
TEMPORADA 2017/2018
4ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 UP Viso Sub 19 Viso 21 111 23 55
2 El Tinte de Utera Tinte Utera 22 97 27 52
3 Solea B Solea B 21 60 22 51
4 CD Mosquito Sub 19 Mosquito 24 73 40 48
5 Carmona AD Carmona AD 25 79 53 41
6 Atletico Oromana Atletico 23 59 40 36
7 Andalucía Este Andalucía 23 59 41 31
8 La Oliva AF La Oliva AF 23 58 61 31
9 Los Puertos Atletico Puertos 23 44 39 30
10 Peña Bética Alcalá Peña 23 34 44 26
11 Club Jorge Juan Antonio Ull Club Jorge. 23 43 54 23
12 La Barrera CF Barrera 24 33 89 9
13 An Andalis B Andalis 4 3 28 3
14 Recreativo Alcosa Recreativo 25 13 205 0
TEMPORADA 2016/2017
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 Calavera CF Sub 19 Calavera 34 105 29 84
2 Sevilla Sub 19 B Sevilla 34 105 31 78
3 Ecija Balompie SAD Ecija 34 77 34 77
4 Centro Histórico AAVV Centro 34 69 44 58
5 ADP Sevilla Este B Juvenil Sevilla Este 34 65 48 52
6 AD Nervión Sub 19 Nervión 34 63 54 50
7 Andalucía Este Andalucía 34 64 53 48
8 Puebla de Cazalla Puebla 34 83 87 48
9 CD Mosquito Sub 19 Mosquito 34 74 70 47
10 CD Cabecense Sub 19 Cabecense 34 60 91 45
11 C.D. Utrera C.D. Utrera 34 73 81 44
12 Círculo Don Bosco Círculo 34 57 62 42
13 Atlético Antoniano Sub 19 Atlético 34 66 89 39
14 U.D. Moron C.F. U.D. Moron. 34 55 72 38
15 Torreblanca CF Sub 19 Torreblanca 34 57 77 38
16 Puebla CF Puebla CF 34 47 81 33
17 Mairena Aljarafe U.D Mairena 34 55 97 28
18 C.D. Mairena C.D. Mairena 34 39 114 11
TEMPORADA 2015/2016
3ª ANDALUZA SEVILLA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Andalucía Este Andalucía 32 105 32 82
2 Puebla de Cazalla Puebla 32 137 63 71
3 Club Jorge Juan Antonio Ull Club Jorge. 32 75 44 55
4 Ecija Balompie SAD Ecija 32 60 46 54
5 Portaceli CD Portaceli 32 73 55 52
6 Campana Balompie Campana 32 57 67 47
7 Diablos Rojos CD Diablos 32 63 49 46
8 Circulo Don Bosco Circulo 32 63 63 44
9 Utrera CD Utrera CD 32 75 72 43
10 San Roque Balompie Sub 19 Roque 32 55 55 40
11 CF Torreblanca Torreblanca 32 45 78 40
12 C.D. Pedrera C.D. Pedrera 31 47 56 39
13 Osuna BC Osuna BC 32 48 70 37
14 Marchena Balompie Marchena 32 66 79 37
15 CD Mosquito Sub 19 Mosquito 31 52 87 28
16 AD Nervión B Juvenil Nervión 32 55 93 25
17 La Oliva AF La Oliva AF 32 37 104 23
18 Montellano CD Montellano 0 0 0 0
TEMPORADA 2014/2015
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 Sevilla Sub 19 B Sevilla 34 92 24 84
2 UD Tomares Sub 19 Tomares 34 101 49 76
3 C.D. Utrera C.D. Utrera 34 88 43 75
4 C.D. Mairena C.D. Mairena 34 73 45 62
5 ADP Sevilla Este B Juvenil Sevilla Este 34 70 55 57
6 AD Nervión Sub 19 Nervión 34 74 65 56
7 Centro Histórico B Centro 34 65 66 54
8 Círculo Don Bosco Círculo 34 62 59 47
9 Écija Balompié Écija 34 49 56 44
10 Coria CF B Coria CF B 34 46 49 42
11 CD Mosquito Sub 19 Mosquito 34 53 65 42
12 CD Cabecense Sub 19 Cabecense 34 58 59 41
13 U.P Viso U.P Viso 34 49 58 35
14 Puebla CF Puebla CF 34 36 53 34
15 Andalucía Este Andalucía 34 43 66 32
16 Mairena Aljarafe U.D Mairena 34 45 65 30
17 Atlético Antoniano Sub 19 Atlético 34 37 79 20
18 C.D. Pedrera C.D. Pedrera 34 29 114 14
TEMPORADA 2013/2014
2ª ANDALUZA SEVILLA CADETE
Equipo PJ GF GC Puntos
1 Real Betis C Real Betis 30 88 30 68
2 Sevilla FC Sub 16 B Sevilla 30 82 30 65
3 Nervión Cadete Nervión 30 67 24 65
4 Atletico Dos Hermanas Atletico 30 62 42 57
5 Centro Histórico B Centro 30 74 47 54
6 Círculo Don Bosco Círculo 30 55 43 52
7 Tomares Tomares 30 55 51 47
8 Calavera C.F Calavera 30 53 49 43
9 Andalucía Este Andalucía 30 49 52 43
10 Peloteros Sierra Sur B Peloteros 30 58 60 42
11 Écija Balompié Écija 30 64 55 39
12 Villanueva Atletico Villanueva 30 56 56 37
13 UD Bellavista B Bellavista 30 32 81 24
14 Sevilla Este Cadete Sevilla Este 30 44 66 16
15 Atlético Antoniano Sub 19 Atlético 30 34 105 14
16 Cerro Águila Cerro 30 27 109 14

  USO DE MEMORIA  
5,831,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  3.4626
Total Execution Time  3.4638
  CADENA URL  
/historico/Andalucia-Este
  GET DATOS  
$_GET['/historico/Andalucia-Este']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.1092  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 = 'Andalucia-Este' 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.2922  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 = 'Andalucia-Este' 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=14504 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=14504 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=14504 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=14504 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=14504 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=14504 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=14504 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=14504 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=14504 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=14504 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=14504 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=14504 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=14504 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14504 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=437 AND type_rel = 3
0.1736  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 = '14504' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.2310  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 = '14504' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.2093  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=14504 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0076  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 (68953) 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.0076  SELECT count(id) as num_players from rel_players_base WHERE league_id = 68953 AND teamId = 14504
0.0204  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 = '14504' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0242  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '14504' and rp.type = 4
0.0397  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 = '14504' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0979  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 = 14504 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.1195  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 = 68953 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.1993  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 = 64947 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.1985  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 = 59548 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1593  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 = 51990 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.1211  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 = 45821 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1184  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 = 45692 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1657  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 = 39945 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1682  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 = 40031 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1965  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 = 34211 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2511  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 = 17034 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2772  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 = 4225 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2105  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 = 3047 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC