4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Salernitana Sub 19
TEMPORADA 2023/2024
CAMPIONATO PRIMAVERA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Cesena Sub 19 Cesena 29 90 28 70
2 Benevento Sub 19 Benevento 29 66 42 59
3 Napoli Sub 19 Napoli 29 45 29 51
4 Pisa SC Sub 19 Pisa 29 45 36 48
5 Virtus Entella Sub 19 Virtus 29 43 34 44
6 Ascoli Sub 19 Ascoli 29 48 41 44
7 Nuova Cosenza Sub 19 Nuova 29 34 37 39
8 Perugia Sub 19 Perugia 29 51 53 38
9 Palermo Sub 19 Palermo 29 35 38 38
10 Spezia Sub 19 Spezia 29 54 50 35
11 SSC Bari Sub 19 Bari 29 51 67 34
12 Salernitana Sub 19 Salernitana 29 33 48 33
13 Ternana Sub 19 Ternana 29 28 43 31
14 Pescara Sub 19 Pescara 29 53 59 30
15 Monopoli Sub 19 Monopoli 29 24 59 20
16 Crotone Sub 19 Crotone 29 27 63 19
TEMPORADA 2022/2023
CAMPIONATO PRIMAVERA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Lazio Sub 19 Lazio 30 67 27 63
2 Ascoli Sub 19 Ascoli 30 53 38 59
3 Virtus Entella Sub 19 Virtus 30 55 39 54
4 Nuova Cosenza Sub 19 Nuova 30 44 31 50
5 Benevento Sub 19 Benevento 30 48 36 50
6 Spezia Sub 19 Spezia 30 66 48 48
7 Pisa SC Sub 19 Pisa 30 40 34 44
8 Crotone Sub 19 Crotone 30 41 49 41
9 Pescara Sub 19 Pescara 30 51 53 40
10 Perugia Sub 19 Perugia 30 44 44 38
11 Imolese Sub 19 Imolese 30 31 40 33
12 Viterbese Castrense Sub 19 Viterbese 30 36 62 31
13 Monopoli Sub 19 Monopoli 30 32 59 31
14 Salernitana Sub 19 Salernitana 30 34 46 30
15 Ternana Sub 19 Ternana 29 35 49 28
16 Reggina Sub 19 Reggina 29 27 49 27
TEMPORADA 2021/2022
CAMPIONATO PRIMAVERA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Cesena Sub 19 Cesena 24 74 35 56
2 Frosinone Sub 19 Frosinone 24 64 35 49
3 Pisa SC Sub 19 Pisa 24 42 30 46
4 Lazio Sub 19 Lazio 24 57 28 44
5 Perugia Sub 19 Perugia 24 46 35 39
6 Benevento Sub 19 Benevento 24 41 41 37
7 Ascoli Sub 19 Ascoli 24 36 32 34
8 Spezia Sub 19 Spezia 24 42 40 34
9 Nuova Cosenza Sub 19 Nuova 24 38 47 27
10 Salernitana Sub 19 Salernitana 24 38 52 25
11 Reggina Sub 19 Reggina 24 28 53 25
12 Crotone Sub 19 Crotone 24 33 70 16
13 Ternana Sub 19 Ternana 24 20 61 13
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 1
Equipo PJ GF GC Puntos
1 Bologna Sub 19 Bologna 22 48 17 53
2 SPAL Sub 19 SPAL Sub 19 22 42 24 45
3 Venezia Sub 19 Venezia 22 37 28 38
4 Spezia Sub 19 Spezia 22 43 29 35
5 Hellas Verona Sub 19 Hellas 22 40 30 35
6 Brescia Sub 19 Brescia 22 41 42 31
7 Padova Sub 19 Padova 22 29 33 30
8 Cremonese Sub 19 Cremonese 22 36 37 29
9 Parma Sub 19 Parma 22 29 41 25
10 Carpi Sub 19 Carpi 22 23 42 19
11 Salernitana Sub 19 Salernitana 22 20 42 14
12 Cittadella Sub 19 Cittadella 22 17 40 12
TEMPORADA 2017/2018
CAMPIONATO PRIMAVERA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Palermo Sub 19 Palermo 24 50 23 45
2 Cagliari Sub 19 Cagliari 24 46 23 44
3 SSC Bari Sub 19 Bari 24 47 33 42
4 Ascoli Sub 19 Ascoli 24 50 34 42
5 Crotone Sub 19 Crotone 24 44 30 38
6 Perugia Sub 19 Perugia 24 39 32 37
7 Pescara Sub 19 Pescara 24 44 34 37
8 Frosinone Sub 19 Frosinone 24 31 31 34
9 Ternana Sub 19 Ternana 24 34 30 32
10 Calcio Foggia Sub 19 Calcio 24 38 39 28
11 Benevento Sub 19 Benevento 24 28 42 27
12 Salernitana Sub 19 Salernitana 24 26 44 26
13 Avellino Sub 19 Avellino 24 22 104 0
TEMPORADA 2016/2017
CAMPIONATO PRIMAVERA 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Atalanta Sub 19 Atalanta 26 68 22 63
2 Inter Sub 19 Inter 26 66 18 60
3 Virtus Entella Sub 19 Virtus 26 53 21 56
4 Roma Sub 19 Roma Sub 19 26 82 41 53
5 Genoa Sub 19 Genoa 26 56 41 51
6 Bologna Sub 19 Bologna 26 40 28 48
7 Palermo Sub 19 Palermo 26 38 33 38
8 Novara Sub 19 Novara 26 28 36 33
9 Crotone Sub 19 Crotone 26 37 45 32
10 Ternana Sub 19 Ternana 26 21 44 25
11 Cagliari Sub 19 Cagliari 26 27 47 24
12 Frosinone Sub 19 Frosinone 26 25 54 17
13 Pisa SC Sub 19 Pisa 26 16 75 14
14 Salernitana Sub 19 Salernitana 26 27 79 6
TEMPORADA 2015/2016
CAMPIONATO PRIMAVERA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Inter Sub 19 Inter 26 50 18 60
2 Atalanta Sub 19 Atalanta 26 53 23 57
3 Milan Sub 19 Milan 26 58 31 52
4 Chievo Verona Sub 19 Chievo 26 45 22 49
5 Cagliari Sub 19 Cagliari 26 52 41 48
6 Hellas Verona Sub 19 Hellas 26 38 26 46
7 Udinese Sub 19 Udinese 26 33 31 32
8 Cesena Sub 19 Cesena 26 32 36 32
9 Bologna Sub 19 Bologna 26 28 35 32
10 Como Sub 19 Como Sub 19 26 32 48 26
11 Perugia Sub 19 Perugia 26 31 54 24
12 Brescia Sub 19 Brescia 26 41 64 22
13 Vicenza Sub 19 Vicenza 26 26 43 19
14 Salernitana Sub 19 Salernitana 26 21 68 16
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

  USO DE MEMORIA  
6,144,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6271
Total Execution Time  0.6283
  CADENA URL  
/historico/Us-Salernitana-1919-Sub19
  GET DATOS  
$_GET['/historico/Us-Salernitana-1919-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0154  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 = 'Us-Salernitana-1919-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.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=82259 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=82259 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=82259 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=82259 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1983 AND type_rel = 3
0.0146  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.0147  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.0151  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 = '82259' ORDER BY l.year DESC,cat.coefficient DESC
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 = '82259' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '82259' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=82259 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (74038,74005) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 74038 AND teamId = 82259
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 74005 AND teamId = 82259
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 = '82259' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '82259' 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 = '82259' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0160  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 = 74038 WHERE rp.league_id = 74038 AND rp.teamId = 82259 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.0163  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 = 74038 WHERE rp.league_id = 74038 AND rp.teamId = 82259 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167  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 = 74038 WHERE rp.league_id = 74038 AND rp.teamId = 82259 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 82259 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74038 AND t.round = 29 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 = 68689 AND t.round = 30 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 = 64094 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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.0160  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.0164  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 = 48436 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 40231 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 37894 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 15857 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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.0151  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.0146  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 = 74038 ORDER BY nameShow LIMIT 100