4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Montevarchi Calcio
TEMPORADA 2023/2024
SERIE D GRUPO 5
Equipo PJ GF GC Puntos
1 Pianese Pianese 33 61 34 67
2 Grosseto Grosseto 33 52 30 63
3 Follonica Gavorrano Follonica 33 43 25 62
4 Livorno Livorno 33 49 31 59
5 Tau Altopascio Altopascio 33 54 30 57
6 Seravezza Seravezza 33 47 39 54
7 Ghivizzano Borgo Ghivizzano 33 54 53 50
8 Poggibonsi Poggibonsi 33 44 41 49
9 AS Figline AS Figline 33 44 39 49
10 Sangiovannese Sangiovannes 33 29 34 42
11 Montevarchi Calcio Montevarchi 33 39 40 40
12 Sporting Trestina Sporting 33 40 44 40
13 San Donato Tavarnelle Donato 33 29 32 39
14 Orvietana Calcio Orvietana 33 32 44 35
15 Real Forte Querceta Real Forte. 33 30 44 28
16 Vivi Altotevere Sansepolcro Vivi 33 23 45 28
17 Ponsacco Ponsacco 33 33 57 20
18 SC Cenaia SC Cenaia 33 26 67 16
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 D GRUPO 5
Equipo PJ GF GC Puntos
1 Montevarchi Calcio Montevarchi 34 68 32 71
2 Trastevere Trastevere 34 56 38 60
3 Sporting Trestina Sporting 34 48 33 56
4 San Donato Tavarnelle Donato 34 48 41 54
5 Siena Siena 34 48 40 53
6 Pianese Pianese 34 42 34 51
7 Follonica Gavorrano Follonica 34 48 37 51
8 Lornano Badesse Lornano 34 51 44 48
9 Tiferno Lerchi Tiferno 34 44 48 47
10 Cannara Cannara 34 41 48 47
11 Sangiovannese Sangiovannes 34 42 43 45
12 Montespaccato Montespaccat 34 40 47 41
13 Ostia Mare Ostia Mare 34 50 54 39
14 Flaminia Flaminia 34 44 57 39
15 Foligno Calcio Foligno 34 35 48 36
16 Scandicci Scandicci 34 42 49 35
17 Grassina Grassina 34 32 52 30
18 Sinalunghese Sinalunghese 34 24 58 23
TEMPORADA 2019/2020
SERIE D GRUPO 5
Equipo PJ GF GC Puntos
1 Grosseto Grosseto 26 44 25 52
2 Monterosi Tuscia Monterosi 26 35 20 50
3 Grassina Grassina 26 39 32 46
4 Albalonga Albalonga 26 36 24 45
5 Montevarchi Calcio Montevarchi 26 35 26 40
6 Scandicci Scandicci 26 45 30 39
7 Foligno Calcio Foligno 26 33 27 36
8 Aglianese Aglianese 26 35 30 34
9 Follonica Gavorrano Follonica 26 33 31 34
10 Flaminia Flaminia 26 31 29 34
11 Cannara Cannara 26 31 31 33
12 Sporting Trestina Sporting 26 34 35 33
13 Sangiovannese Sangiovannes 26 25 37 32
14 San Donato Tavarnelle Donato 26 30 32 31
15 Pomezia Pomezia 26 23 34 26
16 Bastia Calcio Bastia 26 22 36 26
17 Ponsacco Ponsacco 26 20 46 17
18 Tuttocuoio Tuttocuoio 26 19 45 16
TEMPORADA 2018/2019
SERIE D GRUPO 5
Equipo PJ GF GC Puntos
1 Pianese Pianese 38 58 21 74
2 Ponsacco Ponsacco 38 61 27 73
3 Seravezza Seravezza 38 62 42 65
4 Follonica Gavorrano Follonica 38 49 34 64
5 Montevarchi Calcio Montevarchi 38 49 38 64
6 San Donato Tavarnelle Donato 38 51 32 63
7 Ghivizzano Borgo Ghivizzano 38 50 37 60
8 Prato Prato 38 50 48 55
9 Tuttocuoio Tuttocuoio 38 43 43 55
10 Cannara Cannara 38 33 38 51
11 Sporting Trestina Sporting 38 39 40 50
12 Aglianese Aglianese 38 43 52 46
13 Real Forte Querceta Real Forte. 38 42 54 46
14 Sangiovannese Sangiovannes 38 36 41 45
15 Bastia Calcio Bastia 38 45 56 45
16 Scandicci Scandicci 38 44 53 43
17 Viareggio Viareggio 38 42 50 37
18 Sinalunghese Sinalunghese 38 30 54 37
19 Sangimignanosport Sangimignano 38 22 51 36
20 Massese Massese 38 26 64 16
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 2010/2011
SERIE D GRUPO 5
Equipo PJ GF GC Puntos
1 Perugia Perugia 34 51 24 74
2 Castel Rigone Castel 34 64 44 62
3 Sansepolcro Calcio Sansepolcro 34 44 28 60
4 Todi Todi 34 49 33 58
5 Pianese Pianese 34 54 46 55
6 Città di Castello Città 34 44 38 51
7 Flaminia Flaminia 34 44 35 48
8 Scandicci Scandicci 34 43 44 46
9 SS Arezzo SS Arezzo 34 42 41 45
10 ASD Sporting Terni Sporting 34 43 43 44
11 ASD Pontevecchio Pontevecchio 34 44 46 43
12 Voluntas Voluntas 34 41 37 42
13 AS Sestese AS Sestese 34 43 51 38
14 Orvietana Calcio Orvietana 34 39 50 37
15 Montevarchi Calcio Montevarchi 34 39 61 35
16 Deruta Deruta 34 32 56 34
17 Fortis Juventus Fortis 34 37 56 33
18 AC Monteriggioni Monteriggion 34 33 53 29
TEMPORADA 2009/2010
SERIE D GRUPO 5
Equipo PJ GF GC Puntos
1 Follonica Gavorrano Follonica 34 55 38 62
2 ACD Guidonia Guidonia 34 61 43 57
3 Castel Rigone Castel 34 54 33 55
4 Città di Castello Città 34 51 35 55
5 Monterotondo Lupa Monterotondo 34 53 38 54
6 Deruta Deruta 34 41 33 51
7 Sansepolcro Calcio Sansepolcro 34 42 38 51
8 AS Sestese AS Sestese 34 40 50 46
9 US Forcoli 1921 Forcoli 1921 34 36 37 44
10 Scandicci Scandicci 34 37 42 44
11 Montevarchi Calcio Montevarchi 34 34 33 43
12 Fortis Juventus Fortis 34 34 45 42
13 ASD Pontevecchio Pontevecchio 34 42 47 41
14 Orvietana Calcio Orvietana 34 34 43 41
15 AC Monteriggioni Monteriggion 34 34 47 40
16 ASD Sporting Terni Sporting 34 42 57 40
17 Calenzano Calenzano 34 27 38 38
18 Sangimignanosport Sangimignano 34 27 47 33
TEMPORADA 2008/2009
SERIE D GRUPO 5
Equipo PJ GF GC Puntos
1 Lucchese Libertas Lucchese 38 86 28 83
2 Sansepolcro Calcio Sansepolcro 38 52 36 71
3 Follonica Gavorrano Follonica 38 69 35 65
4 AS Sestese AS Sestese 38 51 36 62
5 Montevarchi Calcio Montevarchi 38 61 48 62
6 Deruta Deruta 38 51 36 61
7 GSD Arrone GSD Arrone 38 66 62 61
8 Rieti Rieti 38 53 47 57
9 Pontedera Pontedera 38 50 38 56
10 ASD Cecina ASD Cecina 38 42 47 52
11 Ponsacco Ponsacco 38 42 47 50
12 Scandicci Scandicci 38 45 53 50
13 US Forcoli 1921 Forcoli 1921 38 41 52 47
14 Orvietana Calcio Orvietana 38 39 37 46
15 AC Sansovino Sansovino 38 55 57 45
16 Fortis Juventus Fortis 38 36 47 44
17 ASD Pontevecchio Pontevecchio 38 47 59 41
18 Sangimignanosport Sangimignano 38 37 54 39
19 Armando Picchi Calcio Armando 38 34 55 34
20 Massese Massese 38 24 107 8
TEMPORADA 2005/2006
LEGA PRO 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Cavese 1919 Cavese 1919 34 47 18 66
2 Sassuolo Sassuolo 34 43 32 57
3 AC Sansovino Sansovino 34 31 25 56
4 Benevento Benevento 34 34 33 49
5 Ancona Ancona 34 30 25 48
6 Cuoiovaldarno Cuoiovaldarn 34 34 34 47
7 Castelnuovo Garfagnana Castelnuovo 34 31 29 45
8 Reggiana Reggiana 34 30 27 44
9 Bellaria Igea Bellaria 34 34 33 44
10 Foligno Calcio Foligno 34 37 42 44
11 SPAL SPAL 34 40 37 43
12 AS Gubbio 1910 Gubbio 1910 34 33 32 43
13 Gualdo Gualdo 34 43 47 43
14 Carrarese Carrarese 34 27 32 42
15 Prato Prato 34 27 38 37
16 Montevarchi Calcio Montevarchi 34 26 33 36
17 Castel San Pietro Terme Castel 34 38 46 34
18 Forli Forli 34 20 42 27
TEMPORADA 1999/2000
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 Siena Siena 34 39 22 58
2 Pisa SC Pisa SC 34 34 23 57
3 Cittadella Cittadella 34 39 27 55
4 Varese Varese 34 42 27 53
5 Brescello Brescello 34 35 32 50
6 Lucchese Libertas Lucchese 34 35 30 49
7 SPAL SPAL 34 34 31 46
8 Livorno Livorno 33 38 33 45
9 AlbinoLeffe AlbinoLeffe 34 36 37 45
10 Como Como 33 28 28 41
11 Carrarese Carrarese 34 30 35 41
12 Reggiana Reggiana 34 33 36 40
13 Modena Modena 33 23 31 40
14 Lumezzane Lumezzane 34 29 37 38
15 Lecco Lecco 34 26 38 36
16 Cremonese Cremonese 34 27 36 35
17 Montevarchi Calcio Montevarchi 33 27 34 32
18 Sandonà Sandonà 34 24 42 26

  USO DE MEMORIA  
6,975,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6541
Total Execution Time  0.6553
  CADENA URL  
/historico/Montevarchi-Calcio
  GET DATOS  
$_GET['/historico/Montevarchi-Calcio']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0155  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 = 'Montevarchi-Calcio' 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.0144  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=83211 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=83211 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=83211 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=83211 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=83211 AND type_rel = 2
0.0149  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 = '83211' 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 = 73983 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=83211 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (73983,73559,71432,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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 68592 AND teamId = 83211
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 73983 AND teamId = 83211
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 83211
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 83211
0.0292  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 73983 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '83211' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '83211' and rp.type = 4
0.0146  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 = '83211' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 = 73983 WHERE rp.league_id = 73983 AND rp.teamId = 83211 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 73983 WHERE rp.league_id = 73983 AND rp.teamId = 83211 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 events2024 e ON e.player_id = p.id AND e.league_id = 73983 WHERE rp.league_id = 73983 AND rp.teamId = 83211 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 83211 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73983 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.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 `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.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 `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.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 `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 = 58830 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0177  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 = 51160 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168  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 = 44800 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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.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 `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 = 24698 AND t.round = 34 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 `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 = 24713 AND t.round = 34 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 `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 = 24731 AND t.round = 38 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 `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 = 19912 AND t.round = 31 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 `tables2000` 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 = 19803 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC