4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Balsas Picarral
TEMPORADA 2022/2023
PREF. ARAGÓN BENJAMIN
Equipo PJ GF GC Puntos
1 Amistad Amistad 30 170 50 82
2 Oliver Oliver 30 144 46 76
3 Montecarlo Montecarlo 30 112 50 67
4 Ebro Ebro 30 108 49 65
5 Santa Casablanca Santa 30 119 58 60
6 Santo Domingo juventud Santo 30 122 69 56
7 Racing Club Zaragoza Racing Club 30 92 55 55
8 Balsas Picarral Balsas 30 80 58 52
9 Valdefierro Valdefierro 30 90 77 52
10 Santa Venecia Santa 30 71 83 38
11 Hernan Cortes Junquera Hernan 30 74 80 36
12 Delicias Club Deportivo Delicias 30 40 115 19
13 Huracan Huracan 30 51 142 15
14 Marianistas Marianistas 30 37 177 11
15 El Olivar Estadio Miralbuen Olivar 30 34 111 10
16 Escalerillas Escalerillas 30 34 158 8
TEMPORADA 2021/2022
PREF. ARAGÓN BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Hernan Cortes Junquera Hernan 18 98 24 48
2 Santo Domingo juventud Santo 18 85 29 48
3 Balsas Picarral Balsas 18 69 27 40
4 El Olivar Estadio Miralbuen Olivar 18 64 27 36
5 Tarazona Tarazona 18 48 39 27
6 Santa Venecia Santa 18 39 71 18
7 Marianistas Marianistas 18 41 74 17
8 Delicias Club Deportivo Delicias 18 29 72 13
9 Escalerillas Escalerillas 18 33 97 9
10 San Gregorio Arrabal Gregorio 18 19 65 8
TEMPORADA 2019/2020
1ª ARAGÓN BENJAMIN
Equipo PJ GF GC Puntos
1 Cuarte Club Deportivo Cuarte Club 22 121 31 57
2 St. Casablanca AD Casablanca 22 85 42 48
3 Alcañiz CF Alcañiz CF 22 72 34 45
4 Bajo Aragon Caspe B Bajo Aragon 22 73 40 45
5 Marianistas Marianistas 21 84 60 39
6 Ebro Ebro 22 67 56 37
7 Montecarlo Montecarlo 22 67 63 36
8 Huracan Huracan 22 68 58 35
9 Balsas Picarral Balsas 22 55 62 33
10 Hernan Cortes Junquera Hernan 21 71 59 28
11 Santa Isabel Santa Isabel 22 47 62 28
12 Santo Domingo juventud Santo 22 57 55 27
13 San Jose San Jose 22 51 69 21
14 Cristo Rey Cristo Rey 22 42 99 11
15 Ranillas Ranillas 22 40 106 10
16 Santo DSilos OD Santo DSilos 22 18 122 4
TEMPORADA 2018/2019
1ª ARAGÓN BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Montecarlo Montecarlo 30 156 40 78
2 Unión La Jota Vadorrey Unión Jota 30 135 48 70
3 Alfinden Alfinden 30 96 46 70
4 Balsas Picarral Balsas 30 126 58 62
5 Calatayud Efb Calatayud 30 119 74 54
6 Utebo Utebo 30 110 74 53
7 Huracan Huracan 30 120 86 53
8 Oliver Oliver 30 107 73 52
9 Cuarte Club Deportivo Cuarte Club 30 99 72 46
10 Actur Pablo Iglesias Actur Pablo 30 86 94 31
11 Marianistas Marianistas 30 83 128 28
12 Santo Domingo juventud Santo 30 70 96 27
13 Rivas Rivas 30 84 119 27
14 El Olivar Estadio Miralbuen Olivar 30 71 107 26
15 Casetas Casetas 30 75 151 19
16 Santa Isabel Santa Isabel 30 16 255 0
TEMPORADA 2017/2018
PREF. ARAGÓN BENJAMIN
Equipo PJ GF GC Puntos
1 Amistad Amistad 30 172 33 87
2 Montecarlo Montecarlo 30 124 58 74
3 Santo Domingo juventud Santo 30 74 70 53
4 Balsas Picarral Balsas 30 85 79 51
5 Santa Casablanca Santa 30 59 66 47
6 San Jose San Jose 30 75 84 41
7 Hernan Cortes Junquera Hernan 30 70 69 40
8 Valdefierro Valdefierro 30 58 72 40
9 Actur Pablo Iglesias Actur Pablo 30 64 67 39
10 Oliver Oliver 30 70 85 39
11 Ebro Ebro 30 77 90 37
12 El Olivar Estadio Miralbuen Olivar 30 66 73 32
13 Santa Isabel Santa Isabel 30 42 72 32
14 Unión La Jota Vadorrey Unión Jota 30 57 79 31
15 El Salvador El Salvador 30 43 66 27
16 Santa Venecia Santa 30 42 115 8
TEMPORADA 2016/2017
PREF. ARAGÓN BENJAMIN
Equipo PJ GF GC Puntos
1 Amistad Amistad 30 117 25 80
2 Balsas Picarral Balsas 30 141 44 73
3 Montecarlo Montecarlo 30 102 27 73
4 Unión La Jota Vadorrey Unión Jota 30 109 52 66
5 Santa Casablanca Santa 30 97 45 61
6 Actur Pablo Iglesias Actur Pablo 30 81 43 58
7 Santa Venecia Santa 30 62 79 45
8 Ebro Ebro 30 77 69 37
9 Oliver Oliver 30 72 80 34
10 El Salvador El Salvador 30 72 96 34
11 Santa Isabel Santa Isabel 30 49 66 33
12 Hernan Cortes Junquera Hernan 30 69 96 32
13 Santo Domingo juventud Santo 30 52 96 29
14 Helios Helios 30 34 109 15
15 San Gregorio Arrabal Gregorio 30 41 141 10
16 Calanda Calanda 30 44 151 8
TEMPORADA 2015/2016
PREF. ARAGÓN BENJAMIN
Equipo PJ GF GC Puntos
1 Amistad Amistad 30 126 39 73
2 Unión La Jota Vadorrey Unión Jota 30 106 33 72
3 San Gregorio Arrabal Gregorio 30 89 30 68
4 Balsas Picarral Balsas 30 79 23 68
5 Santo Domingo juventud Santo 30 87 45 57
6 Actur Pablo Iglesias Actur Pablo 30 78 54 53
7 Santa Casablanca Santa 30 63 50 46
8 Hernan Cortes Junquera Hernan 30 63 63 42
9 Montecarlo Montecarlo 30 70 52 35
10 Santa Isabel Santa Isabel 30 61 76 32
11 El Salvador El Salvador 30 57 72 32
12 Oliver Oliver 30 62 73 31
13 Santa Venecia Santa 30 51 68 31
14 San Jose San Jose 30 62 92 29
15 Cuarte Club Deportivo Cuarte Club 30 27 81 13
16 Utebo Utebo 30 11 241 1
TEMPORADA 2014/2015
1ª ARAGÓN BENJAMIN GRUPO 2
Equipo PJ GF GC Puntos
1 El Salvador El Salvador 30 127 23 83
2 Calatayud Efb Calatayud 30 109 68 66
3 Santa Casablanca Santa 30 77 50 59
4 Ebro Ebro 30 90 58 58
5 Santo Dsilos Santo Dsilos 30 63 59 49
6 Unión La Jota Vadorrey Unión Jota 30 83 68 46
7 Oliver Oliver 30 75 64 45
8 Balsas Picarral Balsas 30 77 58 42
9 Delicias Club Deportivo Delicias 30 69 74 41
10 Actur Pablo Iglesias Actur Pablo 30 68 83 38
11 Miralbueno Centro deportivo Miralbueno 30 59 76 38
12 Hernan Cortes Junquera Hernan 30 47 69 38
13 Ejea Ejea 30 73 101 37
14 Villanueva Villanueva 30 48 95 25
15 Alfinden Alfinden 30 38 89 16
16 Cristo Rey Cristo Rey 30 36 104 4

  USO DE MEMORIA  
5,456,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5774
Total Execution Time  0.5793
  CADENA URL  
/historico/Balsas-Picarral-Ud-Benjamin
  GET DATOS  
$_GET['/historico/Balsas-Picarral-Ud-Benjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0113  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 = 'Balsas-Picarral-Ud-Benjamin' 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.0121  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 = 'Balsas-Picarral-Ud-Benjamin' 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.0106  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=34000 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0117  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 = 70046
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=34000 AND type_rel = 2
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=936 AND type_rel = 3
0.0111  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 = '34000' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0109  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 = '34000' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 70046 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  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=34000 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0105  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 (70046) 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.0106  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70046 AND teamId = 34000
0.0107  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 = 70046 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '34000' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107  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 = '34000' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0109  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 = 34000 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0109  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 = 70046 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.0108  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 = 64440 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.0111  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 = 54166 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.0109  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 = 54142 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.0111  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 = 47152 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 47265 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 42322 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 42324 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 35389 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 35448 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 18220 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 18909 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 6037 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 6039 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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 = 70046 ORDER BY nameShow LIMIT 100