4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UD Tomares Sub 14
TEMPORADA 2023/2024
1ª ANDALUZA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 UD Tomares Sub 14 Tomares 25 65 22 61
2 RCR Huelva Sub 14 Huelva 25 64 28 56
3 Mosquito Sub 14 Mosquito 25 42 22 49
4 CD San Fernando Sub 14 Fernando 25 46 20 48
5 Real Betis Sub 14 B Real Betis 25 51 26 48
6 San Roque Balompie Sub 14 Roque 25 46 23 47
7 Peloteros Sierra Sur Sub 14 Peloteros 26 45 40 38
8 Atletico Cordobes Sub 14 Atletico 25 34 28 35
9 Atlético Sanluqueño Sub 14 Atlético 25 37 47 30
10 Algeciras Sub 14 Algeciras 25 41 47 29
11 C. Nuevo Molino Sub 14 Nuevo Molino 25 28 41 28
12 Sevilla FC Sub 14 B Sevilla 25 31 41 25
13 CD Utrera Sub 14 Utrera 26 32 48 25
14 Cadiz Sub 14 B Cadiz 25 30 49 23
15 1889 EFFB Sub 14 1889 EFFB 25 23 67 12
16 Lora CF Sub 14 Lora 25 9 75 6
TEMPORADA 2022/2023
1ª ANDALUZA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Sam-Cam Dos Hermanas Sub 14 Sam-Cam 30 72 28 66
2 Sevilla FC Sub 14 B Sevilla 30 67 23 66
3 Real Betis Sub 14 B Real Betis 30 69 33 59
4 Estrella Portuense Sub 14 Estrella 30 36 36 58
5 Algeciras Sub 14 Algeciras 30 91 60 56
6 Mosquito Sub 14 Mosquito 30 57 37 53
7 San Roque Balompie Sub 14 Roque 30 64 39 50
8 CD San Fernando Sub 14 Fernando 30 57 53 46
9 UD Tomares Sub 14 Tomares 30 60 33 44
10 RCR Huelva Sub 14 Huelva 30 42 52 36
11 C. Nuevo Molino Sub 14 Nuevo Molino 30 48 50 34
12 Don Bosco CF Bosco 30 49 59 31
13 Atlético Sanluqueño Sub 14 Atlético 30 40 60 31
14 CD Apedem CD Apedem 30 54 85 25
15 Coria CF Coria CF 30 28 87 14
16 Taraguilla Taraguilla 30 28 127 6
TEMPORADA 2021/2022
4ª ANDALUZA SEVILLA INFANTIL GRUPO 10
Equipo PJ GF GC Puntos
1 Tor del Rey de Pilas A Pilas 24 118 13 61
2 UD Loreto B UD Loreto B 24 68 23 60
3 Espartinas Tilde A Espartinas 24 98 30 57
4 Castilleja A Castilleja 24 66 35 55
5 Huevar B Huevar B 23 59 24 45
6 Coria CF Coria CF 24 41 41 42
7 UD Tomares Sub 14 Tomares 24 45 70 27
8 Palomares CF A Palomares 24 41 62 23
9 Mairena de Aljarafe A Mairena 24 46 75 23
10 Gelves A Gelves A 24 45 73 21
11 Club Atletico Aznalcazar Club 23 19 70 12
12 Puebla CF Puebla CF 24 19 75 10
13 Villafranco CF Villafranco 24 28 102 9
TEMPORADA 2020/2021
1ª ANDALUZA INFANTIL GRUPO 5
Equipo PJ GF GC Puntos
1 Cádiz CF Sub 14 Cádiz 8 21 1 22
2 Real Betis Sub 14 Real Betis 8 30 6 19
3 Sevilla FC Sevilla FC 8 16 6 15
4 San Roque Balompie Sub 14 Roque 8 10 10 13
5 AD Nervión Sub 14 Nervión 8 10 13 9
6 Córdoba CF Sub 14 Córdoba 8 6 20 4
7 UD Tomares Sub 14 Tomares 8 4 18 4
8 Peloteros Sierra Sur Sub 14 Peloteros 8 4 27 4
TEMPORADA 2019/2020
1ª ANDALUZA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 14 Real Betis 23 105 11 67
2 Sevilla FC Sevilla FC 23 121 11 63
3 Córdoba CF Sub 14 Córdoba 23 43 21 49
4 Cádiz CF Sub 14 Cádiz 23 62 23 48
5 UD Tomares Sub 14 Tomares 23 38 25 47
6 CD Utrera Sub 14 Utrera 23 52 35 41
7 AD Nervión Sub 14 Nervión 23 61 31 40
8 Peloteros Sierra Sur Sub 14 Peloteros 23 42 42 36
9 RCR Huelva Sub 14 Huelva 23 49 45 31
10 Atlético Sanluqueño Sub 14 Atlético 23 43 55 30
11 CD Los Caminantes Caminantes 23 26 42 26
12 CD Futbol Juanin Y Diego Futbol 23 24 56 22
13 Don Bosco CF Bosco 23 21 62 13
14 CD Wea Sierra de Cadiz Sierra Cadiz 23 14 78 6
15 San Roque de Lepe CD Roque Lepe 23 17 100 6
16 1889 EFFB Sub 14 1889 EFFB 23 19 100 5
TEMPORADA 2018/2019
1ª ANDALUZA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla FC Sevilla FC 30 165 12 88
2 Real Betis Sub 14 Real Betis 30 137 14 82
3 Córdoba CF Sub 14 Córdoba 30 96 24 69
4 Cádiz CF Sub 14 Cádiz 30 73 28 66
5 AD Nervión Sub 14 Nervión 30 76 59 51
6 UD Tomares Sub 14 Tomares 30 65 46 47
7 CD Futbol Juanin Y Diego Futbol 30 48 42 46
8 CD Los Caminantes Caminantes 30 54 44 44
9 Peloteros Sierra Sur Sub 14 Peloteros 30 54 79 34
10 RCR Huelva Sub 14 Huelva 30 49 64 32
11 1889 EFFB Sub 14 1889 EFFB 30 43 92 27
12 Atlético Sanluqueño Sub 14 Atlético 30 51 113 27
13 Seneca Sub 14 Seneca 30 34 76 25
14 N. Molino N. Molino 30 28 83 21
15 CD Apedem A CD Apedem A 30 37 139 17
16 CD San Roque Roque 30 33 128 15
TEMPORADA 2017/2018
1ª ANDALUZA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 14 Real Betis 30 91 11 87
2 Sevilla FC Sevilla FC 30 95 7 82
3 Córdoba CF Sub 14 Córdoba 30 71 31 60
4 Cádiz CF Sub 14 Cádiz 30 56 28 56
5 AD Nervión Sub 14 Nervión 30 57 40 53
6 Seneca Sub 14 Seneca 30 61 36 50
7 RCR Huelva Sub 14 Huelva 30 53 46 41
8 UD Tomares Sub 14 Tomares 30 45 52 41
9 CD Futbol Juanin Y Diego Futbol 30 38 53 34
10 Atlético Sanluqueño Sub 14 Atlético 30 34 58 32
11 N. Molino N. Molino 30 33 70 31
12 CD Los Caminantes Caminantes 30 44 54 30
13 CD Utrera Sub 14 Utrera 30 44 65 27
14 San Jose Obrero UD A Jose Obrero 30 19 61 24
15 CD San Fernando Sub 14 Fernando 30 27 59 21
16 Coria CF Coria CF 30 30 127 6
TEMPORADA 2016/2017
1ª ANDALUZA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla FC Sevilla FC 30 188 15 84
2 Real Betis Sub 14 Real Betis 30 123 12 84
3 AD Nervión Sub 14 Nervión 30 71 43 61
4 RCR Huelva Sub 14 Huelva 30 71 38 60
5 Cádiz CF Sub 14 Cádiz 30 87 30 58
6 Córdoba CF Sub 14 Córdoba 30 73 52 56
7 UD Tomares Sub 14 Tomares 30 45 50 43
8 Seneca Sub 14 Seneca 30 54 54 42
9 CD Los Caminantes Caminantes 30 43 45 42
10 CD Utrera Sub 14 Utrera 30 38 52 40
11 Atlético Sanluqueño Sub 14 Atlético 30 46 64 37
12 CD San Fernando Sub 14 Fernando 30 38 85 31
13 Monitores Falgeciras A Monitores 30 40 89 28
14 Taraguilla Taraguilla 30 23 128 15
15 At. Tartessos Tartessos 30 28 112 11
16 Salvador Allende Salvador 30 7 106 3
TEMPORADA 2015/2016
1ª ANDALUZA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla FC Sevilla FC 28 124 23 74
2 Real Betis Sub 14 Real Betis 28 143 20 71
3 UD Tomares Sub 14 Tomares 28 58 32 54
4 Cádiz CF Sub 14 Cádiz 28 61 28 51
5 Córdoba CF Sub 14 Córdoba 28 59 41 50
6 Seneca Sub 14 Seneca 28 64 49 48
7 AD Nervión Sub 14 Nervión 28 52 37 47
8 RCR Huelva Sub 14 Huelva 28 42 45 39
9 CD San Fernando Sub 14 Fernando 28 48 48 34
10 CD Utrera Sub 14 Utrera 28 40 56 33
11 Atlético Sanluqueño Sub 14 Atlético 28 31 56 28
12 Taraguilla Taraguilla 27 36 87 23
13 Siempre Alegres CD Siempre 28 34 111 17
14 CD Deportivo Cordoba CF Deportivo 28 20 103 14
15 Don Bosco CF Bosco 27 19 95 13
16 Xerez Xerez 0 0 0 0
TEMPORADA 2014/2015
2ª ANDALUZA SEVILLA INFANTIL
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 14 B Sevilla 30 105 19 74
2 UD Tomares Sub 14 Tomares 30 90 20 74
3 Real Betis Sub 14 B Real Betis 30 91 26 67
4 Alcosa Polideportivo Alcosa 30 71 31 65
5 CD Alcala CD Alcala 30 54 29 59
6 Centro Histórico Centro 30 57 36 46
7 Viso U.P Viso U.P 30 53 52 44
8 Coria C.F. Coria C.F. 30 60 40 43
9 Mairena del Aljarafe Mairena 30 58 54 40
10 Nervion B Nervion B 30 56 73 37
11 AD San José José 30 47 51 36
12 CD Los Caminantes Caminantes 30 50 66 35
13 Dos Hermanas Hermanas 30 46 62 32
14 San Roque Balompie Sub 14 Roque 30 32 67 27
15 Alcolea del Río Alcolea Río 30 27 132 4
16 Marchena Balompié Marchena 30 31 170 4
TEMPORADA 2013/2014
2ª ANDALUZA SEVILLA INFANTIL
Equipo PJ GF GC Puntos
1 Sevilla F.C. Sevilla F.C. 30 75 19 76
2 Écija Balompié Écija 30 77 33 61
3 Viso U.P Viso U.P 30 74 35 60
4 Alcalá, C.D. Alcalá, 30 51 42 48
5 Mairena del Aljarafe Mairena 30 46 45 45
6 Alcolea del Río Alcolea Río 30 58 59 44
7 Real Betis Sub 14 B Real Betis 30 43 40 44
8 AD San José José 30 71 59 44
9 Dos Hermanas Hermanas 30 54 51 44
10 Nervion B Nervion B 30 50 50 42
11 UD Tomares Sub 14 Tomares 30 45 39 42
12 Coria C.F. Coria C.F. 30 63 50 37
13 Sevilla Este Sevilla Este 30 39 51 36
14 Andalucía Este Andalucía 30 26 66 24
15 Calavera Calavera 30 33 70 18
16 Los Mares Los Mares 30 31 127 11

  USO DE MEMORIA  
5,864,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4337
Total Execution Time  0.4349
  CADENA URL  
/historico/Ud-Tomares-Infantil
  GET DATOS  
$_GET['/historico/Ud-Tomares-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0115  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-Tomares-Infantil' 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.0105  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=71176 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=71176 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0217  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 = 74442
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=71176 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=456 AND type_rel = 3
0.0108  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 = '71176' ORDER BY l.year DESC,cat.coefficient DESC
0.0108  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 = '71176' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0107  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 = '71176' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 74442 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  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=71176 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0105  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 (74442) 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.0105  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74442 AND teamId = 71176
0.0106  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 = 74442 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '71176' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '71176' and rp.type = 4
0.0107  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 = '71176' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0109  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 = 71176 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0110  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 = 74442 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.0110  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 = 68957 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.0109  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 = 64288 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.0108  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 = 64768 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.0108  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 = 59836 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.0108  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 = 62007 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 52959 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.0109  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 = 44968 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 39445 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 34415 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 17537 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 4402 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 3068 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC