4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atlético Tomelloso

Atlético Tomelloso

Entrenador: Joselu Sepúlveda

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 18
Equipo PJ GF GC Puntos
1 UB Conquense Conquense 31 51 16 68
2 CD Cazalegas Cazalegas 31 48 30 58
3 CD Quintanar del Rey Quintanar 31 44 28 52
4 CS Puertollano Puertollano 31 44 30 52
5 Villarrubia CF Villarrubia 31 32 28 51
6 UD Yugo Socuéllamos Yugo 31 40 25 51
7 CD Toledo CD Toledo 31 43 25 49
8 CD Tarancon CD Tarancon 31 33 28 42
9 Atlético Albacete Atlético 31 40 44 41
10 CD Azuqueca CD Azuqueca 31 39 39 40
11 CP Villarrobledo Villarrobled 31 27 35 39
12 CD Villacañas Villacañas 31 29 34 36
13 Huracan de Balazote Huracan 31 33 45 36
14 CD Marchamalo Marchamalo 31 24 35 36
15 CF La Solana Solana 31 32 37 35
16 Atlético Tomelloso Atlético 31 23 46 26
17 CD Torrijos CD Torrijos 31 17 39 24
18 AD San Clemente Clemente 31 23 58 16
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 18
Equipo PJ GF GC Puntos
1 CD Manchego Ciudad Real Manchego 30 43 14 62
2 CD Illescas CD Illescas 30 43 22 52
3 CD Quintanar del Rey Quintanar 30 46 28 50
4 CS Puertollano Puertollano 30 39 27 46
5 Villarrubia CF Villarrubia 30 34 25 46
6 UB Conquense Conquense 30 26 15 45
7 CD Villacañas Villacañas 30 36 36 43
8 CD Toledo CD Toledo 30 29 33 41
9 CD Torrijos CD Torrijos 30 36 30 41
10 CD Marchamalo Marchamalo 30 36 37 40
11 CD Tarancon CD Tarancon 30 40 40 38
12 CD Azuqueca CD Azuqueca 30 40 43 38
13 CP Villarrobledo Villarrobled 30 28 32 35
14 CF La Solana Solana 30 25 52 27
15 Atlético Tomelloso Atlético 30 24 54 25
16 CF Talavera B Talavera 30 23 60 11
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 1
Equipo PJ GF GC Puntos
1 AD San Clemente Clemente 22 43 15 47
2 Criptanense Criptanense 22 24 14 40
3 CD Quintanar de la Orden Quintanar 22 35 24 37
4 Atlético Tomelloso Atlético 22 36 25 36
5 San Jose Obrero Jose Obrero 22 33 30 35
6 AD Campillo AD Campillo 22 31 31 31
7 Munera Munera 22 24 27 29
8 CDB Herencia Herencia 22 29 33 28
9 Sporting de Alcazar Sporting 22 21 38 26
10 Membrilla CF Membrilla 22 23 29 25
11 Atlético Ossa CF Atlético 22 28 42 20
12 La Gineta La Gineta 22 24 43 15
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
TERCERA DIVISIÓN GRUPO 18
Equipo PJ GF GC Puntos
1 UD Yugo Socuéllamos Yugo 38 83 16 91
2 Villarrubia CF Villarrubia 38 61 37 75
3 CP Villarrobledo Villarrobled 38 68 42 75
4 CD Toledo CD Toledo 38 68 43 70
5 Atlético Albacete Atlético 38 64 43 63
6 CD Manchego Ciudad Real Manchego 38 39 31 58
7 La Roda CF La Roda CF 38 41 40 55
8 CD Quintanar del Rey Quintanar 38 49 59 51
9 CS Puertollano Puertollano 38 43 47 51
10 CD Azuqueca CD Azuqueca 38 57 55 50
11 CD Madridejos Madridejos 38 39 40 49
12 Atlético Ibañés Atlético 38 55 58 45
13 CF La Solana Solana 38 38 55 45
14 CD Tarancon CD Tarancon 38 56 74 44
15 CD Guadalajara Guadalajara 38 45 67 43
16 Almagro CF Almagro CF 38 40 51 43
17 CD Villacañas Villacañas 38 39 56 42
18 Atlético Tomelloso Atlético 38 39 55 40
19 CD Marchamalo Marchamalo 38 33 65 37
20 Mora CF Mora CF 38 27 50 35
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 18
Equipo PJ GF GC Puntos
1 UB Conquense Conquense 38 69 37 80
2 CP Villarrobledo Villarrobled 38 81 33 79
3 UD Yugo Socuéllamos Yugo 38 80 34 71
4 Villarrubia CF Villarrubia 38 56 39 65
5 Atlético Albacete Atlético 38 58 39 64
6 CD Guadalajara Guadalajara 38 59 40 64
7 Atlético Ibañés Atlético 38 52 42 60
8 Mora CF Mora CF 38 53 45 59
9 CD Manchego Ciudad Real Manchego 38 35 53 53
10 CD Azuqueca CD Azuqueca 38 52 44 51
11 La Roda CF La Roda CF 38 43 49 47
12 CD Marchamalo Marchamalo 38 49 55 44
13 CD Madridejos Madridejos 38 34 62 44
14 CD Villacañas Villacañas 38 44 53 43
15 Atlético Tomelloso Atlético 38 49 54 43
16 CD Quintanar del Rey Quintanar 38 37 56 41
17 Almagro CF Almagro CF 38 33 48 41
18 CD Pedroñeras Pedroñeras 38 35 53 36
19 UD Almansa UD Almansa 38 41 59 34
20 Miguelturreño Miguelturre 38 24 89 18
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 18
Equipo PJ GF GC Puntos
1 CF Talavera CF Talavera 38 89 37 83
2 UB Conquense Conquense 38 74 43 75
3 CP Villarrobledo Villarrobled 38 75 42 70
4 CD Guadalajara Guadalajara 38 64 43 70
5 Villarrubia CF Villarrubia 38 61 38 67
6 UD Almansa UD Almansa 38 68 54 63
7 CD Manchego Ciudad Real Manchego 38 53 40 62
8 CD Quintanar del Rey Quintanar 38 61 52 52
9 CD Azuqueca CD Azuqueca 38 67 57 52
10 CD Madridejos Madridejos 38 43 53 51
11 CD Marchamalo Marchamalo 38 43 49 50
12 Almagro CF Almagro CF 38 44 52 49
13 Atlético Tomelloso Atlético 38 46 53 48
14 Mora CF Mora CF 38 46 66 46
15 Atlético Albacete Atlético 38 49 56 45
16 CD Pedroñeras Pedroñeras 38 46 45 45
17 CD Toledo B CD Toledo B 38 47 61 44
18 CD Illescas CD Illescas 38 56 82 39
19 UD Carrión UD Carrión 38 37 90 26
20 CD Yuncos CD Yuncos 38 24 80 16
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,104,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1088
Total Execution Time  0.1101
  CADENA URL  
/historico/Atletico-Tomelloso
  GET DATOS  
$_GET['/historico/Atletico-Tomelloso']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0028  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 = 'Atletico-Tomelloso' 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=18983 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=18983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 72278
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18983 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 18983 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (128159,251657,579871,637063,637801) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '18983' 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 = '18983' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '18983' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 72278 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=18983 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (72278) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72278 AND teamId = 18983
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 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 = 72278 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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 = '18983' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18983' and rp.type = 4
0.0021  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 = '18983' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 72278 WHERE rp.league_id = 72278 AND rp.teamId = 18983 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.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 = 72278 WHERE rp.league_id = 72278 AND rp.teamId = 18983 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 72278 WHERE rp.league_id = 72278 AND rp.teamId = 18983 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 18983 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 67992 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.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 `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.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 `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 = 58932 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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.0033  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 = 44406 AND t.round = 38 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 `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 = 39042 AND t.round = 38 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 `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 = 33368 AND t.round = 38 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 `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