4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Marianao Poblet
TEMPORADA 2023/2024
2ª CATALANA GRUPO 3
Equipo PJ GF GC Puntos
1 Almeda Almeda 0 0 0 0
2 CF Gavá CF Gavá 0 0 0 0
3 Ciudad Cooperativa Ciudad 0 0 0 0
4 Espluguenc Espluguenc 0 0 0 0
5 Fundació Academia F. L'hosp Fundació 0 0 0 0
6 Juv. 25 Setembre Juv. 0 0 0 0
7 Levante Las Planas Levante 0 0 0 0
8 Marianao Poblet Marianao 0 0 0 0
9 Moja Moja 0 0 0 0
10 Molins de Rei Molins 0 0 0 0
11 Sant Vicenç Dels Horts A Sant Vicenç 0 0 0 0
12 Sector Montserratina Sector 0 0 0 0
13 Sporting Gava 2013 Sporting 0 0 0 0
14 Terlenka Barcelonista A Terlenka 0 0 0 0
15 Unificació Bellvitge Unificació 0 0 0 0
16 Viladecans B Viladecans 0 0 0 0
17 Vilanova Camí Vilanova 0 0 0 0
18 Vista Alegre Vista Alegre 0 0 0 0
TEMPORADA 2022/2023
2ª CATALANA GRUPO 5
Equipo PJ GF GC Puntos
1 Gornal Gornal 20 43 21 46
2 Sant Ildefons Sant 20 41 19 36
3 Sporting Gava 2013 Sporting 20 28 23 32
4 Terlenka Terlenka 20 32 26 29
5 Unificació Bellvitge Unificació 20 26 25 29
6 Almeda Almeda 20 26 23 28
7 Marianao Poblet Marianao 20 29 27 28
8 Legends L´hospitalet Legends 20 22 31 22
9 Levante Las Planas Levante 20 19 34 22
10 Sant Ignasi Sant Ignasi 20 22 41 19
11 Valldoreix Valldoreix 20 20 38 14
TEMPORADA 2021/2022
2ª CATALANA GRUPO 3
Equipo PJ GF GC Puntos
1 San Mauro San Mauro 27 67 28 63
2 Prat B Prat B 27 68 35 57
3 Sitges Sitges 27 59 37 49
4 Marianao Poblet Marianao 27 63 46 47
5 Terlenka Terlenka 28 47 43 45
6 Sporting Gava 2013 Sporting 27 51 37 42
7 At. Vilafranca Vilafranca 28 55 49 41
8 Sant Quirze Valles Sant Quirze 27 50 36 39
9 At. Prat Delta Prat Delta 28 43 39 39
10 Cubelles Cubelles 25 40 41 38
11 Moja Moja 27 42 50 31
12 Sant Andreu de la Barca Sant Andreu 26 48 58 31
13 Olivella Olivella 26 35 53 20
14 Montserrat Igualada Montserrat 27 35 67 20
15 Òdena Òdena 27 24 108 2
TEMPORADA 2020/2021
2ª CATALANA GRUPO 6
Equipo PJ GF GC Puntos
1 San Mauro San Mauro 1 2 0 3
2 Almeda Almeda 1 1 0 3
3 Molins de Rei Molins 1 1 0 3
4 Marianao Poblet Marianao 1 2 2 1
5 Valldoreix Valldoreix 1 2 2 1
6 Sant Andreu de la Barca Sant Andreu 1 0 0 1
7 Olímpic Can Fatjó Olímpic 1 0 0 1
8 Atlètic Junior FC Atlètic 0 0 0 0
9 Sporting Gava 2013 Sporting 1 0 1 0
10 Fontsanta Fatjo Fontsanta 1 0 1 0
11 Òdena Òdena 1 0 2 0
TEMPORADA 2019/2020
2ª CATALANA GRUPO 3
Equipo PJ GF GC Puntos
1 Sant Cugat Sant Cugat 23 41 21 46
2 At. Prat Delta Prat Delta 23 51 33 46
3 Unificació Bellvitge Unificació 23 41 29 45
4 Sitges Sitges 23 49 39 44
5 Molins de Rei Molins 23 30 36 38
6 Sant Andreu de la Barca Sant Andreu 23 38 25 37
7 Valldoreix Valldoreix 23 41 37 36
8 Almeda Almeda 23 30 28 33
9 Marianao Poblet Marianao 23 39 37 32
10 Atlètic Junior FC Atlètic 23 46 37 29
11 Cubelles Cubelles 23 35 40 28
12 At. Vilafranca Vilafranca 23 43 40 27
13 Olivella Olivella 23 37 46 27
14 Fontsanta Fatjo Fontsanta 23 28 42 27
15 Can Buxeres Can Buxeres 23 28 41 23
16 Espluguenc Espluguenc 23 23 32 22
17 Sant Joan Despi UE Sant Joan D. 23 18 42 18
18 San Mauro San Mauro 23 38 51 16
TEMPORADA 2018/2019
2ª CATALANA GRUPO 3
Equipo PJ GF GC Puntos
1 At. Sant Just Sant Just 34 76 33 78
2 Martorell Martorell 34 60 26 68
3 Joventut Ribetana A Joventut 34 70 53 59
4 Can Trias Can Trias 34 56 37 58
5 At. Vilafranca Vilafranca 34 60 48 54
6 Unificació Bellvitge Unificació 34 47 46 54
7 Atlètic Junior FC Atlètic 34 84 66 53
8 Sant Quirze Valles Sant Quirze 34 57 48 52
9 Fontsanta Fatjo Fontsanta 34 51 54 48
10 Espluguenc Espluguenc 34 44 49 46
11 San Mauro San Mauro 34 57 67 45
12 Molins de Rei Molins 34 58 48 44
13 Marianao Poblet Marianao 34 52 62 43
14 At. Prat Delta Prat Delta 34 51 63 39
15 Prat B Prat B 34 48 64 37
16 PUD Málaga PUD Málaga 34 48 77 32
17 Olímpic Can Fatjó Olímpic 34 43 59 27
18 Begues Begues 34 28 90 12
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 2013/2014
PRIMERA CATALANA GRUPO 2
Equipo PJ GF GC Puntos
1 Martinenc Martinenc 34 66 37 69
2 Viladecans Viladecans 34 52 34 62
3 Torreforta Torreforta 34 64 45 59
4 UA Horta UA Horta 34 57 40 53
5 Tàrrega Tàrrega 33 40 38 53
6 Igualada Igualada 34 50 51 47
7 Ce Efac Almacelles Efac 34 50 46 47
8 Torredembarra Torredembarr 34 48 46 46
9 Vilanova Geltru CF Vilanova 34 42 34 43
10 El Catllar El Catllar 34 39 49 43
11 Amposta Amposta 34 43 46 42
12 Ce Tecnofutbol Tecnofutbol 34 37 39 42
13 Balaguer Balaguer 33 35 50 41
14 Vista Alegre Vista Alegre 34 42 51 39
15 At. Alpicat At. Alpicat 34 38 54 39
16 FC Andorra FC Andorra 34 51 66 38
17 Marianao Poblet Marianao 34 37 42 37
18 Jesús i Maria Jesús Maria 34 51 74 33
TEMPORADA 2009/2010
PRIMERA CATALANA
Equipo PJ GF GC Puntos
1 FC Vilafranca Vilafranca 38 63 29 81
2 Montañesa Montañesa 38 57 37 71
3 Masnou Masnou 38 64 44 66
4 Sanfeliuenc Sanfeliuenc 38 53 44 64
5 Gramanet B Gramanet B 38 62 40 62
6 CP San Cristóbal Cristóbal 38 48 38 62
7 Rubí Rubí 38 69 55 54
8 Igualada Igualada 38 49 53 54
9 UE Sants UE Sants 38 56 50 53
10 Tàrrega Tàrrega 38 46 47 51
11 Guíxols Guíxols 38 45 44 50
12 Unió Esportiva Poble Sec Unió 38 63 66 49
13 Gimnástica Iberiana Gimnástica 38 60 60 48
14 Montcada Montcada 38 48 54 46
15 CF Peralada CF Peralada 38 48 63 46
16 Tortosa Tortosa 38 39 50 45
17 UE Vilassar de Mar Vilassar 38 41 63 43
18 Marianao Poblet Marianao 38 50 65 42
19 Banyoles Banyoles 38 35 65 36
20 Mataró Mataró 38 41 70 22
TEMPORADA 2008/2009
PRIMERA CATALANA
Equipo PJ GF GC Puntos
1 Ascó Ascó 38 72 36 74
2 Castelldefels Castelldefel 38 59 40 70
3 CF Badalona Futur Badalona 38 62 40 68
4 Marianao Poblet Marianao 38 62 39 66
5 Masnou Masnou 38 64 46 66
6 Olesa Montserrat Olesa 38 61 49 66
7 Montañesa Montañesa 38 68 62 58
8 UE Vilassar de Mar Vilassar 38 48 46 55
9 Tàrrega Tàrrega 38 56 54 54
10 Tortosa Tortosa 38 54 45 53
11 Montcada Montcada 38 49 52 53
12 Unió Esportiva Poble Sec Unió 38 45 56 47
13 CF Peralada CF Peralada 38 51 61 46
14 CP San Cristóbal Cristóbal 38 45 56 46
15 Guíxols Guíxols 38 39 47 42
16 Igualada Igualada 38 54 67 42
17 FC Vilafranca Vilafranca 38 40 48 41
18 CE Manresa CE Manresa 38 45 71 39
19 Morell Morell 38 42 65 33
20 Martorell Martorell 38 34 70 27

  USO DE MEMORIA  
6,442,752 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1106
Total Execution Time  0.1119
  CADENA URL  
/historico/Marianao-Poblet
  GET DATOS  
$_GET['/historico/Marianao-Poblet']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0026  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 = 'Marianao-Poblet' 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=1648 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=1648 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 72888
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1648 AND type_rel = 2
0.0022  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 = '1648' 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 = 72888 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=1648 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (72888) 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 = 72888 AND teamId = 1648
0.0021  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 = 72888 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 = '1648' 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 = '1648' 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 = '1648' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 72888 WHERE rp.league_id = 72888 AND rp.teamId = 1648 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 = 72888 WHERE rp.league_id = 72888 AND rp.teamId = 1648 AND (e.action = 4 or e.action = 5) 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 = 72888 WHERE rp.league_id = 72888 AND rp.teamId = 1648 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 1648 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 72888 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.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 `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 = 68559 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 `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 = 63737 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.0021  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 = 58777 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.0030  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 = 50601 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.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 `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 = 44411 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 = 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.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 `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.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 `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 `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 = 2674 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 `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 = 813 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 290 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC