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

III - Cantabria

Tercera División 2020 G 3

  • CD Laredo
  • Gimnástica Torrelavega
  • Rayo Cantabria
  • Tropezón
  • Cayón
  • UM Escobedo
  • CD Bezana
  • SD Barreda Balompié
  • Barquereño
  • CD Guarnizo
  • Siete Villas
  • SD Torina
  • Sámano
  • Selaya
  • SD Textil Escudo
  • SD Solares
  • Ribamontán al Mar
  • CF Vimenor
  • Atlético Albericia
  • UC Cartes
  • Tercera División:

Clasificación

Equipo PJ GF GC Puntos
1 CD Laredo CD Laredo 28 60 24 65
2 Gimnástica Torrelavega Gimnástica 28 58 23 60
3 Rayo Cantabria Rayo 28 54 24 57
4 Tropezón Tropezón 28 55 32 54
5 Cayón Cayón 28 54 23 51
6 UM Escobedo UM Escobedo 28 48 32 49
7 CD Bezana CD Bezana 28 43 27 47
8 SD Barreda Balompié Barreda 28 35 41 44
9 Barquereño Barquereño 28 35 37 36
10 CD Guarnizo CD Guarnizo 28 40 45 35
11 Siete Villas Siete Villas 28 32 31 34
12 SD Torina SD Torina 28 36 42 34
13 Sámano Sámano 28 32 49 33
14 Selaya Selaya 28 21 41 32
15 SD Textil Escudo Textil 28 31 49 27
16 SD Solares SD Solares 28 23 41 26
17 Ribamontán al Mar Ribamontán 28 27 56 25
18 CF Vimenor CF Vimenor 28 30 51 25
19 Atlético Albericia Atlético 28 33 50 25
20 UC Cartes UC Cartes 28 23 52 21

  USO DE MEMORIA  
5,515,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.1335
Total Execution Time  0.1368
  CADENA URL  
/tercera2020/grupo3/resumen/27
  GET DATOS  
$_GET['/tercera2020/grupo3/resumen/27']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0018  SELECT type FROM routes WHERE alias = 'tercera2020'
0.0022  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 = 50271 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 `calendars2020` 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` = 50271 AND c.`round` = 27 ORDER BY shedule ASC LIMIT 200
0.0074  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 `events2020` e INNER JOIN calendars2020 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 = 28 AND e.real_date IS NOT NULL AND e.league_id = 50271 ORDER BY total DESC LIMIT 100
0.0026  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:58:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 15:58:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 15:58:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 15:58:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0039  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 = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  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 events2020 e ON e.player_id = p.id AND e.league_id = 50271 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50271 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.0304  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 events2020 e ON e.player_id = p.id AND e.league_id = 50271 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50271 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0073  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 events2020 e ON e.player_id = p.id AND e.league_id = 50271 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50271 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0050  SELECT *,(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 = 50271 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC