4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Città di Campobasso Città 32 52 28 66
2 L'Aquila L'Aquila 32 39 22 64
3 Sambenedettese Sambenedette 32 51 32 54
4 Avezzano Avezzano 32 46 32 53
5 Vigor Senigallia Vigor 32 53 43 49
6 Roma City Roma City 32 51 34 48
7 Chieti Chieti 32 35 32 47
8 SN Notaresco 2018 Notaresco 32 37 36 45
9 ASD Atletico Ascoli Atletico 32 34 31 44
10 Termoli Calcio Termoli 32 29 35 41
11 Sora Sora 32 36 35 40
12 FC Fossombrone Fossombrone 32 28 27 40
13 Real Monterotondo Scalo Real 32 37 55 38
14 Riccione Riccione 32 44 46 34
15 Tivoli Tivoli 32 33 54 31
16 Fano Fano 32 30 45 29
17 Vastogirardi Vastogirardi 32 23 43 29
18 Matese Matese 32 20 48 25
TEMPORADA 2022/2023
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Pineto Pineto 34 50 21 72
2 Vigor Senigallia Vigor 34 52 34 67
3 Trastevere Trastevere 34 56 41 62
4 Fano Fano 34 45 34 60
5 Cynthialbalonga Cynthialbalo 34 32 23 52
6 Matese Matese 34 44 38 47
7 Sambenedettese Sambenedette 34 39 37 46
8 Chieti Chieti 34 29 27 46
9 Porto D'Ascoli Porto 34 28 27 45
10 Vastogirardi Vastogirardi 34 30 31 42
11 Team Nuova Florida Team Nuova. 34 33 44 42
12 Avezzano Avezzano 34 35 41 40
13 Roma City Roma City 34 29 42 37
14 Vastese Vastese 34 37 43 36
15 Termoli Calcio Termoli 34 25 34 34
16 Montegiorgio Montegiorgio 34 21 34 31
17 Tolentino Tolentino 34 25 41 31
18 SN Notaresco 2018 Notaresco 34 23 41 31
TEMPORADA 2021/2022
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Recanatese Recanatese 34 69 23 68
2 Trastevere Trastevere 34 54 33 59
3 Tolentino Tolentino 34 42 30 56
4 Sambenedettese Sambenedette 34 41 36 55
5 Vastese Vastese 34 44 32 53
6 Pineto Pineto 34 43 29 52
7 Fiuggi Fiuggi 34 41 45 51
8 SN Notaresco 2018 Notaresco 34 45 41 49
9 Matese Matese 34 44 41 49
10 Porto D'Ascoli Porto 34 41 39 49
11 Montegiorgio Montegiorgio 34 38 36 49
12 Chieti Chieti 34 38 38 49
13 Fano Fano 34 44 39 48
14 Vastogirardi Vastogirardi 34 48 51 46
15 Castelnuovo Vomano Castelnuovo 34 49 51 44
16 Castelfidardo Calcio Castelfidard 34 36 36 41
17 Nereto Nereto 34 23 80 12
18 Aurora Alto Casertano Aurora Alto 34 21 81 7
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 C GRUPO 2
Equipo PJ GF GC Puntos
1 Padova Padova 34 44 27 63
2 FC Südtirol Südtirol 34 37 28 55
3 Sambenedettese Sambenedette 34 38 31 53
4 Reggiana Reggiana 34 41 35 53
5 AlbinoLeffe AlbinoLeffe 34 36 31 49
6 Feralpisalò Feralpisalò 34 47 43 49
7 Bassano Virtus Bassano 34 38 30 48
8 Renate Renate 34 34 31 48
9 Mestre Mestre 34 40 36 46
10 Pordenone Pordenone 34 46 44 46
11 Ravenna FC Ravenna FC 34 31 38 43
12 Triestina Triestina 34 42 36 43
13 Fano Fano 34 25 31 38
14 Fermana Fermana 34 27 36 38
15 Santarcangelo Santarcangel 34 34 52 37
16 AS Gubbio 1910 Gubbio 1910 34 34 46 36
17 Teramo Teramo 34 33 42 35
18 Vicenza Vicenza 34 29 39 31
19 Modena Modena 0 0 0 0
TEMPORADA 2016/2017
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Venezia Venezia 38 56 29 80
2 Parma Parma 38 55 36 70
3 Pordenone Pordenone 38 68 42 66
4 Padova Padova 38 50 31 66
5 Reggiana Reggiana 38 43 36 59
6 AS Gubbio 1910 Gubbio 1910 38 44 49 58
7 Sambenedettese Sambenedette 38 53 47 56
8 Feralpisalò Feralpisalò 38 47 45 53
9 AlbinoLeffe AlbinoLeffe 38 38 34 52
10 Bassano Virtus Bassano 38 48 52 51
11 Santarcangelo Santarcangel 38 44 39 50
12 Maceratese Maceratese 38 36 40 48
13 FC Südtirol Südtirol 38 33 40 47
14 Modena Modena 38 31 35 44
15 Mantova Mantova 38 37 50 41
16 Teramo Teramo 38 39 43 40
17 Forli Forli 38 33 54 40
18 Fano Fano 38 28 42 39
19 Lumezzane Lumezzane 38 26 44 34
20 Ancona Ancona 38 27 48 29
TEMPORADA 2015/2016
SERIE D GRUPO 10
Equipo PJ GF GC Puntos
1 AS Gubbio 1910 Gubbio 1910 2 3 1 6
2 Piacenza Piacenza 2 5 1 4
3 Bellinzago Bellinzago 2 4 3 4
4 Viterbese Viterbese 2 6 4 3
5 Virtus Francavilla Virtus 2 5 5 3
6 Siracusa Siracusa 2 4 6 3
7 Parma Parma 2 3 4 1
8 Sambenedettese Sambenedette 2 2 3 1
9 Venezia Venezia 2 4 9 0
TEMPORADA 2014/2015
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Maceratese Maceratese 34 61 22 78
2 Fano Fano 34 60 25 74
3 Sambenedettese Sambenedette 34 71 40 63
4 Città di Campobasso Città 34 49 42 57
5 SN Notaresco 2018 Notaresco 34 59 46 52
6 Chieti Chieti 34 52 46 50
7 Civitanovese Civitanovese 34 56 51 50
8 Matelica Calcio Matelica 34 36 34 45
9 Real Giulianova Real 34 44 43 45
10 Jesina Jesina 34 40 38 42
11 Fermana Fermana 34 37 44 42
12 Recanatese Recanatese 34 37 44 39
13 Termoli Calcio Termoli 34 31 53 39
14 Amiternina Amiternina 34 30 45 38
15 Olympia Agnonese Olympia 34 31 51 31
16 Castelfidardo Calcio Castelfidard 34 25 49 31
17 Vis Pesaro Vis Pesaro 34 35 45 29
18 FC Celano Marsica Celano 34 23 59 17
TEMPORADA 2012/2013
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Sambenedettese Sambenedette 34 75 35 71
2 Termoli Calcio Termoli 34 74 39 68
3 San Cesareo Calcio Cesareo 34 69 44 68
4 Maceratese Maceratese 34 58 39 64
5 Vis Pesaro Vis Pesaro 34 47 25 57
6 Olympia Agnonese Olympia 34 68 56 53
7 Ancona Ancona 34 54 43 53
8 Astrea Astrea 34 53 47 50
9 Jesina Jesina 34 50 47 46
10 Civitanovese Civitanovese 34 34 45 42
11 Amiternina Amiternina 34 39 49 40
12 Fidene Fidene 34 41 52 40
13 Isernia Isernia 34 46 65 38
14 RC Angolana RC Angolana 34 35 53 37
15 FC Celano Marsica Celano 34 32 42 33
16 Recanatese Recanatese 34 28 51 29
17 SN Notaresco 2018 Notaresco 34 36 62 22
18 Città di Marino Città 34 33 78 20
TEMPORADA 2011/2012
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Teramo Teramo 34 86 29 73
2 Sambenedettese Sambenedette 34 57 31 72
3 Civitanovese Civitanovese 34 60 33 68
4 Isernia Isernia 34 46 35 60
5 Atletico Trivento Atletico 34 60 46 59
6 SN Notaresco 2018 Notaresco 34 43 40 50
7 Jesina Jesina 34 48 33 48
8 Olympia Agnonese Olympia 34 64 56 48
9 Recanatese Recanatese 34 41 36 46
10 Vis Pesaro Vis Pesaro 34 45 47 44
11 Riccione Riccione 34 52 56 39
12 Atessa Val di Sangro Atessa 34 40 49 39
13 RC Angolana RC Angolana 34 34 45 36
14 Santegidiese Santegidiese 34 48 62 36
15 Miglianico Miglianico 34 32 57 24
16 Luco Canistro Luco 34 22 71 19
17 Real Rimini FC Real Rimini 34 16 105 6
TEMPORADA 2010/2011
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Santarcangelo Santarcangel 38 65 20 77
2 Teramo Teramo 38 63 38 73
3 Rimini Rimini 38 66 39 71
4 Forli Forli 38 50 43 66
5 Santegidiese Santegidiese 38 62 51 59
6 Jesina Jesina 38 43 37 59
7 RC Angolana RC Angolana 38 59 44 58
8 Real Rimini FC Real Rimini 38 51 44 56
9 Recanatese Recanatese 38 32 35 56
10 Civitanovese Civitanovese 38 37 35 52
11 Atletico Trivento Atletico 38 56 43 51
12 Sambenedettese Sambenedette 38 51 46 51
13 Luco Canistro Luco 38 50 54 51
14 Olympia Agnonese Olympia 38 42 51 51
15 US Venafro US Venafro 38 52 64 49
16 Atessa Val di Sangro Atessa 38 36 44 47
17 Real Cesenatico Real 38 39 61 35
18 Miglianico Miglianico 38 40 57 32
19 FC Fossombrone Fossombrone 38 24 56 22
20 Bojano Bojano 38 21 77 10
TEMPORADA 2008/2009
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 Cesena Cesena 34 41 25 60
2 Pro Patria Pro Patria 34 50 27 58
3 Ravenna FC Ravenna FC 34 48 36 56
4 Padova Padova 34 37 31 54
5 Reggiana Reggiana 34 34 33 54
6 SPAL SPAL 34 38 30 53
7 Hellas Verona Hellas 34 38 32 48
8 Novara Novara 34 36 36 46
9 Lumezzane Lumezzane 34 37 35 45
10 Pergocrema Pergocrema 34 28 28 44
11 Cremonese Cremonese 34 36 36 43
12 Calcio Portogruaro-Summaga Calcio 34 33 39 43
13 AC Monza AC Monza 34 41 48 38
14 Pro Sesto Pro Sesto 34 34 47 38
15 Lecco Lecco 34 29 34 35
16 Venezia Venezia 34 35 41 35
17 Sambenedettese Sambenedette 34 22 36 32
18 AC Legnano AC Legnano 34 31 54 30
TEMPORADA 2007/2008
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Salernitana Salernitana 34 42 24 62
2 Ancona Ancona 34 43 26 57
3 Taranto Taranto 34 47 31 55
4 Crotone Crotone 34 45 30 55
5 Pescara Pescara 34 47 36 54
6 SS Arezzo SS Arezzo 34 42 32 53
7 Perugia Perugia 34 35 34 53
8 Lucchese Libertas Lucchese 34 35 29 51
9 Gallipoli Gallipoli 34 49 41 47
10 Sorrento Sorrento 34 29 30 44
11 Virtus Lanciano Virtus 34 30 34 42
12 Sambenedettese Sambenedette 34 32 39 40
13 Massese Massese 34 34 43 40
14 Potenza SC Potenza SC 34 31 36 38
15 Pistoiese Pistoiese 34 27 38 34
16 Juve Stabia Juve Stabia 34 34 42 33
17 Sangiovannese Sangiovannes 34 24 48 29
18 Martina Martina 34 25 58 21
TEMPORADA 2006/2007
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Ravenna FC Ravenna FC 34 50 30 69
2 Avellino Avellino 34 64 37 68
3 Cavese 1919 Cavese 1919 34 46 30 62
4 Calcio Foggia Calcio 34 41 25 59
5 Taranto Taranto 34 44 30 56
6 Perugia Perugia 34 40 29 54
7 Juve Stabia Juve Stabia 34 34 27 53
8 Sambenedettese Sambenedette 34 45 45 49
9 SS Manfredonia Calcio Manfredonia 34 41 43 46
10 Salernitana Salernitana 34 37 41 44
11 Gallipoli Gallipoli 34 41 48 44
12 Ternana Calcio Ternana 34 30 36 39
13 Virtus Lanciano Virtus 34 26 33 39
14 Teramo Teramo 34 27 39 37
15 Martina Martina 34 27 40 37
16 Ancona Ancona 34 37 49 33
17 San Marino Calcio Marino 34 37 43 32
18 Real Giulianova Real 34 18 60 12
TEMPORADA 2005/2006
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 Spezia Spezia 34 42 22 63
2 Genoa Genoa 34 42 27 59
3 AC Monza AC Monza 34 35 25 56
4 Pavia Pavia 34 44 29 54
5 Teramo Teramo 34 39 35 53
6 Salernitana Salernitana 34 42 30 52
7 Cittadella Cittadella 34 38 33 50
8 Novara Novara 34 40 36 48
9 Padova Padova 34 36 32 47
10 Pro Patria Pro Patria 34 36 39 44
11 AS Pizzighettone Pizzighetton 34 37 32 43
12 Real Giulianova Real 34 33 33 43
13 Ravenna FC Ravenna FC 34 30 33 43
14 Sambenedettese Sambenedette 34 35 48 42
15 Pro Sesto Pro Sesto 34 28 48 38
16 San Marino Calcio Marino 34 32 38 35
17 Lumezzane Lumezzane 34 35 44 35
18 Fermana Fermana 34 18 58 13
TEMPORADA 2004/2005
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Rimini Rimini 34 50 23 70
2 Avellino Avellino 34 48 29 64
3 Napoli Napoli 34 45 31 61
4 Reggiana Reggiana 34 41 24 54
5 Sambenedettese Sambenedette 34 38 25 54
6 Padova Padova 34 46 39 48
7 Virtus Lanciano Virtus 34 36 38 46
8 Benevento Benevento 34 31 38 45
9 SPAL SPAL 34 36 33 43
10 Calcio Foggia Calcio 34 36 35 42
11 Martina Martina 34 31 41 42
12 Cittadella Cittadella 34 36 37 41
13 Teramo Teramo 34 32 37 40
14 Fermana Fermana 34 30 45 39
15 Sora Sora 34 35 42 36
16 Real Giulianova Real 34 20 43 31
17 Chieti Chieti 34 19 32 30
18 Vis Pesaro Vis Pesaro 34 21 39 25
TEMPORADA 2003/2004
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Catanzaro Catanzaro 34 44 25 67
2 Crotone Crotone 34 57 33 65
3 Viterbese Viterbese 34 45 29 61
4 Acireale Acireale 34 40 26 60
5 Benevento Benevento 34 41 28 56
6 Virtus Lanciano Virtus 34 34 31 53
7 Sambenedettese Sambenedette 34 50 40 52
8 Chieti Chieti 34 39 35 48
9 Calcio Foggia Calcio 34 43 43 46
10 Teramo Teramo 34 40 41 45
11 Martina Martina 34 45 50 42
12 Real Giulianova Real 34 35 39 41
13 Sora Sora 34 27 35 41
14 Fermana Fermana 34 34 46 40
15 Vis Pesaro Vis Pesaro 34 31 48 36
16 Paternò Paternò 34 32 47 32
17 Taranto Taranto 34 31 46 30
18 L'Aquila L'Aquila 34 26 52 13

  USO DE MEMORIA  
7,985,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4642
Total Execution Time  0.4654
  CADENA URL  
/historico/Ss-Sambenedettese-Calcio
  GET DATOS  
$_GET['/historico/Ss-Sambenedettese-Calcio']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2408 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2408 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (468433,648783,797663,870260,871850) ORDER BY n.cover_points DESC, update_date DESC
0.0141  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 = '2408' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134  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 = 2408 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0251  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 = 73984 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.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 `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 = 68752 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.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 `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 = 64280 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.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.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 `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.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 `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.0129  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 = 38930 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 33444 AND t.round = 38 ORDER BY team.conference 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 `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 = 15654 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 28006 AND t.round = 3 ORDER BY team.conference 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 `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 = 4819 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 2095 AND t.round = 34 ORDER BY team.conference 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 `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 = 1696 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 24700 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 445 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 538 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 540 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 541 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 583 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 `tables2004` 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 = 585 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC