4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atlético Torremejía
TEMPORADA 2023/2024
2ª REGIONAL EXTREMADURA GRUPO 5
Equipo PJ GF GC Puntos
1 Bienvenida A Bienvenida 20 65 18 45
2 Club Promesas Belenense Club 20 33 11 39
3 Atlético Torremejía Atlético 20 53 22 38
4 CD Berlanga CD Berlanga 20 25 15 37
5 Hernando De Soto A Hernando 20 35 22 34
6 Monesterio Monesterio 20 37 31 34
7 EMD Aceuchal B Aceuchal 20 30 28 26
8 Emérita Augusta Emérita 20 27 25 21
9 Athletic Fregenal Athletic 20 18 30 19
10 UD Fornacense Fornacense 20 35 35 16
11 Oliva 2023 Oliva 2023 20 9 130 3
TEMPORADA 2022/2023
2ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 Emérita Augusta Emérita 20 57 26 42
2 Atlético Torremejía Atlético 20 52 28 42
3 Barbaño Barbaño 20 55 29 35
4 Trujillanos Club de Futbol Trujillanos 20 44 31 35
5 Metelinense A Metelinense 19 38 26 32
6 Don Álvaro B Álvaro 19 39 30 30
7 CD Zarceño CD Zarceño 20 39 39 27
8 CD Almoharín A Almoharín 20 44 43 26
9 Talleres Anglo Talleres 18 27 33 23
10 Madroñera Olimpia Madroñera 20 17 77 10
11 Alange CD Alange CD 20 21 71 7
12 AD Santa Quiteria Santa 0 0 0 0
TEMPORADA 2021/2022
1ª REGIONAL EXTREMADURA GRUPO 4
Equipo PJ GF GC Puntos
1 UD Fuente de Cantos Fuente 22 39 15 48
2 UC La Estrella Estrella 22 42 22 48
3 CD Zafra CD Zafra 22 32 19 41
4 CP Gran Maestre Gran Maestre 22 37 15 39
5 CD San Serván Serván 22 40 29 38
6 Usagre Usagre 22 36 29 35
7 CP Oliva CP Oliva 22 22 16 34
8 EMD Solana EMD Solana 22 33 43 22
9 Santa Marta Santa Marta 22 32 48 20
10 Sport Club La Garrovilla Sport Club. 22 27 49 16
11 Monesterio Monesterio 22 29 46 15
12 Atlético Torremejía Atlético 22 27 65 7
TEMPORADA 2020/2021
1ª REGIONAL EXTREMADURA GRUPO 13
Equipo PJ GF GC Puntos
1 CD Zafra CD Zafra 5 14 2 15
2 CD Nueva Ciudad Nueva Ciudad 5 13 5 12
3 Atlético Torremejía Atlético 5 6 7 5
4 Piornal Piornal 5 8 10 4
5 Cd Talarrubias Talarrubias 5 6 15 4
6 La Albuera-Faesal Albuera-Faes 5 3 11 2
TEMPORADA 2019/2020
1ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Chinato Chinato 25 47 24 57
2 Amanecer Amanecer 25 55 17 50
3 Montehermoso Montehermoso 25 38 29 48
4 CD San Serván Serván 25 49 40 46
5 CD Don Álvaro Álvaro 25 61 38 44
6 AD Valdefuentes Valdefuentes 25 68 39 43
7 Guareña Guareña 25 48 40 38
8 Malpartida Malpartida 24 39 30 37
9 Talayuela Talayuela 24 44 38 34
10 Moraleja Moraleja 24 47 42 33
11 CF Jaraíz CF Jaraíz 24 34 45 29
12 Calamonte UD Calamonte 25 37 51 28
13 Atlético Torremejía Atlético 24 29 55 19
14 Las Hurdes CF Hurdes 25 32 64 19
15 CD Zarceño CD Zarceño 25 33 74 17
16 Piornal Piornal 24 16 51 16
TEMPORADA 2018/2019
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 UD Fuente de Cantos Fuente 30 69 32 70
2 Campanario Campanario 30 63 30 64
3 CD Zafra CD Zafra 30 63 28 63
4 UC La Estrella Estrella 30 66 38 61
5 Villafranca Villafranca 30 64 31 60
6 Guareña Guareña 30 46 50 46
7 CD Don Álvaro Álvaro 30 67 55 44
8 CD Berlanga CD Berlanga 30 54 59 36
9 CP Gran Maestre Gran Maestre 30 51 45 35
10 Gimnástico Don Benito Gimnástico 30 43 58 35
11 Ilipense-Zalamea S. Ilipense-Zal 30 38 59 34
12 Atlético Torremejía Atlético 30 50 73 32
13 UD Frexnense Frexnense 30 23 46 28
14 UD Fornacense Fornacense 30 35 63 28
15 Sp Ribereña Ribereña 30 34 69 25
16 Emérita Augusta Emérita 30 28 58 22
TEMPORADA 2017/2018
1ª REGIONAL EXTREMADURA GRUPO 3
Equipo PJ GF GC Puntos
1 AD Llerenense Llerenense 30 75 27 64
2 Villafranca Villafranca 30 71 29 58
3 UD Frexnense Frexnense 30 52 33 57
4 UC La Estrella Estrella 30 63 38 56
5 UD Fuente de Cantos Fuente 30 66 37 55
6 CD San Serván Serván 30 53 38 51
7 Campanario Campanario 30 46 33 49
8 CD Berlanga CD Berlanga 30 63 52 42
9 Sp Ribereña Ribereña 30 44 48 42
10 Guareña Guareña 30 46 55 40
11 Santa Marta Santa Marta 30 49 62 38
12 Atlético Torremejía Atlético 30 42 55 35
13 Ilipense-Zalamea S. Ilipense-Zal 30 48 70 34
14 Monesterio Monesterio 30 44 84 24
15 Usagre Usagre 30 37 73 22
16 CD Quintana CD Quintana 30 23 88 10
TEMPORADA 2016/2017
2ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 UD Frexnense Frexnense 26 63 33 59
2 Atlético Torremejía Atlético 26 67 34 55
3 CD Zarceño CD Zarceño 26 47 33 48
4 Bienvenida A Bienvenida 26 70 37 47
5 Monesterio Monesterio 25 59 34 45
6 Sporting Malpartida A Sporting 26 70 47 45
7 Castuera Subastacar B Castuera 25 45 38 44
8 Monterrubio CD Monterrubio 26 46 53 35
9 Higuera CF Higuera CF 26 44 47 32
10 Segureña A Segureña A 26 29 57 31
11 Solana UD Solana UD 26 41 51 25
12 Athletic Valle A Athletic 26 30 57 21
13 Cabeza Del Buey Cabeza Buey 26 28 73 15
14 S. Marcos Almendralejo A Marcos 26 39 84 12
TEMPORADA 2015/2016
1ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 Gran Maestre Gran Maestre 21 53 21 46
2 Santa Marta Santa Marta 21 53 28 41
3 Almendralejo A Almendralejo 21 45 37 36
4 UD Frexnense Frexnense 21 39 28 36
5 La Albuera-Faesal Albuera-Faes 21 35 20 34
6 Higuera CF Higuera CF 21 46 47 31
7 Bienvenida A Bienvenida 20 38 41 28
8 Hernando De Soto A Hernando 20 38 38 21
9 Atlético Torremejía Atlético 21 36 51 21
10 Segureña A Segureña A 20 42 45 20
11 Extremadura B Extremadura 10 13 13 17
12 San Jose Promesas B Jose 21 20 89 4
TEMPORADA 2014/2015
1ª REGIONAL EXTREMADURA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Berlanga CD Berlanga 24 87 26 57
2 Usagre Usagre 24 45 25 53
3 Atlético Torremejía Atlético 24 62 39 49
4 CD Don Álvaro Álvaro 24 55 34 42
5 Gran Maestre Gran Maestre 24 40 43 36
6 Azuaga B Azuaga B 24 43 39 35
7 Alfar-Salvatierra A Alfar-Salvat 24 32 55 32
8 UD Frexnense Frexnense 24 42 43 31
9 Saludeño Saludeño 24 45 49 30
10 Higuera CF Higuera CF 24 47 51 28
11 Segureña A Segureña A 24 48 73 23
12 Atletico Romano A Atletico 24 36 45 18
13 Bienvenida A Bienvenida 24 21 81 8

  USO DE MEMORIA  
5,707,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4626
Total Execution Time  0.4647
  CADENA URL  
/historico/Atletico-Torremejia-A-Senior
  GET DATOS  
$_GET['/historico/Atletico-Torremejia-A-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=99335 AND type_rel = 2
0.0136  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 99335 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131  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 (235204,286911) ORDER BY n.cover_points DESC, update_date DESC
0.0129  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 = '99335' ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '99335' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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=99335 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (73799) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73799 AND teamId = 99335
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 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 = 73799 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '99335' 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 = '99335' 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 = '99335' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 73799 WHERE rp.league_id = 73799 AND rp.teamId = 99335 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 73799 WHERE rp.league_id = 73799 AND rp.teamId = 99335 AND (e.action = 4 or e.action = 5) 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 = 73799 WHERE rp.league_id = 73799 AND rp.teamId = 99335 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 99335 AND l.year <= 2024 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 `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 = 73799 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.0127  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 = 69356 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.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 `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 = 63719 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.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 `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 = 59502 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 62275 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 51306 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 44630 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 39346 AND t.round = 30 ORDER BY team.conference 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 `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 = 37076 AND t.round = 26 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 `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 = 16782 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 5199 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC