4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Cosenza

Cosenza

Entrenador: William Viali

Temporada 2023/2024
TEMPORADA 2023/2024
SERIE B
Equipo PJ GF GC Puntos
1 Parma Parma 35 63 32 73
2 Como Como 35 55 38 68
3 Venezia Venezia 35 64 40 67
4 Cremonese Cremonese 35 44 30 60
5 Catanzaro Catanzaro 35 55 44 57
6 Palermo FC Palermo FC 35 59 50 52
7 Brescia Brescia 35 38 35 47
8 Sampdoria Sampdoria 35 48 49 46
9 Pisa SC Pisa SC 35 47 48 45
10 Cittadella Cittadella 35 38 41 45
11 FC Südtirol Südtirol 35 40 42 43
12 Modena Modena 35 38 44 43
13 Reggiana Reggiana 35 36 43 43
14 Cosenza Cosenza 35 43 39 42
15 Ascoli Ascoli 35 34 38 37
16 Ternana Calcio Ternana 35 38 46 37
17 Spezia Spezia 35 31 46 37
18 SSC Bari SSC Bari 35 34 47 36
19 Feralpisalò Feralpisalò 35 41 60 32
20 Lecco Lecco 35 32 66 26
TEMPORADA 2022/2023
SERIE B
Equipo PJ GF GC Puntos
1 Frosinone Frosinone 38 63 26 80
2 Genoa Genoa 38 53 28 73
3 SSC Bari SSC Bari 38 58 37 65
4 Parma Parma 38 48 39 60
5 Cagliari Cagliari 38 50 34 60
6 FC Südtirol Südtirol 38 38 34 58
7 Reggina Reggina 38 49 45 50
8 Venezia Venezia 38 51 50 49
9 Palermo FC Palermo FC 38 48 49 49
10 Modena Modena 38 47 53 48
11 Pisa SC Pisa SC 38 48 42 47
12 Ascoli Ascoli 38 40 47 47
13 Como Como 38 47 48 47
14 Ternana Calcio Ternana 38 37 52 43
15 Cittadella Cittadella 38 34 45 43
16 Brescia Brescia 38 36 57 40
17 Cosenza Cosenza 38 30 53 40
18 Perugia Perugia 38 40 52 39
19 SPAL SPAL 38 41 51 38
20 Benevento Benevento 38 33 49 35
TEMPORADA 2021/2022
SERIE B
Equipo PJ GF GC Puntos
1 Lecce Lecce 38 59 31 71
2 Cremonese Cremonese 38 57 39 69
3 Pisa SC Pisa SC 38 48 35 67
4 AC Monza AC Monza 38 60 38 67
5 Brescia Brescia 38 55 35 66
6 Ascoli Ascoli 38 52 42 65
7 Benevento Benevento 38 62 39 63
8 Perugia Perugia 38 40 32 58
9 Frosinone Frosinone 38 58 45 58
10 Ternana Calcio Ternana 38 58 61 54
11 Cittadella Cittadella 38 38 36 52
12 Parma Parma 38 48 43 49
13 Como Como 38 49 54 47
14 Reggina Reggina 38 31 49 46
15 SPAL SPAL 38 46 54 42
16 Cosenza Cosenza 38 36 59 35
17 Vicenza Vicenza 38 38 59 34
18 US Alessandria Alessandria 38 37 59 34
19 Crotone Crotone 38 41 61 26
20 Pordenone Pordenone 38 29 71 18
TEMPORADA 2020/2021
SERIE B
Equipo PJ GF GC Puntos
1 Empoli Empoli 38 68 35 73
2 Salernitana Salernitana 38 46 34 69
3 AC Monza AC Monza 38 51 33 64
4 Lecce Lecce 38 68 47 62
5 Venezia Venezia 38 53 39 59
6 Cittadella Cittadella 38 48 35 57
7 Brescia Brescia 38 61 53 56
8 Chievo Chievo 38 50 37 56
9 SPAL SPAL 38 44 42 56
10 Frosinone Frosinone 38 38 42 50
11 Reggina Reggina 38 42 45 50
12 Vicenza Vicenza 38 48 53 48
13 Cremonese Cremonese 38 46 44 48
14 Pisa SC Pisa SC 38 54 59 48
15 Pordenone Pordenone 38 40 39 45
16 Ascoli Ascoli 38 37 48 44
17 Cosenza Cosenza 38 29 47 35
18 Reggiana Reggiana 38 31 57 34
19 Pescara Pescara 38 29 60 32
20 Virtus Entella Virtus 38 30 64 23
TEMPORADA 2019/2020
SERIE B
Equipo PJ GF GC Puntos
1 Benevento Benevento 38 67 27 86
2 Crotone Crotone 38 63 40 68
3 Spezia Spezia 38 54 40 61
4 Pordenone Pordenone 38 48 46 58
5 Cittadella Cittadella 38 49 49 58
6 Chievo Chievo 38 48 38 56
7 Empoli Empoli 38 47 48 54
8 Frosinone Frosinone 38 41 38 54
9 Pisa SC Pisa SC 38 49 45 54
10 Salernitana Salernitana 38 53 50 52
11 Venezia Venezia 38 37 40 50
12 Cremonese Cremonese 38 42 43 49
13 Virtus Entella Virtus 38 46 50 48
14 Ascoli Ascoli 38 50 58 46
15 Cosenza Cosenza 38 50 49 46
16 Perugia Perugia 38 38 49 45
17 Pescara Pescara 38 48 55 45
18 Trapani Trapani 38 48 60 44
19 Juve Stabia Juve Stabia 38 47 63 41
20 Livorno Livorno 38 30 67 21
TEMPORADA 2018/2019
SERIE B
Equipo PJ GF GC Puntos
1 Brescia Brescia 36 69 42 67
2 Lecce Lecce 36 66 45 66
3 Benevento Benevento 36 61 45 60
4 Pescara Pescara 36 50 46 55
5 Hellas Verona Hellas 36 49 46 52
6 Cittadella Cittadella 36 49 38 51
7 Spezia Spezia 36 53 46 51
8 Perugia Perugia 36 49 49 50
9 Cremonese Cremonese 36 37 33 49
10 Cosenza Cosenza 36 34 42 46
11 Palermo FC Palermo FC 36 57 38 43
12 Crotone Crotone 36 40 42 43
13 Ascoli Ascoli 36 40 56 43
14 Livorno Livorno 36 38 51 39
15 Venezia Venezia 36 35 46 38
16 Salernitana Salernitana 36 41 57 38
17 Calcio Foggia Calcio 36 44 49 37
18 Padova Padova 36 36 49 31
19 AC Carpi AC Carpi 36 39 67 29
TEMPORADA 2017/2018
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Lecce Lecce 36 53 30 74
2 Catania Catania 36 65 31 70
3 Trapani Trapani 36 60 35 68
4 Juve Stabia Juve Stabia 36 49 35 55
5 Cosenza Cosenza 36 41 35 54
6 Monopoli Monopoli 36 46 35 53
7 Casertana Casertana 36 37 32 50
8 Rende Rende 36 31 35 50
9 Siracusa Siracusa 36 37 29 47
10 Matera Matera 36 40 37 46
11 Sicula Leonzio Sicula 36 37 37 46
12 Virtus Francavilla Virtus 36 35 43 46
13 Bisceglie Bisceglie 36 39 46 45
14 Catanzaro Catanzaro 36 35 45 42
15 Reggina Reggina 36 29 38 41
16 Fidelis Andria Fidelis 36 36 40 38
17 Paganese Paganese 36 36 56 33
18 Fondi Fondi 36 33 52 30
19 Akragas Akragas 36 18 66 6
TEMPORADA 2016/2017
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Calcio Foggia Calcio 38 70 29 85
2 Lecce Lecce 38 62 36 74
3 Matera Matera 38 71 44 65
4 Juve Stabia Juve Stabia 38 65 43 64
5 Siracusa Siracusa 38 47 43 57
6 Virtus Francavilla Virtus 38 47 45 57
7 Cosenza Cosenza 38 57 46 55
8 Paganese Paganese 38 51 45 51
9 Casertana Casertana 38 38 42 49
10 Fondi Fondi 38 49 46 49
11 Fidelis Andria Fidelis 38 30 33 47
12 Catania Catania 38 40 36 47
13 ACR Messina ACR Messina 38 38 52 46
14 Reggina Reggina 38 44 54 45
15 Monopoli Monopoli 38 42 54 42
16 Akragas Akragas 38 30 47 39
17 US Vibonese Calcio Vibonese 38 27 46 39
18 Catanzaro Catanzaro 38 36 49 38
19 Melfi Melfi 38 38 68 34
20 Taranto Taranto 38 25 49 30
TEMPORADA 2015/2016
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Benevento Benevento 34 51 21 71
2 Calcio Foggia Calcio 34 61 31 65
3 Lecce Lecce 34 46 28 63
4 Casertana Casertana 34 52 35 63
5 Cosenza Cosenza 34 44 28 60
6 Matera Matera 34 45 32 55
7 Catania Catania 34 37 34 49
8 Fidelis Andria Fidelis 34 33 21 45
9 ACR Messina ACR Messina 34 37 41 45
10 Akragas Akragas 34 35 47 45
11 Paganese Paganese 34 41 39 43
12 Juve Stabia Juve Stabia 34 45 45 42
13 Catanzaro Catanzaro 34 27 40 41
14 Monopoli Monopoli 34 43 42 39
15 Melfi Melfi 34 32 40 30
16 Ischia Ischia 34 31 65 25
17 Martina Franca Martina 34 30 58 24
18 Lupa Cast Rom Lupa Cast 34 22 65 13
TEMPORADA 2014/2015
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Salernitana Salernitana 38 56 31 80
2 Benevento Benevento 38 55 29 76
3 Juve Stabia Juve Stabia 38 58 37 70
4 Matera Matera 38 56 38 70
5 Casertana Casertana 38 59 35 69
6 Lecce Lecce 38 50 32 67
7 Calcio Foggia Calcio 38 63 36 66
8 Catanzaro Catanzaro 38 48 44 53
9 Melfi Melfi 38 43 44 48
10 Barletta Barletta 38 35 42 47
11 Cosenza Cosenza 38 37 39 44
12 Vigor Lamezia Vigor 38 43 48 44
13 Lupa Roma Lupa Roma 38 40 62 40
14 Martina Franca Martina 38 34 42 38
15 Paganese Paganese 38 30 45 37
16 Real Agro Aversa Real Agro A. 38 36 50 34
17 ACR Messina ACR Messina 38 38 55 34
18 Ischia Ischia 38 32 55 34
19 FC Savoia 1908 Savoia 1908 38 36 59 32
20 Reggina Reggina 38 33 59 32
TEMPORADA 2013/2014
LEGA PRO 2 GRUPO 2
Equipo PJ GF GC Puntos
1 ACR Messina ACR Messina 34 43 33 57
2 Casertana Casertana 34 38 28 57
3 Teramo Teramo 34 48 34 55
4 Cosenza Cosenza 34 38 29 55
5 Calcio Foggia Calcio 34 50 40 51
6 Melfi Melfi 34 39 31 51
7 Ischia Ischia 34 33 29 48
8 Vigor Lamezia Vigor 34 37 39 46
9 Sorrento Sorrento 34 40 36 45
10 Tuttocuoio Tuttocuoio 34 41 38 44
11 Real Agro Aversa Real Agro A. 34 36 40 43
12 Arzanese Arzanese 34 41 46 43
13 Martina Franca Martina 34 36 36 42
14 Chieti Chieti 34 34 35 41
15 Aprilia Aprilia 34 41 50 41
16 Poggibonsi Poggibonsi 34 31 41 36
17 Castel Rigone Castel 34 39 56 34
18 Follonica Gavorrano Follonica 34 24 48 30
TEMPORADA 2012/2013
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 ACR Messina ACR Messina 34 59 24 77
2 Cosenza Cosenza 34 65 41 73
3 Gelbison Gelbison 34 39 28 60
4 FC Messina FC Messina 34 55 40 58
5 US Vibonese Calcio Vibonese 34 42 31 51
6 Comprensorio Normanno Comprensorio 34 40 37 50
7 FC Savoia 1908 Savoia 1908 34 54 52 48
8 Cavese 1919 Cavese 1919 34 47 38 47
9 Noto Noto 34 46 36 46
10 Licata Licata 34 50 46 46
11 Rios Renovables Ribera Nava Rios 34 39 37 46
12 Montalto Comprensorio Montalto 34 44 38 45
13 AC Palazzolo Palazzolo 34 44 45 44
14 Agropoli Agropoli 34 35 37 44
15 Ragusa Ragusa 34 38 42 39
16 ASD Sambiase Sambiase 34 42 43 38
17 Acireale Acireale 34 21 74 15
18 Nissa FC ASD Nissa 34 12 83 8
TEMPORADA 2011/2012
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 ASD HinterReggio HinterReggio 34 58 34 60
2 Cosenza Cosenza 34 56 35 59
3 ACR Messina ACR Messina 34 49 36 58
4 AC Palazzolo Palazzolo 34 50 30 53
5 Battipagliese Battipaglies 33 53 41 53
6 Nuvla San Felice Nuvla Felice 34 43 41 50
7 Polisportiva A… Polisportiva 34 43 45 49
8 Noto Noto 34 51 39 48
9 AC Sant Antoni… Sant 34 55 54 47
10 Licata Licata 34 50 50 47
11 Serre Alburni Serre 34 38 37 45
12 ASD Sambiase Sambiase 34 41 44 45
13 Acri Acri 33 40 42 43
14 Acireale Acireale 33 29 35 39
15 Marsala Marsala 34 34 44 38
16 Nissa FC ASD Nissa 34 30 37 36
17 Valle Grecanica Valle 33 29 46 30
18 Cittanova Interpiana Cittanova 34 20 79 20
TEMPORADA 2010/2011
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Nocerina Nocerina 34 51 30 72
2 Benevento Benevento 34 53 40 61
3 Atlético Roma Atlético 34 53 33 57
4 Juve Stabia Juve Stabia 34 43 35 55
5 Taranto Taranto 34 36 28 55
6 Calcio Foggia Calcio 34 67 58 47
7 Lucchese Libertas Lucchese 34 42 38 44
8 Cosenza Cosenza 34 36 38 44
9 Virtus Lanciano Virtus 34 28 31 44
10 Siracusa Siracusa 34 32 38 44
11 Pisa SC Pisa SC 34 39 40 43
12 Barletta Barletta 34 32 38 40
13 Gela Gela 34 31 42 40
14 AS Andria BAT Andria 34 31 37 39
15 Ternana Calcio Ternana 34 30 46 38
16 Foligno Calcio Foligno 34 36 45 35
17 Cavese 1919 Cavese 1919 34 31 41 35
18 Viareggio Viareggio 34 30 43 31

  USO DE MEMORIA  
7,400,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1452
Total Execution Time  0.1464
  CADENA URL  
/historico/Nuova-Cosenza
  GET DATOS  
$_GET['/historico/Nuova-Cosenza']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0040  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 = 'Nuova-Cosenza' 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.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=10755 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=10755 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=10755 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=10755 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10755 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 = '10755' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '10755' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 72045 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=10755 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73270,72045,71760,71432) 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 WHERE league_id = 72045 AND teamId = 10755
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73270 AND teamId = 10755
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71760 AND teamId = 10755
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 10755
0.0027  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 = '10755' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10755' 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 = '10755' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040  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 = 72045 WHERE rp.league_id = 72045 AND rp.teamId = 10755 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.0042  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 = 72045 WHERE rp.league_id = 72045 AND rp.teamId = 10755 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 events2024 e ON e.player_id = p.id AND e.league_id = 72045 WHERE rp.league_id = 72045 AND rp.teamId = 10755 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 10755 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72045 AND t.round = 35 ORDER BY team.conference ASC,t.position 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 `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 = 67914 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.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 `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 = 62741 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.0064  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 = 58563 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.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 `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 = 49921 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.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 `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 = 38931 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 `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 = 33445 AND t.round = 38 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 `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 = 15399 AND t.round = 34 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 = 4074 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 `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 = 2746 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 2092 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 `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 = 1699 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 `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 = 1218 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC