4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Guadiaro
TEMPORADA 2023/2024
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Cádiz C Cádiz C 28 45 18 57
2 Algeciras CF B Algeciras 27 41 33 51
3 Jerez Industrial CF Jerez 27 50 29 49
4 Guadiaro Guadiaro 27 43 29 45
5 Puerto Real CF Puerto Real 27 43 29 44
6 CD Guadalcacín Guadalcacín 27 41 35 42
7 RC Portuense Portuense 27 35 35 39
8 Arcos CF Arcos CF 27 35 37 34
9 Ciudad De Cadiz PCD Ciudad Cadiz 28 33 40 33
10 Roteña Roteña 27 39 41 32
11 Trebujena CF Trebujena 27 29 38 32
12 Rayo Sanluqueño Rayo 27 42 43 30
13 Xerez Deportivo B Xerez 27 36 48 30
14 Grupo Empresa Bazán CF Grupo 27 34 53 27
15 San Bernardo Bernardo 27 21 45 25
16 CD San Roque Roque 27 26 40 25
TEMPORADA 2022/2023
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 San Fernando CD B Fernando 30 68 35 56
2 Trebujena CF Trebujena 30 46 32 54
3 Roteña Roteña 30 55 41 54
4 Puerto Real CF Puerto Real 30 63 29 53
5 Guadiaro Guadiaro 30 54 39 53
6 RC Portuense Portuense 30 55 34 51
7 Balón de Cádiz CF Balón 30 39 38 47
8 Algeciras CF B Algeciras 30 63 54 42
9 Jerez Industrial CF Jerez 30 44 35 41
10 Grupo Empresa Bazán CF Grupo 30 49 53 41
11 Xerez Deportivo B Xerez 30 57 51 40
12 CD Guadalcacín Guadalcacín 30 53 46 39
13 CD Jédula CD Jédula 30 43 51 39
14 Barbate Barbate 30 55 53 35
15 Recreativo Portuense Recreativo 30 27 74 17
16 CD UD Villamartín Villamartín 30 20 126 7
TEMPORADA 2021/2022
PRIMERA ANDALUZA GRUPO 16
Equipo PJ GF GC Puntos
1 Algeciras CF B Algeciras 28 56 47 41
2 Guadiaro Guadiaro 28 44 31 39
3 Puerto Real CF Puerto Real 28 29 45 36
4 Los Cortijillos Cortijillos 28 53 54 36
5 CD San Roque Roque 28 48 43 36
6 San Bernardo Bernardo 28 38 42 32
7 Chiclana Industrial Chiclana 28 35 52 26
8 Tesorillo Tesorillo 28 32 53 24
9 Rayo Sanluqueño Rayo 28 44 81 23
10 Ubrique UD Ubrique UD 28 39 68 21
TEMPORADA 2020/2021
PRIMERA ANDALUZA GRUPO 3
Equipo PJ GF GC Puntos
1 Balón de Cádiz CF Balón 18 47 13 42
2 San Bernardo Bernardo 18 25 14 37
3 Chiclana Industrial Chiclana 18 24 18 32
4 Guadiaro Guadiaro 18 25 29 27
5 Tesorillo Tesorillo 18 27 25 23
6 Tarifa UD Tarifa UD 18 20 26 19
7 Algeciras CF B Algeciras 18 28 35 18
8 CD Vejer Balompié Vejer 18 21 28 18
9 Los Cortijillos Cortijillos 18 18 29 18
10 Grupo Empresa Bazán CF Grupo 18 22 40 16
11 Barbate Barbate 0 0 0 0
TEMPORADA 2019/2020
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Guadiaro Guadiaro 25 79 17 69
2 Los Cortijillos Cortijillos 25 53 20 55
3 UD Algaida UD Algaida 25 56 24 48
4 Xerez Deportivo B Xerez 25 65 34 47
5 CD Jédula CD Jédula 25 45 33 41
6 San Fernando CD B Fernando 25 42 34 41
7 CD Rivera CD Rivera 25 36 30 40
8 RC Portuense Portuense 25 42 32 39
9 Divina Pastora Sanluqueña Divina 25 28 41 31
10 Amigos Cruz Roja Jerez Amigos Cruz 25 39 45 28
11 J. Sanluqueña Sanluqueña 25 39 46 28
12 Medina Balompié Medina 25 36 41 27
13 Estrella Portuense FC Estrella 25 23 39 25
14 Rayo Sanluqueño Rayo 25 21 40 25
15 Alcalá del Valle Alcalá 25 27 53 24
16 Espera C.F. Espera C.F. 25 22 54 23
17 Cañorrera Cañorrera 25 18 65 21
18 San Jose Obrero UD Jose Obrero 25 30 53 20
TEMPORADA 2018/2019
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Chiclana CF Chiclana CF 34 57 29 72
2 Trebujena CF Trebujena 34 68 34 71
3 Grupo Empresa Bazán CF Grupo 34 62 27 67
4 Balón de Cádiz CF Balón 34 68 35 67
5 CD UD Villamartín Villamartín 34 59 34 67
6 Ubrique UD Ubrique UD 34 66 47 60
7 Jerez Industrial CF Jerez 34 54 47 49
8 Algeciras CF B Algeciras 34 72 67 48
9 CD Vejer Balompié Vejer 34 49 51 45
10 Recreativo Portuense Recreativo 34 48 50 45
11 Tarifa UD Tarifa UD 34 44 52 44
12 Chiclana Industrial Chiclana 34 50 59 43
13 Tesorillo Tesorillo 34 56 52 41
14 CD El Torno 2009 Torno 2009 34 52 61 40
15 Guadiaro Guadiaro 34 47 58 38
16 San Fernando CD B Fernando 33 35 66 26
17 Alcalá del Valle Alcalá 33 31 79 20
18 J. Sanluqueña Sanluqueña 34 24 94 12
TEMPORADA 2017/2018
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Grupo Empresa Bazán CF Grupo 34 68 26 69
2 Roteña Roteña 34 55 33 64
3 Trebujena CF Trebujena 34 59 37 62
4 Jerez Industrial CF Jerez 33 63 39 59
5 CD UD Villamartín Villamartín 34 58 45 59
6 Balón de Cádiz CF Balón 34 58 37 54
7 Chiclana CF Chiclana CF 33 56 37 54
8 CD Vejer Balompié Vejer 34 52 46 52
9 CD El Torno 2009 Torno 2009 33 61 66 48
10 San Fernando CD B Fernando 34 56 53 46
11 Guadiaro Guadiaro 34 53 54 46
12 Tesorillo Tesorillo 33 51 63 41
13 J. Sanluqueña Sanluqueña 33 50 68 40
14 Recreativo Portuense Recreativo 33 39 49 39
15 San Jose Obrero UD Jose Obrero 34 40 60 37
16 Rayo Sanluqueño Rayo 34 47 64 35
17 CD Jédula CD Jédula 33 29 70 27
18 Chipiona CF Chipiona CF 33 25 73 18
TEMPORADA 2016/2017
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Chiclana Industrial Chiclana 34 75 29 73
2 Balón de Cádiz CF Balón 34 91 40 67
3 Trebujena CF Trebujena 33 62 26 67
4 Jerez Industrial Cf Jerez 34 85 40 65
5 Grupo Empresa Bazán CF Grupo 33 70 48 59
6 CD UD Villamartín Villamartín 34 71 43 59
7 Tesorillo Tesorillo 33 70 59 57
8 Guadiaro Guadiaro 34 56 54 49
9 CD El Torno 2009 Torno 2009 33 44 43 49
10 San Jose Obrero UD Jose Obrero 34 55 61 43
11 Chipiona CF Chipiona CF 33 51 70 42
12 CD Jédula CD Jédula 33 50 55 41
13 Recreativo Portuense Recreativo 34 49 57 40
14 At. Sanluqueño B Sanluqueño 34 55 71 37
15 Estella Cd Estella Cd 33 36 79 28
16 AD Los Cortijillos Cortijillos 33 29 74 23
17 Algeciras CF B Algeciras 33 30 69 19
18 CD Rivera CD Rivera 33 30 91 18
TEMPORADA 2015/2016
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Xerez Deportivo Xerez 31 89 12 85
2 Trebujena CF Trebujena 32 64 41 62
3 CD Jédula CD Jédula 32 62 46 56
4 Guadiaro Guadiaro 31 53 39 51
5 CD Rivera CD Rivera 32 55 40 48
6 Estella Cd Estella Cd 32 61 60 48
7 CD El Torno 2009 Torno 2009 31 46 42 48
8 San Jose Obrero UD Jose Obrero 31 59 45 47
9 Balón de Cádiz CF Balón 31 66 61 45
10 Barbate Barbate 32 43 62 43
11 Tesorillo Tesorillo 30 64 47 42
12 Chiclana Industrial Chiclana 31 46 41 42
13 Novo Chiclana Novo 32 42 70 32
14 Puerto Real CF Puerto Real 31 33 61 32
15 San Bernardo Bernardo 31 39 73 30
16 Florida Florida 29 49 97 19
17 CD Balona Balompié CF Balona 23 24 58 12
TEMPORADA 2014/2015
3ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Xerez Deportivo Xerez 28 126 12 77
2 Guadiaro Guadiaro 28 65 25 63
3 Florida Florida 28 55 49 52
4 CD El Torno 2009 Torno 2009 28 65 41 51
5 Ubrique UD Ubrique UD 28 63 41 49
6 J. Sanluqueña Sanluqueña 28 56 51 48
7 San Fernando CD B Fernando 28 56 49 41
8 CD Vejer Balompié Vejer 28 48 46 38
9 Tarifa UD Tarifa UD 28 44 48 38
10 San Benito San Benito 28 50 60 33
11 Prado del Rey Prado 28 39 61 28
12 Federico Mayo C.F. Federico 28 35 60 28
13 Atletico San Roque Atletico 28 37 71 25
14 Espera C.F. Espera C.F. 28 41 69 23
15 Español de Vejer Español 28 17 114 4
16 Puerto Serrano Atco. Puerto 0 0 0 0
TEMPORADA 2013/2014
3ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Xerez Deportivo Xerez 26 95 18 73
2 Guadiaro Guadiaro 27 74 34 50
3 Cañorrera Cañorrera 27 47 33 49
4 San Fernando C. Fernando 26 67 24 49
5 Ubrique Ind. Ubrique Ind. 25 62 27 48
6 FSD Puertollano Puertollano 26 38 19 47
7 CD El Torno 2009 Torno 2009 25 54 37 40
8 Chiclana Ind. Chiclana 26 48 44 40
9 Ciudad de Chiclana Ciudad 26 48 45 40
10 Ud Bornense Ud Bornense 26 59 50 39
11 Union Puertorrealeña Union 25 49 55 35
12 Novo Gazul 2012 Novo Gazul. 25 28 50 28
13 Xerez Balompié Xerez 25 22 54 24
14 Atlético Pastores Atlético 25 43 59 24
15 Cádiz 1812 C.F. Cádiz 1812 25 37 52 23
16 Federico Mayo C.F. Federico 27 27 82 20
17 El Bosque El Bosque 25 23 68 17
18 Juventud Torrecera Juventud 27 36 106 14
19 R. Portuense Portuense 0 0 0 0
TEMPORADA 2004/2005
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Tesorillo Tesorillo 30 60 24 68
2 Algeciras CF B Algeciras 30 66 23 65
3 Ubrique Ind. Ubrique Ind. 30 47 29 51
4 Conil Conil 30 49 31 49
5 Rayo Sanluqueño Rayo 30 56 41 49
6 Chipiona CF Chipiona CF 30 38 26 47
7 Chiclana Ind. Chiclana 30 49 43 44
8 Palmones Palmones 30 37 38 39
9 Grupo Empresa Bazán CF Grupo 30 30 33 35
10 Ud Bornense Ud Bornense 30 35 48 35
11 CD UD Villamartín Villamartín 30 34 52 34
12 CD Guadalcacín Guadalcacín 30 37 51 32
13 Atletico San Roque Atletico 30 32 54 32
14 UD Algaida UD Algaida 30 33 44 31
15 Guadiaro Guadiaro 30 30 68 27
16 San Fernando C. Fernando 30 30 58 18
TEMPORADA 2002/2003
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Chiclana Ind. Chiclana 30 57 24 63
2 R. Portuense Portuense 30 54 26 62
3 Cádiz CF Mirandilla Cádiz 30 68 33 61
4 Los Cortijillos Cortijillos 30 46 29 58
5 Xerez B Xerez B 30 55 27 56
6 Chiclana CF Chiclana CF 30 47 38 50
7 CD Rota CD Rota 30 71 38 49
8 Chipiona CF Chipiona CF 30 44 45 44
9 Atletico San Roque Atletico 30 44 38 41
10 CD UD Villamartín Villamartín 30 31 37 38
11 Ac Nueva Jarilla Nueva 30 30 41 38
12 Roteña Roteña 30 49 47 37
13 Ubrique Ind. Ubrique Ind. 30 35 49 35
14 Rayo Sanluqueño Rayo 30 44 55 34
15 Barbate Barbate 30 33 50 34
16 Grupo Empresa Bazán CF Grupo 30 41 56 33
17 Carolinense Carolinense 30 27 56 29
18 San Fernando C. Fernando 30 42 54 28
19 Guadiaro Guadiaro 30 43 71 23
20 San Bernardo Bernardo 30 34 81 16

  USO DE MEMORIA  
6,587,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1296
Total Execution Time  0.1307
  CADENA URL  
/historico/Guadiaro
  GET DATOS  
$_GET['/historico/Guadiaro']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0062  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 = 'Guadiaro' 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.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=13927 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=13927 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=13927 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0059  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 = 73624
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13927 AND type_rel = 2
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 = '13927' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73624 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=13927 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 (73624,71432) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73624 AND teamId = 13927
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13927
0.0021  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 = '13927' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13927' and rp.type = 4
0.0023  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 = '13927' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044  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 = 73624 WHERE rp.league_id = 73624 AND rp.teamId = 13927 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.0040  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 = 73624 WHERE rp.league_id = 73624 AND rp.teamId = 13927 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 73624 WHERE rp.league_id = 73624 AND rp.teamId = 13927 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 13927 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73624 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.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 `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 = 68699 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.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 `tables2022` 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 = 64021 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.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` 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 = 67384 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.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 `tables2021` 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 = 62158 AND t.round = 6 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` 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 = 58973 AND t.round = 22 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 `tables2020` 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 = 51363 AND t.round = 25 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 `tables2019` 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 = 44621 AND t.round = 34 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` 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 = 39325 AND t.round = 34 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 `tables2017` 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 = 34152 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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` 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 = 16808 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 `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 = 4112 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 `tables2014` 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 = 2996 AND t.round = 38 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 `tables2005` 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 = 2917 AND t.round = 30 ORDER BY team.conference 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 `tables2003` 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 = 2915 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC