4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Santiago Futsal
TEMPORADA 2021/2022
SEGUNDA DIVISIÓN B FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Guardo Guardo 30 138 86 67
2 Union Arroyo FS Union Arroyo 30 137 116 57
3 Santiago Futsal Santiago 30 107 68 57
4 O Esteo O Esteo 30 109 101 50
5 Segosala Segosala 30 121 108 46
6 Sala Ourense 2014 Sala Ourense 30 113 116 46
7 Ribeira De Piquin Ribeira 30 98 73 44
8 Albense Albense 30 103 91 42
9 Leis Pontevedra Leis 30 100 89 41
10 IES Coruxo IES Coruxo 30 107 103 39
11 O´Parrulo Ferrol FS B O´Parrulo 30 93 105 38
12 A Estrada A Estrada 30 102 122 37
13 Univ. de Valladolid Univ. 30 109 131 35
14 Cidade De Narón Cidade 30 88 116 33
15 UV Ventorrillo Ventorrillo 30 71 114 27
16 Racing de Mieres Racing 30 92 149 27
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 Alzira FS Alzira FS 24 78 67 36
2 Bisontes Castellón FS Bisontes 24 62 72 33
3 Full Energía Zaragoza Full 24 101 90 32
4 Ciudad de Móstoles Ciudad 24 71 69 32
5 CD Leganes FS Leganes 24 77 77 31
6 Elche CF Sala Elche Sala 24 84 89 31
7 ElPozo Ciudad de Murcia ElPozo 24 55 64 23
8 Rivas Futsal Rivas Futsal 24 56 97 21
9 Santiago Futsal Santiago 24 46 78 18
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Real Betis Futsal Real Betis. 23 83 47 50
2 CD UMA Antequera Antequera 23 82 43 45
3 Soliss FS Talavera Soliss 23 74 52 43
4 Manzanares FS Manzanares 23 67 56 43
5 Elche CF Sala Elche Sala 23 78 78 40
6 Ciudad de Móstoles Ciudad 23 73 63 33
7 ElPozo Ciudad de Murcia ElPozo 23 61 55 31
8 Noia Portus Apostoli Noia Portus 23 63 69 31
9 Atlético Mengíbar FS Atlético 23 60 61 30
10 Alzira FS Alzira FS 23 70 78 30
11 Barça Atlétic Barça 23 67 71 28
12 Union África Ceutí Union 23 58 65 26
13 Bisontes Castellón FS Bisontes 23 47 66 25
14 Santiago Futsal Santiago 23 42 59 22
15 Full Energía Zaragoza Full 23 82 103 22
16 Rivas Futsal Rivas Futsal 23 59 100 13
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Burela FS Burela FS 30 116 68 67
2 Real Betis Futsal Real Betis. 30 123 56 66
3 Atlético Mengíbar FS Atlético 30 109 65 62
4 Manzanares FS Manzanares 30 94 80 56
5 Barça Atlétic Barça 30 110 74 54
6 ElPozo Ciudad de Murcia ElPozo 30 111 73 53
7 Córdoba Patrimonio Córdoba 30 110 104 48
8 Santiago Futsal Santiago 30 99 88 45
9 Rivas Futsal Rivas Futsal 30 93 104 37
10 Noia Portus Apostoli Noia Portus 30 102 106 35
11 Bisontes Castellón FS Bisontes 30 66 98 33
12 Elche CF Sala Elche Sala 30 75 99 33
13 Full Energía Zaragoza Full 30 110 124 32
14 Soliss FS Talavera Soliss 30 93 129 29
15 Gran Canaria Gran Canaria 30 86 104 29
16 CD Salesianos Tenerife Salesianos 30 41 166 4
TEMPORADA 2017/2018
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 30 137 64 71
2 Barça Barça 30 149 66 70
3 ElPozo Murcia Costa Cálida ElPozo 30 131 70 68
4 Jaén FS Jaén FS 30 119 69 64
5 Osasuna Magna Osasuna 30 123 88 62
6 Palma Futsal Palma Futsal 30 94 77 46
7 Sala 10 Zaragoza Sala 30 96 110 45
8 Ribera Navarra FS Ribera 30 80 91 40
9 Jimbee Cartagena Jimbee 30 107 111 39
10 Levante UD FS Levante 30 104 111 31
11 Naturpellet Segovia Naturpellet 30 94 142 31
12 Industrias Santa Coloma Industrias 30 90 108 29
13 Peñíscola FS Peñíscola 30 67 92 26
14 O Parrulo Ferrol Parrulo 30 80 116 24
15 Santiago Futsal Santiago 30 84 121 19
16 Gran Canaria Gran Canaria 30 66 185 10
TEMPORADA 2016/2017
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 30 151 59 75
2 ElPozo Murcia Costa Cálida ElPozo 30 148 61 71
3 Barça Barça 30 135 70 70
4 Jaén FS Jaén FS 30 103 72 53
5 Palma Futsal Palma Futsal 30 106 72 51
6 Osasuna Magna Osasuna 30 96 73 51
7 Peñíscola FS Peñíscola 30 105 94 48
8 Industrias Santa Coloma Industrias 30 106 104 40
9 Ribera Navarra FS Ribera 30 70 85 34
10 Sala 10 Zaragoza Sala 30 94 119 32
11 Santiago Futsal Santiago 30 89 118 31
12 Levante UD FS Levante 30 82 110 30
13 Gran Canaria Gran Canaria 30 85 130 30
14 Jimbee Cartagena Jimbee 30 80 115 26
15 Burela FS Burela FS 30 88 132 25
16 Jumilla B. Carchelo Jumilla 30 69 193 9
TEMPORADA 2015/2016
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 30 158 57 83
2 Barça Barça 30 157 78 74
3 ElPozo Murcia Costa Cálida ElPozo 30 130 81 63
4 Palma Futsal Palma Futsal 30 107 80 57
5 Ribera Navarra FS Ribera 30 91 75 52
6 Osasuna Magna Osasuna 30 111 85 48
7 Industrias Santa Coloma Industrias 30 129 125 44
8 Peñíscola FS Peñíscola 30 117 116 41
9 Burela FS Burela FS 30 92 108 40
10 Santiago Futsal Santiago 30 99 117 31
11 Sala 10 Zaragoza Sala 30 109 125 31
12 Jaén FS Jaén FS 30 86 111 28
13 Levante UD FS Levante 30 72 128 23
14 Jumilla B. Carchelo Jumilla 30 85 135 21
15 Elche CF Sala Elche Sala 30 75 156 17
16 CD UMA Antequera Antequera 30 97 138 17
TEMPORADA 2014/2015
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 30 152 60 79
2 Barça Barça 30 149 67 74
3 ElPozo Murcia Costa Cálida ElPozo 30 152 71 73
4 Jaén FS Jaén FS 30 113 79 54
5 Palma Futsal Palma Futsal 30 122 105 53
6 Osasuna Magna Osasuna 30 115 98 52
7 Ribera Navarra FS Ribera 30 101 91 51
8 Peñíscola FS Peñíscola 30 116 93 47
9 Burela FS Burela FS 30 97 100 37
10 Sala 10 Zaragoza Sala 30 105 119 36
11 Industrias Santa Coloma Industrias 30 140 134 32
12 Santiago Futsal Santiago 30 80 103 32
13 Jumilla B. Carchelo Jumilla 30 119 135 28
14 Levante UD FS Levante 30 75 124 26
15 Uruguay Tenerife Uruguay 30 72 205 9
16 Prone Lugo FS Prone Lugo 30 59 183 5
TEMPORADA 2013/2014
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 28 148 58 76
2 ElPozo Murcia Costa Cálida ElPozo 28 139 69 68
3 Barça Barça 28 115 46 68
4 Industrias Santa Coloma Industrias 28 115 98 50
5 Osasuna Magna Osasuna 28 92 95 44
6 Jumilla B. Carchelo Jumilla 28 90 92 41
7 Ribera Navarra FS Ribera 28 74 80 39
8 Santiago Futsal Santiago 28 76 79 37
9 Burela FS Burela FS 28 71 77 37
10 Jaén FS Jaén FS 28 59 83 27
11 Palma Futsal Palma Futsal 28 87 117 26
12 Peñíscola FS Peñíscola 28 57 90 25
13 Sala 10 Zaragoza Sala 28 74 108 23
14 Prone Lugo FS Prone Lugo 28 70 108 22
15 C. A Gran Canaria Gran Canaria 28 64 131 11
TEMPORADA 2012/2013
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Barça Barça 26 133 45 67
2 ElPozo Murcia Costa Cálida ElPozo 26 117 62 59
3 Inter FS Inter FS 26 103 50 57
4 Naturpellet Segovia Naturpellet 26 103 79 53
5 Sala 10 Zaragoza Sala 26 83 75 47
6 Osasuna Magna Osasuna 26 91 82 45
7 Santiago Futsal Santiago 26 85 71 43
8 Ribera Navarra FS Ribera 26 88 96 36
9 Industrias Santa Coloma Industrias 26 110 123 32
10 Palma Futsal Palma Futsal 26 64 81 21
11 Prone Lugo FS Prone Lugo 26 75 115 21
12 Burela FS Burela FS 26 48 87 19
13 FSD Puertollano Puertollano 26 37 116 11
14 C. A Gran Canaria Gran Canaria 26 54 109 8
TEMPORADA 2011/2012
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 ElPozo Murcia Costa Cálida ElPozo 30 153 69 79
2 Barça Barça 30 149 65 74
3 Inter FS Inter FS 30 123 61 64
4 Naturpellet Segovia Naturpellet 30 98 81 49
5 Santiago Futsal Santiago 30 85 75 47
6 Carnicer Torrejón Carnicer 30 101 95 45
7 Osasuna Magna Osasuna 30 92 100 45
8 Sala 10 Zaragoza Sala 30 95 96 43
9 FSD Puertollano Puertollano 30 88 98 39
10 Palma Futsal Palma Futsal 30 98 108 37
11 Talavera Talavera 30 83 112 36
12 Ribera Navarra FS Ribera 30 84 106 33
13 Prone Lugo FS Prone Lugo 30 93 125 29
14 Industrias Santa Coloma Industrias 30 71 106 28
15 FS Cartagena Cartagena 30 80 142 24
16 Benicarló Aeroport Castelló Benicarló 30 41 95 11
TEMPORADA 2010/2011
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Barça Barça 30 127 63 70
2 ElPozo Murcia Costa Cálida ElPozo 30 138 90 65
3 Inter FS Inter FS 30 111 75 61
4 Santiago Futsal Santiago 30 133 94 59
5 Palma Futsal Palma Futsal 30 107 87 56
6 Benicarló Aeroport Castelló Benicarló 32 87 80 50
7 Naturpellet Segovia Naturpellet 30 104 95 48
8 Osasuna Magna Osasuna 30 100 96 42
9 Sala 10 Zaragoza Sala 30 93 91 40
10 Carnicer Torrejón Carnicer 30 95 101 35
11 Prone Lugo FS Prone Lugo 30 98 105 35
12 Talavera Talavera 30 78 96 35
13 FS Cartagena Cartagena 30 102 116 34
14 Industrias Santa Coloma Industrias 32 85 107 30
15 Playas de Castellón FS Playas 30 59 108 28
16 Gestesa Guadalajara Gestesa 30 55 168 3
TEMPORADA 2009/2010
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 ElPozo Murcia Costa Cálida ElPozo 30 143 84 72
2 Inter FS Inter FS 30 103 68 64
3 Naturpellet Segovia Naturpellet 30 112 77 61
4 Santiago Futsal Santiago 30 120 86 60
5 Barça Barça 30 97 57 57
6 Industrias Santa Coloma Industrias 30 106 107 43
7 Osasuna Magna Osasuna 30 94 92 42
8 Carnicer Torrejón Carnicer 30 117 124 40
9 Prone Lugo FS Prone Lugo 30 92 113 40
10 Gestesa Guadalajara Gestesa 30 106 119 38
11 Playas de Castellón FS Playas 30 61 84 33
12 Sala 10 Zaragoza Sala 30 93 103 32
13 FS Cartagena Cartagena 30 103 120 32
14 Benicarló Aeroport Castelló Benicarló 30 70 90 23
15 Arcebansa Chint Zamora Arcebansa 30 92 122 22
16 Punctum Millenium Pinto Punctum 30 67 130 15

  USO DE MEMORIA  
6,813,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5238
Total Execution Time  0.5250
  CADENA URL  
/historico/Lobelle-Santiago-F-S
  GET DATOS  
$_GET['/historico/Lobelle-Santiago-F-S']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0224  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 = 64296
0.0118  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 = 67784
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4149 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4149 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0111  SELECT /*35 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 (510616,539629,572187,604298,665978) ORDER BY n.cover_points DESC, update_date DESC
0.0111  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 = '4149' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0111  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 = '4149' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0111  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 = 64296 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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 = 67784 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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 = 63772 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  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=4149 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (67784,64296,63772,61574) 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.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 61574 AND teamId = 4149
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 63772 AND teamId = 4149
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 64296 AND teamId = 4149
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 67784 AND teamId = 4149
0.0116  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 63772 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0114  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 = '4149' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4149' and rp.type = 4
0.0113  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 = '4149' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0105  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '4149' and rp.type = 4
0.0107  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 events2022 e ON e.player_id = p.id AND e.league_id = 63772 WHERE rp.league_id = 63772 AND rp.teamId = 4149 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.0107  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 events2022 e ON e.player_id = p.id AND e.league_id = 63772 WHERE rp.league_id = 63772 AND rp.teamId = 4149 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0106  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 events2022 e ON e.player_id = p.id AND e.league_id = 63772 WHERE rp.league_id = 63772 AND rp.teamId = 4149 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109  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 = 4149 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0109  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 = 58755 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 61574 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 50516 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.0109  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 = 44362 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 39112 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 33893 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 16598 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 4455 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 3019 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 = 1935 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123  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 = 1527 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122  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 = 1159 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123  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 = 923 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC