4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Delta Porto Tolle
TEMPORADA 2021/2022
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Arzignano Valchiampo Arzignano 34 74 32 73
2 Clodiense Clodiense 34 53 22 72
3 Adriese Adriese 34 61 36 66
4 Luparense Luparense 34 60 35 58
5 Campodarsego Campodarsego 34 48 37 56
6 Caldiero Terme Caldiero 34 58 50 51
7 Dolomiti Bellunesi Dolomiti 34 51 50 50
8 Montebelluna Montebelluna 34 57 52 49
9 Mestre Mestre 34 36 45 46
10 Cjarlins Muzane Cjarlins 34 51 43 45
11 Cartigliano Cartigliano 34 44 40 45
12 AC Este AC Este 34 31 42 43
13 Levico Levico 34 31 40 42
14 Ambrosiana Ambrosiana 34 45 52 40
15 Delta Porto Tolle Delta Porto 34 43 51 36
16 Spinea Spinea 34 27 58 25
17 Cattolica Cattolica 34 20 61 23
18 ACD San Martino Martino 34 29 73 20
TEMPORADA 2020/2021
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Trento Trento 38 65 35 81
2 Arzignano Valchiampo Arzignano 38 52 34 67
3 Manzanese Manzanese 38 64 44 66
4 Clodiense Clodiense 38 51 41 62
5 Caldiero Terme Caldiero 38 56 36 61
6 Mestre Mestre 38 58 49 60
7 Delta Porto Tolle Delta Porto 38 51 38 58
8 Luparense Luparense 38 52 48 54
9 Belluno Belluno 38 43 45 53
10 Cjarlins Muzane Cjarlins 38 60 60 52
11 Cartigliano Cartigliano 38 42 45 52
12 Union San Giorgio Sedico Union 38 48 48 49
13 Adriese Adriese 38 55 64 49
14 Ambrosiana Ambrosiana 38 57 64 47
15 AC Este AC Este 38 45 53 43
16 Campodarsego Campodarsego 38 41 48 40
17 Union Feltre Union Feltre 38 41 59 39
18 Virtus Bolzano Virtus 38 46 52 38
19 Montebelluna Montebelluna 38 41 67 38
20 Chions Chions 38 30 68 21
TEMPORADA 2019/2020
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Campodarsego Campodarsego 27 44 25 54
2 Legnago Salus Legnago 28 43 32 49
3 Ambrosiana Ambrosiana 28 47 31 48
4 Clodiense Clodiense 27 44 32 47
5 Mestre Mestre 27 37 28 45
6 Adriese Adriese 27 53 36 44
7 Union Feltre Union Feltre 27 38 25 44
8 Cartigliano Cartigliano 28 46 37 42
9 Cjarlins Muzane Cjarlins 28 44 47 42
10 Luparense Luparense 27 49 45 37
11 Caldiero Terme Caldiero 27 25 28 37
12 AC Este AC Este 27 37 35 36
13 Chions Chions 28 39 41 35
14 Belluno Belluno 27 33 38 34
15 Delta Porto Tolle Delta Porto 27 31 38 31
16 Montebelluna Montebelluna 27 26 35 30
17 Vigasio Vigasio 27 28 42 30
18 Tamai Tamai 27 22 45 22
19 San Luigi San Luigi 28 36 64 21
20 Villafranca Villafranca 27 25 43 17
TEMPORADA 2018/2019
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Arzignano Valchiampo Arzignano 34 63 35 70
2 Adriese Adriese 34 70 37 68
3 Union Feltre Union Feltre 34 51 28 64
4 Campodarsego Campodarsego 34 55 40 60
5 Delta Porto Tolle Delta Porto 34 48 42 49
6 Virtus Don Bosco Virtus Bosco 34 46 43 49
7 Cjarlins Muzane Cjarlins 34 63 55 46
8 Montebelluna Montebelluna 34 37 44 45
9 AC Este AC Este 34 44 47 41
10 Cartigliano Cartigliano 34 37 46 41
11 Chions Chions 34 37 42 40
12 Clodiense Clodiense 34 41 46 39
13 Belluno Belluno 34 33 37 38
14 Tamai Tamai 34 35 48 38
15 Levico Levico 34 34 47 37
16 St. Georgen St. Georgen 34 30 59 36
17 Sandonà Sandonà 34 37 40 35
18 Trento Trento 34 28 53 26
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
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
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Delta Porto Tolle Delta Porto 38 64 29 75
2 Pordenone Pordenone 38 55 38 71
3 AC Sambonifacese Sambonifaces 38 53 36 71
4 Virtus Verona Virtus 38 60 37 69
5 Real Vicenza VS Real Vicenza 38 70 49 67
6 Clodiense Clodiense 38 48 43 65
7 Sandonà Sandonà 38 59 48 58
8 Sacilese Sacilese 38 48 41 56
9 ACD Trissino Trissino 38 58 49 54
10 Belluno Belluno 38 53 56 52
11 Legnago Salus Legnago 38 54 47 51
12 Tamai Tamai 38 54 52 46
13 AC Este AC Este 38 45 50 46
14 Luparense Luparense 38 43 49 46
15 Cerea Cerea 38 42 56 44
16 Montebelluna Montebelluna 38 40 62 43
17 Giorgione Giorgione 38 40 52 39
18 Sanvitese Sanvitese 38 33 52 36
19 Nk Kras Asd Nk Kras Asd 38 34 73 29
20 Union Quinto Union Quinto 38 32 66 21
TEMPORADA 2011/2012
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Venezia Venezia 34 74 37 73
2 Delta Porto Tolle Delta Porto 34 65 34 67
3 Legnago Salus Legnago 34 45 23 62
4 Montebelluna Montebelluna 34 40 33 55
5 Sacilese Sacilese 34 40 34 50
6 Sandonà Sandonà 34 49 34 48
7 Pordenone Pordenone 34 47 38 48
8 AC Mezzocorona Mezzocorona 34 40 37 48
9 Belluno Belluno 34 41 44 45
10 Giorgione Giorgione 34 38 35 44
11 Tamai Tamai 34 52 54 44
12 Union Quinto Union Quinto 34 42 52 44
13 St. Georgen St. Georgen 34 39 54 42
14 Sanvitese Sanvitese 34 31 48 35
15 Sarego Sarego 34 37 59 35
16 Montecchio Maggiore Montecchio 34 32 42 34
17 Concordia Concordia 34 43 59 32
18 Itala S. Marco Itala Marco 34 32 70 18

  USO DE MEMORIA  
6,626,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1721
Total Execution Time  0.1733
  CADENA URL  
/historico/Delta-Porto-Tolle
  GET DATOS  
$_GET['/historico/Delta-Porto-Tolle']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (59)  
0.0024  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 = 'Delta-Porto-Tolle' 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.0053  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 = 'Delta-Porto-Tolle' 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.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6879 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 64277
0.0024  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 = 67606
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6879 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6879 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019  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 (61527) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '6879' ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '6879' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '6879' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = '6879' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 67606 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 64277 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=6879 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (67606,64277,64181) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 64277 AND teamId = 6879
0.0035  SELECT count(id) as num_players from rel_players WHERE league_id = 64181 AND teamId = 6879
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 67606 AND teamId = 6879
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 64277 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '6879' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6879' and rp.type = 4
0.0020  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 = '6879' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0033  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 events2022 e ON e.player_id = p.id AND e.league_id = 64277 WHERE rp.league_id = 64277 AND rp.teamId = 6879 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.0029  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 events2022 e ON e.player_id = p.id AND e.league_id = 64277 WHERE rp.league_id = 64277 AND rp.teamId = 6879 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 events2022 e ON e.player_id = p.id AND e.league_id = 64277 WHERE rp.league_id = 64277 AND rp.teamId = 6879 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 6879 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 64277 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.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 `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 = 58828 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 = 51158 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 44798 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 `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.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 `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.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 `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.0029  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.0023  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 = 2089 AND t.round = 38 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 `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 = 1693 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 64277 ORDER BY nameShow LIMIT 100