4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Burgalés
TEMPORADA 2023/2024
1ª CASTILLA Y LEÓN GRUPO 3
Equipo PJ GF GC Puntos
1 CD Juventud CD Juventud 24 53 16 58
2 Burgos International Burgos 23 60 13 57
3 Capiscol Capiscol 23 46 22 44
4 Alcazar CD Alcazar CD 25 54 39 43
5 Gamonal Gamonal 24 57 40 43
6 CD Raudense CD Raudense 24 46 33 41
7 Polideportivo Salas Polideportiv 24 54 34 40
8 Trespaderne Trespaderne 23 46 36 38
9 Montija Montija 24 48 48 28
10 Villarcayo Nela B Villarcayo 24 29 47 24
11 San Cristóbal Castilla Cristóbal 24 26 53 21
12 San Pedro San Pedro 23 23 59 17
13 Vadillos Vadillos 22 27 67 12
14 CD Burgalés Burgalés 19 22 51 10
15 Arandina CF B Arandina 6 5 38 0
TEMPORADA 2022/2023
1ª CASTILLA Y LEÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Belorado Belorado 28 75 25 72
2 Burgos International Burgos 28 65 27 60
3 CD Burgalés Burgalés 28 66 22 59
4 CD Juventud CD Juventud 28 61 21 54
5 Gamonal Gamonal 27 52 30 54
6 Capiscol Capiscol 28 60 37 48
7 Polideportivo Salas Polideportiv 28 56 40 43
8 Alcazar CD Alcazar CD 28 42 45 38
9 Villarcayo Nela B Villarcayo 28 33 39 37
10 CD Raudense CD Raudense 27 61 58 35
11 Vadillos Vadillos 28 39 63 26
12 San Cristóbal Castilla Cristóbal 28 30 54 21
13 Condado de Castilla Condado 28 36 83 17
14 Montija Montija 28 32 95 14
15 Cerezo Cerezo 28 32 101 10
TEMPORADA 2021/2022
PREFERENTE C. LEÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Becerril Becerril 30 59 12 75
2 Unami CP Unami CP 30 68 24 74
3 Turégano Turégano 30 53 28 59
4 Palencia Cristo Atlético B Palencia 30 72 42 56
5 CD San José José 30 55 44 54
6 CD Villamuriel Villamuriel 30 67 49 49
7 CD La Granja Granja 30 59 45 48
8 CF Briviesca Briviesca 30 45 36 46
9 Villarcayo Nela Villarcayo 30 37 39 42
10 Calasanz de Soria Calasanz 30 50 54 37
11 SC Uxama SC Uxama 30 46 53 37
12 Polideportivo Salas Polideportiv 30 35 55 29
13 Racing Lermeño CF Racing 30 37 58 29
14 Monteresma Atalaya Monteresma 30 35 87 23
15 CD Burgalés Burgalés 30 21 50 22
16 Tardelcuende Tardelcuende 30 10 73 5
17 Real Burgos CF Real Burgos 0 0 0 0
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Palencia Cristo Atlético Palencia 20 29 11 44
2 Atl. Astorga Atl. Astorga 20 26 11 35
3 Júpiter Leonés Júpiter 20 25 18 35
4 La Virgen del Camino Virgen 20 22 18 31
5 Atlético Tordesillas Atlético 20 21 22 26
6 Atl. Bembibre Atl. 20 17 20 26
7 La Bañeza La Bañeza 20 23 23 25
8 Salamanca UDS B Salamanca 20 17 26 22
9 UD Santa Marta Santa Marta 20 14 17 21
10 Peñaranda Bracamonte Peñaranda 20 13 28 16
11 Becerril Becerril 20 10 23 15
12 Gimnástica Segoviana Gimnástica 22 54 10 57
13 Burgos CF B Burgos CF B 22 33 15 40
14 Numancia B Numancia B 22 40 34 39
15 Arandina Arandina 22 41 31 36
16 Mirandés B Mirandés B 22 30 21 33
17 Real Ávila Real Ávila 22 25 23 31
18 SD Almazán SD Almazán 22 26 31 31
19 DiocesÁvila - UCAV DiocesÁvila 22 19 42 23
20 CD La Granja Granja 22 24 30 22
21 Real Burgos CF Real Burgos 22 18 37 19
22 Cebrereña Cebrereña 22 18 36 19
23 CD Burgalés Burgalés 22 17 35 17
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Zamora Zamora 28 63 15 73
2 Gimnástica Segoviana Gimnástica 29 57 20 70
3 Arandina Arandina 28 44 17 59
4 Numancia B Numancia B 28 51 18 57
5 Burgos CF B Burgos CF B 29 45 21 55
6 Palencia Cristo Atlético Palencia 28 40 18 51
7 Atl. Astorga Atl. Astorga 28 46 26 50
8 Real Ávila Real Ávila 28 35 28 44
9 Salamanca UDS B Salamanca 29 37 39 42
10 SD Almazán SD Almazán 29 36 40 38
11 Real Burgos CF Real Burgos 29 36 39 36
12 Júpiter Leonés Júpiter 29 40 50 35
13 CD Burgalés Burgalés 29 26 33 34
14 UD Santa Marta Santa Marta 29 24 32 32
15 Becerril Becerril 28 30 46 32
16 La Virgen del Camino Virgen 29 33 54 30
17 Atlético Tordesillas Atlético 28 27 40 25
18 La Bañeza La Bañeza 29 20 56 21
19 Mirandés B Mirandés B 29 24 54 20
20 Atl. Bembibre Atl. 28 17 40 19
21 CD La Granja Granja 29 25 70 16
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Zamora Zamora 38 94 22 90
2 Gimnástica Segoviana Gimnástica 38 77 24 87
3 Arandina Arandina 38 71 16 83
4 Numancia B Numancia B 38 69 25 80
5 Atl. Astorga Atl. Astorga 38 86 35 77
6 Real Ávila Real Ávila 38 53 32 68
7 Palencia Cristo Atlético Palencia 38 61 55 58
8 Júpiter Leonés Júpiter 38 57 47 57
9 La Virgen del Camino Virgen 38 41 55 54
10 Burgos CF B Burgos CF B 38 42 43 54
11 Atlético Tordesillas Atlético 38 41 45 53
12 SD Almazán SD Almazán 38 49 56 49
13 UD Santa Marta Santa Marta 38 36 58 37
14 Atl. Bembibre Atl. 38 27 46 35
15 La Bañeza La Bañeza 38 38 72 34
16 CD Burgalés Burgalés 38 36 59 32
17 CD La Granja Granja 38 35 81 28
18 CF Briviesca Briviesca 38 28 68 27
19 Cebrereña Cebrereña 38 29 65 25
20 SC Uxama SC Uxama 38 24 90 16
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Unionistas CF Unionistas 38 72 34 80
2 Arandina Arandina 38 79 26 77
3 Palencia Cristo Atlético Palencia 38 69 38 74
4 Salamanca UDS Salamanca 38 74 35 74
5 Atl. Astorga Atl. Astorga 38 66 34 73
6 Atlético Tordesillas Atlético 38 66 40 72
7 La Bañeza La Bañeza 38 53 52 68
8 Numancia B Numancia B 38 55 30 66
9 Zamora Zamora 38 51 41 58
10 Real Ávila Real Ávila 38 50 49 52
11 La Virgen del Camino Virgen 38 41 54 42
12 Cebrereña Cebrereña 38 55 66 42
13 Atl. Bembibre Atl. 38 40 61 38
14 SD Almazán SD Almazán 38 38 51 38
15 CD Burgalés Burgalés 38 44 56 37
16 Burgos CF B Burgos CF B 38 38 61 35
17 SC Uxama SC Uxama 38 39 61 33
18 Real Burgos CF Real Burgos 38 31 82 32
19 Becerril Becerril 38 42 73 32
20 CD San José José 38 26 85 18
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Gimnástica Segoviana Gimnástica 38 97 22 91
2 Atl. Astorga Atl. Astorga 38 83 37 80
3 Unionistas CF Unionistas 38 77 29 78
4 Palencia Cristo Atlético Palencia 38 73 35 76
5 SD Almazán SD Almazán 38 69 47 68
6 Zamora Zamora 38 51 42 60
7 Real Ávila Real Ávila 38 65 55 54
8 Numancia B Numancia B 38 55 55 53
9 La Virgen del Camino Virgen 38 56 56 50
10 Atl. Bembibre Atl. 38 42 51 48
11 CD Burgalés Burgalés 38 53 53 48
12 La Bañeza La Bañeza 38 49 52 47
13 CD San José José 38 39 68 45
14 Atlético Tordesillas Atlético 38 53 70 44
15 Burgos CF B Burgos CF B 38 39 55 43
16 Cebrereña Cebrereña 38 38 55 41
17 SC Uxama SC Uxama 38 37 45 41
18 CD Villamuriel Villamuriel 38 35 49 37
19 Mirandés B Mirandés B 38 26 49 37
20 CD Villaralbo Villaralbo 38 27 139 13
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Zamora Zamora 38 75 29 84
2 Gimnástica Segoviana Gimnástica 38 74 32 77
3 CD Palencia Balompié Palencia 38 64 26 75
4 CD Villaralbo Villaralbo 38 52 26 71
5 La Bañeza La Bañeza 38 53 30 70
6 La Virgen del Camino Virgen 38 55 52 62
7 Atlético Tordesillas Atlético 38 52 53 54
8 Atl. Bembibre Atl. 38 48 44 53
9 SC Uxama SC Uxama 38 37 53 51
10 Numancia B Numancia B 38 51 43 50
11 SD Almazán SD Almazán 38 50 53 49
12 Cebrereña Cebrereña 38 55 61 46
13 CD Villamuriel Villamuriel 38 38 47 46
14 CD Burgalés Burgalés 38 37 41 46
15 Burgos CF B Burgos CF B 38 33 50 43
16 Palencia Cristo Atlético Palencia 38 40 63 40
17 Mirandés B Mirandés B 38 39 67 36
18 Ciudad Rodrigo Ciudad 38 38 68 36
19 UD Santa Marta Santa Marta 38 37 57 36
20 Becerril Becerril 38 34 67 25
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Arandina Arandina 38 63 29 74
2 Numancia B Numancia B 38 65 28 66
3 CD Palencia Balompié Palencia 38 62 36 65
4 Gimnástica Segoviana Gimnástica 38 46 31 64
5 Atl. Bembibre Atl. 38 62 29 64
6 SD Almazán SD Almazán 38 54 42 62
7 Becerril Becerril 38 56 53 59
8 La Virgen del Camino Virgen 38 50 46 57
9 Salamanca UDS Salamanca 38 60 47 55
10 Mirandés B Mirandés B 38 44 44 54
11 La Bañeza La Bañeza 38 42 41 52
12 CD Burgalés Burgalés 38 40 44 52
13 CD Villaralbo Villaralbo 38 36 47 47
14 Atlético Tordesillas Atlético 38 44 62 47
15 Palencia Cristo Atlético Palencia 38 40 45 45
16 Burgos CF B Burgos CF B 38 38 63 42
17 Cebrereña Cebrereña 38 37 55 41
18 CD La Granja Granja 38 33 61 37
19 Real Ávila Real Ávila 38 37 51 33
20 CD Villa de Simancas Villa 38 38 93 23
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Real Valladolid Promesas Real 38 71 30 83
2 Atl. Astorga Atl. Astorga 38 68 32 77
3 Arandina Arandina 38 60 31 75
4 Real Ávila Real Ávila 38 65 35 69
5 Numancia B Numancia B 38 57 42 64
6 Gimnástica Segoviana Gimnástica 38 58 47 62
7 SD Almazán SD Almazán 38 45 35 61
8 CD Burgalés Burgalés 38 51 44 59
9 Salamanca UDS Salamanca 38 52 54 54
10 La Virgen del Camino Virgen 38 59 64 46
11 CD La Granja Granja 38 46 52 46
12 Atl. Bembibre Atl. 38 48 47 45
13 La Bañeza La Bañeza 38 55 66 44
14 Cebrereña Cebrereña 38 50 66 42
15 Atlético Tordesillas Atlético 38 40 57 42
16 Palencia Cristo Atlético Palencia 38 45 60 41
17 Becerril Becerril 38 38 58 40
18 Unami CP Unami CP 38 50 64 40
19 UD Santa Marta Santa Marta 38 31 64 31
20 Racing Lermeño CF Racing 38 26 67 20

  USO DE MEMORIA  
6,520,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1168
Total Execution Time  0.1183
  CADENA URL  
/historico/Cd-Burgos
  GET DATOS  
$_GET['/historico/Cd-Burgos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
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 = 73778
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6207 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6207 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (93130,822157,886617) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '6207' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 73778 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031  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=6207 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 (73778) 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 = 73778 AND teamId = 6207
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 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 = 73778 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025  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 = '6207' 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 = '6207' and rp.type = 4
0.0020  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 = '6207' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 73778 WHERE rp.league_id = 73778 AND rp.teamId = 6207 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 = 73778 WHERE rp.league_id = 73778 AND rp.teamId = 6207 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 73778 WHERE rp.league_id = 73778 AND rp.teamId = 6207 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 6207 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0025  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 = 73778 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.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` 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 = 69052 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 = 63673 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.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 `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 = 58587 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.0025  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 = 50276 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.0025  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 = 44396 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 33358 AND t.round = 38 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` 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 = 15449 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 3910 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 2558 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC