4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2014/2015
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 FBC Melgar FBC Melgar 16 29 11 29
2 Cusco FC Cusco FC 16 26 16 29
3 Sport Huancayo Sport 16 28 20 28
4 Universitario de Deportes Universitari 16 26 20 28
5 Sporting Cristal Sporting 16 35 24 27
6 Univ. César Vallejo Univ. César 16 18 20 27
7 Univ. San Martín Univ. 16 17 17 24
8 UTC Cajamarca Cajamarca 16 18 15 23
9 Juan Aurich Chiclayo Juan Aurich 16 22 25 19
10 Ayacucho FC Ayacucho FC 16 22 26 19
11 Cienciano Cienciano 16 16 19 18
12 Unión Comercio Unión 16 27 32 18
13 Deportivo Municipal Deportivo 16 13 22 18
14 Alianza Lima Alianza Lima 16 18 21 17
15 Alianza Atl. Sullana Alianza Atl. 16 20 29 16
16 León de Huánuco León 16 21 31 15
17 Sport Loreto Sport Loreto 16 13 21 14
TEMPORADA 2013/2014
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Sporting Cristal Sporting 15 35 19 33
2 Alianza Lima Alianza Lima 15 27 11 33
3 Unión Comercio Unión 15 24 15 28
4 FBC Melgar FBC Melgar 15 21 16 27
5 León de Huánuco León 15 21 21 23
6 Cusco FC Cusco FC 15 20 17 21
7 Universitario de Deportes Universitari 15 17 17 21
8 Ayacucho FC Ayacucho FC 15 21 19 20
9 Los Caimanes Caimanes 15 15 18 20
10 Univ. César Vallejo Univ. César 15 22 24 19
11 Juan Aurich Chiclayo Juan Aurich 15 13 19 19
12 Sport Huancayo Sport 15 16 20 17
13 Cienciano Cienciano 15 16 24 17
14 UTC Cajamarca Cajamarca 15 14 22 15
15 Univ. San Martín Univ. 15 21 23 14
16 San Simón San Simón 15 13 31 9
TEMPORADA 2012/2013
PERÚ - LIGA 1 FASE 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Cusco FC Cusco FC 14 22 19 77
2 Sporting Cristal Sporting 14 25 12 75
3 Alianza Lima Alianza Lima 14 23 13 70
4 Univ. César Vallejo Univ. César 14 21 14 69
5 Sport Huancayo Sport 14 15 21 56
6 FBC Melgar FBC Melgar 14 13 16 50
7 Unión Comercio Unión 14 15 19 44
8 Pacífico Pacífico 14 9 29 44
TEMPORADA 2011/2012
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Sporting Cristal Sporting 14 31 14 28
2 Cienciano Cienciano 14 21 13 23
3 Sport Huancayo Sport 14 18 14 23
4 Univ. San Martín Univ. 14 16 14 22
5 Ayacucho FC Ayacucho FC 14 11 16 17
6 José Gálvez José 14 18 20 16
7 Universitario de Deportes Universitari 14 12 21 15
8 Cobresol Cobresol 14 11 26 11
9 Cusco FC Cusco FC 14 25 14 25
10 FBC Melgar FBC Melgar 14 21 10 25
11 Juan Aurich Chiclayo Juan Aurich 14 19 15 24
12 Alianza Lima Alianza Lima 14 19 15 19
13 Unión Comercio Unión 14 14 18 19
14 Univ. César Vallejo Univ. César 14 13 17 19
15 León de Huánuco León 14 12 15 14
16 Sport Boys Association Sport Boys. 14 11 30 8
TEMPORADA 2010/2011
PERÚ - LIGA 1 FASE 1
Equipo PJ GF GC Puntos
1 Alianza Lima Alianza Lima 30 45 22 58
2 Juan Aurich Chiclayo Juan Aurich 30 46 21 56
3 Sport Huancayo Sport 30 49 33 50
4 Univ. San Martín Univ. 30 43 24 47
5 León de Huánuco León 30 37 30 46
6 Ayacucho FC Ayacucho FC 30 42 41 44
7 Unión Comercio Unión 30 46 43 43
8 Cienciano Cienciano 30 42 46 40
9 Cobresol Cobresol 30 32 36 40
10 Sport Boys Association Sport Boys. 30 27 47 37
11 Sporting Cristal Sporting 30 28 35 36
12 FBC Melgar FBC Melgar 30 37 44 34
13 Universitario de Deportes Universitari 30 25 35 34
14 Univ. César Vallejo Univ. César 30 30 42 34
15 Alianza Atl. Sullana Alianza Atl. 30 24 41 33
16 CNI CNI 30 32 45 30
TEMPORADA 2009/2010
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Univ. San Martín Univ. 14 26 9 29
2 Alianza Lima Alianza Lima 14 20 17 22
3 Universitario de Deportes Universitari 14 12 9 21
4 Sporting Cristal Sporting 14 15 12 20
5 UNAP Iquitos UNAP Iquitos 14 19 20 19
6 Ayacucho FC Ayacucho FC 14 27 26 18
7 José Gálvez José 14 12 28 15
8 Total Chalaco Total 14 10 20 10
9 León de Huánuco León 14 22 13 25
10 Sport Boys Association Sport Boys. 14 20 23 23
11 Sport Huancayo Sport 14 20 12 21
12 Juan Aurich Chiclayo Juan Aurich 14 20 17 20
13 Alianza Atl. Sullana Alianza Atl. 14 21 24 20
14 Cienciano Cienciano 14 15 19 16
15 Univ. César Vallejo Univ. César 14 16 18 15
16 FBC Melgar FBC Melgar 14 15 23 14
TEMPORADA 2008/2009
PERÚ - LIGA 1 FASE 1
Equipo PJ GF GC Puntos
1 Juan Aurich Chiclayo Juan Aurich 26 41 29 47
2 Universitario de Deportes Universitari 27 29 20 45
3 Sport Huancayo Sport 26 37 27 44
4 Univ. San Martín Univ. 25 41 28 42
5 Alianza Lima Alianza Lima 26 31 27 41
6 Univ. César Vallejo Univ. César 26 36 30 40
7 Ayacucho FC Ayacucho FC 26 33 26 39
8 FBC Melgar FBC Melgar 25 30 32 37
9 Cienciano Cienciano 26 35 33 36
10 Sporting Cristal Sporting 26 43 35 35
11 José Gálvez José 27 25 34 35
12 Total Chalaco Total 26 37 35 34
13 Alianza Atl. Sullana Alianza Atl. 26 26 31 30
14 CNI CNI 26 21 38 25
15 Sport Ancash Huaraz Sport Ancash 26 23 38 24
16 Bolognesi Tacna Bolognesi 24 17 41 15
TEMPORADA 2007/2008
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Univ. San Martín Univ. 26 40 20 50
2 Sporting Cristal Sporting 26 36 25 45
3 Sport Ancash Huaraz Sport Ancash 26 39 29 43
4 Univ. César Vallejo Univ. César 26 35 31 40
5 FBC Melgar FBC Melgar 26 35 34 40
6 Cienciano Cienciano 26 34 30 39
7 Alianza Atl. Sullana Alianza Atl. 26 35 26 38
8 José Gálvez José 26 42 38 37
9 Atletico Minero Matucana Atletico 26 31 28 34
10 Universitario de Deportes Universitari 26 31 32 34
11 Alianza Lima Alianza Lima 26 35 39 34
12 Juan Aurich Chiclayo Juan Aurich 26 27 33 32
13 Bolognesi Tacna Bolognesi 26 34 51 26
14 Sport Boys Association Sport Boys. 26 17 55 11
TEMPORADA 2006/2007
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Bolognesi FC Bolognesi 22 28 15 36
2 Universitario de Deportes Universitari 22 27 22 35
3 Cienciano Cienciano 22 35 28 34
4 Alianza Lima Alianza Lima 22 29 25 34
5 Sport Ancash Huaraz Sport Ancash 22 26 27 33
6 Sporting Cristal Sporting 22 21 23 30
7 Univ. San Martín Univ. 22 25 24 27
8 FBC Melgar FBC Melgar 22 18 17 26
9 Alianza Atl. Sullana Alianza Atl. 22 17 22 26
10 Total Chalaco Total 22 22 27 25
11 Deportivo Municipal Deportivo 22 24 38 24
12 Sport Boys Association Sport Boys. 22 25 29 23
TEMPORADA 2005/2006
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Universitario de Deportes Universitari 22 34 24 41
2 Cienciano Cienciano 22 40 31 41
3 Bolognesi FC Bolognesi 22 32 20 39
4 Alianza Lima Alianza Lima 22 27 17 38
5 Univ. San Martín Univ. 22 24 21 34
6 Sporting Cristal Sporting 22 24 15 31
7 FBC Melgar FBC Melgar 22 23 22 31
8 Sport Boys Association Sport Boys. 22 26 28 31
9 José Gálvez José 22 24 29 24
10 Sport Ancash Huaraz Sport Ancash 22 26 39 23
11 Alianza Atl. Sullana Alianza Atl. 22 29 40 21
12 Union Huaral Union Huaral 22 15 38 15
TEMPORADA 2004/2005
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Sporting Cristal Sporting 24 37 13 52
2 Univ. San Martín Univ. 24 40 20 48
3 Bolognesi FC Bolognesi 24 38 32 44
4 Universitario de Deportes Universitari 24 31 20 40
5 Cienciano Cienciano 24 33 30 33
6 Sport Ancash Huaraz Sport Ancash 24 27 32 32
7 FBC Melgar FBC Melgar 24 26 37 32
8 AD San Agustín Agustín 24 35 39 31
9 Alianza Atl. Sullana Alianza Atl. 24 29 39 30
10 Sport Boys Association Sport Boys. 24 23 30 28
11 Alianza Lima Alianza Lima 24 26 23 26
12 Univ. César Vallejo Univ. César 24 31 39 22
13 Union Huaral Union Huaral 24 16 38 16

  USO DE MEMORIA  
6,416,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.9773
Total Execution Time  0.9794
  CADENA URL  
/historico/Sporting-Cristal-Lima/2015
  GET DATOS  
$_GET['/historico/Sporting-Cristal-Lima/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (55)  
0.0166  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 = 'Sporting-Cristal-Lima' AND l.year = 2015 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.0149  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=2392 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=2392 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=2392 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0154  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=2392 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=2392 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=2392 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0156  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 = 9729
0.0155  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 = 10886
0.0159  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 = 19904
0.0164  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 = 9424
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2392 AND type_rel = 2
0.0150  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2392 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0150  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 (5652,7995,8440,10278,13166) ORDER BY n.cover_points DESC, update_date DESC
0.0164  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 = '2392' ORDER BY l.year DESC,cat.coefficient DESC
0.0168  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 = '2392' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0162  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 = '2392' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 9424 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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 = 9729 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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 = 10886 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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 = 12133 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0162  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=2392 AND l.year in (2014,2015,2016) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (43058,37480,27239,20243,20056,16245,9424) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 20243 AND teamId = 2392
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 37480 AND teamId = 2392
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 20056 AND teamId = 2392
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 43058 AND teamId = 2392
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 9424 AND teamId = 2392
0.0174  SELECT count(id) as num_players from rel_players WHERE league_id = 16245 AND teamId = 2392
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 27239 AND teamId = 2392
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 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 = 9729 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0156  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 events2015 e ON e.player_id = p.id AND e.league_id = 9729 WHERE rp.league_id = 9729 AND rp.teamId = 2392 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.0161  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 events2015 e ON e.player_id = p.id AND e.league_id = 9729 WHERE rp.league_id = 9729 AND rp.teamId = 2392 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 events2015 e ON e.player_id = p.id AND e.league_id = 9729 WHERE rp.league_id = 9729 AND rp.teamId = 2392 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0210  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 = 2392 AND l.year <= 2015 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0167  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 = 10886 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 3590 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 3195 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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` 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 = 2337 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 `tables2013` 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 = 3194 AND t.round = 14 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 `tables2012` 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 = 1571 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 `tables2012` 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 = 2606 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 `tables2011` 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 = 1298 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 `tables2010` 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 = 1212 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0175  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 `tables2010` 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 = 2604 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0172  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 `tables2009` 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 = 2603 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables2009` 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 = 1211 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 `tables2008` 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 = 259 AND t.round = 26 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 `tables2008` 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 = 260 AND t.round = 26 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 `tables2007` 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 = 23083 AND t.round = 22 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 `tables2007` 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 = 23084 AND t.round = 22 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 `tables2006` 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 = 23069 AND t.round = 22 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 `tables2006` 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 = 23077 AND t.round = 22 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 `tables2005` 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 = 23086 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 9729 ORDER BY nameShow LIMIT 100