4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Slavonija
TEMPORADA 2023/2024
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 Čepin Čepin 15 26 13 31
2 HNK Đakovo Croatia Đakovo 15 36 24 31
3 Tomislav Donji Andrijevci Tomislav 15 31 16 27
4 Bedem Bedem 15 25 15 26
5 NK Svačić NK Svačić 15 20 11 26
6 Slavonija Slavonija 15 25 18 26
7 NK Borac NK Borac 15 17 19 24
8 Valpovka Valpovka 15 30 24 23
9 NAŠK NAŠK 15 25 26 23
10 Oriolik Oriolik 15 16 17 21
11 Sloga NG Sloga NG 15 23 23 17
12 Vuteks Sloga Vuteks Sloga 15 21 23 17
13 Pleternica Pleternica 15 19 29 15
14 Kutjevo Kutjevo 15 19 35 15
15 NK Tomislav Cerna Tomislav 15 21 29 11
16 Graničar Županja Graničar 15 8 40 5
TEMPORADA 2022/2023
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 Slavonija Slavonija 30 65 36 59
2 Graničar Županja Graničar 30 56 26 58
3 NAŠK NAŠK 30 42 28 52
4 Kutjevo Kutjevo 30 60 51 49
5 Čepin Čepin 30 54 40 47
6 NK Borac NK Borac 30 41 38 44
7 Pleternica Pleternica 30 40 52 43
8 Oriolik Oriolik 30 42 48 42
9 Vuteks Sloga Vuteks Sloga 30 49 61 41
10 NK Svačić NK Svačić 30 53 52 40
11 Bedem Bedem 30 47 55 38
12 Sloga NG Sloga NG 30 42 63 38
13 Valpovka Valpovka 30 52 45 36
14 HNK Đakovo Croatia Đakovo 30 51 52 34
15 Darda Darda 30 58 69 30
16 Gornja Vrba Gornja Vrba 30 22 58 24
TEMPORADA 2021/2022
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 Vukovar '91 Vukovar '91 34 80 20 82
2 Zrinski Osječko Zrinski 34 69 33 78
3 Belisce Belisce 34 95 28 75
4 Marsonia Marsonia 34 61 25 70
5 Slavonija Slavonija 34 60 38 61
6 HNK Đakovo Croatia Đakovo 34 60 38 59
7 Bedem Bedem 34 53 52 47
8 Pleternica Pleternica 34 57 68 45
9 Kutjevo Kutjevo 34 59 62 43
10 Graničar Županja Graničar 34 43 52 40
11 Sloga NG Sloga NG 34 46 71 39
12 Oriolik Oriolik 34 43 71 38
13 Čepin Čepin 34 46 64 34
14 Darda Darda 34 44 71 32
15 Vuteks Sloga Vuteks Sloga 34 52 81 31
16 NAŠK NAŠK 34 38 63 30
17 Gornja Vrba Gornja Vrba 34 35 63 30
18 NK Slavonac Bukovlje Slavonac 34 36 77 25
TEMPORADA 2020/2021
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 Vukovar '91 Vukovar '91 33 67 12 72
2 Belisce Belisce 33 68 22 72
3 Marsonia Marsonia 33 60 29 62
4 HNK Đakovo Croatia Đakovo 33 63 40 56
5 Slavonija Slavonija 33 76 47 52
6 Graničar Županja Graničar 33 52 40 51
7 Čepin Čepin 33 38 31 49
8 Zrinski Osječko Zrinski 33 48 46 49
9 Oriolik Oriolik 33 48 44 48
10 Vuteks Sloga Vuteks Sloga 33 46 65 40
11 Bedem Bedem 33 38 55 39
12 Vihor Vihor 33 50 60 38
13 Kutjevo Kutjevo 33 47 59 37
14 Pleternica Pleternica 33 39 63 36
15 Sloga NG Sloga NG 33 43 68 34
16 NAŠK NAŠK 33 39 81 33
17 NK Slavonac Bukovlje Slavonac 33 29 61 32
18 Valpovka Valpovka 33 33 61 31
TEMPORADA 2019/2020
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 Marsonia Marsonia 17 31 13 38
2 Belisce Belisce 17 42 18 35
3 Čepin Čepin 17 29 19 30
4 HNK Đakovo Croatia Đakovo 17 24 16 28
5 Kutjevo Kutjevo 17 32 27 28
6 Bedem Bedem 17 35 22 27
7 Slavonija Slavonija 17 30 18 27
8 Graničar Županja Graničar 17 29 24 27
9 NAŠK NAŠK 17 25 27 24
10 Zrinski Osječko Zrinski 17 19 22 24
11 Oriolik Oriolik 17 25 35 22
12 Pleternica Pleternica 17 28 28 20
13 Vuteks Sloga Vuteks Sloga 17 20 36 18
14 Vihor Vihor 17 21 30 16
15 Vukovar '91 Vukovar '91 17 10 31 8
16 Sloga NG Sloga NG 17 16 50 7
TEMPORADA 2018/2019
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 HNK Cibalia HNK Cibalia 30 67 24 68
2 Vihor Vihor 30 44 29 54
3 Čepin Čepin 30 52 30 51
4 Belisce Belisce 30 53 39 48
5 Mladost Ždralovi Mladost 30 49 38 46
6 Slavonija Slavonija 30 45 42 42
7 Marsonia Marsonia 30 38 40 42
8 Zrinski Osječko Zrinski 30 35 35 41
9 Bedem Bedem 30 39 41 40
10 Oriolik Oriolik 30 46 50 40
11 HNK Đakovo Croatia Đakovo 30 44 51 40
12 Pleternica Pleternica 30 40 44 39
13 Bjelovar Bjelovar 30 49 56 35
14 Vukovar '91 Vukovar '91 30 29 52 31
15 Sloga NG Sloga NG 30 34 64 28
16 NK Koprivnica Koprivnica 30 37 66 22
TEMPORADA 2017/2018
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 NK Osijek II Osijek 30 54 19 66
2 Medjimurje Cakovec Medjimurje 30 61 35 56
3 Bijelo Brdo Bijelo Brdo 30 46 29 56
4 Marsonia Marsonia 30 48 37 53
5 NK Koprivnica Koprivnica 30 54 40 51
6 Čepin Čepin 30 42 31 46
7 Bedem Bedem 30 50 46 43
8 Pleternica Pleternica 30 43 38 41
9 Mladost Ždralovi Mladost 30 40 39 41
10 Bjelovar Bjelovar 30 32 40 37
11 Oriolik Oriolik 30 25 35 33
12 Vukovar '91 Vukovar '91 30 31 45 31
13 Slavonija Slavonija 30 38 57 31
14 Belisce Belisce 30 28 58 29
15 HNK Đakovo Croatia Đakovo 30 25 43 28
16 Varteks Varteks 30 27 52 26
TEMPORADA 2016/2017
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Medjimurje Cakovec Medjimurje 30 58 26 64
2 NK Varazdin NK Varazdin 30 53 27 60
3 Bedem Bedem 30 53 38 53
4 NK Osijek II Osijek 30 58 34 52
5 Marsonia Marsonia 30 41 31 49
6 Slavonija Slavonija 30 47 44 47
7 Bijelo Brdo Bijelo Brdo 30 58 43 46
8 Mladost Ždralovi Mladost 30 28 35 43
9 Pleternica Pleternica 30 46 35 41
10 Bjelovar Bjelovar 30 45 48 40
11 Oriolik Oriolik 30 32 34 38
12 Vukovar '91 Vukovar '91 30 38 51 35
13 HNK Đakovo Croatia Đakovo 30 34 52 35
14 Belisce Belisce 30 38 43 30
15 NK Koprivnica Koprivnica 30 29 49 29
16 Višnjevac Višnjevac 30 18 86 12
TEMPORADA 2015/2016
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Medjimurje Cakovec Medjimurje 30 62 15 66
2 Bjelovar Bjelovar 30 61 29 57
3 Pleternica Pleternica 30 49 35 57
4 Belisce Belisce 30 58 30 54
5 Marsonia Marsonia 30 42 24 54
6 Bijelo Brdo Bijelo Brdo 30 56 40 52
7 Mladost Ždralovi Mladost 30 47 37 52
8 Slavonija Slavonija 30 59 51 43
9 Vukovar '91 Vukovar '91 30 48 50 42
10 Oriolik Oriolik 30 29 38 37
11 NK Varazdin NK Varazdin 30 40 47 34
12 HNK Đakovo Croatia Đakovo 30 34 48 34
13 NK Koprivnica Koprivnica 30 43 56 33
14 Višnjevac Višnjevac 30 46 56 32
15 Podravina Podravina 30 36 74 21
16 Mladost Antin Mladost 30 19 99 5
TEMPORADA 2014/2015
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Pleternica Pleternica 30 62 18 63
2 NK Koprivnica Koprivnica 30 58 27 54
3 Medjimurje Cakovec Medjimurje 30 56 29 54
4 Mladost Ždralovi Mladost 30 49 33 54
5 Mladost Antin Mladost 30 43 25 52
6 Slavonija Slavonija 30 47 43 46
7 Belisce Belisce 30 53 45 43
8 Višnjevac Višnjevac 30 33 37 43
9 HNK Đakovo Croatia Đakovo 30 45 43 42
10 Vukovar '91 Vukovar '91 30 50 47 41
11 NK Varazdin NK Varazdin 30 42 39 39
12 Bjelovar Bjelovar 30 35 42 37
13 Bijelo Brdo Bijelo Brdo 30 46 55 36
14 Podravina Podravina 30 33 49 32
15 Oriolik Oriolik 30 25 53 25
16 Virovitica Virovitica 30 18 110 2
TEMPORADA 2013/2014
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Bijelo Brdo Bijelo Brdo 28 46 23 58
2 Slavonija Slavonija 28 48 23 52
3 Pleternica Pleternica 28 52 32 51
4 Mladost Antin Mladost 28 41 28 51
5 HNK Đakovo Croatia Đakovo 28 36 31 47
6 Vukovar '91 Vukovar '91 28 52 47 41
7 Oriolik Oriolik 28 55 38 40
8 Višnjevac Višnjevac 28 39 36 40
9 Belisce Belisce 28 46 36 38
10 Marsonia Marsonia 28 35 44 36
11 NAŠK NAŠK 28 36 47 35
12 Bedem Bedem 28 38 47 31
13 NK Lipik NK Lipik 15 28 20 29
14 Graničar Županja Graničar 28 33 48 27
15 Croatia Slavonski Croatia 28 35 66 21
16 NK Otok NK Otok 29 27 81 20
TEMPORADA 2012/2013
TERCERA CROACIA 3. NL GRUPO 4
Equipo PJ GF GC Puntos
1 Slavonija Slavonija 30 77 34 64
2 Bijelo Brdo Bijelo Brdo 30 71 42 53
3 Pleternica Pleternica 30 45 32 49
4 Mladost Antin Mladost 30 46 44 48
5 Bedem Bedem 30 32 36 46
6 Višnjevac Višnjevac 30 46 41 44
7 Graničar Županja Graničar 30 40 39 43
8 Oriolik Oriolik 30 38 42 41
9 NAŠK NAŠK 30 34 32 40
10 HNK Đakovo Croatia Đakovo 30 51 53 38
11 NK Otok NK Otok 30 44 67 38
12 Marsonia Marsonia 30 47 52 37
13 NK Olimpija Osijek Olimpija 30 52 64 37
14 NK Lipik NK Lipik 30 46 62 37
15 Belisce Belisce 30 26 44 37
16 NK Mladost Cernik Mladost 30 45 56 33
TEMPORADA 2005/2006
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Belisce Belisce 22 41 14 48
2 Graficar Osijek Graficar 22 38 21 39
3 Bjelovar Bjelovar 22 25 26 37
4 Vukovar '91 Vukovar '91 22 36 21 35
5 NK Koprivnica Koprivnica 22 34 23 35
6 Metalac Osijek Metalac 22 28 16 33
7 Marsonia Marsonia 22 25 30 31
8 NK Cakovec NK Cakovec 22 33 40 28
9 Graničar Županja Graničar 22 28 28 25
10 Dilj Dilj 22 28 44 24
11 Slavonija Slavonija 22 30 42 22
12 Mladost Molve Mladost 22 23 64 9
TEMPORADA 2004/2005
PRIMERA CROACIA 1. NL GRUPO 1
Equipo PJ GF GC Puntos
1 HNK Cibalia HNK Cibalia 22 43 13 48
2 NK Cakovec NK Cakovec 22 36 25 39
3 Belisce Belisce 22 40 28 34
4 Marsonia Marsonia 22 29 24 34
5 Metalac Osijek Metalac 22 34 25 33
6 Dilj Dilj 22 23 26 32
7 Slavonija Slavonija 22 26 34 31
8 NK Koprivnica Koprivnica 22 30 33 29
9 Bjelovar Bjelovar 22 36 36 27
10 Vukovar '91 Vukovar '91 22 23 30 26
11 Graficar Osijek Graficar 22 28 44 17
12 Valpovka Valpovka 22 15 45 17
TEMPORADA 2003/2004
PRIMERA CROACIA 1. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Medjimurje Cakovec Medjimurje 22 53 19 51
2 Belisce Belisce 22 50 19 46
3 Vukovar '91 Vukovar '91 22 36 29 41
4 Graficar Osijek Graficar 22 37 28 32
5 Slavonija Slavonija 22 34 33 31
6 Metalac Osijek Metalac 22 40 36 30
7 Virovitica Virovitica 22 31 29 30
8 NK Cakovec NK Cakovec 22 31 44 26
9 NK Koprivnica Koprivnica 22 33 45 24
10 Dilj Dilj 22 38 50 23
11 Valpovka Valpovka 22 23 56 17
12 Sloga NG Sloga NG 22 13 31 15

  USO DE MEMORIA  
6,572,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6947
Total Execution Time  0.6959
  CADENA URL  
/historico/Slavonija-Pozega
  GET DATOS  
$_GET['/historico/Slavonija-Pozega']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0156  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 = 'Slavonija-Pozega' 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=25077 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=25077 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292  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 = 73585
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25077 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1565 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1565 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  SELECT /*53 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 (1083629,808269,786438,401208,400630) ORDER BY n.cover_points DESC, update_date DESC
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 = '25077' 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 = '25077' 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 = 73585 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=25077 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 (73585,72000) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 73585 AND teamId = 25077
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 72000 AND teamId = 25077
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 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 = 73585 AND t.round = 15 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 = '25077' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25077' 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 = '25077' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 73585 WHERE rp.league_id = 73585 AND rp.teamId = 25077 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.0146  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 = 73585 WHERE rp.league_id = 73585 AND rp.teamId = 25077 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 73585 WHERE rp.league_id = 73585 AND rp.teamId = 25077 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 = 25077 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73585 AND t.round = 15 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 = 68852 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.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 `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 = 64042 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.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 = 58550 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.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 `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 = 51149 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.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 `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 = 44725 AND t.round = 30 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 `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 = 39731 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 `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 = 34136 AND t.round = 30 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 `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 = 15852 AND t.round = 30 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 `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 = 9293 AND t.round = 30 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 `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 = 24835 AND t.round = 29 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 = 24826 AND t.round = 30 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 `tables2006` 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 = 8711 AND t.round = 22 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 `tables2005` 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 = 8715 AND t.round = 22 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 `tables2004` 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 = 8719 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC