4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Futbol Romeral CD
TEMPORADA 2022/2023
3ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 El Palo FC Sub 19 Palo 30 102 49 70
2 26 de Febrero Sub 19 Febrero 28 85 32 63
3 Malaka CF Sub 19 Malaka 28 97 50 62
4 Pto. Malagueño Ciudad Jardí Pto. 28 81 34 54
5 Club Deportivo Trabuco Club 28 77 43 52
6 Dos Hermanas San Andrés Hermanas 30 62 69 40
7 Puerto de la Torre Puerto Torre 29 69 70 39
8 UD Fuengirola Los Boliches Fuengirola 28 61 65 39
9 Cortijillo Bazan Cortijillo 29 64 60 37
10 Guadalmar Guadalmar 30 77 93 35
11 Atlético Juval A Atlético 29 58 79 34
12 Mortadelo Sub 19 Mortadelo 29 63 76 33
13 J. Torremolinos Sub 19 Torremolinos 28 66 72 31
14 Futbol Romeral CD Futbol 29 54 76 28
15 CD Conejito de Malaga Conejito 22 24 97 9
16 Olímpica Victoriana Olímpica 19 21 96 3
TEMPORADA 2021/2022
3ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Athl. Puerta Blanca Sub 19 Athl. Puerta 28 99 28 69
2 CD Rincón Sub 19 Rincón 30 89 31 68
3 Pto.Malagueño C.Jrdn Sub 19 Pto.Malague 30 88 39 63
4 Futbol Romeral CD Futbol 30 69 45 52
5 CD Conejito de Malaga Conejito 30 59 49 52
6 Guadalmar A Guadalmar A 30 86 72 51
7 Cortijillo Bazán Sub 19 Cortijillo 29 69 48 49
8 UD Dos Hermanas SA C Hermanas 30 73 64 45
9 Club Deportivo Trabuco Club 29 55 51 43
10 Mortadelo Sub 19 Mortadelo 30 53 79 38
11 Olimpica Victoriana CF A Olimpica 29 64 71 37
12 Malaka CF Sub 19 Malaka 30 46 63 33
13 Alhaurin de la Torre CF B Alhaurin 30 55 80 30
14 Roma Luz Sub 19 Roma 30 35 73 22
15 Cartama CD Cartama CD 28 38 85 18
16 Campanillas Campanillas 29 20 120 1
TEMPORADA 2020/2021
2ª ANDALUZA MÁLAGA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Malaka CF Sub 19 Malaka 16 39 27 30
2 CD 26 de Febrero B Febrero 17 30 18 30
3 At.Fuengirola Sub 19 At.Fuengirol 16 24 17 30
4 Atlético Juval A Atlético 16 22 23 24
5 CD Tiro Pichón Sub 19 B Tiro Pichón 16 26 24 21
6 Athl. Puerta Blanca Sub 19 Athl. Puerta 17 24 27 19
7 Mijas Las Lagunas Sub 19 Mijas 17 21 35 18
8 Conejito de Malaga Conejito 17 24 25 17
9 Futbol Romeral CD Futbol 16 29 34 16
10 Antequera CF A Antequera 4 3 12 0
TEMPORADA 2019/2020
3ª ANDALUZA MÁLAGA JUVENIL
Equipo PJ GF GC Puntos
1 Futbol Romeral CD Futbol 22 60 20 53
2 Malaka CF Sub 19 Malaka 22 92 38 50
3 Mortadelo Sub 19 Mortadelo 22 55 29 50
4 Archidona Archidona 22 40 33 40
5 Pto.Malagueño C.Jrdn Sub 19 Pto.Malague 22 59 40 37
6 Club Deportivo Trabuco Club 22 46 36 31
7 Vélez C.F. Vélez C.F. 22 56 52 30
8 Futbol Base Torreño Futbol Base 22 37 33 28
9 Benagalbon CD Benagalbon 22 43 48 28
10 Roma Luz Sub 19 Roma 22 33 38 26
11 Campanillas Campanillas 22 50 60 26
12 UD Dos Hermanas SA C Hermanas 22 37 40 25
13 Benalmadena CD Benalmadena 22 30 54 21
14 Alhaurin de la Torre CF B Alhaurin 22 22 47 18
15 Cartama CD Cartama CD 22 26 77 14
16 Guadalmar A Guadalmar A 22 35 76 9
TEMPORADA 2018/2019
3ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Ronda UD Ronda UD 29 60 29 65
2 Benagalbon CD Benagalbon 30 62 41 56
3 El Palo FC Sub 19 Palo 29 60 33 54
4 Campanillas Campanillas 29 66 41 50
5 Torrox CD Torrox CD 30 52 49 43
6 Roma Luz Sub 19 Roma 29 48 45 43
7 Archidona Archidona 30 44 39 42
8 Club Deportivo Trabuco Club 29 54 59 41
9 Futbol Base Torreño Futbol Base 29 34 36 36
10 Guadalmar A Guadalmar A 29 53 61 35
11 Vélez C.F. Vélez C.F. 30 48 59 35
12 Futbol Romeral CD Futbol 30 48 54 34
13 Cartama CD Cartama CD 30 41 54 33
14 Malaka CF Sub 19 Malaka 29 36 66 29
15 Atlético Juval B Atlético 29 41 58 27
16 Algarrobo Algarrobo 21 32 55 17
TEMPORADA 2017/2018
3ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CD Rincón A Rincón 27 97 26 71
2 UD Dos Hermanas SA B Hermanas 26 83 27 62
3 Mortadelo Sub 19 Mortadelo 26 77 36 55
4 Ronda UD Ronda UD 27 71 40 53
5 Cartama CD Cartama CD 26 84 63 50
6 Campanillas Campanillas 26 54 57 34
7 Atlético Juval B Atlético 27 56 56 33
8 Vélez C.F. Vélez C.F. 26 33 35 33
9 Torrox CD Torrox CD 27 42 66 30
10 Roma Luz Sub 19 Roma 26 36 43 29
11 Archidona Archidona 27 37 59 25
12 Malaka CF Sub 19 Malaka 26 39 76 21
13 Futbol Romeral CD Futbol 27 42 76 19
14 Futbol Base Torreño Futbol Base 25 34 83 18
15 Velez FC Velez FC 7 3 45 0
TEMPORADA 2016/2017
2ª ANDALUZA MÁLAGA JUVENIL
Equipo PJ GF GC Puntos
1 CD Vázquez Cultural Sub 19 Vázquez 36 101 42 83
2 Pto. Malagueño Ciudad Jardí Pto. 36 86 52 67
3 CD 26 de Febrero B Febrero 36 117 63 66
4 Fuengirola Los Boliches Juv Fuengirola 36 85 72 63
5 La Mosca Sub 19 Mosca 36 79 50 62
6 UD San Pedro Sub 19 Pedro 36 86 56 59
7 Alhaurin de la Torre CF A Alhaurin 36 87 62 58
8 Athl. Puerta Blanca Sub 19 Athl. Puerta 36 79 55 56
9 Malaka CF Sub 19 Malaka 35 96 66 55
10 CD Tiro Pichón Sub 19 B Tiro Pichón 36 66 67 52
11 Alhaurino Sub 19 Alhaurino 35 73 67 51
12 Futbol Romeral CD Futbol 35 82 73 49
13 UD Dos Hermanas SA B Hermanas 36 76 77 49
14 At.Fuengirola Sub 19 At.Fuengirol 35 62 57 48
15 Roma Luz Sub 19 Roma 35 52 85 38
16 CD Rincón A Rincón 36 74 78 37
17 Atlético Benamiel Atlético 36 63 99 36
18 Alameda CF Alameda CF 31 36 94 22
19 Los Prados Los Prados 36 28 213 8
TEMPORADA 2015/2016
2ª ANDALUZA MÁLAGA JUVENIL
Equipo PJ GF GC Puntos
1 Francisco Castejon EF A Francisco 34 98 30 84
2 Alhaurin de la Torre CF A Alhaurin 34 102 48 74
3 UD San Pedro Sub 19 Pedro 34 87 58 62
4 CD 26 de Febrero B Febrero 34 75 62 59
5 Puerto Malagueño CJGI Puerto 34 62 44 54
6 Atlético Benamiel Atlético 34 75 71 52
7 Los Prados Los Prados 34 55 52 52
8 La Mosca Sub 19 Mosca 34 76 60 51
9 CD Rincón A Rincón 34 48 51 50
10 CD Tiro Pichón B Tiro Pichón 34 69 81 45
11 Futbol Romeral CD Futbol 34 58 68 44
12 Malaka CF Sub 19 Malaka 34 49 81 42
13 UD Dos Hermanas SA B Hermanas 34 60 69 42
14 Mortadelo Sub 19 Mortadelo 34 80 92 40
15 Alhaurino Sub 19 Alhaurino 34 66 77 38
16 Cala Mijas CD Cala Mijas 34 59 90 33
17 Campillos CD Campillos 34 49 79 26
18 Torreño FB Torreño FB 34 47 102 21
TEMPORADA 2014/2015
3ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Futbol Base Torreño Futbol Base 30 94 55 61
2 Futbol Romeral CD Futbol 30 93 54 59
3 Ronda UD Ronda UD 30 96 52 57
4 Carlinda Carlinda 30 71 44 54
5 Antequera CF B Antequera 30 65 46 51
6 Nerja CD Nerja CD 30 69 76 48
7 Roma Luz Sub 19 Roma 30 54 55 44
8 Cortijillo Bazán Sub 19 Cortijillo 30 72 75 44
9 Archidona Archidona 30 74 68 42
10 Atlético Juval A Atlético 30 68 71 42
11 Vélez C.F. Vélez C.F. 30 52 46 41
12 Athl. Puerta Blanca Sub 19 Athl. Puerta 30 75 77 39
13 La Cala CD La Cala CD 30 57 88 36
14 Puerto de la Torre Puerto Torre 30 66 87 33
15 El Palo FC Sub 19 B Palo 30 53 61 31
16 Torre del Mar Torre 30 34 138 3

  USO DE MEMORIA  
5,632,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1435
Total Execution Time  0.1448
  CADENA URL  
/historico/Futbol-Romeral-Cd-Juvenil
  GET DATOS  
$_GET['/historico/Futbol-Romeral-Cd-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0039  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 = 'Futbol-Romeral-Cd-Juvenil' 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.0066  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 = 'Futbol-Romeral-Cd-Juvenil' 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.0022  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=19569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=19569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=19569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=19569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=19569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=19569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=19569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=19569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=19569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=19569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=19569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0032  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 = 69726
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19569 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=440 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 440 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  SELECT /*53 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 (990553,139180,70968) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '19569' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '19569' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 69726 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=19569 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (69726) 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_base WHERE league_id = 69726 AND teamId = 19569
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 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 = 69726 AND t.round = 30 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 = '19569' 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 = '19569' and rp.type = 4
0.0027  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 = '19569' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028  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 = 19569 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0027  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 = 69726 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.0029  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 = 65927 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.0031  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 = 59160 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.0032  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 = 52186 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.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 `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 = 45801 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 39948 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 39982 AND t.round = 30 ORDER BY team.conference 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 `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 = 34210 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047  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 = 17031 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 4272 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 69726 ORDER BY nameShow LIMIT 100