4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Junior
TEMPORADA 2023/2024
3ª CATALANA GRUPO 7
Equipo PJ GF GC Puntos
1 Sabadellenca UE Sabadellenca 27 92 29 71
2 Can Parellada Parellada 27 46 23 57
3 Junior Junior 26 65 38 54
4 San Lorenzo San Lorenzo 27 61 35 49
5 Planadeu-Roureda Planadeu-Rou 27 59 39 47
6 Fundació Terrassa 1906 A Fundació 27 47 36 44
7 Marina-Escola Joan Murtro Marina-Escol 27 64 58 38
8 Rubí B Rubí B 27 47 59 36
9 Juan XXIII Juan XXIII 27 48 50 35
10 Llorençà Llorençà 26 57 61 33
11 PB Ramon Llorens Ramon 27 35 37 29
12 Vilassar Dalt CE B Vilassar 27 47 66 28
13 Matadepera Matadepera 27 36 71 25
14 Sant Quirze Valles B Sant Quirze 27 50 67 24
15 S. Cristóbal B Cristóbal 27 36 89 20
16 Can Boada Can Boada 27 37 69 19
TEMPORADA 2022/2023
3ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 Juv. 25 Setembre Juv. 33 101 41 82
2 Sant Cugat Esport B B Sant Cugat. 34 98 42 71
3 Sabadellenca UE Sabadellenca 33 82 48 69
4 Fundació Terrassa 1906 A Fundació 34 78 40 67
5 Sant Quirze Valles B Sant Quirze 32 78 53 59
6 Junior Junior 34 92 62 52
7 Can Trias Can Trias 32 69 71 46
8 La Farga XXI Farga 33 72 74 45
9 Matadepera Matadepera 34 81 99 45
10 Llorençà Llorençà 34 63 85 43
11 S. Cristóbal B Cristóbal 33 66 61 42
12 Juan XXIII Juan XXIII 33 65 72 41
13 Rubí B Rubí B 34 56 69 41
14 Can Parellada Parellada 31 61 66 38
15 EF Planadeu B Planadeu 34 60 82 38
16 Castellbisbal Castellbisba 34 55 80 33
17 Cercle Sabadellès Cercle 33 50 86 26
18 Les Fonts A Les Fonts A 33 36 132 10
TEMPORADA 2021/2022
3ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 San Lorenzo San Lorenzo 29 82 35 72
2 Juv. 25 Setembre Juv. 30 82 30 68
3 Sant Cugat Esport B B Sant Cugat. 29 74 35 60
4 Rubí B Rubí B 29 64 54 51
5 Junior Junior 30 96 62 46
6 Can Parellada Parellada 30 52 46 40
7 Juan XXIII Juan XXIII 29 59 61 37
8 Castellbisbal Castellbisba 29 55 57 36
9 Fundació Terrassa 1906 A Fundació 27 54 60 36
10 Matadepera Matadepera 30 70 82 34
11 Les Fonts A Les Fonts A 30 56 78 34
12 Llorençà Llorençà 29 64 95 33
13 S. Cristóbal B Cristóbal 29 51 60 32
14 Mirasol-Baco Mirasol-Baco 30 53 67 32
15 EF Planadeu B Planadeu 28 48 75 32
16 Pueblo Nuevo 2002 Pueblo Nuevo 28 33 96 12
TEMPORADA 2020/2021
3ª CATALANA GRUPO 8
Equipo PJ GF GC Puntos
1 Levante Las Planas Levante 17 49 14 44
2 Olesa Olesa 17 50 21 43
3 Corbera Corbera 17 51 26 36
4 Pallejà Pallejà 17 31 23 28
5 PR Sant Feliu Ll. Sant Feliu 17 29 35 26
6 Juv. 25 Setembre Juv. 17 36 31 25
7 Sant Andreu de la Barca B Sant Andreu 17 33 36 23
8 Mirasol-Baco Mirasol-Baco 17 32 36 23
9 Esparreguera Esparreguera 17 34 41 22
10 Rubí B Rubí B 17 38 38 20
11 Papiol Papiol 17 32 33 20
12 Sant Esteve Sesrovires Sant Esteve 17 33 39 20
13 Incresa Incresa 17 35 43 20
14 Junior Junior 17 38 38 19
15 Abrera Abrera 17 27 35 18
16 Cervelló Cervelló 17 20 34 17
17 Castellbisbal Castellbisba 17 18 35 17
18 La Palma Cervelló Palma 17 30 58 8
TEMPORADA 2019/2020
3ª CATALANA GRUPO 4
Equipo PJ GF GC Puntos
1 Vilassar Mar B Vilassar 23 61 14 63
2 Llavaneres Llavaneres 23 55 30 49
3 Lloreda Lloreda 23 57 27 48
4 Vilassar Dalt Vilassar 23 57 24 46
5 Santvicentí Santvicentí 23 51 31 44
6 Young Talent Badalona Young Talent 23 57 40 41
7 Junior Junior 23 52 45 38
8 At. Masnou At. Masnou 23 50 39 37
9 Calella Calella 23 41 33 37
10 Cabrils Cabrils 23 33 43 24
11 Mataronesa Mataronesa 23 28 39 24
12 La Salut Pere Gol A Salut Pere 23 50 61 21
13 Premià Dalt Premià Dalt 23 32 61 21
14 FE Montgat FE Montgat 23 37 60 20
15 Tiana Tiana 23 27 60 20
16 Pastrana-Baix Carmel Pastrana-Bai 23 25 55 18
17 La Llàntia La Llàntia 23 27 51 17
18 Pujadas Pujadas 23 38 65 16
TEMPORADA 2018/2019
3ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 Tibidabo Torre Romeu Tibidabo 34 113 53 76
2 Badia del Vallès Badia 34 111 50 72
3 Can Rull RT Can Rull RT 34 92 44 71
4 Llano de Sabadell Llano 34 102 62 71
5 PD Pajaril PD Pajaril 33 77 52 59
6 Castellbisbal Castellbisba 34 61 66 58
7 Juv. 25 Setembre Juv. 34 85 59 57
8 La Romànica Romànica 34 104 83 57
9 Cerdanyola del Valles B Cerdanyola 34 61 62 46
10 Mirasol-Baco Mirasol-Baco 34 65 68 44
11 EF Barberà And. Barberà 34 63 67 44
12 Sant Cugat Esport B B Sant Cugat. 34 62 66 43
13 Planadeu-Roureda Planadeu-Rou 34 91 71 43
14 Junior Junior 34 79 86 41
15 Marina-Escola Joan Murtro Marina-Escol 34 66 74 40
16 At. Hospitalense Hospitalense 34 56 104 25
17 La Guardia La Guardia 33 60 162 17
18 Atletic Prat Delta B B Atletic Prat 34 43 162 3
TEMPORADA 2017/2018
2ª CATALANA GRUPO 3
Equipo PJ GF GC Puntos
1 Vilanova Geltru CF Vilanova 34 75 41 72
2 Rubí Rubí 34 61 37 63
3 Begues Begues 34 57 40 63
4 Sant Quirze Valles Sant Quirze 34 59 44 59
5 Can Trias Can Trias 34 67 54 55
6 Fontsanta Fatjo Fontsanta 34 58 53 54
7 Prat B Prat B 34 48 48 53
8 At. Sant Just Sant Just 34 64 50 52
9 At. Vilafranca Vilafranca 34 62 57 50
10 Olímpic Can Fatjó Olímpic 34 36 36 48
11 Espluguenc Espluguenc 34 50 50 46
12 At. Prat Delta Prat Delta 34 52 42 44
13 Marianao Poblet Marianao 34 49 43 44
14 Molins de Rei Molins 34 53 62 43
15 Junior Junior 34 67 71 42
16 Suburense Suburense 34 45 58 38
17 Sant Joan Despi UE Sant Joan D. 34 50 90 23
18 Gornal Gornal 34 27 104 12
TEMPORADA 2016/2017
2ª CATALANA GRUPO 3
Equipo PJ GF GC Puntos
1 Can Vidalet Can Vidalet 34 84 35 76
2 Unificació Bellvitge Unificació 34 67 20 71
3 Sant Joan Despi UE Sant Joan D. 34 82 48 63
4 Espluguenc Espluguenc 34 57 53 55
5 Fontsanta-Fatjo Fem Fontsanta-Fa 34 62 49 53
6 At. Sant Just Sant Just 34 87 76 51
7 Olímpic Can Fatjó Olímpic 34 59 53 50
8 Marianao Poblet Marianao 34 46 44 50
9 Junior Junior 34 51 56 48
10 Gornal Gornal 34 57 67 48
11 At. Prat Delta Prat Delta 34 52 52 47
12 At. Vilafranca Vilafranca 34 44 55 47
13 Martorell Martorell 34 61 64 43
14 Montserrat Igualada Montserrat 34 56 62 42
15 San Mauro San Mauro 34 47 64 35
16 Dinamic Batllo Esportiu Dinamic 34 44 81 30
17 Ciudad Cooperativa Ciudad 34 44 75 22
18 Moja Moja 34 46 92 22
TEMPORADA 2015/2016
2ª CATALANA GRUPO 3
Equipo PJ GF GC Puntos
1 Sant Cugat Sant Cugat 34 67 36 65
2 Espluguenc Espluguenc 34 58 49 60
3 Sant Joan Despi UE Sant Joan D. 34 58 44 59
4 Can Vidalet Can Vidalet 34 62 49 58
5 Junior Junior 34 54 42 56
6 Olímpic Can Fatjó Olímpic 34 58 45 55
7 Moja Moja 34 71 55 54
8 Gornal Gornal 34 58 54 50
9 Marianao Poblet Marianao 34 38 35 45
10 At. Vilafranca Vilafranca 34 44 50 43
11 Unificació Bellvitge Unificació 34 41 43 43
12 San Mauro San Mauro 34 43 48 43
13 Fontsanta-Fatjo Fem Fontsanta-Fa 34 47 57 42
14 Begues Begues 34 44 57 40
15 Prat B Prat B 34 53 61 38
16 Òdena Òdena 34 48 74 34
17 Vallirana Vallirana 34 36 52 34
18 Torrelles Torrelles 34 32 61 25
TEMPORADA 2014/2015
2ª CATALANA GRUPO 3
Equipo PJ GF GC Puntos
1 Suburense Suburense 34 82 39 72
2 Vista Alegre Vista Alegre 34 71 41 69
3 Can Vidalet Can Vidalet 34 70 44 66
4 Unificació Bellvitge Unificació 34 58 32 66
5 Marianao Poblet Marianao 34 46 43 55
6 Gornal Gornal 34 64 45 54
7 San Mauro San Mauro 34 44 42 48
8 Begues Begues 34 52 52 45
9 Sant Joan Despi UE Sant Joan D. 34 44 46 45
10 Sant Cugat Sant Cugat 34 39 39 44
11 Prat B Prat B 34 37 48 42
12 Moja Moja 34 63 65 41
13 Junior Junior 34 50 51 40
14 Espluguenc Espluguenc 34 48 53 40
15 Martorell Martorell 34 49 60 38
16 Olivella Olivella 34 48 67 38
17 Sant Andreu de la Barca Sant Andreu 34 37 78 32
18 PUD Málaga PUD Málaga 34 41 98 19
TEMPORADA 2011/2012
PRIMERA CATALANA GRUPO 1
Equipo PJ GF GC Puntos
1 UE Figueres UE Figueres 34 69 28 78
2 UE Vilassar de Mar Vilassar 34 64 31 69
3 Palamós Palamós 34 66 29 67
4 CP San Cristóbal Cristóbal 34 53 50 63
5 Cerdanyola FC Cerdanyola 34 57 41 54
6 Mollet Mollet 34 61 44 53
7 UE Avià UE Avià 34 61 59 48
8 Farners Farners 34 63 63 45
9 Cf Lloret Cf Lloret 34 48 59 45
10 Ripollet Ripollet 34 65 65 44
11 Montcada Montcada 34 52 61 44
12 Guíxols Guíxols 34 44 54 42
13 CF Peralada CF Peralada 34 58 58 41
14 Gramanet B Gramanet B 34 49 66 40
15 San Lorenzo San Lorenzo 34 38 54 38
16 Premià Premià 34 35 59 32
17 CE Manresa CE Manresa 34 45 65 28
18 Junior Junior 34 32 74 24

  USO DE MEMORIA  
6,209,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3064
Total Execution Time  0.3076
  CADENA URL  
/historico/Junior-Cf
  GET DATOS  
$_GET['/historico/Junior-Cf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0028  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 = 'Junior-Cf' 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.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=18171 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=18171 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 73174
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18171 AND type_rel = 2
0.0022  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 = '18171' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '18171' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 73174 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=18171 AND l.year in (2023,2024,2025) 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 (73174) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73174 AND teamId = 18171
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 `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 = 73174 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = 73174 WHERE rp.league_id = 73174 AND rp.teamId = 18171 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.0019  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 = 73174 WHERE rp.league_id = 73174 AND rp.teamId = 18171 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 73174 WHERE rp.league_id = 73174 AND rp.teamId = 18171 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 18171 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73174 AND t.round = 27 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 `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 = 68572 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.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 = 63751 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.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 `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 = 58792 AND t.round = 17 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 `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 = 50746 AND t.round = 23 ORDER BY team.conference ASC,t.position 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 `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 = 44421 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 `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 = 38995 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 = 33987 AND t.round = 34 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 `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 = 16674 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 `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 = 3950 AND t.round = 34 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 = 1458 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 = 73174 ORDER BY nameShow LIMIT 100