4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Rubí FS Rubí FS 24 90 44 54
2 AD Teldeportivo Teldeportivo 23 79 27 53
3 AE Penya Esplugues Penya 24 86 51 48
4 Bisontes Castellón Bisontes 22 58 54 40
5 CN Caldes CN Caldes 23 67 54 38
6 AECS L'Hospitalet AECS 24 63 60 38
7 Intersala Zaragoza Intersala 23 63 41 37
8 UDC Txantrea KKE Txantrea 23 45 51 36
9 Osasuna Futsal Osasuna 23 38 33 35
10 FS Ripollet FS Ripollet 23 52 62 29
11 FSF César Augusta César 23 46 59 25
12 CET 10 CET 10 23 32 54 22
13 AD Sala Zaragoza Sala 23 48 78 19
14 Club Deportivo Orvina Club 22 39 63 16
15 CFS Eixample Eixample 23 27 102 1
16 FS Castelldefels Castelldefel 0 0 0 0
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 AE Les Corts Corts 26 114 34 66
2 AE Penya Esplugues Penya 26 124 42 60
3 CN Caldes CN Caldes 26 101 39 55
4 CFS Eixample Eixample 26 96 59 50
5 Rubí FS Rubí FS 26 104 63 46
6 Intersala Zaragoza Intersala 26 98 64 45
7 FS Ripollet FS Ripollet 26 100 63 42
8 Bisontes Castellón Bisontes 26 73 45 42
9 AECS L'Hospitalet AECS 26 95 85 34
10 FSF César Augusta César 26 87 79 33
11 FS Castelldefels Castelldefel 26 58 85 29
12 CD La Concordia Concordia 26 30 87 14
13 Peña Deportiva Peña 26 25 147 4
14 AD Sala Zaragoza B Sala 26 27 240 0
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Bisontes Castellón Bisontes 30 116 41 79
2 CN Caldes CN Caldes 30 88 38 69
3 CFS Eixample Eixample 30 117 43 66
4 AE Les Corts Corts 30 110 67 63
5 Intersala Zaragoza Intersala 30 86 55 58
6 FSF César Augusta César 30 114 69 57
7 CD La Concordia Concordia 30 90 67 48
8 FS Castelldefels Castelldefel 30 92 80 43
9 AE Penya Esplugues B Penya 30 99 83 42
10 AD Sala 10 AD Sala 10 30 75 89 34
11 AECS L'Hospitalet AECS 30 68 106 31
12 FS Ripollet FS Ripollet 30 72 116 25
13 AD Sala Zaragoza B Sala 30 74 141 24
14 FS Sabadell FS Sabadell 30 61 114 22
15 Futsal Mataró Futsal 30 66 122 17
16 CD Santa Ana Santa 30 35 132 6
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 CD La Concordia Concordia 16 67 22 36
2 CFS Eixample Eixample 16 70 19 33
3 FS Castelldefels Castelldefel 16 67 44 29
4 CN Caldes CN Caldes 16 40 32 24
5 AE Penya Esplugues B Penya 16 71 39 23
6 FS Ripollet FS Ripollet 16 58 47 21
7 Futsal Mataró Futsal 16 43 49 19
8 AECS L'Hospitalet AECS 16 41 60 17
9 FS Atlético Mercadal Atlético 16 5 150 0
10 Joventut d'Elx FS Joventut 16 79 21 46
11 Bisontes Castellón Bisontes 16 62 16 38
12 AE Les Corts Corts 16 52 25 30
13 Restaurante La Torre Red St Restaurante 16 44 26 27
14 FSF César Augusta César 16 35 55 21
15 Cervera Segarra Femeni A A Cervera 16 31 53 17
16 Xaloc Alacant B Xaloc 16 29 42 15
17 CEF Hispanic Hispanic 16 21 62 7
18 Intersala Promises B Intersala 16 20 73 5
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 AE Penya Esplugues B Penya 22 78 35 50
2 Intersala Zaragoza Intersala 22 72 43 48
3 Joventut d'Elx FS Joventut 22 62 41 45
4 CN Caldes CN Caldes 22 57 40 41
5 Bisontes Castellón Bisontes 22 57 41 40
6 FS Castelldefels Castelldefel 22 64 51 37
7 CD La Concordia Concordia 22 59 41 36
8 Cervera Segarra Femeni A A Cervera 22 84 67 33
9 FS Ripollet FS Ripollet 22 58 61 33
10 CFS Eixample Eixample 22 61 57 26
11 AECS L'Hospitalet AECS 22 55 59 25
12 CD Almàssera Ruz FS Almàssera 22 57 72 25
13 Futsal Mataró Futsal 22 62 77 24
14 FSF César Augusta César 22 54 64 22
15 Eurogan Red Star's Eurogan 22 40 76 11
16 Futsal Ciutat de Torrent Futsal 22 19 114 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 CD La Concordia Concordia 30 120 50 73
2 Xaloc Alacant Xaloc 30 123 56 69
3 CFS Eixample Eixample 30 106 62 63
4 Joventut d'Elx FS Joventut 30 112 72 60
5 Intersala Zaragoza Intersala 30 95 62 59
6 Cervera Segarra Femeni A A Cervera 30 117 83 54
7 Assessoria Pear Castelldefe Assessoria 30 107 79 53
8 Bisontes Castellón Bisontes 30 72 54 53
9 FS Ripollet FS Ripollet 30 108 97 46
10 Futsal Ciutat de Torrent Futsal 30 93 87 41
11 Spsan Vicente Hercules Spsan 30 89 121 35
12 AECS L'Hospitalet AECS 30 83 116 28
13 Eurogan Red Star's Eurogan 30 64 101 19
14 Fssabadell Femeni A A Fssabadell 30 71 99 19
15 Vallirana AE A Vallirana 30 41 102 9
16 Avenida Alagon Avenida 30 40 200 6
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Femisport Palau Club Femisport 26 105 39 65
2 CD La Concordia Concordia 26 114 52 62
3 Futsal Ciutat de Torrent Futsal 26 116 54 59
4 AD Teldeportivo Teldeportivo 26 124 56 56
5 CFS Eixample Eixample 26 103 47 51
6 Xaloc Alacant Xaloc 26 94 59 41
7 Assessoria Pear Castelldefe Assessoria 26 78 66 39
8 Bisontes Castellón Bisontes 26 42 69 29
9 Spsan Vicente Hercules Spsan 26 76 102 23
10 Cervera Segarra Femeni A A Cervera 26 70 106 23
11 Vallirana AE A Vallirana 26 64 90 22
12 Fssabadell Femeni A A Fssabadell 26 49 92 22
13 AECS L'Hospitalet AECS 26 81 91 21
14 Esparreguera A A Esparreguera 26 22 215 7
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 AD Teldeportivo Teldeportivo 28 112 43 73
2 Femisport Palau Club Femisport 28 102 41 72
3 Futsal Ciutat de Torrent Futsal 28 111 54 59
4 Femesala Elche Femesala 28 83 53 58
5 CFS Eixample Eixample 28 103 68 53
6 Assessoria Pear Castelldefe Assessoria 28 78 71 39
7 Joventut d'Elx FS Joventut 28 76 76 38
8 Vallirana AE A Vallirana 28 62 77 35
9 AECS L'Hospitalet AECS 28 61 73 34
10 Bisontes Castellón Bisontes 28 53 64 33
11 Esparreguera A A Esparreguera 28 54 93 30
12 CD La Concordia Concordia 28 53 76 23
13 San Isidro San Isidro 28 55 83 22
14 Cn Caldes A A Caldes 28 51 88 20
15 Faycan Faycan 28 13 107 3
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 AD Teldeportivo Teldeportivo 24 119 49 56
2 CD San Isidro Isidro 24 92 61 48
3 CD La Concordia Concordia 24 82 52 46
4 Joventut d'Elx FS Joventut 23 75 48 46
5 FS Castelldefels Castelldefel 24 74 73 42
6 Cfs Femeni Centelles Femeni 23 77 48 39
7 Futsal Ciutat de Torrent Futsal 24 88 70 38
8 Vallirana AE A Vallirana 24 53 45 34
9 AE Les Corts Corts 24 57 72 31
10 AECS L'Hospitalet A AECS 24 47 77 23
11 CN Caldes CN Caldes 24 34 101 17
12 Bisontes Castellón Bisontes 24 36 77 16
13 Cd Santa Rosa Santa Rosa 24 46 107 11
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Rubí FS Rubí FS 28 133 36 76
2 Femesala Elche Femesala 28 112 32 76
3 CD San Isidro Isidro 28 135 56 66
4 AD Teldeportivo Teldeportivo 28 93 56 59
5 AE Penya Esplugues Penya 27 94 42 54
6 FS Castelldefels Castelldefel 28 81 84 43
7 AE Les Corts Corts 28 76 94 37
8 AE Vallirana Vallirana 28 68 95 33
9 Club Femenino Castellon Club 28 58 79 30
10 Cfs Femeni Centelles Femeni 28 55 109 29
11 CN Caldes CN Caldes 28 44 81 28
12 AECS L'Hospitalet A AECS 28 63 73 27
13 Cd Santa Rosa Santa Rosa 28 71 99 24
14 Villena FS Villena FS 27 67 110 20
15 Promoven Insular CFS Promoven 28 11 115 6
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Rubí FS Rubí FS 22 90 38 53
2 AE Penya Esplugues Penya 22 86 55 45
3 FS Castelldefels Castelldefel 22 90 76 40
4 San Viator 78 Viator 22 72 60 38
5 AE Les Corts Corts 22 94 79 37
6 Bisontes Castellón Bisontes 22 77 70 36
7 AD Sala 10 AD Sala 10 22 63 65 32
8 Cd Arenys De Munt Arenys Munt 22 77 72 30
9 Intersala Zaragoza Intersala 22 75 69 29
10 Cfs Femeni Centelles Femeni 22 57 92 22
11 AECS L'Hospitalet A AECS 22 38 86 11
12 Caspe - Polideportivo ADA Caspe 22 59 116 8
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Rubí FS Rubí FS 26 136 39 71
2 AE Vallirana Vallirana 26 125 45 70
3 San Viator 78 Viator 26 82 57 50
4 AE Penya Esplugues Penya 26 73 61 42
5 FS Castelldefels Castelldefel 26 84 80 42
6 Intersala Zaragoza Intersala 26 101 65 40
7 AE Les Corts Corts 26 87 69 38
8 Masnou Inter Dinamic Fs Masnou Inter 26 73 68 37
9 AD Sala 10 AD Sala 10 26 70 79 36
10 Bisontes Castellón Bisontes 26 69 74 33
11 Cd Arenys De Munt Arenys Munt 26 60 85 32
12 FS Sabadell FS Sabadell 26 51 78 17
13 Font Dels Enamorats Cn Cald Font Dels E. 26 44 107 13
14 Pony´s Fs Pony´s Fs 26 7 155 3
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Cfs Femeni Centelles Femeni 25 110 41 62
2 AE Vallirana Vallirana 25 114 67 55
3 Cd Santa Rosa Santa Rosa 25 134 71 54
4 AD Teldeportivo Teldeportivo 25 99 56 52
5 Masnou Inter Dinamic Fs Masnou Inter 25 76 39 48
6 FS Castelldefels Castelldefel 25 113 61 47
7 AE Les Corts Corts 25 87 63 41
8 AE Penya Esplugues Penya 25 58 72 30
9 Font Dels Enamorats Cn Cald Font Dels E. 25 77 115 27
10 FS Sabadell FS Sabadell 25 52 76 25
11 San Viator 78 Viator 25 73 107 22
12 Pony´s Fs Pony´s Fs 25 82 123 21
13 Penya Ciutadella Penya 25 59 122 16
14 AD Sala 10 AD Sala 10 25 45 166 4

  USO DE MEMORIA  
6,366,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5690
Total Execution Time  0.5709
  CADENA URL  
/segunda_division_femenino_futsal2024/grupo2/historico
  GET DATOS  
$_GET['/segunda_division_femenino_futsal2024/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0144  SELECT type FROM routes WHERE alias = 'segunda_division_femenino_futsal2024'
0.0291  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_division_femenino_futsal' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0144  SELECT id,name,alias,stepParent FROM categories WHERE parentId=267 ORDER BY order_id ASC
0.0146  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 267 GROUP BY l.categoryId
0.0146  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=267 GROUP BY l.year ORDER BY l.year DESC
0.0146  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73360 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 267 AND group_code = 2 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 73360 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.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 = 68768 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.0155  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 = 63708 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.0156  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 = 58805 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.0148  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 = 50521 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.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 `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 = 44447 AND t.round = 30 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 `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 = 39792 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 35492 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 64965 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 7597 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 65389 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 `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 = 2164 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 1820 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 11:08:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0152  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 11:08:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 11:08:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 11:08:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0161  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_division_femenino_futsal' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0157  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73360 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73360 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0159  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73360 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73360 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0155  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73360 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73360 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0168  SELECT *,(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 = 73360 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