4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del NK Croatia Sesvete
TEMPORADA 2011/2012
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Dugopolje Dugopolje 28 50 27 57
2 Pomorac Pomorac 28 63 30 56
3 Mosor Mosor 28 36 16 52
4 Vinogradar Vinogradar 28 47 32 50
5 Imotski Imotski 28 26 21 42
6 NK Rudes NK Rudes 28 42 33 41
7 HNK Gorica HNK Gorica 28 27 24 40
8 Hrvatski Dragovoljac Hrvatski 28 36 37 40
9 NK Sesvete NK Sesvete 28 34 31 39
10 Junak Sinj Junak Sinj 28 29 27 39
11 NK Solin NK Solin 28 35 45 35
12 Marsonia Marsonia 28 25 50 30
13 Medjimurje Cakovec Medjimurje 28 31 60 22
14 NK HASK Zagreb HASK Zagreb 28 33 52 21
15 NK Croatia Sesvete Croatia 28 23 52 15
TEMPORADA 2010/2011
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 HNK Gorica HNK Gorica 30 54 21 64
2 Lučko Lučko 30 54 28 59
3 Pomorac Pomorac 30 50 23 56
4 NK Rudes NK Rudes 30 52 39 52
5 Imotski Imotski 30 35 32 48
6 NK Solin NK Solin 30 35 33 45
7 Medjimurje Cakovec Medjimurje 30 53 49 42
8 NK Dugopolje Dugopolje 30 39 30 41
9 Junak Sinj Junak Sinj 30 40 34 40
10 Vinogradar Vinogradar 30 43 38 40
11 NK Croatia Sesvete Croatia 30 37 41 40
12 Croatia Slavonski Croatia 30 42 42 39
13 NK HASK Zagreb HASK Zagreb 30 40 42 38
14 Mosor Mosor 30 32 41 34
15 Vukovar '91 Vukovar '91 30 21 83 20
16 Suhopolje Suhopolje 30 22 73 17
TEMPORADA 2009/2010
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 30 70 20 62
2 HNK Hajduk Split Hajduk Split 30 50 21 58
3 HNK Cibalia HNK Cibalia 30 46 20 57
4 HNK Sibenik HNK Sibenik 30 34 37 50
5 NK Osijek NK Osijek 30 49 36 47
6 NK Karlovac 1919 Karlovac 30 32 23 47
7 NK Slaven Belupo Slaven 30 44 45 43
8 Lokomotiva Lokomotiva 30 35 38 42
9 HNK Rijeka HNK Rijeka 30 49 44 40
10 NK Varazdin NK Varazdin 30 36 43 36
11 NK Istra 1961 Istra 1961 30 31 40 35
12 Zadar Zadar 30 27 41 34
13 NK Zagreb NK Zagreb 30 43 49 33
14 Inter Zapresic Inter 30 36 50 33
15 Medjimurje Cakovec Medjimurje 30 37 61 29
16 NK Croatia Sesvete Croatia 30 30 81 14
TEMPORADA 2008/2009
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 33 71 26 74
2 HNK Hajduk Split Hajduk Split 33 59 25 68
3 HNK Rijeka HNK Rijeka 33 50 44 56
4 NK Slaven Belupo Slaven 33 46 39 55
5 NK Zagreb NK Zagreb 33 38 39 47
6 HNK Sibenik HNK Sibenik 33 44 35 46
7 NK Osijek NK Osijek 33 40 41 41
8 HNK Cibalia HNK Cibalia 33 33 53 38
9 Inter Zapresic Inter 33 41 50 36
10 NK Varazdin NK Varazdin 33 41 55 35
11 Zadar Zadar 33 28 49 29
12 NK Croatia Sesvete Croatia 33 31 66 25
TEMPORADA 2007/2008
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Hrvatski Dragovoljac Hrvatski 30 60 28 64
2 NK Croatia Sesvete Croatia 29 65 25 63
3 NK Istra 1961 Istra 1961 30 42 14 58
4 Pomorac Pomorac 29 42 26 49
5 Vinogradar Vinogradar 30 42 43 44
6 Slavonac Slavonac 30 44 51 44
7 Segesta Segesta 30 39 37 43
8 Trogir Trogir 30 40 37 42
9 Moslavina Moslavina 30 51 42 41
10 Imotski Imotski 30 49 53 40
11 Mosor Mosor 30 27 42 38
12 NK Solin NK Solin 30 46 48 37
13 Marsonia Marsonia 30 34 58 31
14 Kamen Ingrad Velika Kamen Ingrad 30 26 49 28
15 Vukovar '91 Vukovar '91 29 29 51 24
16 Belisce Belisce 29 21 53 13
TEMPORADA 2006/2007
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Inter Zapresic Inter 30 60 28 68
2 Zadar Zadar 30 55 25 65
3 NK Croatia Sesvete Croatia 30 67 38 59
4 Hrvatski Dragovoljac Hrvatski 30 60 25 58
5 NK Solin NK Solin 30 58 33 53
6 Imotski Imotski 30 41 44 44
7 Belisce Belisce 30 46 40 42
8 Pomorac Pomorac 30 53 51 42
9 Vukovar '91 Vukovar '91 30 40 42 35
10 NK HASK Zagreb HASK Zagreb 30 44 49 35
11 Mosor Mosor 30 37 46 35
12 Marsonia Marsonia 30 38 50 34
13 Moslavina Moslavina 29 40 56 30
14 NK Koprivnica Koprivnica 30 42 66 29
15 Bjelovar Bjelovar 29 24 62 18
16 NK Cakovec NK Cakovec 30 37 87 16
TEMPORADA 2004/2005
PRIMERA CROACIA 1. NL GRUPO 2
Equipo PJ GF GC Puntos
1 Hrvatski Dragovoljac Hrvatski 22 45 26 43
2 Novalja Novalja 22 33 19 38
3 NK Solin NK Solin 22 41 39 38
4 HNK Sibenik HNK Sibenik 22 30 16 37
5 Mosor Mosor 22 38 25 37
6 Segesta Segesta 22 38 26 35
7 Pomorac Pomorac 22 30 29 31
8 Naftas Ivanic Naftas 22 29 40 24
9 Imotski Imotski 22 23 36 23
10 NK Croatia Sesvete Croatia 22 27 38 21
11 GOŠK DBK GOŠK DBK 22 17 41 20
12 NK Uskok Klis Uskok Klis 22 18 34 15
TEMPORADA 2003/2004
PRIMERA CROACIA 1. NL GRUPO 2
Equipo PJ GF GC Puntos
1 NK Istra 1961 Istra 1961 22 38 19 43
2 NK Solin NK Solin 22 39 25 39
3 Pomorac Pomorac 22 36 26 39
4 HNK Sibenik HNK Sibenik 22 36 28 37
5 Segesta Segesta 22 32 27 36
6 Novalja Novalja 22 29 25 34
7 NK Uskok Klis Uskok Klis 22 35 33 34
8 Imotski Imotski 22 28 33 25
9 Hrvatski Dragovoljac Hrvatski 22 20 26 25
10 NK Croatia Sesvete Croatia 22 29 38 24
11 GOŠK DBK GOŠK DBK 22 20 38 20
12 HNK Orijent Rijeka Orijent 22 15 39 8
TEMPORADA 2002/2003
PRIMERA CROACIA 1. NL GRUPO 2
Equipo PJ GF GC Puntos
1 Uljanik Uljanik 22 45 20 49
2 Inter Zapresic Inter 22 53 22 46
3 NK Solin NK Solin 22 30 26 33
4 NK Uskok Klis Uskok Klis 22 27 27 32
5 NK Croatia Sesvete Croatia 22 28 32 31
6 Hrvatski Dragovoljac Hrvatski 22 33 35 29
7 GOŠK DBK GOŠK DBK 22 26 29 29
8 Imotski Imotski 22 22 25 27
9 Novalja Novalja 22 22 26 27
10 NK Istra 1961 Istra 1961 22 29 34 27
11 HNK Orijent Rijeka Orijent 22 23 36 22
12 Topolovac Topolovac 22 16 42 15
TEMPORADA 2001/2002
PRIMERA CROACIA 1. NL GRUPO 2
Equipo PJ GF GC Puntos
1 NK Istra 1961 Istra 1961 30 46 21 59
2 Uljanik Uljanik 29 52 26 56
3 Novalja Novalja 30 30 18 50
4 NK Uskok Klis Uskok Klis 30 48 32 49
5 NK Solin NK Solin 30 44 24 48
6 HNK Orijent Rijeka Orijent 30 36 37 46
7 NK Croatia Sesvete Croatia 29 31 29 42
8 Inter Zapresic Inter 30 46 40 41
9 GOŠK DBK GOŠK DBK 30 26 37 41
10 Imotski Imotski 30 36 40 40
11 Mosor Mosor 30 38 50 37
12 Zminj Zminj 29 25 41 36
13 Segesta Segesta 30 28 33 35
14 Samobor Samobor 30 31 40 31
15 NK Trnje NK Trnje 30 30 43 26
16 Vrbovec Vrbovec 29 23 59 23
TEMPORADA 2000/2001
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Kamen Ingrad Velika Kamen Ingrad 34 78 32 74
2 Pomorac Pomorac 34 80 30 70
3 NK Croatia Sesvete Croatia 34 61 33 65
4 Zadar Zadar 34 38 30 61
5 Topolovac Topolovac 34 74 54 59
6 Belisce Belisce 34 48 35 55
7 NK Solin NK Solin 34 45 46 53
8 Mosor Mosor 34 43 41 50
9 Vrbovec Vrbovec 34 51 57 48
10 HNK Orijent Rijeka Orijent 34 40 40 47
11 Segesta Segesta 34 37 46 46
12 Vukovar '91 Vukovar '91 34 54 58 44
13 Bjelovar Bjelovar 34 43 52 44
14 NK Istra 1961 Istra 1961 34 44 45 40
15 NK Koprivnica Koprivnica 34 41 63 33
16 Zminj Zminj 34 35 66 30
17 Imotski Imotski 34 28 57 25
18 NK Jadran LP Jadran 34 22 77 13
TEMPORADA 1999/2000
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Marsonia Marsonia 32 52 18 64
2 NK Cakovec NK Cakovec 32 63 38 63
3 Zadar Zadar 31 46 24 61
4 Pomorac Pomorac 32 49 26 60
5 Mosor Mosor 32 55 26 59
6 Segesta Segesta 32 58 29 56
7 Vrbovec Vrbovec 32 57 39 55
8 NK Solin NK Solin 31 52 41 50
9 HNK Orijent Rijeka Orijent 32 37 41 41
10 Belisce Belisce 32 42 43 39
11 NK Jadran LP Jadran 31 35 53 35
12 NK Croatia Sesvete Croatia 32 38 48 34
13 Bjelovar Bjelovar 32 38 49 32
14 Cazmatrans Cazmatrans 32 33 50 29
15 Split Split 32 29 68 26
16 Zagorec Zagorec 31 24 61 22
17 NK Otok NK Otok 32 28 82 22
TEMPORADA 1998/1999
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Vukovar '91 Vukovar '91 20 30 12 41
2 Belisce Belisce 20 43 26 39
3 Zagorec Zagorec 20 29 26 36
4 NK Cakovec NK Cakovec 20 31 18 35
5 Segesta Segesta 19 29 17 33
6 NK Istra 1961 Istra 1961 20 27 17 33
7 Buducnost Orehovica Buducnost 20 32 28 33
8 Split Split 20 30 16 32
9 NK Otok NK Otok 20 29 27 30
10 NK Jadran LP Jadran 20 34 25 29
11 Bjelovar Bjelovar 20 20 18 29
12 Imotski Imotski 20 24 31 23
13 HNK Đakovo Croatia Đakovo 19 22 20 22
14 NK Solin NK Solin 20 22 26 22
15 HNK Orijent Rijeka Orijent 20 21 33 22
16 NK Croatia Sesvete Croatia 20 24 33 21
17 Samobor Samobor 20 20 33 20
18 Posavina Posavina 20 15 37 11
19 Inter Zapresic Inter 20 13 52 9

  USO DE MEMORIA  
6,368,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.4618
Total Execution Time  0.4633
  CADENA URL  
/historico/Nk-Croatia-Sesvete
  GET DATOS  
$_GET['/historico/Nk-Croatia-Sesvete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1802 AND type_rel = 2
0.0134  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 = '1802' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = '1802' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 8705 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=1802 AND l.year in (2011,2012,2013) 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 (8706) 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 = 8706 AND teamId = 1802
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 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 = 8705 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0135  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 = '1802' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1802' and rp.type = 4
0.0131  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 = '1802' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0142  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 events2012 e ON e.player_id = p.id AND e.league_id = 8705 WHERE rp.league_id = 8705 AND rp.teamId = 1802 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.0140  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 events2012 e ON e.player_id = p.id AND e.league_id = 8705 WHERE rp.league_id = 8705 AND rp.teamId = 1802 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 events2012 e ON e.player_id = p.id AND e.league_id = 8705 WHERE rp.league_id = 8705 AND rp.teamId = 1802 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 1802 AND l.year <= 2012 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 8705 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 `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 = 8706 AND t.round = 30 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 `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 = 875 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 `tables2009` 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 = 458 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 8709 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 `tables2007` 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 = 8710 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 8716 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 8720 AND t.round = 22 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 `tables2003` 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 = 8725 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 `tables2002` 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 = 8729 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 `tables2000` 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 = 8736 AND t.round = 34 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 `tables1999` 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 = 8738 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC