4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Noia Portus Apostoli
TEMPORADA 2023/2024
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Barça Barça 28 94 76 57
2 ElPozo Murcia Costa Cálida ElPozo 28 105 70 55
3 Jaén FS Jaén FS 28 89 66 51
4 Inter FS Inter FS 28 105 71 50
5 Jimbee Cartagena Jimbee 28 88 73 48
6 Palma Futsal Palma Futsal 28 101 91 47
7 Manzanares FS Manzanares 28 101 95 45
8 Viña Albali Valdepeñas Viña Albali 28 94 84 42
9 Industrias Santa Coloma Industrias 28 96 94 41
10 Córdoba Patrimonio Córdoba 28 80 93 34
11 Peñíscola FS Peñíscola 28 104 100 32
12 Osasuna Magna Osasuna 28 71 90 31
13 Noia Portus Apostoli Noia Portus 28 92 106 27
14 Ribera Navarra FS Ribera 28 73 90 24
15 Real Betis Futsal Real Betis. 28 73 122 24
16 Alzira FS Alzira FS 28 58 103 20
TEMPORADA 2022/2023
PRIMERA DIVISIÓN FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Palma Futsal Palma Futsal 30 120 81 65
2 Barça Barça 30 120 77 64
3 Jimbee Cartagena Jimbee 30 105 83 61
4 Jaén FS Jaén FS 30 110 68 60
5 ElPozo Murcia Costa Cálida ElPozo 30 92 70 52
6 Inter FS Inter FS 30 106 88 52
7 Viña Albali Valdepeñas Viña Albali 30 97 96 45
8 Noia Portus Apostoli Noia Portus 30 84 93 38
9 Industrias Santa Coloma Industrias 30 87 94 35
10 Manzanares FS Manzanares 30 80 98 34
11 Ribera Navarra FS Ribera 30 78 101 30
12 Real Betis Futsal Real Betis. 30 84 104 29
13 Córdoba Patrimonio Córdoba 30 87 111 29
14 Osasuna Magna Osasuna 30 59 82 29
15 CD UMA Antequera Antequera 30 74 100 29
16 Levante UD FS Levante 30 74 111 23
TEMPORADA 2021/2022
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Noia Portus Apostoli Noia Portus 34 149 69 82
2 Peñíscola FS Peñíscola 34 122 82 64
3 CD UMA Antequera Antequera 34 123 100 62
4 Alzira FS Alzira FS 34 99 93 57
5 Atletico Benavente FS Atletico 34 152 146 54
6 Barça Atlétic Barça 34 148 120 52
7 Inagroup El Ejido Inagroup 34 95 87 52
8 Union África Ceutí Union 34 100 102 50
9 Full Energía Zaragoza Full 34 111 128 46
10 O Parrulo Ferrol Parrulo 34 106 119 45
11 Bisontes Castellón FS Bisontes 34 88 104 45
12 Real Betis Futsal B Real Betis. 34 122 118 44
13 CD Leganes FS Leganes 34 107 109 44
14 Atlético Mengíbar FS Atlético 34 109 115 42
15 Soliss FS Talavera Soliss 34 95 104 42
16 ETB Calvia - Palma Futsal Calvia Palma 34 112 126 35
17 Ciudad de Móstoles Ciudad 34 93 129 32
18 Club Inter Movistar FS Club Inter. 34 76 156 15
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Inagroup El Ejido Inagroup 16 69 61 31
2 Barça Atlétic Barça 16 58 46 27
3 Manzanares FS Manzanares 16 43 36 25
4 Atlético Mengíbar FS Atlético 16 47 44 23
5 Full Energía Zaragoza Full 16 68 54 22
6 Bisontes Castellón FS Bisontes 16 43 47 20
7 Alzira FS Alzira FS 16 41 49 19
8 Elche CF Sala Elche Sala 16 49 68 16
9 ElPozo Ciudad de Murcia ElPozo 16 36 49 13
10 Noia Portus Apostoli Noia Portus 14 49 30 34
11 Union África Ceutí Union 14 52 34 27
12 Atletico Benavente FS Atletico 14 46 40 20
13 Soliss FS Talavera Soliss 14 34 34 20
14 Ciudad de Móstoles Ciudad 14 44 44 18
15 CD Leganes FS Leganes 14 40 42 16
16 Rivas Futsal Rivas Futsal 14 29 44 14
17 Santiago Futsal Santiago 14 22 48 7
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
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 ElPozo Ciudad de Murcia ElPozo 30 131 84 61
2 Barça Atlétic Barça 30 122 70 60
3 Viña Albali Valdepeñas Viña Albali 30 114 72 60
4 Burela FS Burela FS 30 102 63 55
5 CD UMA Antequera Antequera 30 106 80 51
6 FSD Puertollano Puertollano 30 118 94 51
7 Real Betis Futsal Real Betis. 30 108 88 51
8 Rivas Futsal Rivas Futsal 30 110 91 48
9 Córdoba Patrimonio Córdoba 30 112 108 47
10 Bisontes Castellón FS Bisontes 30 82 99 40
11 Manzanares FS Manzanares 30 83 103 39
12 Atlético Mengíbar FS Atlético 30 81 90 38
13 Elche CF Sala Elche Sala 30 84 102 33
14 Noia Portus Apostoli Noia Portus 30 64 123 22
15 Prone Lugo FS Prone Lugo 30 64 125 18
16 Tenerife Iberia Toscal Tenerife 30 60 149 6
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN B FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Guardo Guardo 25 122 69 60
2 FS Zamora Futsal Zamora 25 81 59 51
3 FS Cuellar Cojalba Futsal Cuellar 25 95 51 50
4 Univ. de Valladolid Univ. 25 120 82 46
5 Albense Albense 25 86 75 36
6 Noia Portus Apostoli Noia Portus 13 49 19 33
7 Atletico Benavente FS Atletico 25 85 98 32
8 Pizarras Los Tres Cuñados Pizarras 14 49 57 14
9 O Esteo O Esteo 13 42 53 13
10 FS San Jose FS San Jose 25 83 150 12
11 Boal Belleza Boal Belleza 14 43 63 11
12 Leis Pontevedra Leis 14 28 53 11
13 SD Xove SD Xove 14 36 69 10
14 UV Ventorrillo Ventorrillo 13 37 58 7
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN B FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Univ. de Valladolid Univ. 29 123 73 62
2 FS Cuellar Cojalba Futsal Cuellar 29 130 84 60
3 Albense Albense 29 85 82 38
4 Guardo Guardo 29 116 116 36
5 Atletico Benavente FS Atletico 29 102 124 33
6 Noia Portus Apostoli Noia Portus 11 38 21 30
7 Cistierna Cistierna 29 118 140 29
8 UV Ventorrillo Ventorrillo 11 48 42 19
9 Boal Belleza Boal Belleza 11 47 43 18
10 SD Xove SD Xove 11 56 44 17
11 Cd Mosteiro Bembrive Futsal Mosteiro 12 42 39 15
12 Leis Pontevedra Leis 12 40 50 15
13 Pizarras Los Tres Cuñados Pizarras 11 48 51 14
14 Sala Ourense 2014 Sala Ourense 11 38 63 9
15 Ad Fs Bueu Futsal Bueu Futsal 12 37 75 7
16 O Esteo O Esteo 12 28 49 6
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN B FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Cd Mosteiro Bembrive Futsal Mosteiro 22 110 59 49
2 Cidade De Narón Cidade 22 98 51 47
3 Univ. de Valladolid Univ. 22 89 60 47
4 Noia Portus Apostoli Noia Portus 22 88 64 44
5 Pizarras Los Tres Cuñados Pizarras 22 74 76 33
6 Guardo Guardo 22 80 81 32
7 Cistierna Cistierna 22 70 84 31
8 Albense Albense 22 53 74 30
9 FS Cuellar Cojalba Futsal Cuellar 22 68 62 29
10 O Esteo O Esteo 22 58 88 18
11 Leis Pontevedra Leis 22 49 79 14
12 UV Ventorrillo Ventorrillo 22 44 103 4
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN B FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Noia Portus Apostoli Noia Portus 26 119 66 65
2 O Parrulo Ferrol Parrulo 26 136 88 57
3 Cidade De Narón Cidade 26 106 62 51
4 Univ. de Valladolid Univ. 26 115 68 50
5 Cd Albense Futsal Albense 26 108 85 49
6 Bembibre Cong. Almar Futsal Bembibre 26 90 83 45
7 FS Zamora Futsal Zamora 26 124 94 44
8 Pizarras Los Tres Cuñados Pizarras 26 86 104 38
9 Amigos De Soto Fs Futsal Amigos Soto 26 93 111 27
10 Puertas Deyma Fs Puertas 26 49 65 25
11 Santiago Futsal B Santiago 26 85 101 24
12 Prone Lugo FS Prone Lugo 26 91 123 22
13 Cd Hl Rueda Futsal Rueda Futsal 26 82 158 22
14 Automocion Junquera Futsal Automocion 26 22 98 10
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN B FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Univ. de Valladolid Univ. 30 157 77 69
2 O Parrulo Ferrol Parrulo 30 124 96 61
3 Puertas Deyma Fs Puertas 30 109 73 56
4 Cidade De Narón Cidade 30 113 91 56
5 Noia Portus Apostoli Noia Portus 30 142 99 55
6 Cistierna Cistierna 30 115 91 50
7 Cd Albense Futsal Albense 30 102 111 45
8 Automocion Junquera Futsal Automocion 30 89 107 42
9 FS Zamora Futsal Zamora 30 116 107 40
10 Amigos De Soto Fs Futsal Amigos Soto 30 116 132 40
11 Lobelle B Futsal Lobelle 30 97 99 39
12 Coruxo Fc Futsal Coruxo 30 81 104 39
13 Mera Fs Futsal Mera Futsal 30 105 124 32
14 Dpto. Santa Maria Futsal Dpto. Santa 30 94 107 27
15 Area 10 Azkar B Futsal Area Azkar. 30 94 121 27
16 Pazo Tizon Carballiño Pazo Tizon. 30 58 173 5
TEMPORADA 2009/2010
SEGUNDA DIVISIÓN B FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 O Parrulo Ferrol Parrulo 26 160 74 70
2 Pazo Tizon Carballiño Pazo Tizon. 25 132 74 58
3 Mera FS Mera FS 26 128 86 57
4 Cidade Naron Cidade Naron 26 112 75 48
5 Noia Portus Apostoli Noia Portus 25 117 95 47
6 Puertas Deyma Puertas 26 88 82 40
7 Santiago FS Santiago FS 26 100 102 38
8 Rececende Rececende 25 79 92 30
9 M. Caloto M. Caloto 26 86 97 29
10 Coruxo Fc Futsal Coruxo 27 96 127 27
11 Hnos. Barbeito Hnos. 25 100 157 26
12 Leis Leis 25 92 104 24
13 Prone Lugo FS Prone Lugo 24 98 121 24
14 Torre Reyes Torre Reyes 25 89 137 17
15 Cistierna Cistierna 25 67 121 13
16 Descansa Descansa 0 0 0 0

  USO DE MEMORIA  
6,538,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5713
Total Execution Time  0.5734
  CADENA URL  
/historico/Noia-Fs-Futsal
  GET DATOS  
$_GET['/historico/Noia-Fs-Futsal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
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 = 'Noia-Fs-Futsal' 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.0128  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=7970 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=7970 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=7970 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7970 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7970 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (527744,588140,588711,607392,757444) ORDER BY n.cover_points DESC, update_date DESC
0.0133  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 = '7970' ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = '7970' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '7970' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=7970 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (74080,73234) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73234 AND teamId = 7970
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 74080 AND teamId = 7970
0.0127  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 = '7970' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7970' and rp.type = 4
0.0127  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 = '7970' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0129  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 = 73234 WHERE rp.league_id = 73234 AND rp.teamId = 7970 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.0127  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 = 73234 WHERE rp.league_id = 73234 AND rp.teamId = 7970 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 73234 WHERE rp.league_id = 73234 AND rp.teamId = 7970 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 7970 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0134  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 = 73234 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.0130  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 = 68486 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.0131  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 = 63428 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.0128  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 = 61573 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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.0129  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.0130  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.0130  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 = 39113 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 36789 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 16952 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 4609 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 2201 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 1790 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 926 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC