4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sporting de Alcazar
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 UD Almansa UD Almansa 31 62 30 59
4 Manzanares CF Manzanares 30 43 26 57
5 Motilla CF Motilla CF 31 52 30 56
6 Atlético Teresiano Atlético 30 49 45 51
7 AD Campillo AD Campillo 30 59 36 50
8 Sporting de Alcazar Sporting 31 46 37 47
9 UD Carrión UD Carrión 31 38 41 45
10 C.F. Almodovar C.F. 30 32 29 44
11 EFB La Roda EFB La Roda 30 41 47 43
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. 31 34 77 18
18 UD La Fuente Fuente 31 28 66 13
TEMPORADA 2022/2023
PREFERENTE C. LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 CD Cazalegas Cazalegas 34 78 33 80
2 CD Noblejas CD Noblejas 34 63 25 64
3 CD Quintanar de la Orden Quintanar 34 49 41 61
4 CD Madridejos Madridejos 34 57 32 61
5 Villa CD Villa CD 34 57 49 55
6 AD Seseña CF Seseña 34 42 46 52
7 Mora CF Mora CF 34 48 48 49
8 Sporting de Alcazar Sporting 34 60 55 47
9 San Jose Obrero Jose Obrero 34 59 54 42
10 CD Toledo B CD Toledo B 34 36 43 42
11 CD Yuncos CD Yuncos 34 38 53 41
12 CF Alovera CF Alovera 34 38 42 41
13 SP Cabanillas Cabanillas 34 47 49 40
14 AD Hogar Alcarreño Hogar 34 39 53 39
15 CD Azuqueca B Azuqueca 34 38 59 38
16 CF Orgaceño Orgaceño 34 39 52 37
17 CD Bargas CD Bargas 34 39 63 30
18 Balona Conquense Balona 34 40 70 25
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
PREFERENTE C. LA MANCHA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Pedroñeras Pedroñeras 34 67 16 80
2 UD Almansa UD Almansa 34 77 27 79
3 Huracan de Balazote Huracan 34 51 20 71
4 La Gineta La Gineta 34 70 28 68
5 Manzanares CF Manzanares 34 58 41 65
6 Miguelturreño Miguelturre 34 49 54 49
7 AD San Clemente Clemente 34 51 41 46
8 AD Campillo AD Campillo 34 49 46 45
9 Daimiel Daimiel 34 36 40 45
10 UD La Fuente Fuente 34 51 60 45
11 UD Carrión UD Carrión 34 46 52 44
12 Sporting de Alcazar Sporting 34 45 57 40
13 Cultural Valdeganga Cultural 34 51 65 39
14 Miguel Esteban AD Miguel 34 47 58 38
15 Membrilla CF Membrilla 34 29 47 38
16 Hellin CF Hellin CF 34 26 61 25
17 C.D. Caudetano C.D. 34 35 79 23
18 Atletico Puertollano Atletico 34 21 67 19
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
2ª AUTO. CASTILLA-LA MANCHA GRUPO 3
Equipo PJ GF GC Puntos
1 Infantes CF Infantes CF 30 87 35 75
2 Sporting de Alcazar Sporting 30 91 22 71
3 Corraleño CF Corraleño 30 68 36 62
4 Sporting Torrenueva Sporting 30 65 42 51
5 Aldea del Rey Aldea 30 67 49 50
6 Calatrava CF Calatrava 30 81 65 50
7 Poblete UD Poblete UD 30 87 74 50
8 Sport Villarrubia Sport 30 56 32 49
9 Villamayor CF Villamayor 30 60 54 45
10 Pozuelo CF Pozuelo CF 30 54 54 42
11 Atletico Puerta Toledo Atletico 30 54 72 31
12 Santa Cruz UD Santa Cruz 30 50 68 27
13 Cd Piedrabuena Piedrabuena 30 45 96 24
14 La Estrella CD Estrella 30 33 70 18
15 Cinco Casas CDB Cinco Casas 30 41 109 17
16 Deportivo Manchego B Deportivo 30 32 93 15
TEMPORADA 2015/2016
2ª AUTO. CASTILLA-LA MANCHA GRUPO 2
Equipo PJ GF GC Puntos
1 CS Puertollano Puertollano 28 96 10 70
2 Deportivo Manchego CF Deportivo 28 72 20 68
3 Sporting de Alcazar Sporting 28 61 34 55
4 Pozuelo CF Pozuelo CF 27 51 34 53
5 Castillo de Cva Aldea del R Castillo 27 48 30 50
6 Calatrava CF Calatrava 28 51 42 43
7 Sport Villarrubia Sport 28 49 54 42
8 La Estrella CD Estrella 27 45 44 41
9 Atletico Puerta Toledo Atletico 28 42 48 38
10 Cd Piedrabuena Piedrabuena 27 37 40 30
11 Poblete UD Poblete UD 27 39 65 26
12 Infantes CF Infantes CF 28 41 68 26
13 Villamayor CF Villamayor 28 22 78 17
14 Santa Cruz UD Santa Cruz 27 27 66 15
15 Cinco Casas CDB Cinco Casas 28 29 77 9

  USO DE MEMORIA  
5,993,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0991
Total Execution Time  0.1003
  CADENA URL  
/historico/Sporting-Alcazar-Cf-Senior
  GET DATOS  
$_GET['/historico/Sporting-Alcazar-Cf-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66465 AND type_rel = 2
0.0021  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.0022  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.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 = '66465' 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 = '66465' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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=66465 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 (73526) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73526 AND teamId = 66465
0.0039  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 = 73526 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '66465' 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 = '66465' and rp.type = 4
0.0022  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 = '66465' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 66465 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.0027  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 = 66465 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 66465 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 66465 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73526 AND t.round = 31 ORDER BY team.conference ASC,t.position 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 `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 = 68797 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.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 `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.0021  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.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 `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 = 44768 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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.0021  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 = 36170 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 16938 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73526 ORDER BY nameShow LIMIT 100