4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Imolese
TEMPORADA 2023/2024
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Ravenna FC Ravenna FC 33 58 13 69
2 AC Carpi AC Carpi 33 64 32 69
3 Lentigione Lentigione 33 52 31 59
4 Forli Forli 33 47 36 58
5 Victor San Marino Victor 33 44 38 57
6 Corticella Corticella 32 57 40 55
7 Sangiuliano City Nova Sangiuliano 33 35 36 47
8 Prato Prato 33 39 42 47
9 Fanfulla Fanfulla 33 31 35 46
10 Imolese Imolese 33 33 32 44
11 Aglianese Aglianese 33 35 37 44
12 Sant Angelo Sant Angelo 32 48 45 41
13 Sammaurese Sammaurese 33 37 48 38
14 Progresso Progresso 33 27 45 35
15 Pistoiese Pistoiese 31 22 39 32
16 Borgo San Donnino Borgo 33 31 57 28
17 Calcio Certaldo Calcio 33 23 51 27
18 Mezzolara Mezzolara 33 22 48 23
TEMPORADA 2022/2023
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Reggiana Reggiana 38 63 27 81
2 Cesena Cesena 38 66 24 79
3 Virtus Entella Virtus 38 60 31 79
4 Carrarese Carrarese 38 51 42 62
5 AS Gubbio 1910 Gubbio 1910 38 50 34 61
6 Pontedera Pontedera 38 48 39 60
7 Ancona Ancona 38 55 44 58
8 Lucchese Libertas Lucchese 38 36 32 51
9 Siena Siena 38 40 40 48
10 Rimini Rimini 38 43 41 47
11 Recanatese Recanatese 38 39 43 47
12 Fermana Fermana 38 43 49 44
13 Olbia Calcio Olbia Calcio 38 43 50 41
14 Fiorenzuola Fiorenzuola 38 31 44 41
15 Sassari Torres Sassari 38 33 36 41
16 Vis Pesaro Vis Pesaro 38 24 55 39
17 US Alessandria Alessandria 38 33 52 38
18 San Donato Tavarnelle Donato 38 40 62 37
19 Imolese Imolese 38 29 55 30
20 Montevarchi Calcio Montevarchi 38 32 59 28
TEMPORADA 2021/2022
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Modena Modena 38 69 25 88
2 Reggiana Reggiana 38 72 26 86
3 Cesena Cesena 38 53 31 67
4 Virtus Entella Virtus 38 62 40 65
5 Pescara Pescara 38 56 41 65
6 Ancona Ancona 38 61 50 57
7 AS Gubbio 1910 Gubbio 1910 38 53 44 52
8 Lucchese Libertas Lucchese 38 39 39 50
9 Olbia Calcio Olbia Calcio 38 44 47 46
10 Carrarese Carrarese 38 39 55 45
11 Vis Pesaro Vis Pesaro 38 35 56 45
12 Montevarchi Calcio Montevarchi 38 41 55 45
13 Siena Siena 38 40 41 44
14 Pontedera Pontedera 38 38 56 43
15 Teramo Teramo 38 36 57 42
16 Viterbese Viterbese 38 44 51 39
17 Imolese Imolese 38 42 56 37
18 Pistoiese Pistoiese 38 40 59 36
19 Fermana Fermana 38 31 49 35
20 Grosseto Grosseto 38 30 47 30
TEMPORADA 2020/2021
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Perugia Perugia 38 67 30 79
2 Padova Padova 38 68 26 79
3 FC Südtirol Südtirol 38 66 29 75
4 Modena Modena 38 51 28 70
5 Feralpisalò Feralpisalò 38 54 46 60
6 Triestina Triestina 38 48 40 59
7 Cesena Cesena 38 51 42 57
8 Matelica Calcio Matelica 38 59 62 56
9 Sambenedettese Sambenedette 38 43 43 54
10 Mantova Mantova 38 47 49 49
11 Virtus Verona Virtus 38 43 44 49
12 AS Gubbio 1910 Gubbio 1910 38 40 45 48
13 Fermana Fermana 38 31 44 42
14 Vis Pesaro Vis Pesaro 38 41 57 41
15 AC Carpi AC Carpi 38 45 62 41
16 Legnago Salus Legnago 38 35 47 38
17 Imolese Imolese 38 34 55 35
18 Fano Fano 38 32 47 33
19 Ravenna FC Ravenna FC 38 32 62 30
20 SS Arezzo SS Arezzo 38 37 66 29
TEMPORADA 2019/2020
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Vicenza Vicenza 27 41 12 61
2 Reggiana Reggiana 27 45 25 55
3 AC Carpi AC Carpi 26 44 21 53
4 FC Südtirol Südtirol 27 43 24 48
5 Feralpisalò Feralpisalò 26 34 31 44
6 Padova Padova 26 35 19 44
7 Piacenza Piacenza 26 32 24 41
8 Modena Modena 27 29 25 40
9 Triestina Triestina 27 36 32 40
10 Fermana Fermana 27 22 33 33
11 Sambenedettese Sambenedette 26 31 31 33
12 Virtus Verona Virtus 27 33 35 32
13 Cesena Cesena 27 33 42 30
14 AS Gubbio 1910 Gubbio 1910 27 23 31 28
15 Vis Pesaro Vis Pesaro 27 22 37 28
16 Ravenna FC Ravenna FC 27 25 41 27
17 Imolese Imolese 27 20 35 23
18 Arzignano Valchiampo Arzignano 26 18 32 22
19 Fano Fano 27 24 42 21
20 Rimini Rimini 27 24 42 21
TEMPORADA 2018/2019
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Pordenone Pordenone 38 56 32 73
2 Triestina Triestina 38 60 33 67
3 Imolese Imolese 38 51 33 62
4 Feralpisalò Feralpisalò 38 50 41 62
5 AC Monza AC Monza 38 45 35 60
6 FC Südtirol Südtirol 38 42 33 55
7 Ravenna FC Ravenna FC 38 39 38 55
8 Vicenza Vicenza 38 43 38 51
9 Sambenedettese Sambenedette 38 40 40 50
10 Fermana Fermana 38 21 35 47
11 Ternana Calcio Ternana 38 39 40 44
12 AS Gubbio 1910 Gubbio 1910 38 35 45 44
13 AlbinoLeffe AlbinoLeffe 38 31 35 43
14 Teramo Teramo 38 36 46 43
15 Vis Pesaro Vis Pesaro 38 29 31 42
16 Giana Erminio Giana 38 42 50 42
17 Renate Renate 38 23 33 39
18 Rimini Rimini 38 28 44 39
19 Virtus Verona Virtus 38 36 50 38
20 Fano Fano 38 18 32 38
TEMPORADA 2017/2018
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Rimini Rimini 38 65 38 80
2 Imolese Imolese 38 72 45 71
3 Forli Forli 38 60 43 65
4 Fiorenzuola Fiorenzuola 38 50 32 64
5 Sangiovannese Sangiovannes 38 42 38 61
6 Lentigione Lentigione 38 45 33 60
7 Villabiagio Villabiagio 38 52 49 59
8 Pianese Pianese 38 54 35 58
9 Montevarchi Calcio Montevarchi 38 42 40 56
10 Romagna Centro Romagna 38 49 42 54
11 Sammaurese Sammaurese 38 34 29 54
12 Vigor Carpaneto Vigor 38 50 48 45
13 Sasso Marconi Sasso 38 35 48 45
14 Tuttocuoio Tuttocuoio 38 25 34 42
15 Sporting Trestina Sporting 38 36 52 41
16 Castelvetro Castelvetro 38 46 62 38
17 Mezzolara Mezzolara 38 34 50 36
18 Sansepolcro Calcio Sansepolcro 38 40 62 33
19 Correggese Correggese 38 37 55 32
20 VF Colligiana Colligiana 38 27 60 29
TEMPORADA 2016/2017
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Ravenna FC Ravenna FC 34 52 26 65
2 Imolese Imolese 34 60 35 63
3 Delta Porto Tolle Delta Porto 34 57 37 61
4 Lentigione Lentigione 34 40 31 58
5 Correggese Correggese 34 58 48 56
6 Castelvetro Castelvetro 34 60 57 50
7 Pianese Pianese 34 46 48 46
8 Scandicci Scandicci 34 45 55 46
9 Mezzolara Mezzolara 34 43 46 45
10 San Donato Tavarnelle Donato 34 50 47 44
11 USD Rignanese Rignanese 34 34 35 44
12 VF Colligiana Colligiana 34 46 47 43
13 Fiorenzuola Fiorenzuola 34 39 45 43
14 Adriese Adriese 34 46 51 39
15 Ribelle Ribelle 34 45 46 38
16 Sangiovannese Sangiovannes 34 42 51 37
17 Virtus Castelfranco Virtus 34 25 41 33
18 Poggibonsi Poggibonsi 34 24 66 21
TEMPORADA 2015/2016
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Parma Parma 38 82 17 94
2 Alto Vicentino Alto 38 84 43 77
3 Forli Forli 38 69 46 69
4 San Marino Calcio Marino 38 55 41 65
5 Correggese Correggese 38 66 49 64
6 Imolese Imolese 38 63 41 63
7 Delta Porto Tolle Delta Porto 38 68 51 61
8 Ribelle Ribelle 38 63 54 61
9 Lentigione Lentigione 38 52 50 59
10 Sammaurese Sammaurese 38 53 50 54
11 Arzignano Valchiampo Arzignano 38 60 54 53
12 Legnago Salus Legnago 38 55 53 51
13 Ravenna FC Ravenna FC 38 50 59 44
14 Romagna Centro Romagna 38 40 51 44
15 Virtus Castelfranco Virtus 38 50 59 42
16 Mezzolara Mezzolara 38 30 55 35
17 Villafranca Villafranca 38 45 62 33
18 Bellaria Igea Bellaria 38 38 76 29
19 Clodiense Clodiense 38 35 81 27
20 Fortis Juventus Fortis 38 31 97 13
TEMPORADA 2014/2015
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Rimini Rimini 38 81 35 86
2 Delta Porto Tolle Delta Porto 38 83 38 74
3 Correggese Correggese 38 71 45 72
4 Piacenza Piacenza 38 60 34 72
5 AC Este AC Este 38 69 41 67
6 Abano Terme Abano Terme 38 49 47 53
7 Fiorenzuola Fiorenzuola 38 46 45 52
8 Bellaria Igea Bellaria 37 41 46 51
9 Scandicci Scandicci 38 47 49 48
10 Jolly Montemurlo Jolly 38 49 57 47
11 Imolese Imolese 38 45 50 46
12 Fortis Juventus Fortis 38 42 53 46
13 Virtus Castelfranco Virtus 38 49 59 45
14 Ribelle Ribelle 38 41 54 44
15 Mezzolara Mezzolara 37 49 58 43
16 Fidenza Fidenza 38 36 45 41
17 Romagna Centro Romagna 38 50 67 37
18 Luparense Luparense 38 37 61 36
19 Thermal Abano Thermal 38 39 69 31
20 Formigine Formigine 38 36 67 28
TEMPORADA 2013/2014
SERIE D GRUPO 4
Equipo PJ GF GC Puntos
1 Lucchese Libertas Lucchese 34 74 21 82
2 Correggese Correggese 34 88 22 81
3 Massese Massese 34 62 25 67
4 Thermal Abano Thermal 34 64 34 67
5 Romagna Centro Romagna 34 71 33 66
6 Fortis Juventus Fortis 34 68 44 62
7 Mezzolara Mezzolara 34 65 57 57
8 Imolese Imolese 34 54 47 51
9 Clodiense Clodiense 34 46 46 44
10 Formigine Formigine 34 41 51 42
11 Virtus Castelfranco Virtus 34 46 49 41
12 Sancolombano Sancolombano 34 35 43 38
13 Fidenza Fidenza 34 39 45 37
14 Camaiore Calcio Camaiore 34 36 48 29
15 AC Montichiari Montichiari 34 49 77 29
16 AC Palazzolo Palazzolo 34 33 60 22
17 US Forcoli 1921 Forcoli 1921 34 20 64 21
18 Riccione Riccione 34 20 145 12

  USO DE MEMORIA  
6,779,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5511
Total Execution Time  0.5524
  CADENA URL  
/historico/Imolese
  GET DATOS  
$_GET['/historico/Imolese']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0162  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 = 'Imolese' 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.0129  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=24969 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=24969 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=24969 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0268  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 = 73982
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=24969 AND type_rel = 2
0.0132  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 = '24969' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '24969' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73982 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=24969 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (73982,73559,68592) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 68592 AND teamId = 24969
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73982 AND teamId = 24969
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 24969
0.0127  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 = '24969' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '24969' and rp.type = 4
0.0127  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 = '24969' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0141  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 = 73982 WHERE rp.league_id = 73982 AND rp.teamId = 24969 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.0142  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 = 73982 WHERE rp.league_id = 73982 AND rp.teamId = 24969 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 73982 WHERE rp.league_id = 73982 AND rp.teamId = 24969 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 = 24969 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0140  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 = 73982 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 68592 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 63825 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 58761 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 51022 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 44232 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 39598 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 33452 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 15652 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 4817 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 24675 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC