4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Livorno Sub 19
TEMPORADA 2019/2020
CAMPIONATO PRIMAVERA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Ascoli Sub 19 Ascoli 19 44 19 43
2 Trapani Sub 19 Trapani 18 24 17 33
3 Frosinone Sub 19 Frosinone 19 31 22 31
4 Livorno Sub 19 Livorno 19 31 27 29
5 Crotone Sub 19 Crotone 19 26 28 28
6 Lecce Sub 19 Lecce 18 32 26 25
7 Perugia Sub 19 Perugia 19 32 28 24
8 Salernitana Sub 19 Salernitana 19 23 28 23
9 Nuova Cosenza Sub 19 Nuova 19 35 42 23
10 Benevento Sub 19 Benevento 19 30 35 21
11 Pisa SC Sub 19 Pisa 19 18 32 17
12 Juve Stabia Sub 19 Juve Stabia 19 22 44 15
TEMPORADA 2018/2019
CAMPIONATO PRIMAVERA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Pescara Sub 19 Pescara 20 56 16 49
2 Lazio Sub 19 Lazio 20 40 12 46
3 Ascoli Sub 19 Ascoli 20 25 15 36
4 Lecce Sub 19 Lecce 20 33 29 34
5 Benevento Sub 19 Benevento 20 31 25 29
6 Frosinone Sub 19 Frosinone 20 23 23 29
7 Livorno Sub 19 Livorno 20 27 42 24
8 Calcio Foggia Sub 19 Calcio 20 32 41 23
9 Crotone Sub 19 Crotone 20 23 46 17
10 Perugia Sub 19 Perugia 20 22 40 15
11 Nuova Cosenza Sub 19 Nuova 20 24 47 9
TEMPORADA 2015/2016
CAMPIONATO PRIMAVERA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 19 Juventus 26 61 27 59
2 Virtus Entella Sub 19 Virtus 26 69 40 57
3 Torino Sub 19 Torino 26 53 19 56
4 Fiorentina Sub 19 Fiorentina 26 61 32 55
5 Sassuolo Sub 19 Sassuolo 26 58 44 49
6 Sampdoria Sub 19 Sampdoria 26 52 30 47
7 Genoa Sub 19 Genoa 26 48 33 40
8 Spezia Sub 19 Spezia 26 37 54 31
9 Novara Sub 19 Novara 26 37 42 30
10 Modena Sub 19 Modena 26 18 39 23
11 Carpi Sub 19 Carpi 26 29 55 20
12 Pro Vercelli Sub 19 Vercelli 26 29 62 19
13 Livorno Sub 19 Livorno 26 24 54 15
14 Trapani Sub 19 Trapani 26 23 68 12
TEMPORADA 2014/2015
CAMPIONATO PRIMAVERA 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Roma Sub 19 Roma Sub 19 26 68 25 61
2 Lazio Sub 19 Lazio 26 74 27 55
3 SSC Bari Sub 19 Bari 26 50 33 55
4 Empoli Sub 19 Empoli 26 55 25 48
5 Palermo Sub 19 Palermo 26 47 30 48
6 Catania Sub 19 Catania 26 46 31 48
7 Napoli Sub 19 Napoli 26 43 30 43
8 Livorno Sub 19 Livorno 26 39 40 35
9 Latina Sub 19 Latina 26 40 39 33
10 Ternana Sub 19 Ternana 26 38 55 24
11 Frosinone Sub 19 Frosinone 26 18 61 23
12 Vicenza Sub 19 Vicenza 26 34 69 19
13 Crotone Sub 19 Crotone 26 20 46 17
14 Avellino Sub 19 Avellino 26 14 75 7
TEMPORADA 2013/2014
CAMPIONATO PRIMAVERA 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Lazio Sub 19 Lazio 26 79 27 67
2 Fiorentina Sub 19 Fiorentina 26 67 28 64
3 Roma Sub 19 Roma Sub 19 26 69 24 57
4 Palermo Sub 19 Palermo 26 55 36 46
5 Catania Sub 19 Catania 26 37 27 42
6 Napoli Sub 19 Napoli 26 42 38 39
7 Livorno Sub 19 Livorno 26 45 44 34
8 SSC Bari Sub 19 Bari 26 44 44 32
9 Reggina Sub 19 Reggina 26 28 37 32
10 Juve Stabia Sub 19 Juve Stabia 26 39 45 30
11 Latina Sub 19 Latina 26 36 60 24
12 Crotone Sub 19 Crotone 26 39 74 22
13 Trapani Sub 19 Trapani 26 24 69 15
14 Avellino Sub 19 Avellino 26 22 73 9
TEMPORADA 2012/2013
CAMPIONATO PRIMAVERA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 19 Juventus 26 49 19 61
2 Fiorentina Sub 19 Fiorentina 26 59 25 56
3 Torino Sub 19 Torino 26 40 19 53
4 Genoa Sub 19 Genoa 26 41 31 46
5 Empoli Sub 19 Empoli 26 41 37 41
6 Parma Sub 19 Parma 26 37 39 36
7 Spezia Sub 19 Spezia 26 27 38 35
8 Novara Sub 19 Novara 26 35 42 31
9 Siena Sub 19 Siena 26 30 35 30
10 Pro Vercelli Sub 19 Vercelli 26 26 40 30
11 Sampdoria Sub 19 Sampdoria 26 33 32 28
12 Cagliari Sub 19 Cagliari 26 33 42 26
13 Livorno Sub 19 Livorno 26 36 53 25
14 Grosseto Sub 19 Grosseto 26 25 60 13
TEMPORADA 2011/2012
CAMPIONATO PRIMAVERA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 19 Juventus 26 67 31 55
2 Torino Sub 19 Torino 26 38 23 49
3 Fiorentina Sub 19 Fiorentina 26 45 23 48
4 Genoa Sub 19 Genoa 26 39 29 43
5 Sampdoria Sub 19 Sampdoria 26 44 34 41
6 Livorno Sub 19 Livorno 26 47 42 40
7 Empoli Sub 19 Empoli 26 35 40 40
8 Novara Sub 19 Novara 26 44 35 35
9 Parma Sub 19 Parma 26 40 45 33
10 Cagliari Sub 19 Cagliari 26 33 46 29
11 Sassuolo Sub 19 Sassuolo 26 36 43 28
12 Siena Sub 19 Siena 26 34 38 22
13 Modena Sub 19 Modena 26 21 45 19
14 Grosseto Sub 19 Grosseto 26 18 67 12
TEMPORADA 2010/2011
CAMPIONATO PRIMAVERA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Genoa Sub 19 Genoa 26 45 25 62
2 Juventus Sub 19 Juventus 26 54 27 54
3 Fiorentina Sub 19 Fiorentina 26 55 25 52
4 Empoli Sub 19 Empoli 26 45 26 46
5 Torino Sub 19 Torino 26 43 32 46
6 Parma Sub 19 Parma 26 33 27 42
7 Novara Sub 19 Novara 26 46 37 41
8 Sampdoria Sub 19 Sampdoria 26 44 37 37
9 Bologna Sub 19 Bologna 26 39 43 34
10 Livorno Sub 19 Livorno 26 27 42 28
11 Sassuolo Sub 19 Sassuolo 26 38 53 27
12 Cesena Sub 19 Cesena 26 28 47 18
13 Modena Sub 19 Modena 26 14 54 14
14 Piacenza Sub 19 Piacenza 26 16 52 13
TEMPORADA 2009/2010
CAMPIONATO PRIMAVERA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Sampdoria Sub 19 Sampdoria 26 55 23 56
2 Juventus Sub 19 Juventus 26 54 26 55
3 Genoa Sub 19 Genoa 26 43 18 51
4 Empoli Sub 19 Empoli 26 36 18 48
5 Parma Sub 19 Parma 26 39 26 48
6 Fiorentina Sub 19 Fiorentina 26 48 27 45
7 Siena Sub 19 Siena 26 36 28 42
8 Piacenza Sub 19 Piacenza 26 31 48 35
9 Torino Sub 19 Torino 26 39 34 33
10 Cagliari Sub 19 Cagliari 26 26 49 24
11 Sassuolo Sub 19 Sassuolo 26 25 39 23
12 Livorno Sub 19 Livorno 26 19 41 20
13 Modena Sub 19 Modena 26 15 56 16
14 Grosseto Sub 19 Grosseto 26 17 50 15
TEMPORADA 2008/2009
CAMPIONATO PRIMAVERA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 19 Juventus 26 52 18 55
2 Sampdoria Sub 19 Sampdoria 26 37 14 51
3 Genoa Sub 19 Genoa 26 43 20 50
4 Empoli Sub 19 Empoli 26 38 20 50
5 Siena Sub 19 Siena 26 39 31 47
6 Torino Sub 19 Torino 26 38 38 32
7 Sassuolo Sub 19 Sassuolo 26 30 35 31
8 Bologna Sub 19 Bologna 26 23 33 31
9 Modena Sub 19 Modena 26 25 34 29
10 Parma Sub 19 Parma 26 21 36 29
11 Piacenza Sub 19 Piacenza 26 36 39 27
12 Pisa SC Sub 19 Pisa 26 24 35 25
13 Livorno Sub 19 Livorno 26 29 41 25
14 Grosseto Sub 19 Grosseto 26 17 58 12
TEMPORADA 2007/2008
CAMPIONATO PRIMAVERA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Juventus Sub 19 Juventus 26 60 30 56
2 Sampdoria Sub 19 Sampdoria 26 45 18 55
3 Parma Sub 19 Parma 26 39 24 50
4 Genoa Sub 19 Genoa 26 46 31 43
5 Piacenza Sub 19 Piacenza 26 40 32 43
6 Brescia Sub 19 Brescia 26 38 30 42
7 Torino Sub 19 Torino 26 37 26 40
8 Spezia Sub 19 Spezia 26 38 45 33
9 Bologna Sub 19 Bologna 26 30 35 29
10 Cagliari Sub 19 Cagliari 26 34 45 28
11 Modena Sub 19 Modena 26 35 48 27
12 Mantova Sub 19 Mantova 26 32 59 19
13 Livorno Sub 19 Livorno 26 23 51 19
14 Pisa SC Sub 19 Pisa 26 28 51 18

  USO DE MEMORIA  
6,052,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1705
Total Execution Time  0.1718
  CADENA URL  
/historico/Livorno-Sub19
  GET DATOS  
$_GET['/historico/Livorno-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (61)  
0.0023  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 = 'Livorno-Sub19' 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.0043  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 = 'Livorno-Sub19' 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.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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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=60523 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 = 51126
0.0023  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 = 51053
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60523 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1983 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1983 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1289511,1289484,1267642,1264496,1224952) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = '60523' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '60523' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '60523' 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 = '60523' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 51126 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 = 51053 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=60523 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (51126,51053) 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 = 51126 AND teamId = 60523
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 51053 AND teamId = 60523
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 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 = 51126 AND t.round = 22 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 = '60523' 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 = '60523' 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 = '60523' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039  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 = 51126 WHERE rp.league_id = 51126 AND rp.teamId = 60523 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.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 = 51126 WHERE rp.league_id = 51126 AND rp.teamId = 60523 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 51126 WHERE rp.league_id = 51126 AND rp.teamId = 60523 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 = 60523 AND l.year <= 2020 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 `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 = 51126 AND t.round = 22 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 = 48437 AND t.round = 22 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 `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 = 15856 AND t.round = 26 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 `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 = 9270 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 44184 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 44185 AND t.round = 26 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 `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 = 44188 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 44191 AND t.round = 26 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 = 44194 AND t.round = 26 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 `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 = 44197 AND t.round = 26 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 `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 = 44200 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC