4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Lecce Sub 19
TEMPORADA 2023/2024
CAMPIONATO PRIMAVERA 1
Equipo PJ GF GC Puntos
1 Inter Sub 19 Inter 31 63 24 63
2 Roma Sub 19 Roma Sub 19 31 69 36 63
3 Atalanta Sub 19 Atalanta 31 55 39 55
4 Lazio Sub 19 Lazio 31 41 35 54
5 Torino Sub 19 Torino 31 61 58 48
6 Sassuolo Sub 19 Sassuolo 31 54 55 48
7 Milan Sub 19 Milan 31 48 39 46
8 Genoa Sub 19 Genoa 31 48 44 44
9 Hellas Verona Sub 19 Hellas 31 52 50 42
10 Cagliari Sub 19 Cagliari 31 43 53 41
11 Juventus Sub 19 Juventus 31 43 49 39
12 Fiorentina Sub 19 Fiorentina 31 48 47 36
13 Lecce Sub 19 Lecce 31 42 53 36
14 Empoli Sub 19 Empoli 31 44 52 35
15 AC Monza Sub 19 Monza 31 47 59 30
16 Bologna Sub 19 Bologna 31 38 62 30
17 Sampdoria Sub 19 Sampdoria 31 37 54 28
18 Frosinone Sub 19 Frosinone 31 39 63 25
TEMPORADA 2022/2023
CAMPIONATO PRIMAVERA 1
Equipo PJ GF GC Puntos
1 Lecce Sub 19 Lecce 34 56 31 65
2 Torino Sub 19 Torino 34 54 40 63
3 Fiorentina Sub 19 Fiorentina 34 54 35 63
4 Sassuolo Sub 19 Sassuolo 34 53 39 57
5 Juventus Sub 19 Juventus 34 71 56 56
6 Roma Sub 19 Roma Sub 19 34 70 54 55
7 Inter Sub 19 Inter 34 53 41 55
8 Empoli Sub 19 Empoli 34 47 45 49
9 Bologna Sub 19 Bologna 34 49 52 49
10 Frosinone Sub 19 Frosinone 34 46 48 47
11 Sampdoria Sub 19 Sampdoria 34 53 47 47
12 Milan Sub 19 Milan 34 52 51 45
13 Hellas Verona Sub 19 Hellas 34 47 48 44
14 Cagliari Sub 19 Cagliari 34 53 57 44
15 Atalanta Sub 19 Atalanta 34 55 56 42
16 Napoli Sub 19 Napoli 34 32 51 32
17 Udinese Sub 19 Udinese 34 26 66 19
18 Cesena Sub 19 Cesena 34 30 84 11
TEMPORADA 2021/2022
CAMPIONATO PRIMAVERA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Roma Sub 19 Roma Sub 19 34 64 33 71
2 Inter Sub 19 Inter 34 60 33 64
3 Cagliari Sub 19 Cagliari 34 59 44 61
4 Atalanta Sub 19 Atalanta 34 62 49 58
5 Juventus Sub 19 Juventus 34 68 48 57
6 Sampdoria Sub 19 Sampdoria 34 63 52 53
7 Fiorentina Sub 19 Fiorentina 34 48 50 51
8 Sassuolo Sub 19 Sassuolo 34 50 36 48
9 Bologna Sub 19 Bologna 34 46 53 46
10 Empoli Sub 19 Empoli 34 42 44 46
11 Hellas Verona Sub 19 Hellas 34 53 54 46
12 Torino Sub 19 Torino 34 42 46 43
13 Milan Sub 19 Milan 34 55 63 43
14 Lecce Sub 19 Lecce 34 42 48 40
15 Napoli Sub 19 Napoli 34 43 57 40
16 Genoa Sub 19 Genoa 34 39 42 38
17 SPAL Sub 19 SPAL Sub 19 34 40 80 26
18 Pescara Sub 19 Pescara 34 35 79 19
TEMPORADA 2020/2021
CAMPIONATO PRIMAVERA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Pescara Sub 19 Pescara 22 58 18 53
2 Lecce Sub 19 Lecce 22 42 21 46
3 Napoli Sub 19 Napoli 22 36 26 38
4 Virtus Entella Sub 19 Virtus 22 42 35 38
5 Frosinone Sub 19 Frosinone 22 37 33 30
6 Spezia Sub 19 Spezia 22 27 29 29
7 Crotone Sub 19 Crotone 22 40 44 29
8 Nuova Cosenza Sub 19 Nuova 22 30 34 29
9 Benevento Sub 19 Benevento 22 40 46 26
10 Pisa SC Sub 19 Pisa 22 27 36 19
11 Reggina Sub 19 Reggina 22 23 50 19
12 Salernitana Sub 19 Salernitana 22 25 55 10
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 2011/2012
CAMPIONATO PRIMAVERA 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Roma Sub 19 Roma Sub 19 26 95 23 70
2 Lazio Sub 19 Lazio 26 93 20 62
3 Palermo Sub 19 Palermo 26 60 31 58
4 Catania Sub 19 Catania 26 47 40 46
5 Napoli Sub 19 Napoli 26 41 38 45
6 Reggina Sub 19 Reggina 26 36 25 40
7 Lecce Sub 19 Lecce 26 53 58 39
8 Ascoli Sub 19 Ascoli 26 35 58 30
9 Juve Stabia Sub 19 Juve Stabia 26 28 36 25
10 Nocerina Sub 19 Nocerina 26 37 64 25
11 SSC Bari Sub 19 Bari 26 39 55 24
12 Pescara Sub 19 Pescara 26 26 56 18
13 Crotone Sub 19 Crotone 26 36 65 16
14 AS Gubbio 1910 Sub 19 Gubbio 1910 26 17 74 11
TEMPORADA 2010/2011
CAMPIONATO PRIMAVERA 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Roma Sub 19 Roma Sub 19 26 82 34 62
2 Lazio Sub 19 Lazio 26 51 28 55
3 Catania Sub 19 Catania 26 45 30 49
4 Siena Sub 19 Siena 26 33 23 44
5 Napoli Sub 19 Napoli 26 40 29 43
6 Palermo Sub 19 Palermo 26 39 44 35
7 Ascoli Sub 19 Ascoli 26 40 48 32
8 Reggina Sub 19 Reggina 26 38 41 31
9 Crotone Sub 19 Crotone 26 23 39 29
10 Grosseto Sub 19 Grosseto 26 32 55 28
11 SSC Bari Sub 19 Bari 26 43 51 27
12 Lecce Sub 19 Lecce 26 29 44 26
13 Frosinone Sub 19 Frosinone 26 29 40 25
14 Pescara Sub 19 Pescara 26 28 46 21
TEMPORADA 2009/2010
CAMPIONATO PRIMAVERA 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Roma Sub 19 Roma Sub 19 26 61 9 63
2 Palermo Sub 19 Palermo 26 49 20 55
3 Lazio Sub 19 Lazio 26 52 23 51
4 Catania Sub 19 Catania 26 51 28 50
5 SSC Bari Sub 19 Bari 26 41 26 49
6 Reggina Sub 19 Reggina 26 43 27 45
7 Salernitana Sub 19 Salernitana 26 41 30 44
8 Napoli Sub 19 Napoli 26 36 37 35
9 Ascoli Sub 19 Ascoli 26 31 51 28
10 Lecce Sub 19 Lecce 26 30 47 23
11 Crotone Sub 19 Crotone 26 23 49 21
12 Ancona Sub 19 Ancona 26 28 56 20
13 Frosinone Sub 19 Frosinone 26 24 42 19
14 Gallipoli Sub 19 Gallipoli 26 15 80 5
TEMPORADA 2008/2009
CAMPIONATO PRIMAVERA 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Lazio Sub 19 Lazio 26 56 17 60
2 Roma Sub 19 Roma Sub 19 26 52 24 51
3 Reggina Sub 19 Reggina 26 59 24 49
4 Palermo Sub 19 Palermo 26 41 20 48
5 Napoli Sub 19 Napoli 26 43 35 44
6 Catania Sub 19 Catania 26 30 26 43
7 Fiorentina Sub 19 Fiorentina 26 41 22 41
8 Ascoli Sub 19 Ascoli 26 43 35 41
9 SSC Bari Sub 19 Bari 26 34 42 33
10 Lecce Sub 19 Lecce 26 28 39 27
11 Salernitana Sub 19 Salernitana 26 31 54 26
12 Frosinone Sub 19 Frosinone 26 23 48 20
13 Avellino Sub 19 Avellino 26 16 65 10
14 Ancona Sub 19 Ancona 26 24 70 7
TEMPORADA 2007/2008
CAMPIONATO PRIMAVERA 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Ascoli Sub 19 Ascoli 26 41 18 56
2 Catania Sub 19 Catania 26 34 16 49
3 Lazio Sub 19 Lazio 26 41 28 46
4 Roma Sub 19 Roma Sub 19 26 48 30 44
5 Reggina Sub 19 Reggina 26 40 27 43
6 Siena Sub 19 Siena 26 30 21 41
7 SSC Bari Sub 19 Bari 26 42 37 38
8 Napoli Sub 19 Napoli 26 33 30 37
9 Palermo Sub 19 Palermo 26 32 31 37
10 Grosseto Sub 19 Grosseto 26 25 40 35
11 Frosinone Sub 19 Frosinone 26 24 44 21
12 Lecce Sub 19 Lecce 26 21 39 20
13 ACR Messina Sub 19 Messina 26 18 39 15
14 Avellino Sub 19 Avellino 26 18 47 14

  USO DE MEMORIA  
6,568,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6937
Total Execution Time  0.6956
  CADENA URL  
/historico/Lecce-Berretti
  GET DATOS  
$_GET['/historico/Lecce-Berretti']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0157  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 = 'Lecce-Berretti' 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.0144  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=90161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=90161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=90161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=90161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=90161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=90161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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 = 72971
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90161 AND type_rel = 2
0.0150  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 = '90161' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '90161' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '90161' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0145  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 = 72971 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  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=90161 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (74025,74005,73159,72971,71432) 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.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 73159 AND teamId = 90161
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 74025 AND teamId = 90161
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 74005 AND teamId = 90161
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 72971 AND teamId = 90161
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 90161
0.0147  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 = '90161' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '90161' and rp.type = 4
0.0146  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 = '90161' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154  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 events2024 e ON e.player_id = p.id AND e.league_id = 74025 WHERE rp.league_id = 74025 AND rp.teamId = 90161 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.0153  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 events2024 e ON e.player_id = p.id AND e.league_id = 74025 WHERE rp.league_id = 74025 AND rp.teamId = 90161 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 events2024 e ON e.player_id = p.id AND e.league_id = 74025 WHERE rp.league_id = 74025 AND rp.teamId = 90161 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 90161 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73159 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68356 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.0150  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 = 63729 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.0148  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 = 58823 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.0149  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.0148  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.0148  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 = 44190 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 44193 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 44196 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 44199 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 44202 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC