4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2021
 
Tercera División 2021 G 18
2020/2021

XVIII - Castilla-La Mancha

Tercera División 2021 G 18

  • Atlético Albacete
  • CS Puertollano
  • CD Quintanar del Rey
  • CD Manchego Ciudad Real
  • La Roda CF
  • Huracan de Balazote
  • Atlético Ibañés
  • UD Almansa
  • Manzanares CF
  • CF La Solana
  • Almagro CF
  • CD Marchamalo
  • CD Toledo
  • CD Torrijos
  • CD Guadalajara
  • CD Villacañas
  • CD Tarancon
  • CD Azuqueca
  • CD Illescas
  • UB Conquense
  • CD Madridejos
  • CD Pedroñeras
  • Tercera División:

Clasificación

Equipo PJ GF GC Puntos
1 Atlético Albacete Atlético 20 34 9 45
2 CS Puertollano Puertollano 20 38 13 44
3 CD Quintanar del Rey Quintanar 20 31 16 35
4 CD Manchego Ciudad Real Manchego 20 21 17 29
5 La Roda CF La Roda CF 20 16 22 28
6 Huracan de Balazote Huracan 20 22 27 25
7 Atlético Ibañés Atlético 20 16 21 23
8 UD Almansa UD Almansa 20 19 25 23
9 Manzanares CF Manzanares 20 16 31 18
10 CF La Solana Solana 20 16 29 17
11 Almagro CF Almagro CF 20 14 33 14
12 CD Marchamalo Marchamalo 20 25 10 45
13 CD Toledo CD Toledo 20 31 15 36
14 CD Torrijos CD Torrijos 20 25 18 32
15 CD Guadalajara Guadalajara 20 27 21 31
16 CD Villacañas Villacañas 20 19 16 30
17 CD Tarancon CD Tarancon 20 24 19 29
18 CD Azuqueca CD Azuqueca 20 22 24 27
19 CD Illescas CD Illescas 20 18 21 25
20 UB Conquense Conquense 20 16 24 22
21 CD Madridejos Madridejos 20 14 35 15
22 CD Pedroñeras Pedroñeras 20 12 30 14

  USO DE MEMORIA  
5,594,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.4134
Total Execution Time  0.4161
  CADENA URL  
/tercera2021/grupo18/resumen/22
  GET DATOS  
$_GET['/tercera2021/grupo18/resumen/22']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0145  SELECT type FROM routes WHERE alias = 'tercera2021'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera' AND (l.group_code = 18 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=18 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4 AND type_rel = 3
0.0187  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 4 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (1173626,928772,1016417,1012236,810592) ORDER BY n.cover_points DESC, update_date DESC
0.0146  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58597 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2 FROM `calendars2021` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 58597 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0164  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2021` e INNER JOIN calendars2021 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 22 AND e.real_date IS NOT NULL AND e.league_id = 58597 ORDER BY total DESC LIMIT 100
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-07 12:00:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-07 12:00:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-07 12:00:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-07 12:00:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0254  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58597 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58597 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0323  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58597 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58597 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0165  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 58597 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58597 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0303  SELECT *,(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 = 58597 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