4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sevilla Sub 12

Sevilla Sub 12

Entrenador: Ángel Clavero

Temporada 2023/2024
TEMPORADA 2023/2024
1ª ANDALUZA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 Sevilla 28 184 22 81
2 Real Betis Sub 12 Real Betis 28 135 39 69
3 Cádiz Sub 12 Cádiz 27 87 43 60
4 Córdoba CF Sub 12 Córdoba 28 91 48 58
5 SAM-CAM Sub 12 SAM-CAM 29 100 80 51
6 San Roque Balompie Sub 12 Roque 28 81 53 42
7 APA Sancti Petri Sub 12 Sancti Petri 28 84 97 42
8 Seneca CF Sub 12 Seneca 28 60 74 37
9 Atletico Seneca Sub 12 Atletico 28 58 63 34
10 Tomares Sub 12 Tomares 27 54 71 34
11 RCR Huelva SAD Sub 12 Huelva 27 62 90 32
12 Asoc. Dva. Nervión Sub 12 Asoc. Dva.. 28 84 98 31
13 San Fernando Isleño Sub 12 Fernando 28 47 117 20
14 Isla Cristina Sub 12 Isla 28 50 119 17
15 CD Juanin Y Diego Sub 12 Juanin Diego 24 42 122 10
16 AD Taraguilla Sub 12 Taraguilla 28 52 135 10
TEMPORADA 2022/2023
1ª ANDALUZA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 Real Betis 30 174 23 86
2 Sevilla Sub 12 Sevilla 30 118 36 80
3 San Roque Balompie Sub 12 Roque 30 122 70 65
4 Cádiz Sub 12 Cádiz 30 122 57 62
5 Córdoba CF Sub 12 Córdoba 30 96 79 59
6 Asoc. Dva. Nervión Sub 12 Asoc. Dva.. 30 96 61 57
7 Atletico Seneca Sub 12 Atletico 30 110 78 53
8 Seneca CF Sub 12 Seneca 30 93 82 45
9 SAM-CAM Sub 12 SAM-CAM 30 102 117 30
10 RCR Huelva SAD Sub 12 Huelva 30 58 81 30
11 AD Taraguilla Sub 12 Taraguilla 30 77 142 27
12 Marismas del Polvorin Marismas 30 52 95 25
13 San Fernando Isleño Sub 12 Fernando 30 54 118 25
14 Don Bosco CF Bosco 30 56 123 19
15 Marianistas AD CD Marianistas 30 45 120 16
16 Xerez Deportivo Xerez 30 35 128 14
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 30 169 24 85
2 San Roque Balompie Sub 12 Roque 29 183 43 76
3 Sevilla Sub 12 Sevilla 30 149 66 66
4 Montequinto Sub 12 Montequinto 30 101 73 54
5 Coria Sub 12 Coria 30 93 67 53
6 Tomares Sub 12 Tomares 30 108 57 52
7 Juventud Gines Sub 12 Juventud 30 104 97 48
8 Castilleja Sub 12 Castilleja 30 94 113 39
9 Camas A Camas A 29 80 112 35
10 C. Claret A C. Claret A 30 88 123 29
11 AD Dani Triana Ar Rabad A Dani Triana 30 67 123 29
12 Umbrete Sub 12 Umbrete 30 60 139 27
13 Bellavista A Bellavista 30 64 149 25
14 Asociación Nervion Sub 12 B Asociación 30 68 123 24
15 Sededos Sededos 28 62 89 23
16 Atlético Antoniano Atlético 30 54 146 18
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 5
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 Sevilla 10 89 10 30
2 Real Betis Sub 12 B Real Betis 10 60 17 24
3 SAM-CAM Sub 12 SAM-CAM 10 52 28 22
4 Sededos Sededos 10 23 34 12
5 Utrera Sub 12 Utrera 10 25 39 12
6 Aficionado de Ecija Sub 12 Aficionado 10 34 43 11
7 Mosquito Sub 12 Mosquito 10 30 48 11
8 Pablo VI A Pablo VI A 10 22 46 7
9 San Roque Balompié Sub 12 B Roque 10 24 70 7
10 Montequinto Sub 12 Montequinto 10 27 51 6
TEMPORADA 2019/2020
2ª SEVILLA ALEVÍN (2ª FASE) GRUPO 2
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 9 41 11 24
2 Sevilla Sub 12 Sevilla 9 59 10 24
3 Tomares Sub 12 Tomares 9 32 37 16
4 Sededos Sededos 9 19 23 12
5 Utrera Sub 12 Utrera 9 18 38 9
6 SAM-CAM Sub 12 SAM-CAM 9 19 31 8
7 AD Dani Triana Ar Rabad A Dani Triana 9 21 49 6
8 CD Antonio Puerta Sub 12 Antonio 9 19 29 5
TEMPORADA 2018/2019
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 Sevilla 14 177 6 42
2 Tomares Tomares 14 70 28 33
3 CD Antonio Puerta Sub 12 Antonio 14 88 54 26
4 Montequinto Sub 12 Montequinto 14 41 51 23
5 SAM-CAM Sub 12 SAM-CAM 14 51 67 21
6 Circulo Don Bosco Circulo 14 44 51 13
7 El Pilar El Pilar 14 16 125 6
8 AD San José Sub 12 José 14 16 121 0
TEMPORADA 2017/2018
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 6
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 B Sevilla 14 99 13 42
2 Utrera Sub 12 Utrera 14 58 37 31
3 Real Betis Balompie C Real Betis. 14 40 40 27
4 Sevilla Sub 12 Sevilla 14 49 40 25
5 San Roque Balompie Sub 12 Roque 14 33 52 16
6 Tomares Sub 12 Tomares 14 29 43 11
7 CD Antonio Puerta Sub 12 Antonio 14 30 65 8
8 SAM-CAM Sub 12 SAM-CAM 14 25 73 4
TEMPORADA 2016/2017
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 2
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 Sevilla 28 255 21 80
2 Real Betis Balompie C Real Betis. 28 196 27 80
3 San Roque Balompié Sub 12 B Roque 28 107 79 54
4 Centro Historico Sub 12 Centro 28 104 89 49
5 Colegio Claret Sub 12 Colegio 27 103 116 49
6 Viso Viso 28 94 104 45
7 Circulo Don Bosco Circulo 28 94 101 43
8 Los Caminantes Caminantes 28 54 97 33
9 Lora Lora 28 85 103 31
10 CD Antonio Puerta Sub 12 Antonio 28 83 144 29
11 Utrera Sub 12 Utrera 28 88 149 28
12 Ciudad de Moron Ciudad Moron 28 75 128 23
13 El Pilar El Pilar 27 53 118 22
14 CD Alcala CD Alcala 28 65 130 20
15 Asoc. Dva. Nervión Sub 12 Asoc. Dva.. 28 72 158 16
TEMPORADA 2015/2016
2ª ANDALUZA SEVILLA ALEVÍN
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 Real Betis 30 255 20 88
2 Sevilla Sub 12 Sevilla 30 255 35 85
3 Asociación Nervion Sub 12 B Asociación 30 147 69 70
4 CD Antonio Puerta Sub 12 Antonio 30 130 81 66
5 Coria Sub 12 Coria 30 113 91 55
6 Tomares Tomares 30 79 80 51
7 Montequinto Sub 12 Montequinto 30 96 90 46
8 Sededos Sededos 30 83 74 45
9 AD San José Sub 12 José 30 83 116 42
10 Utrera Sub 12 Utrera 30 71 130 30
11 Lora C.F Lora C.F 30 64 95 30
12 CD Alcala CD Alcala 30 94 153 28
13 El Pilar El Pilar 30 68 141 27
14 La Liara Sub 12 Liara 30 60 157 20
15 C.D. BORMUJOS S.M. C.D. 30 28 158 5
16 Betisevilla Betisevilla 30 41 255 3
TEMPORADA 2014/2015
2ª ANDALUZA SEVILLA ALEVÍN
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 Real Betis 30 230 19 85
2 Sevilla Sub 12 Sevilla 30 237 33 84
3 CD Antonio Puerta Sub 12 Antonio 30 114 61 69
4 Coria Coria 30 95 55 66
5 Nervión Nervión 30 99 78 58
6 A.D San José José 30 68 87 47
7 C.D. El Pilar C.D. Pilar 30 64 87 42
8 Tomares Tomares 30 62 73 40
9 Sededos Sededos 30 64 76 37
10 C.D Montequinto Montequinto 30 48 93 35
11 C.D. Utrera C.D. Utrera 30 65 133 32
12 CD Alcala CD Alcala 30 63 102 26
13 Centro Historico Sub 12 Centro 30 62 121 25
14 Pvo. Alcosa Pvo. Alcosa 30 43 113 23
15 U.D Bellavista Bellavista 30 52 140 14
16 Calavera C.F Calavera 30 54 149 13
TEMPORADA 2013/2014
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 Sevilla 20 141 24 60
2 Tomares Tomares 20 73 37 42
3 Diez de Sanlúcar Diez 20 95 57 41
4 Tabladilla Tabladilla 21 100 59 40
5 Pvo. Alcosa Pvo. Alcosa 21 85 62 40
6 La Liara Balompié Liara 20 78 65 35
7 Villamartín Villamartín 21 75 68 34
8 AA. Colspe AA. Colspe 20 55 52 34
9 Coria C.F. Coria C.F. 21 75 67 29
10 J.D. Gines J.D. Gines 20 57 59 25
11 C.D Gelves C.D Gelves 21 65 88 21
12 Los Palacios CF Palacios 21 57 64 20
13 Cantely C.D. Cantely C.D. 21 49 105 18
14 C.D Sededos C.D Sededos 21 43 81 16
15 A.C. Villanueva A.C. 21 45 130 14
16 DC3-Carrión DC3-Carrión 21 39 114 5

  USO DE MEMORIA  
5,822,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1451
Total Execution Time  0.1471
  CADENA URL  
/historico/Sevilla-Alevin
  GET DATOS  
$_GET['/historico/Sevilla-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0033  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 = 'Sevilla-Alevin' 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=8724 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=8724 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=8724 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0038  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 = 74883
0.0025  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 = 74444
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8724 AND type_rel = 2
0.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 8724 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0029  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 (72746,658127,999116,1119926) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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 = '8724' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '8724' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 74883 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 74444 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=8724 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (74883,74444,72293,72167) 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.0042  SELECT count(id) as num_players from rel_players WHERE league_id = 74444 AND teamId = 8724
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 74883 AND teamId = 8724
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 72167 AND teamId = 8724
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 72293 AND teamId = 8724
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 = 74883 AND t.round = 3 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '8724' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '8724' and rp.type = 4
0.0020  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 = '8724' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 74883 WHERE rp.league_id = 74883 AND rp.teamId = 8724 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.0019  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 = 74883 WHERE rp.league_id = 74883 AND rp.teamId = 8724 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 74883 WHERE rp.league_id = 74883 AND rp.teamId = 8724 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 8724 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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 = 74444 AND t.round = 29 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 `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 = 69626 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.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 `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 = 64319 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.0044  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 = 64479 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.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 `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 = 60529 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.0021  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 = 62287 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.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 `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 = 53213 AND t.round = 14 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 `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 = 55288 AND t.round = 14 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 `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 = 44976 AND t.round = 14 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 `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 = 42082 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 42862 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 34538 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 17854 AND t.round = 30 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 `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 = 4488 AND t.round = 30 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 `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 = 3100 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 74883 ORDER BY nameShow LIMIT 100