4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Swinoujscie
TEMPORADA 2023/2024
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Świt Skolwin Świt 27 54 12 64
2 TKP Elana Torun Elana Torun 27 41 17 54
3 Unia Swarzędz Unia 28 51 39 50
4 Stargard Szczeciński Stargard 28 65 49 49
5 Zawisza Bydgoszcz Zawisza 28 59 32 48
6 Pogoń Szczecin II Pogoń 28 59 51 44
7 Polonia Środa Polonia 28 47 45 44
8 Vineta Wolin Vineta Wolin 27 33 41 43
9 Nowe Skalmierzyce Nowe 28 45 44 40
10 Cartusia Kartuzy Cartusia 27 51 36 39
11 Notec Czarnków Notec 27 56 50 38
12 Gedania Gdansk Gedania 28 45 47 38
13 Sokół Kleczew Sokół 27 42 49 33
14 Swinoujscie Swinoujscie 27 34 51 32
15 Stolem Gniewino Stolem 27 30 46 29
16 Unia Solec Kujawski Unia Solec. 27 32 62 21
17 KTSK Luzino KTSK Luzino 28 37 67 20
18 Starogard Gdański Starogard 27 33 76 13
TEMPORADA 2020/2021
CUARTA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Radunia Stężyca Radunia 35 115 24 87
2 Świt Skolwin Świt 35 75 28 81
3 Polonia Środa Polonia 35 76 31 76
4 Starogard Gdański Starogard 35 48 46 61
5 Kotwica Kołobrzeg Kotwica 34 59 40 58
6 Sokół Kleczew Sokół 34 63 45 57
7 TKP Elana Torun Elana Torun 35 59 33 56
8 Unia Janikowo Unia 34 54 53 54
9 Jarota Jarocin Jarota 34 68 49 49
10 Bałtyk Koszalin Bałtyk 34 63 56 48
11 Nielba Wagrowiec Nielba 34 74 59 47
12 Swinoujscie Swinoujscie 34 48 55 47
13 Bałtyk Gdynia Bałtyk 35 43 52 47
14 Pomorzanin Toruń Pomorzanin 34 39 40 43
15 Unia Swarzędz Unia 34 51 44 41
16 Przodkowo Przodkowo 35 42 66 40
17 Gwardia Koszalin Gwardia 34 42 52 40
18 Pogoń Szczecin II Pogoń 35 61 68 39
19 Gryf Wejherowo Gryf 34 45 64 36
20 Górnik Konin Górnik 34 32 76 26
21 Chemik Police Chemik 34 28 96 18
22 Mieszko Gniezno Mieszko 34 15 123 4
TEMPORADA 2014/2015
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Zaglebie Lubin Zaglebie 34 57 20 77
2 Termalica Nieciecza Termalica 34 60 26 73
3 Wisła Płock Wisła 34 50 25 69
4 Olimpia Grudziadz Olimpia 34 46 37 53
5 Chojniczanka Chojnice Chojniczanka 34 50 37 50
6 Dolcan Zabki Dolcan Zabki 34 43 39 50
7 Stomil Olsztyn Stomil 34 47 47 49
8 GKS Katowice Katowice 34 44 41 48
9 Wigry Suwalki Wigry 34 36 37 47
10 Arka Gdynia Arka Gdynia 34 38 39 43
11 Chrobry Głogów Chrobry 34 41 45 41
12 Miedz Legnica Miedz 34 44 45 40
13 Bytovia Bytow Bytovia 34 39 45 40
14 Swinoujscie Swinoujscie 34 26 46 36
15 Sandecja Nowy Sacz Sandecja 34 40 55 35
16 Pogon Siedlce Pogon 34 34 53 30
17 GKS Tychy GKS Tychy 34 31 56 28
18 Widzew Łódź Widzew 34 25 58 22
TEMPORADA 2013/2014
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 GKS Bełchatów Bełchatów 34 50 27 63
2 Górnik Łęczna Górnik 34 45 27 61
3 Dolcan Zabki Dolcan Zabki 34 60 39 55
4 Arka Gdynia Arka Gdynia 34 53 40 54
5 Termalica Nieciecza Termalica 34 42 33 53
6 Olimpia Grudziadz Olimpia 34 38 39 53
7 Wisła Płock Wisła 34 37 33 52
8 GKS Katowice Katowice 34 44 45 46
9 Miedz Legnica Miedz 34 42 37 44
10 Kolejarz Stroze Kolejarz 34 36 38 44
11 Sandecja Nowy Sacz Sandecja 34 29 40 44
12 Swinoujscie Swinoujscie 34 29 34 42
13 Chojniczanka Chojnice Chojniczanka 34 35 33 41
14 Stomil Olsztyn Stomil 34 38 42 41
15 GKS Tychy GKS Tychy 34 39 48 41
16 Energetyk ROW Rybnik Energetyk 34 42 52 33
17 Puszcza Niepolomice Puszcza 34 37 56 33
18 Brzesko Brzesko 34 18 51 23
TEMPORADA 2012/2013
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Zawisza Bydgoszcz Zawisza 34 69 26 66
2 KS Cracovia KS Cracovia 34 48 35 64
3 Termalica Nieciecza Termalica 34 54 28 63
4 Swinoujscie Swinoujscie 34 57 33 63
5 Arka Gdynia Arka Gdynia 34 46 29 57
6 GKS Tychy GKS Tychy 34 44 28 55
7 Dolcan Zabki Dolcan Zabki 34 52 41 54
8 Miedz Legnica Miedz 34 49 42 53
9 Olimpia Grudziadz Olimpia 34 39 34 51
10 GKS Katowice Katowice 34 43 36 50
11 Kolejarz Stroze Kolejarz 34 47 45 50
12 Górnik Łęczna Górnik 34 37 42 46
13 Stomil Olsztyn Stomil 34 37 45 38
14 Sandecja Nowy Sacz Sandecja 34 35 54 37
15 Brzesko Brzesko 34 38 54 32
16 Warta Poznan Warta Poznan 34 34 57 28
17 TS Polonia Bytom Polonia 34 29 64 22
18 LKS Lódz LKS Lódz 34 17 82 14
TEMPORADA 2011/2012
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Piast Gliwice Piast 34 57 40 64
2 Pogon Szczecin Pogon 34 54 30 61
3 Zawisza Bydgoszcz Zawisza 34 47 39 59
4 Kolejarz Stroze Kolejarz 34 40 34 57
5 Termalica Nieciecza Termalica 34 42 26 56
6 Górnik Łęczna Górnik 34 50 37 54
7 Arka Gdynia Arka Gdynia 34 50 41 51
8 Swinoujscie Swinoujscie 34 46 43 49
9 Ruch Radzionków Ruch 34 46 51 48
10 Warta Poznan Warta Poznan 34 44 36 46
11 Olimpia Grudziadz Olimpia 34 46 41 43
12 Sandecja Nowy Sacz Sandecja 34 42 46 40
13 GKS Katowice Katowice 34 33 38 39
14 Dolcan Zabki Dolcan Zabki 34 40 53 39
15 TS Polonia Bytom Polonia 34 37 51 36
16 Wisła Płock Wisła 34 39 50 35
17 Gornik Polkowice Gornik 34 40 64 30
18 Olimpia Elblag Olimpia 34 33 66 22
TEMPORADA 2010/2011
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 LKS Lódz LKS Lódz 34 59 34 71
2 Podbeskidzie Podbeskidzie 34 53 23 69
3 Swinoujscie Swinoujscie 34 58 34 66
4 Sandecja Nowy Sacz Sandecja 34 52 34 56
5 Piast Gliwice Piast 34 45 31 52
6 Pogon Szczecin Pogon 34 55 42 51
7 Górnik Łęczna Górnik 34 44 39 50
8 Warta Poznan Warta Poznan 34 44 43 50
9 Ruch Radzionków Ruch 34 34 32 46
10 Gornik Polkowice Gornik 34 31 39 42
11 GKS Katowice Katowice 34 47 57 41
12 Kolejarz Stroze Kolejarz 34 30 43 38
13 Dolcan Zabki Dolcan Zabki 34 33 39 37
14 Termalica Nieciecza Termalica 34 40 53 37
15 Kluczbork Kluczbork 34 36 44 36
16 KSZO Ostrowiec KSZO 34 32 43 36
17 Odra Wodzislaw Slaski Odra 34 29 58 32
18 Warta Gorzów Warta 34 28 62 29
TEMPORADA 2009/2010
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Widzew Łódź Widzew 34 62 17 77
2 Górnik Zabrze Górnik 34 47 30 61
3 Sandecja Nowy Sacz Sandecja 34 55 42 59
4 LKS Lódz LKS Lódz 34 51 45 55
5 Pogon Szczecin Pogon 34 46 35 51
6 Kluczbork Kluczbork 34 43 37 46
7 Swinoujscie Swinoujscie 34 33 36 46
8 KSZO Ostrowiec KSZO 34 37 46 46
9 Warta Gorzów Warta 34 34 33 45
10 Podbeskidzie Podbeskidzie 34 45 38 44
11 Warta Poznan Warta Poznan 34 49 45 44
12 Górnik Łęczna Górnik 34 38 45 44
13 GKS Katowice Katowice 34 41 41 43
14 Dolcan Zabki Dolcan Zabki 34 37 43 42
15 Wisła Płock Wisła 34 43 51 40
16 Znicz Pruszkow Znicz 34 32 48 39
17 Stal Stalowa Wola Stal Stalowa 34 32 58 25
18 Motor Lublin Motor Lublin 34 27 62 23
TEMPORADA 2008/2009
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Widzew Łódź Widzew 34 55 23 72
2 Zaglebie Lubin Zaglebie 34 68 33 69
3 Korona Kielce Korona 34 51 37 61
4 Podbeskidzie Podbeskidzie 34 58 29 59
5 Górnik Łęczna Górnik 34 49 36 57
6 Znicz Pruszkow Znicz 34 42 29 55
7 Swinoujscie Swinoujscie 34 43 37 53
8 Dolcan Zabki Dolcan Zabki 34 35 31 49
9 Wisła Płock Wisła 34 45 41 47
10 Warta Poznan Warta Poznan 34 44 45 46
11 GKS Katowice Katowice 34 37 42 44
12 Stal Stalowa Wola Stal Stalowa 34 33 34 43
13 Jastrzębie Jastrzębie 34 37 48 41
14 Warta Gorzów Warta 34 39 54 36
15 Motor Lublin Motor Lublin 34 21 36 32
16 Tur Turek Tur Turek 34 29 56 30
17 Odra Opole Odra Opole 34 22 51 25
18 Kmita Zabierzów Kmita 34 11 57 21
TEMPORADA 2007/2008
TERCERA POLONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Swinoujscie Swinoujscie 30 49 22 68
2 Unia Janikowo Unia 30 51 22 60
3 Nielba Wagrowiec Nielba 30 58 30 55
4 Jarota Jarocin Jarota 30 55 27 53
5 Kotwica Kołobrzeg Kotwica 30 46 29 53
6 Victoria Koronowo Victoria 30 54 33 47
7 TKP Elana Torun Elana Torun 30 32 26 46
8 Chemik Police Chemik 30 36 40 34
9 Kaszubia Kościerzyna Kaszubia 30 32 46 34
10 Wierzyca Pelplin Wierzyca 30 39 52 32
11 Rodlo Kwidzyn Rodlo 30 33 47 32
12 Mieszko Gniezno Mieszko 30 30 39 31
13 Kujawiak Włocławek Kujawiak 30 24 52 28
14 Rega Trzebiatów Rega 30 26 46 27
15 Zdrój Ciechocinek Zdrój 30 22 55 26
16 Cartusia Kartuzy Cartusia 30 27 48 22

  USO DE MEMORIA  
6,327,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5497
Total Execution Time  0.5511
  CADENA URL  
/historico/Flota-Swinoujscie-57811
  GET DATOS  
$_GET['/historico/Flota-Swinoujscie-57811']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0158  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 = 'Flota-Swinoujscie-57811' 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.0145  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=13367 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=13367 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=13367 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13367 AND type_rel = 2
0.0149  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 = '13367' ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '13367' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '13367' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 72657 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=13367 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (72657,71432) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 72657 AND teamId = 13367
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13367
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 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 = 72657 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '13367' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13367' and rp.type = 4
0.0147  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 = '13367' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0161  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 = 72657 WHERE rp.league_id = 72657 AND rp.teamId = 13367 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.0158  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 = 72657 WHERE rp.league_id = 72657 AND rp.teamId = 13367 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 72657 WHERE rp.league_id = 72657 AND rp.teamId = 13367 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 13367 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72657 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.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 `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 = 57485 AND t.round = 35 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 `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 = 3876 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 2863 AND t.round = 34 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 = 8850 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 8848 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 8845 AND t.round = 34 ORDER BY team.conference 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 `tables2008` 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 = 25017 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC