4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del EDMF Churra
TEMPORADA 2023/2024
PREFERENTE MURCIA
Equipo PJ GF GC Puntos
1 Bala Azul Bala Azul 29 67 25 65
2 Mazarrón FC Mazarrón 29 56 19 65
3 Minerva Minerva 29 51 25 58
4 Aguilas FC B Aguilas 29 51 26 57
5 UD Los Garres Garres 29 52 24 55
6 Yeclano Deportivo B Yeclano 29 53 26 52
7 Algezares UD Algezares 29 42 28 44
8 Atl. Santa Cruz Atl. Santa. 29 45 35 44
9 Abarán CF Abarán CF 29 48 46 39
10 EDMF Churra EDMF Churra 29 55 52 36
11 El Raal El Raal 29 33 44 36
12 Olímpico de Totana Olímpico 29 30 40 34
13 Unión Molinense B Unión 29 33 53 30
14 Atletico Cabezo de Torres Atletico 29 35 50 29
15 Atletico Pinatarense Atletico 29 18 33 27
16 Ciudad de Calasparra Ciudad 29 32 75 26
17 EF La Aljorra Sabic Aljorra 29 24 60 18
18 Fuente Alamo Fuente Alamo 29 24 88 11
TEMPORADA 2022/2023
PREFERENTE MURCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Plus Ultra Plus Ultra 22 34 21 43
2 Montecasillas Montecasilla 22 44 24 42
3 EDMF Churra EDMF Churra 22 34 24 40
4 El Raal El Raal 22 42 25 38
5 Yeclano Deportivo B Yeclano 22 40 31 34
6 Abarán CF Abarán CF 22 36 30 34
7 Atletico Cabezo de Torres Atletico 22 24 26 32
8 Unión Molinense B Unión 22 22 22 30
9 UD Los Garres Garres 22 26 30 30
10 Villa de Fortuna Villa 22 33 39 24
11 Jumilla Atlético Jumilla 22 11 46 16
12 CD Beniel CD Beniel 22 22 50 12
TEMPORADA 2021/2022
PREFERENTE MURCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Muleño CF Muleño CF 28 56 24 61
2 Cieza Cieza 28 50 25 59
3 EDMF Churra EDMF Churra 28 39 24 51
4 Villa de Fortuna Villa 28 41 23 49
5 Unión Molinense Unión 28 44 34 47
6 CD Beniel CD Beniel 28 45 38 44
7 Abarán CF Abarán CF 28 38 35 42
8 Yeclano Deportivo B Yeclano 28 45 41 41
9 El Raal El Raal 28 36 35 39
10 Plus Ultra Plus Ultra 28 36 35 38
11 Santomera Santomera 28 33 29 36
12 Cehegin Cehegin 28 35 37 36
13 CD El Esparragal Esparragal 28 26 62 22
14 CD Hoya del Campo Hoya Campo 28 23 56 13
15 Independiente Ceutí Independient 28 24 73 9
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Real Murcia Imperial Real Murcia 20 36 14 44
2 Águilas FC Águilas FC 20 43 8 44
3 At. Pulpileño Pulpileño 20 30 11 43
4 UD Los Garres Garres 20 22 21 27
5 CD Bullense CD Bullense 20 23 25 27
6 UCAM Murcia B UCAM Murcia 20 28 23 26
7 Olímpico de Totana Olímpico 20 17 23 23
8 El Palmar El Palmar 20 26 28 22
9 Minerva Minerva 20 24 36 20
10 EDMF Churra EDMF Churra 20 17 36 16
11 Plus Ultra Plus Ultra 20 11 52 9
12 Racing Cartagena Mar Menor Racing 20 27 12 43
13 FC Cartagena B Cartagena 20 38 10 40
14 Racing Murcia Racing 20 25 9 37
15 FC La Unión Atl. Unión Atl. 20 33 19 36
16 Cartagena F.C. UCAM Cartagena 20 30 27 32
17 Mazarrón FC Mazarrón 20 21 19 26
18 Deportiva Minera Deportiva 20 18 20 24
19 Huércal-Overa Huércal-Ove 20 17 27 22
20 CAP Ciudad de Murcia Ciudad 20 13 18 21
21 Muleño CF Muleño CF 20 18 31 16
22 Lorca FC Lorca FC 20 9 57 4
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Lorca Deportiva Lorca 28 63 23 60
2 At. Pulpileño Pulpileño 28 52 19 57
3 Racing Cartagena Mar Menor Racing 28 52 19 56
4 Real Murcia Imperial Real Murcia 28 51 28 54
5 Mazarrón FC Mazarrón 28 44 32 54
6 UCAM Murcia B UCAM Murcia 28 45 30 47
7 Lorca FC Lorca FC 28 37 28 46
8 Minerva Minerva 28 46 38 42
9 Muleño CF Muleño CF 28 39 39 40
10 UD Los Garres Garres 28 34 30 35
11 Deportiva Minera Deportiva 28 39 47 33
12 EDMF Churra EDMF Churra 28 31 42 33
13 FC Cartagena B Cartagena 28 35 36 33
14 El Palmar El Palmar 28 26 51 31
15 Huércal-Overa Huércal-Ove 28 29 34 30
16 Águilas FC Águilas FC 28 30 38 27
17 Cartagena F.C. UCAM Cartagena 28 28 49 26
18 Olímpico de Totana Olímpico 28 25 49 24
19 CAP Ciudad de Murcia Ciudad 28 21 51 19
20 Plus Ultra Plus Ultra 28 18 62 15
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Yeclano Deportivo Yeclano 42 88 30 89
2 Lorca Deportiva Lorca 42 69 28 89
3 Lorca FC Lorca FC 42 73 28 80
4 EDMF Churra EDMF Churra 42 63 50 77
5 At. Pulpileño Pulpileño 42 65 41 76
6 Águilas FC Águilas FC 42 56 33 74
7 Racing Cartagena Mar Menor Racing 42 55 49 65
8 UCAM Murcia B UCAM Murcia 42 52 42 63
9 Deportiva Minera Deportiva 42 45 55 55
10 Mazarrón FC Mazarrón 42 48 56 54
11 Olímpico de Totana Olímpico 42 54 64 54
12 UD Los Garres Garres 42 36 48 53
13 Real Murcia Imperial Real Murcia 42 56 64 51
14 Muleño CF Muleño CF 42 44 59 49
15 Minerva Minerva 42 42 55 48
16 Huércal-Overa Huércal-Ove 42 56 68 48
17 FC Cartagena B Cartagena 42 51 53 48
18 CAP Ciudad de Murcia Ciudad 42 43 70 44
19 FC La Unión Atl. Unión Atl. 42 42 55 43
20 Estudiantes Murcia Estudiantes 42 37 55 42
21 CD Algar CD Algar 42 29 71 35
22 Cieza Cieza 42 36 66 32
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Yeclano Deportivo Yeclano 38 81 37 75
2 Racing Cartagena Mar Menor Racing 38 59 39 68
3 At. Pulpileño Pulpileño 38 58 34 67
4 EDMF Churra EDMF Churra 38 57 40 63
5 Minerva Minerva 38 63 46 62
6 FC Pinatar FC Pinatar 38 52 47 58
7 Águilas FC Águilas FC 38 48 44 56
8 FC Cartagena B Cartagena 38 49 51 55
9 Estudiantes Murcia Estudiantes 38 53 54 54
10 UCAM Murcia B UCAM Murcia 38 50 50 53
11 Muleño CF Muleño CF 38 43 46 52
12 Deportiva Minera Deportiva 38 48 50 47
13 Lorca FC B Lorca FC B 38 51 48 47
14 Huércal-Overa Huércal-Ove 38 53 57 46
15 Cieza Cieza 38 41 53 46
16 Real Murcia Imperial Real Murcia 38 50 57 45
17 UD Los Garres Garres 38 55 60 44
18 FC La Unión Atl. Unión Atl. 38 43 53 42
19 El Palmar El Palmar 38 52 65 40
20 Bala Azul Bala Azul 38 30 105 15
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Lorca Deportiva Lorca 38 96 38 85
2 Lorca FC B Lorca FC B 38 87 34 85
3 Águilas FC Águilas FC 38 78 30 81
4 Racing Cartagena Mar Menor Racing 38 54 27 67
5 Yeclano Deportivo Yeclano 38 61 38 65
6 Real Murcia Imperial Real Murcia 38 67 44 59
7 El Palmar El Palmar 38 54 48 58
8 UCAM Murcia B UCAM Murcia 38 71 51 55
9 Estudiantes Murcia Estudiantes 38 58 52 53
10 FC La Unión Atl. Unión Atl. 38 47 54 52
11 Cieza Cieza 38 58 66 52
12 At. Pulpileño Pulpileño 38 50 55 49
13 Huércal-Overa Huércal-Ove 38 40 59 43
14 EDMF Churra EDMF Churra 38 53 57 42
15 Muleño CF Muleño CF 38 44 60 42
16 Deportiva Minera Deportiva 38 40 56 41
17 Pinatar Pinatar 38 39 47 39
18 CAP Ciudad de Murcia Ciudad 38 41 63 37
19 CD Algar CD Algar 38 39 68 33
20 Olímpico de Totana Olímpico 38 27 157 17
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Lorca Deportiva Lorca 34 64 16 78
2 Águilas FC Águilas FC 34 62 29 77
3 El Palmar El Palmar 34 71 30 66
4 Racing Cartagena Mar Menor Racing 34 58 39 63
5 Yeclano Deportivo Yeclano 34 52 27 62
6 FC La Unión Atl. Unión Atl. 34 51 38 59
7 Huércal-Overa Huércal-Ove 34 42 41 50
8 Real Murcia Imperial Real Murcia 34 45 39 49
9 Deportiva Minera Deportiva 34 56 61 46
10 Muleño CF Muleño CF 34 40 48 45
11 Estudiantes Murcia Estudiantes 34 50 42 41
12 EDMF Churra EDMF Churra 34 37 45 41
13 CAP Ciudad de Murcia Ciudad 34 45 56 36
14 At. Pulpileño Pulpileño 34 33 43 35
15 Pinatar Pinatar 34 41 59 31
16 Plus Ultra Plus Ultra 34 35 55 31
17 EF Alhama EF Alhama 34 39 69 26
18 Caravaca Caravaca 34 29 113 16
TEMPORADA 2014/2015
PREFERENTE MURCIA
Equipo PJ GF GC Puntos
1 Lorca Deportiva Lorca 34 71 31 71
2 CAP Ciudad de Murcia Ciudad 34 61 27 71
3 At. Pulpileño Pulpileño 34 60 29 69
4 EDMF Churra EDMF Churra 34 59 23 67
5 Olímpico de Totana Olímpico 34 69 42 64
6 UCAM Murcia B UCAM Murcia 34 64 41 57
7 Montecasillas Montecasilla 34 50 39 55
8 Sporting Club Aguileño Sporting 34 48 41 52
9 CD Algar CD Algar 34 52 53 50
10 UD Los Garres Garres 34 57 57 45
11 Alquerias Alquerias 34 54 49 42
12 Bala Azul Bala Azul 34 52 84 41
13 CD Bullense CD Bullense 34 51 76 35
14 Jumilla CD Jumilla CD 34 37 59 33
15 AD Soho CF AD Soho CF 34 55 72 32
16 Calasparra Calasparra 34 45 79 32
17 Abarán CF Abarán CF 34 37 85 22
18 Balsicas Atlético Balsicas 34 33 68 18

  USO DE MEMORIA  
6,428,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1430
Total Execution Time  0.1441
  CADENA URL  
/historico/Ed-Churra
  GET DATOS  
$_GET['/historico/Ed-Churra']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
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 = 'Ed-Churra' 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.0023  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=19030 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=19030 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=19030 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0063  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 = 73547
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19030 AND type_rel = 2
0.0036  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 19030 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0044  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 (427710,428153,428205,615740,637063) ORDER BY n.cover_points DESC, update_date DESC
0.0051  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 = '19030' ORDER BY l.year DESC,cat.coefficient DESC
0.0045  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 = '19030' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0072  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=19030 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0026  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 (73547,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.0046  SELECT count(id) as num_players from rel_players WHERE league_id = 73547 AND teamId = 19030
0.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 19030
0.0032  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 = 73547 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '19030' 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 = '19030' and rp.type = 4
0.0021  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 = '19030' 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 = 73547 WHERE rp.league_id = 73547 AND rp.teamId = 19030 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.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 = 73547 WHERE rp.league_id = 73547 AND rp.teamId = 19030 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 73547 WHERE rp.league_id = 73547 AND rp.teamId = 19030 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 = 19030 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 = 73547 AND t.round = 31 ORDER BY team.conference ASC,t.position 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 `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 = 68805 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.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 `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 = 64036 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.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 = 58592 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.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 `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 = 50281 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.0042  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 = 44401 AND t.round = 42 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 `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 = 39037 AND t.round = 38 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 `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 = 33363 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 = 15455 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 = 4096 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC