4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tartu Welco
TEMPORADA 2023/2024
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Harju JK Laagri Harju Laagri 8 20 6 18
2 FC Flora Tallin II Flora Tallin 7 15 9 15
3 FC Tallinn FC Tallinn 8 16 13 14
4 Tartu Welco Tartu Welco 7 14 5 13
5 Viimsi JK Viimsi JK 8 16 10 13
6 Levadia Tallinn II Levadia 8 15 12 10
7 FC Elva FC Elva 8 9 16 9
8 Tallinna Kalev II Tallinna 7 11 17 6
9 Paide II Paide II 8 4 20 4
10 Tabasalu Charma Tabasalu 7 6 18 2
TEMPORADA 2022/2023
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 Tartu Welco Tartu Welco 36 92 42 74
2 Tallinna Kalev II Tallinna 36 99 53 67
3 Trans II Trans II 36 69 48 64
4 Tartu Kalev Tartu Kalev 36 85 71 61
5 Kuressaare II Kuressaare 36 87 76 61
6 Tulevik Viljandi Tulevik 36 58 55 55
7 Tammeka II Tammeka II 36 63 70 44
8 Nõmme Kalju II Nõmme Kalju 36 90 103 41
9 Läänemaa Haapsalu Läänemaa 36 67 120 26
10 Pärnu Jalgpalliklubi Pärnu 36 34 106 14
TEMPORADA 2021/2022
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 FC Tallinn FC Tallinn 36 117 38 81
2 Tabasalu Charma Tabasalu 36 120 50 79
3 Tallinna Kalev II Tallinna 36 88 49 66
4 Tartu Welco Tartu Welco 36 73 46 64
5 Tammeka II Tammeka II 36 70 59 56
6 TJK Legion II Legion 36 60 86 42
7 Tartu Kalev Tartu Kalev 36 54 77 41
8 Läänemaa Haapsalu Läänemaa 36 49 84 37
9 Nõmme Kalju II Nõmme Kalju 36 49 103 33
10 Raplamaa Raplamaa 36 33 121 9
TEMPORADA 2020/2021
SEGUNDA ESTONIA GRUPO 3
Equipo PJ GF GC Puntos
1 Levadia Tallinn II Levadia 3 7 5 35
2 Pärnu Jalgpalliklubi Pärnu 3 5 4 29
3 Tammeka II Tammeka II 3 4 7 27
4 Tartu Welco Tartu Welco 3 4 4 19
TEMPORADA 2019/2020
SEGUNDA B ESTONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Paide II Paide II 2 8 2 68
2 Tartu Welco Tartu Welco 2 8 7 62
3 Tallinna Kalev II Tallinna 2 4 13 55
4 Tabasalu Charma Tabasalu 2 5 3 51
TEMPORADA 2018/2019
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 TJK Legion TJK Legion 36 129 35 94
2 FC Flora Tallin II Flora Tallin 36 85 37 73
3 Vaprus Pärnu Vaprus 36 73 48 67
4 Tammeka II Tammeka II 36 59 55 58
5 FC Elva FC Elva 36 67 63 56
6 Levadia Tallinn II Levadia 36 80 65 53
7 Alliance FC Alliance FC 36 51 82 40
8 Rakvere JK Tarvas Rakvere 36 35 98 28
9 Tallinna Kalev II Tallinna 36 38 84 25
10 Tartu Welco Tartu Welco 36 39 89 24
TEMPORADA 2017/2018
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Maardu FC Maardu FC 36 126 38 88
2 FC Flora Tallin II Flora Tallin 36 115 31 71
3 Levadia Tallinn II Levadia 36 67 56 61
4 FC Elva FC Elva 36 51 64 55
5 Rakvere JK Tarvas Rakvere 36 59 60 52
6 Tartu Welco Tartu Welco 36 44 78 42
7 Tartu FC Santos Tartu Santos 36 47 68 41
8 Tallinna Kalev II Tallinna 36 37 52 39
9 Keila Keila 36 41 88 35
10 Nõmme Kalju II Nõmme Kalju 36 37 89 21
TEMPORADA 2016/2017
SEGUNDA ESTONIA
Equipo PJ GF GC Puntos
1 Maardu FC Maardu FC 36 92 44 78
2 Tallinna Kalev Tallinna 36 95 44 74
3 FC Flora Tallin II Flora Tallin 36 79 42 70
4 Rakvere JK Tarvas Rakvere 36 66 61 62
5 Kuressaare Kuressaare 36 70 63 55
6 Levadia Tallinn II Levadia 36 56 60 45
7 Tartu FC Santos Tartu Santos 36 75 74 43
8 Tallinna Infonet II Tallinna 36 60 85 43
9 FC Elva FC Elva 36 40 90 29
10 Tartu Welco Tartu Welco 36 30 100 19
TEMPORADA 2015/2016
SEGUNDA B ESTONIA
Equipo PJ GF GC Puntos
1 Kuressaare Kuressaare 36 117 48 74
2 FC Elva FC Elva 36 67 39 68
3 Tartu Welco Tartu Welco 36 74 50 64
4 Tammeka II Tammeka II 36 89 64 59
5 Tallinna Kalev II Tallinna 36 72 53 55
6 Sillamäe Kalev II Sillamäe 36 70 61 54
7 Joker Joker 36 74 66 52
8 Viimsi JK Viimsi JK 36 56 64 51
9 FC Flora Tallin III Flora Tallin 36 27 85 20
10 Tulevik II Tulevik II 36 26 142 12
TEMPORADA 2014/2015
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Paide II Paide II 26 81 41 61
2 Tartu Welco Tartu Welco 26 64 36 56
3 Johvi FC Lokomotiv Johvi 26 69 38 54
4 Luunja Luunja 26 76 42 53
5 Visadus Visadus 26 80 55 51
6 Tabasalu Charma Tabasalu 26 57 67 37
7 Võru Võru 26 56 57 36
8 JK Piraaja JK Piraaja 26 42 53 33
9 Tallinna Dünamo Tallinna 26 42 52 30
10 Jogeva SK Noorus 96 Jogeva 26 53 75 27
11 Kuusalu JK Rada Kuusalu Rada 26 45 67 23
12 Levadia III Levadia III 26 48 61 19
13 Ajax Lasnamäe Ajax 26 42 69 18
14 TJK Legion TJK Legion 26 42 84 17
TEMPORADA 2013/2014
TERCERA ESTONIA GRUPO 2
Equipo PJ GF GC Puntos
1 Paide II Paide II 26 81 28 62
2 Joker Joker 26 76 31 55
3 Tartu Welco Tartu Welco 26 49 31 51
4 Luunja Luunja 26 70 42 44
5 Tallinna Dünamo Tallinna 26 51 45 40
6 Ganvix Ganvix 26 78 67 38
7 Võru Võru 26 49 46 37
8 Ajax Lasnamäe Ajax 26 62 52 35
9 Jogeva SK Noorus 96 Jogeva 26 68 65 33
10 TJK Legion II Legion 26 49 78 32
11 Levadia III Levadia III 26 63 51 31
12 Visadus Visadus 26 43 65 29
13 Kaitseliit Kalev Kaitseliit 26 57 76 23
14 JK Loo JK Loo 26 28 147 7
TEMPORADA 2012/2013
TERCERA ESTONIA GRUPO 1
Equipo PJ GF GC Puntos
1 Tartu FC Santos Tartu Santos 26 138 16 73
2 Ganvix Ganvix 26 57 60 48
3 Sörve Sörve 26 64 46 47
4 Nõmme United Nõmme 26 90 60 46
5 Jogeva SK Noorus 96 Jogeva 26 63 61 46
6 Rummu Dünamo Rummu 26 66 56 40
7 Keila Keila 26 67 48 39
8 Luunja Luunja 26 61 61 39
9 Tartu SK 10 Premium II Tartu 26 53 75 35
10 Tulevik II Tulevik II 26 62 74 28
11 Tartu Welco Tartu Welco 26 39 59 26
12 FC Metropool Metropool 26 41 88 25
13 Tarvastu Tarvastu 26 45 95 19
14 Kärdla LM Kärdla LM 26 35 82 15

  USO DE MEMORIA  
5,918,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7066
Total Execution Time  0.7085
  CADENA URL  
/historico/Welco-Elekter
  GET DATOS  
$_GET['/historico/Welco-Elekter']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
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 = 'Welco-Elekter' 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=61423 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=61423 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=61423 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=61423 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61423 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=368 AND type_rel = 3
0.0153  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 = '61423' ORDER BY l.year DESC,cat.coefficient DESC
0.0160  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 = '61423' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0160  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 = '61423' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 75170 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155  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=61423 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (75170,71963,71432,70894) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 75170 AND teamId = 61423
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 70894 AND teamId = 61423
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 71963 AND teamId = 61423
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61423
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 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 = 75170 AND t.round = 8 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 = '61423' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61423' and rp.type = 4
0.0146  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 = '61423' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0155  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 = 75170 WHERE rp.league_id = 75170 AND rp.teamId = 61423 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.0152  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 = 75170 WHERE rp.league_id = 75170 AND rp.teamId = 61423 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 75170 WHERE rp.league_id = 75170 AND rp.teamId = 61423 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 61423 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0147  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 = 75170 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.0147  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 = 70894 AND t.round = 36 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 `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 = 66759 AND t.round = 36 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 `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 = 61475 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 65707 AND t.round = 3 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 = 55084 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 60008 AND t.round = 2 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 `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 = 48713 AND t.round = 36 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 `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 = 42546 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 37788 AND t.round = 36 ORDER BY team.conference 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 `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 = 20883 AND t.round = 36 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 `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 = 11805 AND t.round = 26 ORDER BY team.conference 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 `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 = 9436 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 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 = 27884 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC