4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UD Sanse Sub 19

UD Sanse Sub 19

Entrenador: Álvaro González

Temporada 2023/2024
TEMPORADA 2023/2024
DIVISIÓN DE HONOR GRUPO 5
Equipo PJ GF GC Puntos
1 Atlético Sub 19 Atlético 28 75 15 72
2 Real Madrid Sub 19 Real Madrid 28 74 25 65
3 Leganés Sub 19 Leganés 28 54 31 57
4 Rayo Majadahonda Sub 19 Rayo 28 30 22 52
5 Rayo Vallecano Sub 19 Rayo 28 44 29 49
6 Getafe Sub 19 Getafe 28 44 30 45
7 Rayo CI Alcobendas Sub 19 Rayo 28 38 30 45
8 Valladolid Sub 19 Valladolid 28 40 38 42
9 La Cruz Villanovense Sub 19 Cruz 28 35 35 36
10 Unión Adarve Sub 19 Unión 28 37 49 29
11 UD Sanse Sub 19 Sanse 28 27 46 23
12 Fuenlabrada Sub 19 Fuenlabrada 28 33 61 23
13 Alcorcón Sub 19 Alcorcón 28 22 45 23
14 Numancia Sub 19 Numancia 28 32 58 22
15 CDI Amistad Sub 19 Amistad 28 30 60 18
16 Mérida AD Sub 19 Mérida 28 30 71 18
TEMPORADA 2022/2023
LIGA NACIONAL GRUPO 12
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 B Real Madrid 34 94 17 84
2 Atlético Sub 19 B Atlético 34 82 44 69
3 Unión Adarve Sub 19 Unión 34 72 48 69
4 Getafe Sub 19 B Getafe 34 48 31 60
5 Leganés Sub 19 B Leganés 34 77 55 57
6 Rayo Vallecano Sub 19 B Rayo 34 50 40 55
7 UD Sanse Sub 19 Sanse 34 44 37 55
8 Las Rozas CF Sub 19 Rozas 34 47 48 54
9 Atlético Madrileño Sub 19 B Atlético 34 44 38 50
10 Fuenlabrada Sub 19 B Fuenlabrada 34 47 55 44
11 ED Moratalaz Sub 19 Moratalaz 34 40 38 38
12 Complutense Alcalá Sub 19 Complutense 34 41 56 37
13 Atlético de Pinto Sub 19 Atlético 34 42 66 37
14 CD Móstoles Sub 19 Móstoles 34 47 59 37
15 Trival Valderas Sub 19 Trival 34 40 65 32
16 Torrejón Sub 19 Torrejón 34 39 62 30
17 Aravaca Sub 19 Aravaca 34 37 80 23
18 Boadilla Sub 19 Boadilla 34 24 76 15
TEMPORADA 2021/2022
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 34 129 20 93
2 ED Moratalaz Sub 19 Moratalaz 34 75 38 65
3 Complutense Alcalá Sub 19 Complutense 34 72 45 62
4 Fundacion Alcala Fundacion 34 63 53 58
5 Rayo Mjdh. Sub 19 C Rayo Mjdh. 34 64 51 55
6 Rayo Vallecano Sub 19 C Rayo 34 71 59 53
7 Santa Ana Sub 19 Santa 34 61 65 51
8 Villaviciosa de Odón A Villaviciosa 34 71 77 50
9 Chopera Alcobendas Sub 19 Chopera 34 61 49 48
10 San Fernando B Fernando 34 59 56 48
11 Villanueva del Pardillo A Villanueva 34 52 59 46
12 Nuevo Boadilla Sub 19 Nuevo 34 70 72 43
13 Canillas Sub 19 Canillas 34 57 80 38
14 UD Sanse Sub 19 Sanse 34 50 81 38
15 CD Móstoles C Móstoles 34 53 72 36
16 Unión Adarve C Unión 34 38 71 31
17 Alcobendas Sub 19 Alcobendas 34 30 67 24
18 Aluche B Aluche B 34 40 101 23
TEMPORADA 2020/2021
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 19 94 9 57
2 Unión Adarve Sub 19 B Unión 19 31 20 41
3 Sporting Hortaleza Sub 19 Sporting 19 52 25 40
4 Santa Ana Sub 19 Santa 19 55 44 34
5 Villanueva del Pardillo A Villanueva 19 28 22 30
6 Chamartín Vergara A Chamartín 19 33 28 30
7 Chopera Alcobendas Sub 19 Chopera 19 33 36 30
8 Alcalá B Alcalá B 19 28 35 30
9 UD Sanse Sub 19 Sanse 19 32 34 29
10 Canillas B Canillas B 19 29 30 26
11 Complutense Alcalá Sub 19 Complutense 19 36 44 26
12 Nuevo Boadilla Sub 19 Nuevo 19 39 38 24
13 Moratalaz Sub 19 B Moratalaz 19 32 30 23
14 Aravaca B Aravaca B 19 28 36 23
15 Union Zona Norte A Union Zona. 19 30 38 21
16 San Roque EFF Roque 19 25 44 21
17 Siete Picos Colmenar A Siete Picos 19 32 43 20
18 Torrejon B Torrejon B 19 27 62 16
19 CF Pozuelo A Pozuelo 19 20 33 15
20 Collado Villalba A Collado 19 24 57 11
TEMPORADA 2019/2020
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 23 108 15 64
2 Rayo Vallecano Sub 19 C Rayo 23 82 26 61
3 Las Rozas CF Sub 19 Rozas 23 51 36 40
4 Alcalá B Alcalá B 23 44 38 39
5 Fuenlabrada Sub 19 B Fuenlabrada 23 40 23 36
6 Nuevo Boadilla Sub 19 Nuevo 23 47 40 36
7 Aravaca B Aravaca B 23 38 56 33
8 Canillas B Canillas B 23 37 38 32
9 Unión Adarve Sub 19 B Unión 23 33 45 32
10 Siete Picos Colmenar A Siete Picos 23 33 42 29
11 Villanueva del Pardillo A Villanueva 23 35 41 28
12 UD Sanse Sub 19 Sanse 23 42 52 27
13 Santa Ana Sub 19 Santa 23 46 60 26
14 Union Zona Norte A Union Zona. 23 38 58 24
15 CF Pozuelo A Pozuelo 23 31 56 24
16 Complutense Alcalá Sub 19 Complutense 23 31 40 19
17 Chopera Alcobendas Sub 19 Chopera 23 30 57 17
18 Collado Villalba A Collado 23 28 71 11
TEMPORADA 2018/2019
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 34 157 26 95
2 Trival Valderas Alcorcón B Trival 34 98 42 76
3 Rayo CI Alcobendas Sub 19 Rayo 34 69 35 68
4 Torrejón Sub 19 Torrejón 34 97 59 63
5 Las Rozas CF Sub 19 Rozas 34 67 53 57
6 Complutense Alcalá Sub 19 Complutense 34 72 66 52
7 UD Sanse Sub 19 Sanse 34 57 70 50
8 Alcalá B Alcalá B 34 66 70 49
9 Union Zona Norte A Union Zona. 34 62 59 46
10 Santa Ana Sub 19 Santa 34 53 67 44
11 Aravaca B Aravaca B 34 50 63 43
12 Collado Villalba A Collado 34 43 52 41
13 Siete Picos Colmenar A Siete Picos 34 53 92 39
14 Moratalaz Sub 19 B Moratalaz 34 50 88 38
15 Escuela Futbol Concepcion A Escuela 34 55 75 36
16 Fundacion Recuerdo Fundacion 34 55 91 29
17 Colmenar Viejo A Colmenar 34 35 84 22
18 Barrio Pilar A Barrio Pilar 34 34 81 20
TEMPORADA 2017/2018
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 34 105 25 91
2 Rayo Majadahonda Sub 19 B Rayo 34 74 33 72
3 Unión Adarve Sub 19 B Unión 34 78 36 66
4 Collado Villalba A Collado 34 64 47 59
5 CF Pozuelo A Pozuelo 34 65 53 56
6 Barrio Pilar A Barrio Pilar 34 55 40 54
7 Rayo CI Alcobendas Sub 19 Rayo 34 55 41 53
8 UD Sanse Sub 19 Sanse 34 62 57 51
9 Complutense Alcalá Sub 19 Complutense 34 54 52 51
10 Union Zona Norte A Union Zona. 34 53 51 47
11 ED Moratalaz Sub 19 Moratalaz 34 55 67 45
12 Alcalá B Alcalá B 34 47 59 42
13 Móstoles URJC Sub 19 B Móstoles 34 39 58 39
14 Escuela Futbol Concepcion A Escuela 34 39 61 37
15 San Fernando B Fernando 34 51 85 37
16 Las Rozas CF Sub 19 Rozas 34 38 76 26
17 Trival Valderas Alcorcón C Trival 34 39 78 26
18 Galapagar A Galapagar A 34 27 81 16
TEMPORADA 2016/2017
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 34 130 13 98
2 Canillas Sub 19 Canillas 34 89 53 74
3 Aravaca B Aravaca B 34 83 47 69
4 Rayo Majadahonda Sub 19 B Rayo 34 84 52 66
5 Alcalá B Alcalá B 34 81 57 62
6 Complutense Alcalá Sub 19 Complutense 34 76 54 61
7 Vicalvaro A Vicalvaro A 34 76 63 53
8 UD Sanse Sub 19 Sanse 34 67 55 48
9 Rayo CI Alcobendas Sub 19 Rayo 34 80 82 46
10 Union Zona Norte A Union Zona. 34 56 58 42
11 Las Rozas Sub 19 B Rozas 34 50 54 42
12 Collado Villalba A Collado 34 54 70 42
13 Escuela Futbol Concepcion A Escuela 34 53 71 41
14 Móstoles URJC Sub 19 B Móstoles 34 54 66 39
15 Colmenar Viejo A Colmenar 34 56 77 37
16 Sporting Hortaleza Sub 19 Sporting 34 51 102 21
17 Atlético de Pinto B Atlético 34 27 78 17
18 Torrelodones A Torrelodones 34 23 138 8
TEMPORADA 2015/2016
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 34 88 28 83
2 Aravaca Sub 19 Aravaca 34 88 45 69
3 Unión Adarve Sub 19 B Unión 34 66 50 59
4 Vicalvaro A Vicalvaro A 34 66 63 53
5 Rayo Majadahonda Sub 19 B Rayo 34 56 48 51
6 Union Zona Norte A Union Zona. 34 55 53 50
7 Torrelodones A Torrelodones 34 44 52 49
8 Colmenar Viejo A Colmenar 34 74 60 49
9 UD Sanse Sub 19 Sanse 34 66 55 48
10 Sporting Hortaleza Sub 19 Sporting 34 46 67 46
11 Boadilla Sub 19 Boadilla 34 54 66 45
12 Moratalaz Sub 19 B Moratalaz 34 61 67 45
13 Canillas Sub 19 Canillas 34 62 67 44
14 Collado Villalba A Collado 34 54 70 38
15 Alcobendas-Levitt B Alcobendas-L 34 57 66 37
16 S. Fernando Henares Sub 19 Fernando 34 47 63 34
17 Torrejon A Torrejon A 34 40 64 32
18 Escuela Futbol de Brunete Escuela 34 39 79 26
TEMPORADA 2014/2015
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 34 124 25 88
2 Alcalá B Alcalá B 34 65 45 62
3 Barrio Pilar A Barrio Pilar 34 49 40 60
4 Las Rozas Sub 19 B Rozas 34 56 62 60
5 Colmenar Viejo A Colmenar 34 77 61 58
6 Boadilla Sub 19 Boadilla 34 74 55 56
7 Union Zona Norte A Union Zona. 34 56 45 54
8 UD Sanse Sub 19 Sanse 34 56 55 54
9 Leganés Sub 19 C Leganés 34 60 68 49
10 Collado Villalba A Collado 34 65 61 48
11 Escuela Futbol de Brunete Escuela 34 74 66 46
12 Sporting Hortaleza Sub 19 Sporting 34 72 82 45
13 Aravaca Sub 19 Aravaca 34 54 61 38
14 San Fernando B Fernando 34 62 67 33
15 Atlético Casarrubuelos B Atlético 34 43 81 31
16 Fundacion Recuerdo Fundacion 34 42 83 29
17 Coslada Coslada 34 54 83 28
18 Siete Picos Colmenar A Siete Picos 34 39 82 27

  USO DE MEMORIA  
6,193,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4964
Total Execution Time  0.4984
  CADENA URL  
/historico/San-Sebastian-Reyes-A-Juvenil
  GET DATOS  
$_GET['/historico/San-Sebastian-Reyes-A-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0137  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 = 'San-Sebastian-Reyes-A-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.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=22271 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=22271 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=22271 AND type_rel = 2
0.0133  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 156 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  SELECT /*53 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 (1312138,1296752,1287260,1285942,1285456) ORDER BY n.cover_points DESC, update_date DESC
0.0128  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 = '22271' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '22271' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '22271' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 73245 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=22271 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73245,68417) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73245 AND teamId = 22271
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 68417 AND teamId = 22271
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 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 = 73245 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '22271' 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 = '22271' and rp.type = 4
0.0131  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 = '22271' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0152  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 = 73245 WHERE rp.league_id = 73245 AND rp.teamId = 22271 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.0148  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 = 73245 WHERE rp.league_id = 73245 AND rp.teamId = 22271 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 73245 WHERE rp.league_id = 73245 AND rp.teamId = 22271 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 22271 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68417 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.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_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 = 64789 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.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 `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 = 61288 AND t.round = 19 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 `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 = 51855 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.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 `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 = 45014 AND t.round = 34 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 `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 = 39234 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 16966 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 `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 = 4616 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC