4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sporting Chiclana CD
TEMPORADA 2022/2023
3ª ANDALUZA CÁDIZ CADETE GRUPO 5
Equipo PJ GF GC Puntos
1 CD Escuela Bahia San Fernan Escuela 28 158 14 69
2 Ciudad de Cadiz B Ciudad Cadiz 28 112 26 69
3 Chiclana Chiclana 56 117 167 69
4 Barbate Barbate 28 107 36 64
5 Sancti-Petri APA AD Sancti-Petri 28 93 49 62
6 Medina Balompié Medina 28 81 47 54
7 CD Benalup CD Benalup 28 87 44 51
8 Futbol Vejer Futbol Vejer 28 89 42 50
9 Sporting Chiclana CD Sporting 28 44 76 31
10 CD Fair Play Futbol Fair Play F. 28 50 97 31
11 Conil B Conil B 28 49 80 27
12 Pastora 1966 B Pastora 1966 28 31 134 14
13 Club Deportivo de Futbol Fr Club 28 20 88 10
14 Novo Chiclana CD Novo 28 23 161 5
TEMPORADA 2021/2022
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 CD San Roque Roque 32 113 62 70
2 Atlético Sanluqueño Sub 16 Atlético 32 98 49 68
3 CD Comarca de Jerez Comarca 32 97 43 64
4 Sporting Chiclana CD Sporting 32 85 35 61
5 Atlético Zabal Atlético 32 86 45 61
6 Wea Sierra de Cadiz Sierra Cadiz 32 68 49 55
7 Algeciras B CF Algeciras 32 70 45 53
8 Conil Conil 32 79 76 49
9 Xerez Deportivo A Xerez 32 64 58 46
10 Tiempo Libre Tiempo Libre 32 61 58 44
11 Sancti Petri A Sancti Petri 32 63 75 41
12 Estrella Portuense Estrella 32 54 71 37
13 Pueblo Nuevo La Granja Pueblo Nuevo 32 49 61 35
14 Loluba A Loluba A 32 46 81 26
15 Ciudad de Algeciras Ciudad 32 40 108 22
16 CD San Fernando Atlético Fernando 32 40 89 18
17 La Salle A La Salle A 32 34 142 9
TEMPORADA 2020/2021
2ª ANDALUZA CÁDIZ CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Sancti Petri A Sancti Petri 15 47 16 37
2 Sporting Chiclana CD Sporting 14 35 8 34
3 Algeciras B CF Algeciras 14 31 17 30
4 Conil Conil 14 22 16 23
5 Loluba A Loluba A 14 33 28 19
6 Ciudad de Algeciras Ciudad 15 17 34 15
7 Tarifa Tarifa 14 15 33 13
8 San Fernando Isleño A Fernando 14 18 42 7
9 CD Cadistas La Isla Cadistas 14 9 33 7
TEMPORADA 2019/2020
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 Balón De Cádiz CF B Balón 23 83 15 57
2 Monitores Algeciras A Monitores 23 70 12 56
3 Xerez Deportivo A Xerez 23 73 25 51
4 Sancti Petri A Sancti Petri 23 59 28 44
5 Algeciras B CF Algeciras 23 58 35 44
6 La Salle A La Salle A 23 45 25 40
7 San Fernando Isleño A Fernando 23 36 48 34
8 CD Guadalcacín A Guadalcacín 23 44 49 31
9 CD Cadistas La Isla Cadistas 23 40 47 29
10 Estrella Portuense Estrella 23 32 43 25
11 Sporting Chiclana CD Sporting 23 35 63 25
12 Tarifa Tarifa 23 21 39 21
13 Conil Conil 23 25 62 20
14 Rvo Portuense Club Futbol B Portuense 23 27 70 18
15 Divina Pastora Sanluqueña A Divina 23 32 58 16
16 Atco. Sanluqueño CF Atco. 23 29 90 11
TEMPORADA 2018/2019
3ª ANDALUZA CÁDIZ CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Sporting Chiclana CD Sporting 26 111 31 66
2 Barbate Barbate 26 98 27 64
3 APA Sancti Petri Sancti Petri 26 86 37 57
4 Novo Chiclana CD Novo 26 75 36 49
5 Futbol Vejer Futbol Vejer 26 66 45 49
6 Fair Play Futbol CD Fair Play F. 26 67 52 43
7 CD Benalup CD Benalup 26 57 45 41
8 Cañorrera Cañorrera 26 69 68 39
9 Sanix La Isla Sanix Isla 26 52 57 35
10 Conil Conil 26 44 66 20
11 Tiempo Libre Tiempo Libre 26 44 70 20
12 Chiclana Ind. CF Chiclana 26 32 63 20
13 Medina Balompié Medina 26 27 79 19
14 Nueva Vida Nueva Vida 26 16 168 3
15 Futbol Sanix Chiclana Futbol Sanix 0 0 0 0
16 Grupo Empresa Bazan Grupo 0 0 0 0
TEMPORADA 2017/2018
3ª ANDALUZA CÁDIZ CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Chiclana CF A Chiclana 30 111 27 81
2 Futbol Vejer Futbol Vejer 30 103 44 71
3 Sancti-Petri B Sancti-Petri 30 84 35 69
4 CD Benalup CD Benalup 30 86 49 57
5 Medina Balompié Medina 30 88 55 56
6 Barbate Barbate 30 87 58 52
7 Sporting Chiclana CD Sporting 30 78 66 50
8 Tiempo Libre Tiempo Libre 30 90 62 49
9 Escuela Bahia San Fernando Escuela 30 60 52 48
10 Sporting Conil Sporting 30 75 67 43
11 Sanix La Isla B Sanix Isla 30 59 85 27
12 Rivera Rivera 30 65 97 27
13 Olimpico B Olimpico B 30 48 90 22
14 Chiclana Industrial Chiclana 30 50 132 14
15 Burreños Asociación Burreños 30 41 108 12
16 Novo Chiclana B Novo 30 34 132 9
TEMPORADA 2016/2017
3ª ANDALUZA CÁDIZ CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Conil Conil 32 186 19 83
2 San Fernando CD Isleño Fernando 32 147 16 81
3 Sancti-Petri B Sancti-Petri 32 114 41 77
4 Medina Balompié A Medina 32 151 38 76
5 Barbate Barbate 32 130 40 66
6 Chiclana CF A Chiclana 32 122 54 63
7 Futbol Vejer Futbol Vejer 32 99 60 57
8 CD Benalup CD Benalup 32 108 64 51
9 Burreños Asociación Burreños 32 109 64 45
10 Sporting Chiclana CD Sporting 32 85 73 44
11 Escuela Bahia San Fernando Escuela 32 76 82 42
12 Tiempo Libre Tiempo Libre 32 68 86 34
13 Novo Chiclana B Novo 32 53 92 33
14 Chiclana Industrial Chiclana 32 48 186 16
15 Futbol Sanix Futbol Sanix 32 28 180 12
16 Olimpico B Olimpico B 32 21 213 7
17 Pastora 1966 Pastora 1966 32 12 249 3
TEMPORADA 2015/2016
3ª ANDALUZA CÁDIZ CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Novo Chiclana CD Novo 26 105 17 71
2 Santic Petri A Santic Petri 26 102 32 60
3 Conil Conil 26 93 32 55
4 Barbate Barbate 26 103 26 55
5 Futbol Vejer A Futbol Vejer 26 78 36 54
6 Chiclana CF A Chiclana 26 84 40 44
7 Medina Balompié A Medina 26 86 62 40
8 Chiclana Industrial Chiclana 26 63 46 37
9 San Fernando CD Isleño Fernando 26 65 48 35
10 CD Benalup CD Benalup 26 59 87 25
11 Sporting Chiclana CD Sporting 26 32 78 21
12 Burreños Asociación Burreños 26 28 119 13
13 Futbol Sanix Futbol Sanix 26 42 152 9
14 Sanix La Isla Sanix Isla 26 23 188 3
TEMPORADA 2014/2015
3ª ANDALUZA CÁDIZ CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 Barbate C.F. Barbate C.F. 22 90 18 57
2 Futbol Vejer Futbol Vejer 22 86 15 56
3 Chiclana Industrial Chiclana 22 59 21 53
4 APA Sancti Petri Sancti Petri 22 91 32 48
5 Medina Balompie CD Medina 22 66 32 35
6 Novo Chiclana CD Novo 22 53 40 30
7 CD Benalup CD Benalup 22 65 64 28
8 Fair Play Futbol CD Fair Play F. 22 48 54 28
9 Chiclana CF B Chiclana 22 43 61 23
10 Fútbol Sánix C.D. Fútbol 22 46 118 10
11 A.D. Burreños A.D. 22 20 115 7
12 Sporting Chiclana CD Sporting 22 24 121 5

  USO DE MEMORIA  
5,698,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6510
Total Execution Time  0.6524
  CADENA URL  
/historico/Sporting-Chiclana-Cd-Cadete
  GET DATOS  
$_GET['/historico/Sporting-Chiclana-Cd-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0131  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 = 'Sporting-Chiclana-Cd-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.0151  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 = 'Sporting-Chiclana-Cd-Cadete' 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.0127  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=20148 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=20148 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=20148 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=20148 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=20148 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=20148 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=20148 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=20148 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=20148 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=20148 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=20148 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=20148 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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 = 68954
0.0135  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 = 70174
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20148 AND type_rel = 2
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=447 AND type_rel = 3
0.0127  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 = '20148' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '20148' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0126  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 = '20148' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 68954 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 70174 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=20148 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (70174,68954) 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.0126  SELECT count(id) as num_players from rel_players_base WHERE league_id = 68954 AND teamId = 20148
0.0127  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70174 AND teamId = 20148
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 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 = 68954 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '20148' 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 = '20148' and rp.type = 4
0.0126  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 = '20148' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 20148 AND l.year <= 2023 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 `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 = 68954 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.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 `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 = 70174 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.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 `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 = 65015 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.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 `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 = 66039 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 59842 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.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 `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 = 52409 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.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 `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 = 45918 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 `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 = 40268 AND t.round = 30 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 `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 = 34461 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 17257 AND t.round = 26 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 `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 = 4329 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC