4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UD Bellavista Sub 19
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 CD Mosquito Sub 19 Mosquito 26 57 17 63
2 CD Utrera Sub 19 Utrera 26 64 27 60
3 UP Viso Sub 19 Viso 27 55 29 56
4 San Roque Balompie Sub 19 B Roque 26 44 32 43
5 SAM-CAM Dos Hermanas Sub 19 SAM-CAM 26 42 38 41
6 Solea Sub 19 Solea 26 46 40 39
7 UD Bellavista Sub 19 Bellavista 26 32 28 37
8 AD Nervión Sub 19 Nervión 26 42 42 32
9 La Liara Balompié Sub 19 Liara 26 42 43 32
10 Osuna Bote Sub 19 Osuna Bote 26 43 53 32
11 Torreblanca CF Sub 19 Torreblanca 26 29 46 30
12 CD Cabecense Sub 19 Cabecense 26 33 47 29
13 UD Tomares Sub 19 Tomares 26 52 56 26
14 Atlético Antoniano Sub 19 Atlético 26 36 63 26
15 Juventud Gines Sub 19 Juventud 26 42 56 22
16 AD San José Sub 19 José 27 35 77 17
TEMPORADA 2022/2023
4ª ANDALUZA SEVILLA JUVENIL GRUPO 7
Equipo PJ GF GC Puntos
1 Einstein Pino Montano Einstein 24 87 18 64
2 Calavera CF B Calavera 24 72 37 52
3 CD Diablos Rojos Diablos 24 71 30 48
4 CD Demo CD Demo 24 55 37 44
5 UD Bellavista Sub 19 Bellavista 24 57 63 39
6 Manantial Manantial 24 53 37 36
7 Solea Sub 19 Solea 24 64 49 35
8 Colspe Colspe 24 59 51 35
9 Recreativo Alcosa Recreativo 24 50 49 32
10 Atlético Sumi Atlético 24 39 53 24
11 Portaceli CD Portaceli 24 29 61 24
12 Triana CF Triana CF 24 30 87 14
13 CD Isbiliya Balompie Isbiliya 24 17 111 2
14 San Pablo Pino Montano Pablo Pino. 0 0 0 0
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
4ª ANDALUZA SEVILLA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 Colegio Claret Colegio 26 152 24 75
2 Asoc Nervion Asoc Nervion 25 106 27 68
3 CD Doctor Fleming Doctor 26 82 32 58
4 Centro Histórico AAVV Centro 26 59 47 42
5 CD Almena CD Almena 26 58 65 40
6 Manantial Manantial 26 55 56 36
7 La Oliva AF La Oliva AF 26 64 54 34
8 Sporting Cerro Sporting 26 41 51 33
9 Atlético Algabeño Atlético 25 40 56 32
10 Solea A Solea A 26 43 47 29
11 Colspe Colspe 24 49 78 25
12 La Union del Porvenir Union 26 41 60 24
13 UD Bellavista Sub 19 Bellavista 26 44 86 22
14 Alcosa Recreativo CD Alcosa 26 18 169 0
TEMPORADA 2019/2020
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 C Atl. Antoniano Atl. 24 50 35 46
2 Sevilla FC SAD Sevilla 23 68 31 43
3 UD Tomares Sub 19 Tomares 24 51 25 43
4 Atletico Libertad Atletico 24 52 30 42
5 San Roque Balompie Sub 19 Roque 24 53 34 42
6 UD Bellavista Sub 19 Bellavista 24 39 35 42
7 Torreblanca CF Sub 19 Torreblanca 23 39 35 40
8 CD Utrera Sub 19 Utrera 23 51 25 39
9 CD Los Caminantes Caminantes 24 38 35 35
10 Centro Histórico AAVV Centro 23 51 40 34
11 CD Cabecense Sub 19 Cabecense 24 32 47 34
12 CD Mosquito Sub 19 Mosquito 23 44 42 33
13 CMD San Juan Juvenil Juan Juvenil 24 30 46 24
14 Calavera Sub 19 B Calavera 24 41 57 22
15 CD Asoc. Dva. Nervion Asoc. Dva.. 24 29 45 20
16 AD Pvo. Sevilla Este Pvo. Sevilla 23 21 54 10
17 CDAtletico Dos Hermanas CF CDAtletico 23 13 86 7
18 Ecija Balompie SAD Ecija 1 0 0 1
TEMPORADA 2018/2019
4ª ANDALUZA SEVILLA JUVENIL GRUPO 3
Equipo PJ GF GC Puntos
1 San Roque Balompie Sub 19 B Roque 28 111 36 68
2 Einstein Pino Montano Einstein 28 88 36 65
3 San Pablo Pino Montano Pablo Pino. 29 91 45 61
4 Atletico Los Puertos Atletico 29 79 40 61
5 Andalucía Este Andalucía 28 63 36 59
6 CD Demo CD Demo 29 62 40 59
7 UD Bellavista Sub 19 Bellavista 28 65 48 43
8 La Oliva AF La Oliva AF 20 49 36 39
9 Alcosa Recreativo CD Alcosa 29 59 54 37
10 Portaceli CD Portaceli 28 51 70 33
11 Colspe Colspe 29 52 105 23
12 Centro Histórico AAVV Centro 28 46 76 21
13 CD Almena CD Almena 28 42 93 19
14 Club Jorge Juan Antonio Ull Club Jorge. 18 23 49 16
15 La Union del Porvenir Union 29 42 94 15
16 Solea A Solea A 28 33 98 12
TEMPORADA 2017/2018
4ª ANDALUZA SEVILLA JUVENIL GRUPO 5
Equipo PJ GF GC Puntos
1 Triana C.F. Triana C.F. 27 78 43 60
2 Centro Histórico AAVV Centro 27 57 22 59
3 UD Bellavista Sub 19 Bellavista 28 86 45 58
4 San Roque Balompie Sub 19 B Roque 27 81 36 57
5 Einstein Pino Montano Einstein 28 60 45 55
6 Colegio Claret Colegio 27 66 52 42
7 La Hispalense Hispalense 27 40 45 37
8 Solea A Solea A 27 58 67 33
9 San Pablo Pino Montano A Pablo Pino. 27 43 76 33
10 Portaceli CD Portaceli 27 33 52 26
11 CD Almena CD Almena 27 34 71 23
12 An Andalis An Andalis 16 27 29 21
13 Alcosa Recreativo CD Alcosa 27 40 71 21
14 CD Demo CD Demo 26 54 68 18
15 Colspe Colspe 26 47 82 14
TEMPORADA 2016/2017
3ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Atletico Dos Hermanas Atletico 33 87 34 70
2 Calavera CF B Calavera 33 94 43 65
3 Marchena Balompie Marchena 33 106 63 65
4 CD Los Caminantes Caminantes 34 80 59 64
5 UD Bellavista Sub 19 Bellavista 33 96 48 62
6 La Motilla FC Motilla 34 96 70 59
7 CD Arahelense Arahelense 33 90 47 53
8 Portaceli CD Portaceli 33 76 53 52
9 La Liara Balompié Sub 19 Liara 33 71 66 51
10 AD Cerro del Águila Cerro 33 69 60 49
11 AD San José Sub 19 José 33 64 71 42
12 Utrera CD Utrera CD 33 74 88 42
13 Osuna Bote Sub 19 Osuna Bote 33 71 93 36
14 Club Jorge Juan Antonio Ull Club Jorge. 33 61 67 33
15 C.D. Pedrera C.D. Pedrera 33 44 101 27
16 Guadalcanal CD Guadalcanal 34 60 132 26
17 Atlético Porvenir Atlético 20 36 47 21
18 CD Demo CD Demo 33 37 170 7
TEMPORADA 2015/2016
4ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Porvenir Atlético 24 112 17 62
2 Vistahermosa CF Vistahermosa 24 85 28 61
3 Escritor Alfonso Grosso Escritor 24 54 41 47
4 CD San Jerónimo Jerónimo 24 67 40 44
5 CD Einstein CD Einstein 24 38 35 39
6 Su Eminencia Rvo. Eminencia 24 54 45 39
7 UD Soleá UD Soleá 24 46 31 37
8 UD Pino Montano Pino Montano 24 54 49 34
9 Ciudad Jardin CF Ciudad 24 41 72 30
10 Alcosa Recreativo CD Alcosa 24 43 60 28
11 UD Bellavista Sub 19 Bellavista 24 23 60 14
12 CD Almena CD Almena 24 27 100 8
13 AD Cerro del Águila Cerro 24 17 83 3
14 Arquero Los Remedios CD Arquero 0 0 0 0
15 Triana C.F. Triana C.F. 0 0 0 0
TEMPORADA 2014/2015
4ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Club Jorge Juan Antonio Ull Club Jorge. 28 83 32 65
2 CD Demo CD Demo 27 84 36 63
3 Adp Sevilla Este Sevilla Este 26 70 23 59
4 UD Soleá UD Soleá 27 69 49 50
5 UD Pino Montano Pino Montano 26 51 61 42
6 CD Einstein CD Einstein 27 42 50 41
7 CD San Jerónimo Jerónimo 27 54 40 40
8 UD Bellavista Sub 19 Bellavista 26 53 50 34
9 Ciudad Jardin CF Ciudad 26 47 57 33
10 Circulo Civico C. Palmete Circulo 27 56 66 32
11 Vistahermosa CF Vistahermosa 27 59 81 32
12 CD Almena CD Almena 27 50 69 22
13 AD Cerro del Águila Cerro 18 35 54 18
14 Alcosa Recreativo CD Alcosa 26 48 88 16
15 CD Montequinto B Montequinto 21 26 71 10
16 Triana Balompié Triana 0 0 0 0

  USO DE MEMORIA  
5,771,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1396
Total Execution Time  0.1410
  CADENA URL  
/historico/Ud-Bellavista-Juvenil
  GET DATOS  
$_GET['/historico/Ud-Bellavista-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0037  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-Bellavista-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.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=19621 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=19621 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0044  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 = 73834
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19621 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 19621 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (185377) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '19621' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '19621' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '19621' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 73834 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=19621 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73834,69889) 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_base WHERE league_id = 73834 AND teamId = 19621
0.0022  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69889 AND teamId = 19621
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 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 = 73834 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '19621' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19621' 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 = '19621' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 19621 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0035  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_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 = 73834 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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.0031  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 = 69889 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 64709 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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.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 `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 = 59547 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.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 `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 = 60422 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 53858 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.0027  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 = 45803 AND t.round = 34 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 `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.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 `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 = 39989 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 40035 AND t.round = 30 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 = 34583 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 = 34226 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 17059 AND t.round = 30 ORDER BY team.conference 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 `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 = 4283 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC