4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Guadalcacín A Sub 19
TEMPORADA 2023/2024
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 At. Zabal Sub 19 Zabal 27 57 24 59
2 CF Jerez Industrial Sub 19 Jerez 27 50 26 58
3 Sporting Chiclana Sub 19 Sporting 27 56 39 51
4 San Fernando Isleño Sub 19 Fernando 27 44 22 50
5 CD Guadalcacín A Sub 19 Guadalcacín 27 49 34 48
6 Xerez Deportivo Sub 19 Xerez 27 34 20 42
7 Estrella Portuense Sub 19 Estrella 27 33 38 38
8 CF Arcos A Sub 19 Arcos 27 46 40 36
9 Bahia San Fernando Sub 19 Bahia 27 36 39 35
10 CD San Roque Sub 19 Roque 27 32 43 34
11 Conil Sub 19 Conil 27 27 45 32
12 At. Sanluqueño B Sub 19 Sanluqueño 27 31 40 30
13 CD Rota Sub 19 Rota 27 36 48 29
14 CF Sherry Atlético Sub 19 Sherry 27 27 48 25
15 CF Chiclana Sub 19 Chiclana 27 29 54 24
16 San Fernando Atl. Sub 19 Fernando 27 24 51 16
TEMPORADA 2022/2023
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 La Salle Sub 19 Salle 29 79 37 65
2 At. Zabal Sub 19 Zabal 30 54 27 56
3 CF Chiclana Sub 19 Chiclana 30 56 39 54
4 San Fernando Atl. Sub 19 Fernando 29 67 39 49
5 At. Sanluqueño B Sub 19 Sanluqueño 29 67 46 49
6 San Fernando Isleño CD B Su Fernando 29 64 46 49
7 Sporting Chiclana Sub 19 Sporting 30 70 51 48
8 CF Arcos A Sub 19 Arcos 29 56 47 46
9 CD Guadalcacín A Sub 19 Guadalcacín 30 67 67 43
10 CD Rota Sub 19 Rota 30 50 45 36
11 CF Jerez Industrial Sub 19 Jerez 30 61 64 35
12 CD San Roque Sub 19 Roque 29 65 79 35
13 Estrella Portuense Sub 19 Estrella 30 53 70 34
14 San Jose Obrero UD A Jose Obrero 29 37 54 31
15 Guadiaro Guadiaro 30 47 76 25
16 Castellar Castellar 23 21 127 0
TEMPORADA 2021/2022
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 CD Guadalcacín A Sub 19 Guadalcacín 32 95 33 74
2 Xerez Deportivo Sub 19 Xerez 31 86 31 73
3 San Fernando Atl. Sub 19 Fernando 32 84 48 62
4 La Salle Sub 19 Salle 32 80 45 55
5 CF Arcos A Sub 19 Arcos 32 65 57 54
6 Castellar Castellar 31 61 51 52
7 San Fernando Isleño CD B Su Fernando 32 89 51 51
8 CF Chiclana Sub 19 Chiclana 32 55 44 48
9 CF Jerez Industrial Sub 19 Jerez 31 56 46 45
10 CD San Roque Sub 19 Roque 31 70 75 44
11 San Jose Obrero UD A Jose Obrero 29 40 56 41
12 Estrella Portuense Sub 19 Estrella 31 56 58 35
13 Chipiona CF A Chipiona 31 45 73 34
14 Algeciras B Algeciras B 32 42 68 24
15 Tarifa Tarifa 31 35 93 24
16 Vejer Balompie Vejer 32 32 101 20
17 Veteranos Xerez Veteranos 32 36 97 19
18 Wea Sierra de Cadiz Sierra Cadiz 0 0 0 0
TEMPORADA 2020/2021
2ª ANDALUZA CÁDIZ JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 At. Sanluqueño B Sub 19 Sanluqueño 18 45 24 41
2 San Jose Obrero UD A Jose Obrero 18 44 28 34
3 CD Guadalcacín A Sub 19 Guadalcacín 18 49 27 33
4 CF Arcos A Sub 19 Arcos 18 43 29 32
5 La Salle Sub 19 Salle 18 35 28 26
6 Chipiona CF A Chipiona 18 34 44 26
7 Wea Sierra de Cadiz Sierra Cadiz 18 44 36 25
8 Marianistas CD Marianistas 18 31 35 17
9 Trasmallo A Trasmallo A 18 22 57 10
10 Trebujena CF Trebujena 18 8 47 5
TEMPORADA 2019/2020
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 CD San Roque Roque 23 62 28 47
2 CF Chiclana Sub 19 Chiclana 23 54 24 46
3 CD Guadalcacín A Sub 19 Guadalcacín 23 52 20 45
4 San Fernando Isleño CD B Su Fernando 23 33 19 45
5 Wea Sierra de Cadiz Sierra Cadiz 23 55 21 44
6 CF Arcos A Sub 19 Arcos 23 56 34 44
7 Algeciras B Algeciras B 23 41 35 38
8 Conil Sub 19 Conil 23 40 36 37
9 La Salle Sub 19 Salle 23 44 39 33
10 At. Sanluqueño B Sub 19 Sanluqueño 23 50 41 32
11 Marianistas CD Marianistas 23 37 34 32
12 At. Zabal Sub 19 Zabal 23 39 36 31
13 San Jose Obrero UD A Jose Obrero 23 33 50 30
14 San Fernando Atl. Sub 19 Fernando 23 26 47 16
15 Trebujena CF Trebujena 23 11 83 4
16 Trasmallo A Trasmallo A 23 17 103 0
TEMPORADA 2018/2019
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 Balón De Cádiz Sub 19 Balón 30 94 20 76
2 CD Guadalcacín A Sub 19 Guadalcacín 30 51 28 61
3 Algeciras CF B Juvenil Algeciras 30 59 40 59
4 Conil Sub 19 Conil 30 54 32 57
5 Wea Sierra de Cadiz Sierra Cadiz 30 73 45 49
6 CD San Roque Roque 30 61 44 47
7 At. Sanluqueño B Sub 19 Sanluqueño 30 45 36 44
8 Balona Balompie Balona 30 54 53 43
9 CF Chiclana Sub 19 Chiclana 30 50 48 37
10 CF Arcos A Sub 19 Arcos 30 40 66 34
11 Trasmallo Trasmallo 30 45 70 33
12 San Fernando Atl. Sub 19 Fernando 30 36 54 32
13 San Jose Obrero UD A Jose Obrero 30 42 66 30
14 Tarifa Tarifa 30 34 61 28
15 At. Zabal Sub 19 Zabal 30 34 62 22
16 San Bernardo Bernardo 30 44 91 19
TEMPORADA 2017/2018
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 San Fernando Isleño Sub 19 Fernando 30 76 28 76
2 Balón De Cádiz Sub 19 Balón 30 84 27 71
3 Wea Sierra de Cadiz Sierra Cadiz 30 60 42 51
4 CD Guadalcacín A Sub 19 Guadalcacín 30 54 42 49
5 At. Sanluqueño B Sub 19 Sanluqueño 30 48 39 46
6 Balona Balompié Balona 29 60 56 40
7 Conil Sub 19 Conil 30 62 60 39
8 CD San Roque Sub 19 Roque 30 60 65 39
9 At. Zabal Sub 19 Zabal 29 50 49 38
10 San Fernando Atco. Fernando 30 42 55 38
11 Chiclana A Chiclana A 30 51 51 37
12 CF Arcos A Sub 19 Arcos 30 38 55 36
13 Tarifa Tarifa 30 52 60 35
14 Pueblo Nuevo La Granja Pueblo Nuevo 30 46 66 31
15 Roteña Roteña 30 40 76 29
16 C.D. Salesianos Algeciras C.D. 30 39 91 22
TEMPORADA 2016/2017
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 Algeciras CF Sub 19 Algeciras 34 118 38 91
2 San Fernando Isleño Sub 19 Fernando 34 102 47 70
3 Wea Sierra de Cadiz Sierra Cadiz 34 110 48 69
4 San Fernando Atco. Fernando 34 71 55 59
5 CF Arcos A Sub 19 Arcos 34 77 68 58
6 Balona Balompié Balona 34 94 71 56
7 C.D. Salesianos Algeciras C.D. 33 84 63 55
8 CD Guadalcacín A Sub 19 Guadalcacín 34 76 57 55
9 At. Sanluqueño B Sub 19 Sanluqueño 34 67 61 49
10 Chiclana A Chiclana A 33 71 69 49
11 Conil Sub 19 Conil 34 57 57 47
12 Tarifa Tarifa 34 57 70 45
13 Divina Pastora Sanluqueña A Divina 34 66 83 44
14 Xerez Deportivo B Xerez 34 41 67 37
15 Tiempo Libre A.D. Tiempo Libre 34 51 74 35
16 San Jose Obrero UD A Jose Obrero 33 54 74 32
17 Xerez CD SAD Xerez 34 29 118 13
18 Rvo Portuense Club Futbol B Portuense 33 22 127 4
TEMPORADA 2015/2016
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 Xerez Deportivo FC Sub 19 Xerez 32 68 23 70
2 CD Guadalcacín A Sub 19 Guadalcacín 32 63 38 65
3 Algeciras CF Sub 19 Algeciras 31 70 46 56
4 Tiempo Libre A.D. Tiempo Libre 32 67 41 54
5 Balona Balompié Balona 32 82 46 52
6 Conil Sub 19 Conil 32 58 52 49
7 Tarifa Tarifa 32 59 59 47
8 San Fernando Isleño Sub 19 Fernando 32 69 48 47
9 Divina Pastora Divina 32 57 47 46
10 CF Arcos A Sub 19 Arcos 32 81 70 46
11 San Jose Obrero UD A Jose Obrero 32 56 60 44
12 Rvo Portuense Club Fútbol B Portuense 32 50 76 37
13 At. Sanluqueño B Sub 19 Sanluqueño 32 54 63 36
14 At. Zabal Sub 19 Zabal 32 52 72 35
15 AD Taraguilla Juvenil Taraguilla 32 65 88 33
16 CD La Salle CD La Salle 32 40 82 28
17 CD Rota Sub 19 Rota 31 37 117 11
TEMPORADA 2014/2015
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 CF Chiclana Sub 19 Chiclana 30 87 31 73
2 CD Guadalcacín A Sub 19 Guadalcacín 30 75 20 71
3 Tiempo Libre A.D. Tiempo Libre 30 62 39 53
4 San Fernando Isleño Sub 19 Fernando 30 60 31 52
5 Algeciras CF Sub 19 Algeciras 30 60 34 50
6 CF Arcos A Sub 19 Arcos 30 71 57 48
7 At. Zabal Sub 19 Zabal 30 80 50 47
8 Conil Sub 19 Conil 30 51 41 47
9 CD La Salle CD La Salle 30 42 44 42
10 San Jose Obrero UD A Jose Obrero 30 42 52 42
11 At. Sanluqueño B Sub 19 Sanluqueño 30 61 66 40
12 Balona Balompié Balona 30 54 71 37
13 Villa de los Barrios Villa 30 45 79 32
14 Chiclana Industrial Chiclana 30 35 84 19
15 Xerez CD SAD Xerez 30 23 77 18
16 Liberación Liberación 30 26 98 9
TEMPORADA 2013/2014
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 Balón De Cádiz Sub 19 Balón 18 85 17 48
2 San Fernando Isleño Sub 19 Fernando 18 42 11 41
3 CF Chiclana Sub 19 Chiclana 18 44 21 36
4 At. Zabal Sub 19 Zabal 18 45 30 35
5 Tiempo Libre A.D. Tiempo Libre 18 32 28 28
6 La Salle Puerto Real Salle Puerto 18 35 35 28
7 At. Sanluqueño B Sub 19 Sanluqueño 18 37 35 28
8 Conil Sub 19 Conil 18 24 27 23
9 Villa de los Barrios Villa 18 27 41 22
10 Domingo Savio Domingo 18 26 36 21
11 CD Guadalcacín A Sub 19 Guadalcacín 18 26 31 20
12 Tarifa Tarifa 18 27 44 20
13 Chiclana Industrial Chiclana 18 23 30 18
14 Liberación Liberación 18 26 35 17
15 Federico Mayo C.F. Federico 18 29 63 15
16 Don Benito Don Benito 18 11 55 8
TEMPORADA 2012/2013
2ª ANDALUZA CÁDIZ JUVENIL
Equipo PJ GF GC Puntos
1 At. Sanluqueño B Sub 19 Sanluqueño 32 95 26 82
2 Balón De Cádiz Sub 19 Balón 32 74 27 68
3 San Fernando Atco. Fernando 32 59 38 61
4 Federico Mayo C.F. Federico 32 75 39 60
5 C.D. Novo Chiclana C.D. Novo C. 32 74 41 58
6 Conil Sub 19 Conil 32 63 43 57
7 At. Zabal Sub 19 Zabal 32 55 53 45
8 CD Guadalcacín A Sub 19 Guadalcacín 32 51 51 44
9 R. Portuense Portuense 32 54 51 43
10 Domingo Savio Domingo 32 40 46 42
11 Liberación Liberación 32 36 38 40
12 Tiempo Libre A.D. Tiempo Libre 32 41 54 40
13 La Salle Puerto Real Salle Puerto 32 45 57 36
14 Pueblo Nuevo La Granja Pueblo Nuevo 32 49 59 31
15 CD San Roque Sub 19 Roque 32 41 66 29
16 Algeciras CF Sub 19 Algeciras 32 19 104 14
17 Safa San Luis Safa Luis 32 24 102 12

  USO DE MEMORIA  
6,062,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.5344
Total Execution Time  0.5356
  CADENA URL  
/historico/Guadalcacin
  GET DATOS  
$_GET['/historico/Guadalcacin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0153  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 = 'Guadalcacin' 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.0146  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=14285 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=14285 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14285 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=433 AND type_rel = 3
0.0148  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 = '14285' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '14285' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 73829 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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=14285 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (73829) 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.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 73829 AND teamId = 14285
0.0147  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 = 73829 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '14285' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '14285' and rp.type = 4
0.0146  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 = '14285' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0148  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 = 14285 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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 = 73829 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.0149  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 = 68952 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.0166  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 = 65908 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.0148  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 = 59154 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.0151  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 = 51946 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.0149  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 = 45694 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 39947 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 34207 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 17028 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 4269 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 3026 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2013_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 = 3120 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC