4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Algeciras CF Sub 16
TEMPORADA 2023/2024
DIVISIÓN DE HONOR CADETE ANDALUZA
Equipo PJ GF GC Puntos
1 Real Betis Sub 16 Real Betis 26 89 16 71
2 Sevilla FC Sub 16 Sevilla 26 95 20 63
3 UD Almeria Sub 16 Almeria 26 53 27 54
4 Granada CF Sub 16 Granada 25 57 32 49
5 Cádiz CF Sub 16 Cádiz 26 49 27 46
6 CD Altair Sub 16 Altair 26 51 40 42
7 Málaga CF Sub 16 Málaga 26 49 31 41
8 CD 26 De Febrero Sub 16 Febrero 26 35 48 35
9 Algeciras CF Sub 16 Algeciras 26 35 40 32
10 CD Utrera Sub 16 Utrera 25 36 47 29
11 Córdoba CF Sub 16 Córdoba 26 31 49 26
12 Arenas de Armilla Sub 16 Arenas 26 30 50 25
13 Puerto Malagueño Sub 16 Puerto 26 31 43 25
14 UD Maracena Sub 16 Maracena 26 20 60 19
15 Pvo. El Ejido 1969 Sub 16 Pvo. Ejido. 26 22 88 11
16 Linares Deportivo Sub 16 Linares 26 19 84 10
TEMPORADA 2022/2023
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 16 B Real Betis 29 80 27 73
2 CD Altair Sub 16 Altair 28 75 34 61
3 Sevilla FC Sub 16 B Sevilla 29 62 42 52
4 Algeciras CF Sub 16 Algeciras 29 65 48 52
5 Séneca CF Sub 16 Séneca 29 72 43 48
6 San Roque Balompie Sub 16 Roque 29 61 39 48
7 Cadiz CF Sub 16 Cadiz 29 67 48 47
8 SAM-CAM Sub 16 SAM-CAM 29 58 48 42
9 San Jose Obrero UD Sub 16 Jose Obrero 29 55 58 42
10 Recreativo de Huelva Sub 16 Recreativo 29 65 62 40
11 CD Antonio Puerta Sub 16 Antonio 29 34 56 38
12 Juanin Y Diego Sub 16 Juanin Diego 29 39 67 27
13 UD Tomares UD Tomares 29 37 55 26
14 CD Asoc. Dva. Nervión Asoc. Dva.. 29 37 84 17
15 CD San Roque Roque 29 43 86 14
16 CD Marismas Del Polvorin Marismas 14 15 68 7
TEMPORADA 2021/2022
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Peloteros Sierra Sur Sub 16 Peloteros 30 96 31 75
2 Real Betis Sub 16 B Real Betis 30 107 34 68
3 CD Utrera Sub 16 Utrera 29 86 35 68
4 Fundacion Cadiz CF CD Fundacion 29 83 33 64
5 Sevilla FC Sub 16 B Sevilla 30 63 38 57
6 San Roque Balompie Sub 16 Roque 29 59 43 53
7 Algeciras CF Sub 16 Algeciras 30 61 49 47
8 CD Asoc. Dva. Nervión Asoc. Dva.. 29 59 62 42
9 Palma del Rio Atlético Palma 30 44 62 39
10 Córdoba CF B Córdoba 30 36 55 31
11 San Fernando CD Isleño Fernando 30 52 73 26
12 Balón De Cádiz CF B Balón 30 46 69 24
13 CD Siempre Alegres Siempre 29 30 84 23
14 Recreativo de Huelva B Recreativo 30 38 72 20
15 Calavera CF Calavera CF 30 35 81 20
16 Nuevo Molino Sub 16 Nuevo Molino 29 27 101 14
TEMPORADA 2020/2021
1ª ANDALUZA CADETE GRUPO 6
Equipo PJ GF GC Puntos
1 Algeciras CF Sub 16 Algeciras 10 22 9 24
2 San Roque Balompie Sub 16 Roque 8 18 10 17
3 Nuevo Molino Sub 16 Nuevo Molino 10 23 17 17
4 CD Utrera Sub 16 Utrera 8 12 11 13
5 Wea Sierra de Cadiz Sierra Cadiz 10 17 18 13
6 Atlético Sanluqueño Sub 16 Atlético 10 22 24 9
7 CD Los Caminantes Caminantes 8 10 13 8
8 CD Apedem A CD Apedem A 8 17 22 7
9 CD Los Califas Balompie Califas 8 11 28 3
TEMPORADA 2019/2020
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 16 B Real Betis 23 62 26 52
2 Sevilla FC Sub 16 B Sevilla 23 51 25 48
3 Séneca CF Sub 16 Séneca 23 47 21 47
4 CD Antonio Puerta Sub 16 Antonio 23 43 28 45
5 San Fernando CD Isleño Fernando 23 42 26 41
6 Tomares UD Tomares UD 23 53 38 40
7 Algeciras CF Sub 16 Algeciras 23 57 36 39
8 Atlético Sanluqueño Sub 16 Atlético 23 43 36 36
9 Córdoba CF B Córdoba 23 36 30 36
10 CD Los Califas Balompie Califas 23 44 44 29
11 San Jose Obrero UD Sub 16 Jose Obrero 23 30 35 28
12 CD Los Caminantes Caminantes 23 29 42 22
13 Wea Sierra de Cadiz Sierra Cadiz 23 26 51 22
14 San Roque de Lepe CD Roque Lepe 23 26 64 17
15 CD Utrera Sub 16 Utrera 23 21 63 12
16 CD Siempre Alegres Siempre 23 15 60 7
TEMPORADA 2018/2019
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla FC Sub 16 B Sevilla 30 108 21 85
2 Real Betis Sub 16 B Real Betis 30 74 16 64
3 Peloteros Sierra Sur Sub 16 Peloteros 30 54 30 59
4 San Fernando Isleño A Fernando 30 66 37 58
5 Recreativo de Huelva Sub 16 Recreativo 30 56 40 56
6 CD Antonio Puerta Sub 16 Antonio 30 65 41 46
7 Wea Sierra de Cadiz Sierra Cadiz 30 38 33 43
8 UD Tomares UD Tomares 30 56 42 41
9 Córdoba CF B Córdoba 30 47 46 37
10 CD Siempre Alegres Siempre 30 40 55 37
11 CD Utrera Sub 16 Utrera 30 33 53 35
12 Algeciras CF Sub 16 Algeciras 30 38 49 34
13 Pozoblanco Pozoblanco 30 41 50 33
14 Salerm Cosmetics Puente Gen Salerm 30 32 58 30
15 Cartaya A Cartaya A 30 16 107 9
16 CD Alcala Sub 16 Alcala 30 15 101 6
TEMPORADA 2017/2018
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 Algeciras CF Sub 16 Algeciras 30 153 34 76
2 Sancti Petri A Sancti Petri 30 82 53 67
3 Xerez Deportivo A Xerez 30 84 39 60
4 Balón De Cádiz CF B Balón 30 90 33 58
5 Conil Conil 30 54 42 57
6 San Jose Obrero UD Sub 16 Jose Obrero 30 72 56 54
7 Rvo Portuense Club Futbol B Portuense 30 66 50 50
8 La Salle A La Salle A 30 60 59 49
9 Sanluqueño Atlético B Sanluqueño 30 59 57 46
10 CD Guadalcacín A Guadalcacín 30 61 78 33
11 San Fernando CD Isleño Fernando 30 52 66 27
12 Atletico Zabal A Atletico 30 47 81 27
13 Pueblo Nuevo La Granja A Pueblo Nuevo 30 48 74 26
14 Arcos A Arcos A 30 37 74 25
15 Novo Chiclana A Novo 30 38 119 16
16 Amigos Cruz Roja Jerez Amigos Cruz 30 24 112 9
TEMPORADA 2016/2017
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 Wea Sierra de Cadiz Sierra Cadiz 28 98 30 67
2 Balón De Cádiz CF B Balón 28 86 33 63
3 Algeciras CF Sub 16 Algeciras 28 95 47 58
4 Xerez Deportivo FC Xerez 28 64 35 53
5 Novo Chiclana CD Novo 28 51 55 43
6 La Salle A La Salle A 28 42 51 39
7 Arcos A Arcos A 28 55 57 38
8 San Jose Obrero UD Sub 16 Jose Obrero 28 51 54 38
9 CD Guadalcacín A Guadalcacín 28 43 40 36
10 Sanluqueño Atlético B Sanluqueño 28 50 56 36
11 Atletico Zabal A Atletico 28 40 69 27
12 Santic Petri A Santic Petri 28 33 58 26
13 El Mirador El Mirador 28 30 60 23
14 Pueblo Nuevo La Granja A Pueblo Nuevo 28 34 80 21
15 Taraguilla B Taraguilla 28 51 98 17
TEMPORADA 2015/2016
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 Taraguilla A Taraguilla 30 83 39 71
2 San Fernando Isleño A Fernando 30 79 26 71
3 Xerez Deportivo FC Xerez 30 88 37 66
4 CD Guadalcacín A Guadalcacín 30 73 53 52
5 Atletico Zabal A Atletico 30 75 48 51
6 Arcos A Arcos A 30 58 45 48
7 Balón De Cádiz CF B Balón 30 68 55 47
8 Algeciras CF Sub 16 Algeciras 30 76 57 42
9 San Jose Obrero UD Sub 16 Jose Obrero 30 59 68 41
10 Pueblo Nuevo La Granja A Pueblo Nuevo 30 53 64 38
11 Domingo Savio Domingo 30 43 61 36
12 Sanluqueño Atlético B Sanluqueño 30 63 81 35
13 La Salle A La Salle A 30 35 47 34
14 Salesianos Algeciras A Salesianos 30 54 86 29
15 Trasmallo A Trasmallo A 30 36 92 12
16 San Roque A San Roque A 30 43 127 8
TEMPORADA 2014/2015
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 Balón De Cádiz CF B Balón 31 105 40 75
2 Xerez Cd Xerez Cd 31 75 25 68
3 Atlético Zabal Atlético 31 87 44 64
4 San Jose Obrero UD Sub 16 Jose Obrero 31 82 45 64
5 Arcos A AD Arcos A AD 32 119 41 61
6 Algeciras CF Sub 16 Algeciras 31 70 51 56
7 Atletico Sanluqueño B Atletico 31 64 45 49
8 Domingo Savio Domingo 31 42 45 39
9 Safa San Luis Safa Luis 31 47 58 36
10 Taraguilla B AD Taraguilla 31 59 81 36
11 La Salle Puerto Real Salle Puerto 31 55 81 35
12 Pueblo Nuevo Pueblo Nuevo 31 43 66 33
13 Chiclana CF A Chiclana 31 50 87 26
14 Conil C.F. Conil C.F. 31 42 100 19
15 CD Rota CD Rota 31 26 109 10
16 Tarifa Tarifa 17 23 93 7
TEMPORADA 2013/2014
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 Balón De Cádiz CF B Balón 20 61 20 46
2 Xerez Cd Xerez Cd 20 45 25 45
3 Salesianos Algeciras Salesianos 20 61 38 39
4 Chiclana CF A Chiclana 20 47 26 37
5 Ad Taraguilla Taraguilla 20 48 42 34
6 Algeciras CF Sub 16 Algeciras 20 47 35 32
7 Pueblo Nuevo Pueblo Nuevo 20 44 38 32
8 Ud Orotava Ud Orotava 20 41 38 30
9 Atlético Zabal Atlético 20 42 29 29
10 Tarifa Tarifa 20 31 42 25
11 La Salle Puerto Real Salle Puerto 20 24 36 25
12 Conil C.F. Conil C.F. 20 35 56 21
13 Safa San Luis Safa Luis 20 24 47 19
14 Tiempo Libre Tiempo Libre 20 18 48 11
15 Distrito La Granja Distrito 20 17 44 10
16 Marianistas Marianistas 20 21 42 10

  USO DE MEMORIA  
5,879,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1003
Total Execution Time  0.1014
  CADENA URL  
/historico/Algeciras-Cf-A-Cadete
  GET DATOS  
$_GET['/historico/Algeciras-Cf-A-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0028  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 = 'Algeciras-Cf-A-Cadete' 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=69300 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=69300 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 74210
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=69300 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1934 AND type_rel = 3
0.0022  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 = '69300' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '69300' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '69300' 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 = 74210 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=69300 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74210,68955) 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 = 68955 AND teamId = 69300
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74210 AND teamId = 69300
0.0019  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 = 74210 AND t.round = 26 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 = '69300' 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 = '69300' and rp.type = 4
0.0019  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 = '69300' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 69300 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74210 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.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 `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 = 68955 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.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 `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 = 64285 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.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 = 59847 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 `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 = 62004 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 = 52405 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.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 `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 = 44970 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 41328 AND t.round = 30 ORDER BY team.conference 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 `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 = 34340 AND t.round = 30 ORDER BY team.conference 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 `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 = 17365 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 = 4290 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 3045 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 74210 ORDER BY nameShow LIMIT 100