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

Rimini

Entrenador: Emanuele Troise

Temporada 2019/2020
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 10
Equipo PJ GF GC Puntos
1 US Vibonese Calcio Vibonese 1 4 0 3
2 Gozzano Gozzano 1 2 0 3
3 Vis Pesaro Vis Pesaro 2 1 4 0
4 Pro Patria Pro Patria 1 3 1 3
5 Virtus Verona Virtus 2 1 5 0
6 Albissola Albissola 2 6 4 4
7 Rimini Rimini 2 6 5 4
8 Rieti Rieti 1 0 0 1
9 Potenza Calcio Potenza 2 0 4 1
TEMPORADA 2015/2016
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 SPAL SPAL 34 59 25 71
2 Pisa SC Pisa SC 34 42 26 63
3 Maceratese Maceratese 34 47 31 58
4 Ancona Ancona 34 34 29 53
5 Carrarese Carrarese 34 49 37 51
6 Teramo Teramo 34 42 40 46
7 Siena Siena 34 34 38 46
8 Pontedera Pontedera 34 43 38 45
9 Santarcangelo Santarcangel 34 41 38 45
10 SS Arezzo SS Arezzo 34 33 31 43
11 L'Aquila L'Aquila 34 34 41 40
12 Tuttocuoio Tuttocuoio 34 27 34 40
13 Lucchese Libertas Lucchese 34 39 43 39
14 Pistoiese Pistoiese 34 29 35 39
15 Rimini Rimini 34 29 39 38
16 Prato Prato 34 32 43 37
17 Savona Savona 34 27 44 36
18 Lupa Roma Lupa Roma 34 26 55 25
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
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
LEGA PRO 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Pro Patria Pro Patria 39 72 41 72
2 Venezia Venezia 41 71 59 72
3 AC Monza AC Monza 40 67 45 69
4 Renate Renate 41 74 53 69
5 Bassano Virtus Bassano 38 62 38 64
6 Savona Savona 34 51 33 60
7 Castiglione Castiglione 38 44 32 59
8 Forli Forli 40 58 38 55
9 US Alessandria Alessandria 38 42 35 53
10 Santarcangelo Santarcangel 43 50 51 53
11 Mantova Mantova 39 51 61 51
12 AC Giacomense Giacomense 38 47 54 50
13 Bellaria Igea Bellaria 38 45 54 46
14 S. Christophe Christophe 43 45 79 46
15 Fano Fano 38 49 72 41
16 Rimini Rimini 39 40 45 40
17 Casale Casale 40 39 65 25
18 Milazzo Milazzo 38 18 89 11
TEMPORADA 2011/2012
LEGA PRO 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Pro Patria Pro Patria 38 59 36 71
2 Treviso Treviso 38 60 33 69
3 San Marino Calcio Marino 38 65 41 66
4 Cuneo Cuneo 38 60 47 65
5 Casale Casale 38 50 32 62
6 Virtus Entella Virtus 38 61 37 61
7 Rimini Rimini 38 46 43 61
8 Santarcangelo Santarcangel 38 46 42 54
9 Poggibonsi Poggibonsi 38 50 49 54
10 Savona Savona 38 47 41 53
11 US Alessandria Alessandria 38 45 45 52
12 Borgo a Buggiano Borgo 38 46 46 51
13 Renate Renate 38 40 44 48
14 Bellaria Igea Bellaria 38 39 45 45
15 AC Giacomense Giacomense 38 46 53 45
16 Mantova Mantova 38 44 49 44
17 AC Montichiari Montichiari 38 48 59 40
18 Lecco Lecco 38 34 66 37
19 AC Sambonifacese Sambonifaces 38 37 80 26
20 Valenzana Calcio Valenzana 38 28 63 24
TEMPORADA 2010/2011
SERIE D GRUPO 9
Equipo PJ GF GC Puntos
1 Bacoli Sibilla Bacoli 2 5 3 4
2 Sandonà Sandonà 1 2 2 1
3 Pontedera Pontedera 1 1 3 0
4 Vallée dAoste Vallée 1 3 2 3
5 Rimini Rimini 1 1 1 1
6 Pomigliano Pomigliano 2 3 4 1
7 Voghera Voghera 1 1 0 3
8 Sansepolcro Calcio Sansepolcro 1 3 3 1
9 Forza e Coraggio Forza 2 3 4 1
TEMPORADA 2009/2010
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Calcio Portogruaro-Summaga Calcio 34 39 26 59
2 Pescara Pescara 34 39 25 58
3 Hellas Verona Hellas 34 38 20 55
4 Rimini Rimini 34 39 36 51
5 Reggiana Reggiana 34 45 38 49
6 Ternana Calcio Ternana 34 34 34 49
7 SPAL SPAL 34 37 29 45
8 Taranto Taranto 34 26 24 45
9 Progreditur Marcianise Progreditur 34 44 40 44
10 Virtus Lanciano Virtus 34 31 36 44
11 Cavese 1919 Cavese 1919 34 25 25 43
12 Cosenza Calcio Cosenza 34 43 45 43
13 Calcio Foggia Calcio 34 27 37 41
14 Ravenna FC Ravenna FC 34 38 36 40
15 AS Andria BAT Andria 34 31 35 40
16 Pescina V. Giovenca Pescina 34 32 49 34
17 Potenza SC Potenza SC 34 30 48 34
18 Real Giulianova Real 34 28 43 32
TEMPORADA 2008/2009
SERIE B
Equipo PJ GF GC Puntos
1 SSC Bari SSC Bari 42 65 35 80
2 Parma Parma 42 65 34 76
3 Livorno Livorno 42 64 40 68
4 Brescia Brescia 42 54 40 67
5 Empoli Empoli 42 53 44 67
6 Grosseto Grosseto 42 64 66 64
7 Sassuolo Sassuolo 42 57 50 60
8 Triestina Triestina 42 52 47 59
9 AlbinoLeffe AlbinoLeffe 42 49 49 58
10 Piacenza Piacenza 42 48 48 55
11 Frosinone Frosinone 42 48 53 53
12 Vicenza Vicenza 42 44 41 52
13 Mantova Mantova 42 41 46 52
14 Ascoli Ascoli 42 37 48 52
15 Modena Modena 42 54 63 51
16 Salernitana Salernitana 42 46 56 51
17 Cittadella Cittadella 42 42 43 50
18 Rimini Rimini 42 43 56 50
19 Ancona Ancona 42 54 66 49
20 Pisa SC Pisa SC 42 45 55 48
21 Avellino Avellino 42 41 61 42
22 Treviso Treviso 42 37 62 36
TEMPORADA 2007/2008
SERIE B
Equipo PJ GF GC Puntos
1 Chievo Chievo 42 77 43 85
2 Bologna Bologna 42 58 29 84
3 Lecce Lecce 42 70 29 83
4 AlbinoLeffe AlbinoLeffe 42 67 48 78
5 Brescia Brescia 42 59 40 72
6 Pisa SC Pisa SC 42 61 44 71
7 Rimini Rimini 42 68 46 69
8 Ascoli Ascoli 42 64 49 62
9 Mantova Mantova 42 56 49 60
10 Frosinone Frosinone 42 63 67 56
11 SSC Bari SSC Bari 42 50 55 55
12 Triestina Triestina 42 55 67 51
13 Grosseto Grosseto 42 47 54 49
14 ACR Messina ACR Messina 42 38 62 49
15 Piacenza Piacenza 42 43 59 47
16 Modena Modena 42 57 65 46
17 Treviso Treviso 42 41 52 45
18 Vicenza Vicenza 42 43 60 45
19 Avellino Avellino 42 42 64 36
20 Ravenna FC Ravenna FC 42 48 75 35
21 Spezia Spezia 42 45 66 34
22 Cesena Cesena 42 37 66 32
TEMPORADA 2006/2007
SERIE B
Equipo PJ GF GC Puntos
1 Juventus Juventus 42 83 30 94
2 Napoli Napoli 42 52 29 79
3 Genoa Genoa 42 68 44 78
4 Piacenza Piacenza 42 57 50 68
5 Rimini Rimini 42 55 38 67
6 Brescia Brescia 42 51 43 67
7 Bologna Bologna 42 52 43 65
8 Mantova Mantova 42 47 36 64
9 Lecce Lecce 42 56 53 58
10 AlbinoLeffe AlbinoLeffe 42 46 48 53
11 SS Arezzo SS Arezzo 42 42 46 51
12 Vicenza Vicenza 42 42 43 50
13 Treviso Treviso 42 44 47 50
14 SSC Bari SSC Bari 42 40 46 50
15 Frosinone Frosinone 42 44 54 50
16 Modena Modena 42 38 46 49
17 Triestina Triestina 42 37 48 49
18 Cesena Cesena 42 51 66 49
19 Hellas Verona Hellas 42 34 46 48
20 Spezia Spezia 42 50 61 46
21 Crotone Crotone 42 36 67 32
22 Pescara Pescara 42 36 77 25
TEMPORADA 2005/2006
SERIE B
Equipo PJ GF GC Puntos
1 Atalanta Atalanta 42 61 39 81
2 Catania Catania 42 67 42 78
3 Torino Torino 42 51 31 76
4 Mantova Mantova 42 46 35 69
5 Modena Modena 42 59 41 67
6 Cesena Cesena 42 66 54 66
7 SS Arezzo SS Arezzo 42 45 34 66
8 Bologna Bologna 42 55 42 64
9 Crotone Crotone 42 56 48 63
10 Brescia Brescia 42 54 44 60
11 Piacenza Piacenza 42 56 52 54
12 Pescara Pescara 42 41 50 54
13 SSC Bari SSC Bari 42 43 47 51
14 Triestina Triestina 42 44 51 51
15 Hellas Verona Hellas 42 42 41 49
16 Vicenza Vicenza 42 38 49 49
17 Rimini Rimini 42 42 49 48
18 AlbinoLeffe AlbinoLeffe 42 38 52 46
19 Avellino Avellino 42 42 62 46
20 Ternana Calcio Ternana 42 36 58 39
21 Cremonese Cremonese 42 36 60 30
22 Catanzaro Catanzaro 42 26 63 28
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 1
Equipo PJ GF GC Puntos
1 SS Arezzo SS Arezzo 34 51 27 67
2 Lumezzane Lumezzane 34 42 33 59
3 Cesena Cesena 34 47 34 58
4 Rimini Rimini 34 42 33 53
5 Lucchese Libertas Lucchese 34 39 34 52
6 Spezia Spezia 34 35 33 51
7 Pisa SC Pisa SC 34 44 37 49
8 Padova Padova 34 36 27 48
9 SPAL SPAL 34 31 28 47
10 Pistoiese Pistoiese 34 35 36 44
11 Cittadella Cittadella 34 34 35 42
12 Novara Novara 34 37 41 40
13 Sassari Torres Sassari 34 21 28 38
14 Pro Patria Pro Patria 34 28 38 38
15 Reggiana Reggiana 34 32 45 37
16 Varese Varese 34 29 43 35
17 Prato Prato 34 33 46 34
18 Pavia Pavia 34 29 47 32
TEMPORADA 1981/1982
SERIE B
Equipo PJ GF GC Puntos
1 Hellas Verona Hellas 38 49 31 65
2 Sampdoria Sampdoria 38 41 25 64
3 SSC Bari SSC Bari 38 47 33 60
4 Varese Varese 38 42 30 60
5 Pisa SC Pisa SC 38 47 26 59
6 Perugia Perugia 38 37 26 58
7 Palermo FC Palermo FC 38 52 42 57
8 Sambenedettese Sambenedette 38 37 32 49
9 Catania Catania 38 38 41 49
10 Lazio Lazio 38 38 35 48
11 Cremonese Cremonese 38 36 39 48
12 Lecce Lecce 38 30 35 47
13 Rimini Rimini 38 39 45 47
14 Calcio Foggia Calcio 38 30 37 47
15 Cavese 1919 Cavese 1919 38 28 35 47
16 Reggiana Reggiana 38 31 36 45
17 Pistoiese Pistoiese 38 31 38 45
18 Brescia Brescia 38 26 39 39
19 SPAL SPAL 38 26 43 34
20 Pescara Pescara 38 20 57 21
TEMPORADA 1980/1981
SERIE B
Equipo PJ GF GC Puntos
1 Milan Milan 38 49 29 68
2 Genoa Genoa 38 47 29 65
3 Cesena Cesena 38 44 26 64
4 Lazio Lazio 38 50 32 59
5 Pescara Pescara 38 35 38 55
6 Sampdoria Sampdoria 38 39 33 54
7 SSC Bari SSC Bari 38 40 41 50
8 Pisa SC Pisa SC 38 35 37 49
9 Palermo FC Palermo FC 38 35 33 48
10 Lecce Lecce 38 33 40 47
11 Rimini Rimini 38 40 42 46
12 Catania Catania 38 38 50 46
13 SPAL SPAL 38 45 46 45
14 Varese Varese 38 41 43 45
15 Taranto Taranto 38 29 32 45
16 Calcio Foggia Calcio 38 32 38 44
17 Vicenza Vicenza 38 34 40 41
18 Hellas Verona Hellas 38 24 28 40
19 Atalanta Atalanta 38 28 40 39
20 AC Monza AC Monza 38 24 45 29

  USO DE MEMORIA  
7,786,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.8129
Total Execution Time  0.8149
  CADENA URL  
/historico/Rimini-Calcio/2020
  GET DATOS  
$_GET['/historico/Rimini-Calcio/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0212  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 = 'Rimini-Calcio' AND l.year = 2020 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.0134  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=2161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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=2161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0137  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=2161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0269  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 = 50623
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2161 AND type_rel = 2
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2161 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0139  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 (437231,491818) ORDER BY n.cover_points DESC, update_date DESC
0.0166  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 = '2161' ORDER BY l.year DESC,cat.coefficient DESC
0.0137  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 = '2161' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '2161' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 50623 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 51022 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=2161 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (63095,58829,51022,50623,43475) 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.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 51022 AND teamId = 2161
0.0141  SELECT count(id) as num_players from rel_players WHERE league_id = 58829 AND teamId = 2161
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 50623 AND teamId = 2161
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 63095 AND teamId = 2161
0.0556  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 2161
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '2161' 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 = '2161' 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 = '2161' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 events2020 e ON e.player_id = p.id AND e.league_id = 51022 WHERE rp.league_id = 51022 AND rp.teamId = 2161 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.0136  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 events2020 e ON e.player_id = p.id AND e.league_id = 51022 WHERE rp.league_id = 51022 AND rp.teamId = 2161 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 events2020 e ON e.player_id = p.id AND e.league_id = 51022 WHERE rp.league_id = 51022 AND rp.teamId = 2161 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 2161 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 43432 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 `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 = 15398 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 `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.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 `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.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 `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 = 2086 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 1637 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 `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.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 `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 = 24706 AND t.round = 2 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 `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 = 444 AND t.round = 42 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 `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 = 506 AND t.round = 42 ORDER BY team.conference 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 `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 = 507 AND t.round = 42 ORDER BY team.conference 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 `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 = 508 AND t.round = 42 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 `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.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 `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 = 584 AND t.round = 34 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 `tables1982` 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 = 30854 AND t.round = 38 ORDER BY team.conference 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 `tables1981` 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 = 30853 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 51022 ORDER BY nameShow LIMIT 100