4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Jédula
TEMPORADA 2023/2024
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 AD Taraguilla Taraguilla 0 0 0 0
2 At. Sanluqueño B Sanluqueño 0 0 0 0
3 Athletic Nueva Jarilla Athletic 0 0 0 0
4 Barbate Barbate 0 0 0 0
5 CD Jédula CD Jédula 0 0 0 0
6 CD Ubrique CD Ubrique 0 0 0 0
7 CD UD Villamartín Villamartín 0 0 0 0
8 CD Vejer Balompié Vejer 0 0 0 0
9 Chiclana Industrial Chiclana 0 0 0 0
10 Chipiona CF Chipiona CF 0 0 0 0
11 J. Sanluqueña Sanluqueña 0 0 0 0
12 Olvera Olvera 0 0 0 0
13 RB Linense B Linense 0 0 0 0
14 Recreativo Portuense Recreativo 0 0 0 0
15 San Jose Atletico Jose 0 0 0 0
16 Tarifa UD Tarifa UD 0 0 0 0
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 15
Equipo PJ GF GC Puntos
1 Balón de Cádiz CF Balón 28 70 27 67
2 UD Algaida UD Algaida 28 54 26 61
3 Xerez Deportivo B Xerez 28 59 33 57
4 RC Portuense Portuense 28 52 25 53
5 Roteña Roteña 28 40 34 43
6 San Fernando CD B Fernando 28 48 47 40
7 Trebujena CF Trebujena 28 37 37 40
8 CD Jédula CD Jédula 28 37 49 38
9 CD UD Villamartín Villamartín 28 35 41 35
10 Recreativo Portuense Recreativo 28 32 47 28
TEMPORADA 2020/2021
2ª ANDALUZA CÁDIZ GRUPO 1
Equipo PJ GF GC Puntos
1 Rayo Sanluqueño Rayo 16 37 12 36
2 CD Jédula CD Jédula 15 31 13 28
3 Castellar UD Castellar 16 29 22 28
4 Aficion Xerecista Aficion 16 24 20 24
5 San Jose Obrero UD Jose Obrero 16 20 22 20
6 Ud Bornense Ud Bornense 16 24 26 19
7 Divina Pastora Sanluqueña Divina 16 28 34 18
8 J. Sanluqueña Sanluqueña 15 21 27 18
9 Alma de África Alma África 16 17 55 7
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
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 San Bernardo Bernardo 34 73 41 76
2 Puerto Real CF Puerto Real 34 75 36 74
3 Chipiona CF Chipiona CF 34 67 33 72
4 Barbate Barbate 33 75 46 69
5 Los Cortijillos Cortijillos 34 62 34 63
6 Espera C.F. Espera C.F. 34 62 37 56
7 CD Jédula CD Jédula 34 68 44 56
8 At. Sanluqueño B Sanluqueño 34 57 40 51
9 Medina Balompié Medina 33 59 48 50
10 San Jose Obrero UD Jose Obrero 34 51 63 40
11 Rayo Sanluqueño Rayo 34 55 76 39
12 C.D. La Salle C.D. Salle 34 36 57 38
13 Estrella Portuense FC Estrella 34 34 60 34
14 Juventud Jerez Industrial Juventud 34 47 68 33
15 Divina Pastora Sanluqueña Divina 34 52 76 31
16 San Jose Atletico Jose 34 44 70 30
17 Facinas Facinas 34 37 86 26
18 Prado del Rey Prado 34 40 79 19
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
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Recreativo Portuense Recreativo 28 51 21 58
2 Algeciras CF B Algeciras 28 59 26 54
3 CD Jédula CD Jédula 28 61 37 54
4 San Bernardo Bernardo 28 48 42 42
5 San Jose Obrero UD Jose Obrero 28 45 39 42
6 Tesorillo Tesorillo 28 45 41 41
7 Novo Chiclana Novo 28 41 36 38
8 Barbate Barbate 28 44 40 37
9 Estella Cd Estella Cd 28 39 47 35
10 CD Rivera CD Rivera 28 34 43 34
11 Puerto Real CF Puerto Real 28 43 56 34
12 Trebujena CF Trebujena 28 45 67 32
13 Pueblo Nuevo Granja Pueblo Nuevo 28 33 53 29
14 Xerez Cd B Xerez Cd B 28 43 61 24
15 Rayo Sanluqueño Rayo 28 29 51 22
16 CD Portorrealeña Portorreale 0 0 0 0
TEMPORADA 2013/2014
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 CD UD Villamartín Villamartín 30 60 36 58
2 Los Cortijillos Cortijillos 30 46 32 58
3 Algeciras CF B Algeciras 30 58 26 54
4 CD Rivera CD Rivera 30 46 31 54
5 CD Balona Balompié CF Balona 30 55 43 51
6 Pueblo Nuevo La Granja Pueblo Nuevo 30 46 46 49
7 Estella Cd Estella Cd 30 52 35 47
8 Recreativo Portuense Recreativo 30 50 38 46
9 Barbate Barbate 30 40 44 39
10 Rayo Sanluqueño Rayo 30 44 46 39
11 CD Jédula CD Jédula 30 40 48 39
12 Atletico El Gastor Atletico 30 43 54 35
13 Tarifa UD Tarifa UD 30 43 59 34
14 Athletic Nueva Jarilla Athletic 30 38 46 34
15 Cdg Don Benito Benito 30 42 86 24
16 Federico Mayo C.F. Federico 30 24 57 16
TEMPORADA 2009/2010
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 CD Guadalcacín Guadalcacín 29 60 32 57
2 Ac Nueva Jarilla Nueva 29 64 37 53
3 Deportes Romero Deportes 29 48 31 48
4 Barbate Barbate 29 43 29 48
5 Chiclana Industrial Chiclana 29 44 34 48
6 Ud Bornense Ud Bornense 29 52 47 48
7 UD Algaida UD Algaida 29 49 40 47
8 Chipiona CF Chipiona CF 29 48 39 46
9 Trebujena CF Trebujena 29 48 48 39
10 CD UD Villamartín Villamartín 29 40 55 36
11 Atletico El Gastor Atletico 29 47 53 35
12 Rayo Sanluqueño Rayo 29 31 43 35
13 Tesorillo Tesorillo 29 34 44 31
14 CD Jédula CD Jédula 29 48 50 30
15 Espera C.F. Espera C.F. 29 21 63 21
16 Palmones Palmones 15 12 44 2

  USO DE MEMORIA  
6,129,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5200
Total Execution Time  0.5213
  CADENA URL  
/historico/C-D-Jedula
  GET DATOS  
$_GET['/historico/C-D-Jedula']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0179  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 = 'C-D-Jedula' 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.0129  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=13858 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=13858 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13858 AND type_rel = 2
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13858 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (179462) ORDER BY n.cover_points DESC, update_date DESC
0.0129  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 = '13858' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '13858' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  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=13858 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130  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 (73678,68699) 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 = 68699 AND teamId = 13858
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73678 AND teamId = 13858
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 = '13858' 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 = '13858' and rp.type = 4
0.0127  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 = '13858' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 73678 WHERE rp.league_id = 73678 AND rp.teamId = 13858 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.0126  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 = 73678 WHERE rp.league_id = 73678 AND rp.teamId = 13858 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 73678 WHERE rp.league_id = 73678 AND rp.teamId = 13858 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 = 13858 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 73678 AND t.round = 27 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 `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.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 `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.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` 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 = 67383 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.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 `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 = 59425 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.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` 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.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 `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 = 45002 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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.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 `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.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 `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.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 = 4105 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 2586 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2010` 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 = 2922 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC