4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del C.F. Almodovar
TEMPORADA 2023/2024
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Pedroñeras Pedroñeras 30 42 16 62
2 Valdepeñas Valdepeñas 30 53 28 61
3 Manzanares CF Manzanares 30 43 26 57
4 UD Almansa UD Almansa 30 56 29 56
5 Motilla CF Motilla CF 30 48 28 53
6 Atlético Teresiano Atlético 30 49 45 51
7 AD Campillo AD Campillo 30 59 36 50
8 Sporting de Alcazar Sporting 30 44 34 47
9 C.F. Almodovar C.F. 30 32 29 44
10 EFB La Roda EFB La Roda 30 41 47 43
11 UD Carrión UD Carrión 30 35 39 42
12 CD Quintanar de la Orden Quintanar 30 44 39 40
13 La Roda CF La Roda CF 30 41 51 34
14 Patrimonio Almadén CF Patrimonio 30 33 58 30
15 Miguelturreño Miguelturre 30 30 48 27
16 Socuéllamos B Socuéllamos 30 29 52 22
17 C.D. Caudetano C.D. 30 32 73 18
18 UD La Fuente Fuente 30 27 60 13
TEMPORADA 2022/2023
1ª AUTO. CASTILLA-LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 C.F. Almodovar C.F. 30 78 23 75
2 Patrimonio Almadén CF Patrimonio 30 62 29 65
3 At. Consuegra Consuegra 30 66 38 63
4 Daimiel Daimiel 30 55 32 59
5 Atletico Puertollano Atletico 30 51 31 47
6 CD Los Yébenes Yébenes 30 47 34 43
7 Bolañego Bolañego 30 59 53 43
8 Pozuelo CF Pozuelo CF 30 54 56 42
9 Calatrava CF Calatrava 30 39 67 39
10 CDB Herencia Herencia 30 48 48 37
11 CD Urda CD Urda 30 46 50 34
12 Miguel Esteban AD Miguel 30 33 46 32
13 Atletico Cervantino Atletico 30 42 60 29
14 Ciudad Real CF Ciudad Real 30 32 50 28
15 CF Villartense Villartense 30 35 68 20
16 Calzada CDB Calzada CDB 30 27 89 19
TEMPORADA 2021/2022
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 CF La Solana Solana 33 77 30 74
2 Atlético Tomelloso Atlético 34 50 36 63
3 Manzanares CF Manzanares 34 57 27 62
4 CD Pedroñeras Pedroñeras 34 57 37 61
5 Valdepeñas Valdepeñas 34 67 48 57
6 AD Campillo AD Campillo 34 53 42 52
7 UD Carrión UD Carrión 34 59 47 49
8 CD Quintanar de la Orden Quintanar 34 48 34 48
9 Criptanense Criptanense 34 45 34 48
10 Sporting de Alcazar Sporting 34 37 48 45
11 Atlético Ibañés Atlético 34 50 41 44
12 UD La Fuente Fuente 34 59 58 44
13 EFB La Roda EFB La Roda 34 44 47 42
14 CDB Herencia Herencia 34 49 53 40
15 C.F. Almodovar C.F. 34 37 53 37
16 Munera Munera 34 52 76 34
17 C.D. Caudetano C.D. 33 31 98 27
18 Almagro CF Almagro CF 34 26 89 16
TEMPORADA 2020/2021
PREFERENTE C. LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 Miguelturreño Miguelturre 24 39 14 49
2 Mora CF Mora CF 24 46 19 48
3 UD Carrión UD Carrión 24 42 24 43
4 C.F. Almodovar C.F. 24 28 18 43
5 CD Noblejas CD Noblejas 24 37 23 40
6 UD La Fuente Fuente 24 27 17 36
7 CF Orgaceño Orgaceño 24 34 35 34
8 CD Toledo B CD Toledo B 24 27 26 32
9 Valdepeñas Valdepeñas 24 29 45 28
10 CD Sonseca CD Sonseca 24 27 34 27
11 At. Consuegra Consuegra 24 23 43 21
12 Daimiel Daimiel 24 15 42 17
13 CD Urda CD Urda 24 22 56 16
TEMPORADA 2019/2020
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 Manzanares CF Manzanares 26 47 7 65
2 Huracan de Balazote Huracan 26 43 17 56
3 AD San Clemente Clemente 26 48 23 54
4 CD Quintanar de la Orden Quintanar 26 35 21 46
5 La Gineta La Gineta 26 37 24 42
6 UD Carrión UD Carrión 26 23 21 37
7 Miguelturreño Miguelturre 26 23 23 37
8 Atlético Tomelloso Atlético 26 26 23 36
9 AD Campillo AD Campillo 26 32 32 34
10 San Jose Obrero Jose Obrero 26 31 37 33
11 Criptanense Criptanense 26 28 39 32
12 UD La Fuente Fuente 26 32 41 30
13 Sporting de Alcazar Sporting 26 25 29 29
14 C.F. Almodovar C.F. 26 34 44 29
15 Membrilla CF Membrilla 26 25 36 29
16 Daimiel Daimiel 26 20 30 21
17 Atlético Tarazona Atlético 26 18 41 21
18 Cultural Valdeganga Cultural 26 23 62 21
TEMPORADA 2018/2019
1ª AUTO. CASTILLA-LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 Criptanense Criptanense 30 76 28 69
2 C.F. Almodovar C.F. 30 64 30 60
3 CDB Herencia Herencia 30 74 35 59
4 Porzuna CDB Porzuna CDB 30 65 33 57
5 Valdepeñas Valdepeñas 30 71 37 55
6 Atco. Pedro Muñoz Atco. Pedro 29 61 32 54
7 Atlético Teresiano Atlético 30 49 27 50
8 Atletico Cervantino Atletico 30 42 30 41
9 Almoradiel Almoradiel 30 51 53 37
10 Valenzuela AD Valenzuela 30 45 55 35
11 Las Mesas Las Mesas 30 33 50 32
12 Socuéllamos B Socuéllamos 30 37 45 30
13 Infantes CF Infantes CF 30 36 77 26
14 Calatrava CF Calatrava 29 36 85 24
15 Sporting Torrenueva Sporting 30 29 83 23
16 Ascensores Eninter Los Llan Ascensores 30 19 88 12
TEMPORADA 2017/2018
1ª AUTO. CASTILLA-LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 Sporting de Alcazar Sporting 30 61 32 61
2 Membrilla CF Membrilla 30 57 25 58
3 Atlético Teresiano Atlético 30 66 40 57
4 Criptanense Criptanense 30 52 30 53
5 At. Consuegra Consuegra 30 50 34 53
6 C.F. Almodovar C.F. 30 50 46 49
7 CDB Herencia Herencia 30 43 35 47
8 Deportivo Manchego CF Deportivo 30 44 39 43
9 CD Los Yébenes Yébenes 30 43 35 41
10 Las Mesas Las Mesas 30 53 44 39
11 Sporting Torrenueva Sporting 30 33 53 36
12 Ascensores Eninter Los Llan Ascensores 30 23 43 33
13 Valenzuela AD Valenzuela 30 42 60 29
14 Infantes CF Infantes CF 30 37 61 27
15 Calzada CDB Calzada CDB 30 35 69 26
16 Castillo de Cva Aldea del R Castillo 30 22 65 22
TEMPORADA 2016/2017
1ª AUTO. CASTILLA-LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 CS Puertollano Puertollano 30 96 20 76
2 Patrimonio Almadén CF Patrimonio 30 56 40 55
3 Criptanense Criptanense 30 58 33 53
4 CD Urda CD Urda 29 39 33 53
5 C.F. Almodovar C.F. 30 58 50 47
6 Bolañego Bolañego 30 50 43 46
7 Valenzuela AD Valenzuela 30 47 46 43
8 Atlético Teresiano Atlético 30 44 35 42
9 Membrilla CF Membrilla 30 37 38 41
10 Deportivo Manchego CF Deportivo 30 59 56 40
11 At. Consuegra Consuegra 30 42 40 36
12 CDB Herencia Herencia 30 41 48 36
13 Calzada CDB Calzada CDB 30 39 54 36
14 CD Los Yébenes Yébenes 30 35 53 36
15 Villafranca Villafranca 30 44 94 16
16 Las Casas CD Casas 29 23 85 9
TEMPORADA 2015/2016
1ª AUTO. CASTILLA-LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 Porzuna CDB Porzuna CDB 30 49 25 65
2 UD La Fuente Fuente 30 72 49 57
3 Atlético Teresiano Atlético 30 73 49 53
4 Criptanense Criptanense 30 66 45 52
5 Valenzuela AD Valenzuela 30 50 43 49
6 Patrimonio Almadén CF Patrimonio 30 51 40 48
7 C.F. Almodovar C.F. 30 53 44 45
8 CD Urda CD Urda 30 56 47 44
9 Bolañego Bolañego 30 47 42 42
10 CDB Herencia Herencia 30 50 51 42
11 Membrilla CF Membrilla 30 37 41 38
12 Las Casas CD Casas 30 50 62 37
13 Fuencaliente Asociacion Fuencaliente 30 46 68 33
14 Calzada CDB Calzada CDB 30 34 54 29
15 Sporting Torrenueva Sporting 30 37 78 27
16 Corraleño CF Corraleño 30 34 67 22
TEMPORADA 2014/2015
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 San Jose Obrero Jose Obrero 33 79 40 71
2 Munera Munera 33 73 27 70
3 CF La Solana Solana 33 78 38 70
4 Atlético Tomelloso Atlético 34 86 35 65
5 U.B. Conquense B U.B. 33 52 40 57
6 UD Tobarra UD Tobarra 33 49 34 54
7 Motilla CF Motilla CF 33 54 40 53
8 UD Carrión UD Carrión 33 46 34 51
9 CD Quintanar de la Orden Quintanar 33 50 48 45
10 Cd Miguelturreño Miguelturre 33 39 51 39
11 U.D. Alpera U.D. Alpera 33 50 61 37
12 C.D.B.F. Cervantes C.D.B.F. 33 38 54 35
13 C.F. Almodovar C.F. 33 41 62 35
14 C.D. Caudetano C.D. 33 36 66 35
15 EF Zona 5 EF Zona 5 33 31 64 35
16 CD Mota Del Cuervo Mota Cuervo 32 28 63 20
17 Cd Piedrabuena Piedrabuena 32 27 77 19
18 Tomelloso Tomelloso 18 21 44 12

  USO DE MEMORIA  
6,136,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1297
Total Execution Time  0.1313
  CADENA URL  
/historico/Cf-Almodovar
  GET DATOS  
$_GET['/historico/Cf-Almodovar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0030  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 = 'Cf-Almodovar' 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.0018  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=18977 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=18977 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0053  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 = 73526
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18977 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 86 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1304399,1199941,1184917,1070918,701719) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = '18977' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '18977' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '18977' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 73526 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=18977 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73526,69450) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73526 AND teamId = 18977
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 69450 AND teamId = 18977
0.0021  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 = '18977' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0026  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18977' and rp.type = 4
0.0020  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 = '18977' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040  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 = 73526 WHERE rp.league_id = 73526 AND rp.teamId = 18977 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.0040  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 = 73526 WHERE rp.league_id = 73526 AND rp.teamId = 18977 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 73526 WHERE rp.league_id = 73526 AND rp.teamId = 18977 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042  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 = 18977 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0028  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 = 69450 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.0026  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 = 63675 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.0027  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 = 58933 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 51208 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 45378 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 39793 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 34566 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 16791 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 4077 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC