4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1960/1961
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Sevilla At. Sevilla At. 30 74 19 48
2 Melilla CF Melilla CF 30 58 19 43
3 CD Linares CD Linares 30 57 30 40
4 RB Linense RB Linense 30 68 49 35
5 Peñarroya Peñarroya 30 57 50 33
6 Algeciras CF Algeciras 30 46 43 32
7 CD Ronda CD Ronda 30 41 54 29
8 Vélez CF Vélez CF 30 36 55 29
9 At. Malagueño Malagueño 30 50 46 28
10 Adra Adra 30 50 54 28
11 Atl. Cordobes Atl. 30 49 56 26
12 Recreativo Granada Recreativo 30 51 45 25
13 Antequera CF Antequera 30 31 47 22
14 Baeza CF Baeza CF 30 28 65 21
15 Écija Balompié Écija 30 37 59 21
16 Iliturgi CF Iliturgi CF 30 37 79 20
TEMPORADA 1959/1960
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 CD Málaga CD Málaga 30 80 32 45
2 RB Linense RB Linense 30 74 39 42
3 Algeciras CF Algeciras 30 60 26 42
4 CD Linares CD Linares 30 74 36 37
5 Iliturgi CF Iliturgi CF 30 40 39 35
6 Adra Adra 30 60 47 31
7 At. Malagueño Malagueño 30 53 47 30
8 Atl. Cordobes Atl. 30 50 50 29
9 Melilla CF Melilla CF 30 54 56 29
10 Peñarroya Pueblonuevo Peñarroya 30 51 50 28
11 CD Ronda CD Ronda 30 48 52 28
12 Recreativo Granada Recreativo 30 52 60 26
13 Antequera CF Antequera 30 57 79 22
14 Guadix CF Guadix CF 30 39 73 21
15 CD Pozoblanco Pozoblanco 30 45 96 18
16 Puente Genil Puente Genil 30 28 83 17
TEMPORADA 1958/1959
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Adra Adra 30 69 35 45
2 CD Linares CD Linares 30 54 27 40
3 Algeciras CF Algeciras 30 54 43 37
4 At. Malagueño Malagueño 30 75 49 33
5 Atl. Cordobes Atl. 30 77 64 33
6 Antequera CF Antequera 30 64 51 31
7 CD Ronda CD Ronda 30 55 54 31
8 Iliturgi CF Iliturgi CF 30 58 51 29
9 Guadix CF Guadix CF 30 49 67 29
10 Recreativo Granada Recreativo 30 47 48 28
11 Imperio Ceuta Imperio 30 55 58 27
12 RB Linense RB Linense 30 57 73 25
13 Melilla CF Melilla CF 30 51 51 24
14 Puente Genil Puente Genil 30 45 68 24
15 CD Úbeda Viva Úbeda Viva 30 31 60 22
16 UD Lucentina Lucentina 30 31 73 22
TEMPORADA 1957/1958
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 CA Almeria CA Almeria 38 99 37 58
2 Adra Adra 38 91 41 53
3 Iliturgi CF Iliturgi CF 38 103 66 52
4 CD Linares CD Linares 38 89 46 46
5 Puente Genil Puente Genil 38 81 68 45
6 CD Úbeda Viva Úbeda Viva 38 70 56 44
7 At. Malagueño Malagueño 38 88 49 42
8 Guadix CF Guadix CF 38 76 58 41
9 Castro Rio CF Castro 38 60 63 40
10 UD Lucentina Lucentina 38 61 57 39
11 Antequera CF Antequera 38 68 57 38
12 Atl. Cordobes Atl. 38 68 68 36
13 Recreativo Granada Recreativo 38 44 52 36
14 Melilla CF Melilla CF 38 73 76 32
15 Martos CD Martos CD 38 59 69 32
16 CD Ronda CD Ronda 38 54 83 31
17 CD Pozoblanco Pozoblanco 38 50 91 29
18 Atlético Bastetano Atlético 38 48 128 27
19 Villa Del Rio CF Villa 38 38 71 25
20 Peñarroya Pueblonuevo Peñarroya 38 48 132 14
TEMPORADA 1956/1957
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 CD Linares CD Linares 56 122 72 74
2 Iliturgi CF Iliturgi CF 56 144 72 70
3 CD Úbeda Viva Úbeda Viva 56 102 64 68
4 Recreativo Granada Recreativo 56 120 76 66
5 Peñarroya Pueblonuevo Peñarroya 56 136 82 66
6 CA Almeria CA Almeria 56 120 70 64
7 CD Ronda CD Ronda 56 108 96 62
8 Antequera CF Antequera 56 126 84 60
9 Guadix CF Guadix CF 56 114 108 58
10 Lucena Lucena 56 88 138 50
11 CD Pozoblanco Pozoblanco 56 76 172 44
12 Martos CD Martos CD 56 112 160 42
13 At. Malagueño Malagueño 56 76 114 40
14 Atl. Cordobes Atl. 56 84 126 38
15 Atlético Bastetano Atlético 56 60 154 38
16 Motril CF Motril CF 0 0 0 0
TEMPORADA 1955/1956
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 Córdoba CF Córdoba CF 22 52 19 32
2 CA Almeria CA Almeria 22 58 33 28
3 CD Úbeda Viva Úbeda Viva 22 50 31 28
4 CD Pontanés Pontanés 22 51 34 26
5 Iliturgi CF Iliturgi CF 22 48 48 23
6 Motril CF Motril CF 22 43 44 23
7 Antequera CF Antequera 22 54 47 23
8 Recreativo Granada Recreativo 22 32 49 21
9 CD Linares CD Linares 22 44 55 19
10 Martos CD Martos CD 22 32 47 19
11 At. Malagueño Malagueño 22 35 54 14
12 Atlético Bastetano Atlético 22 27 65 8
TEMPORADA 1954/1955
TERCERA DIVISIÓN GRUPO 13
Equipo PJ GF GC Puntos
1 CD Úbeda Viva Úbeda Viva 18 39 28 25
2 Iliturgi CF Iliturgi CF 18 54 36 23
3 CD Linares CD Linares 18 56 32 22
4 CA Almeria CA Almeria 18 45 33 21
5 Martos CD Martos CD 18 38 38 17
6 Motril CF Motril CF 18 37 44 17
7 At. Malagueño Malagueño 18 37 44 16
8 Recreativo Granada Recreativo 18 33 40 16
9 Antequera CF Antequera 18 36 50 13
10 Atlético Bastetano Atlético 18 24 54 10
TEMPORADA 1953/1954
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Real Betis Real Betis 36 77 33 52
2 CD San Alvaro Alvaro 36 85 57 46
3 CD San Fernando Fernando 36 114 57 45
4 Cádiz Cádiz 35 90 52 43
5 SD Ceuta SD Ceuta 36 65 43 42
6 Recreativo Granada Recreativo 36 62 59 38
7 Algeciras CF Algeciras 36 72 53 38
8 CA Almeria CA Almeria 34 65 43 36
9 Martos CD Martos CD 36 75 67 36
10 Recreativo Recreativo 36 49 61 34
11 Iliturgi CF Iliturgi CF 36 63 80 32
12 Utrera Utrera 36 54 87 32
13 Español de Tetuán Español 36 66 76 31
14 Larache Larache 36 64 88 31
15 At. Malagueño Malagueño 36 58 83 30
16 RCD Córdoba Córdoba 36 51 50 29
17 Valdepeñas Valdepeñas 36 45 88 29
18 CD Úbeda Viva Úbeda Viva 36 45 83 27
19 Juventud Sevillana Juventud 35 53 93 27
TEMPORADA 1952/1953
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 30 88 42 43
2 UD España UD España 30 94 43 42
3 Cádiz Cádiz 30 75 48 37
4 Algeciras CF Algeciras 30 102 45 36
5 Recreativo Granada Recreativo 30 58 55 35
6 Real Betis Real Betis 29 72 56 34
7 SD Ceuta SD Ceuta 30 55 47 33
8 Recreativo Recreativo 30 83 66 32
9 Iliturgi CF Iliturgi CF 30 75 75 31
10 CA Almeria CA Almeria 30 53 51 30
11 CD San Fernando Fernando 30 52 77 27
12 Español de Tetuán Español 30 48 74 27
13 Juventud Sevillana Juventud 30 58 86 26
14 CD Úbeda Viva Úbeda Viva 30 52 79 23
15 Utrera Utrera 30 38 91 14
16 At. Malagueño Malagueño 29 32 100 5
TEMPORADA 1951/1952
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Real Jaén Real Jaén 26 84 40 37
2 CA Almeria CA Almeria 26 70 37 35
3 Real Betis Real Betis 26 63 47 32
4 Cádiz Cádiz 26 66 39 31
5 SD Ceuta SD Ceuta 26 59 44 31
6 Recreativo Recreativo 26 54 45 31
7 UD España UD España 26 56 44 30
8 Algeciras CF Algeciras 26 47 48 26
9 CD San Fernando Fernando 26 54 53 23
10 Xerez CD Xerez CD 26 52 71 23
11 Recreativo Granada Recreativo 26 36 54 20
12 Español de Tetuán Español 26 43 70 17
13 Utrera Utrera 26 30 62 16
14 At. Malagueño Malagueño 26 24 84 11
15 Larache Larache 0 0 0 0
16 Maghreb-Al-Aksa Maghreb-Al-A 0 0 0 0
TEMPORADA 1950/1951
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 30 86 41 41
2 Real Betis Real Betis 30 94 54 40
3 Real Jaén Real Jaén 30 73 43 40
4 CA Almeria CA Almeria 30 57 45 37
5 CD San Fernando Fernando 30 72 56 34
6 Xerez CD Xerez CD 30 62 49 32
7 Español de Tetuán Español 30 51 63 30
8 Cádiz Cádiz 30 48 49 30
9 Iliturgi CF Iliturgi CF 30 61 61 28
10 Maghreb-Al-Aksa Maghreb-Al-A 30 51 52 27
11 Utrera Utrera 30 52 69 27
12 At. Malagueño Malagueño 30 49 59 26
13 Recreativo Granada Recreativo 30 36 69 24
14 UD España UD España 30 49 64 23
15 Algeciras CF Algeciras 30 42 71 22
16 Larache Larache 30 35 73 19

  USO DE MEMORIA  
6,191,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5378
Total Execution Time  0.5390
  CADENA URL  
/historico/Granada-B/1961
  GET DATOS  
$_GET['/historico/Granada-B/1961']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0212  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 = 'Granada-B' AND l.year = 1961 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.0132  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=1252 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=1252 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0263  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 = 21529
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1252 AND type_rel = 2
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1252 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  SELECT /*35 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 (1872,1903,2601,2835,6752) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = '1252' AND l.year = 1961 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '1252' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 21529 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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=1252 AND l.year in (1960,1961,1962) 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 (21544) 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 = 21544 AND teamId = 1252
0.0129  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 = '1252' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1252' and rp.type = 4
0.0127  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 = '1252' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 events1961 e ON e.player_id = p.id AND e.league_id = 21529 WHERE rp.league_id = 21529 AND rp.teamId = 1252 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.0129  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 events1961 e ON e.player_id = p.id AND e.league_id = 21529 WHERE rp.league_id = 21529 AND rp.teamId = 1252 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 events1961 e ON e.player_id = p.id AND e.league_id = 21529 WHERE rp.league_id = 21529 AND rp.teamId = 1252 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 1252 AND l.year <= 1961 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0137  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 `tables1961` 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 = 21529 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 `tables1960` 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 = 21516 AND t.round = 30 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 `tables1959` 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 = 21503 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 `tables1958` 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 = 21456 AND t.round = 38 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 `tables1957` 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 = 21487 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 `tables1956` 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 = 21471 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 `tables1955` 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 = 21428 AND t.round = 18 ORDER BY team.conference 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 `tables1954` 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 = 21415 AND t.round = 40 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 `tables1953` 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 = 21401 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 `tables1952` 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 = 21395 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 `tables1951` 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 = 21386 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC