4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tamai
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 2017/2018
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Virtus Verona Virtus 34 60 33 73
2 Campodarsego Campodarsego 34 73 43 68
3 Arzignano Valchiampo Arzignano 34 75 42 67
4 Mantova Mantova 34 56 34 60
5 Adriese Adriese 34 56 31 56
6 AC Este AC Este 34 49 29 56
7 Belluno Belluno 34 62 50 51
8 Legnago Salus Legnago 34 53 47 49
9 Union Feltre Union Feltre 34 49 56 49
10 Rovigo Calcio Rovigo 34 47 50 47
11 Cjarlins Muzane Cjarlins 34 51 49 44
12 Clodiense Clodiense 34 44 60 41
13 Tamai Tamai 34 50 51 40
14 Ambrosiana Ambrosiana 34 51 64 40
15 Montebelluna Montebelluna 34 34 50 32
16 Calvi Noale Calvi Noale 34 32 67 28
17 Liventina Liventina 34 33 64 25
18 Abano Terme Abano Terme 34 25 80 16
TEMPORADA 2016/2017
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Mestre Mestre 34 73 34 80
2 Triestina Triestina 34 63 33 72
3 Campodarsego Campodarsego 34 55 42 60
4 Virtus Verona Virtus 34 42 30 53
5 Abano Terme Abano Terme 34 46 38 53
6 Belluno Belluno 34 40 36 50
7 Arzignano Valchiampo Arzignano 34 43 34 49
8 Montebelluna Montebelluna 34 46 54 44
9 AC Este AC Este 34 33 33 43
10 Union Feltre Union Feltre 34 35 37 43
11 Legnago Salus Legnago 34 46 43 41
12 Calvi Noale Calvi Noale 34 44 45 40
13 Alto Vicentino Alto 34 45 55 40
14 Tamai Tamai 34 33 45 40
15 ASD Cordenons Cordenons 34 44 56 39
16 Vigasio Vigasio 34 42 61 38
17 Vigontina Vigontina 34 42 62 25
18 Eclisse Carenipievigina Eclisse 34 29 63 23
TEMPORADA 2015/2016
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Venezia Venezia 38 89 26 90
2 Campodarsego Campodarsego 38 56 31 79
3 AC Este AC Este 38 61 23 76
4 Belluno Belluno 38 52 38 67
5 Virtus Verona Virtus 38 67 37 63
6 Luparense Luparense 38 65 57 58
7 Tamai Tamai 38 45 43 53
8 Mestre Mestre 38 71 54 51
9 Abano Terme Abano Terme 38 50 47 49
10 Levico Levico 38 54 53 48
11 Calvi Noale Calvi Noale 38 40 43 48
12 Dro Calcio Dro Calcio 38 35 53 48
13 Union Ripa Fenadora Union Ripa. 38 50 56 45
14 Fincantieri Monfalcone Fincantieri 38 47 57 43
15 Montebelluna Montebelluna 38 50 62 43
16 Liventina Liventina 38 45 62 39
17 Triestina Triestina 38 40 57 39
18 Fontanafredda Fontanafredd 38 44 62 39
19 Giorgione Giorgione 38 42 74 38
20 Sacilese Sacilese 38 26 94 13
TEMPORADA 2014/2015
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Calcio Padova 2015 Calcio 34 77 30 85
2 Alto Vicentino Alto 34 63 34 70
3 Sacilese Sacilese 34 62 31 62
4 Belluno Belluno 34 57 38 59
5 Arzignano Valchiampo Arzignano 34 53 39 56
6 Union Pro Union Pro 34 46 42 55
7 Clodiense Clodiense 34 48 47 49
8 Montebelluna Montebelluna 34 45 49 47
9 Union Ripa Fenadora Union Ripa. 34 45 42 45
10 Fontanafredda Fontanafredd 34 50 49 44
11 Legnago Salus Legnago 34 50 55 43
12 Tamai Tamai 34 45 38 41
13 Giorgione Giorgione 34 40 50 38
14 Dro Calcio Dro Calcio 34 37 50 35
15 Triestina Triestina 34 41 51 34
16 Nk Kras Asd Nk Kras Asd 34 41 58 33
17 Mori Santo Stefano Mori Santo. 34 31 69 19
18 AC Mezzocorona Mezzocorona 34 20 79 16
TEMPORADA 2013/2014
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Pordenone Pordenone 34 77 20 85
2 Marano Marano 34 72 24 83
3 Sacilese Sacilese 34 55 28 66
4 Belluno Belluno 34 54 43 59
5 Luparense Luparense 34 45 51 50
6 Union Ripa Fenadora Union Ripa. 34 59 49 49
7 AC Este AC Este 34 53 43 48
8 Montebelluna Montebelluna 34 45 46 48
9 ACD Trissino Trissino 34 47 49 43
10 Triestina Triestina 34 48 45 42
11 Giorgione Giorgione 34 36 35 39
12 Tamai Tamai 34 42 56 39
13 Vittorio Falmec Vittorio 34 42 59 38
14 Fincantieri Monfalcone Fincantieri 34 37 52 34
15 AC Mezzocorona Mezzocorona 34 35 56 33
16 Dro Calcio Dro Calcio 34 34 66 31
17 Sanvitese Sanvitese 34 37 55 30
18 Fersina Perginese Fersina 34 26 67 17
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
TEMPORADA 2010/2011
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Treviso Treviso 34 59 26 73
2 Venezia Venezia 34 69 42 69
3 Tamai Tamai 34 61 43 56
4 Sandonà Sandonà 34 56 44 55
5 Luparense Luparense 34 49 44 55
6 Union Quinto Union Quinto 34 50 42 49
7 Rovigo Calcio Rovigo 34 48 43 49
8 AC Este AC Este 34 55 48 46
9 Sanvitese Sanvitese 34 51 54 45
10 Pordenone Pordenone 34 52 53 42
11 AC Chioggia AC Chioggia 34 34 39 42
12 Montebelluna Montebelluna 34 32 43 41
13 Montecchio Maggiore Montecchio 34 43 48 40
14 Belluno Belluno 34 38 48 39
15 US Opitergina Opitergina 34 50 63 36
16 Concordia Concordia 34 49 68 36
17 Nk Kras Asd Nk Kras Asd 34 39 61 32
18 ASD Torviscosa Torviscosa 34 41 67 23
TEMPORADA 2009/2010
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 AC Montichiari Montichiari 38 64 23 84
2 AC Este AC Este 38 69 41 76
3 Venezia Venezia 38 71 43 75
4 US Citta di Jesolo Citta Jesolo 38 88 57 70
5 Union Quinto Union Quinto 38 63 41 64
6 Montebelluna Montebelluna 38 57 41 60
7 Pordenone Pordenone 38 58 43 60
8 Tamai Tamai 38 50 41 57
9 Virtus Verona Virtus 38 60 53 54
10 Villafranca Villafranca 38 53 51 51
11 Sanvitese Sanvitese 38 57 59 49
12 Albignasego Albignasego 38 54 51 47
13 Belluno Belluno 38 49 59 46
14 Nuova Verolese Nuova 38 40 63 46
15 Domegliara Domegliara 38 48 54 44
16 Concordia Concordia 38 41 56 44
17 Palazzolo 1913 Palazzolo 38 44 73 29
18 Manzanese Manzanese 38 29 55 24
19 Porfido Albiano Porfido 38 37 84 23
20 Montecchio Maggiore Montecchio 38 33 77 17
TEMPORADA 2008/2009
SERIE D GRUPO 3
Equipo PJ GF GC Puntos
1 Sacilese Sacilese 34 61 30 73
2 SSD Eurotezze Eurotezze 34 49 36 65
3 Domegliara Domegliara 34 40 26 59
4 Union Quinto Union Quinto 34 46 34 58
5 Chioggia Sottomarina Chioggia 34 43 34 54
6 Pordenone Pordenone 34 39 30 50
7 Belluno Belluno 34 49 32 49
8 Tamai Tamai 33 37 32 45
9 Virtus Verona Virtus 34 36 35 44
10 Sanvitese Sanvitese 34 39 43 44
11 US Citta di Jesolo Citta Jesolo 33 33 35 41
12 Concordia Concordia 33 44 50 41
13 Trento Trento 34 31 36 37
14 Montebelluna Montebelluna 34 28 39 35
15 AC Somma AC Somma 34 28 42 35
16 Gorla Maggiore Gorla 34 36 52 33
17 Sandonà Sandonà 33 24 42 29
18 FC Bolzano FC Bolzano 34 23 58 21

  USO DE MEMORIA  
6,785,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1891
Total Execution Time  0.1903
  CADENA URL  
/historico/Tamai
  GET DATOS  
$_GET['/historico/Tamai']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (56)  
0.0042  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 = 'Tamai' 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.0118  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 = 'Tamai' 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.0022  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=6883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6883 AND type_rel = 2
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=222 AND type_rel = 3
0.0031  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 222 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0031  SELECT /*53 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 (1244039,1222208,1221521,1177309,1176862) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '6883' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '6883' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = '6883' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 51158 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=6883 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (51158,51105,49702) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 51158 AND teamId = 6883
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 51105 AND teamId = 6883
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 49702 AND teamId = 6883
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '6883' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6883' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '6883' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 51158 WHERE rp.league_id = 51158 AND rp.teamId = 6883 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.0028  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 = 51158 WHERE rp.league_id = 51158 AND rp.teamId = 6883 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 51158 WHERE rp.league_id = 51158 AND rp.teamId = 6883 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 6883 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 39597 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 = 33451 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 15651 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 `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 = 4816 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 `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 = 24671 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.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 `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.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 24696 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 `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 = 24711 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 `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 = 24724 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC