4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pergolettese
TEMPORADA 2017/2018
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Pro Patria Pro Patria 36 58 22 79
2 Rezzato Rezzato 36 84 35 78
3 Pontisola Pontisola 36 67 44 70
4 Pergolettese Pergolettese 36 57 37 67
5 Darfo Boario Darfo Boario 36 51 30 62
6 Virtus Bergamo Virtus 36 57 46 58
7 Lecco Lecco 36 46 35 58
8 Crema Crema 36 43 40 48
9 Bustese Milano City FC Bustese 36 44 43 47
10 Caravaggio Caravaggio 36 47 52 47
11 Pol. Ciliverghe Pol. 36 47 46 45
12 Levico Levico 36 45 56 44
13 Scanzorosciate Scanzoroscia 36 41 51 43
14 Trento Trento 36 42 64 43
15 Lumezzane Lumezzane 36 37 51 42
16 Ciserano Ciserano 36 42 58 36
17 Grumellese Grumellese 36 34 55 34
18 Dro Calcio Dro Calcio 36 33 62 31
19 Romanese Romanese 36 30 78 11
TEMPORADA 2016/2017
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 AC Monza AC Monza 34 70 17 80
2 Pol. Ciliverghe Pol. 34 75 45 73
3 Pergolettese Pergolettese 34 58 38 65
4 Virtus Bergamo Virtus 34 57 34 63
5 Pro Patria Pro Patria 34 50 34 62
6 Pontisola Pontisola 34 59 37 59
7 Darfo Boario Darfo Boario 34 46 38 54
8 Caravaggio Caravaggio 34 45 48 47
9 Seregno Seregno 34 51 49 45
10 Grumellese Grumellese 34 37 51 42
11 Ciserano Ciserano 34 44 54 40
12 Dro Calcio Dro Calcio 34 33 48 36
13 Olginatese Olginatese 34 39 56 36
14 Scanzorosciate Scanzoroscia 34 30 61 34
15 Levico Levico 34 42 53 31
16 Lecco Lecco 34 31 64 31
17 Virtus Bolzano Virtus 34 31 54 29
18 Fanfulla Fanfulla 34 38 55 27
TEMPORADA 2015/2016
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Piacenza Piacenza 38 85 27 96
2 Lecco Lecco 38 83 41 80
3 Seregno Seregno 38 63 47 64
4 Pontisola Pontisola 38 63 48 61
5 Pol. Ciliverghe Pol. 38 48 49 61
6 Olginatese Olginatese 38 57 50 56
7 Inveruno Inveruno 38 65 57 53
8 Ciserano Ciserano 38 48 55 53
9 Folgore Caratese Folgore 38 52 48 50
10 AC Monza AC Monza 38 52 49 49
11 Grumellese Grumellese 38 49 53 48
12 Pro Sesto Pro Sesto 38 50 51 47
13 Varesina Varesina 38 42 49 47
14 Pergolettese Pergolettese 38 38 42 46
15 Bustese Milano City FC Bustese 38 47 58 45
16 Virtus Bergamo Virtus 38 44 61 45
17 Caravaggio Caravaggio 38 35 56 34
18 Fiorenzuola Fiorenzuola 38 28 51 33
19 MapelloBonate MapelloBonat 38 36 59 31
20 Sondrio Sondrio 38 39 73 27
TEMPORADA 2014/2015
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Castiglione Castiglione 36 54 26 74
2 Lecco Lecco 36 65 42 66
3 Seregno Seregno 36 64 37 65
4 Ciserano Ciserano 36 53 39 60
5 Virtus Verona Virtus 36 58 34 59
6 Pergolettese Pergolettese 36 46 44 55
7 Olginatese Olginatese 36 44 34 54
8 Pontisola Pontisola 36 50 42 52
9 Pol. Ciliverghe Pol. 36 37 40 51
10 Sondrio Sondrio 36 46 50 51
11 Aurora Seriate Aurora 36 42 43 50
12 Inveruno Inveruno 36 47 48 49
13 Pro Sesto Pro Sesto 36 38 41 47
14 Villafranca Villafranca 36 44 49 47
15 MapelloBonate MapelloBonat 36 36 48 47
16 Caravaggio Caravaggio 36 37 42 41
17 Folgore Caratese Folgore 36 34 40 37
18 AC Castellana Castellana 36 36 61 30
19 AC Montichiari Montichiari 36 26 97 5
TEMPORADA 2013/2014
LEGA PRO 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Bassano Virtus Bassano 34 62 35 69
2 US Alessandria Alessandria 34 59 39 57
3 Renate Renate 34 43 26 57
4 AC Monza AC Monza 34 57 43 54
5 Santarcangelo Santarcangel 34 44 26 53
6 SPAL SPAL 34 52 42 53
7 Mantova Mantova 34 57 46 52
8 Real Vicenza VS Real Vicenza 34 51 48 52
9 Forli Forli 34 53 45 49
10 Delta Porto Tolle Delta Porto 34 45 36 48
11 Cuneo Cuneo 34 43 32 47
12 Sassari Torres Sassari 34 40 44 47
13 Rimini Rimini 34 38 38 46
14 Virtus Verona Virtus 34 35 32 44
15 Pergolettese Pergolettese 34 27 35 36
16 Castiglione Castiglione 34 37 54 30
17 Bellaria Igea Bellaria 34 24 79 16
18 AS Bra AS Bra 34 29 96 12
TEMPORADA 2012/2013
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Pergolettese Pergolettese 38 64 27 84
2 Pontisola Pontisola 38 87 45 83
3 Olginatese Olginatese 38 59 32 70
4 Voghera Voghera 38 60 43 68
5 Lecco Lecco 38 66 42 62
6 AC Castellana Castellana 38 50 44 58
7 Caronnese Caronnese 38 50 46 58
8 Caravaggio Caravaggio 38 41 36 56
9 AC Montichiari Montichiari 38 58 53 54
10 Aurora Seriate Aurora 38 55 52 53
11 MapelloBonate MapelloBonat 38 60 56 48
12 Darfo Boario Darfo Boario 38 57 55 48
13 AlzanoCene AlzanoCene 38 62 63 47
14 Seregno Seregno 38 51 53 46
15 Fersina Perginese Fersina 38 52 56 46
16 Pro Sesto Pro Sesto 38 44 50 44
17 AC Mezzocorona Mezzocorona 38 49 76 32
18 Trento Trento 38 45 82 28
19 St. Georgen St. Georgen 38 47 85 27
20 Sant Angelo Sant Angelo 38 31 92 13
TEMPORADA 2011/2012
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Sterilgarda Castiglione Sterilgarda 38 55 36 76
2 Pontisola Pontisola 38 53 34 69
3 Olginatese Olginatese 38 57 43 65
4 Pergolettese Pergolettese 38 51 36 64
5 MapelloBonate MapelloBonat 38 60 51 61
6 Caronnese Caronnese 38 58 42 57
7 AlzanoCene AlzanoCene 38 55 45 54
8 AC Castellana Castellana 38 54 53 51
9 Fidenza Fidenza 38 35 39 50
10 Voghera Voghera 38 36 34 49
11 Pro Piacenza Piacenza 38 45 44 49
12 Aurora Seriate Aurora 38 44 45 49
13 Rudianese Rudianese 38 39 41 49
14 Gozzano Gozzano 38 43 43 48
15 Darfo Boario Darfo Boario 38 44 47 48
16 Seregno Seregno 38 48 52 43
17 Carpenedolo Carpenedolo 38 48 63 40
18 Colognese Colognese 38 35 55 40
19 Fiorenzuola Fiorenzuola 38 41 64 33
20 Gallaratese Gallaratese 38 22 56 23
TEMPORADA 2010/2011
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Borgo a Buggiano Borgo 34 53 23 69
2 Pontedera Pontedera 34 47 29 62
3 Bagnolese Bagnolese 34 55 38 56
4 Virtus Castelfranco Virtus 34 43 28 54
5 Mezzolara Mezzolara 34 51 48 53
6 Camaiore Calcio Camaiore 34 44 39 52
7 US Forcoli 1921 Forcoli 1921 34 42 39 51
8 Pergolettese Pergolettese 34 46 39 47
9 Rosignano Rosignano 34 39 32 47
10 Rudianese Rudianese 34 41 37 47
11 Tuttocuoio Tuttocuoio 34 38 35 46
12 Fiorenzuola Fiorenzuola 34 38 40 46
13 Ponsacco Ponsacco 34 28 23 44
14 Virtus Pavullese Virtus 34 37 40 44
15 AC Carpenedolo Carpenedolo 34 44 47 38
16 Castel San Pietro Terme Castel 34 33 48 31
17 US Russi US Russi 34 31 52 29
18 Nuova Verolese Nuova 34 14 87 6
TEMPORADA 2009/2010
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Tritium Tritium 34 68 24 80
2 AlzanoCene AlzanoCene 34 53 41 55
3 Pontisola Pontisola 34 53 42 54
4 Renate Renate 34 47 41 54
5 Darfo Boario Darfo Boario 34 42 36 54
6 Colognese Colognese 34 47 38 51
7 Caronnese Caronnese 34 53 49 50
8 Voghera Voghera 34 63 50 48
9 Cantù San Paolo Cantù Paolo 34 48 50 48
10 Pergolettese Pergolettese 34 50 49 45
11 Solbiatese Arno Calcio Solbiatese 34 42 44 42
12 Olginatese Olginatese 34 52 59 42
13 US Sestese US Sestese 34 34 43 41
14 Fiorenzuola Fiorenzuola 34 44 49 37
15 Folgore Caratese Folgore 34 26 36 36
16 Borgosesia Borgosesia 34 30 49 33
17 Caravaggio Caravaggio 34 40 60 29
18 Stradellina Stradellina 34 22 54 22
TEMPORADA 2008/2009
LEGA PRO 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Varese Varese 34 52 28 61
2 US Alessandria Alessandria 34 42 25 61
3 Como Como 34 40 34 56
4 AC Rodengo Saiano Rodengo 34 39 26 55
5 Olbia Calcio Olbia Calcio 34 36 29 54
6 AC Sambonifacese Sambonifaces 34 44 38 53
7 Itala S. Marco Itala Marco 34 36 29 50
8 FC Canavese FC Canavese 34 37 41 44
9 US Ivrea Calcio Ivrea Calcio 34 37 39 43
10 AC Mezzocorona Mezzocorona 34 36 40 42
11 Pavia Pavia 34 37 38 40
12 Pro Vercelli Vercelli 34 27 33 40
13 AC Montichiari Montichiari 34 43 47 38
14 Poli. Alghero Poli. 34 36 44 38
15 FC Südtirol Südtirol 34 31 40 36
16 Valenzana Calcio Valenzana 34 27 36 36
17 AC Carpenedolo Carpenedolo 34 29 41 33
18 Pergolettese Pergolettese 34 24 45 29

  USO DE MEMORIA  
6,803,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.1592
Total Execution Time  0.1615
  CADENA URL  
/historico/Pergolettese/2018
  GET DATOS  
$_GET['/historico/Pergolettese/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0031  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 = 'Pergolettese' AND l.year = 2018 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.0028  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=10711 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=10711 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=10711 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=10711 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=10711 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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 = 39596
0.0024  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 = 48697
0.0024  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 = 43433
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10711 AND type_rel = 2
0.0026  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 = '10711' ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '10711' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '10711' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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 = 48697 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 43433 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 39596 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=10711 AND l.year in (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0038  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 (49828,48698,43475,43433) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 49828 AND teamId = 10711
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 48698 AND teamId = 10711
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 43433 AND teamId = 10711
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 10711
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 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 = 39596 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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 = '10711' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10711' 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 = '10711' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  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 events2018 e ON e.player_id = p.id AND e.league_id = 39596 WHERE rp.league_id = 39596 AND rp.teamId = 10711 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.0034  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 events2018 e ON e.player_id = p.id AND e.league_id = 39596 WHERE rp.league_id = 39596 AND rp.teamId = 10711 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 events2018 e ON e.player_id = p.id AND e.league_id = 39596 WHERE rp.league_id = 39596 AND rp.teamId = 10711 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 10711 AND l.year <= 2018 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026  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 = 39596 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 = 33450 AND t.round = 34 ORDER BY team.conference 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 `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 = 15650 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 `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 = 4815 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 = 2745 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 `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 = 2088 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 `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 = 1692 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 24697 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 24710 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 447 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC